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. 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.

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.

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