Bank Statement Reconciliation Tool
Compare a bank statement with your ledger, review possible matches and download the reconciliation from your browser.
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.