Quicken Mac 2006 --> MD import
Sorry if this is covered elsewhere, but I can't find my exact problem discussed. Just downloaded a trial version of MD and am attempting to port over from Quicken Mac 2006. I exported the qif file and tried the import. 10 years of records, so I can't check what's going wrong. I did the import the way it describes...account info only the first time, then the whole file with account info unchecked. The account balances come out spectacularly wrong. My checking account states that I have a balance of $4.7 million, which would be nice, but is far from true. Can you point me toward where on this site I can find a solution to this? I have way too many records to manually check them.
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | 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
1 Posted by pierson949 on 17 Feb, 2010 03:59 PM
I haven't ever been able to get the import process to work as described in the MD documentation. The only process that works for me is to export out of Quicken one account at a time. That way you can tell MD where to put the transactions. Otherwise it comes out a complete jumble. It can be tedious if you have many accounts to export, but it does work properly. A note of caution, you must export all accounts out of Quicken, even the ones that are zeroed out and no longer used, otherwise your balances will not be right. Also, don't even think about looking at the balances until you have finished this process, they won't be right until you have finished importing ALL accounts.
2 Posted by bstewart on 20 Feb, 2010 03:20 PM
I've been chipping away at this for a couple of days. Very tedious importing 10 years worth of accounts. I'm up to the accounts starting with H. Not sure this is worth it!
3 Posted by Ben Spencer on 20 Feb, 2010 09:36 PM
It absolutely should not be necessary to import each account individually from a qif file created by quicken. The most common cause of incorrect account balances after an import is the need to set an initial balance for each account the is being imported. some versions of Quicken export the initial balance as a transaction at the beginning of the register others do not. In moneydance set the initial balance by entering the account in question and then selecting Edit account from the account menu.
Sincerely
Ben Spencer
4 Posted by bstewart on 20 Feb, 2010 10:28 PM
So, do I import the account info only the first time, then change the balances, then import the transactions? I have many, many accounts...everything Quicken seems to be treated as an account: assets, bank accounts, liabilities, and many things that are zeroed out and not used any more.
5 Posted by Ben Spencer on 20 Feb, 2010 10:32 PM
It doesn't matter when you set the initial balances. You can do it before or after you import the transactions.
It is important to include all the accounts in the import even those which are no longer used and contain zero balances.
Ben
Angie Rauscher closed this discussion on 24 Jul, 2011 07:26 PM.