Bookkeeping season has a familiar shape: twelve monthly statements, each a PDF, each with a few hundred rows, and a spreadsheet that needs all of them. Retyping is not the answer, and neither is a screenshot.
Get the rows out
Upload the statement to PDF to Excel and download an .xlsx with the tables rebuilt as real rows and columns — sortable, filterable, and ready to total. It works best on documents that contain actual tabular data, which is exactly what statements, invoices, payslips, and price lists are.
Bank statements convert particularly well because they’re rigidly structured: date, description, debit, credit, balance, repeated down the page.
Cleaning up before you rely on the numbers
A converted statement is a starting point, not a finished ledger. Five minutes of checking saves a reconciliation nightmare:
1. Check the columns lined up. Descriptions containing numbers (“Payment 4471”) occasionally land in an amount column. Sort by amount and anything nonsensical jumps out.
2. Fix the date column. Dates often arrive as text rather than real dates, especially in formats like 03/04/2026. Select the column and use Data → Text to Columns → Date, telling Excel which of day and month comes first. Getting this wrong silently reorders your whole year.
3. Watch for negative-number conventions. Statements write debits as (45.00), 45.00 DR, or -45.00. Convert them all to one signed convention before summing anything.
4. Reconcile against the closing balance. The fastest possible check: total the credits, subtract the debits, add the opening balance, and see whether you land on the printed closing balance. If you do, the extraction is sound. If you don’t, something didn’t come across.
5. Delete the furniture. Page headers, footers, and the bank’s marketing text repeat on every page and become stray rows. Sort or filter them out in one pass.
Multiple statements at once
For a whole year, merge the PDFs into one file first and convert once — you get a single sheet to clean instead of twelve. Add a “source month” column before you combine everything so you can always trace a row back.
If your statement is a scan
Older statements and anything you photographed are images, not text, so there’s nothing to extract. Run it through OCR PDF first to add a real text layer, then convert. Check the amounts carefully afterwards — recognition can confuse 8 and B, or 0 and O, and in a financial document that matters.
If it’s password-protected
Banks routinely email statements locked with your date of birth or account number. An encrypted PDF can’t be read by any converter — remove the password with Unlock PDF first (you need to know it), then convert.
Going the other way
Once your spreadsheet is finished and you need to send it to an accountant or a client, Excel to PDF turns it back into a fixed document where nobody can alter a figure.
Ready? Try the free PDF to Excel converter now — no sign-up, no watermark, and your file is never stored.