Accounts Payable Reconciliation |
|
|
|
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. |
|
|
|
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.
|
|
|
|
|
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:
In the Knowledgebase type article number KB148470 in the Search for a
Solution section for steps on how to void checks
.
Invoices:
In the Knowledgebase type article number KB190241in the Search for a
Solution
section, if the rejected entry is for a future period. In the Knowledgebase
type article number KB84177 in the Search for a Solution
section, if the rejected entry is for a prior period. In the Knowledgebase
type article number KB108188 in the Search for a Solution
section, if the rejected entry is for a recurring invoice. |
|
|
Repeat steps 3, 4, and 5 as needed for each account and/or batch that is out of
balance |
|
|
|
|
|
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.
|
|
|