An approver looks at a spread and stops on one number: FY2025 EBITDA of $406,895. Where did it come from? In most credit files the honest answer is that an analyst typed operating income and depreciation from a PDF into a spreadsheet template, added them, and the template did the rest. The number is probably right. But “probably” is what credit review, the approver and the examiner are all there to test, and a typed spread gives them nothing to test it against except the PDF and an afternoon.

In short

  • A spread is a set of claims about documents. Every cell says “the statement shows this”. A spread you can trust lets anyone check that claim in one click: the document, the line and the exact text.
  • Read, don’t type. InsightCredit’s document reader takes each figure from the PDF’s text layer with its line number and quote. A figure it can’t find is marked partial, never guessed.
  • Every derived number carries its formula. EBITDA, debt service, tangible net worth, the ratios, pro forma DSCR and global cash flow are computed from the spread, and the formula is shown beside the result.
  • Reconcile before you rely. The statements are tested against themselves, the tax returns, the agings, the bank deposits and the rent roll. A difference outside tolerance becomes a check a person has to resolve or waive with a reason.

Why traceability is the point

Spreading is the foundation of commercial credit analysis. The approver reads the ratios, the grade reads the ratios, the policy controls read the ratios, and the covenants written into the loan will be tested against the same lines next year. An error in the spread doesn’t stay in the spread. A transposed digit in interest expense moves the debt service coverage, which moves the grade, which can move who is allowed to approve the request.

The usual defence is a second analyst who re-keys or ticks the spread against the statements. That works, slowly, and it leaves no evidence of what was ticked. Credit review, under the Interagency Guidance on Credit Risk Review Systems (2020), is expected to test the accuracy of risk ratings on a sample of loans; examiners look at the analysis that supports repayment capacity. Both start the same way: by asking where the numbers came from.

TODAY A spread typed from the PDF

Numbers in a template. No link to the page they came from, no record of who checked them, and a formula hidden in a cell that someone may have overwritten last year.

TRACEABLE A spread built from what was read

Each cell links to its document and line; hover shows the quoted text, a click opens the PDF beside it. Each derived figure names its formula. Nothing in the spread was typed.

Reading, not typing

The document reader in InsightCredit is deliberately unglamorous. It is not a language model guessing at a page. It applies deterministic patterns to the text layer of each PDF, document type by document type, and for every field it takes it keeps three things: the value, the line number and the exact text of that line. If the pattern doesn’t find a field, the document is marked partial and the field is left empty. A scanned PDF with no text layer is refused in plain words, so nobody mistakes an image for a document that was read.

DocumentWhat the reader takes
Financial statementsIncome statement and balance sheet: 30 lines, from revenue to total liabilities and equity
Business tax returns (1120, 1120-S, 1065)Gross receipts, cost of goods sold, total income, officer compensation, interest, depreciation, deductions, ordinary income, taxable income
Bank statementsTotal deposits, the months covered, returned (NSF) items
Receivables and payables agingsEach bucket, the total, the amount over 90 days, the customers
Rent rollsMonthly rent and occupancy
Personal financial statementsTotal and liquid assets, liabilities, net worth, annual income, annual debt payments, living expenses, contingent liabilities
Appraisal summariesAppraised value, effective date, appraiser, value type

Documents come from the bank’s systems when the case is opened, or from the borrower through a secure request; a borrower’s upload is read the moment it arrives, and the spread and checks run again. The analyst’s job shifts from transcription to inspection: open the document, look at what the reader took, decide whether it is the right line.

The document viewer for a receivables aging: the PDF on the left and, on the right, what the reader took line by line, with Current 227,066, 31 to 60 days 96,066, 61 to 90 days 52,400, over 90 days 61,133 and a total of 436,665, all from line 14
What the reader took, line by line. A receivables aging beside its extracted figures. Every bucket comes from line 14, and the quote is kept with the value.

Three years, side by side

