Reconciliation Tool  

Accounts Payable Reconciliation
Step Action Note
1. Post

Ensure all entries are posted.

AP Post Entries

Click  the AP Post Entries link and post.

GL Post Entries

Click the link; then select Post Entries under the Task menu.

Note:   Review posting journals for rejecting entries that must be corrected.

2. Data Verification

 

Open Invoices

A) Select the Open invoices report and make a note of the balance and the open retainage.

 

Open Invoices w/Cut-off Date

B) Select the open invoices w/cut-off date using a future date in the cut-off date box and make a note of the balance and the open retainage.

C) Compare the balance and the open retainage on each report to determine if there is a difference.  

If the difference is zero continue with step 3.  If the difference is not zero, your master file totals do not equal your transaction totals and you may have data corruption.  You must correct this before you continue.

3. AP Summary Reconciliation

 

AP Summary

 

Retainage Summary

 

View the summary report  to determine if your AP accounts and applicable RP accounts balance to AP and GL. 

 
If the accounts are in balance skip to step 7 to print period end reports, otherwise 
    continue with step 4. 
4. Detail

Batch Detail: Identify which batches are out of balance

Totals by Batch

 

Retainage Totals by Batch

This step allows you to perform a more detailed analysis of your transactions by reviewing batches to determine if any are out-of-balance in relation to GL for both the payable and. of applicable, retainage payable accounts. This report offers drill-down capability into each batch to see the transaction detail.

Note :  Invoices entered at the same time as a manual check or a quick check with a check date and an accounting date in the same period will cause the appearance of an out of balance situation.  The zero summary entries to Accounts Payable will be on the Accounts Payable Batch report and not on the General Ledger Batch report.

 
5. Common causes if out of balance

Unexplained entries

Payable Account Entries

Use this report to identify entries made to payable accounts that did not originate in Accounts Payable. 

How to correct:

Reverse the original transaction and enter the correction in AP.

Entry spanning two accounting periods

Change in Void Accounting Date

Select this report to determine if a check has been voided with a new date. This may cause a temporary out of balance.

Note : For invoices entered at the same time as a manual check or a quick check with a check date and an accounting date in the same period, the AP entries will be listed for AP but not for GL.

How to correct:

Reverse the original transaction and enter the correction in AP.

Unposted Transactions

Unposted AP transactions in GL

When AP transactions are not posted or rejected in GL an out-of-balance situation results. This report helps determine if these transactions are the cause of an out of balance situation.

How to correct:

Checks:

Voiding AP checks

Invoices:

If the rejected entry is for a future period:

Change the invoice and remove future transactions

If the rejected entry is for a prior period:

Posted entries to a closed General Ledger period

If the rejected entry is for a recurring invoice:

Unable to post recurring entries to a future period when the fiscal entity level is data folder

6. Repeat

Repeat steps 3, 4, and 5 as needed for each account and/or batch that is out of balance

 

 

7. Period End Reports

 

Period End Report for AP Accounts

 

Period End Report for RP Accounts

Print common period end reports, such as the Period End Report AP Accounts and the Period End Report for Retainage Payable Accounts.