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.
User Navigation
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: 35 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 1800 964 3096 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 1800 964 3096 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
