How to convert a PDF bank statement to Excel, CSV or QBO

Why a PDF statement does not paste as a table

As Microsoft's page on opening PDFs in Word explains, a PDF stores a table as lines, with nothing linking them to the text in the cells, so whatever reads it has to guess where the columns are. Statements make that harder: money in and out may be two columns or one signed column with CR and DR markers or parentheses, descriptions run over several lines, and tables continue over several pages. And a table that looks right can still be wrong: a missed row or a misread digit only shows when you compare the transactions with the opening and closing balance.

Option 1: download the transactions from online banking

If you can still sign in to the account, look for a download of the transactions as CSV, OFX, QFX or QBO: then nothing needs converting. QuickBooks Online accepts .csv, .txt, .qbo, .ofx and QFX files from your bank, and Web Connect in QuickBooks Desktop reads .qbo files. Not every bank offers every format or the period you need, and it does not help with a statement a client sends you as a PDF.

Option 2: QuickBooks Online's statement upload

If your books are in QuickBooks Online, the same Intuit page says you can upload an account statement as a PDF or an image (JPG, PNG or HEIC) from any bank, as long as it is in English. QuickBooks extracts the transactions, you compare them side by side with the statement before saving, and Intuit says its team may review your statement. You get no Excel or CSV file for other software, and statements in other languages are not covered.

Option 3: copy and paste, or open the PDF in Word

For a short statement, pasting the table from a PDF viewer into Excel can be enough, if you fix columns, split descriptions and signs by hand. Word can also open a PDF: it converts a copy into a Word document and tries to match the layout. Microsoft says this works best with files that are mostly text, names tables with cell spacing among the known problems, and warns that when a PDF is mostly graphics, whole pages may show up as pictures. A scanned page is a picture too.

Option 4: Excel's Get Data From PDF

1. Choose Data, Get Data, From File, From PDF.
2. Pick the statement and select Open. The Navigator shows the tables Excel found.
3. Select the tables and choose Load, or Transform Data to clean them up in Power Query first.

Microsoft's table of Power Query data sources lists PDF for Excel with a Microsoft 365 subscription on Windows, not for Excel 2016, Excel 2019 or Excel for Mac, and it needs .NET Framework 4.5 or later. Microsoft's PDF connector page says rows over several lines are not always recognised and may need clean-up. You get a table, not a checked statement: the balances, the signs and any QBO or OFX file are still up to you.

Option 5: Ledgerwright ($24.99)

Ledgerwright is a Windows app from Karelia Labs for bookkeepers and small-business owners. It reads bank and credit card statements in PDF on your own PC, scans included (with the text recognition built into Windows), and exports Excel (.xlsx), CSV, QBO, OFX, QFX, QIF and JSON. It works offline, with no account and no telemetry. It costs $24.99 in the Microsoft Store: Get it from Microsoft Store.

1. Open one or more statements, or try the bundled samples first. For a password-protected PDF, Ledgerwright asks for the password and does not keep it.
2. Read the check result: Balances reconcile, Does not add up with the rows that do not add up marked, or Could not check when the statement does not show its balances.
3. In the review grid, edit any cell, delete, merge and split rows, flip a sign, fix the year or swap day and month. If the columns were found wrongly, drag their boundaries in the column mapper and save them as a template for that layout.
4. Export, one file per statement or many statements in one workbook with a summary sheet.

The check. Ledgerwright finds the opening and closing balance on the statement and checks that the opening balance plus every transaction equals the closing balance, and that every running balance printed on the statement matches the rows above it. The check runs again after every edit. A statement that failed or could not be checked is never shown as correct, and its exported files say "not reconciled" in their name.

CSV files from online banking can be turned into QBO, OFX or QIF too, and account and card numbers can be masked in exported files.

Which format to export

What to expect

• No converter reads every statement right. Look through the rows before you export. The balance check is there to catch a missed row, a misread digit or a wrong sign. Could not check means the opening or closing balance was not found: the rows may be right, but nothing has confirmed it.
• Two decimals only. Currencies without decimals, such as the Japanese yen, are not read.
• Without a known header and without balances on the page, which money column is which is a guess (noted on the statement), and the check cannot run.
• Rows across pages. When a page has no header and a row began on the previous page, wrapped lines at the top of the next page are dropped.
• Credit cards are recognised by keywords. A card statement without them is read with bank signs, and the check then fails.
• Encrypted PDFs. Only RC4 40-bit encryption was tested; AES-encrypted PDFs have not been tested.
• QBO, QFX and OFX were checked by reading them back with Ledgerwright's own reader, not by importing them into any accounting program. How a program imports them depends on the program and its version, so check your first import.
• Scans need a Windows language with text recognition installed; paper statements must be scanned first. In our test with a scanned statement (200 dpi greyscale with noise, Swedish text recognition), all 24 dates, amounts and balances were read right, 21 of 24 descriptions exactly right, and the check passed.
• Our tests used statement PDFs we generated ourselves in many layouts. With layouts it had not seen before, Ledgerwright did not always read every row right at first, but the check never passed on wrong rows: it said Could not check instead.
• Windows only: Windows 10 version 2004 or later, or Windows 11, 64-bit (x64).

If your bank delivers camt.053 or MT940 files, nothing needs to be read from a PDF: see how to open camt.053 and MT940 bank statement files.

The QuickBooks details are from Intuit's help pages, Excel's PDF import and Word's PDF conversion from Microsoft Support and Microsoft Learn, and the OFX and QIF names from the GnuCash manual, all checked on 15 November 2026. Ledgerwright's results are from our own tests with statement PDFs we generated in different layouts; its QBO, QFX and OFX files were checked by reading them back, not by importing them into an accounting program.