[Kmymoney] QIF investment file sign convention

[timothy]

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