How it works
- 1
Upload the statement PDF
Create a free account and upload the PDF. Files are stored in a private bucket scoped to your account, and the browser uploads directly with a short-lived signed URL.
- 2
Review the extracted rows
FlowParse shows the ledger it reconstructed, the reconciliation result and any rows that need a second look. Edit a description, date or amount directly in the table.
- 3
Export the Excel workbook
Download a formatted XLSX file with a statement summary, reconciliation details, the transaction ledger, value dates and review notes.
What the Excel file contains
The workbook is designed for analysis, not as a visual replica of the PDF. Each transaction becomes a row, and the columns stay consistent across statements so you can append one month to the next without reworking the sheet.
| Column | What it holds |
|---|---|
| Transaction date | The posting date, normalised to a real spreadsheet date |
| Value date | The value date when the statement provides a separate one |
| Description | The transaction narrative with statement line breaks collapsed |
| Reference | A cheque, transfer or payment reference when the statement includes one |
| Debit / Credit | Separate columns so amounts stay positive and direction stays explicit |
| Balance | The running balance after the transaction, when the statement shows one |
| Currency | A per-row currency when the statement includes more than one |
| Review note | The reason a row was flagged, when it needs attention |
Why copying from a PDF into Excel breaks
A converter avoids those problems by rebuilding the table from the document's geometry and text, then validating the result against the statement's own opening and closing balances.
- A copied PDF line often arrives as one text cell, so dates and amounts need to be split by hand.
- Negative amounts may paste as text, which breaks sums and pivot tables.
- Multi-line descriptions become extra rows, shifting every later transaction.
- Page headers, footers and page numbers land in the middle of the data.
- Scanned statements have no selectable text at all, so copy-and-paste returns nothing.
Digital statements, scanned statements, and OCR
Digital statements carry a text layer. FlowParse extracts words and positions directly, which is fast and precise. Scanned statements are images, so the processor renders each page and runs OCR before parsing. OCR is slower and less certain, so any page that relies on it is marked and its rows are reviewable.
The extraction engine uses conservative bank profiles for several UK, US and Australian banks. A profile changes defaults such as currency and date order; evidence in the document always wins. If a layout is unfamiliar, FlowParse reports unresolved lines instead of fabricating transactions.
What to check before you rely on the numbers
- The opening balance plus credits minus debits should equal the closing balance. FlowParse shows this reconciliation for every statement.
- Look at the count of flagged rows. A clean statement should have none or very few.
- Spot-check the first and last transaction against the PDF, especially on scanned pages.
- If you edited rows, re-check the reconciliation before exporting.
When a PDF-to-Excel converter is the wrong tool
If you have direct bank feeds in your accounting software, use those for day-to-day bookkeeping; they are more complete than a monthly PDF. If you need the visual statement preserved for an audit file, keep the original PDF alongside the workbook.
A converter is the right tool when the statement only exists as a PDF, when the client cannot share a bank feed, or when you need a transaction table for analysis outside the accounting system.
Who uses PDF-to-Excel conversion
Bookkeepers
Turn client statements into a ledger you can code and import without retyping a month of transactions.
Accountants
Produce consistent working papers for month-end, loan applications and audits.
Finance teams
Consolidate statements from several accounts into one analysis-ready sheet.
Individuals
Get a clean transaction list for a mortgage application, expense claim or personal budget.
Questions
Does this work with password-protected bank statements?
No. FlowParse rejects encrypted PDFs with a clear error rather than guessing at the contents. Open the statement with your bank's password, save or print an unprotected copy, and upload that.
Will the Excel file look exactly like the PDF?
No. The export is a data workbook with one row per transaction, not a visual copy of the statement. That is deliberate: a clean table is what Excel formulas, pivot tables and accounting imports need.
Can I convert a scanned bank statement to Excel?
Yes. Scanned pages are rendered and processed with OCR, then parsed like a digital statement. OCR pages are marked, and low-confidence rows are flagged so you can review them before exporting.
How many statements can I convert for free?
The Free plan includes 3 processed pages per month, one PDF per upload batch and a 25 MB file limit. Paid plans raise the monthly page allowance and batch size.
Are my bank statements stored permanently?
Statements are stored privately in your account so you can review and re-export them. You can delete a statement at any time, which removes the document record and attempts to remove the stored PDF.