[Kmymoney] QIF investment file sign convention

[timothy]

On Sun, 2014-11-30 at 18:10 +0000, Allan wrote:
> 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


Will do so.
Timothy