How to use Bank Transaction Reconciliation
- Paste or upload bank and ledger CSVs with id, date, amount and reference columns. Use one currency and a consistent signed-amount convention.
- Choose date and amount tolerances and the maximum number of transactions in a split, then run the comparison.
- Inspect the candidates and download the review-decisions CSV template. Enter accept or reject beside each complete candidate ID you have reviewed.
- Paste the completed CSV into Reviewed decisions CSV and run again with the same data and settings. Download the reviewed matches and unresolved transaction IDs.
Example: Bank Transaction Reconciliation
A 100.00 bank transaction proposes a match with ledger rows of 60.00 and 40.00.
Supported inputs and limits
- Two CSV inputs, each up to 2 MiB and 80 rows.
- Amounts have at most two decimal places; use one currency and one signed-amount convention.
- Dates are YYYY-MM-DD from 1900 through 2200.
- Search is limited to 150,000 combinations and 2,000 candidates.
- One transaction may match up to three on the other side; many-to-many search is unsupported.
More details
Only accepted non-overlapping decisions resolve rows.
Changing data or options requires fresh review IDs.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Bank Transaction Reconciliation
Will suggested matches clear my unresolved list?
Only an explicit accept decision clears the linked transactions in this report. A matching total or reference is evidence to review, not permission to alter the ledger.
Can a payment cover several invoices?
Choose a group size of two or three. Each candidate compares one bank transaction with a group of ledger rows, or the reverse. Individual candidate approvals cannot reuse a transaction.
Why did the search stop before listing every candidate?
The combination and candidate caps prevent a large ambiguous match search from monopolizing the browser. Narrow the dates, tolerances, group size or source rows and review the smaller set.