- 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 each value cited and the arithmetic shown, and spends the time on which services to put in and what to say about the price.
Three cycles of statements to an approved treasury proposal in seven days
The prospect, a veterinary group with 14 clinics, 420 staff and $47.2 million of revenue, was referred to the bank by the relationship manager who has a $6.4 million request in process. Three cycles of statements from its current bank arrived a week earlier. Here is one afternoon, from the officer's screen. Each number is from the working solution's sample data.
A worked example on sample data. Names, IDs and figures on the screens and in this section come from the demo.
- 01Early afternoon
Their own statement, with the agents' notes in the margin
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, and neither figure is in the total.
- 02A minute later
Each value opens the statement line behind it
Treasury management officerThe officer 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 the officer cannot put in front of a chief financial officer.
- 03The value
What each service is worth, with the arithmetic shown
Treasury management officerACH 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, or $19,822 in all.
- 04The gap
One value the agents refuse to count
Treasury management officerThe 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 document it needs, and the request to the prospect is already drafted for the officer to send.
About $14,350 a year is excluded from the $19,822 until the document arrives.
- 05The pages
Eighteen pages, and the one that failed
Treasury management officerEach 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 to be sent. The screen also states which privacy rules govern the pack the officer is holding.
- 06The price
Priced at the bank’s own list, and tested against the officer's authority
Treasury management officerNineteen services at version 14 of the price list, 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%, the officer's authority is 10%, and the floor is $1,196.47. So the pro forma says, before anything else can happen, that this is a pricing exception and who has to approve it.
- 07The credit
The earnings credit rate, worked out on their own balances
Treasury management officer$1,420,000 investable at 1.10% over a 30-day cycle is $1,283.84, with the formula on the screen. 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.
- 08Sending it up
Sent for approval, with the reason attached
Treasury management officerFirst the officer 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 that reason on the record. Then the price goes for approval with the relationship-value reason code, and the $6.4 million request in process written where the manager will read it.
- 09Later that afternoon
A named person approves the price, and says why
Treasury sales managerThe manager sees what 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, and a net position of $138.84 in credit. The manager approves as priced, with their own reason. Had the manager drafted the proposal, the system would have routed it one level up instead.
- 10The same afternoon
The proposal goes out the same afternoon
Treasury management officerWhat 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 the approval, and the record says so: approved by the sales manager as priced, valid for sixty days.
$19,822 a year found, a price a manager signed for, and a proposal sent seven days after the statements arrived.