Guides

How to Convert a Bank Statement PDF to CSV

A CSV file is the most useful form a bank statement can take. It opens in Excel, Google Sheets, and almost every accounting tool. This guide walks through the whole job: how to get the right PDF from your bank, how to convert it with the bank statement converter, how to prove the numbers are right, and what to do when something goes wrong.

What a CSV file is, in plain words

CSV stands for comma-separated values. It is a text file. Each line of the file is one row of a table. Commas split the line into columns. That is all there is to it. There is no styling, no color, and no hidden code.

This plain shape is why CSV is so popular. Excel can open it. Google Sheets can open it. Most bookkeeping tools can import it. If a tool takes any file at all, it almost always takes CSV.

A bank statement as a CSV has one row per transaction. The columns are the date, the text of the transaction, the money out, the money in, and the balance. Once your statement looks like that, you can sort it, filter it, add it up, and hand it to your accountant.

Step 1: Get the right PDF from your bank

The conversion can only be as good as the file you start with. The right file is the PDF statement your bank makes for you. You can download it from your bank's website or app. Most banks keep PDF statements for years — far longer than the few months of transactions they offer as a quick download.

Our per-bank download notes show where the download lives for the banks we know best, from Chase and Bank of America to CommBank and HDFC. The path is almost always the same idea: sign in, open the account, find Statements, pick the month, and save the PDF.

One warning matters more than any other. Do not scan a paper statement and upload the scan. A scan is a photo of text, not text. There is nothing inside it for software to read. Our guide on scanned and digital statements explains the difference with pictures. If you have paper, go back to the bank's site and download the PDF version of the same statement. It is the same document, but in a form that can be read and checked.

Step 2: Convert the PDF

With the PDF saved on your computer or phone, the conversion itself takes under a minute for most statements:

1. Open the converter and drop the PDF into the upload box, or tap to pick the file.
2. If the PDF asks for a password, type it in the field under the upload box. Some banks lock their statement PDFs. The password is used once, to open the file, and is never stored.
3. Wait while the file is read. You will see the pages count as they are processed.
4. Read the result. Each transaction is a row you can edit. Nothing is final yet.
5. Check the balance result at the top of the page (the next section explains it).
6. Download the CSV. On a free account, CSV and Excel downloads are included, and the file holds every row — exports are never cut short.

You can convert several statements in one go. Free accounts take batches of up to 5 files at once, and paid plans take up to 20. Each file is read and checked on its own. If you convert statements for a client, this batch flow is the one you will live in: drop a quarter's worth of PDFs, check each one, download them all.

Step 3: Check the balance before you trust the file

Here is the part most people skip, and it is the part that matters most. A converted file can look perfect and still be wrong. A row can be missed. A row can be read twice. A digit can be swapped. Your eyes will not catch these. Math will.

Every statement prints two numbers that let you test the work: the opening balance and the closing balance. The test is simple:

Opening balance + all money in − all money out = closing balance.

StatementConverter runs this test for you on every statement and shows the result before you download. If the rows add up, the result says Reconciled. If they do not, you see the exact difference and the rows most likely to explain it — a row equal to the difference, a row that appears twice, or the row where the running balance chain breaks. You can fix rows right there, in the table, and the check runs again each time you save.

Why insist on this? Because the cost of a wrong row is paid later, with interest. A missed fee becomes a wrong tax return. A doubled deposit becomes income you never had. Two minutes of checking now is cheaper than two days of fixing later. Our guide on why a converted statement does not balance lists the usual causes and how to hunt each one down.

Step 4: Open the CSV in Excel or Google Sheets

Double-click the CSV and it will most likely open in Excel. In Google Sheets, choose File, then Import, then Upload. A few practical notes:

• Dates come out in ISO form (2026-01-03). That is on purpose: every tool reads it the same way, and it sorts correctly.
• Amounts are plain numbers, so sums and filters work at once. Money out and money in sit in their own columns, and there is also a single signed Amount column if your tool prefers that shape.
• If a description starts with a zero or looks like a date, Excel may try to be clever with it. This is an Excel habit, not a flaw in the file. Widening the column or setting it to Text fixes the display; the file itself is unchanged.
• Save a copy as .xlsx if you plan to add notes, colors or extra sheets, so the plain CSV stays as your clean original.

