Skip to content

How-to guide

How to convert a bank statement to CSV

Updated June 27, 2026 · 4 min read

CSV is the universal import format — almost every accounting tool and spreadsheet reads it. Here's how to get a clean CSV from a statement PDF and format it for your destination.

Convert the PDF to CSV

Upload the statement PDF to a converter that extracts transactions and exports CSV. Review the rows — date, description, amount, balance — before downloading.

Format the CSV for your accounting tool

Different tools expect different columns. QuickBooks accepts Date/Description/Amount (or Date/Description/Credit/Debit); Xero and Wave have their own column orders. Many converters offer a pre-formatted CSV per tool so you don't have to rearrange columns by hand.

Common CSV pitfalls

Watch for date formats (US vs UK), amount signs (some banks split debit/credit into two columns), and encoding when special characters appear. If numbers look wrong after opening in Excel, it's usually a date-format or decimal-separator mismatch — re-export with the right options.

Ready to convert a statement?

Upload a PDF, review every row, and export in seconds.

Convert a statement
Can my bank export CSV directly?

Some online banking portals offer CSV, but it's often limited to recent transactions or a fixed layout. Converting the statement PDF gives you full control over the date range and columns.

Why does my CSV look wrong in Excel?

Usually a date format or decimal-separator mismatch. Re-export choosing the date format your locale expects, and confirm amounts use the right sign convention.

Related

Convert a bank statement to Excel & CSVCSV vs Excel for bank statementsAll file converters