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
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
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
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
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.
- This does not guess amounts off a picture of a statement. If the PDF is a scan, download a CSV or Excel file from the bank instead.
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.