Skip to tool
MM/FINIMO
MM/FINIMOAI in FP&A, the controlled way

Bank reconciliation, leftovers explained

Reconciliation Monitor

A bank rec that explains itself, up to the point where a person has to sign. Helix's main operating account, October 2026: 160 bank lines against 167 GL lines.

Helix Consumer Goods is a fictitious company. Every figure is synthetic.

Main operating account · EUR · October 2026Statement date 31 Oct 2026
0%
match rate
Unmatched bank0
Unmatched GL0
Oldest open item0days
Unexplained difference, EUR0.00

Match rules

They run in this order. Each rule sees only what the last one left.

Rules only pair lines. They never explain a leftover, and they never post anything.

Use your own file

Run the same rules on your lines

One CSV with a source column that says bank or gl on each line. Or two CSVs, one with bank or statement in its name and one with gl or ledger. The four rules run as above, each leftover gets a cause drafted by the page's fixed rules (no AI model is called), and a named reviewer still accepts each one.

or drop one or two files here

Your file stays on this device. The page reads it in your browser and keeps nothing when you close the tab.

Match rate as the rules are added

What the rules leave

Leftovers, aged

Each leftover gets a drafted cause, a confidence and its candidate matches, from the page's fixed rules. In your own rec, this is the step an approved AI assistant can draft. A named reviewer accepts it, or not.

The tie-out

Reconciliation statement

GL closing balance, plus outstanding items and adjustments, must equal the bank closing balance. The block stays amber until the difference is 0.00 and every suggestion has a reviewer.

Remaining difference, EUR

0.00
Not tied

Review log

Replicate it

Take the rec to your own lines

One copy gives you the columns to export, the four rules and the leftover causes in the order the page applies them, and a controlled prompt for the drafts. Plain text, no tool required.

1 · The dataSeven columns, one row per bank line or GL cash line. Source, date and amount are required.
2 · The rulesFour match rules in order, then the drafted causes for what is left, with their confidence and owner.
3 · The promptOnly the lines given, a line id for every number, nothing accepted until a named reviewer does it.

    

The lesson

Match by rule, explain by name

  1. Matching is mechanical; explaining the leftovers is judgement. The four rules take the match rate from % to %. The unexplained difference stays at until someone explains what is left.
  2. Every accepted suggestion needs a name. A drafted cause is a hypothesis. The log records who accepted it, in which role, and what it changed in the statement.
  3. Age the open items: anything over 30 days is a question for the owner, not the bank. A cheque still open after days will not clear by waiting. Ask the AP lead whether the payee ever received it.

Where to start

Export last month's unmatched items and sort them into four buckets: timing, fees, errors, unknown. Timing should clear next month. Fees get booked. Errors get corrected. Unknown gets an owner and a date.

Free series

AI in FP&A, the controlled way

Short, practical tools that show finance teams where AI really helps, without losing lineage, approvals or the controller's trust. Follow me on LinkedIn for the next one.

Not sure where to start? Take the 10-question AI Reality Check