- Before
- Keys three months of volumes into a spreadsheet, guesses at the value of each service, and builds the pro forma by hand against a price list in another system.
- Now
- Opens a statement already annotated, with every value cited and the arithmetic shown; spends her time on which services to put in and what to say about the price.
One treasury management proposal, from three statements to a signed-off price
Calder Brook Veterinary Partners — 14 clinics, 420 staff, $47.2 million of revenue — is a prospect of Tessaly Community Bank, referred by the relationship manager who has a $6.4 million request in process. Three cycles of statements from their current bank arrive on October 14. Here is the afternoon of October 21, from the officer's screen. Every name and number is from the working solution's sample data.
- 012:26 PM
Their own statement, with the agents' notes in the margin
Renata Villalobos · Treasury management officerThe statement is on screen as a page, at the size you would read it, with their bank's name removed. Down the margin the agents have written five notes against the lines they came from: 612 paper checks a quarter, $1,142,380 of checks issued with no payee verification, 38 incoming wires at $15.00 each, $1,420,000 of collected balance earning $0.00 of credit, and card settlements arriving net of processor fees. Each note names the service that answers it and what it is worth a year.
Seven agents read 18 statement pages, grouped 2,689 items into four flows and found five things. One page could not be read and one document is missing — neither figure is in the total.
- 022:27 PM
Every value opens the statement line behind it
Renata VillalobosShe clicks the checks figure. The source opens on what the agents read across all three cycles — June 198 items at $374,210, July 210 at $386,710, August 204 at $381,460; the quarter 612 items and $1,142,380, annualized to 2,448 checks and $4,569,520 — with the confidence and who opened it. Nothing in the proposal is a number she cannot put in front of a chief financial officer.
- 032:28 PM
What each service is worth, with the arithmetic shown
Renata VillalobosACH payables saves $3,960 a year, and the page says exactly how: the Flows agent grouped the check detail into 318 payees and found 184 of them already accepting an electronic payment, which is 2,200 of the 2,448 annual checks, at $1.80 saved each — the published median cost of issuing a check less an ACH payment. Positive pay carries no saving at all, only the exposure it covers: $4,569,520 of checks issued a year. Moving the 152 incoming wires a year to $12.00 is worth $456, and the earnings credit on their own balances is worth $15,406 — $19,822 in all.
- 042:28 PM
One value the agents refuse to count
Renata VillalobosThe card settlements arrive net of processor fees, so the effective rate cannot be read from the statement. The Recommendation agent's confidence fell to 0.62 against a 0.90 threshold, so it asked instead of answering: about $14,350 a year stays out of the total, the card processor statement is named as the thing it needs, and the request to the prospect is already drafted for her to send.
About $14,350 a year is excluded from the $19,822 until the document arrives.
- 052:29 PM
Eighteen pages, and the one that failed
Renata VillalobosEvery page says what was read, at what confidence, and whether a figure in the proposal depends on it. July page 4 arrived as a photograph taken at an angle; it is listed as unreadable, no figure is taken from it, and the re-scan request naming the page and what it needs is written and waiting for her to send. The screen also states which privacy rules govern the pack she is holding.
- 062:30 PM
Priced at the bank’s own list, and tested against her authority
Renata VillalobosNineteen services at price list v14, each with its service code, volume, list price and proposed price: $1,145.00 a month against $1,329.41 at list. The discount is 13.87%, her authority is 10%, and the floor is $1,196.47 — so the pro forma says, before she can do anything else, that this is a pricing exception and who has to approve it.
- 072:30 PM
The earnings credit rate, worked out on their own balances
Renata Villalobos$1,420,000 investable at 1.10% over a 30-day cycle is $1,283.84 — the formula is on the screen, not behind it. Against $1,145.00 of monthly service charges that is a net credit of $138.84: the whole package is covered by balances they already keep, and today they pay $812.50 a cycle for less, with no earnings credit at all.
- 082:31 PM
Sent for approval, with the reason attached
Renata VillalobosFirst she declines one thing the agents raised: collecting the 9,400 wellness plans by ACH debit needs an exposure limit assessed before a file moves, so it is held for a second phase with reason DR-4 on the record. Then she sends the price for approval under PX-2, relationship value, with the $6.4 million request in process written where the manager will read it.
- 092:48 PM
A named person approves the price, and says why
Garrett Okonkwo · Treasury sales managerHe sees what he is being asked for and what it buys: $19,822 a year found on the prospect's own statements, an earnings allowance of $1,283.84 a cycle, a net position of $138.84 in credit. He approves as priced, AP-1, with his own reason — and if he had drafted the proposal himself the system would have routed it one level up instead.
- 102:53 PM
The proposal goes out the same afternoon
Renata VillalobosWhat we read, what we found and recommend, what it costs and what happens next — in plain words, with the arithmetic written out and nothing in it that is not from an accepted recommendation or the approved price. It could not have been sent before 2:48, and the record says so: approved by Garrett Okonkwo, AP-1, valid to December 20.
$19,822 a year found, a price a manager signed for, and a proposal sent seven days after the statements arrived.