Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

How to Correct Out of Balance General Ledger in Sage 100

10/31/2016

0 Comments

 
Balancing the General Ledger
​In Sage 100, you can’t post an out of balance journal entry in the general ledger. Total debit entries must equal the total credit entries. Here are some tips and a video tutorial that will show you how to correct an out-of-balance journal entry before updating the general ledger in Sage 100.

​Out of Balance in the Current Period

You can recall and modify journal entries at any time until you complete the update process.  To recall a journal entry you have previously entered, click the list entries button to modify the journal entry.

However if the update process has already been completed, you must record an adjusting entry to correct the mistake.

When printing a trial balance for all accounts, the totals at the beginning balance and ending balance columns for the report total should equal zero.  The debits and credits should display the same amounts.

If these conditions are not met, general ledger is out of balance.

You can also view on the general ledger detail report or the general ledger detail by source report to verify the out of balance situation.

NOTE: there are also some very unique situations where you need to use the one-sided entry feature to correct an out-of-balance entry. In this case, you must have your user logon set up with a role assigned with the proper security rights assigned in order to post out of balance entries.

When you review your general ledger trial balance (choosing the “ending balance only” in the report options screen), you can go to the end of the report and see that it is not in balance. You’ll notice that the debits and credits do not equal.

Picture

​Getting Things Back in Balance

​If posting a correcting journal entry to reverse the mistake is not an option, you may need to use the one-sided journal entry function. 

Here’s how to correct things:

1. Go to general journal entry, select a source journal, and assign the next entry number.

2. Choose a G/L account number and enter the appropriate amount in the debit or credit field.

3. Click Accept

Immediately, you’ll see a popup warning that reads as follows:
“This journal entry is out of balance by $X,XXX.XX. The entry must balance to post to the general ledger.”
​
The available options on the popup include:
  • Correct – which allows you to modify the entry and correct it.
  • Accept – saves the entry so that you can research the issue and fix it later.
  • Delete – remove the entry completely.
  • One – this allows you to post a one-sided journal entry (available only if you have the proper user credentials)
​
Sage 100 GL Entry Screen
4.  Choose the One option, post the entry, and update the general journal.

​As a last step, check your general ledger trial balance, go to the last page, and verify that  debits equal credits and voila – you’re back in balance!
​

​Out of Balance in the Current Period

In situations where the out-of-balance occurred in a prior period, you’ll need to print the trial balance report and review the total line.  You may need to do that several times for prior periods until you find a trial balance report with the beginning balance total at zero.

You'll print the trial balance report for all accounts including beginning balance activity and ending balances, and then you can print the general ledger “detail by source” report to help you identify the out the out-of-balance entry.

You’ll want to print the report for all journals, all batches, and for the date range of the period that’s out of balance. After you've located the out-of-balance entry, you can refer to the original register to determine what portion of the entry is incorrect.

It's very similar to the current period adjustment we walked through earlier in the article, but going back period by period until you find a beginning balance of zero, apply your appropriate entries, and then making that correction.
​

​Video Tutorial: How to Correct Out of Balance GL

Got Questions or Need Help?
Contact your local Sage partner if you have questions or need help with an out of balance general ledger.

Not currently working with a partner? 
​Click below to find an Sage 100 consultant in  your neck of the woods using our  Top Sage Reseller partner locator.
Find a Partner
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy