Reconciling a borrower projections against their tax returns for SBA review

How to reconcile borrower cash flow projections against filed tax returns for SBA 7(a) and 504 lender review. Step-by-step mechanics and red flags.

Reconciling a borrower projections against their tax returns for SBA review with cash flow documentation

P
Paola Vargas
Content Lead, Outsourcing Processing — SBA loan income & cash flow analysis for brokers

Free Trial, No Card

Worried an SBA file gets kicked back over the cash flow numbers?

DSCR and cash flow calculated and organized for your SBA 7(a)/504 submissions — human-reviewed, ready for your lender’s underwriting. See a real report in minutes.

Built for SBA DSCR & Form 1919 cash flow analysis
Every calculation flagged for your review — never auto-submitted
Lender-guideline aware, not generic math
Free trial, no credit card required

When a self-employed borrower or 1099 filer submits cash flow projections alongside two years of filed tax returns, underwriters rarely take the numbers at face value. The real friction happens in the reconciliation—the moment you have to explain why projected income diverges from what the IRS already has on file. This isn’t about catching fraud; it’s about meeting the structural requirement that underlies every SBA 7(a) and 504 deal: underwriters need to see credible cash flow that services the loan at a debt service ratio their wholesale lender will accept. The gap between what a borrower projects and what their history shows is where that credibility either holds or fractures.

Does this sound familiar? Two lenders, two different DSCR requirements, and a spreadsheet that’s hard to trust. See how the platform keeps SBA cash flow organized and lender-ready — free trial, no credit card required.

Why Reconciliation Matters for DSCR Calculation

Form 1919 requires a reconciliation statement—not always labeled as such, but functionally present in every complete 7(a) package. The IRS knows what the borrower reported on Schedules C, E, or F. The SBA lender knows what cash flow the deal needs to support the requested loan amount and term. The broker’s job is to bridge those two worlds in a way that’s defensible.

The math is unforgiving. If a borrower earned $180,000 on last year’s tax return but projects $240,000 for next year, underwriters will want to know why—and “business growth” alone doesn’t close the file. They’re modeling DSCR using either the lower of trailing twelve months (TTM) cash flow or the average of two years’ tax returns, depending on the lender’s overlay. If projected income exceeds historical income by more than 10–15%, most wholesale lenders will cap the qualifying income at the highest filed-year figure, sometimes discounting it further. That’s not a suggestion; it’s how the math works at funding.

Step-by-Step Reconciliation Process

1. Start with the filed tax return baseline. Pull the last two full years of personal tax returns (1040 with Schedule C for self-employed, Schedule E for rental income, K-1s for pass-throughs). Note the exact net income or net profit line. This is your floor—the number the SBA lender will assume a borrower can at least earn again.

2. Verify income sources match the business model. A borrower claiming $200,000 in Schedule C net profit must have invoices, bank deposits, or client contracts backing that claim. If the tax return shows $200,000 but bank deposits for the same year total $140,000 with gaps, that discrepancy gets flagged. Underwriters cross-check tax returns against business bank statements (usually the last 12–24 months) to ensure the numbers reconcile. A missing three-month cash surge or unexplained dips raises questions.

3. Document the source of projected growth (if any). If the borrower projects $240,000 and last year’s return showed $180,000, provide written support. This could be: signed contracts with new clients committing to work, a detailed invoice pipeline with dates, hiring records showing expanded capacity, or documented market data showing price increases or volume commitments. Vague statements like “expect 20% growth” don’t work. Underwriters want specifics—new contract values, start dates, and the borrower’s written explanation of how those translate to cash flow.

4. Adjust for loan use and business changes. If the SBA loan funds a business expansion (adding staff, equipment, location), the borrower’s income model may legitimately change. If the loan is for working capital or debt refinance, the cash flow baseline should remain conservative. Separate the loan use from the borrower’s general cash flow assumptions. A borrower using $200,000 to hire a full-time employee might project payroll expenses that reduce net income in year one, even if gross revenue grows—that timing matters for DSCR.

