Two-List Matcher
Paste any two lists of transactions and find what does not line up — matched pairs, exceptions on each side, and duplicates within either.
Nothing you paste leaves this page. Parsing and matching happen in your browser.
How it works
Matching runs in three passes, strongest evidence first. Items sharing a reference and an amount pair up before anything else. What remains is matched on amount within a date window, and only then on amount alone. Ordering the passes this way stops a weak coincidence consuming a record that a stronger rule would have paired correctly.
Everything left over is an exception, and exceptions are the output that matters. An item on one side with no counterpart is either timing — it will appear next period — or an error. Duplicates within a single list are reported separately, because a repeat billing and a double entry look identical to any parser and only you can tell them apart.
Pass 1: reference + amount · Pass 2: amount + date window · Pass 3: amount alone
- Tolerance — how far two amounts may differ and still count as equal
- Date window — how many days apart two entries may sit and still pair
- Exception — an entry on one side with no counterpart on the other
Worked example
A ledger of 8 entries against a statement of 8
Inputs
Results
The 18,100 difference resolves into four specific lines rather than one unexplained total — which is the entire point of reconciling.
Frequently asked questions
What format should I paste?
Copy straight out of a spreadsheet, or paste CSV. A header row is optional — columns are identified by their headings when present and by their content when not. Dates, references and amounts are detected automatically, and amounts may carry currency symbols, thousands separators or accounting parentheses.
What if the two sides use opposite signs?
Turn on sign flip. Bank exports frequently show a payment as negative where your ledger shows it positive, and without flipping, nothing at all will match.
Why did two items match that should not have?
Almost always the third pass, which matches on amount alone. Narrow the date window or make sure both sides carry references, and the stronger passes will claim those records first.
Is my ledger data uploaded anywhere?
No. Every line you paste is parsed and matched inside your browser. Nothing is transmitted to us, nothing is stored, and closing the tab discards it. That is the whole reason this tool exists in this form.
More in Reconciliation
Bank Reconciliation
Match your cash book against the bank statement and produce a proper reconciliation — outstanding items, unrecorded charges and adjusted balances on both sides.
ReconciliationInvoice vs Payment Reconciliation
Match payments received against invoices raised, and find the short payments, overpayments and unallocated cash sitting in your receivables.
ReconciliationPayment Gateway Payout Reconciliation
Reconcile what the gateway actually paid you against what your orders say it should have — with fees, refunds and missing settlements itemised.
ReconciliationGST / VAT Return Reconciliation
Match your purchase register against what your suppliers actually filed, and find the input tax credit you are about to lose.
ReconciliationDuplicate Payment Detector
Scan a payment run or a full year of ledger for payments made twice — the same supplier, the same amount, days apart.
ReconciliationAR / AP Aging Report Builder
Turn a flat list of open invoices into a proper aged report — bucketed, totalled, and sorted by how long the money has been outstanding.