Bank statements for a mortgage or loan application
By the Banking Converter editorial team
Published
Lenders almost always want the original PDF statements straight from your bank, covering the last three to six months, unedited. A converted spreadsheet is for your own preparation — checking what an underwriter will see and getting your figures straight — not usually for submission.
What lenders typically ask for
Requirements vary by lender and by country, so treat this as the usual shape rather than a rule. Ask the lender directly if anything is unclear; getting it wrong costs a round trip and often several days.
| Purpose | Typical period | Usual form |
|---|---|---|
| Residential mortgage | 3–6 months | Original PDFs from the bank |
| Remortgage | 3 months | Original PDFs |
| Business loan | 6–12 months of business accounts | Original PDFs, sometimes a spreadsheet as well |
| Rental application | 3 months | PDFs, sometimes stamped by the bank |
| Self-employed income check | 12 months plus accounts | PDFs and often an accountant's summary |
Business applications are where a spreadsheet is most often welcome alongside the PDFs, because an analyst wants to sort and total the transactions rather than read them.
Why they want the original PDF
A statement downloaded from online banking carries things a spreadsheet cannot: the bank's own layout, the account and sort code as the bank prints them, the period, and often embedded metadata. Underwriters are trained to look at those.
- It is the bank's document, not yours, so it is harder to alter without leaving traces.
- It shows the balance progression the lender wants to see, including the low points during the month.
- It is complete: every transaction, not a selection.
Never edit a statement PDF before sending it. Altering a bank statement submitted in support of a credit application is fraud in most jurisdictions, regardless of intent. If something on it needs explaining, explain it in a covering note instead.
Redacting is different from altering, and is sometimes appropriate when a statement is going to a landlord or a counterparty rather than a regulated lender — see how to redact a bank statement.
What an underwriter actually looks at
Knowing this is the argument for converting your own statements first: you can see what they will see.
- Regular income: how much, how often, and from a consistent source.
- Committed outgoings: rent or mortgage, loans, childcare, subscriptions — anything that will still exist after the new borrowing.
- Existing debt repayments, including buy-now-pay-later arrangements, which increasingly appear on statements.
- Returned direct debits and unarranged overdraft use, which weigh heavily.
- Gambling transactions, which many lenders assess separately.
- Large or irregular deposits, which will need an explanation and evidence of source.
- The lowest balance in each month rather than the closing balance.
Converting your statements to a spreadsheet and grouping by description makes most of these visible in a few minutes. Sorting by amount surfaces the large deposits you will be asked about.
Preparing before you apply
- Download the statements as PDFs from your bank, covering the full period the lender asked for. See downloading statements.
- Convert a copy to a spreadsheet for your own review.
- Total the income lines and check they match your stated income.
- List every recurring payment, and cancel the subscriptions you no longer use before the application rather than after.
- Identify every deposit that is not salary and write one line explaining each: a gift, a refund, a transfer between your own accounts.
- Check nothing was returned unpaid in the period. If something was, be ready to explain it.
- Keep the original PDFs unmodified for submission.
The point of the conversion is preparation. What you send is the original.
Joint applications and several accounts
Most applications involve more than one account: a current account, a savings account, sometimes a partner's.
- Send each account's statements separately and completely. A partial set invites questions.
- Transfers between your own accounts appear as a payment on one and a deposit on the other. Being able to point at both sides settles it immediately.
- For your own analysis, merging the statements into one file makes transfers easy to pair up — keep an account column so each row's origin is clear.
A note on privacy
A bank statement is among the most revealing documents you own. Before uploading one anywhere, including here, it is reasonable to ask what happens to it.
- Originals are deleted 24 hours after processing; exports and extracted transactions after 7 days. You can delete everything immediately.
- Account numbers are stored masked.
- Documents are never used to train models.
There is a fuller answer in is it safe to upload a bank statement online, including the questions worth asking of any service, not just this one.
Frequently asked questions
Can I send a converted spreadsheet instead of the PDFs?
Rarely for a mortgage or a consumer loan: lenders want the bank's own document. Business lenders and brokers sometimes ask for a spreadsheet in addition, because it is faster to analyse.
How many months do I need?
Three months is the common minimum for a residential mortgage and six is often requested; business lending typically wants six to twelve. Ask the lender rather than guessing, because sending too few delays the application.
Will one gambling transaction sink my application?
Not usually on its own. Lenders look at pattern and proportion — regular, sustained spending relative to income matters far more than an isolated transaction.
Do I need to explain transfers between my own accounts?
Often yes, because they look like unexplained deposits from the receiving account's side. Showing the matching payment on the other statement resolves it, which is why sending complete sets for every account helps.
Other bank statement converters
About the author
The Banking Converter editorial team is the engineering group that builds and tests the conversion engine: the parsers for regional date and number formats, the reconciliation checks and the CSV, Excel, JSON, OFX and QBO exporters. Guides describe what the software does and what the formats require; they are not financial, legal or tax advice.