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.
| Line | Effect |
|---|---|
| Bank statement balance | Start |
| + Deposits in transit | Book receipts not on the statement |
| − Outstanding cheques | Book payments not yet cleared |
| Cash book balance | Start |
| + Bank credits | Interest, direct receipts |
| − Bank charges | Fees, direct debits |
Each bank line is matched to one ledger line with the same amount within the date window, preferring a matching reference.
Receipts recorded in your books that haven't reached the bank statement yet.
Check opening balances, duplicate entries and amounts entered wrongly; the unmatched lists show where to look.
No. The files are read in your browser and never leave it.
No. Everything runs in your browser.
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.