This forum has been archived. All content is frozen. Please use KDE Discuss instead.

investments from Q2000 to Kmymoney

Tags: None
(comma "," separated)
dougt
Registered Member
Posts
2
Karma
0

investments from Q2000 to Kmymoney

Fri Sep 21, 2012 2:55 am
Is there a good reference for current workarounds/best practices for importing securities account lists from Q2000 to Kmymoney? I tried using a multi-account .qif, which was great except it stripped all of the securities transactions out, or removed all of the transfers involving securities .... which is especially weird because those transfers at least should have shown up in the corresponding bank account ... but afterward there were big holes on all of the accounts where Kmymoney had stripped those out ..... After the import, all that was left was an investment account and a brokerage account with interest transactions and a smattering of other things. Is this about missing categories and ticker symbols? Because there are lots of reasons to have neither a ticker nor a category on an investment that is accounted for through an "investment account".

Does it make a difference if I go from the original .QDF source via a prior version of Kmymoney (.80)?
Does it help to convert the .QIF first to a .CSV?
Can I take a hop through GNU Money or something else to make this import work?
Is there a way to make it work with mixed brokerage transactions including securities and xin/xout?

Seems like the securities account imports ok if I remove all of the transfers (xin xout) from the .qif. Is that right?

Kmymoney looks pretty good ... but this whole securities account import is a major headache. If I have to go install an old OS to get Kmymoney .80 going so that it will work with .QDFs .... well, might as well keep sticking it out with that old Q 2000 via Wine. Thoughts?
zebulon
Registered Member
Posts
417
Karma
2
OS
I doubt you will again anything from going back to older KMM versions.
Changing to CSV won't help. Neither will Gnucash.
Before you start importing, I would recommend the following: Create all your accounts and securities manually upfront. This is very important. Unfortunately, there is no way to create a security at the time of import. Not sure about bank accounts, but chances are it will be incorrectly defined. Use an investment account with associated brokerage account. Make sure the labeling corresponds exactly to what is in the imported file (Y and L fields). If necessary, set up an import filter to redefine certain fields.
Check this forum for posts on importing QIF. Let us know if you have any specific questions.

I found an old QIF file and it does contain NXin, which probably means I was able to import it somehow.
dougt
Registered Member
Posts
2
Karma
0
Actually seems to work pretty well to import the Quicken 2000 .qif to GnuCash first, then import the results from GnuCash to KMyMoney. Also used some of the tips from OldJohnB ( viewtopic.php?t=97494 ), although those tips themselves did not completely solve the problem for me.

KMyMoney's qif importer was very unreliable dealing with investment accounts, GnuCash seems to have figured that part out. Previously KMM failed to import any investments and failed to import transfers from/to investment accounts. So all of the accounts were completely out of whack. Now, everything is OK (and much easier than fumbling through manual/scripted edits to QIF file).

Downside: all of my investments are now in one "investment" account. But they all seem to be tagged with the correct account link ... go figure. I think at least this is a workable solution.


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Evergrowing, Google [Bot], ourcraft