Your Aged Creditors nominal code balance might not reconcile with the aged creditors report. There are various reasons why this can happen, including running the reports with incorrect criteria.

Run the Aged Creditors Analysis (Summary)

Check all suppliers are included

Run the report to include all suppliers. Any suppliers excluded from the report will cause the aged creditors balance to be different.

The aged creditors report can exclude suppliers with underscores or other non-alphanumeric characters in their account reference. For example, Z_01.

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

Run the 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  TIP: Run the Transactional Trial Balance from 01/01/1980 to the last day of the month you're reconciling.   
4. Click OK then check the total for the Creditors Control Account.