[Kmymoney] Hello - new and looking for help and advice migrating from MsMoney to KMM

[Peter]

On Wed, 10 Aug 2011 21:09:02 +1000
Peter <peter777 at users.sourceforge.net> wrote:

> On Wednesday 10 August 2011 20:54:11 Peter wrote:
> > On Wed, 10 Aug 2011 11:04:33 +0100
> > 
> > aga <agander93 at gmail.com> wrote:
> > > On Wed, 10 Aug 2011 11:22:20 +1000
> > > 
> > > Peter <cave at tpg.com.au> wrote:
> > > > Hello Allan
> > > > 
> > > > I have run KMM 4.5.3 on Linux Mint 11 from both the terminal
> > > > command line and from the start menu and imported the Amex.qif
> > > > file in each instance with the same results.
> > > > 
> > > > I get two accounts, both under the Assets heading,
> > > > 
> > > > 1.one showing Amex Gold Card as a checking account (incorrect),
> > > > with zero balance (correct), and
> > > > 
> > > > 2.the other showing Bank of Qld A Account also a checking
> > > > account (correct), with the direct debit amounts of the Amex
> > > > Gold Card (as a negative (correct) amount - most likely due to
> > > > the fact that there is no other balance to offset against - so
> > > > this would be correct.)
> > > > 
> > > > Having now looked at the Amex.qif file with a text editor and
> > > > seen that the !Type CCard line seems to be correct, should KMM
> > > > recognise this and import as a Credit Card Liability account?
> > > > 
> > > > If it were possible to Edit the import generated Amex Gold Card
> > > > account and change the type from Checking to Credit Card then
> > > > perhaps the account would then appear under the Liability
> > > > heading.
> > > > 
> > > > Maybe this is a too simplistic approach to fix the problem??
> > > > 
> > > > Regards
> > > > 
> > > > Peter
> > > 
> > > Hi Peter
> > > 
> > > I've just tried again, as it happened on my Mint PC.  Still all
> > > looks correct.
> > > 
> > > I suspect that your accounts may have been set up incorrectly from
> > > your earlier attempts.  Can you delete both of those accounts
> > > (right click), when in Accounts view.  You'll need to delete all
> > > the transactions first.  This may be done in bulk, by selecting
> > > all items in one of the accounts, then delete.   Then repeat in
> > > the other account.  If you're not able to delete an account, it
> > > will be because there are other references to them, possibly in
> > > Reports or Schedules, if you've got that far yet.
> > > 
> > > The credit card account is correctly listed under Liability here.
> > > I think you're nearly there, at least so far as this issue is
> > > concerned.
> > > 
> > > Allan
> > 
> > Hello Alan
> > 
> > I have deleted both accounts - no difficulty there- and had also
> > started the above import with a new clean install of KMM.
> > 
> > The accounts button now shows
> > Liability with no sub accounts and a balance of $0.00 and
> > Assets with no sub accounts and a balance of $0.00.
> > 
> > I must be doing something untoward as I am at a loss to explain how
> > you can import the file and find it as a Credit Card under
> > Liabilities.
> > 
> > Ok - exactly my procedure:
> > 
> > Start KMM from the menu
> > 
> > Click on file - import - qif, browse for the file and click on it,
> > QIF profile is Default, Source of QIF is Other Application, then
> > click Import.
> > 
> > Window pops up saying the statement has been processed and the
> > result is again two Checking accounts under Assets as mentioned
> > above.
> > 
> > Is there something I have missed in the above procedure?
> > 
> > Regards
> > 
> > Peter
> > 
> Peter,
> 
> I have not read all the posts for this, so excuse me if I don't 'get
> what you are doing'.
> 
> I have KMM and import msmoney QIF files. yes, there are a few gotchas
> there. What I have had to do in some instances is (a) import msmoney
> qif file, and then export from kmm to qif, and then do a beyond
> compare on the 2 QIF files. ... Some differences.
> 
> Anyway, I'd suggest you setup 2 test accounts, exactly as you want
> the 'import result' to be. Then export to QIF, and see what account
> type the header info has there. Then modify your QIF import file
> accordingly.
> 
> I do still use a (very small) QIF to import to KMM sometimes, and I
> _think_ I had to fiddle with the header info to get what I really
> wanted. I will try and hunt up that file.
> 
> From a fellow aussie.  :)
> 
> Peter
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney
> 
> 

HI Peter

Thanks for the guidance - I will try it immediately and see what the
differences might be - I never thought of doing that.

This has been driving me around the twist for at least 6 months now and
holding me back from an almost full transition. Had to keep all my tax
stuff in Ms money because I could not get KMM on Linux Mint right.

Every version of KMM I have tried has done it to me - it must? be me
somehow?

I am learning to ask after trying to solve things myself.

Will post back here what I find

Thanks and regards

Peter