Most budgeting apps (YNAB, Actual Budget, Tiller, Firefly III, Monarch, spreadsheets) can import a CSV, but card issuers usually only let you download the last few months as CSV. Anything older is a PDF statement. Here's a workflow for backfilling a year or more of credit card history without retyping it.

1. Get every statement PDF in one folder

Download all the monthly statements and rename them consistently, e.g. 2025-01_visa.pdf. Sorting by name then gives you chronological order, which makes gaps obvious.

2. Convert each PDF to CSV

For digital PDFs, a table extractor like pdfplumber gets you most of the way:

import pdfplumber, csv, glob rows = [] for path in sorted(glob.glob("*.pdf")): with pdfplumber.open(path) as pdf: for page in pdf.pages: for table in page.extract_tables(): rows.extend(table) with open("all_transactions.csv", "w", newline="") as f: csv.writer(f).writerows(rows) 

Card statements have their own quirks:

  • Dates without years. "Dec 28" on a statement closing Jan 5 belongs to the previous year. Infer the year from the statement period, not from today.
  • Payments vs. purchases. Some issuers show payments as negatives, others in a separate section. Decide on one sign convention (purchases negative is what most budget apps expect).
  • Foreign transactions often span two lines (original currency + converted amount). Keep the converted amount.
  • Interest and fees sometimes sit in a summary box rather than the transaction table. Don't miss them.

3. Normalize to your app's import format

Most apps want something like:

Date,Payee,Amount 2025-01-03,GROCERY STORE 123,-54.20 2025-01-05,PAYMENT THANK YOU,500.00 

Use ISO dates (YYYY-MM-DD) to avoid day/month confusion on import.

4. Reconcile before importing

For each statement: previous balance + purchases + fees + interest - payments = new balance. If it doesn't add up, a row is missing or a sign is wrong. Fix that before it pollutes your budget.

5. Import oldest first and watch for duplicates

Import month by month, oldest first. Where your app's own bank sync overlaps the backfill, delete the duplicates at the boundary.

Disclosure: I'm part of the team behind Card Statement CSV, which converts PDF credit card statements from any issuer (digital or scanned) into CSV. There's a free preview before you pay, no sign-up to start, files are deleted within 24 hours, and it's priced per conversion from $1. The manual route above works fine too if you have the time.

How far back have you tried to backfill your budget? I'd like to hear what issuers made it hardest.