Can I download sample CSV files?

Yes. The how-to page includes small sample File A and File B CSV downloads so you can test the reconciliation workflow.

What should I check before uploading files?

Use one header row, remove report clutter, confirm amount columns, and agree the matching key before running reconciliation.

Yes. FireLookup supports exact, fuzzy, one-to-many, and many-to-many matching workflows.

Sample files

Download the examples, upload them into FireLookup, choose invoice ID as the key, and review the matched and unmatched rows.

Spreadsheet Reconciliation Guide

Follow these steps to prepare your files, run reconciliation, review exceptions, and export cleaner results.

01
Prepare your files
- Make sure row 1 contains your column headers.
- Use supported file types (.csv, .xlsx, .xlsm, .ods or .numbers).
- Keep each file under 10 MB.
- Place the upload table on the first non-empty sheet if your workbook has multiple tabs.
02
Choose your key fields
- Select stable identifiers such as reference number, invoice number, transaction ID or date + reference.
- Keep date, ID, reference and description formats consistent across both files.
03
Preview and run
- Review detected headers and preview rows before running reconciliation.
- Confirm the right columns are selected and correct any issues.
04
Review and export
- FireLookup categorises matches and unmatched rows automatically.
- Download matched and unmatched packs in .xlsx, .numbers, .ods and .csv formats.
05
Pro tips
- Don’t include amount columns in the reconciliation key unless necessary.
- Remove repeated header rows and subtotal/grand total lines from your data.
- Avoid text-heavy amount values (e.g., “Paid 1200” or “USD 1200 CR”).

Start free and run your first Excel or CSV reconciliation with 1,000 included row credits.

Explore more

Explore pricing, reconciliation guides, and support resources for teams comparing Excel and CSV files with an audit trail.