Dates and other problems.

Julian Sambrook's Avatar

Julian Sambrook

02 Nov, 2015 09:18 AM

I sent an email last Monday but no reply. I don't want to give up on Moneydance as it looks so promising. My previous email:
I hope I am only having teething problems. A learning curve perhaps?
The transfer of QIF data seems to screw up and I think it is caused by incorrect dates.
The incorrect date is associated with the data dowloaded from a Quicken for windows QIF file to MD for Mac.
At the bottom of an account it gives me the correct balance but the date given is 07/07/2017 for a deposit made on 16/10/2015.
At the beginning of the account is payment dated 01/09/2010 but the opening balance is 10 entries lower down and date correctly 10/05/2010 (I know this is DD/MM/YYY). Why would an October entry be before a May entry?
So this first payment places me overdrawn and cannot be reconciled through the account.

I have tried to start again by deleting the application and associated files (search for .md and ‘moneydance) only the latter has any files. Currently 3 times of sending the app to the bin.
However on opening the MD accounts there is usually a list of all of my Quicken accounts which include those not to be shown anymore. With all incorrect dates and accounts that are ‘hidden’ I am rather lost and unable to reconcile or even get started.

I started again this morning for a fresh beginning by removing to the ‘bin’ the MD application and three associated files, rebooted the laptop, and checked the bin and downloaded MD again. I copied a QIF to MD but the first file had wrong dates as above and on opening the ‘Personal Finances’ I was presented with an entire list of active and hidden accounts. I really don’t understand that????

Can you help please.

Thank you and kind regards,


  1. 1 Posted by dwg on 02 Nov, 2015 10:33 AM

    dwg's Avatar

    I would start by opening the QIF file in a text editor (it is only a text file really) and examining the dates in the file to ascertain exactly what format they are in. What formats dates are in and what they should be in, in QIF files is not always the same. Quicken has a mind of its own when creating files.

    When importing make sure the date format matches and also ensure that you have selected "From another program"

    Importing of data from other programs is generally problematic because although qIf is one of the few universal formats, but it is incomplete and there are implementation differences, so it is a case of being patient and having perseverance and working through any problems. Many of us have done it but it is not a five minute job, especially with large quantities of data and Investment accounts. If you only having banking and credit card type accounts then it generally goes pretty well after you have it all setup correctly.

  2. System closed this discussion on 19 Mar, 2016 05:02 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac