There may be times when your Aged Debtors nominal code balance doesn't reconcile with an aged debtors report. There are a number of reasons why this may happen. click here to read more about why this may happen.

Run the Aged Debtors Analysis (Summary) with the correct criteria

Check all customers are included

You need to run the report for all customers. If any customers are excluded from the report the aged debtors won't balance.

If any customers have an underscore, or other non-alphanumeric characters, in their account reference, for example, Z_01, the aged debtors report may exclude them.

• Click Customers then click the  button until All Records appear then click Clear
• Ensure the Include inactive checkbox is selected

Run the Aged Debtors Analysis (Summary) report

1. Click Customers then click Reports.
2. Click Aged debtors then click Aged Debtors Analysis (Summary).
3. Click Preview then complete the Criteria as follows:
   • Customer Ref: Leave as default
   • Report Date: Enter the last day of the month being reconciled
   • Inc Future Tran: Clear this check box
   • Exc Later Payments: Select this check box
4. Click OK then check the total of the Balance column.

Run the Period Trial balance with the correct criteria