Commercial financial spreading for every related entity, each figure one click from its page
Every related entity spread in hours, each number linked to its page.
See one case, screen by screen ↓Spreading is moving every figure from a borrower’s tax returns, CPA statements and interims into the bank’s own template, for the operating company, every affiliate and every guarantor, then building global cash flow and the ratios. Commercial Financial Spreading has six agents do that work and pin each figure to its page; the credit analyst reviews and signs.
How to choose AI solutions for lending →
Updated
Before anyone can judge a commercial credit, an analyst has to spread it: every line of the business’s 1120-S, the property company’s 1065, each owner’s 1040 with its Schedule E and K-1s, three years of reviewed statements and the latest interim — keyed into the bank’s template, entity by entity, then tied out, then combined into global cash flow. For a borrower with an affiliate and two guarantor households, that is days of data entry before the first hour of credit judgement.
And keying is where spreads go wrong. One extra zero, or the Schedule E taxable income added on top of the business’s own cash flow, makes the borrower look far stronger than it is. Once the number is in a spreadsheet cell, there is no link back to the page it came from — so the senior underwriter cannot see where it came from, and next year’s analyst starts again from a blank template.
Estimated split in working days for one borrower with an affiliate and two guarantors — by hand, and with the solution once the agents have spread the package (about three hours of the analyst’s time).
Six specialist agents spread and pin every figure to its page; the credit analyst confirms, re-maps and signs.
Halvorsen Precision Machining wants a new $2.8 million equipment term loan and a $1.4 million line renewal — $4.2 million in all, with loan committee on Thursday 15 October. Here is the spread, screen by screen, in the working solution.
Priya opens her spreading queue: 9 packages, 4 credit memos due for the 15 Oct committee, 9 open exceptions. Halvorsen sits at the top — 38 of 38 documents received Friday at 16:40, four entities, memo due Wednesday 14 Oct.
When the last K-1s arrived, the package sorter sorted 38 documents — 4 entities, 3 tax years each, 412 pages, none missing. The tax return reader read 12 returns and 12 K-1s, the statement spreader spread three reviewed statements and the August interim, and the exception writer wrote 5 exceptions with their sources. 11 checks passed.
“Finished in 6 min 48 s · Friday 16:47”
No greeting, no dashboard: the operating company’s spread, FY2023 to FY2025, in Tamarack spread v4. Every cell carries a pin — amber for the tax return, blue for the reviewed statement, a ring for a calculated line. Five lines wait for her, and two mapping rules carried over from Owen Pritchard’s Excel spreads already apply.
“Whole dollars · 1,186 figures across the four entities, each pinned to its document, page and line”
She hovers 2025 officers’ compensation, $620,000, and page 1 of the Form 1120-S slides in with line 7 boxed. The tax return reader ties it to the reviewed statement, page 4, and to Form 1125-E: Erik Halvorsen $420,000 plus Marcus Delacroix $200,000, the same as both W-2s. She confirms it.
Form 1120-S line 11 shows $480,000, $480,000 and $504,000 of rent paid to Halvorsen Properties LLC. The template put it in 6310 Occupancy — third party. She moves it to 6320 Rent — affiliate, which global cash flow eliminates.
The re-map becomes a rule at the top of “What this borrower’s spread has learned”, with Priya’s name. It maps the line on the FY2026 annual review package, due 15 Mar 2027, before anyone opens it — on this borrower and its related entities only.
“Re-mapped to 6320 · learned for every later Halvorsen spread”
Selling, general and administrative is one line on the reviewed statement and three on the return. She splits FY2025’s $1,840,000 into salaries and wages ($1,019,000, line 8), taxes and licenses ($145,000, line 12) and other operating expenses ($676,000, line 19). Each part keeps its own pin; the total and EBITDA do not change.
Last year’s method added the owners’ Schedule E income — $591,000 — on top of the entities’ own cash flow. Halvorsen Properties shows $286,000 on Schedule E, but its K-1s show $96,000 paid out. Counted once, cash available of $2,332,000 covers $1,588,430 of debt service 1.47x — and on the trailing twelve months business coverage is 1.16x, below the 1.20x policy.
Pass-through income is counted once, at the entity — K-1 cash, never Schedule E.
Schedule E is not cash. Distributions counted once. The interim balance sheet is $50,000 off — an advance to Erik Halvorsen on 18 Jun 2026, found in the ledger detail and added as due from shareholder. Margin slipped to 21.8%. Marcus Delacroix’s PFS is 19 months old. She accepts the adjustments, notes the rest for the credit memo and signs.
The relationship is above the analyst’s $1,000,000 limit, so Walter Brandt co-signs. Priya’s signature records “Spread complete and tied to source”; his records “Approved for the credit memo”. The spread goes to Thursday’s committee with every figure linked to its page.
“Four entities, 1,186 figures each linked to its page, sent to the credit memo for Thursday’s committee — under three hours after Priya opened it.”
The same Halvorsen package, seen by the four people who carry it to committee — what their week looked like, and what it looks like now.
Six specialist agents spread and pin every figure to its page; the credit analyst confirms, re-maps and signs.
Identifies every document in a borrower package — the IRS form and schedules, the CPA statement and its level, interims, debt schedules, personal financial statements — and matches each to its entity by name and EIN, and to its tax year.
Reads 1120-S, 1065, 1120 and 1040 returns with every schedule, K-1, Form 8825 and Form 1125-A/E, and ties them: K-1s to Schedule K, Schedule E to the K-1s, Form 1125-E to the W-2s, Schedule L to the CPA balance sheet, Schedule M-1 to book income.
Maps audited, reviewed, compiled and interim statements to the bank’s chart of accounts by the uniform method, foots every statement and rolls equity forward.
Combines the borrower, its affiliates and each guarantor household by the bank’s method, eliminates payments between entities and sets cash available against pro forma debt service.
Computes ratios, the trailing twelve months and peer comparisons, and flags swings beyond the threshold.
Writes each failed check with the figures on both sides, the pages they came from and what it does to coverage, and drafts the request that would clear it.
Signs; a senior underwriter co-signs above $1M. The agents propose; a named person decides.
The analyst can ask about anything in a spread in plain words — or tell it what to request. Every answer points to its page.
Why is global coverage 1.47x and not 1.84x?
Last year’s spreadsheet added the owners’ Schedule E income — $591,000 — on top of the entities’ own cash flow. That is taxable income, and its cash is already in the business and property numbers. Halvorsen Properties is the clearest case: $286,000 on Schedule E, but its K-1s show only $96,000 paid out. Counted once, cash available is $2,332,000 against $1,588,430 of debt service: 1.47x.
What changed in the August interim?
Margin. Gross margin was 21.8% for the eight months against 25.2% a year earlier — mill surcharges on bar stock under the fixed-price Corvane Aero agreement, repriced from 1 Oct. Inventory rose 32% to $2,840,000 and the line is 94% drawn. On the trailing twelve months business coverage is 1.16x against the 1.20x policy; global holds at 1.31x.
Does the interim balance sheet tie?
Not as presented. Total assets read $11,774,000 against liabilities and equity of $11,824,000. The $50,000 is a check to Erik Halvorsen on 18 Jun 2026, booked to ledger account 1350, which the interim template never picks up. I added it as due from shareholder and took it out of tangible net worth.
Request the September interim, the repricing letter and Marcus’s updated statement
Sent, due Wednesday 14 Oct: the September interim and the Corvane Aero repricing letter, and the terms of the $50,000 advance, to Dana Kowalczyk; an updated personal financial statement to Marcus Delacroix — his is dated 14 Mar 2025. Three exceptions are now marked as requested.
13 screens from the working solution, on its sample data. Pick one to see it large.
The template and the credit policy every spread is built on are settings. Changes are versioned, on the audit trail, and apply to spreads started after them.
| Setting | Default | Choose from |
|---|---|---|
| Template and chart of accounts | Tamarack commercial spread v4 · 214 lines | Commercial v4 · agricultural v2 · real estate holding v3 |
| Which statement leads | CPA statement, tax return tied | CPA statement leads · tax return leads |
| Tie tolerance | $1,000 | $250 · $500 · $1,000 · $2,500 · $5,000 |
| Unusual swing | 2 points of margin · 25% on a line | 1 pt / 15% · 2 pts / 25% · 3 pts / 35% |
| Global cash flow method | Combined entity cash flow | Combined entity cash flow · distributions method (K-1 cash to owners) |
| Living expenses | $48,000 + $12,000 per dependant | Per dependant · $60,000 flat · from the PFS only |
| Minimum coverage | 1.20x business · 1.25x global | 1.20x / 1.25x · 1.25x / 1.25x · 1.15x / 1.00x (SBA floor) |
| Analyst signs alone up to | $1,000,000 exposure | $500,000 · $1,000,000 · $2,500,000 |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
“demo” = seen in the working solution, on its sample borrower data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (Vine Financial analysis of FFIEC/NCUA call reports, CBA of Georgia 2025 — 77% of US commercial lenders manual; 6.5% error rate of single data entry, from a published study the article cites). People, companies and borrowers named on this page are fictional — characters and sample data in the working solution.
Spreading is moving every figure from a borrower’s tax returns, CPA statements and interims into the bank’s own template, for the operating company, every affiliate and every guarantor, then building global cash flow and the ratios. Commercial Financial Spreading has six agents do that work and pin each figure to its page; the credit analyst reviews and signs.
The tax return reader reads 1120-S, 1065, 1120 and 1040 returns with their schedules, K-1s, Form 8825 and Form 1125-A/E, ties each return’s totals, and cites form, page and line for every value. It keeps Schedule E taxable income apart from K-1 cash distributions.
By the bank’s method in Settings. Payments between entities, such as rent to the owners’ property company, are eliminated; pass-through income is counted once, at the entity, as K-1 cash; and without a K-1 no cash from that entity is counted.
Yes. Every figure on the spread is pinned to its document, page and line. Hover it and the page slides in beside the grid with the line boxed, the agent that read it and what it ties to.
Yes. Every figure is mapped to a line of the bank’s own spread. When the analyst re-maps or splits a line, it becomes a rule for that borrower and its related entities, so the next annual review maps it the same way.
Yes. The agents spread, tie out and draft; they never sign a spread and never send a request without the analyst. The credit analyst signs, and above $1,000,000 of exposure a senior underwriter co-signs. Overriding an agent adjustment needs a reason, shown to the second signer.
It becomes an exception, never a plug. In the sample case the interim balance sheet was $50,000 off; the statement spreader found the advance to the owner in the ledger detail and the exception writer drafted the request for its terms.
The Agentic Solution Engine builds and deploys it from your requirements — your spreading template, your credit policy and a sample of past borrower packages — and it goes live once every quality gate has passed. We will walk you through it on your own packages first.
We’ll spread a sample of your own borrower packages into your template.