Free Tool

Free Statement to Ledger Transaction Matcher

Paste statement and ledger CSVs to create matched pairs, review unmatched rows, and copy a mapping CSV for reconciliation work.

Tool workspace

Run the tool below, then copy or reuse the cleaned output in your spreadsheet or finance workflow.

Amount toleranceDate window (days)

• Paste one CSV from the statement and one from the ledger, each with a header row.
• Matching uses amount tolerance, date window, and cleaned description similarity.
• Copy the mapping CSV when you want a row-to-row bridge for spreadsheet review.

Statement CSVLedger CSV

Output

You will get a matched-pairs table with confidence scores, plus separate unmatched lists and a copyable mapping CSV.

Statement row	Ledger row	Amount	Date gap	Description score	Confidence
3 → 3	PAYROLL ↔ Payroll Deposit	$2,400.00	0d	65.00%	83 / 100
2 → 2	AMAZON MKTPLACE ↔ Amazon Marketplace	-$42.11	0d	33.33%	67 / 100
4 → 4	UBER TRIP ↔ Uber BV	-$18.90	1d	33.33%	57 / 100

Unmatched statement rows	Amount
None

Unmatched ledger rows	Amount
None

statement_row,statement_date,statement_description,statement_amount,ledger_row,ledger_date,ledger_description,ledger_amount,confidence,amount_difference,date_difference_days
3,2026-03-02,PAYROLL,2400.00,3,2026-03-02,Payroll Deposit,2400.00,83,0.00,0
2,2026-03-01,AMAZON MKTPLACE,-42.11,2,2026-03-01,Amazon Marketplace,-42.11,67,0.00,0
4,2026-03-03,UBER TRIP,-18.90,4,2026-03-04,Uber BV,-18.90,57,0.00,1

Input stays in your browser. No upload is required for these free tools.

Related free tools

CSV to JSON Converter JSON to CSV Converter Statement Date Normalizer Transaction Description Cleaner Duplicate Transaction Checker Running Balance Checker