Your client has sent you twelve months of bank statements, all as PDFs. You need them in Excel. Retyping them line by line is slow, and it's how transposed numbers sneak into the books.
This guide covers three ways to get a bank statement from PDF into Excel. It ends with a two-minute check that tells you whether every transaction made it across.
Before you start: check whether the bank offers a CSV
If you have online access to the account, look for "Export", "Download transactions" or "CSV" in the bank's website. A download straight from the bank is the cleanest source. Use it when you can.
You need a PDF converter when you don't have that option, which happens a lot in practice:
- the client only sends PDFs
- the account is closed, or the bank only keeps a few months of history online
- you're catching up on a year of books and the statements are all you have
- the statements are scans or photos
Method 1: Copy and paste (fine for one short statement)
- Open the PDF and select the transaction table.
- Copy it and paste it into Excel.
- If everything lands in one column, use Data → Text to Columns to split it.
Where it breaks: dates and amounts often end up in the wrong columns. Long descriptions wrap onto a second line and become a separate row. Page headers get pasted into the middle of your data. Scanned statements can't be copied at all. For one page it's manageable. For a stack of statements, it isn't.
Method 2: Excel's built-in PDF import
Excel for Microsoft 365 on Windows can read tables out of a PDF:
- Go to Data → Get Data → From File → From PDF.
- Choose the statement. Excel shows the tables and pages it found.
- Pick the transaction table (or each page's table), then click Transform Data to clean it in Power Query, or Load to drop it straight into a sheet.
Where it breaks: each page usually comes through as a separate table, so a six-page statement means combining six tables. Debit and credit columns, running balances and multi-line descriptions often need manual clean-up. It doesn't read scanned PDFs, and it isn't available in every version of Excel.
Method 3: A bank statement converter
A converter built for statements does the extraction and the clean-up in one step. Here's how it works in PDFDrill:
- Upload the statements. You can add a whole batch for one client, digital or scanned.
- PDFDrill extracts every transaction into one table: date, description, money in, money out, running balance.
- It checks each statement balances. The opening balance plus the transactions must equal the closing balance, to the cent. You see PASS or FAIL with the exact difference.
- Review anything flagged, fix it, and the checks re-run.
- Download an Excel workbook. It has the ledger, a statement summary and a reconciliation sheet.
The free plan includes 10 pages a month, which is enough to try it on a real statement.
The two-minute check: did every transaction make it?
Whichever method you use, run this check before you rely on the data. It catches missed rows, doubled rows and misread amounts.
Put money in as positive numbers and money out as negative numbers in one Amount column. Then:
| Cell | What goes in it |
|---|---|
| F1 | The opening balance printed on the statement |
| F2 | The closing balance printed on the statement |
| F3 | =F1+SUM(C:C) (if your amounts are in column C) |
| F4 | =F3-F2 |
If F4 is 0.00, the statement balances. If it isn't, the difference tells you what to look for. For example, a difference of exactly one transaction's amount usually means that row was missed or counted twice.
PDFDrill runs this check for you on every statement. It also checks that one month's closing balance matches the next month's opening balance, which catches a missing statement.
Common problems and how to fix them
Dates come out wrong (03/04 becomes 4 March, not 3 April). The statement uses day/month order and Excel assumed month/day, or the other way round. Check a date where the day is above 12 to see which order you have, then set the column's format to match the statement.
Money out shows as "CR"/"DR" or in brackets. Some banks print (45.00) or 45.00 DR instead of -45.00. Convert them to negative numbers before you total anything.
Descriptions split across two rows. Merge the second line back into the row above. A row with a description but no date or amount is almost always a continuation.
Page totals and "balance brought forward" rows. Delete them. They aren't transactions and they'll throw off the balance check.
Overlapping statements. If two statements cover some of the same days, the same transactions appear twice. Sort by date and look for identical date-and-amount pairs at the joins. PDFDrill marks these as duplicates instead of deleting them, so you can see what happened.
FAQ
Can I convert a scanned bank statement to Excel? Yes, with a converter that has OCR (text recognition). Copy-paste and Excel's PDF import won't work on scans. Scans are where the balance check matters most, because a misread digit shows up as a difference.
Can I convert several statements into one spreadsheet? Yes. Upload them as one batch and PDFDrill produces one ledger per account, in date order, with overlaps flagged.
Is it safe to upload bank statements? It's a fair question to ask of any tool. With PDFDrill, uploaded statements are stored privately. Source PDFs are deleted 7 days after the batch is created and extracted data after 30 days, and you can delete a batch at any time. Details are on the security page.
I need CSV for Xero or QuickBooks, not Excel. See How to convert a bank statement PDF to CSV and How to import a bank statement into Xero.
Stop retyping statements. Upload a statement to PDFDrill and get a balance-checked Excel ledger. It's free for your first 10 pages each month.