How to turn bank statement PDFs into CSV for budgeting

Budgeting starts with knowing where your money went. Your bank statement has the answer, but it’s locked inside a PDF. Copying transactions out by hand is slow, and pasting them into a spreadsheet usually scrambles the columns.

This guide shows how to turn statement PDFs into clean CSV files you can sort, filter and total, and how to check that nothing was missed.

First: check if your bank already offers CSV

Before converting anything, log in to your online banking and look for an export or download option on the transactions page. Many banks let you download recent transactions as CSV, Excel, or formats like OFX or QIF that budgeting apps understand. If yours does, that’s usually the most accurate route.

Converting PDFs is the answer when:

• your bank only provides PDF statements,
• you need older months that the export no longer covers,
• you’re working with statements someone else sent you, such as for a shared household budget.

How to convert a statement PDF to CSV

Open the bank statement to CSV converter. It runs in your browser, so your statements stay on your device. That matters here: statements contain your account number, address and spending history.

1. Add your statement PDF. You can add several months at once.
2. Choose your settings (see below).
3. Click Convert.
4. Download each CSV, or all of them as one ZIP.

Each file is named after the statement with “-transactions” added, so you can tell the months apart.

The settings

Amounts controls how money in and out is shown:

• Debit and Credit columns (default): money out goes in Debit, money in goes in Credit. Easy to read and to total separately.
• One signed Amount column: money out is negative, money in is positive. Many budgeting apps prefer this when importing.

Dates controls how dates are written:

• As in the statement (default) keeps them exactly as printed.
• YYYY-MM-DD rewrites them in one unambiguous format, which sorts correctly in any spreadsheet. The converter works out whether your bank writes day/month or month/day by looking at all the dates in the statement, and tries to fill in the year from the top of the statement when the rows don’t show it. If it can’t work out a full date, it keeps the date as printed.

What you get

The CSV has one row per transaction, with these columns:

• Date
• Description
• Debit and Credit (or a single Amount)
• Balance, when the statement shows a running balance

How the converter reads a statement

Bank statements come in all sorts of layouts, so it helps to know what the converter looks for:

• Each transaction starts with a date. Rows beginning with a date become transactions. If your bank prints the date only once for several transactions on the same day, the following rows reuse it.
• Wrapped descriptions are joined. When a description runs onto a second line, the lines are merged into one cell.
• Amounts are read from the right of the row. If the statement has Debit, Credit or Balance headings, amounts go into the matching columns. If not, the converter uses the running balance to tell money in from money out.
• Amounts need two decimals. This keeps reference numbers from being mistaken for money.
• Summary lines are skipped. Opening and closing balances, “brought forward” lines, totals and page headers aren’t treated as transactions.

Password-protected statements

Some banks send statement PDFs that need a password to open. The converter can’t read a locked file. Use Unlock PDF with your password to save an unlocked copy, convert that copy, and then delete it once you’re done.

When it doesn’t work

“No transactions found”

Some statements are laid out in ways the converter doesn’t recognize, for example with the date at the end of the row. Try the PDF to Excel converter instead. It extracts the whole table as it appears on the page, and you can tidy the columns in your spreadsheet.

Scanned statements

If your statement is a scan or a photo of paper, there’s no text inside the PDF to read, and the converter can’t extract anything. Treeet doesn’t do OCR (text recognition from images). Download the original PDF from online banking instead, or ask your bank for an electronic copy.

Check the numbers before you rely on them

Any automatic conversion can miss or misread a row, so take two minutes to verify:

1. Count the rows. Compare the number of transactions with the statement, roughly.
2. Check the totals. Many statements print total debits and total credits. Add up your Debit and Credit columns and compare.
3. Check the balance. Opening balance + total credits − total debits should equal the closing balance.
4. Look at a few long descriptions. Make sure wrapped lines landed in the right transaction.

If the totals match, you can trust the data.

Turning the CSV into a budget

In a spreadsheet

Open the CSV in Excel, Google Sheets, LibreOffice or Numbers. If you’d like a proper Excel file, the CSV to Excel converter makes one. Then:

1. Add a Category column (Groceries, Rent, Transport, Eating out and so on) and fill it in. Sorting by Description first makes this much quicker, since the same shops appear again and again.
2. Total by category with a pivot table, or with SUMIF formulas.
3. Combine months by pasting each month’s rows into one sheet. Add a Month column if you want to compare months side by side.

In a budgeting app

Most budgeting apps that accept CSV imports ask you to match columns: which one is the date, the description and the amount. If the app expects one amount column, choose One signed Amount column when converting. If it’s fussy about dates, choose YYYY-MM-DD.

Keep your data private

Bank statements are among the most sensitive files you have. Converting in the browser means the statement isn’t uploaded to Treeet. After you’re done:

• delete unlocked copies of password-protected statements,
• keep your CSVs out of shared or public folders,
• remove old exports you no longer need.

For converting other kinds of PDF tables, see our guide on converting a PDF table to Excel.