To MS Money: Convert transactions to a format importable by Microsoft Money

Microsoft Money Sunset edition imports OFX, QIF files. It also import QBO and QFX files. There are some differences with QIF and OFX import (see below), but overall either QIF or OFX are fine to use for import.

Convert to the OFX format

OFX files are Open Financial Exchange files. This is a preferred format for Xero as transactions are presented only in one way.

OFX format has the reference ID, when QIF does not. Reference ID (when supplied by your bank) allows to skip already imported transactions.

ProperSoft converters support reference ID and if not supplied, generate it to be unique to guarantee the import for all transactions.

OFX files should be created differently for different software (Microsoft Money for Us, non-US, old Microsoft Money 99, 2000, and also other software like Sage).

Convert to the QIF format

QIF format supported by Xero. Make sure to use expected date format (based on your country settings). When you use *2QIF converter, select QIF target as "MS Money or other" and set expected output date format

QIF import somewhat better when using “Recover accounts” instead of “Downloaded statements”.

How to Import QBO and QFX files

QBO and QFX files are extended OFX files. As MS Money follows OFX specification, it should import QBO and QFX files as OFX files. To import a QFX or QBO file, try the following in MS Money:

import an OFX/QFX/QBO file into MS Money

Related artciles