Bank Statement Converter for S-Corp Owner Mortgage Qualification
S-corporation owners pay themselves a reasonable salary shown on a W-2, then take additional income as distributions that flow through to their personal tax return on Schedule E. For a mortgage lender, combining the W-2 salary with verifiable distributions requires both business and personal bank statements — converting them to Excel creates a clear deposit-level audit trail for the underwriter.
Key Benefits
- Show owner salary W-2 deposits separately from S-corp distributions in one Excel workbook
- Document the business account transfer that funds each distribution to prove business cash flow support
- Calculate average monthly income from both salary and distributions for the lender's qualifying income worksheet
- Show the business account balance trend to confirm distributions do not strip the company of operating funds
- Provide a dual-account workbook — business and personal — that gives underwriters a complete income picture
How It Works
- Step 1: Upload PDF statements from both your personal checking account and your S-corp business checking account for 12–24 months
- Step 2: The tool extracts all transactions from both files with dates and amounts
- Step 3: Download Excel and create separate tabs for business and personal accounts
- Step 4: Label each row on the personal sheet as salary, distribution, or other; on the business sheet, mark transfers to personal
- Step 5: Attach the dual-tab workbook with your personal and business tax returns to your mortgage file
Frequently Asked Questions
- How do lenders calculate qualifying income for an S-corp owner?
- Lenders typically add your W-2 salary to your share of Schedule E S-corp income (after adding back depreciation and depletion), then average across two tax years. Bank statements showing that distributions were actually deposited to your personal account confirm the income is not just a paper entry.
- Can I use a bank statement loan to avoid the S-corp income calculation complexity?
- Yes. Bank statement loan programs calculate qualifying income as a percentage of your total personal account deposits — typically 50–85% after filtering business-purpose deposits. This often produces a higher qualifying income for S-corp owners whose tax return AGI is depressed by business deductions.
Convert a Statement Free