How do I get older bank transactions into Excel when my bank only gives me PDFs?

Check your bank's export screen first: some banks only offer CSV or Excel for a recent period, while older months exist only as statement PDFs. Download those PDFs, convert each one with the free Bills AI converter (no signup, text-based PDFs only), then paste the CSVs into one sheet and compare balances with the originals.

Last reviewed:

Steps

  1. Look for an export option in your online banking first. If it covers the months you need, use it, because it avoids extraction mistakes entirely.
  2. For the months it does not cover, download each statement as a PDF from the statements section. Use the bank's own file, not a scan or photo, so the text can be selected.
  3. Drop one PDF at a time on the free converter and download the CSV. Read the warnings it shows about lines it left out.
  4. Paste the CSVs into one sheet in date order. Turn off "Include header row" for every file after the first so the headings appear once.
  5. Check that each month's closing balance equals the next month's opening balance, and compare a few rows with the original PDFs.

When this will not work

  • Scanned statements and photos have no text layer, and the free converter has no OCR, so it reports that it found no table.
  • Banks change statement layouts over the years. Column headings that differ between old and new statements can put values in different columns, so look at each file before you merge.
  • The converter copies dates and amounts as printed and leaves out opening, closing and total rows, so the balance check is yours to do.
  • The limit is 10 conversions a minute and 40 a day per visitor, with files up to 10 MB.

Related

Frequently asked questions

Can I upload several statements at once?

No. The free converter takes one PDF at a time. Convert each statement and paste the results into one sheet.

Why would my bank only offer PDFs for older months?

Banks decide how far back an online export goes, and that period differs between banks. Check your own bank's export screen to see how far back it reaches.

Does the converter keep my statements?

The PDF is read in memory on the server and the CSV is returned to you. The free converter does not save the file or the result to a database, and it uses no AI.

More answers