The Real Work Behind the Income Worksheet
Mortgage underwriters use a spreadsheet (or automated system) to verify that a borrower's stated income is stable, documented, and likely to continue. The worksheet itself isn't magic. It takes pay stubs, W-2s, tax returns, and sometimes profit-and-loss statements, then applies Fannie Mae, Freddie Mac, and FHA guidelines to land on a qualifying monthly income figure. That figure drives the debt-to-income ratio and the final approval decision. Here is how I actually do it when a file comes across my desk. First, I pull the most recent 30 days of pay stubs. Under Fannie Mae guidelines, you generally need to show two months of payroll history if the borrower is W-2 employed. Self-employed borrowers need two years of tax returns. I note that rule right away because skipping it is the single most common reason files get sent back for supplements.
Next, I take the gross annual income and divide by 12. That gives the base monthly income. Then I scan for anomalies. Overtime, bonus, commission, and second-job income all get treated differently. Overtime has to be consistent for at least two years. A one-time bonus does not count as stable income. If the borrower received a $4,000 bonus last December but nothing in January through November, I exclude it entirely from the calculation. I have seen underwriters include it anyway and then get slapped with a conditions letter three weeks before closing. For commission-based income, I pull the most recent year-to-date commission statement and average it over twelve months, but only if the borrower has a two-year history of similar earnings. If year one shows $80,000 in total compensation with $30,000 in commission and year two shows $95,000 total with $45,000 in commission, I take the lower commission figure and annualize it. That conservative approach keeps the file from getting flagged for income fluctuation. Here is the part most people get wrong. The worksheet does not just add up every dollar the borrower received. It applies specific adjustments. Social Security income gets multiplied by 0.75 to account for taxes, even though most Social Security benefits are tax-free. That 25 percent reduction is a guideline, not a suggestion. Military housing allowances and certain disability payments also get specific treatment under the automated underwriting systems. You cannot just line-item every deposit from a bank statement and call it income. The system rejects that approach.
I dealt with a file recently where a borrower had been receiving a small pension plus workers' compensation. The pension was regular and predictable. The workers' comp was for a permanent injury but had a scheduled end date listed in the award documents. The underwriter on the other side asked for four years of payment history. I pushed back with the actual award letter showing permanence, cited the Fannie Mae guide section on stable supplemental income, and got the file approved without the extra documentation. If the income has a defined end date, it may still count, but the remaining months factor into the qualifying period. That nuance trips up a lot of people who assume all non-wage income is automatically excluded. When I build the worksheet, I follow a consistent structure. Column one lists each income source. Column two shows the annual amount from the most recent tax return or year-to-date statement. Column three applies the relevant guideline multiplier or averaging method. Column four gives the adjusted monthly income. I then sum column four and compare it against the borrower's monthly debt obligations. Employment verification is part of the worksheet process even if it is not always printed on the same page. Most lenders use the Employment Confirmation form or pull data directly from third-party verification services. A gap of more than thirty days in employment history requires a written explanation from the borrower. Not every gap matters. A two-week layoff between jobs does not raise red flags. A six-month gap without documentation does.
Get the Full Details
Self-employed borrowers face a harder worksheet. The standard approach uses Schedule C from the most recent two years of tax returns. You start with gross revenue, subtract COGS to get net profit, then add back depreciation, amortization, and one-time expenses. The resulting figure is the adjusted net income. If the borrower shows a loss on both years, the file usually goes to manual underwriting unless there is a compelling explanation. I have seen files rejected outright when the borrower ran a side business that operated at a loss for two consecutive years. The lender assumes the loss will continue, which reduces qualifying income. A few practical notes about what the worksheet cannot do. It cannot account for income that is not documented. Cash payments, under-the-table work, and undocumented side gigs do not exist in the underwriter's world. It also cannot forgive inconsistencies. If the W-2 shows $72,000 but the pay stubs over the last thirty days imply an annual rate of $85,000, the underwriter will ask for an explanation. More often than not, they just use the lower number from the tax return and move on. Borrowers sometimes think they can talk their way into a higher income figure. That rarely works. The biggest bottleneck I encounter is the delay between when income changes and when the worksheet reflects it. A raise that starts mid-year requires proof from the most recent pay stub, but the automated system may still default to the previous year's W-2 until the file reaches a certain stage. This creates a mismatch that slows processing by two to four business days in most cases. The workaround is to attach a current employment verification letter that explicitly states the new salary and effective date. That typically clears the issue without a full re-submittal.
If you are building your own worksheet rather than relying on an automated underwriting system, use a simple layout with clearly labeled sections for each income type. Include columns for gross annual, adjusted annual, and monthly. Keep a separate sheet for asset documentation because some income calculations depend on reserve requirements that vary by loan type. A conventional loan may need two months of reserves. An FHA loan may need none. That difference does not change the income calculation but it changes whether the file closes on time. One last thing that surprises people. The worksheet is not the same as the closing disclosure income section. The closing disclosure reflects the approved income after underwriting adjustments. The worksheet is the working document where those adjustments happen. If you are reviewing your own file, ask for a copy of the income worksheet, not just the final approval letter. The worksheet shows exactly which income items were included, which were excluded, and why. That visibility saves time when the file hits a condition and you need to respond quickly.
