Why bank statement PDFs are such a pain
A client sends you six months of bank statements. They're PDFs. You need the transactions in Excel so you can reconcile, categorize and import them into your accounting software.
Copying and pasting from a PDF rarely works. Columns collapse into one, dates break across lines, and the table stops and restarts on every page. Retyping hundreds of rows by hand takes hours and invites typos.
There are three practical ways to convert a bank statement PDF to Excel. Which one you use depends on whether you can log in to the bank, whether the PDF is digital or scanned, and how many statements you have:
Download the data straight from the bank (fastest, if you have access)
Use Excel's built-in "Get Data From PDF" (free, for digital PDFs on Windows)
Use an AI converter (for scanned statements, many banks, or large batches)
At the end, there's a 30-second check to make sure the numbers in your spreadsheet actually match the statement.
Method 1: Download a CSV or Excel file from the bank
If you or your client can log in to online banking, skip the PDF entirely. Most banks let you export account activity as a CSV or spreadsheet file, which opens directly in Excel.
Example: Chase
Log in at chase.com and open the account.
Go to the account's transactions and click Download account activity.
Set the file type to Spreadsheet (Excel, CSV).
Choose the date range and click Download.
Chase also offers QuickBooks (QBO) and Quicken (QFX) formats in the same menu. Other major banks have a similar "Download" or "Export" option on the transactions page.
When this method doesn't work
- You don't have the client's login, which is common for bookkeepers.
- The period is too old. Banks limit how far back activity downloads go, while PDF statements often stay available for years. Check your bank's limit.
- The account is closed or the bank only provides PDF statements.
- You only have scans or photos of paper statements.
If any of these apply, use Method 2 or 3.
Method 2: Use Excel's "Get Data From PDF"
Excel can read tables out of a PDF using Power Query. It's free if you already have Excel, but it has requirements.
What you need
- Excel for Microsoft 365 on Windows. The PDF option isn't available in Power Query on Excel for Mac.
- A digital PDF, meaning one downloaded from online banking, where you can select and copy the text. A scan or phone photo usually won't give you a usable table.
Steps
Open a blank workbook.
Go to Data > Get Data > From File > From PDF.
Select the bank statement PDF and click Import.
In the Navigator window, click through the tables and pages until you find the transactions table.
Click Transform Data to clean it up, or Load if it already looks right.
In the Power Query Editor, fix common problems: use Use First Row as Headers, remove summary rows, and set the date and amount columns to the right data types.
Click Home > Close & Load.
Tips
- Excel tries to combine tables that continue across pages, but check that no rows were dropped at page breaks.
- Descriptions that wrap onto two lines may be split into separate rows. You'll need to merge them.
- The query is tied to that file, so each new statement, especially from a different bank, often needs its own cleanup.
Best for: a few digital statements from the same bank, if you're comfortable with Power Query.
Method 3: Use an AI bank statement converter
When you can't download from the bank and Excel can't read the file, an AI converter is the practical option. Instead of relying on the PDF's internal structure, it reads the statement the way a person would, so it handles scans, photos and unfamiliar layouts.
Here's how it works in Parsinto:
Create a Box for your statements, for example "Client A, bank statements."
Upload the PDFs or images. You can upload several statements at once, including scanned pages.
Confirm the fields. Parsinto reads your first document and suggests the fields to extract, such as date, description, withdrawal, deposit and balance. Adjust them if needed.
Run the extraction. Every statement in the Box uses the same fields, even if the layouts differ.
Export to Excel, CSV or JSON.
Best for: scanned or photographed statements, catch-up work covering many months, and clients who bank with several different banks.
Pricing is per page (1 page = 1 credit), with plans starting at $10 a month. Try it on your own bank statement.
Which method should you use?
Bank download
- Cost: Free
- Needs bank login: Yes
- Scanned or photographed statements: No
- Works on Mac: Yes
- Different banks and layouts: Each bank separately
- Many statements at once: One account at a time
- Cleanup needed: Little
Excel Get Data From PDF
- Cost: Free with Microsoft 365
- Needs bank login: No
- Scanned or photographed statements: Usually no
- Works on Mac: No
- Different banks and layouts: Often needs cleanup per layout
- Many statements at once: One file at a time
- Cleanup needed: Often some
AI converter (Parsinto)
- Cost: From $10/month
- Needs bank login: No
- Scanned or photographed statements: Yes
- Works on Mac: Yes (in the browser)
- Different banks and layouts: Same fields for every layout
- Many statements at once: Batch upload
- Cleanup needed: Review only
Rule of thumb: download from the bank when you can. Use Excel for an occasional digital PDF. Use an AI converter for scans, catch-up work and anything over a handful of statements.
How to check the converted statement is accurate
Whichever method you use, check the result before you import it anywhere. It takes 30 seconds:
Opening balance + Deposits - Withdrawals = Closing balance
In Excel, sum the deposit and withdrawal columns, then compare the result with the closing balance printed on the statement. If they don't match, look for these common causes:
- A row missing at a page break. Transactions that continue onto the next page are the most common thing to go missing.
- A wrong sign. A withdrawal read as a deposit, or a minus sign that disappeared.
- A "balance forward" line counted as a transaction.
- A misread digit on a faded scan, such as a 3 read as an 8.
Also compare the number of transactions with the count printed on the statement, if the bank shows one.
