The customer’s balance and the aged debtors report don't match
Description

You can use the aged debtor report to check that the balance on the customer's balance is also correct. In most circumstances, the two figures should match. This explains what to do when the figures don't match.

Cause
Resolution

Why the report may not match

This usually occurs when your customer balance includes all sales invoices, payments and credits. This includes those dated in the future. The aged debtors report displays only transactions up to the specified date on the report.

What you need to check

  • Check that you have chosen the correct date for the aged debtors report. If you choose a date in the past, the report may exclude some recently dated transactions.
  • Make sure the invoices that show as outstanding in the report show as outstanding in your customer record
  • If an invoice is showing as paid on your customer activity, but outstanding on the report, then the payment's date is after the date of the report. To resolve this, change the date of the aged debtors report to make sure it also includes these payments
  • If the invoices on your customer activity aren't paid, then check for outstanding payments on account. Then match them to the outstanding invoices
  • Make sure the payments shown on your customer activity have a type called Customer Receipt. If you have any receipts with the type Other Receipt, the payment won't appear on the Aged Debtors report

[BCB:299:UKI - Personal content block - Dane:ECB][BCB:306:UKI - Search override - Accounting UK / IE:ECB]


[BCB:276:UKI - hide back button:ECB]


Steps to duplicate
Related Solutions