How many months of bank statements do I need for a mortgage?

For a conventional loan, usually the two most recent months to document assets. Self-employed borrowers using a bank-statement loan typically need 12 to 24 consecutive months, because the lender averages deposits to calculate qualifying income. Ask your loan officer for the exact requirement before gathering documents.

Will a lender accept a CSV or spreadsheet instead of PDF statements?

Almost never as a substitute. Underwriters need the complete official statements, every page, to trust them. A spreadsheet is a supplement: it helps you summarize deposits, answer questions about large transactions, and keep two years of activity searchable. Send the official PDFs unless your lender specifically asks for an export.

Why does the underwriter keep asking about specific deposits?

Any deposit that doesn't fit your normal income pattern has to be sourced — the lender needs to confirm it isn't an undisclosed loan. Expect to document large or unusual deposits with invoices, transfer records, or a signed letter of explanation. A searchable spreadsheet of all 24 months makes finding those transactions fast.

Is it safe to convert bank statements on a free converter website?

Check how the tool handles files before uploading anything. Statements contain your name, address, account numbers, and full transaction history. Prefer converters that process files locally in your browser so nothing is uploaded to a server; if a tool does upload, read its retention and deletion policy first.

Bank Statement to CSV for a Mortgage Application

Why lenders ask for so many statements

For a conventional mortgage, the lender is verifying assets: where your down payment sits, whether you'll have reserves after closing, and whether any of the money appeared suddenly from an undisclosed loan. That usually means the most recent two months of statements for every account used to qualify.

Self-employed borrowers often land on a different product: the bank-statement loan. Instead of W-2s and tax returns, the lender calculates qualifying income from 12 to 24 months of personal or business bank statements, averaging eligible deposits across the period. SBA and other small-business loans follow similar logic — statements show real cash flow, not just what's left on a tax return after deductions.

Either way, the underwriter reads the same signals: deposit consistency, average balances, NSF and overdraft activity, and large deposits that need a paper trail.

Loan type	Statements typically requested	What the lender is measuring
Conventional / government-backed	Most recent 2 months per account	Down payment, reserves, sourced funds
Bank-statement loan (self-employed)	12–24 consecutive months	Average monthly deposits as qualifying income
SBA / small-business loans	Varies — often 3–12 months plus financials	Business cash flow and ability to repay

Exact requirements are set by your lender and loan program, so confirm before you gather — but nobody ever lost a deal by having more complete statements than asked for.

What underwriters actually want

Requirements vary by lender, but the standard is strict about one thing: completeness.

The official statements as the bank issued them — every page, including the blank ones and the disclosures.
Consecutive months with no gaps. A missing month restarts the questions, not just the count.
Every account used to qualify, for the full period.

A CSV or spreadsheet almost never substitutes for the official PDFs — underwriters need the bank-issued documents to trust them. Where the spreadsheet earns its keep is preparation: summarizing 24 months of deposits for a bank-statement loan, locating the large deposits you'll need letters of explanation for, and answering underwriter conditions in hours instead of days.

Common reasons applications stall

Unsourced large deposits. Anything outside your normal pattern needs documentation.
Gaps in the statement sequence. Even one missing month triggers a condition.
NSFs and overdrafts. Not always fatal, but expect questions.
Commingled funds. Personal and business money in one account makes income calculation slower and messier.

A clean, complete spreadsheet addresses the first two directly and makes the rest easier to explain.

Submitting the package without creating new problems

Use the lender's secure portal, not email. Statements over email sit unencrypted in inboxes and sent folders forever.
Don't redact or "clean up" the PDFs. Altered statements get rejected and raise fraud flags; if an account number must be masked, the lender will tell you exactly how they want it done.
Include an index if you have several accounts. One page listing account, institution, and months covered saves the underwriter a hunt and saves you a condition.
Keep personal and business accounts in separate, labeled batches. Bank-statement loan income calculations treat them differently.

Turning two years of PDFs into one spreadsheet

The batch workflow is mechanical once you standardize it:

Download every statement as PDF, named consistently — business-checking-2024-07.pdf style — so sorting works.
Convert each PDF to CSV or Excel. One file per statement, one file per account.
Standardize columns before combining: date, description, signed amount, account, source statement.
Concatenate into a single master sheet, or one tab per account with a summary tab on top.
Add a monthly summary per account: opening balance, total deposits, total withdrawals, closing balance.

That monthly summary is where a bank-statement loan's income calculation starts, and it's the first place you look when a condition comes back.

Reconciliation is your proof of completeness

When you're the one assembling two years of records, you carry the risk that something was dropped — a missed page, a failed download, a conversion that silently lost rows. One simple proof catches all of it, because every statement prints its own checksum:

Opening balance + total deposits − total withdrawals = closing balance

Recompute that for every converted statement. If all 24 months tie to the penny, the spreadsheet is complete and unaltered, and you can trace any number in it back to the source document with confidence. ReconCSV runs this check as part of conversion and flags any statement that doesn't reconcile — worth having when you're converting a 24-file batch at 11 p.m. before a conditions deadline.

Privacy: think about where the PDFs go

A bank statement is a full identity kit: name, address, account numbers, balances, and a transaction history that reveals far more. Uploading 24 of them to a random free converter means trusting an unknown operator's servers, retention policy, and security with exactly the documents your lender tells you to protect.

Prefer tools that process files locally in your browser, so the PDFs never leave your machine — ReconCSV works this way, with nothing uploaded to a server. If you must use a server-side tool, read the retention policy first and delete your uploads when you're done.