Locate batches causing an out of balance General Ledger period
Description
Cause
Resolution

Run the Totals by Batch report for the accounting period that is out of balance.

  1. In General Ledger, from the Reports menu, select Entries, Totals by Batch.
  2. Click Conditions.
  3. From the Field list, select Accounting Date.
  4. Under Operator, select Greater than or equal to.
  5. In the Value, enter the first day of the period.
  6. Click OK.
  7. Click Add.
  8. From the Field list, select Accounting Date.
  9. Under Operator, select Less than or equal to.
  10. In the Value, enter the last day of the period.
  11. If you’re using prefixes and the out of balance is in a particular prefix, add a condition:
    1. From the Field list, select the prefix description listed under Account. For example, if your prefix description is Company, select Company under the Account field.
    2. Under Operator, select Equal to.
    3. In the Value, enter the prefix ID.
    4. Click OK.
  12. If you’re using Both accounting methods, click Add to add this condition:
    1. From the Field list, select Accrual or Cash.
    2. Under Operator, select Equal to.
    3. In the Value, select the accounting method that is out of balance.
    4. Click OK.
  13. Click OK.
  14. Print or preview the report.
  15. Make note of the batches that have an amount in the Batch Proof column.
     NOTE: There’s a page break between applications so be sure to review all pages. 
  16. Check the Entries by Batch report and determine the best solution for the batches you noted.
Steps to duplicate
Related Solutions

Why is my General Ledger out of balance?

Error: "REJECTED - Batch [number] - Debits not equal to credits" (batch didn’t completely post)