The spread lays out the latest three fiscal years of income statement and balance sheet, built only from what the reader took. Take the first request in the demo, CR-2026-000001: Tidewater Industrial Properties LLC (fictional, like every borrower, person and figure on Brightwater Commercial Bank’s demo data), a Michigan lessor of nonresidential buildings asking for a $175,000 commercial real estate loan to replace a roof and HVAC. Its statements are compiled, all three years.

LineFY2023FY2024FY2025FY2025 source
Revenue1,195,5571,143,7061,042,064financials_2025, line 8
Operating expenses461,969582,287635,169line 11
Depreciation and amortization251,822251,822251,822line 12
Operating income481,766309,597155,073line 13
Interest expense314,074325,599338,102line 14
Net income167,352(13,087)(183,240)line 18
Current portion of long-term debt149,340160,775173,627line 33
Total liabilities4,092,8654,249,7334,412,669line 37
Owners’ equity4,862,6584,430,2764,037,825line 38

Hover over FY2025 revenue and the spread shows the quote it was taken from, “Revenue ...... 1,042,064”, on line 8 of tidewater_industrial_propert_financials_2025.pdf. Click it and the document opens at that line. That is the whole idea: a figure on the spread is a pointer, not a copy.

The spread tab for CR-2026-000001 Tidewater Industrial Properties: income statement and balance sheet for FY2023, FY2024 and FY2025, compiled basis, with the note that every figure is the statement's and can be hovered for its line or clicked to open the document
The spread. Three compiled years, income statement beside balance sheet. “Every figure is the statement’s: hover for its line, click to open the document.”

Every derived number names its formula

Once the lines are read, the derived figures are arithmetic, and the arithmetic is shown. There are no hidden cells. Each derived line and ratio on the screen carries its formula; hover and you see it. These are the definitions InsightCredit uses, with Tidewater’s FY2025 results:

FigureFormulaTidewater FY2025
EBITDAoperating income + D&A155,073 + 251,822 = 406,895
Historical debt serviceinterest + current portion of LTD338,102 + 173,627 = 511,729
Tangible net worthequity − intangibles4,037,825 − 0 = 4,037,825
Funded debtLOC + CPLTD + LTD0 + 173,627 + 4,167,037 = 4,340,664
Historical DSCREBITDA / (interest + CPLTD)0.80x
LeverageTL / TNW (none if TNW ≤ 0)1.09x
Funded debt / EBITDAfunded debt / EBITDA10.67x
EBITDA marginEBITDA / revenue39.1%
Revenue growthrevenue / prior-year revenue − 1−8.9%
Current ratiototal current assets / total current liabilitiesnot computed for a property owner
DSOAR / revenue × 365not computed for a property owner
DIO and DPOinventory / COGS × 365; AP / COGS × 365no cost of goods sold

Two things in that table are policy, not arithmetic, and they are worth noticing. Leverage is not computed at all when tangible net worth is zero or negative, because a ratio over a negative denominator reads as a small number and looks healthy. And for a property owner (NAICS 5311) the current ratio and DSO are not computed and liquidity isn’t scored: the rent roll and the property carry that credit, not working capital.

The trend line summarises the three years: revenue compound annual growth of −6.6%, an EBITDA margin down 22.3 points from 61.4% to 39.1%, and historical DSCR of 1.58x, 1.15x and 0.80x. Nobody has to compute that path by hand to see the direction.

Pro forma and global: the numbers the decision turns on

Historical coverage says how the business serviced the debt it had. The approver needs to know how it will service the debt it is asking for. InsightCredit computes both pro forma measures from the spread and the request, and shows every term:

Pro forma DSCR = latest EBITDA / (latest historical debt service + the request’s annual debt service). An amortizing request is costed at its indicative rate and amortization as a level payment; a revolving line at its full commitment, interest only; an annual review adds nothing. Tidewater’s $175,000 amortizes over 300 months at 7.38%: $1,280 a month, $15,355 a year. So pro forma debt service is 511,729 + 15,355 = 527,084, and pro forma DSCR is 406,895 / 527,084 = 0.77x.

