Convert a PDF Bank Statement to CSV

PDF to CSV in four steps

1. 1

   Download the statement PDF

   Save the statement from your bank's online banking or app. Text-based PDFs give the fastest result; scanned or photographed statements work too.

2. 2

   Upload it here

   Drop the PDF into the upload box below. No account is needed for the demo, and the file is deleted automatically within 14 days at the latest.

3. 3

   Check the result

   Every row is checked against the running balance printed on the statement, and opening balance plus transactions is compared with the closing balance. Rows that don't add up are flagged.

4. 4

   Download CSV

   Pick CSV (or Excel / JSON) and import the file into the tool you use — spreadsheet, accounting software or your own script.

Try it now — convert your statement to CSV

What the CSV file looks like

The file starts with a single header row followed by one row per transaction. There are no page headers, footers, summary boxes or blank lines in between — the kind of clutter that breaks imports when you copy text out of a PDF by hand. The exact columns depend on what your statement prints; a typical file looks like this:

• Amounts are signed: money in is positive, money out is negative — one column instead of separate debit and credit columns.
• Numbers are plain values with a dot as the decimal separator and no currency symbol or thousands separator.
• Fields are comma-separated and quoted, so descriptions that contain commas stay in one column.
• The file is UTF-8 with a byte-order mark, so Excel shows accented and non-Latin characters correctly.

Importing the CSV into accounting software

Most accounting and bookkeeping tools — QuickBooks Online, Xero, Zoho Books, Sage, Wave, FreshBooks and many regional products — have a bank statement or bank transaction import that accepts CSV. The flow is nearly always the same:

1. Open the bank account in your accounting tool and choose the option to import or upload a statement file.
2. Select the CSV and tell the importer that the first row is a header.
3. Map the columns: date → Date, description → Description/Payee, amount → Amount. If the tool wants separate money-in and money-out columns, see the formula below.
4. Choose the date format that matches the file, preview the rows and confirm.
5. Only import date ranges that are not already in the ledger (for example via a live bank feed), otherwise you will create duplicates.

If your software insists on separate debit and credit columns, add two columns in Excel before saving: Credit =IF(E2>0,E2,"") and Debit =IF(E2<0,-E2,"") (assuming the amount is in column E). Our QuickBooks and Tally guides walk through those two tools step by step.

Delimiter, date and number format notes

• Everything in column A? In regions that use a comma as the decimal separator (much of Europe, Turkey, Latin America), Excel may expect semicolons when you double-click a CSV. Open it with Data → From Text/CSV instead and choose comma as the delimiter — or download the .xlsx version, which needs no delimiter at all.
• Dates are written year-first (YYYY-MM-DD), which is unambiguous. If your importer only accepts MM/DD/YYYY or DD/MM/YYYY, pick the matching option in the import screen, or reformat the date column in Excel and save as CSV again.
• Re-saving in Excel can change things: it may rewrite dates in your local format and drop leading zeros from reference numbers. Import the original file when possible.
• Amounts never carry currency symbols, so a multi-currency statement keeps its amounts as printed — note the account currency when you import.

CSV, Excel or JSON — which should you pick?

• CSV — the universal import format for accounting software, databases and scripts.
• Excel (.xlsx) — best when a person will review, filter or build pivot tables; no delimiter or encoding issues.
• JSON — for developers; the same structured data is available directly from the REST API for automated pipelines.

Frequently asked questions

Related tools and guides