If your real goal is a spreadsheet you can work in — with a summary sheet and tidy formatting — the Excel download does that in one step. Our companion guide on converting a statement PDF to Excel covers when to pick which file.

Common problems and what to do about them

One more case deserves a line of its own. If a statement fails to convert at all — no table found, or the file will not open — its pages are not charged to your account. You only spend pages on statements that convert. And if a bank's layout beats the reader, sending the details to support genuinely helps: layout reports are how the reader learns new banks.

When CSV is not the right file

CSV is the best general choice, but it is not always the final stop. If the file is headed for QuickBooks, a QBO file imports with no column mapping at all — see our guide to importing statements into QuickBooks. If it is headed for Quicken or Xero, OFX is the native tongue. Our guide to OFX, QBO and QIF formats explains which tool wants which file, and why.

Whatever you choose, keep the habit from Step 3: check the balance first, download second. A statement that reconciles is a statement you can file, send and forget. A statement that almost reconciles is a problem that waits for the worst day to be found.

A worked example, start to finish

Meet a typical job. Ana keeps the books for a small design studio. The studio's March statement lands in her inbox as a PDF: four pages, 63 transactions, opening balance $4,102.55. The bank's own CSV download only covers the last 90 days and March is long past, so the PDF is the only route.

She drops the PDF into the converter. It is not locked, so there is no password step. The read takes seconds. The result page shows the balance check first: opening $4,102.55, money in $11,240.00, money out $9,874.31, closing $5,468.24 — Reconciled. She spot-checks two rows against the PDF (the biggest deposit and one row near a page break), downloads the CSV, and imports it into the studio's bookkeeping tool with the date, description and amount columns mapped once. Total time, including the checks: about four minutes. The old way — typing 63 rows by hand — used to take her an hour, and the typing errors took another hour to find at month end.

Notice what did the work in that story. Not speed — the check. Because the statement reconciled, Ana did not have to wonder whether row 41 was missing. The math had already answered.

Naming and filing the CSV

A converted file tends to live longer than you expect. It will be opened at tax time, requested by a lender, and searched for in a hurry. Give it a name that answers three questions at a glance: whose statement, which account, which month. StudioBank_Checking_2026-03.csv beats statement.csv in every future search. Keep the CSV in the same folder as the PDF it came from, and keep one folder per account per year.

How long should you keep them? US tax guidance says records that support income and deductions generally need to be kept for years, not months — three years is a common floor, and some records need seven. The IRS pages in our sources below give the exact periods. Storage is cheap; a missing year of statements during an audit is not.

CSV small print: separators, quotes and accents

Three quirks of the format are worth knowing before they surprise you. First, quoting: if a description itself contains a comma — 'Smith, Jones and Co' — the field is wrapped in quote marks so the comma is not mistaken for a column break. Every serious tool handles this; if a home-made import breaks on such rows, quoting is why. Second, separators: a few countries' spreadsheet settings expect semicolons instead of commas, because their decimal numbers use commas. Our files use commas, the worldwide default; if your Excel shows one wide column, import via Data → From Text/CSV and choose comma. Third, characters: names with accents (José, Müller) are stored in UTF-8, the universal text encoding. Modern Excel and Google Sheets read it correctly; very old spreadsheet versions may show odd characters, which is a display issue in the old tool, not damage in the file.

None of these quirks changes the numbers. They are display and parsing manners, and they are the reason the balance check belongs before the download: once the rows are proven, every later quirk is cosmetic and fixable, never financial.

Sources and further reading

• What kind of records should I keep? — Internal Revenue Service (IRS)
• How long to keep records — Internal Revenue Service (IRS)
• Regulation E, §1005.9: what a periodic statement must show — Consumer Financial Protection Bureau

More guides

How to Convert a Bank Statement PDF to Excel · How to Import Bank Statements into QuickBooks (QBO Files) · OFX vs. QBO vs. QIF: Which Format Should You Download? · Why a Converted Bank Statement Does Not Balance — and How to Fix It · How to Check a Converted Bank Statement Is Correct · Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not · How to Convert a Password-Protected Bank Statement PDF · How to Convert Many Bank Statements at Once (and Merge Them Cleanly) · Is It Safe to Convert Bank Statements Online? A Privacy Checklist