Articles

Why Sage Trial Balance is Not in Balance?

by Bizfin Consulting Accountants

Sage trial balance out of balance is a common issue faced by Sage software user. This error signifies inaccurate balance in the saving earnings when the fiscal year has been just turned off. The accounts have a dissimilar balance on end day of the first fiscal year and last day of the present fiscal year, with no transaction to cause it. The sage accounts did not shut down to the maintain earnings account that has been divided into another account.

Cause of Issue Sage Trial Balance Out of Balance

  • Account types have been modified
  • Corrupt transactions
  • Corrupt custom report
  • Custom report misplaced general ledger account
  • General Ledger Trial out of Balance is being clean for particular accounts or account segments
  • Account balance must be zero
  • Subsidiary businesses are out of balance

Resolutions to Fix Issue Sage Trial Balance Out of Balance

Method I: Incorrect customization or corrupted report

  • Start the customized standard version of Balance Sheet report or Trial Balance report
  • In case, the standard version is out of balance, perform the method II
  • In case the custom version has balance, remove the customized report and recreate the report by using the standard report as the beginning point.

Method II: Run the Journal Synchronization or Chart of Accounts test

  1. Run Journal Synchronization or Chart of Accounts test
  1. Run Journal Balances test; click Help, Integrity Check, Support Utilities, and then select Continue.
  2. Choose the Journal Balances dialogue box, and then click OK
  3. Run G/L Balances test; select Help, Support Utilities, Integrity Check, and then click to Continue.
  4. Choose G/L Balances dialogue box, and then select OK.
  5. Check whether the report is now in balance or still out of balance.

Method III: Corrupted Transaction(s)

  1. Choose Forms & Reports, and then click to General Ledger.
  2. Choose the General Ledger report.
  3. Click Options.
  4. Modify the Time Frame to All.
  5. Click OK.

Method V: Consolidated business is out of balance

  1. Launch one of the subordinate companies.
  2. Choose Forms & Reports, and then choose General Ledger.
  3. Double-click the General Ledger Trial Balance, and then go to the bottom.
  4. Perform the steps again for all the subsidiary companies.
  5. Reconsolidate the consolidated organization
  6. Check the consolidated business is in balance.

Method VI: General Ledger Trial Balance is being cleaned by Account Segment, GL Account ID, or Account Type

  1. Start the report standard General Ledger Trial Balance with no filter.
  2. Confirm the credit totals and ending debit resembles with each other.

Method VII: Verify all the corrupted Transaction Errors

  1. Click Reports > then Click Forms > and then click the General Ledger
  2. Choose the General Ledger report > and then Click Options
  3. Modify the Time Frame to All > and then Click OK
  4. If any error occurs, shut down the error message, click the General Ledger report, and Choose a Report or Form
  5. Go to File > and then click Data Verification
  6. Leave Both tests chosen > and Click Start
  7. Save the backup file, the tests will automatically begin automatically
  8. Once data verification has completed, verify the account balance

Why RemoteAccounting247 Sage Technical Support?

Hope the given step-by-step resolution proves useful for resolving Sage trial balance out of balance. However, for best Sage accounting support, you can benefit from our array of experts communication services which are actively accessible 24x7 or connect with our well-trained multilingual technical experts’ team. They rectify the issues from most general to the most crucial problem encountered in Sage tech Software. Each query and complaint is taken by them very sincerely and they are trained to fix Sage trial balance out of balance types of errors within a limited time.

RemoteAccounting247 Sage Support

 

Source: https://goo.gl/NVMEmJ


Sponsor Ads


About Bizfin Consulting Advanced   Accountants

51 connections, 1 recommendations, 164 honor points.
Joined APSense since, April 23rd, 2018, From Chicago, United States.

Created on Nov 5th 2018 05:26. Viewed 380 times.

Comments

No comment, be the first to comment.
Please sign in before you comment.