How to Troubleshoot Sage 50 Account Out of Balance Error

When businesses grow, accounting becomes complex and difficult. Professional accounting software like Sage 50 automates the accounting process and makes things simple and less time consuming even for a novice user. However, at times, running financial reports on Sage 50 results in errors. One such error is ‘Account out of balance’. This error occurs if there’s a discrepancy in your accounts balance and needs manual intervention.

So, if you are facing “Sage 50 Account out of balance” error while working on your Sage 50 accounting software and need help, here are some simple steps that you can carry out to troubleshoot the issue manually.

Reason Behind Sage 50 Account Out of Balance Error

• When the types of the account have been modified
• Corrupted transactions
• Damaged custom report
• Missing custom report from the general ledger account
• When the General ledger trail balance is being refined for particular accounts
• If the account should be zero but it has a balance
• Out of balance subsidiary companies

Read More : Error Sage Balance Sheet not Balancing

How to Fix Sage 50 Account Out of Balance Error

Here we are mentioned some steps to fix this issue:

Method 1- Corrupted or Incorrectly Customized Report

• If you using a customized Trial Balance report or Balance sheet report then run its standard version
• If the custom version contains an error then delete the customized report
• Now use the standard report as the initial or right custom report to recreate it.

Method 2- Execute the Journal Synchronization /Chart of Accounts Test

• Run the Journal Balances test
• Choose Help button
• Hit Support Utilities, select Integrity Check and then select the Continue tab
• Give a click on box named Journal Balances
• Hit OK button
• Next Run the G/L Balances test then hit the Help tab
• Choose Support Utilities, click Integrity Check
• Hit Continue
• Give a click on box named G/L Balances
• Choose OK
• Check the report is now in balance

Method 3- Corrupted Transactions

• Choose Reports & Forms
• Click the General Ledger tab
• The select report named General Ledger
• Give a click on Options
• Choose Options
• Modify Time Frame to All
• Hit OK

Method 4- Run Data Verification

• Change the accounting period to one to run the test to ensure the verification procedure
• Highlight the Accounting period from the list
• Hit OK
• Choose File
• Give a click on Data verification
• Choose field Both Tests and then hit Start
• The prompt will display to create a Sage 50 data backup then hit Save
• Once the backup is complete then it will start the data verification test automatically
• Once finished Data verification test then you have the button to display the Error log
• If the error does not found then hit Close
• If you discover the error then you can check the test details by giving a click on the button named View Error Log

Method 5- Out of Balance Consolidated Company

• Select one of the subsidiary companies and open it
• Click option named Reports & Forms 
• Choose General Ledger
• Double-click on the tab labeled General Ledger Trial Balance
• Now scroll to the bottom
• Check if the debits are equal to credits
• If they are not the same then run the chart of Accounts journal Synchronization test
• Check the subsidiary companies
• Now reconsolidate the consolidated company
• Check the consolidated company is in balance

Method 6- If Trail Balance is Filtered by Account Segment, Account ID, or Account Type

• Firstly Run Report with no filter
• Check the ending sum of the debit and credits

How to Correct an Out of Balance General Ledger – Video Tutorial

Also Read : Sage 50 Balance Sheet Carry Over Error

Final Words!

Accountingadvice.co is one of the leading remote tech support providers for Sage accounting software. With a proficient team of technicians who have years of experience in resolving all kinds of Sage related issues, we are best in business. Our experts can give you quick and timely resolution for all your technical problems to keep your business up and running. We are available 24X7, 365 days a year and provide first call resolution for all tech issues.

Frequently Asked Questions(FAQs)