Free bank reconciliation tool · No signup
Compare bank and book transactions. Review matches, find differences and download a report.
01 / Set up the comparison
Use the same account, period and currency. CSV/TSV: up to 5 MB and 10,000 records per file.
In Excel, save as CSV UTF-8. Keep one header row and transaction rows only; remove titles, opening balances and subtotals. PDF and XLSX files are not supported.
Contains fictional sample data — replace both files to use your own records
Choose two files, or try the sample.
02 / Review the differences
Pairs to review
Unmatched bank records
Unmatched books records
Net movement difference
This is not a completed bank reconciliation. Equal totals are not proof: verify opening/closing balances, completeness and every pair.
| Status | Bank record | Books record | Why / review note | Action |
|---|
Pair equal signed amounts only after verifying the source, even if dates or references differ. A review note is required.
Includes every record, review note and control total. Download before leaving; in Excel, import reference columns as text to preserve leading zeroes.
First: equal reference and signed amount within your date window. Next: a unique equal-amount candidate within that window. A pair must be unique from both sides. References ignore letter case and surrounding spaces, but retain punctuation and leading zeroes.
Conflicting references, zero amounts and ambiguous candidates stay unmatched. Missing records may reflect timing differences, fees or incomplete exports. Invalid input rows block the run; none are silently skipped.
Files, mappings, notes and results stay in this tab’s memory and are cleared on reload. Site analytics record visits and successful non-sample use/downloads—not file contents or filenames.
No PDF/XLSX import, bank connection, foreign exchange, fuzzy matching, split/batch settlements, balance certification or accounting-system changes. Amounts must match to the cent. Suggested pairs are not automatic approvals.