- Before
- Gets a list of a few hundred unmatched lines and works them in spreadsheets and email, while cash positioning is due by 10:00.
- Now
- Opens 14 cases that need him, each with the agents' hypothesis, sources and a checked draft; asks, approves with a reason code and moves on.
One Monday morning, from 18,642 lines to a signed reconciliation
Kestrel & Vane Group runs 214 bank accounts at 11 banks across 13 legal entities. Friday 9 October's statements arrived over the weekend — 18,642 lines. Here is how Leo Grant, treasury analyst for the Americas, works them with the agents, screen by screen, in the working solution.
- 01Monday, 08:40
The agents tell him what they found, in plain words
Leo Grant · Treasury analyst, AmericasLeo's morning opens as a conversation, not a grid. The agents worked through the weekend: 18,417 of 18,642 lines matched by rule, 196 of 225 breaks cleared with cited evidence, 15 still being investigated and 14 that need him, 3 of them risk alerts. Each agent reports in its own words — the fraud sentinel on three payments that look wrong, the checker on two cases where it disagrees, the statement collector on the one bank that has not sent Friday's file.
Investigation agent: “The $18,250.00 deposit on ****4417 matches no invoice. It is two Fernwood invoices, $11,200.00 and $7,085.00, less a $35.00 intermediary charge. I am 97% sure and the checker agrees to the cent.”
- 02The casebook
Every break is a case, not a row
Leo Grant · Treasury analyst, AmericasEvery line that did not match is a case in one of four lanes: Needs you 14, Agents investigating 15, Cleared 196, Reopened 0. Each shows the bank line, the agent's working hypothesis in a sentence, the evidence tested so far, a confidence and who it waits for — Claire for the Orvella Metals wire, Owen for the Brask Logistics debit, Nadia for the Hartwig exchange rate, Leo for seven of them. The matched lines sit in one small line at the top, because they are not the story.
“18,417 of 18,642 lines matched by rule overnight, so they are not cases.”
- 03C-4417-018
Three hypotheses, two rejected and why
Investigation agentA $18,250.00 wire from FERNWOOD INC, reference “FW PMT OCT”, landed on ****4417, the operating receipts account of Kestrel & Vane Distribution at Ellisford National Bank. No open receivable is for that amount. H1, one invoice, is rejected: the nearest is Varek Tools at $18,520.00, a different customer. H3, a part payment of INV-K-40655, is rejected: it was settled on 2 Oct. H2 is confirmed at 97%: two Fernwood invoices in one wire, less a $35.00 intermediary charge.
Every test carries a numbered source; a click opens it.
- 04Replay
He watches the investigation step by step
Leo Grant · Treasury analyst, Americas“Replay the investigation” runs the agent's plan again on screen, one hypothesis at a time: it reads receivables, the remittance email, the bank statement's wire detail, Ellisford's fee schedule and the customer master, each step with what it found and how long it took. Leo sees what the agent read and in what order, not just a score.
“Plan: 3 hypotheses to test for +$18,250.00 on ****4417.”
- 05One click
The remittance behind the answer
Leo Grant · Treasury analyst, AmericasCitation 3 opens Fernwood's remittance advice, received in the remittance inbox on Thu 8 Oct at 16:42: INV-K-40731 for $11,200.00 and INV-K-40768 for $7,085.00, together $18,285.00, by wire on 9 October. The wire detail shows $18,285.00 instructed and $35.00 deducted under shared charges (SHA), and Ellisford's fee schedule §4.2 passes intermediary charges through.
“Read-only copy kept with the case.”
- 06In the case
He asks “why not Varek?”, and the draft is checked to the cent
Leo Grant and the agentsLeo asks the question he would ask a colleague. The agent answers with its sources: Varek Tools pays by ACH from ****8830, this wire came from ****2291, Fernwood's account on file, and Varek has never short-paid. Below, the adjustment drafter has applied $11,200.00 and $7,050.00 and drafted JE-D-1009-018 — Dr 6420 Bank and wire charges $35.00, Cr 1210 Trade receivables, Fernwood Inc. $35.00. The checker re-performs it on its own.
Checker: “$11,200.00 + $7,085.00 − $35.00 = $18,250.00. The break clears to $0.00. Neither invoice is applied anywhere else. $35.00 is inside the $50.00 short-pay tolerance of policy TR-7.”
- 0708:42 · approved
Approved with a reason code; the agents never post
Leo Grant · Treasury analyst, AmericasLeo approves with reason code FEE-WIRE — bank charge deducted from a wire, within tolerance — signed as Leo Grant, Treasury analyst, Americas. The case moves to Cleared, and the adjustment drafter parks JE-D-1009-018 in the ERP for posting; approved entries go to the ERP at 12:00 and 17:00. If something turns out wrong later, the case can be reopened with a note and the agents look again.
“Every decision needs a reason code and is chained in the audit trail.”
- 08Risk alerts
Three payments that look wrong, two with a clock running
Fraud sentinelBrask Logistics was debited twice, $42,816.50 — the scheduled run and a manual re-send after a timeout — and the reversal window closes Fri 16 Oct, 4 banking days left. A $118,400.00 wire went to Orvella Metals at an account changed on 6 Oct from a look-alike domain, with no call-back recorded: recall today. Cheque #20418, issued for $974.00 to Lena Marsh, was paid at $9,740.00 to “L. Marsh Services” on an account not on positive pay: report to the bank by Sun 8 Nov.
The sentinel reads matched lines too: the Orvella wire matched, but to a changed account.
- 09Drafted, not sent
The reversal request waits for the second approver
Fraud sentinel → Owen Strand · Assistant treasurerThe sentinel has drafted the request to Ellisford's ACH operations: originate a reversing entry for the duplicate payment in file PR-1009-M, keep the original in file PR-1009-A, and notify Brask Logistics in advance, as the ACH rules require. Leo sends it to Owen Strand to approve. Every recall, reversal and claim needs two people, and no agent contacts a bank itself.
“Drafted by an agent. Edit freely; nothing is sent until you approve.”
- 10Bank to book
The account ties out, every item explained
Leo Grant · Treasury analyst, AmericasWith Fernwood cleared, ****4417 shows its reconciliation from bank to book: the bank balance, each item in the bank but not yet in the books linked to its case, a $12,880.00 lockbox deposit in transit, the GL 1010 balance — and an unexplained difference of $0.00. Signing records the reconciliation as control evidence; open cases stay listed until they clear. At month end, Claire Whitcombe signs.