Reconcile bank transactions from Excel or CSV files
Upload two transaction files, configure matching rules, and download matched and unmatched records for review.
Bank reconciliation often starts with two messy files: one from the bank and one from an internal system, GL, or payment report. Transaction Matcher helps finance and operations users compare these files without building complex Excel formulas or manually checking each line.
Common reconciliation use cases
- Match bank statement lines against GL transactions
- Compare deposits, payments, receipts, or settlement records
- Identify unmatched transactions that need follow-up
- Prepare a cleaner reconciliation file for further review in Excel
How it works
- Upload your bank statement file and your internal transaction file.
- Select the amount, date, and optional description fields from each file.
- Adjust matching tolerances for amount and date differences.
- Run the matching process and download the result file.
Why use this instead of manual Excel matching?
- Avoid repetitive VLOOKUP, filters, and manual comparison work
- Use finance-friendly matching rules instead of simple row-by-row comparison
- Review matched and unmatched records in one downloadable Excel file
- Keep the workflow lightweight without setting up a full reconciliation platform
Start matching your reconciliation files
Use Transaction Matcher to compare two transaction files and generate a clear matched/unmatched output.