The aged debtors report and the balance on the customer's account normally match.

When the two figures differ, use the steps below to find and fix the difference.

The customer balance includes every invoice, payment, and credit note on the account, whether they're allocated or not. It also includes transactions dated in the future. The aged debtors report only includes transactions up to the date you select when you run it.

What you need to check

• Check the date on the aged debtors report, as any transactions dated after it won't appear
• Check that every invoice marked as outstanding on the report is also outstanding on the customer record
• If an invoice shows as paid on the customer activity but outstanding on the report, the payment falls after the report date. Change the date on the aged debtors report to cover the payment date
• If the customer activity still shows outstanding invoices, check for payments on account or credit notes, then allocate them to those invoices
• Check that every payment on the customer activity uses the type Customer Receipt. Transactions with the type Other Receipt don't appear on the Aged Debtors report