How to Troubleshoot Sage 50 Account Out of Balance Error

balance error on sage 50

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

How to Fix Sage 50 Account Out of Balance Error

Total Time: 15 minutes

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

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.

So, whether you want to install Sage 50 on your computer or are encountering error messages while using it, we can help you fix all your issues in the lowest wait time possible. Call us on our toll free number today and experience the best tech support session for your Sage 50 accounting software.


πŸ”·Frequently Asked QuestionsπŸ”·

Q1. How Would I Change the Accounting Period in Sage 50?

Ans: πŸ”· Choose Tasks, hit System, and then click Change Accounting period
πŸ”· Now click on the accounting period you need to open
πŸ”· Hit OK
πŸ”· You need to click on the No tab to the question which says “Would you like to print your invoices or checks before continuing?”
πŸ”· Now hit No on the question named “Would you like to run an Internal Accounting Review?”
πŸ”· The active accounting period will modify to the customized period.

Q2. How do I Consolidate My Consolidated Company?

Ans: πŸ”· Open the Sage 50
πŸ”· Choose File and then New Company
πŸ”· Select Next
πŸ”· Write the information for the consolidated company
πŸ”· Hit Next tab
πŸ”· Choose Consolidate existing Sage 50 Accounting companies
πŸ”· Select Next
πŸ”· Choose the posting technique for the company
πŸ”· Hit Next
πŸ”· Select Finish
πŸ”· Update consolidated company by locating File option
πŸ”· Click Consolidated company
πŸ”· Choose and company and then hit Add button
πŸ”· Hit Reconsolidate tab

Q3. How Would I Fix Error: “General Ledger Does Not Balance”?

Ans: πŸ”· Locate File button
πŸ”· Click Backup option
πŸ”· Create a company file backup
πŸ”· Change the accounting period and set it period 1
πŸ”· Run the integrity check by clicking on the Help button and then hit Support utilities
πŸ”· Hit Continue button
πŸ”· Verify reindex files on the list named Reindex
πŸ”· Choose Chart and then hit OK
πŸ”· If the error sort out then take a new backup
πŸ”· In case the error persists then restore a backup file

Report Your Issue

(Didn't find what you were looking for! Report your issue and get customized help from our Sage experts.)



    Sage Version

    Edition Year

    No of User: Licence

    Operating System:

    Help Needed:

    Write your Issue

    Further Reading