- Before
- Reviews mapping exceptions in spreadsheets, ties tables to the ledger with bridge files and emails data owners when something does not tie.
- Now
- Opens each break with the proposal, the instruction passage and the liquidity effect already there, accepts with a reason code and sends the fix to the source.
One month of FR 2052a liquidity reporting, one break at a time
Corvane National Bank runs FR 2052a monthly in parallel ahead of crossing $100 billion. It is Tuesday, October 13, 2026, business day 8 of 10 for the September 30 run, which is due Thursday, October 15. Here is what happens, screen by screen, in the working solution.
- 0111:47 am, day 8
The whole report on one strip, and four breaks
Priya Raman · Liquidity Reporting AnalystPriya opens the September 30 parallel run: 1,899,000 position rows from 43 feeds in 13 tables, drawn as a maturity river from Open to beyond five years. Inflows run above the line and outflows below, and three gaps stand out: $43.7M above the general ledger, −$18.2M against the Call Report and a $612.0M rule break. Under the river, the breaks left today, each with an owner and a due time.
“Breaks today: 4 · 31 opened this month · 27 closed”
- 02Overnight
What the agents did before anyone logged in
The agentsThe Feed monitor found 42 of 43 feeds complete by 6:10 am. Feed F-27 delivered 3,840 of about 6,200 rows, so Derivatives & Collateral is marked provisional and the other 12 tables ran on. The Classifier proposed a classification for 14,812 new or changed positions, and the Rule agent re-checked every one, agreed with 14,789 and opened 1 rule break and 22 questions. The hand-off sent 4 breaks to their owners with due times.
Liquidity impact agent: 6 pending changes priced · 1 above $25.0M routed to the second line.
- 03One break
$612.0M of sweep deposits coded as stable retail
Classifier and Rule agentBreak BRK-0930-014: 2,846 accounts in the treasury sweep program, product code TMS-SWP-03, are reported as O.D.2 Non-Transactional Relationship Accounts under mapping rule PM-118. The Classifier proposes O.D.8 Affiliated Sweep Accounts at 0.97 confidence and splits the insured flag: $560.1M stays FDIC and $51.9M in 96 accounts above $250,000 becomes Uninsured. The Rule agent checked it on its own and agrees.
Analyst accepts · Manager approves · Second line reviews
- 04Click a source
The passage behind the proposal
Priya Raman · Liquidity Reporting AnalystEvery source chip opens what the agents read. The sweep program agreement, DOC-TMS-2291 §2.1 in document imaging, shows the sentence that makes these balances an affiliated sweep, beside the legal entity master entry LE-042 and the FR 2052a instructions for O.D.2 and O.D.8. The agents cite the agreement; they do not change it.
“At the close of each business day, available cash in your brokerage account at Corvane Investment Services LLC is transferred to a deposit account in your name at Corvane National Bank.”
- 05She asks back
“Why not O.D.9 Non-Affiliated Sweep?”
ClassifierPriya challenges the proposal in plain words. The Classifier answers that the sweeping firm is an affiliate, legal entity LE-042, and that O.D.9 is for unaffiliated firms, with numbered citations to the entity master and the instructions. Beside the conversation, the change is already priced: derived LCR outflows rise from $18.4M to $76.8M, and the derived LCR moves from 122.4% to 121.9%.
Above the $25.0M threshold, Helen Marsh reviews after the manager approves.
- 0611:50
She accepts as maker, with a reason code
Priya Raman · Liquidity Reporting AnalystPriya accepts with reason code RC-02, instruction requires a different product, and leaves a note for the checker: sweep agreement §2.1 and LE-042 confirm an affiliated nightly sweep, and O.D.2 excludes sweep deposits. The dialog tells her what happens next before she signs.
“You are the maker. Daniel Okafor approves as checker; Helen Marsh reviews because derived outflows move +$58.4M.”
- 07Approvals
Nobody approves their own change
Priya Raman · Liquidity Reporting AnalystOn the approvals queue Priya tries to approve her own reclassification, RC-0930-031, and is stopped: a different person with the Treasury Reporting Manager role must approve it. Every reclassification, top-side adjustment and break closure waits for a second person and is decided before the run's day 9; overdue items escalate to the Head of Treasury.
Policy SOD-01: the maker and the checker of any change must be different people.
- 0812:10
The checker approves and opens the source fix
Daniel Okafor · Treasury Reporting ManagerDaniel sees exactly what he is signing: 2,846 sweep accounts from O.D.2 to O.D.8, $560.1M insured and $51.9M uninsured, the sources, and +$58.4M of derived outflows. Approving opens source fix SF-0930-022 for Marisol Vega, Deposit Data Owner, due Tuesday, October 20, five business days out, and sends the change to the second line. The override retires when the source is fixed.
“Agree with the analyst. Override until the source is fixed; no top-side adjustment.”
- 09Review due October 14
The second line sees the liquidity effect before sign-off
Helen Marsh · Liquidity Risk OfficerBecause the change moves derived outflows by more than $25.0M, it waits for Helen. The derived liquidity view prices every pending change: the sweep reclass adds $58.4M to 30-day net cash outflows, moves the derived LCR from 122.4% to 121.9% and leaves the derived NSFR at 118.5%. She acknowledges it or challenges it.
“Internal view · not a filed ratio”
- 10Before the ALCO, October 22
Six parallel months, and whether the bank is ready to file
Readiness agentThe readiness view turns six monthly parallel runs into the go-live decision: breaks opened per run fell from 58 in April to 31 in September, the run now completes in 9 business days against a target of 10, and open top-side adjustments fell from 22 to 4. Nine of 12 go-live checklist items are done; Model Risk validation of the Classifier and Rule agent is one of the three still open.
The Readiness agent never marks a checklist item done without its evidence.