Statement versus book
The bank file is what cleared. The cashbook or GL file is what you posted. Unmatched bank items are often timing. Unmatched ledger items are often missing deposits or unpresented payments.
Free tool
Upload the bank file and the ledger export, map reference, and optionally date and amount. This is a basic match, not a period close.
The checker does not create journals, mark items cleared in a bank account, or apply accounting treatment. It reports what matched on the columns you chose.
No file selected yet.
The checker does not create journals, mark items cleared in a bank account, or apply accounting treatment. It reports what matched on the columns you chose.
The bank file is what cleared. The cashbook or GL file is what you posted. Unmatched bank items are often timing. Unmatched ledger items are often missing deposits or unpresented payments.
A cheque issued on the last day of the month can sit unmatched until it clears. The free checker will not apply a date window unless you include date in the key.
Seeing an unmatched row does not post a correcting entry. Use AuditExport when you need review, assignment, and a report for the file.
Continue with the full workflow, or try another free check.
Compare the bank statement with the cash book or GL and review outstanding items.
Work the rows that did not match — status, comments, assignment, and history.
Present in both, missing from either side, and possible duplicates
Rows only in file A, only in file B, matches, and changed rows when a key is set
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 those columns exist in both files. Matching is still exact — there is no date window or amount tolerance here.
Take the same exports into AuditExport when you need review, reports, and a repeatable close checklist.