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@kde.org
Reporter: egroegba...@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.
_______________________________________________
KMyMoney-devel mailing list
KMyMoney-devel@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney-devel
