Timing and cut-off
A payment can hit the bank after you exported the ledger, or a vendor can list an invoice you have not posted. Those rows are unmatched, not necessarily errors.
Free tool
Upload a ledger export and a statement, pick the reference column, and optionally amount and date. Matching is exact.
A row is present in both when the selected columns match exactly. Possible duplicates are the same key appearing more than once on one side.
No file selected yet.
A row is present in both when the selected columns match exactly. Possible duplicates are the same key appearing more than once on one side.
A payment can hit the bank after you exported the ledger, or a vendor can list an invoice you have not posted. Those rows are unmatched, not necessarily errors.
A reference alone can collide (the same cheque number reused). Adding amount makes the key stricter. The free checker still requires an exact amount, not a tolerance band.
Exact matching is the right first pass. Full AuditExport can then apply date windows, amount tolerance, and many-to-one grouping without rebuilding the file.
Continue with the full workflow, or try another free check.
Upload two or more Excel or CSV files, map columns, and separate matches from exceptions.
Exact, tolerance, fuzzy, partial, 1:N, N:1, and N:N matching with visible rules.
Matched, unmatched bank, unmatched ledger, and possible duplicates
Matched, only on the statement, only in internal records, and amount differences
Anonymous uploads are processed in memory for this check only. They are not saved to an AuditExport workspace and are discarded when the request finishes.
CSV and .xlsx, depending on the tool. Legacy .xls, password-protected workbooks, and ZIP batches are not accepted here.
The free checker accepts up to 2 files, each file up to 1.5 mb, and 2,000 data rows per file. Larger work belongs in an AuditExport workspace.
No. Files are read in memory for this check. Nothing is written back to the file you selected.
No. These pages run a limited, exact check so you can see the problem. AuditExport adds tolerance, multi-way matching, review, reports, and saved workflows.
No. The checker reports what it can see in the files. It does not post journals, close a period, or replace professional judgment.
Yes, when you map those columns. Both files need the same header names you select. Matching stays exact.
Keep going with tolerance, multi-way matching, review, and a report you can reuse next period.