5. Calculate adjustments for non-recurring items. Tax returns often include one-time gains (sale of equipment, insurance settlements) or unusual losses (legal fees, accounting adjustments). If a borrower’s 2024 return shows $210,000 but includes a $50,000 gain on asset sale, the normalized operating income is $160,000. Document these adjustments in writing so the underwriter can see the reconciled figure, not just the raw return.

Worked Example: Reconciling a Service Business Projection

Say a borrower runs a management consulting firm and requests a $150,000 SBA 7(a) loan. Here’s how reconciliation flows:

Filed 2024 return: Schedule C shows $185,000 net profit. 2023 showed $168,000. Average: $176,500.

Projected 2025 cash flow (borrower’s submission): $220,000 (assumes new corporate contracts totaling $55,000 in new revenue).

Bank statements (Jan–Nov 2024): Monthly deposits average $15,500; November and December show $18,000 each (seasonal uptick). TTM deposits: ~$195,000 (higher than net profit due to owner draws and tax refunds, which explains the variance).

Reconciliation step: The borrower provides three signed contracts with Fortune 500 subunits, each worth $18,000–$22,000, starting Q1 2025, with multi-year terms. Written narrative explains the contracts represent the new revenue projection. Underwriter caps qualifying income at the higher of two-year average ($176,500) or can accept up to 10% above the highest year ($185,000 × 1.10 = $203,500) if the contracts are enforceable and risk-rated. DSCR is then calculated on the approved qualifying income, not the $220,000 projection.

This borrower likely qualifies for the loan if DSCR holds above the wholesale lender’s minimum (often 1.25x for 7(a), depending on SBA program guidelines and lender overlays). But if no contracts are provided, underwriters cap income at $185,000 and may discount further, pushing DSCR below threshold and requiring additional collateral or guarantor strength.

Red Flags in Reconciliation

Certain patterns trigger additional scrutiny or deal rejection. Income projections that exceed two-year historical averages by more than 20% without documented support often get capped at the historical high. Conversely, if a borrower’s tax returns show declining income over two years but projects a sharp reversal upward, underwriters demand explanation—market shift, new marketing spend, hire of key personnel. Inconsistencies between tax returns and bank statements (deposits lower than reported revenue, cash withdrawals that don’t reconcile to draw patterns) raise integrity questions that can stall underwriting or require amended returns.

Timing mismatches also matter. If a borrower’s most recent tax return is for 2024 but it’s now mid-2026, the SBA lender will want to see 2025 returns and, ideally, YTD 2026 financials to confirm the business is still operating and the historical income is still representative.

How DSCR Flows From Reconciled Income

Once reconciliation is complete and qualifying income is established, DSCR calculation is straightforward. Most U.S. Small Business Administration lenders use: DSCR = (Net Operating Income) / (Annual Debt Service). Net Operating Income is the reconciled, underwriter-approved annual cash flow. Annual Debt Service is the sum of all debt obligations (the new SBA loan payment plus existing mortgages, vehicle loans, credit lines, and any other monthly debt multiplied by 12). If the borrower’s qualifying income is $180,000, new SBA payment is $24,000 annually, and existing debt service is $18,000, then DSCR = $180,000 / $42,000 = 4.29x—well above most lenders’ minimum thresholds.

The reconciliation determines the numerator. The debt schedule (which the borrower or broker assembles from credit reports and loan documents) determines the denominator. Reconciliation without accurate debt data is incomplete; reconciliation without clear documentation is vulnerable to underwriter pushback.

Tools and Documentation Checklist

To move reconciliation quickly, maintain a working file with: (1) two years of filed tax returns and any amendments; (2) 24 months of borrower business bank statements; (3) current personal credit report and full debt schedule (all monthly obligations listed); (4) written explanation of any income growth, one-time gains or losses, or business model changes; (5) supporting documents for new revenue (contracts, letters of intent, customer lists with revenue breakdowns); (6) schedule of existing collateral and personal guaranty details; (7) loan use narrative explaining how funds deploy and impact cash flow timing.

