4788: Fixing bucket corruption

<< Home
<< Contact Us

Last Modified:
Author: Pimbrook Support

Fixing bucket corruption

Within each nominal, customer and supplier record, the monthly values in the Actuals column are called buckets. Bucket corruption occurs when one or more of these bucket values disagree with the total on the record activity for the same period.

A common symptom of nominal bucket corruption is if the debit and credit totals on the trial balance report don’t match.


Fixing bucket corruption

Did you find this video helpful?

To fix bucket corruption

Note: Before you follow these steps, in Help > About you must check when the clear audit trail was last ran. If you’ve cleared the audit trail using a date within the current financial year, the monthly buckets prior to the clear audit trail date will be incorrect after recalculating. In this scenario, print any required reports before you recalculate.

Sage 50 Accounts 2012 (v18) and above

  1. File > Maintenance > Yes to close any open windows.
  2. Check Data > Recovery Tools > follow the prompts to take a backup of your data > OK.
  3. Recalculate Period Values > OK > Close > Close.


Sage 50 Accounts 2011 (v17)

  1. Take a backup of the data.
  2. File > Maintenance > Recalculate.


Note: Revaluation transactions may be added to the bucket values on rebuild.

Possible causes and best practice

Bucket corruption may be caused by issues including crashes and power failures. There are also some specific causes that you should be aware of:

  • Crashing out of the Year End process – The Year End process may take some time to run, during which the Task Manager may show ‘Not Responding’. You should not crash out of the year end routine.
  • 3rd party data import – Data imported from third party software may cause bucket corruption. You should check your bucket values are correct after such imports.
  • Nominal codes missing from the chart of accounts – Before running the Year End routine it is important to check the chart of accounts to ensure no codes are missing

Still need help?

<< return to search