How to find the difference when the A/P Report and the Account Balance Report do not agree
This article applies only to accrual basis customers
There are two reports you need to reconcile A/P:
- The Account Balance Report (Reports → Accounts → Account Balance Report).
- The A/P Aging Report (Reports → Transactions → A/P Aging Detail by Period).
The two reports should agree!
Troubleshooting tips if they do not agree:
How much is the difference? When did the problem start?
- It's easier to search for the problem if you can narrow down when the difference was created. You could use an spreadsheet to help you. We suggest that you run the two reports as of the beginning of the year to see if the problem is in prior years. If it is in a prior year, work backwards. If the problem developed in the current year, run the reports by quarter to narrow down the time frame. Below is an example - the problem began in the fourth quarter in July. By running monthly reports we determined which month was the culprit. Once we narrowed down the month, we can then look at the transactions in that month.
- Are there journal entries in the GL AP account? If transactions are NOT recorded in Bills, but are entered in the general ledger the two reports will be out of balance.