ReconFiles

Reconcile two CSV files on a shared key — a payment reference, invoice number, or transaction ID. Free, private, and runs entirely in your browser.

1Load your two files

File A ⊞ Click to browse or drop a CSV here
File B ⊞ Click to browse or drop a CSV here

2Choose how to match them

Saved mappings
Scans the actual values in each column to suggest the best key and amount pairings — useful when column names don't match.

File A columns

The unique reference used to pair rows.
Optional — enables amount-mismatch detection.

File B columns

Should hold the same kind of reference as File A.
Optional — compared against File A's amount.
Ignore below £ … and below %
A matched reference only flags as a mismatch when the difference exceeds both limits — letting small absolute rounding and small FX drift pass quietly.

3Reconciliation results

0
Matched references
0
Only in File A
0
Only in File B
0
Amount mismatches
⌕
⊘ 0 rows marked — these will be skipped from the Excel export

What is ReconFiles?

A free browser-based tool for matching records across two CSV files using a shared key — a payment reference, invoice number, or transaction ID. Built for finance teams who need to reconcile payment processor exports (Stripe, GoCardless) against accounting or CRM reports (Salesforce, Xero) without sending sensitive data to a server.

How it works

  1. Upload your two CSV files — drag and drop or click to browse.
  2. Auto-detect scans the actual values in each file and suggests the best matching columns, even when names differ between systems.
  3. Review the suggested key and amount columns, adjust if needed, set your tolerance, then click Reconcile.
  4. Export a multi-sheet Excel workbook — matched records, unmatched rows from each file, and any amount discrepancies, with VLOOKUP formulas linking both source sheets.

Features

  • Smart column detection — finds the right key even when it's called "Description" in one file and "Asperato Reference" in another.
  • FX tolerance — absolute (£) and percentage (%) thresholds so small currency conversion differences don't create false mismatches.
  • Excel export — multi-sheet workbook with live VLOOKUP formulas, frozen headers, and auto-sized columns.
  • Saved mappings — save your column configuration and reload it next month in one click.
  • Completely private — all processing runs in your browser. Your files are never uploaded anywhere.
  • Free, no account needed — open the page and start reconciling.