PDF to CSV

Convert a bank statement PDF to CSV

CSV is the format that moves data between systems. It is what accounting imports, expense tools and data pipelines expect. It is also unforgiving: one misplaced comma, one text-formatted amount or one locale-specific date can break an import before it starts.

FlowParse turns a bank statement PDF into a consistent CSV with explicit columns and normalised values. You review the extracted rows first, then download a file designed to be parsed rather than admired.

  • UTF-8 CSV with a stable header row you can map once and reuse.
  • Separate debit and credit columns so values stay positive and direction is unambiguous.
  • Descriptions containing commas, quotes and line breaks are quoted correctly.
  • Spreadsheet formulas in statement text are neutralised so a CSV cannot execute them.

No card required. 3 processed pages free every month.

How it works

  1. 1

    Upload the PDF statement

    Create an account and upload the statement. Digital and scanned PDFs are both accepted; scans are processed with OCR and flagged accordingly.

  2. 2

    Check the ledger and reconciliation

    Confirm the row count, opening and closing balances, and review any flagged rows. Fix the source row in the editor if something looks wrong.

  3. 3

    Download the CSV

    Export the same reviewed data as CSV. The header row is stable, so a mapping you create for one statement works for the next.

What a good bank statement CSV looks like

The exact columns depend on the statement, but a useful export keeps direction explicit and avoids mixing presentation with data. FlowParse uses one row per transaction and separate debit and credit columns.

Typical CSV columns
ColumnExample
date2026-10-31
value_date2026-10-31
descriptionCARD PAYMENT COFFEE SHOP
referenceTXN-88421
debit12.40
credit
balance1840.22
currencyGBP

CSV details that decide whether an import works

  • Encoding: UTF-8 keeps currency symbols and non-ASCII merchant names intact.
  • Delimiter: commas are the default. Fields containing commas are wrapped in quotes, and quotes inside a field are escaped.
  • Dates: ISO 8601 (YYYY-MM-DD) is unambiguous. Locale dates such as 03/04/2026 mean different things in different countries.
  • Amounts: values are plain decimals with a dot, not strings with thousands separators or currency symbols.
  • Direction: separate debit and credit columns avoid negative-number conventions that some importers reverse.
  • Formula injection: cells starting with =, +, - or @ are neutralised so a spreadsheet cannot treat statement text as a formula.

CSV or Excel? Choose by destination

Choose CSV when the next stop is an accounting import, a database, a script or a tool that asks for CSV. Choose Excel when a person will read, format, filter or annotate the file, or when you need more than one sheet. The data is the same; only the container changes.

FlowParse can export both formats from the same reviewed statement, so you do not need to convert twice. See Excel vs CSV for bank statement conversion for a longer comparison.

Importing the CSV into accounting software

Most accounting tools let you map CSV columns during import. Map the date, description, amount and balance columns once, then reuse the mapping. If your tool expects a single signed amount column, combine debit and credit in a spreadsheet formula before import.

FlowParse does not connect to your accounting software and does not claim a native integration. It produces a clean CSV that tools accepting CSV can import.

What to verify before importing

  • The reconciliation matches the statement's opening and closing balances.
  • The date range covers the statement period without gaps at page boundaries.
  • The row count matches the statement's transaction count, or flagged rows explain the difference.
  • Your accounting tool's locale matches the CSV date format.

Where CSV exports fit

Accounting imports

Feed a bookkeeping or accounting tool that accepts a transaction CSV.

Data analysis

Load statements into a database, notebook or BI tool with predictable columns.

Expense and audit tools

Hand a client a portable file that opens anywhere without conversion.

Automation

Join monthly exports into a pipeline without parsing a PDF again.

Questions

Will the CSV open in Excel?

Yes. Excel opens CSV files directly. Use Data > From Text/CSV if your regional settings use a different list separator, so the columns are split correctly.

Are amounts stored as numbers or text?

Amounts are written as plain decimals in the file. When Excel opens a CSV it may apply local formatting; import through Data > From Text/CSV and set the amount columns to numeric if you need formulas immediately.

Can descriptions contain commas?

Yes. Fields containing commas, quotes or line breaks are quoted and escaped so the row structure stays intact.

Does the CSV include a running balance?

When the statement prints a running balance, the export includes it. If the statement does not show one, the column is empty rather than calculated.

Is CSV safer than Excel for sharing?

CSV cannot carry macros, so it is simpler to inspect. It also has no formatting, formulas or multiple sheets. Neither format is encrypted; share files through a secure channel.

Convert your first statement free

The Free plan includes 3 processed pages per month. Upload a PDF, review the ledger, and export Excel or CSV when it looks right.