Import QIF into Microsoft Money: convert QIF to OFX

Microsoft Money imports OFX and QIF files. It can take your QIF file directly, so convert it to OFX when the direct import fails or you need what OFX offers. Read the full Microsoft Money import guide.

load a QIF file in ProperConvert

What is a QIF file

QIF is plain text with no transaction IDs and no account number, so apps can't use it to detect duplicates. Avoid converting the same period twice. Its dates can be ambiguous, such as 03/04/26, so confirm the date format in the app. QIF can carry categories, which are useful when the output needs expense and income accounts.

What is an OFX file

OFX (Open Financial Exchange) is a standard format for bank data. Many accounting apps import it. It holds the date, amount, payee, memo, check number and a transaction ID, along with the account ID and type. More about OFX.

Why convert QIF to OFX

QIF is an older format with no transaction IDs and no currency, and many current apps don't take it. OFX is the most widely accepted bank format, with named fields and a transaction ID on each row, so an app can skip rows it already has.

Before you import: back up Microsoft Money

Back up your Money file before you import any file, so you can restore it if the transactions come in wrong.

Step by step: convert QIF to OFX

  1. Download, install and start ProperConvert. The trial is free.
  2. Open your QIF file.
  3. Review the transactions to see how the app read your file. Check that the dates are correct, and that expenses are negative and deposits (payments to the account) are positive. The "Change +/-" button reverses the signs for the whole file, for bank and credit card accounts alike.
  4. Set the OFX settings below.
  5. Click Convert, then confirm the file name and location.

Set the OFX output settings

In the QBO/QFX/OFX tab on the right sidebar, set the file type to OFX and choose the OFX target for your app, then set:

Import the OFX file into Microsoft Money

  1. Start Money and select File > Import > Downloaded Statement.
  2. In the file dialog, select All Files as the file type if the file isn't listed.
  3. Select the OFX file and open it.
  4. Review the imported transactions.

See the Microsoft Money import guide for more.

Import an OFX file into Microsoft Money

Microsoft Money OFX questions

OFX or QIF for Microsoft Money?

OFX is the preferred format, because transactions are stored in a fixed, standard way. It also carries a transaction ID, which lets Money skip transactions you already imported. QIF doesn't have one.

Does my Money version need its own OFX file?

Yes. Money has US and non-US versions and older versions (99, 2000), and each expects its own OFX variant. Select the matching option in the OFX output settings.

Related Microsoft Money conversions