There may be times when your Aged Creditors nominal code balance doesn't reconcile with an aged creditors report. There are a number of reasons why this may happen. One reason may be due to the reports being ran with the wrong criteria.

Run the Aged Creditors Analysis (Summary)

Check all suppliers are included

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

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

• Click Suppliers then click the  button until All Records appear then click Clear.

Run the Aged Creditors Analysis (Summary) report

1. Click Suppliers then click Reports.
2. Click Aged creditors then click Aged Creditors Analysis (Summary).
3. Click Preview then complete the Criteria as follows:
   • Supplier 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

1. Click Nominal codes then click Reports.
2. Click Trial balance then click Period Trial Balance.
3. Click Preview then complete the Criteria as follows:
   • Period: Select the period being reconciled.
4. Click OK then check the total for the Creditors Control Account.