Analistable

Match customers to every invoice

Match one customer to many transactions. Total amounts, list invoices, and identify unmatched records without lookup formulas.

First file

Second file

How it works

  1. 1. Choose two tables

    Add your customers and transactions from Excel or CSV.

  2. 2. Choose matching fields

    Select identifiers and optional amounts, dates, and invoice references.

  3. 3. Review and export

    Check every match and unmatched transaction. Sign in to download Excel or CSV.

Frequently asked questions

Does this keep every invoice match?

Yes. Every matching transaction contributes to the count, total, latest date and item list.

Are approximate matches automatically accepted?

No. Approximate matches are explicitly flagged for review; totals remain provisional.

Doing this every period-end?

Save the job once and rerun it next period with new files in one click.

Create a free account