Import OFX into Microsoft Money: convert OFX to QIF

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

load an OFX file in ProperConvert

What is an OFX file

OFX is a standard format for bank data. It carries the date, signed amount, payee, optional memo and check number, a transaction ID, and the account type and ID. Those details carry over, so there is little to fix. Check the account type and that the IDs stay the same between files for the same account, because apps use them to detect duplicates.

What is a QIF file

QIF is an older plain text format for transactions, with a line for each date, amount, payee, memo, check number and category. It has no transaction IDs and no currency. More about QIF.

Why convert OFX to QIF

An OFX file has the right data, but not every app accepts it. QIF is a plain text format that apps without OFX support often import, and it can carry categories. It has no transaction IDs, so import each period only once.

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 OFX to QIF

  1. Download, install and start ProperConvert. The trial is free.
  2. Open your OFX 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 QIF settings below.
  5. Click Convert, then confirm the file name and location.

Set the QIF output settings

In the QIF tab on the right sidebar, set:

See all QIF settings.

Import the QIF file into Microsoft Money

QIF imports work better through Recover Accounts than through Downloaded Statement.

  1. Start Money and select File > Import > Recover Accounts.
  2. Select the QIF file and open it.
  3. Review the imported transactions. QIF has no transaction IDs, so import each period once.

See the Microsoft Money import guide for more.

Microsoft Money QIF questions

OFX or QIF for Microsoft Money?

OFX is the preferred format, and its transaction IDs let Money skip transactions you already imported. QIF works too, but it has no IDs, so import each period once.

Which date format should a QIF file use?

The format of the country settings of your Money installation. Set it as the output date format in ProperConvert.

Which import command should I use for QIF?

Recover Accounts. QIF imports work better there than through Downloaded Statement.

Related Microsoft Money conversions