Skip to main content

Reconciliation Reports

The Payables and Receivables Reconciliation reports show total amounts you owe and are due you, respectively. These reports also show out of balance amounts by comparing the transaction totals with the values of the accounts in the account list. They are reports that you run as of a specific date and only show information up until that date.

The value of the Inventory Asset account(s) should equal the total of the Current Value of all the items associated with the Inventory Asset account(s). The Inventory Value Reconciliation report compares these two values, and if they don't match, they are Out of Balance. Check the Inventory Reconciliation Out of Balance FAQ if an out of balance situation exists.

For the same given report date, your Balance Sheet, Accounts Payable account value should match the Total Due field on your Payables Reconciliation Report, and your Balance Sheet, Accounts Receivable account value should match the amount in the Total Due field on your Receivables Reconciliation Report. (If you are using the multi-currency feature, you'll need to indicate a currency code in order to display the total due.) If there is an out of balance amount, display the Payables or Receivables Reconciliation Exception report (Reports > Index to Reports > Accounts > Exceptions > Payables Reconciliation or Reports > Index to Reports > Accounts > Exceptions > Receivables Reconciliation). AccountEdge will report transactions that are possibly causing the out of balance situation. You can also check the Accounts Payable or Accounts Receivable Out of Balance FAQ for troubleshooting tips.

Why Don't My Totals Match? (Multi-Currency)

If you are using the AccountEdge multi-currency feature, you must filter the report for one selected currency at a time in order to get a receivable or payable total, and an out of balance indication displayed and printed on the report. The reason is that each currency is linked to a different receivable or payable linked account.

Did this answer your question?