Clear Bank Transactions in Bank Reconciliation

Summary

Steps to clear bank transactions in your bank reconciliation in Sage 100.

Resolution

After you’ve recorded all checks, deposits, and adjustments in Bank Reconciliation, do the following:

  1. Enter the bank statement's ending balance in the Statement Ending Balance field.
  2. Click Clear to toggle the entry at the Clear column from N to Y
  3. The amount in the Out of Balance By field reflects the clearing of this transaction amount.
    • For deposits, the 'Out of Balance By' amount will decrease.
    • For checks, the 'Out of Balance By' amount will increase.
  4. Click Printer button in Reconcile Bank to print the Bank Reconciliation Register/Report.
  5. Verify that the adjusted book balance and the calculated book balance on the Bank Reconciliation Register/Report match.
  6. Proceed with procedures on How to purge cleared transactions in Bank Reconciliation.

If you don't integrate Bank Reconciliation to any other module

  1. Enter all transactions for the month in Check, Deposit, and Adjustment Entry.
  2. Click Clear to toggle the entry at the Clear column from Y to N. Do this for all entries you don't show on the bank statement.
  3. If the bank statement doesn't list cleared checks in numerical order, use the Check, Deposit & Adjustment Entry to clear monthly transactions:
    •  Use Reconcile Bank to correct the ending balance from the monthly bank statement before clearing checks.



Related Solutions

General Ledger doesn’t balance to the Bank Reconciliation module
How to resolve an Out of Balance in Bank Reconciliation

Solution Properties

Solution ID
222924550020798
Last Modified Date
Wed Nov 19 18:54:59 UTC 2025
Views
0