Turn a bank statement PDF into Excel rows

Twelve statements and a tax deadline

Tomas freelances as a photographer and pays his quarterly tax estimate from a business current account. Every April his accountant asks for the same thing: one spreadsheet with the full year of transactions, dated, described, with money in and money out in separate columns. His bank only exports PDF, so Tomas has twelve files named like statement_2025_07.pdf, each four to six pages long, each with dates, descriptions, debits, credits, and a running balance.

Retyping a year of transactions would take a weekend and still leave errors. Converting works because his bank builds these PDFs from real text: every amount sits in an aligned column, and every transaction occupies one row. Tomas converts each statement, stacks the twelve sheets into one table in Excel, and reconciles the year. The whole job takes one evening, and the reconciliation proves the numbers.

Your statements may differ from his. Some banks wrap long descriptions over two lines, some print debits and credits in a single column with minus signs, and older statements may be scanned images with no text at all. Try selecting one transaction with your mouse: if the words highlight, conversion can work. If the page behaves like a picture, nothing below will help until the file has a text layer.

Convert the statements without uploading them

1. If your statements carry an open password, remove it first with Unlock PDF. Converters cannot read a locked file.
2. Open PDF to Excel and choose one statement. Bank data never leaves the browser tab, which matters more here than for a price list.
3. Review the detected tables. A statement usually yields one table per page plus stray detections from the header block, the fee summary, or the marketing box. Deselect everything except the transaction tables.
4. Press Convert to Excel. Each selected table becomes its own visible worksheet in one XLSX file, with every value stored as plain text and no formulas, macros, or hidden sheets.
5. Check the receipt view: the source PDF page beside the first worksheet, with an outline marking the text used for that sheet. Confirm the columns line up with date, description, and amounts before downloading.
6. Repeat for the remaining statements, then stack the sheets into one table in Excel: copy every transaction block under the first, keep the column order identical, and add a month column so each row stays traceable.

If your bank numbers its pages oddly or splits one month across two downloads, merge the pages into one file per month before converting. Converting per month keeps every workbook small enough to check in one sitting.

Reconcile before you trust the sheet

Money punishes silent errors, so treat the workbook as a draft until it proves itself. Work through this checklist for every statement, in order. Each item takes a minute and catches a different failure.

• Count the rows: the number of transaction rows in Excel must match the number of transactions on the PDF pages.
• Recompute the closing balance: opening balance plus credits minus debits must equal the printed closing balance to the cent.
• Scan the running balance column, if your bank prints one: it should change exactly once per row and never jump.
• Check negatives: debits shown in parentheses or with a trailing minus must land in the money out column as negative values.
• Look for wrapped descriptions: a two line shop name may have pushed an amount onto its own row, which breaks the running balance at that point.
• Confirm the month boundaries: the first and last transaction dates must fall inside the statement period, with no January row hiding in the February sheet.
• Spot check five amounts against the PDF, including the largest debit and the largest credit.

Money mistakes and how to fix them

• One amount split across two rows. Wrapped descriptions are the usual cause. Join the description cells, move the amount back onto the transaction row, and delete the leftover empty row.
• Debits and credits share one column. Some banks print a single amount column with minus signs. After converting, sort by that column, move the negatives into a money out column, and keep positives as money in.
• The closing balance is off by a small amount. A missing row is more likely than a wrong digit. Compare row counts per page between the PDF and the sheet to find where a transaction vanished, often a fee line printed in a smaller font.
• Dates land as text like 07JAN25. Bank shorthand does not sort. Add a helper column that turns the shorthand into real dates, then sort and filter on the helper.
• Thousands separators break the values. A PDF prints 12,400.00 exactly as shown, and the wrong locale turns it into 12.4. Set the column locale to match the statement before converting text to numbers.
• Stray header tables pollute the workbook. Account numbers, branch addresses, and fee summaries can align into small false tables. Delete those sheets and keep only transaction data, and deselect them next time.

When conversion is the wrong move

Some statements resist conversion honestly. A scanned statement from the 1990s, a phone photo of a printed page, or a bank that lays out transactions as artwork with scattered labels will produce garbage, and retyping thirty transactions beats repairing three hundred broken rows. Check whether your bank offers a CSV or Excel export inside online banking first: banks that export PDF almost always offer CSV too, and that file skips detection entirely.

When the goal is a database import or a bookkeeping script rather than a workbook, PDF to CSV runs the same detection but saves plain CSV files. When only the totals matter for a loan application, converting is overkill: quote the figures from the PDF and send the original file. And when the statements hold someone else's account, convert only with their permission and delete the workbook when the job is done. The general PDF to Excel guide covers catalogs, reports, and other non money tables.