Version: unspecified (using KDE 1.2) OS: Linux This bug has been tested with an import of Interest, Dividends and Management fees into an investment account. Since no actual share activity takes place (Buy or Sell), all transactions are placed in the brokerage account with relevant category:sub-category descriptions. These are existing categories and sub-categories which have transactions from manual input. When importing a QIF investment file with Lcategory:sub-category, which indicates the sub-category type for the transaction, the importation takes place without error. In the ledger view of the brokerage account all appears correct with the Category field or the Interest field displaying what appears to be Category:Sub-category. However when inspecting the category list it is evident that a new category only has been created with the name of "Category:Sub-category" as one word and the transaction has been allocated to this category with nothing in the existing sub-category. As mentioned the exact same transaction can be done manually with no error or newly created categories. This bug only occurs in QIF import and I believe only in QIF investment import. I have tested a QIF Bank file (!Type:Bank) from Allan Anderson and QIF Bank files downloaded from my own bank. The transactions are correctly allocated to existing sub-categories and are correctly created when none exist. Reproducible: Always Steps to Reproduce: An example of the QIF which causes the error is given in Additional Information File>Import>QIF... Select file with the default profile. Import. Actual Results: A new category only is created with the name of "Category:Sub-category" as one word and the transaction is allocated to this category with nothing in the existing sub-category. Expected Results: The transactions should be correctly allocated to existing sub-categories and correctly created when none exist. !Type:Invst D01/04/2011 YSatrix 40 NIntInc MCREDIT INTEREST LLocal Interest:Satrix Interest T1.55 I1.0000 Q1.55 ^ D21/04/2011 YSatrix 40 NIntInc MSatrix Dividends LLocal Dividend:Satrix 40 T454.86 I1.0000 Q454.86 ^ D28/04/2011 YSatrix 40 NIntInc MManagement Fee LBank Charges:Service Fee T304.02 I1.0000 Q-304.02 ^ I am using KMM 1.0.5 on KDE 3.5.10, but I believe this bug is common to the latest version.
Ping - the bug report exists :).
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. 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. 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
(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.
I've found the source of this issue, which is much like the previous report, except concerning categories rather that accounts, and I've inserted a similar change. Now, the category imported is separated correctly. However, I've had a concern about this issue from the beginning, and I think now I can put my finger on it. As has been stated, it is possible to perform a manual input of the same transaction type, and this does give the correct results. Now, back trying importing again, at least so far so far as the categories are concerned, all is well. However, the transactions are flagged because, while there is now a category, there is no account in which to deposit the funds. The reason is that the 'L' record contains the category, so cannot contain the account. It does not default to using a brokerage account during import. Should it? Did it previously?
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@gmail.com> To: egroegbaker@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.
Timothy Just to avoid you losing any sleep, I think I've found a way, without needing to edit the QIF file. The problem with your 'IntInc' is that in some cases, it may be being used for an expense transaction so KMM gets the sign wrong. Whilst 'IntInc' does not need and does not expect share quantities and prices, if they are there, as they are in your case, the amount can be derived from price x quantity, and if the quantity is negative, that sorts out the sign. This looks to be OK and shouldn't trouble anyone else, I don't think. Because the 'L' line is being used for the category in your case, no account can be specified, so, provided the investment account has a brokerage account, that gets used. If there is no such account, the transaction will be flagged.
Hi Allan To recap: Bug #1: Accounts Fixed 1) No new accounts created 2) L[Account:sub-account]processed correctly Bug#2: Categories:sub-categories only in KMM 1.0.5 More serious in version KMM 4.x 1) Categories sorted out except for " Bank Charges:Service Fee not split"? 2) IntInc work around for negative (Fees) and positive (Interest) transactions or use miscexp for negative Fees 3) IntInc transactions are being recorded correctly in brokerage account only 4) Dividends: use option 'Div' - records in both brokerage and investment a/cs Is that everything? Is there any thing left out? or have I got anything wrong? Maybe you could sum it up better, but it seems that you have got it working in all the problem areas. Thanks and regards Timothy ________________________________ From: allan <agander93@gmail.com> To: egroegbaker@yahoo.com Sent: Friday, June 3, 2011 12:08 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 #6 from allan <agander93 gmail com> 2011-06-03 12:08:37 --- Timothy Just to avoid you losing any sleep, I think I've found a way, without needing to edit the QIF file. The problem with your 'IntInc' is that in some cases, it may be being used for an expense transaction so KMM gets the sign wrong. Whilst 'IntInc' does not need and does not expect share quantities and prices, if they are there, as they are in your case, the amount can be derived from price x quantity, and if the quantity is negative, that sorts out the sign. This looks to be OK and shouldn't trouble anyone else, I don't think. Because the 'L' line is being used for the category in your case, no account can be specified, so, provided the investment account has a brokerage account, that gets used. If there is no such account, the transaction will be flagged.
(In reply to comment #7) > Hi Allan > > To recap: > Bug #1: Accounts > > Fixed > 1) No new accounts created > 2) L[Account:sub-account]processed correctly > 1) Using your original QIF, and with the accounts and categories set up as you have them, yes, no new accounts/categories get created. 2) Yes, with activity codes left as 'IntInc', the transactions are allocated to the correct category:sub-category, with the service fee as a Payment, and the others as deposits. > Bug#2: Categories:sub-categories only in KMM 1.0.5 > More serious in version KMM 4.x > > 1) Categories sorted out except for " Bank Charges:Service Fee not split"? > 2) IntInc work around for negative (Fees) and positive (Interest) transactions > or use miscexp for negative Fees > 3) IntInc transactions are being recorded correctly in brokerage account only > > 4) Dividends: use option 'Div' - records in both brokerage and investment a/cs 1) All categories are correct. 2) Yes, as above. No miscexp necessary. 3) Yes, all appear only in the Brokerage account - two deposits and one payment. 4) Not sure what you mean here? No Dividend records are now involved in your QIF. If you mean, aside from your QIF, if Dividends are entered, how do they appear, well, I still have a problem with Div records. a) 'Div' 'L[acc]' treated as category. b) 'Div' 'Lacc' deposits in 'acc' with no category. c) 'DivX' 'Lacc' deposits in 'acc' with no category. d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category. From my reading, b) and d) should be valid, and the other two, who knows? It would be interesting to know how V1.x handles these. > > Is that everything? Is there any thing left out? or have I got anything wrong? > Maybe you could sum it up better, but it seems that you have got it working in > all the problem areas. > I think that covers the problem areas, but I have more testing to do, and a tidy up, then it goes to the reviewboard.
(In reply to comment #8) > (In reply to comment #7) > > Hi Allan > > > > To recap: > > Bug #1: Accounts > > > > Fixed > > 1) No new accounts created > > 2) L[Account:sub-account]processed correctly > > > 1) Using your original QIF, and with the accounts and categories set up as you > have them, yes, no new accounts/categories get created. > 2) Yes, with activity codes left as 'IntInc', the transactions are allocated to > the correct category:sub-category, with the service fee as a Payment, and the > others as deposits. > > > Bug#2: Categories:sub-categories only in KMM 1.0.5 > > More serious in version KMM 4.x > > > > 1) Categories sorted out except for " Bank Charges:Service Fee not split"? > > 2) IntInc work around for negative (Fees) and positive (Interest) transactions > > or use miscexp for negative Fees > > 3) IntInc transactions are being recorded correctly in brokerage account only > > > > 4) Dividends: use option 'Div' - records in both brokerage and investment a/cs > > 1) All categories are correct. > 2) Yes, as above. No miscexp necessary. > 3) Yes, all appear only in the Brokerage account - two deposits and one > payment. > 4) Not sure what you mean here? No Dividend records are now involved in your > QIF. If you mean, aside from your QIF, if Dividends are entered, how do they > appear, well, I still have a problem with Div records. > a) 'Div' 'L[acc]' treated as category. > b) 'Div' 'Lacc' deposits in 'acc' with no category. > c) 'DivX' 'Lacc' deposits in 'acc' with no category. > d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category. > > From my reading, b) and d) should be valid, and the other two, who knows? > It would be interesting to know how V1.x handles these. > > Let me have another go at this, this time using the version with my patches :( a) 'Div' 'L[acc]' deposits in 'Brokerage' with 'Dividend' category. b) 'Div' 'Lacc' deposits in 'Brokerage' with 'Dividend' category. c) 'DivX' 'Lacc' deposits in 'acc' with no category. d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category, (inc any sub-cat). so, still a bit to do. > > Is that everything? Is there any thing left out? or have I got anything wrong? > > Maybe you could sum it up better, but it seems that you have got it working in > > all the problem areas. > > > I think that covers the problem areas, but I have more testing to do, and a > tidy up, then it goes to the reviewboard.
Hi Allan Regarding the Div transactions. Agreed. 4 a) and 4 c) are not as per QIF specifications and should be ignored I guess. 4 b) One of my transactions is actually a dividend transaction for which I was using the IntInc. When changing IntInc to Div I geta transaction in both the investment account and the brokerage. In the investment account it is an entry with no effect - only the value is shown. But it has the correct category. You do not mention this entry? In the brokerage the category is just 'investment transaction', but the amounts are valid. This would seem to be the correct outcome since there are no shares bought, but it is an investment activity. I have attached snap shots of both accounts with the div transaction highlighted,. The QIF entry is as follows:- D21/04/2011 YSatrix 40 NDiv MSatrix Dividends LLocal Dividend:Satrix 40 T454.86 I1.0000 Q454.86 ^ I will look into 4 d) later and separately so as not to confuse the issue. Regards Timothy ________________________________ From: allan <agander93@gmail.com> To: egroegbaker@yahoo.com Sent: Saturday, June 4, 2011 1: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 #9 from allan <agander93 gmail com> 2011-06-04 13:56:45 --- (In reply to comment #8) > (In reply to comment #7) > > Hi Allan > > > > To recap: > > Bug #1: Accounts > > > > Fixed > > 1) No new accounts created > > 2) L[Account:sub-account]processed correctly > > > 1) Using your original QIF, and with the accounts and categories set up as you > have them, yes, no new accounts/categories get created. > 2) Yes, with activity codes left as 'IntInc', the transactions are allocated to > the correct category:sub-category, with the service fee as a Payment, and the > others as deposits. > > > Bug#2: Categories:sub-categories only in KMM 1.0.5 > > More serious in version KMM 4.x > > > > 1) Categories sorted out except for " Bank Charges:Service Fee not split"? > > 2) IntInc work around for negative (Fees) and positive (Interest) transactions > > or use miscexp for negative Fees > > 3) IntInc transactions are being recorded correctly in brokerage account only > > > > 4) Dividends: use option 'Div' - records in both brokerage and investment a/cs > > 1) All categories are correct. > 2) Yes, as above. No miscexp necessary. > 3) Yes, all appear only in the Brokerage account - two deposits and one > payment. > 4) Not sure what you mean here? No Dividend records are now involved in your > QIF. If you mean, aside from your QIF, if Dividends are entered, how do they > appear, well, I still have a problem with Div records. > a) 'Div' 'L[acc]' treated as category. > b) 'Div' 'Lacc' deposits in 'acc' with no category. > c) 'DivX' 'Lacc' deposits in 'acc' with no category. > d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category. > > From my reading, b) and d) should be valid, and the other two, who knows? > It would be interesting to know how V1.x handles these. > > Let me have another go at this, this time using the version with my patches :( a) 'Div' 'L[acc]' deposits in 'Brokerage' with 'Dividend' category. b) 'Div' 'Lacc' deposits in 'Brokerage' with 'Dividend' category. c) 'DivX' 'Lacc' deposits in 'acc' with no category. d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category, (inc any sub-cat). so, still a bit to do. > > Is that everything? Is there any thing left out? or have I got anything wrong? > > Maybe you could sum it up better, but it seems that you have got it working in > > all the problem areas. > > > I think that covers the problem areas, but I have more testing to do, and a > tidy up, then it goes to the reviewboard.
Hi Allan I tested out the DivX: 4 d) options which were 1) L[Bank Accounts:ABSA Cheque] 2) L[ABSA Cheque] These come back to the original problem Bug#1 Accounts which have not been fixed in v1.0.5. So I am not sure whether the results are useful. For instance 2) above gives the following 2) *Entry into Investment Account with just value and no shares. *Deposit into 'Bank Accounts:ABSA Cheque' - correct amount; and Category 'Investment transaction' *No entry into brokerage (correct) *New empty top level account created under Assets called 'ABSA Cheque' If you would like me to continue with 1) or send snapshots of the results, let me know. Timothy ________________________________ From: allan <agander93@gmail.com> To: egroegbaker@yahoo.com Sent: Saturday, June 4, 2011 1: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 #9 from allan <agander93 gmail com> 2011-06-04 13:56:45 --- (In reply to comment #8) > (In reply to comment #7) > > Hi Allan > > > > To recap: > > Bug #1: Accounts > > > > Fixed > > 1) No new accounts created > > 2) L[Account:sub-account]processed correctly > > > 1) Using your original QIF, and with the accounts and categories set up as you > have them, yes, no new accounts/categories get created. > 2) Yes, with activity codes left as 'IntInc', the transactions are allocated to > the correct category:sub-category, with the service fee as a Payment, and the > others as deposits. > > > Bug#2: Categories:sub-categories only in KMM 1.0.5 > > More serious in version KMM 4.x > > > > 1) Categories sorted out except for " Bank Charges:Service Fee not split"? > > 2) IntInc work around for negative (Fees) and positive (Interest) transactions > > or use miscexp for negative Fees > > 3) IntInc transactions are being recorded correctly in brokerage account only > > > > 4) Dividends: use option 'Div' - records in both brokerage and investment a/cs > > 1) All categories are correct. > 2) Yes, as above. No miscexp necessary. > 3) Yes, all appear only in the Brokerage account - two deposits and one > payment. > 4) Not sure what you mean here? No Dividend records are now involved in your > QIF. If you mean, aside from your QIF, if Dividends are entered, how do they > appear, well, I still have a problem with Div records. > a) 'Div' 'L[acc]' treated as category. > b) 'Div' 'Lacc' deposits in 'acc' with no category. > c) 'DivX' 'Lacc' deposits in 'acc' with no category. > d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category. > > From my reading, b) and d) should be valid, and the other two, who knows? > It would be interesting to know how V1.x handles these. > > Let me have another go at this, this time using the version with my patches :( a) 'Div' 'L[acc]' deposits in 'Brokerage' with 'Dividend' category. b) 'Div' 'Lacc' deposits in 'Brokerage' with 'Dividend' category. c) 'DivX' 'Lacc' deposits in 'acc' with no category. d) 'DivX' 'L[acc]' deposits in 'acc' with 'Dividend' category, (inc any sub-cat). so, still a bit to do. > > Is that everything? Is there any thing left out? or have I got anything wrong? > > Maybe you could sum it up better, but it seems that you have got it working in > > all the problem areas. > > > I think that covers the problem areas, but I have more testing to do, and a > tidy up, then it goes to the reviewboard.
(In reply to comment #11) > Hi Allan > > I tested out the DivX: 4 d) options which were > 1) L[Bank Accounts:ABSA Cheque] > 2) L[ABSA Cheque] > These come back to the original problem Bug#1 Accounts which > have not been fixed in v1.0.5. So I am not sure whether the results > are useful. For instance 2) above gives the following > > > 2) *Entry into Investment Account with just value and no shares. > *Deposit into 'Bank Accounts:ABSA Cheque' - correct amount; > > and Category 'Investment transaction' > *No entry into brokerage (correct) > *New empty top level account created under Assets called > > 'ABSA Cheque' > > If you would like me to continue with 1) or send snapshots of the > > results, let me know. > > Timothy This is becoming a very wordy bug, so I think it best to heavily edit responses to avoid repetition!! No, I don't think further testing by you is necessary, unless you uncover something not previously mentioned. I will take a look at your Div transaction. Here, the problem at the moment is that I have resolved the issue of account:sub-account handling, but this works only for categories which already exist. If a 'new' category is needed, I don't think the hierarchy is correct. also, if a 'new' category is needed, how can KMM know what type to create? It appears to default to income. So, even if I correct the hierarchy, it may still be of the wrong type.
svn1237738 has been committed, unfortunately before I had annotated with bug ID and review ID. And, I'm not able (not allowed) to close this bug.