Cash flow analysis from tax returns is the upstream step that has to be right before global cash flow consolidation makes sense. It turns each tax return into a per-entity cash flow with the right classification of income, distributions, and add-backs. If this step is wrong, every downstream number is wrong with it. AI can automate most of this work today, but only if the system reads Form 1040, Form 1065, Form 1120-S, and Form 1120 the way a senior credit officer would, including the Schedule K-1 distinction between allocated income and actual cash distributions.
This guide covers the per-entity construction step. The companion how to automate global cash flow analysis guide covers the downstream consolidation across multiple entities. Together they describe the full workflow a commercial credit team needs.
Six stages, in order: document set assembly, per-entity cash flow construction, allocated-vs-distributed K-1 classification, tiered ownership tracing, add-back normalization, and consolidation to the guarantor's pro-rata share. We walk each stage with the manual baseline, what AI changes, and what the analyst still owns.
Stage 1. Document set assembly
The cash flow analysis cannot start until the document set is complete. For a guarantor who owns interests in multiple entities, the minimum is the personal 1040 with all schedules, every owned-entity return (1065, 1120-S, or 1120) with K-1s and continuation sheets, and prior-year returns for year-over-year comparison.
Manual baseline: a packet arrives via email or borrower portal, the analyst opens each PDF, and missing pieces become apparent only after the spread starts. Half a day can disappear chasing a missing K-1 or a continuation sheet that was supposed to be attached.
What AI changes: classification on intake. The system reads each PDF, identifies the form (1040, 1065, 1120-S, 1120), separates each entity's return from the others, and validates completeness against the implied document tree. If the guarantor's Schedule E references three entities and only two entity returns are in the packet, the system flags the third before any analyst time is spent on the spread.
Stage 2. Per-entity cash flow construction
Each entity gets its own cash flow before any consolidation. For a 1040 with a Schedule C, the input is wage income, self-employment income, interest and dividends, capital gains, and Schedule E flow-through. For a 1065, the input is ordinary business income from page 1, guaranteed payments, depreciation, interest expense, and the K-1 lines for each partner. For a 1120-S, the input mirrors the 1065 structure but at the shareholder level.
Manual baseline: the analyst keys each line into the spreading template. A clean 1040 with a Schedule C takes 30 to 45 minutes. A 1065 with K-1s and a few continuation sheets pushes well past an hour, and that is just for one entity in isolation.
What AI changes: extraction with the entity context preserved. The system reads each return, maps line items into the bank's spreading template, and keeps the per-entity cash flow distinct from the per-guarantor view. Source-page citations stay attached to every number. The analyst can click any line in the spread and see the exact page in the underlying return.
Stage 3. Allocated vs distributed income classification
This is the stage where most manual cash flow work goes wrong. Allocated income on a Schedule K-1 is the partner's or shareholder's pro-rata share of the entity's earnings. It is reported even if no cash actually moved. Distributions are separately reported and represent the cash the entity actually paid out. The two amounts are usually different.
For Form 1065 K-1s, ordinary business income is reported on Box 1 and cash distributions are reported on Box 19. For Form 1120-S K-1s, ordinary business income is also on Box 1 and shareholder distributions are reported on Box 16, code D. The IRS K-1 instructions (partnership and S-corp) describe the distinction explicitly.
Manual baseline: an analyst working fast can collapse allocated income and distributions into one line called "K-1 income" and double-count or undercount cash available to the guarantor. We covered this failure mode in tax return spreading for commercial loans.
What AI changes: explicit classification. A defensible system reads each K-1, separates allocated income from distributions on each box, surfaces the difference as a visible line in the spread, and flags any case where the two are very far apart so the analyst can think about why.
| K-1 type | Allocated income line | Cash distribution line | Common analyst error |
|---|---|---|---|
| Form 1065 K-1 (partnership) | Box 1 ordinary business income | Box 19 distributions | Treating Box 1 as cash available |
| Form 1120-S K-1 (S corporation) | Box 1 ordinary business income | Box 16, code D distributions | Treating Box 1 plus Box 16 as cash available |
Stage 4. Tiered ownership tracing
Tiered ownership shows up the moment a partnership owns interests in another partnership. Entity A files a 1065. Entity B files a 1065. Entity A holds a partnership interest in Entity B and receives a K-1 from Entity B. The guarantor receives a K-1 from Entity A, and the analyst has to trace the income and cash from Entity B through Entity A back to the guarantor.
Manual baseline: the analyst opens both entity returns, both K-1 packages, and reconciles by hand. We covered the failure modes in your borrower owns 7 LLCs. Several hours can disappear on this step alone before the actual cash flow math starts.
What AI changes: ownership graph construction. The system reads every K-1, identifies entity-on-entity relationships, builds the ownership graph, applies the right pro-rata percentages at each tier, and surfaces unresolved nodes (entities referenced on a K-1 but not in the document set). The analyst sees the graph and confirms it instead of building it from scratch.
Stage 5. Add-back normalization
Add-backs convert reported income to a cash flow figure that reflects what is actually available for debt service. The standard list is depreciation, amortization, interest expense, and owner compensation. Banks then add policy-specific items: one-time gains and losses, related-party rent or salary normalization, and any analyst-judgment items the bank's policy permits.
Manual baseline: each analyst applies add-backs slightly differently. One analyst always adds back owner compensation. Another only adds back the portion above market. A third adds back legal fees as one-time even when they recur. Drift across analysts shows up in committee as inconsistent files, which is bad for credit quality and worse for examiner findings.
What AI changes: consistent application of the bank's add-back policy. The system applies the standard set on every file, surfaces optional or judgment-laden add-backs as flagged items for analyst decision, and keeps a clean audit trail of which rules were applied to which line. The policy stays the bank's. The application gets consistent.
Stage 6. Consolidation to guarantor pro-rata share
Per-entity cash flows roll up to the guarantor's pro-rata share. For each entity the guarantor owns, the consolidated cash flow includes the guarantor's percentage of distributions actually received plus any salary or guaranteed payments. Allocated income that was not distributed stays in the entity. Overlapping debt across entities gets eliminated so the same obligation is not counted twice.
This stage is the boundary with the global cash flow workflow. The detailed consolidation rules, intercompany elimination, and ownership-percentage application are covered in the companion global cash flow guide. The point here is that the consolidation can only be defended if the upstream per-entity work in stages 1 through 5 was right.
What AI changes: end-to-end traceability. Every figure in the consolidated guarantor cash flow links back through the entity rollup, through the per-entity cash flow, to the source page in the underlying tax return. The audit trail does not break at any step, which is what makes the output examiner-ready.
What still requires the analyst
Three judgment calls do not automate, and good AI cash flow tools do not pretend they do.
Add-back judgment
Whether an item is recurring or one-time. Three years of "one-time" legal fees usually means recurring.
Related-party treatment
Above-market rent paid to an affiliated entity. Salary that is really a distribution. The system flags. The analyst decides.
Basis limitations
For S-corps, whether stock and debt basis (tracked on Form 7203) constrains the cash actually available to the shareholder.
AI handles the extraction, the classification, and the cross-document reasoning. The analyst owns the credit judgment that follows. That split is what the AI-Assisted Underwriting Playbook calls "AI prepares, human decides," and it is the load-bearing principle behind making the workflow examiner-ready.
Practical workflow checklist
A short version of the six stages, sized for a sticky note next to the analyst's monitor.
Workflow checklist
- Document set is complete. Schedule E references match the entity returns in the packet.
- Per-entity cash flow exists for each owned entity, with source citations on every line.
- Every K-1 has allocated income and distribution lines split. Big gaps between the two are flagged.
- Ownership graph is built and confirmed. Tiered relationships are walked, not assumed.
- Add-backs are applied per the bank's written policy. Judgment items are flagged, not silently included.
- Consolidated guarantor cash flow ties back through every step to source pages.
Cash flow from tax returns FAQ
How do you automate cash flow analysis from tax returns?
In six stages: assemble the document set (1040 plus every owned-entity return and K-1), build per-entity cash flow from the tax-return line items, classify allocated vs distributed income on each K-1, trace tiered ownership where one entity K-1 references another return, normalize add-backs against the bank's policy, and consolidate to the guarantor's pro-rata share. AI handles the extraction and the cross-document reasoning. The analyst still owns judgment on add-back recurrence, related-party treatment, and basis limitations.
What is the difference between cash flow analysis from tax returns and global cash flow analysis?
Cash flow analysis from tax returns is the upstream step: turning each tax return into a per-entity cash flow with the right classification of income, distributions, and add-backs. Global cash flow analysis is the downstream consolidation: rolling those per-entity cash flows up to the guarantor's pro-rata share with overlapping debt eliminated. The same workflow uses both. This guide covers the upstream step. The companion global cash flow guide covers the consolidation.
What is the most common manual error in this workflow?
Confusing allocated income with actual distributions on K-1s. A 1065 K-1 reports allocated ordinary business income on Box 1 and reports cash distributions separately on Box 19. The amounts are usually different. Counting the allocated income as cash available to the guarantor (or counting the distribution on top of the income) overstates cash flow. AI cash flow tools should flag the distinction explicitly on every K-1 they read.
What should still stay with the analyst?
Three judgment calls. Whether an add-back is recurring or one-time. How to treat related-party transactions and intercompany transfers. Whether basis limitations on an S-corp constrain the cash that is actually available to the shareholder. Automation should produce a defensible draft with source citations on every figure. The analyst makes the calls that determine credit.
How long does this analysis take manually?
Single-entity files with a clean 1040 and one Schedule C take an experienced analyst 30-45 minutes. Multi-entity guarantor files with a 1065, K-1s, an 1120-S, and a Schedule E commonly take four to eight hours, and tiered ownership tracing alone can consume several of those hours before the actual cash flow math starts. That is the workload AI is targeting.
Go deeper
Downstream consolidation. Read how to automate global cash flow analysis for the entity-graph rollup that follows this guide.
Form-by-form treatment. Read tax return analysis software for commercial lending for the 1040, 1065, 1120-S, and 1120 specifics.
Multi-entity ownership in plain English. Read your borrower owns 7 LLCs.
Governance and rollout. Read the AI-Assisted Underwriting Playbook.