Export/Import data from MS Money

john mclaughlin 0 Reputation points
2026-03-25T16:08:49.5033333+00:00

When exporting QIF Data from Money it creates a date format of dd/mm'yyyy for transactions dated 2000 onwards which I am unable to use to import to other programs. Strangely data dated from 1997 to 1999 creates a date format of dd/mm/yyyy. How can I get all transactions to export to a useable format ie. dd/mm/yyyy.

Windows for home | Previous Windows versions | Apps

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lychee-Ng 30,240 Reputation points Microsoft External Staff Moderator
    2026-03-26T11:08:04.12+00:00

    Hi john mclaughlin,

    I know it’s frustrating when long‑term financial data won’t export properly, making newer transactions become unusable. Unfortunately, I need to note that Microsoft Money is a discontinued product, meaning it no longer receives updates or fixes. There is no settings to control or normalize QIF date formats. So your only option is to try workaround:

    1. Export the QIF file as usual
    2. Open it in a text editor (Notepad, Notepad++, etc.)
    3. Use Find and Replace to remove the apostrophe (') from dates > Save the file.

    Because Microsoft Money is no longer supported, this behavior cannot be fixed within the program itself. The only way to obtain a usable date format for all transactions is to manually clean the exported QIF file before importing.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-03-25T16:08:59.72+00:00

    Microsoft Money is not covered in the provided material, and there is no documented method in the context for changing or normalizing its QIF export date format behavior.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?