Skip to content
logo Knowledgebase

General Ledger Trial Balance or Balance Sheet is out of balance

Created on  | Last modified on 

Summary

The General Ledger Trial Balance and/or Balance Sheet is out of balance in Sage 50 Accounting. Assets don’t equal liabilities.

Cause

  • Chart of accounts/journal is out of sync
  • Damaged transactions
  • Improperly customized or damaged report


Resolution

Chart of Accounts/Journal Synchronization test (most common fix)

See How do I run the Chart of Accounts Journal Synchronization test?.


Damaged transactions

Damaged transactions can cause out-of-balance issues. Run the General Ledger report, select Options, and change the Time Frame to All. If there’s an "at least one damaged transaction has been found" error, see Error: "At least one damaged transaction has been found in account [number] in the period beginning [date]....".


Improperly customized or damaged report

  • If you’re using a customized Trial Balance or Balance Sheet, run the standard version of the report
  • If the custom version is out of balance while the standard version balances, do one of the following: Re-design the custom report or use the standard report

Consolidated company is out of balance

  1. Open one of the subsidiary companies.
  2. Select Reports & Forms. Then select General Ledger.
  3. Double-click General Ledger Trial Balance and then scroll to the bottom.
  4. Do debits equal credits?
  5. Repeat steps 1-4 for all subsidiary companies until all trial balances are in balance.
  6. Reconsolidate the consolidated company. Refer to How do I reconsolidate my consolidated company?.
  7. Verify that the consolidated company is in balance.

Need more help?

Chat now