How to Convert PDF Bank Statements to CSV
CSV is the lingua franca of financial tooling — but a CSV that imports cleanly needs more than commas. This guide covers what a good statement CSV looks like and how to produce one from a PDF.
What makes a statement CSV import-ready
Import failures almost always come down to formatting details rather than data.
- Unambiguous dates — ISO 8601 (2026-01-31) avoids the DD/MM vs MM/DD trap entirely
- Plain numbers — no currency symbols, no thousands separators
- Proper quoting — descriptions containing commas must be quoted (RFC 4180)
- Consistent columns — same header row and order for every statement
Converting the PDF
Upload the statement to a converter that reconstructs the transaction table from the PDF layout. Verify the preview against the document — transaction count and final balance are the two fastest checks — then download the CSV.
For scanned statements, confirm the converter applies OCR automatically and review any rows flagged with low confidence.
Importing into accounting software
QuickBooks Online accepts 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) CSVs through its statement upload. Xero's importer maps columns interactively. In both cases, a signed amount column or a separate debit/credit pair from the conversion maps directly.