Global cash flow = (EBITDA − income tax + Σ guarantors’ (annual income − living expenses)) / (pro forma debt service + Σ guarantors’ annual debt payments), each guarantor’s figures taken from their personal financial statement.

Cash flowDebt serviceFrom
The business (EBITDA − income tax)406,895527,084the spread and the request
Neha Valdez (income 889,000 − living 326,300)562,700162,800her PFS
Danielle Russo (income 330,000 − living 127,400)202,600198,800her PFS
Global1,172,195888,6841.32x
The ratios table for Tidewater with EBITDA, debt service, tangible net worth, funded debt and each ratio by year; a pro forma DSCR panel showing 0.77x with FY2025 EBITDA 406,895, existing debt service 511,729 and the request's 15,355; and a global cash flow panel at 1.32x with the business and two guarantors
Ratios, pro forma and global cash flow. Every figure computed from the spread above, every formula printed in the panel heading.

Statements, returns,
PFSs, request terms

Reader
value, line, quote

Spread
three fiscal years

Derived lines
EBITDA, debt service,
TNW, funded debt

Ratios
each with its formula

Pro forma DSCR
0.77x

Grade and
policy controls

Guarantor PFSs

Global cash flow
1.32x

One chain from the PDF to the decision. Each arrow is arithmetic you can see; nothing in it was typed.

Tidewater tells a story the spread makes plain in a minute: the property’s own cash flow no longer covers its debt, even before the new loan, while two guarantors with $2,163,000 of liquid assets between them bring global coverage to 1.32x. Whether that is enough is a credit judgement, and the other posts in this series follow it into the grade and the policy exceptions. The spread’s job is to make sure the judgement is made on numbers everyone can check.

Reconcile before you rely

A spread traced to the statements is only as good as the statements. Company-prepared and compiled statements aren’t audited, and receivables in particular are easy to overstate. So InsightCredit tests the spread against itself and against independent documents, and every test becomes a check on the case with its evidence quoted.

TestComparesOutcome outside tolerance
Statements add uptotal assets = liabilities + equity; revenue − COGS = gross profit; current + LTD + other liabilities = total liabilitiesFail
Returns agree with the statementseach year’s gross receipts on the return against statement revenue (10%)Fail
Receivables agree with the agingbalance-sheet receivables against the aging total (10%)Fail
Receivables over 90 daysshare of the aging over 90 days (15%)Warn; excluded from the borrowing base
Concentrationlargest customer’s share of receivables (35%)Warn
Payables agree with the agingbalance-sheet payables against the aging (10%)Warn
Deposits support the revenueannualized deposits against revenue (below 75%)Warn
Returned itemsNSF items on the bank statementsWarn
Rent roll supports rental revenueannualized rent roll against revenue (15%)Warn

The tolerances in that table are illustrative settings for the demo, not a standard; a bank sets its own (CREDIT_TOL_RECEIVABLES, CREDIT_TOL_TAX_REVENUE, CREDIT_MIN_DEPOSIT_RATIO, CREDIT_TOL_RENT_ROLL and the rest).

Tidewater passes every one. Its three years tie. The 2025 Form 1065 shows gross receipts of $1,044,698 against statement revenue of $1,042,064, a 0.2% difference. Three months of deposits total $259,739, or $1,038,956 a year, 99.7% of revenue. The rent roll at 30 September 2026 shows $92,007 a month, $1,104,084 a year, at 85.4% occupancy. Each of those is a row on the checks tab with the quoted line it rests on.

