How it works
- 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
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
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.
| Column | Example |
|---|---|
| date | 2026-10-31 |
| value_date | 2026-10-31 |
| description | CARD PAYMENT COFFEE SHOP |
| reference | TXN-88421 |
| debit | 12.40 |
| credit | |
| balance | 1840.22 |
| currency | GBP |
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.