Balance of my Retained Earnings account is incorrect after closing the fiscal year
Description
Cause
Resolution

Check for damaged transaction errors

  1. Click Reports & Forms and General Ledger.
  2. Select the General Ledger report.
  3. Click Options.
  4. Change Time Frame to All.
  5. Click OK.
  6. If no error appears, skip to the next section. 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 out of Sage 50.
  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 the next section.

Integrity Checks

Make a backup of the company before performing these steps.

  1. Have all other users close out of Sage 50.
  2. Select Tasks, System, and then select Change Accounting Period.
  3. Select period 01.
  4. Click OK.
  5. Select Help, Support Utilities, Integrity Check.
  6. Run the Chart of Accounts Journal Synchronization test.
  7. Check the account balances the General Ledger should now be in balance if the account balance is still incorrect, proceed to the next step.
  8. Access Integrity Check, and then click Continue. 
  9. Select Journal Balances box, and then click OK.
  10. Access Integrity Check, and then click Continue.
  11. Select G/L Balances box, and then click OK.
  12. Check the account balances; the General Ledger should now be in balance; if the account balance is still incorrect, proceed to the next section.

Manual correction

Adjust the balances with a General Journal Entry in one of the open periods. See How to create a general journal entry.

Need more help?

Chat now

 

Steps to duplicate
Related Solutions

Integrity Check Guide

Incorrect zeroed out account balances after closing year