<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi Allan</span></div><div><br><span></span></div><div><span>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.<br></span></div><div><br><span></span></div><div><span>I have attached the QIF file that I am using in case something was lost in the translation.</span></div><div><span>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.</span></div><div><br><span></span></div><div><span>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. </span></div><div><br><span></span></div><div><span>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.</span></div><div><br><span></span></div><div><span>Regards</span></div><div><span>Timothy</span></div><div><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial"
size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> allan <agander93@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> egroegbaker@yahoo.com<br><b><span style="font-weight: bold;">Sent:</span></b> Sunday, May 29, 2011 12:56 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [Bug 274185] QIF investment import with Lcategory:sub-category creates new incorrect category<br></font><br>
<a href="https://bugs.kde.org/show_bug.cgi?id=274185" target="_blank">https://bugs.kde.org/show_bug.cgi?id=274185</a><br><br><br><br><br><br>--- Comment #3 from allan <agander93 gmail com> 2011-05-29 12:56:09 ---<br>(In reply to comment #2)<br>> I've added today's list post to the bug -<br>> "<br>> These are standard transactions which were downloaded from the<br>> investment website. Buys and sells of shares do not always have to take<br>> place.<br>> <br>> The equity account only gets entries from a buy or sell or reinvestment<br>> of shares. All other cash transactions are shown in the brokerage<br>> account. The two accounts are a pair. The broker uses the cash in the<br>> brokerage to do the share transactions.<br>> <br>> Let me explain the cash transactions. They are not transfers between<br>> accounts. The shares generate dividends in the form of cash payouts, the<br>> money in the brokerage
account generates interest, and the broker<br>> charges fees. All these transactions take place in the brokerage/cash<br>> account unless I use the L[account:sub-account] option, then they take<br>> place as transfers to/from another account. If I buy shares the money<br>> comes from the brokerage unless I use the L[]. This is necessary as<br>> sometimes there is not enough money in the brokerage to cover expenses<br>> or purchases. However there has to be a certain threshold of cash to<br>> cover the brokers fees.<br>> <br><br>OK, That helps.<br><br>> I have just done a test run with that example file. I created an asset<br>> account "ETF" under Assets. "Satrix" with its accompanying brokerage<br>> account is an investment sub-account of ETF and contains an investment<br>> Satrix 40. I then imported the QIF into the investment account Satrix<br>> and all three cash transactions appeared in the brokerage account.
The<br>> import must be done into ETF equity account and not into the ETF<br>> brokerage account. KMM sorts out the correct account internally. AFAIK<br>> the brokerage account is never used directly - KMM does that<br>> programmatically.<br>> <br><br>That does not happen for me here! Nothing goes into to brokerage account. In<br>fact, nothing goes into any account. The only entries are as categories,<br>which, as you say, appear to ignore the ':' separator. Let's just confirm the<br>setup. I have - <br><br>ETF Asset<br>---Satrix Investment<br>------Satrix 40 Stock<br>---Satrix (Brokerage) Checking<br><br>> By the way if you use the full QIF header as below, KMM then knows what<br>> account you are working with and does not ask you in the wizard.<br>> <br>> !Account<br>>
NETF:Satrix<br>> TInvst<br>> ^<br>> !Type:Invst<br>> rest of the example file<br><br>Yes, I had added similar to your QIF, and have now edited the qif header to<br>match your actual setup.<br><br>I'm wondering if this absence of account entries is a difference between v4.5<br>and v1.x???<br><br>Has anyone a KMM v1 and v4.5? setup, please?<br><br>Incidentally, manually entering a 'yield' activity does appear to work<br>correctly.<br><br>-- <br>Configure bugmail: <a href="https://bugs.kde.org/userprefs.cgi?tab=email" target="_blank">https://bugs.kde.org/userprefs.cgi?tab=email</a><br>------- You are receiving this mail because: -------<br>You are on the CC list for the bug.<br>You reported the bug.<br><br><br></div></div></div></body></html>