Convert CSV to OFX

OFX (Open Financial Exchange) is the standard bank-statement format most accounting software accepts, Xero, GnuCash, MoneyMoney, Banktivity and many others. If your bank only exports CSV, QBO Maker turns it into a clean .OFX file locally, without uploading anything.

Open the converter

Then choose .OFX, generic as the output format.

Convert my CSV

How to convert CSV to OFX

  1. Download your bank transactions as CSV or Excel.
  2. Drop the file into the QBO Maker converter.
  3. Map the date, amount and description columns (auto-detected for you).
  4. Choose .OFX output and download.
  5. Import the .OFX in your accounting app's bank-import screen.
Which format do I need? Use .QBO for QuickBooks, .QFX for Quicken, and .OFX for everything else. The transactions are identical, only the wrapper differs.

Handles messy bank exports

Signed amounts or split debit/credit columns, dollar signs, parentheses for negatives, European number formats, and US/UK/ISO dates are all parsed correctly. Duplicate rows are removed and each transaction gets a unique ID.

Related