Two other demo cases show what failing looks like. Driftwood Industrial Supply (CR-2026-000003) reports receivables of $592,463 on its FY2025 balance sheet; its aging at the same date totals $436,665, a 35.7% difference against a 10% tolerance. Hawthorne Bakeries (CR-2026-000005) reports FY2025 revenue of $14,517,350; its 2025 Form 1120 shows gross receipts of $11,560,905, 20.4% lower. Neither is an accusation. Both are questions that must be answered before anyone approves.

The checks tab for CR-2026-000003 Driftwood Industrial Supply: a failed check, Receivables agree with the aging, quoting the aging's line 14 and the FY2025 financial statements' line 22
A failed reconciliation, with both sides quoted. The aging’s total on line 14 against the balance sheet’s receivables on line 22. The check stays failed until a person resolves or waives it.

no

no

no

no

The spread

Statements
add up?

Returns agree
within 10 pct?

Receivables agree
with the aging?

Deposits at least
75 pct of revenue?

Failed check
both sides quoted

Warning
for the analyst

Spreading agent drafts
a request for an explanation

Analyst edits and sends,
or resolves or waives
with a reason

Reconciliations turn a doubtful figure into a check with evidence. Tolerances shown are the demo’s illustrative settings.

Who does what

The spreading agent builds the spread and runs the reconciliations, and when a difference needs an explanation it drafts the request to the borrower. It can’t send that request and it can’t clear a check. A failed check is resolved by a person (a corrected document, an explanation) or waived with a written reason, and a waived check shows as waived, never as passed.

Spreading a requestOwners in the tag
1
Read the documentsintake agent

Each PDF is read as it arrives. Missing documents become a drafted request to the borrower; scanned PDFs are refused in plain words.

2
Build the spreadspreading agent

The latest three fiscal years, derived lines, ratios, pro forma DSCR and global cash flow, all from what was read.

3
Reconcilespreading agent

Ties, returns, agings, deposits and rent roll. A difference outside tolerance becomes a check with both sides quoted.

4
Inspectcredit analyst

Hover the cells that matter, open the lines behind them, read the checks. The spread is reviewed, not re-keyed.

5
Ask or resolvecredit analyst

Accept, edit and send the drafted request for an explanation, or resolve or waive a check with a reason.

6
RerunInsightCredit

A borrower’s upload is read at once; the spread and checks run again on the new evidence.

What the spread will not do

It will not invent a figure the reader couldn’t find, and it will not smooth over a statement that doesn’t add up. Where the statement is wrong or incomplete, the remedy is a corrected document or an explanation from the borrower, recorded on the case, not an edit to a cell.

What it means for each audience

For the chief credit officer

Every number in a credit file can be traced to a page and a line, which is the first thing credit review and an examiner will test.

Formulas are fixed and visible, so a ratio means the same thing on every request in the book.

For the credit team lead

Analysts stop transcribing and start inspecting. Second reviews become a matter of opening the lines that matter, not re-keying three years.

Reconciliation failures arrive as checks with evidence, so the conversation with the borrower starts with a specific question.

For the board

Credit decisions rest on figures the bank can show came from the borrower’s own documents, tested against independent ones.

The quality of a file no longer depends on which analyst spread it.

What to be careful about

  • Traceable is not true. A figure quoted exactly from a company-prepared statement can still be wrong. Traceability shows where a number came from; the reconciliations and the analyst’s judgement decide whether to believe it.
  • Patterns read layouts they know. A statement in an unfamiliar format may be read partially. That is shown, not hidden, but it still needs a person to supply the right document.
  • Definitions are choices. EBITDA as operating income plus D&A, debt service as interest plus current maturities: these are common conventions, not the only ones. A bank should make sure the formulas match its credit policy and its covenant definitions.
  • Tolerances are policy. The demo’s 10% and 15% are illustrative. Set them deliberately, and know that a looser tolerance means fewer questions to borrowers and more risk that a real difference goes unasked.

A number in a credit file is a claim about a document. Make every claim checkable in one click.

Read the figures with their lines, show every formula, and test the statements against the returns, the agings and the bank before anyone relies on them.

Keep reading