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. Choose two tables
Add your customers and transactions from Excel or CSV.
2. Choose matching fields
Select identifiers and optional amounts, dates, and invoice references.
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