Balance of my Retained Earnings account is incorrect after closing the Fiscal Year
Description
Cause
Resolution

Section I: Check for damaged transaction errors

  1. Click Reports & Forms, General Ledger
  2. Select General Ledger report
  3. Click Options
  4. Change Time Frame to All
  5. Click OK
  6. If no error appears, skip to Section II; if an error does appear, continue to the next step
  7. Close the error message, the General Ledger report, and Select a Report or Form
  8. Have all other users close Sage 50—U.S. Edition
  9. Click File, Data Verification
  10. Leave Both tests selected and click Start
  11. Save the backup; the tests will begin automatically when this completes
  12. When the Data Verification has finished, check the account balances; if still incorrect, or if the General Ledger Trial Balance and/or Balance Sheet are out of balance, continue to Section II

Section II: Integrity Checks

Note: It is recommended to make a backup of the company prior to performing these steps.

  1. Have all other users close Sage
  2. Select Tasks, System, and then select Change Accounting Period
  3. Select period 01
  4. Click OK
  5. Select Help, Support Utilities, Integrity Check

Note: For Versions prior to 2018.0, select Help, Customer Support and Service, and then select Integrity Check.

  1. Run Chart of Accounts/Journal Synchronization test; refer to Article ID 10249: DocLink: How do I run the Chart of Accounts Journal Synchronization test?
  2. Check the account balances the General Ledger should now be in balance if the account balance is still incorrect, proceed to the next step
  3. Access Integrity Check, and then click Continue
  4. Select Journal Balances box, and then click OK
  5. Access Integrity Check, and then click Continue
  6. Select G/L Balances box, and then click OK
  7. Check the account balances; the General Ledger should now be in balance; if the account balance is still incorrect, proceed to the next section

Section III: Manual Correction

Adjust the balances with a General Journal Entry in one of the open periods; refer to Article ID 10631: DocLink: How do I create a general journal entry?.

DocLink: Integrity Check Guide
DocLink: Incorrect zeroed out account balances after closing year
DocLink: How do I access the Integrity Check in prior versions?

[BCB:161:Chat 50 US:ECB]
Defect ID
Steps to duplicate
Related Articles