How to convert a bank statement PDF to CSV

Bank download or PDF conversion?

You can often get bank statement data in CSV format straight from your bank. Look for an export or download option in the transaction history of online banking and choose CSV or a spreadsheet format. Bank exports often cover only a recent window, and their columns differ from bank to bank, but they come directly from the bank’s system.

A PDF statement is the official document for a closed period and is what most people receive for older months, for accounts they no longer have online access to, or from clients and family members. A PDF can be converted to CSV, but the converter has to read a page layout rather than a data file, so the result needs checking before you rely on it.

Why copying from a PDF breaks the rows

Copying text out of a statement PDF, or running a general PDF-to-table converter, works for some layouts and fails quietly on others. Statements are designed to be read, not parsed, and the problems are predictable.

• Descriptions wrap onto a second or third line and turn into extra rows
• Debits and credits sit in separate columns, so a copied amount loses its direction
• Page headers, running balances, and subtotals repeat on every page and mix with transactions
• Dates are printed without a year or only on the first transaction of a day
• Scanned pages contain no text layer at all, so copying returns nothing

What a useful statement CSV contains

Fulla’s CSV has one header row and one row per approved transaction, with these columns. Two of them exist only for checking: source_page lets anyone trace a row back to the PDF, and raw_fields keeps the values as they were read from the page.

• statement_number: which statement in the export the row came from
• date: the transaction date, written year-month-day, for example 2026-09-30
• description: the full transaction description, joined across wrapped lines
• amount: a signed amount, negative for money out of the account
• debit and credit: the same amount as a positive number in the matching column, with the other column left blank
• balance: the running balance where the statement prints one, blank where it does not
• currency: the statement currency
• source_page: the PDF page the row was read from
• raw_fields: the original labeled values from the page, for audit

Opening the CSV in Excel or Google Sheets

The file is UTF-8 with a byte order mark, which helps Excel display accented names and currency symbols correctly. Amounts use a decimal point and no thousands separators, so they stay numeric. If your spreadsheet shows dates in a different order, that is display formatting; the underlying values are still year-month-day.

A description that begins with =, +, minus, or @ is written with a leading apostrophe so a spreadsheet does not treat it as a formula. If you need the plain text in another system, remove that apostrophe there.

If you want a workbook with separate Transactions, Statement, and Original Fields sheets instead of a flat file, the How to convert a bank statement PDF to Excel guide covers the XLSX export, and CSV, XLSX, or JSON for bank statement data compares the formats.

Importing the CSV into other software

Every importer has its own expectations for columns, date formats, and signs. Keep the full CSV as your record and make a trimmed copy for the import. QuickBooks Online, for example, accepts a 3-column or 4-column layout; the CSV to QBO guide walks through the exact changes.

If the destination accepts OFX, consider that instead. QuickBooks Online and Xero both import OFX statement files, and Fulla’s OFX export carries the dates, signed amounts, and a stable transaction ID for each approved row, so there is no column layout to prepare.

For several statements, a paid workspace batch can produce one combined CSV. It adds source_file and document_id columns so each row still points to its statement.

Check the exported CSV before mapping an import

Download the sample CSV and compare its rows with the fictional source PDF. Fulla exports a richer record than a minimal accounting importer expects: preserve the original export, then make a separate mapped copy for the receiving system. Keep dates consistent and confirm that money out is negative and money in is positive for a signed-amount layout.

Do not import the balance, debit and credit fields as additional transactions. CSV text that could be interpreted as a spreadsheet formula is escaped by the exporter; keep that protection when viewing an untrusted description in a spreadsheet. Inspect the raw text and the destination preview before accepting the mapped rows.

• QuickBooks Online: prepare its supported three- or four-column layout and check the chosen account.
• Xero: map Date and Amount, with expenses negative; remove opening/closing balance and account-number columns from the import copy.
• After either import: compare transaction count, signed total and date range, then review duplicates before accepting.