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

Wed Aug 10 12:42:43 UTC 2011

On Wed, 10 Aug 2011 22:22:10 +1000
Peter <cave at tpg.com.au> wrote:

> On Wed, 10 Aug 2011 21:54:40 +1000
> Peter <peter777 at users.sourceforge.net> wrote:
> 
> > On Wednesday 10 August 2011 21:44:05 you wrote:
> > > Hi,
> > > 
> > > on Wednesday 10 August 2011 13:21:39 Peter 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,
> > > > 
> > > > In my KMM, I have an AMEX account imported from msmoney. It
> > > > shows 'credit card' under KMM. Here is the header part of the
> > > > original QIF file from MsMoney..
> > > > 
> > > > ----
> > > > !Type:CCard
> > > > D11/07'03
> > > > T0.00
> > > > CX
> > > > POpening Balance
> > > > L[American Express]
> > > > ^
> > > > D11/07'03
> > > > CX
> > > > etc, etc
> > > > ---
> > > > 
> > > > the exported QIF file from KMM shows ..
> > > > 
> > > > -----
> > > > !Type:Bank
> > > > D11/07'03
> > > > T0.00
> > > > CX
> > > > POpening Balance
> > > > L[American Express]
> > > > ^
> > > > D11/07'03
> > > > CX
> > > > etc,etc
> > > > ----
> > > > 
> > > > but KMM definitely shows it as a credit card under liabilities.
> > > 
> > > Maybe just another KMM bug. I admit that QIF export is certainly
> > > not the strength of KMM.
> > 
> > Thomas,
> > 
> > When I uncompress the KMM data here, my Amex account info is ...
> > 
> > ----------
> >   <ACCOUNT parentaccount="AStd::Liability"
> > lastmodified="2009-06-17" lastreconciled="" institution="I000011"
> > number="" opened="2003-11-07" currency="AUD" type="4" id="A000462"
> > name="American Express" description="" > <KEYVALUEPAIRS>
> >     <PAIR key="IBAN" value="" />
> >     <PAIR key="lastStatementDate" value="" />
> >    </KEYVALUEPAIRS>
> >   </ACCOUNT>
> > -----------
> > 
> > Note account type of '4' , which must be a credit card, as my KMM
> > data is okay.  Could Peter (the other Peter) uncompress his KMM
> > file, modify the XML to account type of '4' , and then compress
> > again to .KMY  ??
> > 
> > ... without loss of other data and keeping data integrity intact of
> > course.
> > 
> > Peter
> > _______________________________________________
> > KMyMoney mailing list
> > KMyMoney at kde.org
> > https://mail.kde.org/mailman/listinfo/kmymoney
> > 
> > 
> 
> HI Peter
> 
> From an earlier mail it makes no difference which order I import the
> files result is the same.
> 
> Below is the same KMM exported Amex.qif - also similar to yours. 
> 
> !Type:Bank
> D11.10.2006
> T0.00
> CX
> POpening Balance
> L[Amex Gold Card]
> ^
> D11.10.2006
> T-571.02
> PExotissimo Travel
> LHoliday:Food & Lodging
> 
> Regards
> 
> Peter
> ^

The problem is.....

a missing entry.

Add the following at the top of the qif file.

!Account
NAmex Gold Card
TCCard
^

I've just done this successfully on the old version of KMM.

Allan