- Before
- Rebuilds qualifying income from two years of personal and business returns by hand — an hour or more per file.
- Now
- Starts from a filled worksheet with every figure tied to its line, reads the why notes, and signs.
One income file, from complete to signed
Daniel and Lena Castellano are buying 2218 Juniper Hollow Drive in Meridian with a $692,000 conventional loan. He owns 60% of an S corporation, she runs a photography business on Schedule C, and they rent out a condo. Here is their file, screen by screen, in the working solution.
- 01Monday morning
Eight files on her desk, the next one ready
Priya Raman · Senior underwriterPriya opens Income files: eight self-employed and rental borrowers, ranked by what needs a decision. The Castellano file was marked complete on Friday — 42 pages, the 2024 transcript in, 2025 pending. The loan officer’s estimate at application sits beside it: $24,222.17 a month.
- 02One click
“Fill the worksheet” — and the figures land
Priya Raman · Senior underwriterThe return pages are on the left and the Form 1084 worksheet in the middle. Each figure glows on its line of the return and flies onto the worksheet while the monthly income meter adds up. The run log beside the work shows each agent as it finishes.
Transcript matcher: “2024 matches line for line · 2025 no record, filed on extension 14 Sep.”
- 031 min 31 s later
$22,914.12 a month, 31 of 31 figures traced
The agentsThe last line to land is Lena’s Schedule C depreciation — line 13, $5,600 and $6,100, added back at $487.50 a month. Daniel’s income, Lena’s two-year average and the condo’s +$81.33 total $22,914.12: $1,308.05 below the estimate, DTI 35.71%. A dashed line joins the selected worksheet line to its line on the return.
- 04Click any line
Why it is there — the rule, the line, the arithmetic
Cash-flow calculatorPriya clicks “Net gain on sale of equipment”. The note says why it came out: an $18,500 gain from selling a 2019 skid steer and trailer, 1120-S line 4 and Form 4797 Part II, happened once and will not recur. Daniel’s 60% share comes off at $925 a month.
“B3-3.7-02 · nonrecurring income”
- 05Same file
Form 1084 and Form 91, side by side
Priya Raman · Senior underwriterEvery line is also worked the Form 91 way. 18 of 19 lines agree. They differ on notes payable: the lender’s Form 91 rule set subtracts the $30,000 credit line unless the bank’s renewal letter is in the file, and the file has only the CPA’s statement 4. Form 91 gives $21,414.12 and DTI 38.21%. The loan goes to DU, so Form 1084 is used — and one click asks the processor for the renewal letter.
- 06Trend
Declining income, never averaged
Trend and continuance analystDaniel’s income fell 8.9%, from $240,960 in 2024 to $219,600 in 2025, so 2025 is used alone: $18,300.00 a month instead of the $19,190.00 two-year average. The 2026 P&L through 30 September annualizes to $211,600 of ordinary income, 12.6% above 2025, so the decline has stopped. The written analysis is drafted for Priya to edit and keep.
Choosing the two-year average is an override — it goes to Marcus Dell for a second review.
- 07Liquidity
K-1 income above distributions, so liquidity is tested
Liquidity and distributions checkerDaniel’s 2025 K-1 shows $112,740 of income against $96,000 distributed, 85%. The current ratio is 1.38 — $412,600 of current assets over $298,300 of current liabilities, above the 1.00 threshold — so the K-1 income counts. Schedule L line 17’s $52,000 is split from statement 4: a $30,000 revolving line with Ridgeway Community Bank that renews every April, and $22,000 due on an equipment note. Only the $22,000 is subtracted.
- 08Transcripts
2024 matches; 2025 is not on record yet
Transcript matcherThe 2024 transcript matches the return on 6 of 6 lines. For 2025 the IRS answered “no record of return filed” on 8 October — the return was e-filed on extension and accepted on 14 September, and the acknowledgement is in the file. A condition goes to the processor: the 2025 transcript before closing.
- 09Decision
Income by source, DTI, and a note for the loan officer
Conditions and decision writer$18,300.00 from Daniel, $4,532.79 from Lena, $81.33 from the condo. DTI moves from 33.78% at application to 35.71%, ready to resubmit to automated underwriting. Five findings reviewed, no finding overridden, and a plain note to Tyler Brandt drafted — sent only when Priya signs.
- 10Signed
Priya signs the qualifying income
Priya Raman · Senior underwriter$22,914.12 a month. Her figure equals the worksheet, so no second review is needed. She signs, the signature records that she reviewed the income, its sources and the written analysis, Tyler is told the income changed by −5.4%, and the transcript condition goes to Jenna Ortiz.
“Your figure equals the worksheet. No second review is needed.”