Accounts Payable Trial Balance

The Accounts Payable Trial Balance shows you a complete list of all unpaid invoices on the system that has been transferred to the General Ledger, irrespective of whether they are due for payment or not. This report will assist with the month end reconciliation process.

This is a period end report. This represents your opening and closing AP Trial Balance.

The closing value per AP control account in this trial Balance should match with the corresponding Account in the General Ledger Trial Balance.

If it does not, then there is an issue.

Following reports can be run in the accounting period that is being in question to find the potential problem.

Posted Invoices Register

Posted Payments Register

The Opening Account Payable Trail Balance (AP TB)

+ The Posted Invoice

- The Posted payments

= The Closing AP TB

This is a key formulat to identify the source of potential problems.

Note that in above:

The Aging Invoice Report Total should = The AP Trial Balance Total (from above for posted transactions) + The Total of Swept (Unposted Transactions)

You may wish to perform this reconciliation as a further month end reconciliation check.