tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/1409-does-not-calculate-the-fee-in-transactionsInfinite Kind: Discussion 2018-03-15T21:44:33Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-19T03:57:36Z2017-01-19T03:57:36Zdoes not calculate the fee in transactions<div><p>If you buy 100 shares of x for $5 and there is a $9.95 fee then
the total transaction should be 509.95. This would be the amount
put into the transaction total not $500.</p>
<p>The share price is $5 but the cost basis would be $5.10 (rounded
up). When calculating the share price, MD deducts the fee from the
transaction total.</p>
<p>From the screen shot, I am assuming that the total transaction
cost would have been 524.95 and 648.45</p>
<p>This would have put nike at 51.17 which is between the trading
hi/low on 12/28</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-19T11:40:40Z2017-01-19T11:40:43Zdoes not calculate the fee in transactions<div><p>thank you, tom,</p>
<p>maybe I did not express myself clearly</p>
<p>see the 2 attached before fee and after fee</p>
<p>1- before fee: my cash balance is 104,22</p>
<p>2- after fee: if I add the 104,22 to the balance fee, the cash
balance is still 104,22, which makes me think that fee field is not
calculated in the cash balance</p>
<p>is it correct?</p>
<p>if so, then the only way to me to input the operation would be
to manually calculate the price as it follows (to be able to
include share cost + fee in the Amount field):</p>
<p>shares time price = XXX + fees = XXX / shares = input price</p>
<p>say that I want to input 104,22 all to the last transaction (to
make it simple) I should then do:</p>
<p>20*52,38 = 1047,6 + 104,22 = 1151,82 / 20 = 57,591 (this would
be my input price instead of the price that I actually bought the
shares)</p>
<p>indeed 57,591 * 20 = 1151,82 (total amount shares cost +
fee)</p>
<p>am I correct? if this is the way to properly do it I will do,
but it is conceptually wrong from an admin point of view</p>
<p>thank you for your patience</p></div>Gabriele eutag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-19T20:08:01Z2017-01-19T20:08:01Zdoes not calculate the fee in transactions<div><p>Interesting, I tried entering a transaction in a number of
different ways in build 1592.</p>
<p>Depending on how I did it I got some very very wrong
transactions, with Moneydance making some rather strange arbitary
changes</p>
<p>It appears one reliable way to get the transaction right is to
enter:</p>
<ol>
<li>Total amount<br></li>
<li>Fee amount<br></li>
<li>Number of shares</li>
</ol>
<p>Share price is then calculated correctly. I would expect that
this data you should have in any case</p>
<p>If I enter</p>
<ol>
<li>Total amount<br></li>
<li>Fee amount<br></li>
<li>Price per share</li>
</ol>
<p>I get rubbish and it changes price per share, does not calculate
a number of shares.</p>
<p>If I enter</p>
<ol>
<li>Total amount<br></li>
<li>Price per share<br></li>
<li>Number of shares</li>
</ol>
<p>It changes the number of shares rather than calculate a fee
(even if I enter a fee category).</p>
<p>The algorithm behind this is doing some odd things.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-19T20:45:55Z2017-01-19T20:45:55Zdoes not calculate the fee in transactions<div><p>I've just had some thoughts on why Moneydance does some what may
be considered odd things in this, perhaps some of them are not so
odd.</p>
<p>You may not necessarily be charged any fees for the transaction,
it depends on the nature of the transaction so to conclude that a
fee must be calculate could be quite wrong.</p>
<p>Moneydance does allow you to just enter an amount it works to
increase or decrease the cost basis, it sort works as a poor mans
return of capital or capital call, but has problems in that it only
works with average cost, so it is not all that useful most of the
time.</p>
<p>It seems to me that moneydance is only using a simple algorithm
here rather than trying to eliminate the possibilities and requires
some definite input data and will not calculate just any field
based on arbitary entry.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-20T02:57:13Z2017-01-20T02:57:13Zdoes not calculate the fee in transactions<div><p>I also think it would be nice to be able to keep track of the
fees that a broker charges, as a separate investment expense
category. You may want to try and use the 'Sell' action and then
add a tag or memo to identify it as a fee. This will reduce the
number of shares in your account which should agree with the
balance of your broker statement.</p></div>rcooper85tag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-20T04:31:11Z2017-01-20T04:31:11Zdoes not calculate the fee in transactions<div><p>If you enter fees in the fee field in moneydance they are
recorded under the category "Fees" which can be reported on.</p>
<p>In direct share transactions fees are always charged separately
they are not funded by selling units as they are in Mutual
Funds</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-20T19:53:53Z2017-01-20T19:53:53Zdoes not calculate the fee in transactions<div><p>The cost basis of the stock is what you paid for the stock,
inclusive of fees. DWG is correct in that the best manner to input
a stock transaction is total shares, total cost, fees. MD will
calculate the cost per share, which is inclusive of the fees.</p>
<p>And DWG is also correct that if you want to track you investment
fees, you can run a transaction report edited to show only the
catagory for Investment fee and the dates yous wish.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-20T20:33:08Z2017-01-20T20:33:08Zdoes not calculate the fee in transactions<div><p>Tom,</p>
<p>I believe you have made a mistake.</p>
<p>In a transaction record the price per share is exclusive of
fees, it is the actual price per share of the stock.</p>
<p>In other words in the transaction record it is</p>
<p>No.of shares * price per share + fees = Amount</p>
<p>In the cost basis report the cost is inclusive of fees</p>
<p>Des</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-20T21:09:37Z2017-01-20T21:09:37Zdoes not calculate the fee in transactions<div><p>Yes DWG good catch. the register price per share is without the
fee.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-23T09:05:11Z2017-01-23T09:05:13Zdoes not calculate the fee in transactions<div><p>Hello tom,</p>
<p>I see you team had some discussion about my problem, in the end
I personally agree with des, that the balance should count all the
lines/voices in the operation, so</p>
<p>Share value * number of shares + fees</p>
<p>Anyway, to go back to my problem, are you going to fix the
formula here or should I do it differently in order to deduct the
fees from the balance?</p>
<p>Thank you</p></div>Gabriele EUtag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-23T20:22:11Z2017-01-23T20:22:11Zdoes not calculate the fee in transactions<div><p>How are you inputting transaction?</p>
<p>I select a buy transaction. I put in 20 shares, then 1047.6 in
transaction total then 104.22 in the fee and the total is adjusted
to 1151.82</p>
<p>If i put in 20 shares then 104.22 fee then 1047.6 transaction
total, then MD thinks I am telling it to take the 104 from the
1047.</p>
<p>The order in which you input informs MD on what to do.</p>
<p>When I manually enter transactions in my investment account. I
generally do the share count, the amount deducted or added to my
account as the total (in this case 1151.82) then the fee.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-23T23:48:37Z2017-01-23T23:48:37Zdoes not calculate the fee in transactions<div><p>I have always followed the same procedure:<br>
I always use keyboard input: I Tab through the entries I want to
skip, and I enter the way it is provided to me by my broker:<br>
# shares, tab, tab, tab, fee category, price per share, fee.</p>
<p>The behavior ought to be : "only the oldest variable entered by
the user is (re)computed", but there might be a need to add a
"tabbing through has a lower weight of entering than pressing
enter" in order for this to correctly work.</p>
<p>Make note: as far as I know I had no issue before MD 2017.</p></div>Charlestag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-01-24T01:36:09Z2017-01-24T15:36:18Zdoes not calculate the fee in transactions<div><p>Hello tom</p>
<p>I input share and price (amount will self calculate), then a few
days later (usually 3, when I can actually see the operation in my
bank) I add the fee</p>
<p>I will also adjust the transfer of money from bank account to
stock account (since I might have different currency, example
account in euro but stock in usd), with the real values</p>
<p>The issue here is that regardless to what I do, the cash balance
is not affected</p></div>Gabriele EUtag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-02-06T15:08:16Z2017-02-06T15:08:16Zdoes not calculate the fee in transactions<div><p>The app assumes that the transaction total amount is inclusive
of all data. If you add the fee afterwards, the app assumes this
was already in the transaction total. The best method is to adjust
the total price paid in transaction from the bank statement then
add the fee.</p>
<p>Is the transfer of funds a buy transfer, or a simple transfer
from bank to broker. You should be able to edit the transfer.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freemantag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-02-07T01:51:07Z2017-02-07T01:51:08Zdoes not calculate the fee in transactions<div><p>ok if this is the wy it works, I will move in that direction,
however in the previous version it worked differently, and in my
opinion in a more logic way. any chance you are going to modify
this area and bring it back as it was? so that the fees are
calculated in their own field?</p>
<p>thank you for the assistance</p></div>Gabriele eutag:infinitekind.tenderapp.com,2009-01-14:Comment/417100822017-02-10T23:26:54Z2017-02-10T23:26:54Zdoes not calculate the fee in transactions<div><p>I'm sorry I have just realized what the issue is. There was a
change to the coding in the investment register so that when you
edited a investment transaction the various fields would not
change. Prior to this, if you have selected the wrong security and
edited to the correct security then the price field would update to
that security price. This would completely change the transaction
total. There were a few other edits which would also change aspects
of the transaction.</p>
<p>The solution was to lock done the transaction details so there
would be no auxiliary changes with an edit. Any edit would have to
be a manual change to any necessary fields in the transaction. This
was done to minimize the chance of inadvertent changes to the
transaction while editing that transaction.</p>
<p>So when you go back to a transaction to edit in the fee, the
amount total is locked unless you change that as well. I went back
to MD 2015 and saw that was not the case.</p>
<p>I will pass the feedback you gave on to the developers.</p>
<p>Tom Freeman<br>
Infinite Kind Support</p></div>Tom Freeman