How to convert a bank statement PDF to Excel
A practical workflow for turning PDF bank statements into clean Excel rows for reconciliation, bookkeeping, and monthly cleanup.
Who this is for
Bookkeepers, small business owners, and anyone cleaning old bank statement PDFs.
What a good bank statement export should look like
The goal is not just getting text out of a PDF. A useful bank statement export should preserve transaction rows with a date, description, debit, credit, and balance where the statement provides one.
Before importing or using the file for reconciliation, scan the preview for shifted rows, merged descriptions, missing dates, and amounts that landed in the wrong column.
- One transaction per row
- Separate debit and credit columns when possible
- No statement headers mixed into the transaction table
- Opening and closing balance lines reviewed separately
When the free conversion is enough
Original PDFs downloaded from online banking are usually the easiest to convert. The rows and columns can often be read clearly without AI.
If the preview looks clean, download Excel and review the totals before doing any accounting work.
When to use AI
Scanned statements, phone photos, and hard-to-read PDFs may need AI. Credits are charged only when AI improves the result.
Try AI when the free preview has missing rows, unclear amounts, or columns in the wrong place.
Step-by-step workflow
Choose Bank Statement
Set the document type to Bank Statement so the output is shaped around transaction fields instead of generic table columns.
Upload the PDF
Try the file free first and review the preview before paying for AI.
Review the preview
Check the first and last rows, amounts, and balance column. If the rows look shifted, try AI.
Download Excel
Download the `.xlsx` file and keep a copy of the original statement for audit or client review.
Review checklist
- Opening and closing balances are not mixed into transaction rows
- Payments and deposits have the correct sign or debit/credit placement
- Multi-line descriptions stay attached to the right transaction
- Fees, transfers, and interest lines are included
- The downloaded workbook opens cleanly in Excel or Google Sheets
Frequently asked questions
Can Excel open a bank statement PDF directly?
Excel can sometimes import simple tables, but bank statements often need cleanup because descriptions wrap, amounts shift, or page headers repeat between rows.
Should I use Excel, CSV, or QuickBooks CSV?
Use Excel for review and cleanup, CSV for flexible imports, and QuickBooks CSV when the next step is a QuickBooks transaction import.