How to convert a PDF bank statement to Excel (and check it ties out)

Updated October 26, 2026

Method 1: Excel's built-in PDF import (free)

1. In Excel for Microsoft 365 on Windows, open Data → Get Data → From File → From PDF and pick the statement.
2. In the Navigator, choose the table that holds the transactions (statements often split one table per page).
3. Click Transform Data to combine the pages, remove summary rows, and set the Date and Amount column types, then Close & Load.

It works best on digital statements with simple tables. It can't read scanned or photographed statements, multi-line descriptions often split into extra rows, and it doesn't check the result against the balance.

Method 2: TieOut (digital or scanned, checked automatically)

1. Upload the PDF. Sign in to TieOut and drop the bank statement PDF. Digital and scanned statements both work.
2. Check the balance. TieOut reads every transaction and checks that opening balance + credits − debits equals the closing balance. Rows that break the running balance are flagged so you can correct them.
3. Export. Download CSV, Excel (.xlsx) or a QuickBooks-ready CSV once the statement ties out.

Free covers 3 statements a month with CSV export; Pro adds Excel and QuickBooks exports. The PDF is deleted as soon as it has been read.

Method 3: Copy and paste by hand

For a one-page statement, selecting the table in a PDF viewer and pasting into Excel can be enough. Use Data → Text to Columns to split the pasted lines, and expect to fix dates, negative amounts in parentheses, and rows that wrapped.

How to check that the spreadsheet ties out

Whatever method you use, add this check before importing anywhere. With amounts in column C (debits negative):

Computed closing = Opening balance + SUM(C2:C36)
Difference       = Printed closing − Computed closing   → must be 0.00

For example, from a real 35-row statement:

If the difference isn't zero, walk the running balance: each printed balance should equal the previous balance plus that row's amount. The first row where it doesn't is the one that was misread. A converter that read 48.22 as 84.22 leaves you off by exactly 36.00.

Stop Excel from changing your numbers

• Opening a CSV directly lets Excel guess types: account and check numbers lose leading zeros and long numbers turn into scientific notation. Import with Data → From Text/CSV and set those columns to Text.
• Store dates as real dates in ISO format (2026-09-30) so they sort and filter correctly.
• TieOut's .xlsx export stores dates as dates and check numbers as text, so nothing changes when you open it.

Importing into QuickBooks Online

QuickBooks Online's bank upload accepts a CSV with three columns — Date, Description, Amount — or four, with separate Credit and Debit columns. Use one date format throughout and remove totals rows before uploading.