Bank Statement Converter for a Pilot Income Home Loan
Commercial pilots earn a combination of hourly flight pay, per diem, and longevity bonuses that look nothing like a standard W-2 salary. Contract pilots and charter pilots add 1099 complexity on top. Converting 12–24 months of bank statements to Excel gives a mortgage lender a clear monthly deposit history behind all those income streams.
Key Benefits
- Capture monthly airline payroll deposits including base pay, per diem, and bonuses
- Show contract pilot or charter income from multiple operators as consolidated deposits
- Document the full 24-month income history lenders use to average irregular flight pay
- Separate per diem allowances from taxable wages if your lender counts them differently
- Export to Excel so your loan officer can calculate average monthly qualifying income
How It Works
- Step 1: Upload your bank statement PDFs — 12 months minimum, 24 months preferred
- Step 2: The converter extracts all deposits with dates, descriptions, and amounts
- Step 3: Download Excel and filter deposit rows to show airline payroll and contract payments
- Step 4: Attach to your mortgage application with your employment verification from the airline
Frequently Asked Questions
- My per diem is non-taxable. Will a lender count it toward my mortgage income?
- Most lenders exclude non-taxable per diem from qualifying income. The bank statement shows all deposits — your loan officer applies the lender's policy to separate taxable wages from allowances. Showing both in Excel gives them all the information they need.
- I recently upgraded to captain. My income jumped significantly. Which year does the lender use?
- Standard practice is a 2-year average. But if you have documentation proving the income increase is permanent — a new contract at captain pay — some lenders will use the current pay rate rather than averaging it down with prior first-officer income.
Convert a Statement Free