[Kmymoney-devel] [kmymoney4] [Bug 322381] Fees(taxes) are deducted twice from dividend amount after QIF import

[egroegbaker at yahoo.com]

https://bugs.kde.org/show_bug.cgi?id=322381

egroegbaker at yahoo.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |egroegbaker at yahoo.com

--- Comment #1 from egroegbaker at yahoo.com ---
> > 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

Hi Allan

This is a duplicate of Bug 322381 filed July 2013 with the variation the sign
is also changed.
I did not follow up on this bug as I had implemented a work-around in my own
QIF preprocessor 
and things had worked quite nicely from then. However the negative sign has now
thrown out my
work-around logic.
I had forgotten the original bug filed, as dividend import was working for me.
You can import my
original bug numbers and see that the result has now changed. If you want me to
add anything to 
the original bug filed let me know.

Timothy

-- 
You are receiving this mail because:
You are the assignee for the bug.