Missing bank entries
Book items with no bank counterpart stay on the book side.
Bank reconciliation
Upload the bank export and the cash book or GL cash account. Match cleared items, then review outstanding payments, deposits in transit, charges, and timing differences.
Sample preview
Professional sample. Fictional bank activity.
| Reference | Counterparty | Amount | Status | Note |
|---|---|---|---|---|
| CHK-3188 | Northline Rent | $4,200.00 | Outstanding payment | Issued 31 Jan, not on statement |
| DEP-902 | Counter receipts | $1,150.00 | Deposit in transit | Booked 31 Jan |
| FEE-01 | Bank service charge | $35.00 | Bank charge | Statement only |
| ACH-2210 | Harbor Supplies | $2,480.00 | Timing | Booked 2 Feb, statement 31 Jan |
Bank recs stall on items that are not wrong — they are late, charged by the bank, or entered on the other side tomorrow. A structured run separates cleared rows from the items a person still has to explain.
How it works
Step 1
Bank CSV or Excel plus cash book or GL export.
Step 2
Identify cleared date, value date, and narrative if present.
Step 3
Exact matches first; date or amount tolerance where configured.
Step 4
Outstanding payments, deposits in transit, charges, and missing entries.
Step 5
Share a result a reviewer can open without the working spreadsheet.
What this workflow is designed to do with uploaded files.
Book items with no bank counterpart stay on the book side.
Bank lines not yet in the cash book stay on the bank side.
Cheques or payments issued but not cleared remain open.
Booked receipts that have not appeared on the statement stay visible.
Statement-only fees can be listed instead of being treated as unexplained cash.
Near dates can match on tolerance when you configure that rule.
The same withdrawal or deposit posted twice is flagged.
Small amount or date differences can be classified without forcing an exact pair.
January statement versus the cash account. Cleared transfers match exactly. A $35.00 bank charge is statement-only. A $4,200.00 cheque issued on the 31st is outstanding. A $1,150.00 deposit booked the same day is in transit.
A bank rec is finished when outstanding items are explained, not when every row is forced to match. The preview below is a sample of that review surface — not live account data.
Continue with the workflows that usually sit next to this one.
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.
Turn run results into Excel, PDF, and management packs a reviewer can open.
Schedule a saved configuration. A worker runs it. People still review exceptions.
Yes. Save the recipe and, on plans that include automation, run it when the next statement is uploaded.
This page describes file-based reconciliation. You upload the statement export you already receive.
Each run is based on the files you upload. Reuse the recipe; bring forward items by including them in the next book file if that is how you work.
Upload the statement and the cash book. Review outstanding items in one place.