How do I find the batches causing a General Ledger period to be out of balance in total debits and credits?
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 are using prefixes and the out of balance is in a particular prefix, click Add to add this condition:
    1. From the Field list, select the prefix description listed under Account. For example, if your prefix description is Company, you would select Company listed under the Account field.
    2. Under Operator, select Equal to.
    3. In the Value, enter the prefix ID.
    4. Click OK.
  12. If you are 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 is a page break between applications so be sure to review all pages.

Run the Entries by Batch report for the batches noted in step 15 above:

  1. From the Reports menu, select Entries, Entries by Batch.
  2. Use Ranges to select the specific batches noted in step 15.
  3. Click Conditions.
  4. From the Field list, select Accrual or Cash.
  5. Under Operator, select Equal to.
  6. In the Value, select the accounting method that is out of balance.
  7. Click OK twice.
  8. Print or preview the report.
  9. Review the batches and note what is causing the out of balance:
    • If the total debits and credits do not match, the batch is out of balance.
    • If the total debits and credits match, the batch may have entries for different accounting periods or different prefixes.
  10. Determine the correction to be made. Whenever possible, make the correction in the originating application. See article 49756"DocLink: A batch in General Ledger is out of balance" to identify possible solutions. If you're unsure of the correction to be made, contact your Sage 300 Construction and Real Estate consultant for assistance.
DocLink: How do I record or post a one-sided or out of balance entry in General Ledger?
DocLink: Why is my General Ledger out of balance?
DocLink: Error: "REJECTED - Batch [number] - Debits not equal to credits" (batch did not completely post)
DocLink: A batch in General Ledger is out of balance
Defect ID
Steps to duplicate
Related Articles