Bank statement to CSV

Bank statement PDF to CSV, ready for import

Download a plain CSV (Date, Description, Amount, Debit, Credit, Balance) or a Xero-ready CSV (Date, Amount, Payee, Description, Reference). Both come from a statement that has passed the balance check.

Balance proofReconciled
Opening + 75 rows
5,152.81
Statement closing
5,152.81 ✓
QBOQFXOFXExcelCSVXero CSV
Illustration with sample numbers. Your statement is checked the same way before any download.

How it works

  1. 01

    Upload the PDF statement

  2. 02

    Check the balance proof

  3. 03

    Download CSV or Xero CSV

Checked before you download

Opening balance plus every transaction must equal the closing balance, and every printed running balance must follow from the row above. If anything is off, you see the exact rows, not a silently wrong file.

Xero users in the UK

Xero imports PDF statements only for organisations in the US and Canada. Everywhere else, convert the PDF here and import the Xero CSV or the OFX file instead.

Built for bookkeepers

Keep each client’s statements apart in one workspace, with unlimited clients and seats on every paid plan.

Deleted after 24 hours

Uploads and everything read from them are deleted automatically 24 hours after upload (or after 7 or 30 days if your workspace chooses), or right away when you click delete. Your statements are never used to train AI models.

Which CSV goes where

Different tools want different columns. StatementLoom gives you two CSV shapes from the same checked statement; the bank CSV cleaner reshapes a CSV you already have.

CSV layouts and where they import
DestinationColumnsFrom StatementLoom
SpreadsheetsDate, Description, Amount, Debit, Credit, BalanceCSV
Xero statement importDate and Amount required; Payee, Description, Reference optionalXero CSV
QuickBooks Online, 3 columnsDate, Description, AmountCSV (delete the extra columns) or the bank CSV cleaner
QuickBooks Online, 4 columnsDate, Description, Credit, DebitBank CSV cleaner

What the importers expect

  • Xero: income and expenses in one Amount column, income positive and expenses negative, and no commas as decimal separators. Only Date and Amount are required, and a CSV can have at most 100,000 rows (Xero Central). Xero recommends an OFX file over CSV where your bank offers one, and StatementLoom exports OFX too.
  • QuickBooks Online: a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit), one date format throughout, and zeros left blank (Intuit).
  • Quicken for Windows: CSV imports need month-first dates and, unlike Web Connect files, do not check for transactions already in the register, so importing the same file twice creates duplicates (Quicken).

Pricing

Pay for pages that reconcile

Every plan includes every format, unlimited clients and unlimited seats. Pages that do not reconcile are not charged. Cancel any time.

Starter

For a solo bookkeeper.

$30 / month

Or $288 billed yearly.

+ VAT where applicable. Calculated at checkout.

  • Unlimited Clients
  • 400 Pages / month
  • QBO, QFX, OFX, Excel, CSV, Xero CSV
  • Balance check on every statement
  • Unlimited clients and seats
  • Deleted after 24 hours
Start 7-day trial

Just one statement? The free converter handles up to 10 pages a day.

Questions

Which date format does the CSV use?
US-dollar statements use MM/DD/YYYY; every other currency uses DD/MM/YYYY. Xero asks you to confirm the format when a date could be read either way.
Is the CSV download free?
Yes. The free converter reads up to 10 pages a day without an account and downloads CSV, Xero CSV or Excel.

Other conversions

QuickBooks, Quicken and Xero are trademarks of their respective owners. StatementLoom is not affiliated with or endorsed by them; their names describe file compatibility only.