Outsourcing Processing’s platform ingests this data and organizes DSCR and cash flow calculations so the broker can review the math before submission, catch reconciliation gaps early, and present a clean file to the underwriter. The platform doesn’t auto-submit or advise on deal structure—it ensures the reconciliation and DSCR math are transparent and defensible from the moment the file lands in underwriting.

Common Underwriter Questions on Reconciliation

Prepare answers to: “Why does projected income exceed the tax return?” (have contracts, invoices, or market data ready). “Why do bank deposits diverge from reported revenue?” (distinguish owner draws, tax refunds, and redeposits from operating income). “Is this income sustainable after the loan closes?” (confirm the business model supports it independent of temporary factors). “Have you adjusted for any one-time gains?” (show normalized calculations). These questions aren’t obstacles; they’re the underwriter doing their job. A broker who answers them crisply, with documentation, closes files faster.

Frequently Asked Questions

What if a borrower’s tax return shows losses for one of the two years?

Many SBA lenders average net income across two years. If 2024 shows $200,000 and 2023 shows a $20,000 loss, the average is $90,000. Some lenders will use the higher of the two years ($200,000) if the loss was one-time and documented as such. Others require three years of returns to confirm stability. Underwriters often ask for a written explanation of what caused the loss year—temporary slowdown, one-time expense, or structural issue. If the loss was tied to a discrete event (equipment breakdown, major client loss) that’s now resolved, that explanation can allow the lender to use the positive year’s income.

Can a borrower project income beyond two years’ history if they have a specific new contract?

Yes, but with conditions. A signed, multi-year contract with a creditworthy counterparty and defined payment terms can support income above the historical average. The contract must be enforceable (not a letter of intent or informal agreement), and the lender will verify it independently. Typically, lenders cap qualifying income at 10–15% above the highest historical year even with contracts, depending on the lender’s risk appetite and the contract’s terms. The SBA doesn’t mandate a specific cap, so confirm your wholesale lender’s overlay.

What happens if bank statements don’t match the tax return?

Discrepancies must be explained in writing. Common reasons include owner draws (cash the borrower took out, reducing net income but showing as bank outflows), personal deposits (tax refunds, inheritance, loans from family that aren’t business income), and timing differences (invoices issued in December but paid in January). The underwriter will cross-reference the tax return to the bank statement to reconcile items. Large unexplained gaps—especially where tax income exceeds deposits—can raise flags about income verification and may require amended returns or additional documentation like invoices and client confirmations.

Does the SBA require a specific reconciliation format or statement?

The U.S. Small Business Administration doesn’t mandate a single reconciliation template, but most lenders expect a written statement (often called a “cash flow reconciliation” or included in the borrower’s business narrative) that explains variances between tax returns and projections, and confirms the sources of income are stable or supported by new contracts. Form 1919 is the standard SBA cash flow worksheet, but the reconciliation is typically a narrative document prepared by the broker or borrower, signed by the borrower, and reviewed by the underwriter. Your lender will specify their format preference; ask early in the process.

Can projected income include the borrower’s planned salary increase if they’re restructuring the business?

Possibly, but with documentation. If the borrower currently takes a $100,000 draw but plans to formalize a $120,000 salary after the loan closes, the underwriter needs to see the business plan and confirm the income supports both the new salary and debt service. The reconciliation should show how the business model changes post-loan—whether cash flow is being redirected from owner draw to payroll, or if gross revenue is increasing to cover both. One-time restructuring doesn’t automatically increase qualifying income; the underwriter will model it conservatively and may cap income at the historical level unless growth is separately documented.

This article is educational and does not constitute lending advice — confirm current SBA program requirements with your lender before submitting a file.

This article is educational and does not constitute lending advice — confirm current SBA program requirements with your lender before submitting a file.

See SBA Cash Flow, Organized

DSCR and cash flow calculated and organized for your SBA loan file review — human-reviewed, never auto-submitted, free trial, no credit card.