Why is my General Ledger out of balance?
Description
Cause
Resolution
  1. Open Sage Desktop.
  2. If you don’t see a task list to the left side of the screen, choose View, Tasks.
  3. Under Sage 300 Construction and Real Estate/Applications, select Additional Tools.
  4. Double-click on Reconciliation.
  5. Find Application Procedures in the bottom left and select General Ledger.
  6. Follow step 1 to Post Entries.
  7. Follow step 2 to run the Current Ledger.
  8. Look at the grand totals on the last page.
    Tip: Press END on your keyboard twice to skip to the last page.
  9. Your ledger is in balance if your grand totals show the following:
Beginning Balance Debits/Credits Ending Balance
.00 Debits = Credits .00
If your ledger shows anything other than the above, you are out of balance. Compare your grand totals with the table below and choose the appropriate option to reconcile General Ledger:

 

Beginning Balance Debits/Credits Ending Balance Option
Any Debits not equal to Credits Any Option 1
.00 Debits equal to Credits Not .00 Option 2
Not .00 Debits equal to Credits Same as beginning balance Option 3

Option 1:

There is an out of balance batch, there is a batch that is split across two different accounting periods, a General Ledger account was deleted, or amounts were posted to a Unit account. For more information on determining whether a General Ledger account was deleted, see Why is my General Ledger account missing from the Current or Year-to-date Ledger?. Otherwise, determine the issue as follows.

To determine whether there is an out of balance or split batch, move to Step 4 in the Reconciliation Tool to print the Totals by Batch report. (You can find this report in the reports menu under Reports, Reconciliation, Totals by Batch (CR).)

  1. If any applications show an amount in the Difference column, double-click that amount. It will drill down to the batch information.
  2. Find the batch or batches that show a difference and double-click the difference amount. It will drill down into the entries that make up that batch.
  3. If the batch is out of balance:
    • Verify the rest of the batch is in the New file in Inquiry, Entries by Batch. If the remainder of the batch is unposted, see How do I post an out of balance batch in General Ledger? to post.
    • If the rest of the batch isn't in the new file, use Record Entries in General Ledger to bring it in balance or reverse it completely.
    • If the batch is in balance, continue with the next step.
  4. Review each batch to see if any of the accounting dates are in different periods or if entries are missing or duplicated. For more detailed information on this situation, in the Reconciliation Tool, follow Step 5, second option "Entries Spanning Two Accounting Periods." See How do I find the batches causing a General Ledger period to be out of balance in total debits and credits? for more infomation.
  5. If the batch is in balance (the debits equal the credits), but some entries are in different accounting periods, reverse the entries that are in the incorrect period and record them in the proper period.
  6. If the batch includes more than one prefix, in the Reconciliation Tool, follow Step 5, third option, "Inter-company discrepancy."
  7. If the batch is in balance (the debits equal the credits), but some entries are in different prefixes, record intercompany transactions to fix the discrepancy.

If possible, correct the batch in the application of origin; otherwise correct the batch in General Ledger. See How do I record or post a one-sided or out of balance entry in General Ledger? for more information.

To determine whether amounts were posted to a unit account, print the Entries by Account report in General Ledger:

  1. From the Reports menu, select Entries, Entries by Account.
  2. Select GL Transaction (current), and select GL Transaction (history) if available.
  3. Click OK and then click Conditions.
  4. Click Index, select GL - Account, and click OK.
  5. Under Field, select Account Type.
  6. Under Operator, select Equal to.
  7. Under Value, select Units.
  8. Click OK and click Add.
  9. Under Field, select Accounting Date.
  10. Under Operator, select Greater or equal to.
  11. Under Value, enter the beginning date of the out of balance period.
  12. Click OK and click Add.
  13. Repeat steps 9-11, but under Operator, select Less or equal to and under Value, enter the ending date of the out of balance period.
  14. Click OK twice and click Print Preview.
  15. If amounts print on the report, review the setup of the accounts listed (Setup, Accounts) to determine if the account type should be changed or the amounts should be reclassified to other accounts.

Option 2:
The activity of the General Ledger master file does not match the transactions in the transaction file. Look for accounts that appear on your ledger with exclamation points (!!) next to the ending balances. In the Reconciliation Tool, follow the directions in the Notes column for Step 2 Current Ledger. See Double exclamation marks (!!) appear on the Current Ledger or Year-to-date Ledger in General Ledger (activity field on account record does not equal transactions) for more information.

Option 3
The out of balance situation has carried forward from a prior period. Print your Year-to-date Ledger for prior periods until you find the out of balance period as follows:

  1. From the Reports menu, select Year-to-date Ledger.
    Note: If you use both cash and accrual accounting, select your accounting method and click OK.
  2. Select the Modify date range check box and enter the first and last day of your prior period.
  3. Click Print Preview and look at the grand totals on the last page of your report.
  4. Repeat these steps for each prior period until you find a period that has a beginning balance of zero and then check the table below:
Beginning Balance Debits/Credits Ending Balance Option
.00 Debits not equal to Credits Difference of debits and credits Option 1 (above)
.00 Debits equal to Credits Not .00 Option 2 (above)
.00 Debits equal to Credits .00 Option 4 (below)

Option 4
Your ledger may be out of balance due to prior year adjustments. In the Reconciliation Tool, follow the steps in Step 5, first option, "Entries have been made to a prior year."
You can also check for prior year adjustments with General Ledger is in balance the end of the prior year but is out of balance the beginning of the current year (Prior year adjustments need to be closed)

If you don't have prior year adjustments or if your ledger (Reports, Current Ledger) is still out of balance after you close or reverse your prior year adjustments, see How do I close prior year adjustments to retained earnings?.

Note: There is also a chance that what is thought of as the prior year has not yet been closed. When trying to look at the Year to Date Ledger for the first period of the current year in real life, the first period begins and ends out of balance by the amount of the Net Income/Loss of the closing year. For more information on how to close the fiscal year, please see How do I close the fiscal year in General Ledger?.

Note: The Retained Earnings account may have been deleted. Or deleted and then re-added without the balances on the Master file (Account Setup balance boxes) being updated to match what the Transaction file shows for entries. You will need to look at the Accounts Inquiry for both Current and History. It will not let you look at both at the same time within the same GL module. You can either print them out for comparison or if the module Information Assistant is available you can run one Inquiry in GL and one in IA, while having each window next to each other. See How do I recreate a deleted General Ledger account? for steps on correcting the Master file balances.

Other Options
If the options above do not resolve your issue, consider the following:



[BCB:156:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions

How do I recreate a deleted General Ledger account?


Attachment: 347_20230425114339_Explanation of GL reports.pdf