How to convert PDF bank and credit card statements to Excel

To convert a PDF bank statement to Excel, copy the rows, use a converter such as Power Query, or use document AI. Copying works for a page or two. Excel's own Power Query reads text-based PDFs only. Document AI is software that reads a page and extracts its data. It reads scans and any bank's layout, so use it when you handle many banks or many statements each month. If the statement is for your own account, skip the PDF. Many banks and card issuers let you download transactions as a CSV file.

Ways to convert a bank statement to Excel, compared

Two things decide which method works. The first is whether the PDF has selectable text or is a scan, which is only a picture of a page. To test it, try to select a word or search for one. If that works, the PDF has text. The second is how many different banks' statements you handle.

Microsoft's documentation notes that Power Query may not identify rows that run onto a second line, which then need cleaning up. A Microsoft moderator explains why scans fail. An image-only PDF gives the import no text to read, so it comes back empty. For converters and extraction platforms side by side, see the best bank statement extraction software.

What to look for in bank statement to Excel software

Test any tool on your own worst statements before you pay for it. These are the differences that show up.

• Reads scans, not just digital PDFs

  Try a phone photo and an old scan, not only a clean bank download.

• Handles multi-line and multi-page tables

  A description that runs onto a second line, or a table that continues on the next page, still becomes one row per transaction.

• Checks the math

  Balances are reconciled before you download, so a dropped row is caught.

• Shows what it's unsure about

  Low-confidence values are flagged with their source line, not quietly guessed.

• Exports what you use

  Excel, CSV or an API, depending on where the data goes next.

How to convert a PDF bank statement to Excel with Docsumo

Docsumo is an intelligent document processing (IDP) platform. Its bank statement extraction reads statements in any layout, so there's no template to build for each bank, and the result downloads to Excel. It runs in the cloud and isn't a desktop tool for editing PDFs or making searchable files.

Say a client sends you a scanned statement as a password-protected PDF. Save a copy without the password first, because no tool can read a locked file. Then sign up for the free trial with a work email. The trial runs 14 days and covers up to 1,000 pages. Upload the file. PDFs, scans and phone photos all go in the same way.

Docsumo reads the account details, balances and every transaction. It joins tables that run across pages into one table, so a long statement doesn't end up as separate tables. If the model can't read an amount on a smudged line, it marks that field for a person to check. Click that field to see its source line on the page, correct the value, and your correction improves the model.

Before you export, Docsumo checks the running balance against every transaction, so a missed or misread row shows up first. When the balances agree, download the data as an Excel file, or send it to other software through the API and webhooks.

Play video: Bank statement extraction using Docsumo AI [A Quick Guide]

Before and after you convert

• Remove the passwordPassword-protected statements have to be saved without the password, or downloaded again unprotected, before any tool can read them.
• Make sure every page is there and readableCheck the page count ("page 3 of 6") and the period. A missing page means missing transactions. A skewed or blurred scan means misread digits.
• Check the totals in ExcelOpening balance plus deposits minus withdrawals should equal the closing balance. Add a column that recalculates the running balance. Find the first row where your recalculated balance no longer matches the statement. That is the row that was converted wrongly.
• Protect the fileThe spreadsheet holds account numbers and every transaction. Keep it where only the people who need it can open it.

Our take. If the totals add up, you know only that the numbers on that one statement match each other. A lending decision needs several documents to match, such as the deposits on the statement, the pay stubs and the income on the application. We'd judge a conversion tool by how well it helps you check the whole file. On Docsumo's Enterprise plan, cross-document validation does that by checking one document against another.

How to convert a credit card statement to Excel

A credit card statement has the same parts as a bank statement, with a different summary to check. Under the CFPB's Regulation Z, a card statement shows the previous balance and each transaction. It also lists payments and credits, interest and fees, the closing date, the new balance and the payment due date.

For your own card, download the transactions from your card account instead of converting a PDF. American Express, for example, lets cardholders download recent activity and the past six billing statements as a CSV file or for Quicken and QuickBooks. For card statements you only have as PDFs, such as employees' or clients', the methods above work the same way. Docsumo reads those card statements too. It covers 250+ document types and also handles any other document type.

Copy, Power Query or document AI?

Copy and paste, or Excel's PDF import, is enough for one or two statements. For scans, many banks or a large monthly volume, use document AI. It rebuilds the transaction table, checks the balances and sends unsure values to a person before the download. Either way, check that the totals add up before anyone relies on the spreadsheet. Lenders can see how this fits a wider lending workflow.

Book a demo with a few of your own statements, or start a free trial.

Frequently asked questions