How to Convert Bank Statements to CSV (Without Losing Data Accuracy)

If you've ever tried converting a bank statement PDF to CSV and ended up with

a jumbled mess of merged cells, missing rows, or split transaction

descriptions — you're not alone. This is one of the most common data pain

points for accountants, bookkeepers, and anyone who does their own finances.

In this post, I'll walk through why this happens, what the right approach

looks like, and how to get clean, analysis-ready CSV output from any bank

statement.

Why Bank Statement PDFs Are So Hard to Parse

Bank statements aren't structured documents — they're designed for printing,

not data extraction. Here's what generic converters run into:

• 
  Merged cells: PDF renderers often group date + description + amount
  into a single visual block. Naive converters pick one cell boundary and
  split it wrong.


• 
  Multi-line transactions: A single transaction entry (especially with
  memos) can span 2–3 lines in the PDF, but gets split into separate rows
  in the spreadsheet.


• 
  Negative vs. positive amounts: Debit/credit columns vary by bank.Chase uses a single "Amount" column with negatives for debits. BoA uses
  two separate columns. A generic converter treats them identically and
  produces wrong signs.


• 
  Running balance drift: If even one row is misaligned, every balance
  figure below it is off.

Method 1: Manual Copy-Paste (What You're Probably Doing Now)

The baseline. Open the PDF, select all, paste into Excel, then spend 30

minutes fixing column alignment.

Pros: Free, no tools required.

Cons: Slow (20–40 minutes per statement), error-prone, completely

unscalable if you have multiple accounts or months to process.

Method 2: Python + pdfplumber

For developers who want a scriptable solution:

import pdfplumber

import csv



with pdfplumber.open("statement.pdf") as pdf:

    rows = []

    for page in pdf.pages:

        table = page.extract_table()

        if table:

            rows.extend(table)



with open("output.csv", "w", newline="") as f:

    writer = csv.writer(f)

    writer.writerows(rows)

This works reasonably well for simple, text-layer PDFs. But it breaks on:

• Scanned/image PDFs (no text layer to extract)


• Non-standard table layouts


• Banks that render statements as one continuous text block without table
  structure (US Bank, some credit unions)

You'll also need bank-specific post-processing to normalize column names,

handle debit/credit sign conventions, and filter out header/footer rows.

Pros: Scriptable, free, good for clean PDFs.

Cons: Breaks on scanned documents, needs per-bank customization.

Method 3: AI-Powered OCR (Best Accuracy)

This is what actually works reliably across different banks, statement

formats, and even photographed documents.

The key difference: instead of trying to detect table boundaries from PDF

structure (which is unreliable), a vision model looks at the document the

way a human does — reads column headers, understands that "Withdrawal" means

debit, knows that a running balance should decrease when there's a debit —

and extracts accordingly.

We built CleanStmt specifically for this use case.

It uses Claude's vision API to extract transactions digit-by-digit, outputs

clean CSV (and Excel, QBO, QIF, OFX) with no merged cells, and handles 17+

major banks including Chase, Bank of America, Wells Fargo, and Citi.

The extracted CSV structure is consistent regardless of source format:

Date,Description,Amount,Balance

2024-01-03,AMAZON.COM*1A2B3C,-42.99,1957.01

2024-01-05,DIRECT DEPOSIT EMPLOYER,2500.00,4457.01

2024-01-07,WHOLE FOODS MARKET #123,-87.50,4369.51

No merged cells. Amounts with correct signs. Dates in ISO format. Ready for

pivot tables, VLOOKUP, or import into any accounting tool.

What to Look for in a Bank Statement to CSV Converter

Whether you build your own or use a tool, the output should pass these checks:

• [ ] Row count matches the transaction count on the last page of the statement


• [ ] Sum of Amount column reconciles with (closing balance − opening balance)


• [ ] No merged cells in the CSV (check by opening in a text editor)


• [ ] Multi-line descriptions are joined, not split into separate rows


• [ ] Debits are consistently negative, credits consistently positive

If any of these fail, your data has integrity issues — and downstream reports

or QuickBooks imports will silently be wrong.

Recommended Workflow

1. 
   For a one-off statement: Use an AI-powered converter. Fastest path to
   clean data.


2. 
   For recurring monthly processing: Script it with pdfplumber + a
   post-processing layer, or use a tool with API access.


3. 
   For scanned/photographed statements: AI OCR is the only reliable
   option. pdfplumber can't read image-only PDFs.

The goal isn't just getting rows out of a PDF — it's getting rows you can

trust. The merged cells problem is a symptom; the root cause is treating a

financial document like a generic table. Once you account for bank-specific

conventions and use a parser that understands financial context, CSV

conversion becomes a solved problem.

If you run into a specific bank or format that's giving you trouble, drop a comment — happy to help debug.