Bank Statement Converter for Bonus Income Mortgage Qualification
Mortgage underwriters treat bonuses as variable income. They need to see that your employer has paid a bonus two years in a row and that it is likely to continue. Converting your bank statements to Excel creates a clear deposit-by-deposit record of every bonus received, making the two-year averaging calculation straightforward.
Key Benefits
- Show bonus deposit dates and amounts for the last 24 months in one Excel file
- Distinguish annual bonus from profit sharing, commissions, and regular pay deposits
- Demonstrate the upward trend if bonuses have increased year over year
- Provide gross deposit amounts that reconcile with your W-2 box figures
- Give the underwriter a sortable file so they can pull bonus rows by amount and date
How It Works
- Step 1: Upload your bank statements for at least 24 months covering each bonus payment period
- Step 2: The converter extracts every deposit with date, description, and amount
- Step 3: Download Excel and filter by deposit descriptions that match your employer's bonus labels
- Step 4: Attach the file alongside your offer letter or employer bonus policy documentation
Frequently Asked Questions
- My bonus is not guaranteed. Will a lender count it?
- Lenders require two years of bonus history with a high likelihood of continuance. A signed letter from your employer stating the bonus program continues — combined with two years of bank deposit evidence — is the standard documentation package.
- Can I include a signing bonus from a new job?
- Signing bonuses are generally excluded because they are non-recurring. Your base salary plus any guaranteed bonus structure will be what the underwriter qualifies you on for a new position.
Convert a Statement Free