How to Convert Bank Statements to Excel for a Loan or Mortgage Application

A mortgage, an SBA loan, a business line of credit — they all ask for the same thing: several months of bank statements, as PDFs. And then someone (you, your accountant, or the broker) has to turn those PDFs into numbers: average monthly deposits, total income, recurring expenses. Copying line by line from a stack of statements is slow and error-prone right when accuracy matters most. Here's the clean way.

Why lenders want statements — and why PDFs slow you down

Underwriters use bank statements to verify income and cash flow. For a self-employed borrower or a business, that means calculating averages and totals across 3, 6, or 12 months. You can't do that on a PDF — you need the transactions in a spreadsheet. And a single mis-typed figure can change a debt-to-income ratio or a qualifying number.

Convert the statements (with a balance check)

1. Open Convert Bank Statements and drop in each statement PDF (or scan).
2. Every transaction is extracted into clean rows — date, description, amount.
3. The balance check matters more here than anywhere. Each statement is reconciled (opening + deposits − withdrawals = closing); if a figure was misread, the row is flagged instead of silently exported — so the totals you hand a lender are right.
4. Export to Excel or CSV.

Turn it into the numbers a lender wants

Once it's in Excel, the analysis is quick:

• Total and average monthly deposits — sum the deposit column, divide by the number of months.
• Recurring expenses / obligations — sort by description to spot rent, loan payments, subscriptions.
• Ending-balance trend — the printed closing balances, month over month.
• Multiple accounts export one worksheet each, so business and personal stay separate.

Tips

• Convert every month the lender asked for — most want the full, unbroken run; a gap raises questions.
• Keep the originals. The lender still needs the official PDF statements; the Excel is your working copy for the totals.
• Scanned or mailed statements work too; the balance check catches OCR misreads before they hit a calculation. See the scanned statement guide.

Is it accurate and private?

Every statement is reconciled the way a bookkeeper would check it, and your file is never stored and never used to train AI — which matters when the document is your full financial history. See our security page.

FAQ

Can I convert a full year at once? Yes — convert each monthly PDF; page packs never expire, so a 12-month application is one sitting.

Does it handle business and personal accounts? Yes — each account exports to its own worksheet.

How much does it cost? 15 free pages on sign-up. Page packs start at $12 and never expire. See pricing.

Convert statements for your application →

Related guides

• Catch-up bookkeeping: convert a year of statements
• Bank statement to CSV: a bookkeeper's guide
• Convert a scanned bank statement (OCR)

---

Convert Bank Statements is a document-conversion tool, not a lender or financial adviser. Always follow your lender's document requirements.