Paste two transaction lists, a bank statement and your ledger, and automatically match entries by amount, date, and description so you can focus review time on the exceptions.
How matching works: this tool uses a local rule-based algorithm (amount, date tolerance, and text similarity), not an external AI model, everything runs in your browser and nothing is uploaded.
| Date | List A description | List B description | Amount |
|---|
| Date | Description | Amount |
|---|
| Date | Description | Amount |
|---|
How to use the reconciliation assistant
- Export or copy your bank statement transactions into List A, one transaction per line as date, description, amount.
- Copy your ledger or accounting system transactions into List B in the same format.
- Set a date tolerance to account for posting delays between systems.
- Click Run Reconciliation to see matched pairs plus anything left over on either side.
- Investigate unmatched items first, they're the most likely source of a real discrepancy.
How the matching algorithm works
Each transaction in List A is compared against every transaction in List B. A match requires the amounts to be equal (allowing a tiny rounding tolerance) and the dates to fall within your chosen tolerance window. Among candidates that satisfy both, the algorithm picks the closest date and highest description text overlap, then removes both transactions from the pool so no single entry gets matched twice. Anything left over after this pass appears in the unmatched lists.
Example
A bank entry dated January 5th for 45.00 described as "POS Purchase Store 12" will match a ledger entry dated January 5th for 45.00 described as "Store 12 purchase", even though the wording differs, because the amount matches exactly and the date is identical.
Frequently asked questions
- Does this tool use a large language model or AI API?
- No, matching runs entirely with a local rule-based algorithm in your browser.
- What format should I paste my transactions in?
- One per line: date, description, amount, separated by commas or tabs.
- Why didn't two transactions I know are the same get matched?
- Check that amounts are equal and dates fall within your tolerance window; widen the tolerance if needed.
- Is this a replacement for a full accounting reconciliation process?
- No, it's a first-pass triage tool; a qualified preparer should still review the results.
Bookmark this page and use it at month-end close, letting the tool handle the obvious matches frees up review time for the entries that actually need judgment.
0 Comments