How to resolve an Out of Balance in Bank Reconciliation

Summary

Steps, tips, and tricks for reconciling bank accounts or resolving an Out of Balance in Bank Reconciliation in Sage 100.

Resolution

Bank Recap Report

  1. Lists checks, deposits, and adjustments in the order they happened.
  2. You can print it anytime before deleting the Bank Reconciliation file.
  3. This report shows all transactions for a chosen date range.
  4. You can print:
    • One or more transaction types.
    • Only cleared, only outstanding, or all transactions.
  5. For each bank code, it prints:
    • Transaction date, type, source, check number, and check type
    • Reference, comment/payee name, cleared status, amount, and bank balance
  6. The report prints the number of transactions and total amount for each selected transaction type.

Bank Reconciliation Report (Register)

  1. Lists all transactions for a chosen date range.
  2. The report provides a summary of reconciliation.
  3. The register acts as an audit record of bank activity.
  4. It Includes transactions from:
    • General Ledger, Accounts Payable, Accounts Receivable
    • Payroll, Purchase Order updates, and manual entries using Check, Deposit & Adjustment Entry
  5. You normally print the Bank Reconciliation report after using the Reconcile Bank.
  6. The reconciliation summary:
    • Total all outstanding checks, deposits, and adjustments
    • Shows calculated book balance up to the ending transaction date

Bank Reconciliation Process Tips

Match these amounts with the bank statement summary:

  • Beginning balance on statement = beginning balance on Bank Recap Report
  • Ending balance on statement = ending balance entered in Reconcile Bank
  • Cleared items on statement = cleared items on Bank Recap Report

 

You can create a template such as the example below. Enter the bank information and use it to Check amounts in Sage 100.

Image

TIP:

If the Reconcile Bank window shows Out of Balance By 0.00, but the Bank Reconciliation Report shows a different balance (or vice versa), run the Recalculate Outstanding Entries Totals utility. In Bank Reconciliation, select Utilities, and then run Recalculate Outstanding Entries Totals.

 
▼ Tip #1: Reconcile beginning balance on Bank Recap Report

Image

  1. Open Bank Reconciliation, go to Reports, then select Bank Recap Report.
  2. Enter the bank code only. Leave other fields blank.
  3. Preview the report and compare its beginning balance to the Bank Statement's beginning balance.
  4. If the balances don’t match, follow these steps to fix it:
  5. Find the difference between:
    • Ending balance on last purged Bank Statement.
    • Beginning balance on Bank Recap Report. (For example: If you purged May, June's Bank Statement beginning balance need to match the Bank Recap Report.)
    • Tip: Always purge cleared transactions monthly after printing a balanced Bank Reconciliation Report.
  6. Go to Bank Reconciliation, then Main, and open Bank Code Maintenance.
  7. Choose the correct bank code from the lookup list.
  8. Write down the Current Balance before making changes.
  9. Adjust the Current Balance using the difference from step 5:
    • If the Bank Recap Report is too low: Increase the Current Balance.
    • If the Bank Recap Report is too high: Decrease the Current Balance.
    • Enter the new amount and click Accept.
  10. Run the Bank Recap Report again and confirm the beginning balance matches the Bank Statement.
▼ Tip #2: Confirm the ending balance in Reconcile Bank is correct

Make sure the ending balance on the bank statement matches the Ending Balance entered in the Reconcile Bank.

Image

 

▼ Tip #4: Finalizing the Bank Reconciliation
  1. When the out of balance amount is zero, start reconciling against the General Ledger.
  2. This process uses the Bank Recap Report and General Ledger Detail report for comparison.
  3. Print the Bank Recap Report through the last day of the month you're reconciling.
  4. Print the Bank Reconciliation Report through the same date.
  5. Answer Yes when asked, “Do you want to purge cleared documents?”

 CAUTION: Retain these copies as you can't regenerate these reports. 

Image

 

 

 

 

Need more help?

Chat now



Related Solutions


Reconcile Bank is in balance but the Bank Reconciliation Report is out of balance or vice versa

Reconcile the Bank Reconciliation Register for the first time

Solution Properties

Solution ID
222924250018026
Last Modified Date
Fri Oct 09 13:37:05 UTC 2026
Views
0