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

Wed Aug 10 13:12:34 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
> ^
>  

As an alternative, firstly, create the credit card account manually.
Then remove the whole of the opening balance statement, but leaving
the !Type:CCard, and immediately below that, the first proper
transaction.

On import, you will be asked for the account into which to import.
this way too works correctly on the old rev.

Using the !Account just automates the account creation.

So there looks to have been a problem affecting the opening balance
transaction.  I'm just now wondering if this works correctly now because
of a patch I made some weeks ago, to do with failing to find the parent
account when a sub-account is encountered.

Allan