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. One reason may be due to corruption in your data.

Check your data for errors or warning relating to the sales aged balance

1. Click File then click Maintenance.
2. Click Check Data.
   
   Errors: These may be causing the problem and must be corrected before continuing - Use our A to Z of Check Data errors guide for more information. 
   
   Warnings: The following warning indicates problems with the aged creditors:
   
   'Sales Aged Balance disagrees with Debtors Control by (amount)' 

• The currency information in your data files may be corrupt. For help with this, refer to the Check for currency corruption section
• Link removed transactions. For help with this, continue to the Check for bucket corruption section

Check for bucket corruption

Bucket corruption occurs when the nominal code bucket values disagree with the total of the activity for the same period. To check this, run the Nominal Activity report for the full date range, 01/01/1980 to 31/12/2099, and compare the history balance to the Total in the Actuals column in the nominal record.  For more information on bucket corruption use our guide.

Check for currency corruption

If the currency information in your data is corrupt, this may cause the aged debtors reports to show an incorrect balance.

To check for currency corruption, run check data:

• In Sage 50 Accounts, click File then Maintenance then click Check data

The following will appear if you have currency corruption:

 NOTE: This will appear as a comment if you're using v27 or above and an error is you're using v26 or below. 

To resolve this issue:

• If the account has no transactions associated with it, then the account can be deleted to resolve the issue
• If the account does have activity, then it's not possible to fix this error using the maintenance tools in your software, we recommend you restore an error free backup and re-process.

If the issue persists

You'll need to check if any journals have been posted to the Debtors Control Account.

[BCB:19:UK - Sales message :ECB]
[BCB:278:UKI - Personal content block - Steph:ECB]