Bank Statement PDF to Excel Before a Mortgage Application
Review your bank statements in Excel before a mortgage or loan application. Convert the PDFs in your browser. 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).
- Add the file to the converter at the top of this page. Several PDFs can go in together.
- Make sure every deposit made it into the table. Those are what a lender asks about.
- Set Export layout to Standard columns (QuickBooks, Xero and YNAB layouts are free as well), choose Download Excel, then sort it by amount, largest first.
What the file looks like
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-06-01 | Rent payment | -1750.00 | |
| 2026-06-25 | Cash deposit | 600.00 | |
| 2026-06-28 | Student loan payment | -238.00 |
Sample rows, Standard columns setting.
Excel notes
- If you'd rather keep a CSV and open it in Excel, use Data > From Text/CSV so Excel shows a preview and you can check how it reads the date column.
Why it fits loan or mortgage paperwork
Underwriters look closely at deposits and regular payments. Putting your statements into Excel lets you highlight the deposits you'll need to explain and confirm your recurring debts.
Keep a short explanation sheet beside the converted rows: date, amount, source and any document that backs it up. When the underwriter's questions arrive, you'll have answers ready, which can save days of back-and-forth during an application.
Tip: Use conditional formatting to highlight deposits over a level you choose, and add a Notes column with the source of each one.
Questions
Does RowSmith check whether I'll qualify?
No. It only converts your statement. Your lender decides what they need and how they assess it.
What if my statement is a scan from a branch?
Scanned PDFs aren't supported. If a file looks scanned, the tool says so. Download the statement from online banking instead, which is usually text-based.
Can I total my monthly debt payments?
Yes. Filter for loan, card and other recurring payments and sum them by month. Compare that with what your lender has on file.
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.