Skip to content
Banking Converter
Convert

How to convert bank statements to CSV

By the Banking Converter editorial team

Published

To convert a bank statement to CSV, extract the transaction table from the PDF, decide on a column layout (signed amount, or separate debit and credit columns), write amounts as plain decimals and dates in one consistent format, and verify the rows against the statement's balances. A converter with reconciliation does the extraction and the verification; the choices below determine whether the CSV imports cleanly.

Choose the column layout first

Importers are fussy about columns. Decide where the CSV is going before you convert.

LayoutColumnsTypical destination
StandardDate, Description, Amount (signed)QuickBooks Online 3-column, Wave, scripts
AccountingDate, Description, Debit, Credit, BalanceXero, Sage, QuickBooks 4-column, reconciliation
FullTransaction Date, Posting Date, Description, Payee, Reference, Check Number, Debit, Credit, Amount, Balance, Currency, AccountData warehouses, audits, custom mappings

The CSV converter offers exactly these three profiles.

Get the signs right

In a signed-amount layout, money in is positive and money out is negative. Banks print the opposite convention on some statements (debits as positive numbers in a Withdrawals column), so a naive extraction produces inverted signs. Check one known transaction, such as a salary deposit, before importing. For credit cards the natural convention is reversed: purchases are negative (they increase what you owe) and payments are positive.

Numbers and dates

  • Write amounts without thousands separators or currency symbols: 1234.56, not $1,234.56. A comma inside a number is a classic cause of shifted columns.
  • Use a dot as the decimal separator unless the destination is a European Excel that expects a comma; in that case use the semicolon delimiter so the comma is free for decimals.
  • Pick one date format and stick to it: YYYY-MM-DD is unambiguous and sorts correctly as text; MM/DD/YYYY and DD/MM/YYYY are both common and are the main source of silent import errors (12 March becomes 3 December).
  • Quote any field containing the delimiter, a quote or a line break, per RFC 4180.
A correctly formed accounting-profile CSV
Date,Description,Debit,Credit,Balance
2026-08-02,"Payroll deposit ACME Design LLC",,2500.00,10920.00
2026-08-03,"Card purchase Fresh Market #214",84.17,,10835.83

Converting a PDF statement

  1. Upload the PDF to the CSV converter. Text and scanned files are accepted on every plan; password-protected PDFs need a paid plan.
  2. Select CSV, then the profile, delimiter and date format.
  3. Review flagged rows against the highlighted source line; fix anything the parser was unsure about.
  4. Download. The Conversion Report (available in the Excel and JSON exports, and shown on screen) records whether the balance equation and running-balance chain held.

Encoding and Excel

Save as UTF-8. Excel on Windows only recognises UTF-8 automatically when the file starts with a byte-order mark; without it, accented characters in descriptions turn into mojibake. The converter writes the BOM for this reason. Google Sheets and most accounting importers ignore the BOM harmlessly.

Frequently asked questions

Should I include the balance column?

Include it when the destination accepts it or when you want to verify the import: the running balance lets you spot a missing row instantly. Most importers ignore extra columns; QuickBooks Online's 3- and 4-column formats do not accept a balance column, so use the standard profile there.

Why did my import shift columns?

Almost always a comma inside an unquoted field: a thousands separator in an amount or a comma in a description. Use plain decimals and quoted text, or switch to the semicolon delimiter.

About the author

The Banking Converter editorial team is the engineering group that builds and tests the conversion engine: the parsers for regional date and number formats, the reconciliation checks and the CSV, Excel, JSON, OFX and QBO exporters. Guides describe what the software does and what the formats require; they are not financial, legal or tax advice.