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

[egroegbaker at yahoo.com]

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

            Bug ID: 322381
           Summary: Fees(taxes) are deducted twice from dividend amount
                    after QIF import
    Classification: Unclassified
           Product: kmymoney4
           Version: 4.6.3
          Platform: Ubuntu Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: kmymoney-devel at kde.org
          Reporter: egroegbaker at yahoo.com

The QIF file contains a dividend amount and a fee/tax amount. When the QIF is
imported into the investment  account the displayed amounts show a double
deduction of the fees from the dividend.
QIF                                                             KMM (display
after import)
dividend = 1150                                          dividend = 1000
fee = 150                                                    fee = 150
                                                                    total = 850
(this amount is recorded in the ledger, wrong!)

Reproducible: Always

Steps to Reproduce:
1.Open Investment account
2.Import QIF file with dividend transaction containing fees (actually dividend
tax)
3.The incorrect dividend which has the fee deducted twice is recorded.
Actual Results:  
The Dividend is shown as net (the fee is deducted before display)
The Fee is displayed correctly.
The Total amount shows the net dividend less the fee again ie a double
deduction of the fee from the dividend as recorded in the import QIF file

Expected Results:  
Asuming the dividend is the gross dividend (including the fee) the dividend
amount should display as the gross amount, the fee should display as the fee,
and the total amount which gets put into the ledger should be net (gross
dividend minus fee/tax). This is the actual money recieived.

I am running KMM 4.6.3 Using KDE 4.8.5 on Mint 13.
--------------------------------------------------------------
QIF FILE
!Account
NJSE-Shares:XYZ Shares
TInvst
^
!Type:Invst
D03/06/2013
YABSA Group Ltd
NDivX
MDividend Payment
L[Bank Accounts:Barclays Cheque]
T1150.0
O150.0
^
--------------------------------------------------------
SUPPORTING INFORMATION AS DISCUSSED ON THE LIST
> > > I am importing a dividend (DivX) via a QIF file into an investment
> > > account to be transferred to a cheque account. The QIF file has
> > > the dividend amount (T) as 1150.00 and the fees/commission (O) as
> > > 150.00.
> > > 
> > > After import KMM shows the fees as 150.00, the dividend as
> > > 1000.00 and the total as 850.00. The net dividend amount is
> > > displayed in the ledger as 850.00 which is 300 less than the QIF
> > > amount.
> > > 
> > > If I make the fees negative -150, the amounts are added twice and
> > > the total amount of 1450 is shown.
> > > 
> > > The only way to get the correct amounts is to enter a bogus
> > > dividend of 1300 in the QIF which is then subtracted twice and
> > > 1000 is then shown as the net net amount in the ledger.
> > > 
> > > I tried to get a QIF output file from Allan's CSV-plugin with no
> > > success as I am not sure of the content of the input CSV file,
> > > but I would be interested to know whether the same code is used
> > > for the import in the plugin and how the fees are handled there.
> > > 
> > > Is this a bug or am I doing something wrong?
> > > 
> > > Regards
> > > Timothy
> > > 
> > 
> > Hi Timothy
> > 
> > I wouldn't waste time trying to produce a QIF file via the CSV
> > plugin. It's now really there for historical reasons and because I
> > haven't had time to remove it.
> > 
> > However, if you attempted to use the plugin, did you try to follow
> > through to complete the import?
> > 
> > However, if you already have a QIF file, then that needs to be made
> > to work.  To be sure I try to do what you tried, can you send me
> > your QIF file direct, with any private info disguised.
> > 
> > Allan
> > 
> Hi Allan
> 
> No, I was more interested in comparing your QIF with mine to see how
> you handled the fees and whether you used the net or gross dividend.
> 
> Anyway here is the QIF I am using.
> 
> Regards
> Timothy
> 

Yes, that does not look right.  Would you raise a bug at
https://bugs.kde.org/ so it doesn't get forgotten.

Allan

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