Free Bank Reconciliation Tool
Paste your bank statement and payment records, map the amount and date columns, and automatically match transactions to surface discrepancies and unmatched entries.
Runs entirely in your browser · No login · No data uploaded
Paste CSV exported from your bank. First row must be headers.
Paste your internal payment collection records. First row must be headers.
How to Reconcile Bank Transactions in 3 Steps
Follow these steps to get results in under a minute
How Bank Reconciliation Tool Compares
vs spreadsheets, manual processes, and paid platforms
| Feature | UniCloud360 Bank Reconciliation Tool | Manual Excel Matching | VLOOKUP / XLOOKUP | Accounting Software |
|---|---|---|---|---|
| Dual CSV input matching | Bank + records side by side | One file at a time | Complex setup | Yes |
| Amount tolerance setting | Configurable ± value | Exact match only | Formula complexity | Yes |
| Date tolerance (processing delays) | Configurable ± days | No | Manual date logic | Fixed periods only |
| Reference / description matching | Toggle on/off | Separate lookup | Fuzzy match complex | Yes |
| Matched / unmatched split report | 3-panel tabbed view | Manual review | Flag only | Yes |
| Print-ready audit report | One-click A4 landscape | Manual formatting | Export then format | Paid tier |
| Cost | Free forever | Time-intensive | Excel expertise needed | Monthly subscription |
What Finance Teams Are Saying
Trusted by lecturers and students across Sri Lankan universities
"End-of-month reconciliation used to take two staff members a full day. We paste both CSVs, run the reconciliation, and have a clean report in 10 minutes. The unmatched entries are exactly what we need to investigate — everything else is confirmed matched."
"The date tolerance feature solved a real problem for us. Our bank processes batch transfers overnight so a payment made on the 31st appears in the statement on the 1st. Setting ±1 day tolerance means these aren't falsely flagged as unmatched."
"The amount tolerance is invaluable for handling bank charges and rounding. We set ±50 LKR and the vast majority of transactions match automatically, leaving only genuine discrepancies to investigate."
"The print report is formatted cleanly enough for an internal audit file. All three sections — matched, unmatched bank, unmatched records — are clearly separated with totals. It's saved us from manually formatting reconciliation reports in Word."