What this tool does
Bank reconciliation is the process of matching every deposit on your bank statement against an invoice in your books, so you can tell which invoices have actually been paid and which are still outstanding. Most accounting platforms do not do this automatically — invoices stay marked unpaid until someone clicks the in-app payment link, even when the money already landed in the bank account via transfer.
This tool fixes that gap. Upload two CSVs:
- Your bank statement (Chase, Wells Fargo, Wise, Revolut, Mercury, any major bank — column layout auto-detected).
- Your invoice list (FreshBooks, QuickBooks, Wave, Xero, or a plain CSV with invoice number + amount).
The matcher cross-references deposit amounts against invoice amounts, accounting for partial payments, bank fees that shave a few cents off the round figure, and fuzzy counterparty names. You get a report showing paid, unpaid, and ambiguous matches you should review manually.
Why bank reconciliation matters
Without an accurate reconciliation, your accounts receivable balance lies to you. You think a client owes you $1,500 when in fact they paid two weeks ago and your books never caught the deposit. You send a dunning email. They never work with you again.
The cost of getting this wrong scales with volume:
- Under 20 invoices/month: spreadsheet works, errors are catchable
- 20-50 invoices/month: error rate climbs, accidental dunning emails become a quarterly event
- 50+ invoices/month: spreadsheet is a liability — you need deterministic matching
How the matching works
The tool runs three passes:
- Exact amount match — invoice total equals deposit amount, counterparty name matches.
- Fuzzy amount match — invoice total minus bank fees (typical 2-3% for cards, fixed for ACH) equals deposit.
- Counterparty alias match — same client paid under a slightly different name (trading name vs legal name, parent entity vs subsidiary).
Ambiguous matches surface in a manual-review queue. You decide.
Common questions
What CSV format does it accept? Any bank export. The tool auto-detects column layouts from Chase, Wells Fargo, Wise, Revolut, Mercury, ING, mBank, PKO BP, and most other major banks. For invoices, FreshBooks, QuickBooks, Wave, Xero, and Zoho exports work out of the box.
Is anything uploaded sent to a server? Files are uploaded for processing only. They are deleted after the match completes. See the security page for details.
Can I use this for VAT-inclusive invoices? Yes. The matcher handles gross-vs-net mismatches that come up under reverse-charge VAT rules (Poland, Germany, the Netherlands).
Does it work for multi-currency bank accounts? Yes for Wise and Revolut multi-currency exports. The matcher groups deposits by currency before matching against invoice currency.