[Kmymoney-devel] [Bug 274185] QIF investment import with Lcategory:sub-category creates new incorrect category

[egroegbaker at yahoo.com]

https://bugs.kde.org/show_bug.cgi?id=274185





--- Comment #5 from  <egroegbaker yahoo com>  2011-05-30 14:46:47 ---
Hi Allan

Yes, that is exactly the setup I have. I even deleted all accounts and
investments and started from scratch to try and mimic a non-event, but it works
from my side. I made the date on the investment file today's date, but that
made no difference. I added a buy transaction to the QIF file and that
correctly appeared in both the investment file and the brokerage file.


I have attached the QIF file that I am using in case something was lost in the
translation.
Also the screen capture of the Statement Stats on successful import. Does your
statement import give the same information? I have also attached the specs for
the QIF format I have been using - of course what matters is how KMM treats the
QIF.

In the QIF import message it invariably states that "statement balance is not
contained in the statement". I have tried adding it as per specs, but it is
ignored. I used the \ and $ options in the header. If you find anything that
helps it could be quite useful as it might indicate a missing transaction if
the balances do no match. 

Your suggestion that it may be a difference between KMM versions - has there
been work done on QIFs since the new version came out? I could not find
anything relevant in a bug search on bugzilla.

Regards
Timothy



________________________________
From: allan <agander93 at gmail.com>
To: egroegbaker at yahoo.com
Sent: Sunday, May 29, 2011 12:56 PM
Subject: [Bug 274185] QIF investment import with Lcategory:sub-category creates
new incorrect category

https://bugs.kde.org/show_bug.cgi?id=274185





--- Comment #3 from allan <agander93 gmail com>  2011-05-29 12:56:09 ---
(In reply to comment #2)
> I've added today's list post to the bug -
> "
> These are standard transactions which were downloaded from the
> investment website. Buys and sells of shares do not always have to take
> place.
> 
> The equity account only gets entries from a buy or sell or reinvestment
> of shares. All other cash transactions are shown in the brokerage
> account. The two accounts are a pair. The broker uses the cash in the
> brokerage to do the share transactions.
> 
> Let me explain the cash transactions. They are not transfers between
> accounts. The shares generate dividends in the form of cash payouts, the
> money in the brokerage account generates interest, and the broker
> charges fees. All these transactions take place in the brokerage/cash
> account unless I use the L[account:sub-account] option, then they take
> place as transfers to/from another account. If I buy shares the money
> comes from the brokerage unless I use the L[]. This is necessary as
> sometimes there is not enough money in the brokerage to cover expenses
> or purchases. However there has to be a certain threshold of cash to
> cover the brokers fees.
> 

OK, That helps.

> I have just done a test run with that example file. I created an asset
> account "ETF" under Assets. "Satrix" with its accompanying brokerage
> account is an investment sub-account of ETF and contains an investment
> Satrix 40. I then imported the QIF into the investment account Satrix
> and all three cash transactions appeared in the brokerage account. The
> import must be done into ETF equity account and not into the ETF
> brokerage account. KMM sorts out the correct account internally. AFAIK
> the brokerage account is never used directly - KMM does that
> programmatically.
> 

That does not happen for me here!  Nothing goes into to brokerage account.  In
fact, nothing goes into any account.  The only entries are as categories,
which, as you say, appear to ignore the ':' separator.  Let's just confirm the
setup.  I have - 

ETF                   Asset
---Satrix             Investment
------Satrix 40       Stock
---Satrix (Brokerage) Checking

> By the way if you use the full QIF header as below, KMM then knows what
> account you are working with and does not ask you in the wizard.
> 
> !Account
> NETF:Satrix
> TInvst
> ^
> !Type:Invst
> rest of the example file

Yes, I had added similar to your QIF, and have now edited the qif header to
match your actual setup.

I'm wondering if this absence of account entries is a difference between v4.5
and v1.x???

Has anyone a KMM v1 and v4.5? setup, please?

Incidentally, manually entering a 'yield' activity does appear to work
correctly.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.