Skip to main content
All checkers

Bank Statement Reconciliation Tool

Compare a bank statement with your ledger, review possible matches and download the reconciliation from your browser.

Transaction records

Up to 20 MB. The file stays on this device.

Paste a table with a header, or choose a file.

Bank statement columns and signs
Column separator

Numeric date order

Negative amounts

Up to 20 MB. The file stays on this device.

Paste a table with a header, or choose a file.

Ledger columns and signs
Column separator

Numeric date order

Negative amounts

Closing balances

Balance adjustments

Reconciliation

Example transactions
Rows to review
5
Exact pairs
1
Confirmed pairs
0
Adjusted bank
$1,360.00
Adjusted ledger
$1,360.00
Balance difference
$0.00

Review transactions

Record and rowAmount
Exact match 118 Jun 2026 · Transfer from savings$600.00
Exact match 118 Jun 2026 · Transfer from savings$600.00
Open bank row 228 Jun 2026 · Office supplies-$40.00
Open bank row 330 Jun 2026 · Account fee-$20.00
Open ledger row 227 Jun 2026 · Stationery-$40.00
Open ledger row 330 Jun 2026 · Client deposit$200.00
Open ledger row 430 Jun 2026 · Supplier payment-$90.00

Confirm a pair

Prepare the Two Records

Use the bank statement and cash ledger for the same account, currency and period. Paste each transaction table or choose a CSV or tab-separated file. Each record needs a header row and a date, description and signed amount for every transaction.

The default column order is Date, Description, Amount. If yours differs, enter the column numbers from left to right, starting at 1. Choose the separator and date order for each record. Full ISO dates such as 2026-06-30 work with either date order.

By default, positive amounts are money in and negative amounts are money out. Change Negative amounts for any record that uses the reverse convention. If the ledger has separate debit and credit columns, make a signed amount column first.

Enter both closing balances from the original records on the same date. The comparison starts from those balances, with no opening balance calculation. Check each opening balance against its prior closing record before using the closing comparison.

Match and Review

An exact pair has the same date, signed amount and description after the tool ignores letter case and extra spaces. The signature must appear once in each record. Repeated entries stay open, even when their dates and amounts agree.

For an open bank row, the tool lists up to ten possible ledger rows within the date window. The description or signed amount must agree for a row to appear as a suggestion. The window defaults to three calendar days.

Check the references and posting dates before confirming a pair. Enter one row number from each record to confirm two open rows with the same signed amount. Leave partial amounts and split payments open while you check the original records.

Keep the Difference Report

Download the reconciliation CSV to save exact pairs, confirmed pairs and open rows with their signed amounts. The report includes the entered closing balances and adjustments. It calculates the closing difference when both balances are present.

The tool compares the data you supply. Confirming that a statement came from the bank and remains intact takes separate evidence. The browser keeps the source tables and the download on your device.

Reconciliation Statement and Template

A bank reconciliation explains the difference between a bank statement and the matching cash ledger. Deposits in transit and outstanding payments are timing items. A bank fee missing from the ledger is an omission, while an incorrect amount is a recording error.

In the fictional example, the bank closes at $1,250. Add a $200 deposit in transit and subtract a $90 outstanding payment to get an adjusted bank balance of $1,360.

The ledger closes at $1,380. Subtract a $20 bank fee that is already on the statement to get an adjusted ledger balance of $1,360. Enter timing totals as positive amounts. Enter other adjustments with the sign of their effect on the balance. Check each item against the records so it enters the worksheet once.

Download the empty template to start with just the column headers. Fill one copy for the bank statement and another for the ledger, then load both in the tool.