Spreadsheet reconciliation

Compare two CSV files and export matched and unmatched rows

FireLookup compares two CSV files as reconciliation data, not as a developer-style text diff.

Sample output

Matched and unmatched review

Audit trail
INV-1001PAY-8841Matched
INV-1002 + INV-1003DEP-9004Grouped match
INV-1004-Missing from File B
No formulas or macros required
Source files stay unchanged
Matched and unmatched exports
Audit trail for review
1,000 free row credits

Who this is for

Built for spreadsheet-heavy reconciliation

CSV-heavy teams reconciling bank, e-commerce, payout, invoice, and accounting exports.

Teams comparing files exported from banks, ERPs, CRMs, payment processors, marketplaces, or spreadsheets.

Excel-heavy users who want less formula maintenance and a clearer review output.

Manual workflow in Excel

What teams do manually today

Users open CSV files in Excel, clean headers, choose a key, and run lookups in both directions.

Users usually add helper columns, normalize text and dates, run XLOOKUP or SUMIFS, then filter the remaining exceptions.

The workbook becomes harder to hand off when logic is hidden across copied formulas, pivot tables, or Power Query steps.

Where manual reconciliation breaks

The common failure points

CSV comparison gets noisy when date formats, casing, delimiters, or duplicate IDs differ between exports.

Duplicate keys, timing differences, messy descriptions, and gross-vs-net amounts create false exceptions.

Grouped or fuzzy matches are difficult to document when every reviewer sees a different workbook view.

How FireLookup handles it

A cleaner reconciliation workflow

FireLookup compares two CSV files as reconciliation data, not as a developer-style text diff.

FireLookup keeps source files unchanged, lets you select matching rules, and separates matched from unmatched rows.

Exact, fuzzy, one-to-many, and many-to-many matching options help when the files are not simple one-row lookups.

Workflow

Step-by-step reconciliation flow

  1. 01

    Upload File A and File B without changing the source exports.

  2. 02

    Choose amount columns, matching keys, and the relationship types to test.

  3. 03

    Review matched, unmatched, and grouped results before exporting the reconciliation output.

Example

What the result looks like

File AFile BExpected result
order_id 1001order_id 1001Matched key
order_id 1003-Missing from File B
-order_id 1005Missing from File A

Preview

Screenshot placeholder

This lightweight preview shows the output structure without adding heavy media to the page.

Sample output

Matched and unmatched review

Audit trail
INV-1001PAY-8841Matched
INV-1002 + INV-1003DEP-9004Grouped match
INV-1004-Missing from File B

Comparison

Manual Excel vs FireLookup

NeedManual spreadsheet workflowFireLookup workflow
SetupHelper columns, lookup formulas, pivots, or Power Query stepsUpload two files and choose matching rules
Messy textManual cleaning before every runExact and fuzzy matching options
Grouped matchesSUMIFS, pivots, and manual reviewOne-to-many and many-to-many grouped matching
Review outputSeparate tabs and copied filtersMatched and unmatched exports
Audit trailNotes depend on workbook disciplineRun history and match logic are easier to hand off

FAQ

Common questions

Practical answers for finance and operations teams evaluating this reconciliation workflow.

Can FireLookup help with compare two CSV files?

Yes. FireLookup is built for two-file Excel and CSV reconciliation with exact, fuzzy, grouped, matched, and unmatched review workflows.

Do I need formulas or macros?

No. FireLookup runs the comparison in a guided workflow, so you do not need to maintain VLOOKUP, XLOOKUP, SUMIFS, helper columns, or macros.

Can I test before paying?

Yes. New accounts include 1,000 free row credits so you can test the workflow with a real reconciliation.

Start with 1,000 free row credits

Upload two files, run a reconciliation, and review matched and unmatched rows before paying.

Start reconciling

Related pages

Keep exploring FireLookup