How do you reconcile the bank statement in minutes, not hours?
The statement imported as CSV or Excel, duplicates flagged, the obvious matched automatically, a real entry in the payments journal, the 91-day position and the “Unreconciled” figure.
What you get
- Statement reconciliation in minutes instead of hours at month-end.
- A 91-day position where nothing is counted twice.
- A visible limit of accuracy: what’s still unexplained.
Transcript
This is where the system stops taking your word for it and starts checking with the bank.
You import the statement from your online bank as it is, CSV or Excel, and the columns are recognised automatically. The direction of an operation is read in three forms: debit and credit, a signed amount, or a D or C flag. And if a line's D or C flag is empty, that line is refused: an honest refusal beats a minus sign silently flipped.
Importing the same file again breaks nothing: lines already known are marked as duplicates. But two genuine, identical fuel fill-ups on the same day stay two.
The obvious ones, the system reconciles on its own: a client transfer with the exact amount and the invoice number in the wording. Recurring expenses are classified by rules. For everything else, the system only suggests: a person links the money to the document.
Reconciling an invoice isn't ticking "paid": it's a real entry in the payments journal. The expected payment is closed by the actual one, and the ninety-one-day position no longer counts that money twice.
The position's fifth number is "Unreconciled": money on the account that no document explains yet. Enter the balance printed by the bank, and any gap shows at once. That is the honest limit of your forecast's accuracy.
Statement reconciliation: minutes instead of hours at month end.