Bank statement to CSV

Convert a bank statement PDF to CSV

Your bank only gives you a PDF, and QuickBooks, Xero or your spreadsheet wants a CSV. Drop the statement here and download one row per transaction, with money in and money out in separate columns.

Goes in

A bank or credit-card statement PDF, digital or scanned, up to 20 MB

Comes out

statement.csv: a header row, then one row per transaction in 7 columns

date,description,credit,debit,balance,reference,classification
2026-10-02,Acme Payroll,3200,,5450,PPD 1002,ACME PAYROLL
2026-10-03,Amazon,,64.99,5385.01,,AMAZON

What the CSV looks like

This is the exact output of our CSV exporter for a four-line sample statement. Credit and debit are positive numbers in separate columns; the classification column is the payee, cleaned up.

date,description,credit,debit,balance,reference,classification
2026-10-02,Acme Payroll,3200,,5450,PPD 1002,ACME PAYROLL
2026-10-03,Amazon,,64.99,5385.01,,AMAZON
2026-10-05,City Electric Co,,118.4,5266.61,ACH 88213,CITY ELECTRIC CO
2026-10-07,Rent - Oak Street,,500,4766.61,CHK 1043,OAK STREET RENTALS

Sample data from a made-up statement, not a real account.

Who this is for

  • Bookkeepers importing a client's bank activity into QuickBooks Online or Xero when there is no bank feed.
  • Anyone who wants statement rows in Google Sheets, Numbers or a database that loads CSV.

How it works

  1. Step 1

    Upload the PDF

    Digital statements are read as text; scanned pages go through OCR.

  2. Step 2

    Check the preview

    The first rows appear on the page as CSV, Excel and JSON before you download anything.

  3. Step 3

    Download statement.csv

    UTF-8, comma-separated, one header row, dates as YYYY-MM-DD.

Importing the CSV into QuickBooks or Xero

Neither tool needs a special template from us; both let you match columns at import. Check their preview before you confirm.

QuickBooks Online

Its bank file upload accepts a Date, Description, Credit, Debit layout, and those are our first four columns in that order. Pick the two-column amount option when mapping, remove the last three columns if it complains, and confirm in the preview that money in and money out landed on the right side.

Xero

Xero's bank statement import asks you to assign each column of your file to a field. Assign date, description, reference and the amount columns. If your import screen offers only one amount field, add a column in a spreadsheet with credit minus debit and assign that.

Spreadsheets and databases

The header row is lowercase and fixed: date, description, credit, debit, balance, reference, classification. Scripts can rely on the order.

Accuracy and limits

  • A balance that starts with a minus sign is written as '-120.00 (leading apostrophe). That stops spreadsheet formula injection from text inside a PDF; strip it if your import reads the balance as text. Credit and debit amounts are always positive, so they are never affected.
  • Dates are written as YYYY-MM-DD. If your import tool wants DD/MM/YYYY, pick the format in its mapping step or reformat the column.
  • This page converts bank and card statements to rows; it does not match them to invoices or bills. To check a supplier's statement against your books, use supplier statement reconciliation (linked below).
  • PDF only, up to 20 MB per file. Photos and screenshots (JPG, PNG) are not accepted; save them as a PDF first. If the PDF is password-protected, save an unlocked copy.
  • Without an account you can convert one PDF of up to 3 pages a day. A free account converts up to 5 pages a day; Pro 400 at $15 / month (up to 400 pages per month) or Scale 1000 at $30 / month (up to 1000 pages per month).
  • On our ground-truth benchmark the current engine scores 93% transaction F1 and 99% date accuracy. That benchmark is three hand-checked statements (Canara, HSBC, ICICI), so treat it as a sign, not a guarantee for your bank. Check the preview before you download.
  • The running balance of every row is recomputed from the one before it. A row that does not add up is flagged in the JSON (balance_check), not silently fixed.

Questions

What columns does the CSV have?

Seven, in this order: date, description, credit, debit, balance, reference, classification. Credit is money in, debit is money out, both positive. Classification is the payee or merchant in capitals.

Can I import the CSV into QuickBooks Online?

Yes, through QuickBooks' bank file upload. It accepts Date, Description, Credit, Debit, which are our first four columns. Choose the two-column amount option, drop the extra columns if asked, and check its preview before accepting.

Can I import it into Xero?

Yes, through Xero's bank statement import, where you assign each column to a Xero field. If your screen only takes a single amount column, make one as credit minus debit first.

Does it reconcile supplier or vendor statements?

Not on this page, which converts bank and credit-card statements. Supplier statements have their own tool at /supplier-statement-reconciliation: upload the supplier's PDF and your ledger exported from Xero, QuickBooks or a spreadsheet, and it lists what matches, what is missing on each side and why the balances differ.

Does it work on scanned statements?

Yes. Pages without a text layer go through OCR before the rows are extracted. Check the preview, since scans are where mistakes are most likely.

Is it free?

One PDF of up to 3 pages a day needs no account. A free account converts up to 5 pages a day; paid plans are Pro 400 at $15 / month (up to 400 pages per month) or Scale 1000 at $30 / month (up to 1000 pages per month).

Related