Reconciling items register
- 4 reconciling items, GBP 8,615 gross.
- Needing an entry: 0 items, GBP 0.
- Explained as timing or error elsewhere: 0 items, GBP 0.
Financial Intelligence · Expanded Financial Intelligence
Bank-to-Ledger Reconciliation
Match authorised bank transactions, accounting records, settlements and invoices, and find entries that are unmatched, duplicated, missing or delayed, with the matching…
Demonstration: Fernhill Packaging Ltd (fictional) · Manufacturing. Fictional data and a scripted answer.
The situation
- Organisation
- Fernhill Packaging Ltd (fictional)
- Who is asking
- Financial controller
- Industry
- Manufacturing
- What happened
- The March bank reconciliation has lines that do not agree, and the close is due in two days.
The question asked
Which lines in the March bank statement do not agree with the ledger, and which of them actually need an entry?
What it reads, and who can see the result
- Bank statement, March fileA read-only CSV export from the bank portal.
- Ledger cash account, March exportThe cash account's transactions from the accounting system, read only.
- Reads
- The two exports the controller attaches: statement lines and ledger cash lines for one account and one month.
- Does not read
- Other accounts, payroll detail, or anything in the bank portal beyond the statement file.
- Permission
- The controller attaches the files for this review. Nothing is connected to the bank.
- Who sees it
- The controller and the finance team lead can see the result.
Try it
Review each flagged record: confirm it or dismiss it. The totals and the answer below follow your decisions.
| Date | Reference | Description | Amount (GBP) | Finding | Decision |
|---|---|---|---|---|---|
| 03 Mar | BACS-4410 | Receipt, Hollins Print | 12,400 | Matched | None needed |
| 05 Mar | DD-0931 | Insurance premium | 1,850 | Matched | None needed |
| 07 Mar | CHQ-2207 | Cheque to Calder Pallets | 2,400 | In the ledger, not on the statement: the cheque has not been presented | |
| 11 Mar | BACS-4422 | Receipt, Nettle & Co | 5,000 | On the statement, not in the ledger | |
| 14 Mar | FEE-0314 | Bank charges | 35 | Bank fee not booked in the ledger | |
| 18 Mar | BACS-4431 | Payment, Orrin Films | 3,210 | Matched | None needed |
| 21 Mar | BACS-4440 | Payment, Orrin Films | 1,180 | Posted twice in the ledger, paid once | |
| 25 Mar | BACS-4455 | Payroll | 28,900 | Matched | None needed |
| 28 Mar | BACS-4461 | Receipt, Hollins Print | 7,750 | Matched | None needed |
- Flagged
- 4 of 9 · GBP 8,615
- Needs action
- 0 · GBP 0
- Explained
- 0 · GBP 0
- Undecided
- 4 · GBP 8,615
The answer
Simulated answer. Written for this fictional case, not produced by a live model. Only the figures in it are computed, from what you decided above.
5 of 9 lines agree. 4 do not, worth GBP 8,615 in all.
The differences are not all errors. The unpresented cheque is a timing difference that clears by itself [S2]; the unbooked bank fee and the receipt missing from the ledger need entries [S1]; the second Orrin Films posting is a duplicate that the ledger, not the bank, got wrong [S2].
You have marked 0 as needing action (GBP 0) and 0 as explained (GBP 0). 4 remain undecided (GBP 8,615); the reconciliation is complete only when that reaches zero.
Relies on: S1 · March bank statementS2 · March ledger cash account
Review and approval
The financial controller decides. Approving records which differences need a correcting entry. It does not post anything and does not move money.
Not ready to approve. 4 flagged differences are still undecided. Confirm or dismiss each one first.
In the product this is a different person with the right permission. Here you play that role to see the rule.
What it produces
Reconciliation sign-off
- Each flagged line points to the statement or ledger line it came from.
- The sign-off covers the decisions shown here and is withdrawn if any changes.
Limits of this example
- Matching uses the files supplied: a bank charge that appears in neither file cannot be found.
- A timing difference is only assumed to clear; the next month's statement is what proves it.
- This is a scripted demonstration on fictional data. No model was called and no real organisation, person or result is shown.
More in Financial Intelligence
- Overview and reportingLeaders see finance through spreadsheets that disagree, assembled by hand before every meeting.
- Revenue and profitabilityRevenue leaks quietly, and it is hard to see which customers, products or sites actually make money.
- Costs and optimisationSpend grows across suppliers, licences, cloud services and people with no single place to see what is wasted.
- Financial governanceCash, risk and unusual transactions are watched by different people with different tools, and action is slow.
- Revenue AssuranceFind possibly unbilled deliveries, missing invoices, incorrect contract pricing, expired entitlements, missed renewals and other revenue leakage.
- Multidimensional Profitability IntelligenceCalculate supported profitability and margin by customer, contract, project, product, location, department and business unit, respecting the accounting and allocation as…
- AI Cash-Flow ForecastingProduce source-backed cash forecasts with scenario ranges and cash-shortfall warnings, showing assumptions, confidence limits and forecast against actual.
- Contract-to-Invoice VerificationCompare contracts, purchase orders, agreed rates, invoice charges, quantities, tax and payment terms, and surface exceptions for review.
The Financial Intelligence story · This capability in the full register