Spreadsheet conversion

Convert bank statements to spreadsheets

A spreadsheet is only useful if the data inside it is consistent. Statements from different months, accounts or banks can use different date orders, amount conventions and column layouts. Appending them without normalising produces a sheet that looks complete but cannot be summed reliably.

FlowParse normalises each statement into the same transaction structure, reconciles the balances, and exports Excel or CSV. It is a conversion workflow, not a bank feed: you keep the original PDFs, and you decide what to do with the structured data.

  • Excel and CSV exports from the same reviewed ledger.
  • Consistent columns across statements, so months can be appended.
  • Page-based allowances: 3 pages free, 100 on Starter, 400 on Pro, unlimited on Business.
  • Batch limits from 1 file on Free to 10 files on Pro and Business.

No card required. 3 processed pages free every month.

How it works

  1. 1

    Choose the statements

    Upload a batch of PDFs within your plan's file limit. Digital and scanned statements can be mixed in the same batch.

  2. 2

    Review each conversion

    Every statement gets its own reconciliation and review flags. Fix rows in the workspace before exporting.

  3. 3

    Export to Excel or CSV

    Download one format, or both, from the same data. Use Excel for analysis and CSV for imports.

Pick the output by what happens next

Excel or CSV
If the next step is…UseWhy
A person reviewing or formatting the dataExcelMultiple sheets, formatting, filters, formulas
An accounting importCSVPredictable, text-based and widely supported
A database or scriptCSVSimple to parse and diff
A pivot table or financial modelExcelNative numeric cells and formulas
A client hand-offExcelReadable without an import step

Batch conversion without losing track

Each PDF becomes its own document with its own extraction report. A batch does not merge statements into one anonymous table, so you can see which rows came from which file. Export per statement, then combine in a spreadsheet if you need a consolidated view.

Batch size depends on your plan: 1 file on Free, 5 on Starter, 10 on Pro and Business. The monthly allowance counts processed pages, not files, so a long statement consumes more of the allowance.

Which statements work

Unsupported or corrupt files fail with an explanation rather than a partial silent result. Password-protected PDFs must be unlocked before upload.

  • Digital PDFs with a text layer: the most reliable input.
  • Scanned PDFs: OCR is used and the result is marked and reviewable.
  • Statements with separate debit and credit columns, or a single signed amount.
  • Headerless layouts, with conservative inference and unresolved-line reporting.
  • UK, US and Australian statement conventions, plus generic international layouts.

The spreadsheet structure

Each export includes a statement summary, reconciliation details, the transaction ledger and an extraction report. The ledger uses one row per transaction with separate debit and credit columns, a balance column when the statement provides one, and review notes for flagged rows.

This structure is intentionally boring. A stable schema is what lets you reuse a pivot table, an import mapping or a formula from one month to the next.

From statement to close

For bookkeeping, export CSV and import into your accounting tool with a saved column mapping. For analysis, export Excel and append the month to a model. For audit work, keep the original PDF alongside the workbook and the extraction report.

If you need bank-specific notes, see the bank pages for Barclays and Chase, or start with PDF to Excel if you are converting a single statement.

Teams that convert statements in batches

Accounting practices

Process client statements at month-end without asking clients for a different export.

Bookkeepers

Turn PDFs into a ledger that can be coded and imported.

Finance operations

Consolidate multiple accounts into a consistent monthly dataset.

Analysts

Build a comparable transaction history from documents that only exist as PDFs.

Questions

Can I convert several statements at once?

Yes, within your plan's batch limit. Each statement stays a separate document with its own report, so you always know which rows came from which PDF.

Do you merge multiple statements into one spreadsheet?

No. Each statement exports separately. That keeps the reconciliation and review notes attached to the right document. You can combine the exports in Excel afterwards.

What counts against the monthly allowance?

Processed pages. A 12-page statement uses 12 pages of the allowance; re-exporting an already processed statement does not use more pages.

Can I convert a statement for accounting software?

Yes. FlowParse produces a CSV with a stable header row. Your accounting tool's import wizard maps the columns; FlowParse does not claim native integrations with specific packages.

Is there a file-size limit?

PDFs are limited to 25 MB in the app, and the processor caps a document at 100 pages.

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.