Bank Reconciliation Matcher

This bank reconciliation tool matches your bank statement to your cash book automatically. Paste or drop both exports, set how many days apart matching entries can be and enter both closing balances, and it pairs up transactions by amount, date and cheque number, lists what's only on the statement and what's only in the books, and builds the reconciliation statement showing deposits in transit, outstanding cheques, bank charges and the adjusted balances. Everything stays in your browser.

Reconciliation statement layout

LineEffect
Bank statement balanceStart
+ Deposits in transitBook receipts not on the statement
− Outstanding chequesBook payments not yet cleared
Cash book balanceStart
+ Bank creditsInterest, direct receipts
− Bank chargesFees, direct debits

When to use it

  1. Reconcile the bank account at month end.
  2. Find bank charges and interest to record.
  3. Track outstanding cheques.
  4. Clean up a backlog of unreconciled months.
  5. Check an accountant's reconciliation.

How to Use

  1. Paste or drop the bank statement and the ledger.
  2. Set the date window and closing balances.
  3. Review matched and unmatched items.
  4. Read the reconciliation statement and export CSV.

Features

  1. Auto-matching by amount, date and reference
  2. Debit/credit or signed amounts
  3. Unmatched items on each side
  4. Reconciliation statement
  5. CSV export
  6. Private: stays in the browser

FAQs

How does the matching work?

Each bank line is matched to one ledger line with the same amount within the date window, preferring a matching reference.

What are deposits in transit?

Receipts recorded in your books that haven't reached the bank statement yet.

What if the balances still differ?

Check opening balances, duplicate entries and amounts entered wrongly; the unmatched lists show where to look.

Is my statement uploaded?

No. The files are read in your browser and never leave it.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

Both files are read as CSV or spreadsheet exports with a date, a description and either an amount or debit/credit (deposit/withdrawal) columns. Each bank line is matched to one ledger line with the same amount within a date window, preferring a matching cheque or reference number and then the closest date. Unmatched book items become deposits in transit (positive) or outstanding payments (negative); unmatched bank items are credits or charges not yet in the books. The statement shows adjusted bank and book balances and any difference. Results export to CSV.

Finance & Tax Tools

Finance & Tax Tools

  • Receivables Aging Report
  • Markup and Margin Converter
  • 12-Month Cash Flow Forecast
  • Withholding Tax Calculator (Pakistan)
  • Rental Yield and Cap Rate Calculator
  • Rent vs Buy Calculator
  • Property Transfer Cost Calculator
  • Tip Pool Calculator