BooksReady

CSV to OFX converter

OFX (Open Financial Exchange) is the standard bank statement file. Xero, GnuCash, Moneydance and many other programs import it without asking you to map columns. The converter below builds one from a payment app or bank CSV, on your device.

Convert a CSV to OFX

To OFX

A CSV export from Venmo, Cash App, PayPal, Stripe, Square, Shopify, Wise, Etsy, Airbnb, Gumroad or your bank, or an MT940 or camt.053 bank statement (or a camt.052 report or camt.054 notification). The source is detected automatically.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The data in the sample is invented. It is converted on this device, the same way your own file would be.

One email when it ships. The address is used for nothing else. Details.

Pick the app the file came from

From a bank CSV

Bank CSV exports differ from bank to bank: some use one signed amount, some separate debit and credit columns, dates may be day-first or month-first, and many add header or total rows. Choose "Bank CSV" as the source (it is picked automatically when the file is not from a known app).

  1. In your online banking, find Download or Export transactions.
  2. Choose CSV (sometimes called Excel CSV or Comma separated).
  3. Pick the date range and download.
  • We look for the header row even if the file starts with account details.
  • We map Date, Description and Amount, or separate Debit and Credit columns, automatically, and show the result in the preview.
  • We work out whether dates are month/day or day/month and whether "," or "." is the decimal point from the file itself; when the file cannot tell, we ask you instead of guessing. Dotted dates (31.01.2025) are read day first.
  • Card exports that show purchases as positive numbers can be flipped with the "invert sign" option.

What Xero, Wave, GnuCash, Moneydance, MS Money and others requires

  • Plain OFX 1.0.2 SGML with no Intuit extensions.
  • One account and one currency per file.
  • Stable transaction ids: the same row in two overlapping exports gets the same id.

How to import it

  1. In your accounting software open the bank account and choose Import statement (or File > Import > OFX).
  2. Choose this .ofx file.
  3. Review and confirm the transactions.

Questions

Which programs accept OFX files?
Xero, Wave, GnuCash, Moneydance and many desktop finance programs offer an OFX import. QuickBooks prefers .qbo and Quicken prefers .qfx; use those variants for Intuit products.
What happens with overlapping exports or repeated rows?
Each transaction gets an id built from its date, amount, description and platform id, so the same row in two overlapping exports gets the same id. Whether your software uses that id to skip a repeat is up to the software, so avoiding overlapping date ranges is still the safest habit. Within one file, exact repeats of the same platform transaction are dropped and the notes say how many.
Which exports can I convert to OFX?
Venmo statement, PayPal activity download, Stripe balance transactions, Wise balance statement CSV, MT940 bank statement and camt.053 bank statement (ISO 20022 XML), or any bank CSV with a header row, a date column and an amount column (or separate debit and credit columns). Each has its own page with the export steps.

Common Xero, Wave, GnuCash, Moneydance, MS Money and others import problems