Bank Statement PDF to CSV for Mortgage and Loan Paperwork
Preparing for a mortgage or loan? Convert your statement PDFs to CSV to review deposits before you apply. Your file is never uploaded.
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it.
Steps for loan or mortgage paperwork
- Download each statement your lender has asked for as a PDF (scanned PDFs aren't supported).
- Drop the PDF on the converter box above (or tap the box to pick it).
- Make sure every deposit made it into the table. Those are what a lender asks about.
- Set Export layout to Standard columns (the QuickBooks, Xero and YNAB layouts are free too), choose Download CSV, then sort it by amount, largest first.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-06-15 | Payroll deposit | 2850.00 | |
| 2026-06-18 | Transfer from savings | 5000.00 | |
| 2026-06-20 | Auto loan payment | -412.00 |
Sample rows, Standard columns setting.
CSV notes
- CSV opens in almost anything: spreadsheets, accounting software, budgeting apps and scripts. It's the safest choice when you're not sure what the next tool expects.
Why it fits loan or mortgage paperwork
Before you send statements to a lender, it helps to know what's in them. A CSV lets you sort every deposit by size so you can see which ones a lender might ask about.
Lenders commonly want to know where your down payment and closing funds came from and that your regular income is steady. A sorted CSV helps you spot transfers, cash deposits and one-off amounts before anyone asks, so you can gather paperwork such as gift letters or pay stubs early.
Tip: Sort by Amount, largest first, and write a short note for any deposit that isn't regular pay, such as a transfer between your own accounts or a gift.
Questions
Can I give the CSV to my lender instead of the PDF?
Lenders usually ask for the original statements. Use the CSV for your own review and send whatever documents your lender requests.
How many months should I convert?
Convert the same period your lender asks for, often the most recent two or more months for each account. Your lender sets the requirement.
Should I explain overdrafts too?
Lenders sometimes ask about overdraft or returned-item fees. Filter the CSV for fees so you know whether any appear before you apply.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.