[Kmymoney] QIF investment file sign convention

[Allan]

On 30/11/14 14:49, timothy wrote:
>
> On Sun, 2014-11-30 at 13:13 +0000, Allan wrote:
>> Hi Timothy
>>
>> On 30/11/14 12:18, timothy wrote:
>>> Hi
>>>
>>> Could you please give me the sign convention for QIF investment format
>>> expected by Kymoney. ie Should the QIF file show positive or negative
>>> numbers.
>>
>> In general, the sign is taken care of in the activity type.  That
>> is,both a Buy and a Sell expect no sign.  Similarly, a Div and a Fee
>> will be expected to be  with no sign.
>>
>>> Specifically in the DIVX file for the Amount (T) and the Fees (O).
>>>
>>> Things seem to have changed since I last imported a Dividend?
>>
>> Well, that might depend on when you last imported a Dividend!  The
>> general case has not changed.  However, there may well have been some
>> minor changes, to cater for certain activity types previously not
>> expecting say, a fee, but which some users wished otherwise.
>>
>> If that doesn't help, the best thing might be to give us an example
>> which is not doing what you expect/expected.
>>
>> Allan
>
> Thanks Alan. Could you also please specify whether the amount (T) is
> expected net of fees (O) or inclusive of the fees.
>
> In KMM it appears that when amount and fees are positive or no sign, the
> the fees are being subtracted from the QIF file amount to give the KMM
> "Interest Amount" and then subtracted again to give the "Total Amount".
> The sign of the amount or interest is then changed to negative.
>
> Example
> The QIF file gives
> !Type:Invst
> D15/09/2014
> NDIVX
> T1853.00  \\ This is net of fees being the amount received by me
> O327.00   \\ These are the fees as taken off by broker. The total
>               dividend declared should be T+O
>
> After manual import KMM gives
> Fee Amount    ZAR 327.00
> Interest      ZAR -1526.00
> Total         ZAR 1199.00
>
> Regards
> Timothy
>
> Further to above I have found that the Total 1199.00 which is transferred to my
> cheque account is actually negative and appears in the cheque a/c as a payment not a deposit.
> So it looks like the QIF amount T has the sign changed and then the fees are added to give the
> Interest Amount and then added again to give the Total. Wow!
>
> Timothy
>

Just a quick test for the moment, but that doesn't look right to me.

I'll need to investigate, but would you please raise a bug at 
https://bugs.kde.org

Allan