Import from Quicken 2006 for Mac has multiple issues, unsure how to resolve
I'm attempting to abandon Quicken 2006 for Mac so that I can upgrade to Lion. I exported everything to QIF, and imported it into MD as a new file. I haven't investigated much, but the initial problems are obvious.
1) There is an account named "$6,000" with an account name as a check number, and another account name as the category. I suppose I can delete this, but what is it?
2) The balance is wrong on 8 accounts, some are bank accounts, some investments, some credit cards. All of these accounts have a zero opening balance (correctly). Some of them contain over a decade of transactions. How do I find out what's causing the incorrect balance?
3) One of my credit card accounts appears twice, once with its name, and once with the name "Imported Credit Card Account." The one with the incorrect name has all the correct transactions. The account with the right name has all the transfers (payments) but is missing all other transactions and, as a result, has the wrong balance.
4) Investment accounts are missing price history. Many of my investments (401ks and such) are in securities that don't have symbols. Over the years, I've manually entered prices. These manually entered prices are all missing.
5) I've tried to hide closed accounts by editing the account and setting Hide and Inactive. The accounts still appear in the sidebar. I have far more closed accounts than open ones. I had Quicken set up to hide the closed accounts, and it hid them in almost every listing.
6) I need to hide securities without deleting them. Quicken has this feature. I can't find a way to do this. All the closed 401k accounts from previous employers were using proprietary securities that are no longer of any use except for their transaction and price history.
Please help. I have no experience with MD, but I can't even get started without a valid import and basic setup.
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 Ben Spencer on 15 Aug, 2011 08:18 AM
Hi Stephanie
1) That is odd and unfortunately not entirely surprising. Dispute its name QIF is not really a file format at least not in the sense that other file formats are. It is not standardised and there is no official specification for it. Every single version of Quicken produces QIF files in slightly different ways. If the account does not contain any transactions it is safe to delete it. I suspect this was eiter a bug in Quicken 2000 or a variation in the QIF file that we have not encountered before.
2) The first thing I would do is create a new blank Moneydance data file by selecting File->New... and then perform the import again following the instructions in the article below:
http://help.infinitekind.com/kb/importing-from-quicken-or-ms-money/...
Also please take a look at this article for common issues with QIF imports.
http://help.infinitekind.com/kb/importing-from-quicken-or-ms-money/...
3) You say that the account named "Imported Credit Card Account." has all the correct transactions and you also say that the other account contains some transactions. Are the transactions that are in the correctly named account also in the account named "Imported Credit Card Account."? If they are and "Imported Credit Card Account." does indeed have all the transactions it would be fine to delete the other account. This may go some way to correct the balance on other accounts. Once done you can rename "Imported Credit Card Account." by going into its register and selecting Account->Edit Account.
4) I don't think that Quicken 2000 includes the security price history in the QIF file.
5) You can remove an account from the side bar by clicking the minus button at the bottom of the side bar.
6) I am afraid that Moneydance does not have a feature for marking securities as inactive. It is something that has been suggested and received quite a bit of support. I am certain we will get it implemented in the not too distant future.
Sincerely
Ben Spencer
Moneydance Support
2 Posted by Stephanie on 15 Aug, 2011 12:14 PM
Thanks for your reply. I've kept the same imported file. I believe I imported it correctly.
The credit card account that was all messed up was actually pretty simple to fix. There were two "bad" accounts, which I deleted. That fixed a lot of balance issues because the bad accounts were duplicating transfers. The remaining account simply had the wrong name, so I renamed it.
One balance issue was a share rounding issue that Quicken had left in there--not a MD issue.
The remaining wrong balances were from split transfers to the same account in which only the memo line differed. I believe this was noted as a MD bug somewhere else on this site. I still have Quicken running (haven't gone to Lion yet), so I was able to find those transactions by the differing running account balances. In each case there was an extra transaction that I deleted.
I figured out how to hide the inactive accounts. With the securities, at least I got them off the home page, though it took a lot of clicking to hide about 75 securities...
It's too bad about the price history. I can record prices going forward, but my historical net worth reports won't be entirely accurate. That's just me being nit-picky, because there are probably enough buy/sell points in most of those accounts to provide a good approximation.
I'm less panicky now, and I'm closer to dumping Quicken than I ever have been (have been trying to dump it since 2008, but haven't found any software that I was comfortable with before). I've been using Quicken for Mac since 1993! Too bad Intuit destroyed the program... their loss.
3 Posted by Ben Spencer on 16 Aug, 2011 01:14 AM
Thanks for getting back to me. I am pleased that you were able to resolve a number of the issues.
Do let me know if I can be of any assistance.
Sincerely
Ben Spencer
Moneydance Support
System closed this discussion on 31 Mar, 2015 03:39 PM.