Check data error - 'Trial balance recorded in nominal records is unbalanced by (amount)'

In Sage 50 Accounts, if you receive any errors, we recommend you fix these before continuing.

When you check your data you may get the following error:

'Trial balance recorded in nominal records is unbalanced by (amount)'

 

NOTE: If this error appears after running a year end, you'll need to restore a back up of your data and re-process. 

To correct this error, please follow the steps below.

1. Click File, then click Maintenance and click Check Data.
2. Click the Warnings tab and if either of the following warnings appear, make a note of the amounts:
   
   • Sales aged balance disagrees with Debtors Control by (amount)
   • Purchase aged balance disagrees with Debtors control by (amount)
3. Click the Technical Information tab then in Dataset Information, note the number of Splits.
4. Click Recovery Tools, when prompted, follow the instructions and create a data backup.
5. Click Reindex and Compress All, then click OK.
6. Click Recalculate Transaction History, then click OK.
7. Click Recalculate Period Values, then click OK and click Close.
8. When prompted to check the data again, click Yes.
   
   If the error is still present, restore an error free backup and re-process, otherwise continue.
   
   
9. Click the Warnings tab and check the amounts on the Aged Balance warnings.
   
   If the warnings disappear, continue to the next step.
   
   If the amounts differ to step 2, restore an error free backup and re-process, otherwise continue.
   
   
10. Click the Technical Information tab then in Dataset Information, check the number of Splits.
    
    If the number differs to that in step 3, restore an error free backup and re-process.

Next steps

• I have other errors, warnings or comments >
• I've removed all errors and warnings >