Financial Spreading
Statements, spread to your template, cited to the page.
LendPipe spreads tax returns, audited financials, interim statements, and personal financial statements into your institution's exact format. Every cell links back to the source page and line, so committee can audit any number in two clicks.
| Category | FY 2025 | FY 2024 | FY 2023 |
|---|---|---|---|
| ASSETS | |||
| +Current Assets1 | 2,472,320 | 2,087,700 | 1,977,600 |
| +Fixed Assets (Net) | 1,896,000 | 1,848,000 | 1,771,600 |
| +Non-Current Assets | 125,000 | 150,000 | 175,000 |
| LIABILITIES | |||
| +Current Liabilities2 | 1,161,200 | 1,110,800 | 970,400 |
| +Long-Term Liabilities | 1,240,000 | 1,380,000 | 1,520,000 |
| EQUITY | |||
| Retained Earnings | 1,174,785 | 757,450 | 553,834 |
| Net Income3 | 417,335 | 203,616 | 162,466 |
What it does
Spreading that produces a workpaper your committee already knows how to read.
Financial spreading is the highest-leverage step in commercial credit analysis — and the one where manual work eats the most analyst hours. Tax returns come in as scanned PDFs, balance sheets ship as Excel files with custom line item labels, audited financials follow GAAP, compiled statements don't, and every CPA names accounts a little differently. Before LendPipe, a senior analyst spends a full afternoon re-keying numbers into your spreading template, then a junior analyst spends another two hours checking the work. LendPipe reads each statement, identifies the line items, and maps them to your chart of accounts. The output looks like your existing spread — same template, same row labels, same period columns, same ratios — except every cell carries a citation linking back to the page and line in the source document. Reviewing a spread becomes a verification exercise, not a transcription exercise. If a number doesn't look right, the analyst clicks it and lands on the exact source page.
Capabilities
What the spreading capability covers
Tax return spreading (1040, 1065, 1120, 1120-S)
Schedule C, K-1s, Schedule E, business returns, and personal returns spread into your template. Multi-entity returns kept attributed to the right entity through the global cash flow.
Balance sheet and income statement extraction
Audited, reviewed, compiled, and management-prepared statements all read. Custom line item labels are matched to your chart of accounts using your institution's mapping.
Multi-period comparisons
Two-, three-, and five-period comparative spreads with auto-calculated period-over-period change, common-sizing, and trend analysis built in.
Personal financial statements
Guarantor PFS parsed into the same workpaper format. Real estate schedules, contingent liabilities, and net worth calculations match what your guarantor analysis template expects.
Multi-entity consolidation
Operating company, real estate holdco, related entities, and guarantor cash flow combined into a global view. Intercompany eliminations and ownership-weighted contributions handled.
Your spreading template, not ours
Your chart of accounts, line labels, period structure, and ratio definitions. Examiners see analysis that matches your documented credit process — not generic AI output.
How it works
Four steps from document to spread
- 01
Documents arrive — any format you accept
Tax returns as scanned PDFs, financials as Excel files, K-1s as PDFs from the borrower's CPA, interim statements that came over email. LendPipe accepts the same mix of formats your borrowers actually send, including the scanned-from-fax tax returns that nobody admits to receiving but everyone does.
- 02
Line items recognized and mapped
Each line on the source document is parsed — label, amount, period — and matched to a line in your institution's spreading template using your mapping rules. Custom account names borrowers use ("Owner's Comp", "Officer Salaries", "Distributions") map to the right standardized category every time, not just when the wording matches exactly.
- 03
Citations attached to every cell
Every spread number carries a back-pointer to the source page and line on the original document. Hovering shows the source snippet; clicking opens the underlying PDF at the right page. Multi-document figures — a total that pulled from three different schedules — carry multiple citations.
- 04
Ratios and analysis computed
DSCR, leverage, working capital, current ratio, debt-to-tangible-net-worth, fixed-charge coverage, and the rest of your institution's standard ratio set computed automatically from the spread. Period-over-period change and common-sized statements generated. The workpaper is ready for analyst review when intake completes.
What you get back
What lands in the analyst's queue
Spread workpaper in your template
Excel-exportable spread matching your institution's exact format — line labels, period columns, ratio rows. Committee sees output that looks like every other deal they review.
Source-linked citations
Every cell in the spread links back to the source page and line. Two-click verification on any figure. Examiner-ready audit trail without separate documentation work.
Computed ratio panel
DSCR, leverage, coverage ratios, and trend metrics auto-computed across all periods. Your institution's policy thresholds applied so out-of-policy values are visually flagged.
Global cash flow for multi-entity borrowers
Operating company, holding entities, and guarantor cash flow consolidated into a single global view, with intercompany eliminations and ownership weighting applied.
Built for lenders
Spreading that fits the way community banks and credit unions actually underwrite
Large commercial banks built their spreading software in the 1990s and have spent the last twenty years bolting OCR onto it. Community banks, credit unions, and SBA lenders inherited that software and the manual workarounds that come with it — three-screen workflows, copy-paste between Word and Excel, and spread templates that look identical to a template designed for a 1998 deal. LendPipe is built for the way your team actually works: messy borrower packages, multi-entity structures that real businesses have, guarantor PFS that ten different CPAs prepared ten different ways, and credit policies that need to be applied consistently across deals without forcing analysts to re-key the same numbers fifteen times. The spread template is yours — the speed comes from skipping the data entry, not from generic output.
Common questions
What lenders ask before they switch
Does LendPipe spread into our exact template or its own format?
Into your exact template. Your chart of accounts mapping, line labels, period column structure, ratio definitions, and conventions like "officer comp" vs. "owner draws" treatment are all configured at the institution level. The Excel export matches what your team has historically produced by hand. Examiners and credit committee see output that's indistinguishable from a manually prepared spread, except every cell carries a source citation.
How does it handle a borrower with multiple entities and K-1s?
Multi-entity borrowers are LendPipe's largest accuracy advantage over manual spreading. Each entity's returns and financials are processed separately, attributed correctly, and consolidated using the ownership structure you configure. K-1 pass-through income flows to the right guarantor; intercompany rents are eliminated from the operating company's cash flow; guarantee relationships are tracked in the global cash flow. This is where most manual errors happen, and where the audit trail matters most.
What document formats do you support for spreading?
Scanned and digital PDFs are the most common, including multi-page tax returns and audited financial statements. Excel files (including the borrower's own bookkeeping export) are supported. Image files from phone photos are read but spot-checked. The spreading engine is the same regardless of format — your team uploads what the borrower sent.
Can analysts edit the spread before it goes to committee?
Yes — the spread is a starting point, not a final answer. Analysts can re-categorize any line, adjust ratios, override extracted values, and add commentary. Edits are tracked with the analyst's name and timestamp so the audit trail shows what came from extraction and what came from analyst judgment. The final committee export reflects all analyst edits.
How does spreading interact with credit policy screening?
The same spread data feeds the deal screening capability. DSCR, leverage, debt-service coverage, and concentration metrics computed during spreading are passed directly to your policy gates — there's no second data entry step. If your credit policy says "minimum 1.20x DSCR using fully amortized debt service on a 25-year basis," that's how DSCR is computed in the spread and that's the number that's checked against the policy gate.
What about CPA-prepared adjustments and EBITDA add-backs?
Common add-backs — depreciation, amortization, owner's compensation in excess of market, non-recurring items, deferred rent — are detected from the spread and surfaced as candidate adjustments rather than applied automatically. Your analyst decides which add-backs to accept based on credit judgment and supporting documentation. The audit trail records both the unadjusted spread and the adjusted figure with the analyst's notes.
Related capabilities
Built to work together, not in isolation
See it run on a real borrower file.
Walk through one of your own deals — document drop to committee-ready output, end to end.
Book a 10-minute demo