Skip to the converter
StatementZap

Guides

How to convert a bank statement PDF to Excel

Turn a text-based bank statement PDF into an Excel workbook and check the printed totals.

  1. 1

    Use a text PDF

    The statement has to contain real text. A scan or a photo of a page has no text layer, and that file is refused.

  2. 2

    Open the PDF to Excel page

    Upload the PDF. Each posted row needs a date and an amount. A description that wraps onto the next line stays with that row. A header or footer that repeats on every page is not a transaction.

  3. 3

    Read the balance check

    If the statement has a running balance, opening plus the transactions should equal the closing balance. If it only prints opening and closing totals, those totals are checked against the same movement. Balance ties means they agree. Balance off means they do not.

  4. 4

    Download the workbook

    Excel keeps Date, Description, Amount, and the other columns the statement supported. CSV, QBO, and QIF are the same read with a different download.

Questions

The PDF opened but no rows appeared. Why?

The pages did not contain a date and an amount in text. That is the same refusal as a scanned statement.