Difference between revisions of "Reconcile Company Payables"

From Agency Systems Wiki
Jump to navigation Jump to search
(initial save)
 
(11 intermediate revisions by 2 users not shown)
Line 8: Line 8:
 
<td>
 
<td>
 
<ul>
 
<ul>
 +
<li>[[Adjust (disambiguation)#Invoice_Adjustment|Adjust Invoice]]</li>
 
<li>[[Company Profile]]</li>
 
<li>[[Company Profile]]</li>
 +
<li>[[Reconcile (disambiguation)|Reconcile (All)]]</li>
 
<li>[[Reconcile Payables Batch]]</li>
 
<li>[[Reconcile Payables Batch]]</li>
 
<li>[[Training 6: Accounting]]</li>
 
<li>[[Training 6: Accounting]]</li>
Line 27: Line 29:
 
</tr>
 
</tr>
 
</table>
 
</table>
{{#ev:youtube|9wk8ctiJn4Q|300|right|Reconcile Payables}}
 
  
 
The Reconcile Company Payables interface is used to create [[General Ledger Profile|GL-2110]] [[Company Profile|company]] payable [[:Category:Checks|checks]] against [[:Category:Agency Bill|Agency Bill invoices]].
 
The Reconcile Company Payables interface is used to create [[General Ledger Profile|GL-2110]] [[Company Profile|company]] payable [[:Category:Checks|checks]] against [[:Category:Agency Bill|Agency Bill invoices]].
  
 
Access to reconcile company payables requires the following security:
 
Access to reconcile company payables requires the following security:
*Other -> [[Security System]] -> AP -> Reconcile Payables -> View and Entry.
+
*Setup-> [[Security System]] -> AP -> Reconcile Payables -> View and Entry.
*Other -> [[Security System]] -> AP -> Check Transaction -> Entry.
+
*Setup -> [[Security System]] -> AP -> Check Transaction -> Entry.
*Other -> [[Security System]] -> Profiles -> Company -> View.
+
*Setup -> [[Security System]] -> Profiles -> Company -> View.
 +
 
 +
== Frequently Asked Questions (FAQ) ==
 +
*[[Talk:Reconcile_Company_Payables#How_can_I_hide_ignored_invoices_from_a_reconcile_report.3F|How can I hide ignored invoices from a reconcile report?]]
  
 
== Start a Company Payable Reconcile ==
 
== Start a Company Payable Reconcile ==
#Select '''AP -> Reconcile Payables'''. ''(To process company or [[Reconcile Producer Payables|producer payables]] '''in a batch''', see [[Reconcile Payables Batch]].)''
+
#Select '''Company -> Reconcile Company Payables (Agency Bill)'''. ''(To process company or [[Reconcile Producer Payables|producer payables]] '''in a batch''', see [[Reconcile Payables Batch]].)''
 
#Enter the [[Company Profile|Company Code]].  
 
#Enter the [[Company Profile|Company Code]].  
 
#Select the [[:Category:Agency Bill|Agency Bill invoice]] '''Start Date''' and '''End Date'''.   
 
#Select the [[:Category:Agency Bill|Agency Bill invoice]] '''Start Date''' and '''End Date'''.   
Line 44: Line 48:
 
#:[[File:Ap-reccomp.png]]
 
#:[[File:Ap-reccomp.png]]
  
 +
=== Start a Reconcile: Additional Options ===
 +
The additional (optional) items below are available by selecting the '''Other''' button.
 
==== Change Default Date Range ====
 
==== Change Default Date Range ====
#Select '''AP -> Reconcile Payables'''.
+
#Select '''Company -> Reconcile Company Payables (Agency Bill)'''.
 
#Select '''Other -> Change Default Dates...'''.
 
#Select '''Other -> Change Default Dates...'''.
 
#:[[File:Ap-rec-changedefault.png]]
 
#:[[File:Ap-rec-changedefault.png]]
Line 53: Line 59:
 
==== Include a Department Filter ====
 
==== Include a Department Filter ====
 
The list of invoices can be limited by [[Department Profile|Department Code]], commonly used for agencies with multiple locations.
 
The list of invoices can be limited by [[Department Profile|Department Code]], commonly used for agencies with multiple locations.
 +
 +
Select '''Company -> Reconcile Company Payables (Agency Bill)'''.  Next, select ''' Other -> Show Department Filter'''.
  
Select '''AP -> Reconcile Payables'''.  Next, select ''' Other -> Show Department Filter'''.
+
The department code entry field will display below the End Date.
 
 
The department code entry field will display below the End Date.  
 
  
 
== Process a Company Payable Reconcile ==
 
== Process a Company Payable Reconcile ==
Line 79: Line 85:
 
#:[[File:Ap-rec-reccomp-list-paydetails-transdetails.png]]
 
#:[[File:Ap-rec-reccomp-list-paydetails-transdetails.png]]
 
#'''Optionally''' select '''Transfer Earned Commission''' to automatically transfer any earned commission between the [[Bank Profile|trust and operating bank accounts]]. ''(Do not select if paying beginning balance invoices)''.
 
#'''Optionally''' select '''Transfer Earned Commission''' to automatically transfer any earned commission between the [[Bank Profile|trust and operating bank accounts]]. ''(Do not select if paying beginning balance invoices)''.
#:'''See: [[Bank Transfer#Setup Bank Transfer General Ledger Account|Setup bank transfer general ledger account]] select or create the [[General Ledger Profile|bank transfer GL profile]])'''.  
+
#:'''See: [[Bank Transfer#Setup Bank Transfer General Ledger Account|Setup bank transfer general ledger account]] or select the existing [[General Ledger Profile|bank transfer GL profile]])'''.  
 
#:[[File:Ap-rec-reccomp-list-paydetails-transdetails-selectearned.png]] [[File:Ap-rec-reccomp-list-paydetails-transdetails-earned.png]]  
 
#:[[File:Ap-rec-reccomp-list-paydetails-transdetails-selectearned.png]] [[File:Ap-rec-reccomp-list-paydetails-transdetails-earned.png]]  
 
#Select '''OK''' when finished.
 
#Select '''OK''' when finished.
Line 96: Line 102:
  
 
=== Additional Options ===
 
=== Additional Options ===
There are many additional options available in either the primary '''Right-Click Menu''', or by selecting the window buttons.
+
<!--<table class="infobox" cellspacing="5" style="background-color: #FFFFFF; width:27em; text-align:left; border-spacing: 2px; line-height:1.5em;">
 +
<tr>
 +
    <td>[[File:Ap-rec-reccomp-list-rightclick.png]]</td>
 +
</tr>
 +
</table>-->
 +
There are many additional options available in either the primary reconcile '''Right-Click Menu''', or by selecting the reconcile window buttons.
 
*'''Add Invoices''': Search for additional invoices by date, or invoice number to add to the existing reconcile window.  This option can add fully paid invoices.  
 
*'''Add Invoices''': Search for additional invoices by date, or invoice number to add to the existing reconcile window.  This option can add fully paid invoices.  
 
*'''Adjust This Invoice''': See: [[Invoice:_Adjust_Premium_and_Commission_on_Existing_Invoices_in_Closed_GL_Periods#Adjust_an_Invoice_Using_Reconcile|Adjust an Invoice Using Reconcile]]
 
*'''Adjust This Invoice''': See: [[Invoice:_Adjust_Premium_and_Commission_on_Existing_Invoices_in_Closed_GL_Periods#Adjust_an_Invoice_Using_Reconcile|Adjust an Invoice Using Reconcile]]
Line 102: Line 113:
 
*'''Ignore This Invoice''': Ignored invoices are not paid when [[#Step 1: Mark Invoices To pay|selecting "pay all" options]].  After selecting invoices to ignore, optionally select the bottom checkbox to '''Hide invoices that are being ignored'''.  
 
*'''Ignore This Invoice''': Ignored invoices are not paid when [[#Step 1: Mark Invoices To pay|selecting "pay all" options]].  After selecting invoices to ignore, optionally select the bottom checkbox to '''Hide invoices that are being ignored'''.  
 
*'''Save And Exit''': Saves the pending reconcile as a reconcile in progress without posting any changes. See [[#Resume or Cancel a Reconcile in Progress|the section below to resume or cancel]] a saved reconcile in progress.  
 
*'''Save And Exit''': Saves the pending reconcile as a reconcile in progress without posting any changes. See [[#Resume or Cancel a Reconcile in Progress|the section below to resume or cancel]] a saved reconcile in progress.  
*'''Window: Red X''': Exit without saving any changes.  
+
*'''Window: Red X''': Exit without saving any changes.
 +
 
 +
[[File:Ap-rec-reccomp-list-rightclick.png]]
  
 
== Resume or Cancel a Reconcile in Progress ==
 
== Resume or Cancel a Reconcile in Progress ==
 
If a pending reconcile is saved, it can either be resumed exactly where the operator left off, or cancelled to start the reconcile process at the beginning.  
 
If a pending reconcile is saved, it can either be resumed exactly where the operator left off, or cancelled to start the reconcile process at the beginning.  
#Select '''AP -> Reconcile Payables'''.
+
#Select '''Company -> Reconcile Company Payables (Agency Bill)'''.
 
#Select '''Load a Reconcile in Progress'''.
 
#Select '''Load a Reconcile in Progress'''.
 
#Highlight the previously saved reconcile and select '''OK''' to resume, or '''Cancel This Item''' to remove the saved reconcile.  
 
#Highlight the previously saved reconcile and select '''OK''' to resume, or '''Cancel This Item''' to remove the saved reconcile.  
Line 115: Line 128:
 
== Review Reconcile Archive (Completed) ==
 
== Review Reconcile Archive (Completed) ==
 
Previously processed reconciles can be viewed using the reconcile archive report, or by viewing the automatically generated .PDF from the '''Company Tab -> Attachments Band'''.  
 
Previously processed reconciles can be viewed using the reconcile archive report, or by viewing the automatically generated .PDF from the '''Company Tab -> Attachments Band'''.  
#Select '''AP -> Reconcile Payables'''.
+
#Select '''Company -> Reconcile Company Payables (Agency Bill)'''.
 
#Select '''Other -> View Reconcile Archive...'''.  
 
#Select '''Other -> View Reconcile Archive...'''.  
#Select the previously processed reconcile from the list, and select '''Report'''.
+
#Select the previously processed reconcile from the list, and select '''Report''' or '''Excel''' for a spreadsheet
 
#:[[File:Ap-rec-reccomp-viewarchive-completed.png]]
 
#:[[File:Ap-rec-reccomp-viewarchive-completed.png]]

Latest revision as of 19:23, 19 July 2021

Related Pages
Related Categories

The Reconcile Company Payables interface is used to create GL-2110 company payable checks against Agency Bill invoices.

Access to reconcile company payables requires the following security:

Frequently Asked Questions (FAQ)

Start a Company Payable Reconcile

  1. Select Company -> Reconcile Company Payables (Agency Bill). (To process company or producer payables in a batch, see Reconcile Payables Batch.)
  2. Enter the Company Code.
  3. Select the Agency Bill invoice Start Date and End Date.
    (Invoices before or after the date range will not be included in the reconcile payables results. See change default date range below to modify the default values.)
  4. Select OK.
    Ap-reccomp.png

Start a Reconcile: Additional Options

The additional (optional) items below are available by selecting the Other button.

Change Default Date Range

  1. Select Company -> Reconcile Company Payables (Agency Bill).
  2. Select Other -> Change Default Dates....
    Ap-rec-changedefault.png
  3. Select a different start and end date method, and select OK. (When prompted restart Agency Systems for the default date changes to take affect.)
    Ap-rec-changedefault-defaults.png

Include a Department Filter

The list of invoices can be limited by Department Code, commonly used for agencies with multiple locations.

Select Company -> Reconcile Company Payables (Agency Bill). Next, select Other -> Show Department Filter.

The department code entry field will display below the End Date.

Process a Company Payable Reconcile

After starting a company payable reconcile, a list of matching invoices will be provided.

Ap-rec-reccomp-list.png

Step 1: Mark Invoices To Pay

Right-Click to view the list of available actions.

  • To pay individual invoices, select Pay This Invoice In Full/Part/Trust Amount. (Trust Amount = Only pay the percentage paid by the client.)
  • To pay all listed invoices, select Pay All In Full/Trust Amount.

Ap-rec-reccomp-list-payoptions.png

Step 2: Verify Payment Details and Earned Income Transfer

  1. Select Payment Details... after marking invoices to pay.
    Ap-rec-reccomp-list-paydetails.png
  2. The Transaction Details window will display.
    • Enter the bank code. (The code defaults from the agency profile.)
    • Verify the Check Number, Check Date, and Check Type.
    • Enter a short Description.
    Ap-rec-reccomp-list-paydetails-transdetails.png
  3. Optionally select Transfer Earned Commission to automatically transfer any earned commission between the trust and operating bank accounts. (Do not select if paying beginning balance invoices).
    See: Setup bank transfer general ledger account or select the existing bank transfer GL profile).
    Ap-rec-reccomp-list-paydetails-transdetails-selectearned.png Ap-rec-reccomp-list-paydetails-transdetails-earned.png
  4. Select OK when finished.

Step 3: Perform the Reconciliation

After marking the invoices to pay, and entering the payment details, verify the total "paying" amount displayed at the bottom of the reconcile window.

Ap-rec-reccomp-list-totalpaying.png

Once verified, select Perform Reconciliation to execute the following:

  • Create a check transaction for the total payment amount.
  • Apply the check payment to each of the marked invoices.
  • Create a .PDF report attached to the company tab.
  • Transfer any Earned Commission if selected.
  • Prompt to print the company payable check if configured as Check Type -> Regular.

Additional Options

There are many additional options available in either the primary reconcile Right-Click Menu, or by selecting the reconcile window buttons.

  • Add Invoices: Search for additional invoices by date, or invoice number to add to the existing reconcile window. This option can add fully paid invoices.
  • Adjust This Invoice: See: Adjust an Invoice Using Reconcile
  • Export to Excel: Creates and opens a Microsoft Excel spreadsheet of the currently displayed list of invoices.
  • Ignore This Invoice: Ignored invoices are not paid when selecting "pay all" options. After selecting invoices to ignore, optionally select the bottom checkbox to Hide invoices that are being ignored.
  • Save And Exit: Saves the pending reconcile as a reconcile in progress without posting any changes. See the section below to resume or cancel a saved reconcile in progress.
  • Window: Red X: Exit without saving any changes.

Ap-rec-reccomp-list-rightclick.png

Resume or Cancel a Reconcile in Progress

If a pending reconcile is saved, it can either be resumed exactly where the operator left off, or cancelled to start the reconcile process at the beginning.

  1. Select Company -> Reconcile Company Payables (Agency Bill).
  2. Select Load a Reconcile in Progress.
  3. Highlight the previously saved reconcile and select OK to resume, or Cancel This Item to remove the saved reconcile.
    Ap-rec-reccomp-loadinprogress.png

After a reconcile in progress is cancelled, the operator can now start a new company payable reconcile for the same company.

Review Reconcile Archive (Completed)

Previously processed reconciles can be viewed using the reconcile archive report, or by viewing the automatically generated .PDF from the Company Tab -> Attachments Band.

  1. Select Company -> Reconcile Company Payables (Agency Bill).
  2. Select Other -> View Reconcile Archive....
  3. Select the previously processed reconcile from the list, and select Report or Excel for a spreadsheet
    Ap-rec-reccomp-viewarchive-completed.png