Loading this page.
Loading this page.
Upload the bank's own statement (BAI2) and your cash book (CSV) -- the internal record of the same account. F20 matches transaction against transaction and classifies what is left over: timing gaps, bank charges and interest not yet posted, and anything that still needs a look.
Bank reconciliation compares the bank's statement with your cash book to find missing entries, timing differences, duplicates and amount mismatches. Use this free tool to match a BAI2 statement to a cash book CSV.
Matches the statement against your cash book through a ladder of ten passes — exact transaction ID or reference first, then amount-and-date, then fuzzy text and grouped one-to-many matches — each carrying its own confidence, so a row is only left unmatched once every stronger method has had a chance at it. What's left is classified by priority-ordered rules into categories like timing difference, bank charge, duplicate or possible anomaly, each with a recommended action: an outstanding cheque is flagged to carry forward, not to investigate.
Upload the bank's BAI2 statement and your cash book CSV. Matching runs a ladder of ten passes, then classifies what is left — timing differences, bank charges, duplicates — each with a recommended action.
Open the page, drop the statement and the cash book, and read the result in the browser. Download CSV or Excel when the tool offers those exports.
Yes. There is no charge and no account required. Every tool on F20 FinanceOps runs without signing in. A run made without an account is not recorded.
No. Uploaded files are processed in memory and dropped when the response is sent. Nothing is written to disk. They are never stored.
No. Outstanding cheques and deposits in transit are expected in a bank rec. They show up as timing differences to carry forward, not as errors to reverse.
Have the bank's statement (BAI2) and your cash book as CSV. Outstanding cheques and deposits in transit are expected findings, not errors to delete before you upload. Convert the BAI2 first if you still cannot open it.
Work the exception list: timing differences to carry forward, bank charges to book, duplicates to review. Then reconcile bank to GL if the cash account is the next break, and analyse fees if the statement is heavy with charges.
Statement vs cash book is the core bank-rec step. Matching runs a ladder of ten deterministic passes, then classifies what is left. You review every exception with the rows behind it. A copilot is not doing this match. The same two files produce the same result.