PDF Bank Statements to Excel, CSV or OFX: Which to Use
How to get transactions out of PDF bank and credit-card statements, when to pick Excel, CSV or OFX, and how to be sure no transaction went missing.
By Pix2Doc Team,
Banks are happy to give you a PDF statement and much less happy to give you the data inside it. If you need those transactions in a spreadsheet or in your accounting software, the usual options are retyping them, copying and pasting a table that falls apart, or uploading the statement to a converter website and hoping it is handled carefully.
This guide covers a quicker route, which output format to choose, and how to check the result so a missing line doesn't end up in your books.
Step 1: Get the right kind of PDF
Everything depends on the PDF containing real text. Statements you download from online banking almost always do: you can select a word in them with your mouse. A photo of a paper statement, or a scan, is just a picture of text, and no converter can read numbers from it reliably without OCR and a lot of checking.
So before anything else:
- Log in to online banking or your card's app and download the statement as a PDF.
- Prefer full monthly statements over "recent activity" printouts. Monthly statements print an opening and closing balance, which you need for the check in step 3.
Step 2: Choose the output format
The same transactions can come out in three formats. Pick the one that matches where they're going.
Excel (.xlsx): for working with the numbers
Choose Excel if you'll sort, filter, pivot or add up the transactions yourself. A good converter writes dates as real dates and amounts as real numbers, so formulas work immediately instead of treating "1,234.56" as text. Use bank statement to Excel for bank accounts, and credit card statement to Excel for cards, which print their data differently (more on that below).
CSV: for importing into other tools
CSV is a plain text table that almost anything can read: Google Sheets, budgeting apps, scripts and many import screens. It's also what QuickBooks Online accepts when you can't use OFX, in a specific 3-column layout (Date, Description, Amount, with US-style dates). Bank statement to CSV has a "CSV for QuickBooks" option that writes exactly that layout.
OFX: for accounting software
OFX is the format bank feeds use behind the scenes. QuickBooks, Xero, GnuCash and many other bookkeeping apps import it directly, with no column mapping, and it carries the closing balance so the software can confirm the account reconciles. If a bank feed missed a few months, or a new client only has PDFs, PDF bank statement to OFX is usually the fastest way to fill the gap.
In short:
- Analyse spending, build a budget, prepare workpapers: Excel
- Load into Google Sheets, a budgeting app or a script: CSV
- Upload to QuickBooks Online without OFX: CSV for QuickBooks
- Back-fill QuickBooks, Xero or GnuCash: OFX
Step 3: Check that nothing went missing
This is the step most people skip, and it's the one that matters. A statement converter can misread a line that wraps onto two rows, a page break in the middle of a table, or a refund printed with "CR" instead of a minus sign. You won't notice by eye in a 200-row statement.
The statement already contains everything you need to check the result:
- Bank accounts: opening balance + money in − money out should equal the closing balance. If the statement prints a running balance, each row's balance should follow from the one before.
- Credit cards: previous balance + new charges − payments and credits should equal the new balance.
Pix2Doc's converter does this arithmetic for you and shows whether the totals match to the cent. If they don't, it tells you by how much and highlights the rows to look at, so you only check the suspicious lines instead of every one.
Credit-card statements are different
Card statements trip up generic converters because:
- They often show two dates, the purchase date and the posting date.
- Purchases are printed as positive numbers, and payments as negative or with "CR".
- There's usually no running balance, only the totals at the top.
For spreadsheets and accounting imports you want one consistent rule: money out is negative, money in is positive. So card purchases should come out negative and payments and refunds positive, the same as a bank account. The credit card converter keeps both dates and applies that rule.
Is it safe to convert a bank statement online?
A bank statement holds your name, address, account number and every payment you've made. Many converter websites upload the PDF to their servers to process it, and their privacy policies vary.
Pix2Doc reads the PDF entirely in your browser. The statement is never uploaded: the transactions are extracted, checked and turned into Excel, CSV or OFX on your own device. If you want to confirm that, load the page, disconnect from the internet, and convert a statement; it still works. You can read more about what to look for in our checklist for online PDF tools.
Quick answers
Can I convert several months at once? Convert one statement at a time, oldest first. That keeps each balance check meaningful and makes imports line up with your accounting software's running balance.
My bank isn't a big US or UK bank. Will it work? The converter reads the table's column headings and layout rather than relying on a template per bank, so most text-based statements from US, UK, European and Indian banks work.
What about scanned statements? Not yet. Download the PDF from online banking instead; nearly every bank offers one.