Posted by & filed under Tools for Excel, Tools for Microsoft Money.

Import into Microsoft Money through QIF or OFX format (all Microsoft Money versions are supported).
There are some differences with QIF and OFX import (see below), but overall either QIF or OFX are fine to use for import.

Import into MS Money through QIF format.

  • CSV2QIF – use it to convert CSV, Excel (XLS, XLSX), TXT to QIF and import ┬áinto all Quicken versions
  • Bank2QIF – convert OFX, QFX, QBO, QIF, QBX, OFX to QIF
  • QBO2QIF – when you need to convert QBO to QIF
  • FixMyQIF – use it to make QIF file importable (select QIF target as “MS Money or others”)
  • OFX2QIF – use to convert OFX to QIF
  • QFX2QIF – use to convert QFX (Web connect) to QIF

Import into Microsoft Money through OFX format

  • Use CSV2OFX to convert CSV, Excel (XLS, XLSX), TXT to OFX and import into Microsoft Money
  • Use Bank2QFX to convert QFX, QBO, QIF, QBX to OFX (also fix OFX)

What are main differences between QIF and OFX import into Microsoft Money?

  • QIF format supports categories (and subcategories) and tags, and OFX does not
  • QIF import somewhat better when using “Recover accounts” instead of “Downloaded statements”.
  • 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).

Leave a Reply

Your email address will not be published. Required fields are marked *