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

[Peter]

On Wednesday 10 August 2011 21:21:36 you wrote:
> 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

Peter,

Just another thought. As it is the Amex account that is not being created with 
the right account type, have you tried to import the QIF from the Bank of QLD 
_first_  ?

Peter