ALCO reporting where the model's inputs tie to the general ledger before a page is drafted, every move is explained by driver in the margin, and the Treasurer approves the ALCO package page by page
An approved ALCO pack in 3 days, with every change explained and cited.
See one case, screen by screen ↓ALCO Reporting is how treasury and finance assemble the ALCO package and explain NII, EVE and liquidity changes, with six agents doing the assembling, checking and explaining. The agents prove the ALM model's inputs to the general ledger before any page is drafted, explain every move by driver with each amount cited, compare every measure to the board's limits and draft the minutes. The ALM Analyst prepares, the Treasurer approves every page and the release, and the CFO approves the minutes.
AI use cases in banking: a buyer's guide to agentic AI for bank and credit union operations →
Updated
Every month treasury and finance put a 40-to-60-page package in front of the asset/liability committee: the balance sheet, net interest income and margin, NII and EVE under rate shocks, liquidity, capital, the investment portfolio, the assumptions behind the model and every measure against the limits the board approved. The ALM model runs the numbers. Everything around it — pulling the inputs, proving they match the general ledger, building the pages, writing what changed and why, comparing every measure to its limit — is done by hand in spreadsheets and slides.
So the inputs are proved to the ledger by eye on totals, or not at all, and a break is found after the pages are built. The commentary describes a move ("NIM fell 9 bp") instead of explaining it. An exception is noticed at the meeting, without a cause, a plan or an owner. Members' questions arrive by email and are answered without sources, and the minutes are typed a week later with the decisions and owners left vague. ALCO Reporting puts six agents on that work and keeps every decision with a named person.
Estimated split for one monthly package at a community bank, by hand and with the agents: our arithmetic from the steps above, kept modest. The ALM model's own run is not counted, because it stays in the model. The 3-day total is a design target, measured in a pilot.
Six agents reconcile, draft, explain, check limits, answer and minute; the ALM Analyst prepares, the Treasurer approves every page, the CFO approves the minutes.
Tessaly Community Bank, $3.4 billion in assets, prepares its October 2026 ALCO package on September 30 data. The committee meets on Tuesday, October 20, and the package goes to members on Friday, October 16. Here is the month, screen by screen in the working solution.
The Pack agent loads the ALM run and ten other sources and runs 14 checks against the general ledger and the core. Loans in the model are $2,526.24M; in the ledger, $2,540.45M: a $14.21M break, 0.56% against a 0.25% tolerance. It holds the 21 pages that depend on loans and drafts the other 25. On Monday Elise Marchetti adds the participations to the model, Jonah Whitcombe approves the fix with RECON-FIX, and on run R2 13 checks tie and one timing difference of $2.04M goes to the Treasurer.
Accounts 1427-310 and 1427-315 were not in the model's loan extract.
Page 12 of 46, Net interest margin, August to September: 3.21%, down 9 bp from 3.30%, with a waterfall by driver. In the margin, the Change agent's notes under "What changed since the last ALCO, and why": −6 bp from deposit mix, −3 bp from partner repricing, 0 bp from asset yields, net. Along the bottom, a strip of all 46 pages marks the notes, limit items, questions and approvals.
The −6 bp note opens the core banking system's deposit migration report for September, with the cited lines marked: 2,912 customers moved $61,004,318 from non-interest-bearing demand into money market, where the weighted rate paid was 3.15%. The −3 bp note cites Schedule B of the program agreements: $412.0M of partner balances stepped from 3.40% to 3.65% on September 1.
The agent read page 12 and September's version of it, found the measures that moved, traced each one to its source and checked that the notes sum to the change. A remainder would show as unexplained and hold the page. It handed the page to Elise Marchetti and then the Treasurer, with its lowest confidence at 93% against an 85% threshold.
Notes sum to −9 bp · unexplained 0.0 bp
Base 12-month net interest income is $101.8M. At +200 bp it falls to $94.9M, −6.8% against a −10% limit: 68% of the limit used, below the 80% early-warning level. The margin splits the 0.7-point change since August into −0.5 points from the deposit mix and −0.2 points from the larger partner balances, which reprice at 80% of a rate move.
Elise Marchetti prepared page 17; Jonah Whitcombe approves it as the checker. The dialog lists what he is approving: inputs reconciled on run 2026-09-R2, three margin notes each cited, no limit item on the page. The count moves to 21 of 46 approved, and the page is released to the nine ALCO members. On the contents, 17 pages with nothing open can be approved together; 8 need a decision first.
Of 23 board limits, 21 are within, one is on watch and one is over. Quillfern Wallet, a program partner, holds $151.0M, 5.20% of total deposits against a 5.00% single-partner limit in Section 6.3 of the policy: $5.8M over, after it moved its card-program settlement float to the bank on September 8. Elise Marchetti submitted the note; Jonah Whitcombe approves or sends it back with a reason code.
Plan: sweep $8.0M to the bank's reciprocal deposit network by October 30, to 4.92% of deposits. Owner: Lena Ostrowski.
Elise Marchetti proposes shortening the partner balances' average life from 3.0 to 2.0 years, on 50.2% annualized runoff over 18 months. The agent shows the effect beside the evidence: EVE at +400 bp moves from −26.9% to −27.9%, from 90% to 93% of its limit, and NII at +200 bp from −6.6% to −6.8%. The back-test sits below it: $99.4M of NII projected, $97.6M actual, −1.8% within ±5%.
Anita Ferreira, Head of Retail Banking, asked on page 10 how much of the $61M went into the September money market promotion. The drafted answer: $47.2M, in 1,284 promotional accounts at 3.15%, cited to the money market promotion and the deposit migration report. Nothing reaches a member until Elise Marchetti releases it, within one business day.
The trail shows who, what, when, the reason code and the evidence for agents and people alike: the loan fix approved with RECON-FIX, the 21 held pages drafted on run R2, the notes on page 12, page 17 approved. It is kept and never edited, and an evidence pack can be exported for FDIC and state examiners, internal audit or the Board Risk Committee.
The same October package, seen by five people at Tessaly Community Bank: what their month looked like, and what it looks like now.
Six agents reconcile, draft, explain, check limits, answer and minute; the ALM Analyst prepares, the Treasurer approves every page, the CFO approves the minutes.
Loads the ALM run and the 10 other sources, proves the model's inputs to the general ledger and the core, drafts the 46 pages from the template, checks the release gates and stamps the version.
Explains every moved measure by driver — balance mix, rates, contract terms, assumption changes — with an amount and a citation per driver.
Compares all 23 measures to the board limits, flags the early-warning levels, and drafts each exception note with cause, plan, owner and policy section.
Compares the model's assumptions to the deposit study and to experience, shows the effect of every change on NII and EVE, and back-tests the projection and the betas.
Answers members' questions on released pages from the package's own sources, with citations.
Drafts the minutes from the secretary's notes — attendance, quorum, each decision with its owner and due date, each cited to the notes — and tracks actions to the next ALCO.
Prepares · approves every page · approves the minutes. The agents propose; a named person decides.
The assistant answers from the package's own pages and sources, cites them, and opens the screen where the decision is made.
Why did the margin fall 9 basis points?
Two drivers, and they add up to the whole move. −6 bp from deposit mix: $61.0M moved from non-interest-bearing demand into money market accounts paying 3.15%, within the same 2,912 customer relationships. −3 bp from partner repricing: the program agreements' year-two rate took effect September 1, $412.0M from 3.40% to 3.65%. Asset yields net to 0 bp: new loans added 1 bp, securities paydowns took 1 bp.
Which limits are closest to breaking?
One is already over and one is close. Quillfern Wallet is at 5.20% of deposits against a 5.00% single-partner limit, $5.8M over; the drafted plan sweeps $8.0M by October 30. EVE at +400 bp is −27.9% against −30.0%, 93% of the limit, and a note is required at 90%. The other 21 are within.
What does the partner average-life change do to the numbers?
Shortening partner balances from 3.0 to 2.0 years moves EVE at +400 bp from −26.9% to −27.9%, from 90% to 93% of its limit, and NII at +200 bp from −6.6% to −6.8%. The evidence is 18 months of partner attrition: 50.2% annualized runoff. The change is with Jonah Whitcombe.
Is the package ready to release?
Only when all six gates hold: sources in, checks closed, notes and the assumption decided, every page approved and every question answered. Until then it says which gates are open; once they hold, Jonah Whitcombe can release it.
13 screens from the working solution, on its sample data. Pick one to see it large.
The calendar, tolerances, thresholds and retention are settings the administrator holds. Each change is saved as a new version with a reason, and a change to a board limit opens a new policy version the board must approve before it is used.
| Setting | Default | Choose from |
|---|---|---|
| Meeting calendar | Monthly, the third Tuesday, 8:00 a.m. | Third Tuesday, second Tuesday or quarterly |
| Release lead time | 2 business days before the meeting | 2, 3 or 5 business days |
| Rolling release | On | On or off; when on, members read each page as soon as the Treasurer approves it |
| Reconciliation tolerances | Balances 0.25% · income $0.25M · rates 2 bp | Set per check; a break holds every page it touches |
| Confidence threshold | 85% | A note below it is held for the ALM Analyst before the page is drafted |
| Early-warning level | 80% of a limit | Reported to ALCO at this share of a limit |
| Written note required at | 90% of a limit | The Limit agent drafts a watch note |
| Retention | 7 years for packages, minutes and the trail; 5 years for source extracts | 7 years / 5 years or 10 years / 7 years, following the bank's record schedule |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
Sources: Risk.net, "EVE and NII dominate IRRBB limit-setting", 2025 benchmarking (89% of banks use NII sensitivity as a primary measure; batch processing and Excel still pervade ALM, and about one lender in four plans technology upgrades) · Federal Reserve SR 10-1 and FDIC FIL-2-2010, Interagency Advisory on Interest Rate Risk Management, January 2010. "demo" = seen in the working solution, on its sample data · "target" = design goal, measured in the live solution · "typical" = published figures · "estimated" = our arithmetic, kept modest. Tessaly Community Bank, its program partners, its balance sheet and the people named on this page are fictional: characters and sample data in the working solution.
ALCO Reporting is how treasury and finance assemble the ALCO package and explain NII, EVE and liquidity changes, with six agents doing the assembling, checking and explaining. The agents prove the ALM model's inputs to the general ledger before any page is drafted, explain every move by driver with each amount cited, compare every measure to the board's limits and draft the minutes. The ALM Analyst prepares, the Treasurer approves every page and the release, and the CFO approves the minutes.
In the working solution, the October package has 46 pages in 13 sections, drawn from 11 sources: the balance sheet, net interest income and margin, NII and EVE sensitivity under rate shocks from +400 to −400 bp, liquidity, capital, the investment portfolio, the assumptions and their back-tests, every measure against the board's limits, and the actions from the last meeting. Each page lists the sources it draws on.
The Change agent splits each move into drivers — balance mix, rates, contract terms, assumption changes — each with its amount and a citation to the source passage. The amounts must add up to the move: on the margin page, −6 bp from deposit mix and −3 bp from partner repricing explain the 9 bp fall, with 0.0 bp unexplained. A remainder would hold the page for a person.
Before any page is drafted, the Pack agent runs checks of the model's inputs against the general ledger and the core banking system, each with a tolerance — 0.25% for balances. A break holds exactly the pages it touches and names the accounts behind it; in the working solution a $14.21M loan break held 21 pages until the ALM Analyst fixed the input and the Treasurer approved the fix.
No. The calculation of NII, EVE, gap and liquidity stays in your ALM model; the agents read its run. They never change a model figure or an assumption in the model: an assumption change is proposed by the ALM Analyst, shown with its effect on NII and EVE, and approved or rejected by the Treasurer.
Yes. The Minutes agent drafts the minutes from the secretary's notes — attendance, quorum, each decision with its owner and due date — and cites every item to a note line. Only the CFO, as chair, approves them. Actions are tracked to the next ALCO, listed on page 2 of the next package, and an overdue one is escalated to the CFO.
Yes. The agents prepare, check and explain; they never approve a page, release the package, resolve an exception or change a limit. The Treasurer approves every page, exception note and assumption change with a reason code, members read released pages only, and every step is on a trail that internal audit can export.
The Agentic Solution Engine builds and deploys it from your requirements and documents — your package template, board policy and limits, ALM model output and ledger extracts — and it goes live once every quality gate has passed. We will walk you through it on one month of your own data first.
Every key assumption checked against what members actually did, with proof for examiners.
1-min demoLiquidity Risk MonitoringEvery morning, each liquidity move explained by the accounts behind it, before 7:30 a.m.
1-min demoContingency Funding PlanA plan that works on the day it is needed, with every line tested and every loan counted.
1-min demoWe'll run ALCO Reporting on one month of your ALM model run, general ledger and board limits, and show you the notes it writes on your margin.