Saved

Press the star next to a tool's name to save it.

All my tools

QBO to CSV Converter

Use this bank file converter to read OFX, QFX, QBO, QIF or IIF files and save the transactions as CSV, Excel, a PDF table, QIF or OFX, in your browser.

Choose a file or paste its text. The converter finds the format on its own, shows the first rows and lets you save the transactions as CSV, Excel, a PDF table, QIF or OFX. It runs in your browser.

Your bank data stays on your device. Nothing is uploaded.

Transactions

Choose an OFX, QFX, QBO, QIF or IIF file to see its transactions.

This bank file converter reads OFX, QFX, QBO, QIF and IIF files and saves the transactions as CSV, Excel, a PDF table, QIF or OFX. Choose a file or paste its text. The converter finds the format on its own, shows the first rows, and lets you download the result. It runs in your browser, so your bank data is never uploaded.

How to use the bank file converter

  1. Choose your file, or paste its text.
  2. Check the preview to see that the dates and amounts look right.
  3. Pick the format to convert to.
  4. Download the file, or copy the text.

OFX, QFX and QBO files

The Financial Data Exchange describes Open Financial Exchange as an open standard for exchanging financial data. OFX 1.0 started with an SGML-based syntax, and the 2.x versions are XML-based. Intuit says that with Web Connect, users download a .qfx file for Quicken or a .qbo file for QuickBooks and import it themselves. The converter reads both styles of OFX, with or without closing tags, and it reads QFX and QBO files in the same way, by looking for the transaction records. It does not need your bank login.

What is read from a transaction

The OFX 2.01 statement example shows what a transaction looks like. A statement holds a list of transactions between a start date and an end date. Each transaction has a type such as CHECK or ATM, a posted date, an amount and a unique ID, and may have a check number and a user date. The converter reads the type, the posted date, the amount, the ID, the name, the memo and the check number, and the account number from the statement. Dates are written as year, month and day, and the converter shows them as year-month-day.

QIF files

The Quicken Interchange Format is described as as an open specification for reading and writing financial data in files. The first line is a header such as !Type:Bank, and each record is a set of lines that begin with a one-letter code and end with a caret. D is the date, T the amount, P the payee, M the memo, N the number and L the category. The page notes that leading zeroes on the month and day can be skipped, and that the year can have four digits, two digits or an apostrophe and a digit. Because a date such as 3/4/10 could be March 4 or April 3, you can choose month/day/year or day/month/year.

IIF files

Intuit says that Intuit Interchange Format files are ASCII text, tab-separated files that QuickBooks Desktop uses to import or export lists or transactions. The header rows begin with an exclamation point and name the columns of the records that follow. The converter reads those headers and puts every record in a table, with the record type in the first column. It does not turn an IIF file into QIF or OFX, because the file holds accounting entries, not only bank transactions.

The formats you can save

CSV and Excel files hold the nine columns the converter reads: date, amount, type, name, memo, number, ID, category and account. The PDF is a table on landscape pages with the header repeated on each page. QIF is written with a !Type:Bank header and dates as month/day/year. OFX is written as XML in the layout of the OFX 2.01 example, with the currency and account number you enter. Check any file in your accounting program before you rely on it, since programs differ in what they accept.

Why there is no QFX or QBO output

QFX files are made for Intuit's products. Because this converter cannot know which financial institution Intuit would accept for your file, it does not write QFX or QBO files. If your program accepts OFX or QIF files, use those. If it needs QFX or QBO, your bank's own download is the safest source.

Checking the result

Look at the preview before you save. Compare the first and last dates and one or two amounts with your bank statement. If the dates are in the wrong order or the months and days are swapped, change the date setting for a QIF file and look again. The converter shows the amounts exactly as the file holds them, with a comma used as a decimal mark changed to a point, so a negative number means a withdrawal in most files, but check your own bank, because some banks use the opposite sign.

Large files

A statement with thousands of transactions is fine. The preview shows the first ten rows, and the download and the copy button hold all of them. The PDF can run to many pages, with the column headings repeated on each page. Excel files store plain numbers as numbers, so you can add up a column straight away.

Common mistakes

  • Reading dates the wrong way round. For QIF, choose day/month/year if your file uses it.
  • Expecting amounts to change sign. Some banks send withdrawals as negative and others as positive, and the converter keeps what the file says.
  • Opening a CSV in Excel with the wrong encoding. The file starts with a byte order mark so accents display correctly.
  • Using IIF as a bank statement. It is a table of accounting records.

What next

Use this often? Add QBO to CSV to your Home screen.

Frequently asked questions

What is a bank file converter?

A tool that reads bank files such as OFX, QFX, QBO, QIF and IIF and saves the transactions in another format, such as CSV or Excel.

Which files can it read?

OFX in both its older tag style and XML, QFX, QBO, QIF and IIF.

Can it write QFX or QBO files?

No. QFX is a proprietary variant of OFX used in Intuit's products, so this tool writes CSV, Excel, PDF, QIF and OFX instead.

How are QIF dates read?

Month/day/year by default. You can switch to day/month/year, and two-digit years and years after an apostrophe are handled.

Is my bank data uploaded?

No. The file is read and converted in your browser.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Finance Tools