Skip to content

Bank CSV to OFX Converter

Import bank transactions into accounting software that does not read your bank's CSV. Choose the export, check the date format, and download an OFX or QIF file ready to import.

Processed in your browser · never uploaded

  1. 1Add input
  2. 2Review
  3. 3Download
Columns (found from the header automatically)

Column numbers start at 1. Use either one amount column, or separate money out and money in columns.

How to use the Bank CSV to OFX Converter

  1. Choose a bank statement CSV, paste it, or try the example.
  2. Choose OFX or QIF, and the date format your bank uses. Columns are found from the header.
  3. Select Convert statement and import the downloaded file into your software.

Supported files and limits

  • Works with one signed amount column, or separate money in and money out columns. A balance column sets the closing balance.
  • Each transaction gets a stable ID, so importing the same file twice is recognised as a repeat by most software.
  • Statements listed newest first are written oldest first. Rows that cannot be read stop the conversion, so nothing is lost silently.
  • Up to 50,000 transactions. Amounts like 1,250.00 and 1.250,00 are both read correctly.

Common questions

OFX or QIF: which should I choose?
Choose OFX for QuickBooks, Xero, Sage, FreeAgent, GnuCash and most current software. QIF is for Quicken and older programs; its dates are written month/day/year.
Why does my software not accept my bank's CSV?
Every bank formats its CSV differently: column names, date formats and decimal separators. OFX is a standard format, so software can read it without guessing.
Will the transactions be imported twice if I convert again?
Each transaction gets an ID made from its date, amount and description, so most software recognises a repeated import and skips the duplicates.
Is my bank statement uploaded?
No. It is converted in your browser and never sent to our server or anyone else.

Related tools