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

[Peter]

On Wed, 10 Aug 2011 12:15:35 +0100
aga <agander93 at gmail.com> wrote:

> On Wed, 10 Aug 2011 20:54:11 +1000
> Peter <cave at tpg.com.au> 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
> > 
> 
> Hi Peter
> 
> Right, now let's see....   OK, you're in the Southern hemisphere?  No,
> forget that.
> 
> The only difference between what you do and what I do is that I choose
> 'Bank statement' rather than 'Other application', but I've now tried
> that and still it works.
> 
> One difference is that I'm on the very latest version, rather that the
> Mint version, but this is pretty fundamental and I can't see it being
> that.  Never-the-less, I'll see if I can try an older rev.
> 
> In the meantime, just as a quick and dirty, but temporary, fix, can
> you delete your incorrect credit card account and create a new one
> manually, from the Account menu at the top, then try once more.
> 
> Allan
> 
> 
> 
Hi Allan

Yes I know we do things a little differently down here - but only
sometimes!

I would happily try the latest version of KMM but do not know how to
get it and install it.

However I am reluctant to think that it is a version issue as all
versions I have tried so far have done the same for me.

I have already deleted the incorrect accounts so will go and create a
new account manually and try again.

It will be an interesting exercise as I have done just this on both
Mint 9 and KMM 1.0.4 and Mint 10 and KMM 4.5.0 on previous occasions in
case I had missed something.

No harm in trying again.

Regards

Peter

Hi Allan

Back again

I have done exactly as you instructed, 

all accounts were deleted,

clicked on Account - New Account - filled in blank fields and made it
credit card account under Liabilities.

Checked accounts under Liabilities and sure enough Amex Gold Credit
Card account with zero balance exists.

Now I did the following import separately twice one as Bank Statement
and the other as Other Application - same result both times.

File /Import / QIF / browsed for file/ QIF Default profile / Bank
Statement / Import.

Result: No change to the manually setup Amex Credit Card Liability
account.

Two Checking accounts under Assets - one Bank of Qld and the other Amex
Gold as previously mentioned.

I have yet to compare QIF files as mentioned by another Peter just a
few minutes ago.

This must be why I am going grey!! - cant be anything else - age
doesn't count.

Regards

Peter