Bank statements for a mortgage application: get them into Excel

When you apply for a mortgage, the lender asks for recent bank statements — usually two to three months across all accounts. Beyond handing them over, converting them to a spreadsheet lets you see exactly what the underwriter will see, and fix what can be fixed before you apply.

What a lender looks for

• Stable, recurring income (salary, rental income).
• Fixed outgoings: rent, existing loans, childcare.
• Affordability: monthly commitments versus income.
• Red flags: overdrafts, returned payments, gambling, large unexplained deposits.

Why Excel helps you, not just the lender

In a PDF, these signals are buried. Categorized in a spreadsheet, your transactions total by type in seconds: average income, recurring costs, and a quick affordability ratio. It is much better to find a recurring overdraft yourself than to have the underwriter flag it.

How to prepare

Convert your statements (any bank) with bankpdf into a clean, categorized Excel file; convert several months and accounts at once and merge them for a full picture. Data stays private (EU hosting, GDPR) — which matters for documents this sensitive.