Bank Statement to Excel for a Mortgage, Visa or Loan Application
Lenders and immigration offices usually ask for your original bank statements, so send those as they are. Converting the same statements to Excel is for you: it lets you total your income, spot unusual payments and check balances before you apply, so nothing in the statements surprises you or the person reviewing them.
Send the originals, analyze a copy
Each lender, bank or visa route sets its own rules: how many months, whether statements must be stamped or downloaded, and in which format. Follow exactly what they ask for. A spreadsheet you made yourself is not a replacement for the statements, and you shouldn’t edit the statements you send.
What the spreadsheet does is let you prepare. Before you apply, you can see what a reviewer will see: your regular income, your outgoings, and anything that needs an explanation.
Step 1: Convert the statements
- Download the months you’ve been asked for as PDF statements from online banking.
- Convert each one with PDF bank statement to Excel. If a statement is a scan or photo, use PDF table to Excel, which reads scans with text recognition.
- Join the months with Combine CSV and Excel files into one sheet.
Statements are among the most sensitive documents you have. These tools read them in your browser and never upload them, and you can check that yourself.
Step 2: What to look at
- Regular income: filter for salary or client payments and check they arrive on similar dates and amounts each month.
- Balances: if a minimum balance or savings amount matters, check the balance column on every day of the period, not only at month end.
- Large or unusual payments in: gifts, transfers between your own accounts or one-off sales. Have the paperwork ready to explain them.
- Commitments: loan repayments, credit cards and subscriptions add up. A pivot table by payee shows them quickly.
- Gambling, returned payments or overdraft fees: reviewers often notice these. Better that you see them first.
Step 3: Build a simple summary
With the months in one sheet, a pivot table by month gives total money in, total money out and the net for each month. Add the lowest balance in each month with MINIFS. That one-page summary is useful when a broker or adviser asks about your finances, alongside the original statements.
For a business applicant, the same data can be reconciled against your accounts: see bank reconciliation in Excel.
Frequently asked questions
Can I send a converted Excel file instead of my bank statements?
Usually not. Lenders and immigration offices generally want the original statements from your bank. Use the Excel version to check and summarize your own finances before you apply.
Is it safe to convert bank statements online?
Many online converters upload your file to a server. The useme4 tools read the statement in your browser and never upload it; you can check this yourself in your browser’s developer tools.
How many months of statements do I need?
It depends on the lender or visa route. Check the exact requirement with them and download that period.