How to Correct an Out of Balance in General Ledger Trial Balance for Sage 100

How to Correct an Out of Balance in General Ledger Trial Balance for Sage 100
6 min read
16 August 2022

Reinforcement Warning

Use alert while working with the underneath item usefulness. Continuously make a reinforcement of your information prior to continuing with cutting edge arrangements. On the off chance that important, look for the help of a certified Sage colleague, network director, or Sage client care expert.

Goal

Two different ways exist for the General Ledger to become out-of-balance. The accompanying choices help to figure out what direction the General Ledger is out-of-equilibrium, and how to determine it.

Find-: Sage Error 1306 : Another application has exclusive access to the file

Charges don't rise to the credits:

The main method for deciding whether General Ledger is out-of-balance is the point at which the 'Charges' don't rise to the 'Credits'. Create the Trial Balance Report and the General Ledger Detail Report (should be produced for all records). Check that the 'Charge' segment report absolute doesn't rise to the 'Credit' section report all out. See beneath:

Create General Ledger Detail Report:

  • Open General Ledger, Reports, General Ledger Detail Report
  • Under the Criteria area, select a similar period as you produce the Trial Balance for
  • Select pertinent year and period
  • Select All Accounts
  • Click Preview

Create General Ledger Trial Balance:

  • Open General Ledger, Reports, General Ledger Trial Balance
  • Under the Options area, in the Type of Balance to Print drop-down list, select Beginning Bal/Activity/Ending Bal
  • Select a similar period as you create the GL Detail Report for
  • Select All Accounts
  • Click Preview
  • The above Trial Balance Report shows the Beginning Balance, Activity and Ending Balance.
  • Note: if the 'Report Total', 'Starting Balance' segment doesn't approach zero. This shows that the out-of-balance happened in a past period.

An "in balance" report (when created for all records) ought to show a 'Report Total' for the 'Starting Balance' section equivalent to zero when produced for all records, the 'Charge' and 'Credit' sums would be equivalent, and the 'Finishing Balance' segment would be zero. If at least one of these are valid, General Ledger is out-of-balance.

 

Step by step instructions to determine the above out-of-balance:

  • Run the Trial Balance Report for all records showing the Beginning Balance, Activity and Ending Balance. See the means above.
  • In the event that the Beginning Balance Report Total doesn't approach zero, run the Trial Balance Report once more (as in sync 1 for the past time frame).
  • Proceed with this cycle until the Beginning Balance Report Total is zero.
  • To lay out which section is definitely not a 'twofold sided passage' (meaning the section's complete charges don't rise to the all out credits):
  • Open General Ledger, Reports, General Ledger Detail by Source Report
  • Print the report for all diaries, all clusters, and for the date scope of the period that is out-of-balance.
  • Note: If the report is many pages, it very well may be printed to conceded and saw from that point or reviewed for a more modest scope of dates (for instance if Aug 2013 is out of equilibrium, take a stab at running this report for the posting dates of 8/1 - 8/15 to assist with reducing if the out of equilibrium happened during the initial 15 days of the month)
  • Survey the report to affirm every section is a twofold sided passage (in balance).

Find More-: What is Double Entry Bookkeeping

Model: On CD-0001 (the primary passage) diary sums, the absolute charges equivalent the complete credits. Disc 0002 is an out-of-balance section, the charge all out doesn't approach the credit all out. The money part of the passage is absent. An uneven section should be made for the piece of the passage that is absent.

  • Open General Ledger, Main, General Journal Entry
  • Enter the source diary, bunch number, and posting date from the first register. On the Lines tab, enter the records for just the lines that are absent..
  • Click Accept
  • Click One button.
  • Note: If the 'One' button isn't accessible, the User doesn't play adequate part consents. see Related Article underneath, How to Create a One-sided Journal Entry
  • Print and Update the General Journal.

After the interaction finishes, affirm General Ledger is presently not out-of-balance by contrasting the aggregates of the Trial Balance Report and the General Ledger Detail Report for a similar period. Presently produce the Trial Balance report for the following time frame. Follow the above strides until the out-of-balance issue does not exist anymore.

Utilize the means underneath to address the out-of-balance issue provided that the GL Detail Report versus the GL Trial Balance report out of equilibrium sums don't coordinate:

  • Make a duplicate of the organization. See Related Article beneath, How to Create a New Company code and Copy Company Data from Existing Company Code.
  • In the Copy Company, recalculate the overall record account adjusts utilizing the General Ledger Utility (See Related Article beneath, How to Recalculate Account Balances).
  • Republish the General Ledger Detail Report for all records to affirm the accompanying:
  • Out-of-balance lines don't show up in that frame of mind of any records.
  • 'Starting Balance Report Total' approaches zero.
  • 'Charge' and 'Credit' section sums equivalent.
  • 'Finishing Balance Report Total' rises to nothing.
  • Check the equilibriums of all records on the Trial Balance Report
  • 'Starting Balance Report Total' approaches zero.
  • 'Charge' and 'Credit' section sums equivalent.
  • 'Finishing Balance Report Total' approaches zero.
  • Open General Ledger, Utilities, Recalculate Account Balances
  • Click Proceed
  • Assuming that the Recalculate Utility remedies the out of equilibrium and all record adjusts have been confirmed, rehash these means in the live organization.
  • Note: Make sure you back up your organization once more and all clients are out of the organization prior to doing ventures above in the live organization.

Note: Make sure you back up your organization once more and all clients are out of the organization prior to doing ventures above in the live organization.

Find Also-: Step to Add the Forget Password option on the Sage Login Screen

In case you have found a mistake in the text, please send a message to the author by selecting the mistake and pressing Ctrl-Enter.
thomaslane 52
At AccountingAdvice, we are a leading third-party remote technical support provider for Sage 50. With a global footprint, we provide expert support service for...
Comments (0)

    No comments yet

You must be logged in to comment.

Sign In / Sign Up