Home › Guides › How to convert a bank statement

How to convert a bank statement

A bank statement PDF is a print layout, not data. Converting it means extracting the transactions as rows — date, description, amount, balance — and writing them in a format your software can use. This guide covers the whole process, for any bank.

Drag & drop statement PDFs hereor tap to choose files — multiple PDFs for batch mode

Privacy: uploaded files and generated exports are stored only briefly to complete your download and are automatically deleted within 15 minutes. Files are never used for any other purpose.

Step by step

  1. Get the statement as a PDF. Sign in to online banking, open the account's Statements or Documents section, choose the period, and download the PDF. Avoid screenshots — a real PDF preserves the table layout (and scans can still be read with OCR).
  2. Choose the target format. Excel for review and analysis, CSV as the universal format, the three-column QuickBooks CSV for QuickBooks Online, or the Xero CSV layout for Xero. Decide before converting so the columns come out right.
  3. Convert the PDF. Upload the PDF to a statement converter. The tool detects the statement's column layout, extracts each transaction, and normalizes the columns.
  4. Verify with reconciliation. Check that the extracted transactions add up to the statement's opening and closing balances. If a converter does not offer this check, total the Amount column yourself and compare it with the statement before importing anything.
  5. Import and reconcile in your software. Import the file, then reconcile the period in your accounting software against the statement. Work one month at a time on catch-up jobs.

Questions and answers

Can I convert a bank statement by hand?

For a handful of transactions, typing works. Beyond a page or two it becomes slow and error-prone, and there is no built-in check — a converter with reconciliation is faster and proves its own totals.

What if my statement is a scan or photo?

Use a converter with OCR (optical character recognition). OCR results should always be reconciled against the statement's balances and flagged rows reviewed, because OCR can misread digits.

What does the reconciliation check do?

Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.

Are my statement files kept?

No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.

Related reading from the blog

Reconciliation & Verification · November 3, 2026

What reconciled, flagged, and unverified actually mean

Understand what reconciled, flagged, and unverified verification outcomes mean for a converted statement, and what to do next with each one.

Excel, CSV & Google Sheets · November 4, 2026

How to Clean Up a Converted Bank CSV

Remove header blocks, page-title rows, subtotals, blank rows, and stray characters from a converted bank CSV so it imports cleanly the first time.

Excel, CSV & Google Sheets · November 3, 2026

Google Sheets Bank Statement Workflow

Import a converted bank statement CSV into Google Sheets, protect the header, filter and sort safely, and total categories with simple formulas.

More on the StatementVerified blog.

All guides

How to convert a bank statement · How to convert a bank statement PDF to Excel · How to import a bank statement into QuickBooks Online · How to import a bank statement into QuickBooks Desktop · How to import a bank statement into Xero

Bank statements in. Clean books out.

Your first conversion is free — no card, no sign-up — and every result is reconciled against the statement itself before you download it.

Convert a statement — free