Export/Import data from MS Money

Question

Export/Import data from MS Money

john mclaughlin 0

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.

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

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

2 answers

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

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:

Answer 2

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:

Export the QIF file as usual
Open it in a text editor (Notepad, Notepad++, etc.)
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.