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:
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
|
|
|
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.
|
|
|