tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/6359-inconsistent-cost-basis-amounts-between-different-reportsInfinite Kind: Discussion 2022-02-17T01:10:19Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/494944632021-11-17T07:01:22Z2021-11-17T07:01:24ZInconsistent Cost Basis amounts between different reports<div><p>Attached are some screenshots to illustrate the issues:<br>
(1) - Securities Detail view - Cost Basis $5,078.37 (2) - Securities Detail view - Cost Basis $5,078.37 (3) - Portfolio Report - Cost Basis $5,078.37 (4) - Cost Basis Report - Remaining Total $4,889.04 (5) - Independent Excel verification - $4,889.04 All calculations are based on Average Cost basis.<br>
4:1 stock split occurred 2005.04.08</p></div>Henry Chantag:infinitekind.tenderapp.com,2009-01-14:Comment/494944632021-11-17T08:12:40Z2021-11-17T08:12:40ZInconsistent Cost Basis amounts between different reports<div><p>I agree with you.. In the meantime, one solution that normally works where splits are concerned, is to switch to lot matching and match up the buys and sells. This often corrects the CB..</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494944632021-11-17T23:31:47Z2021-11-17T23:31:51ZInconsistent Cost Basis amounts between different reports<div><p>I have not tried the Lot Matching method yet, since I need to use Average Cost for tax purposes. However, I have tried to effect the stock split by alternative means for an otherwise equivalent stock "Auckland I A L - h" (the previous stock is "Auckland I A L - e":<br>
Method B: "Buy" the additional 1200 shares from the stock split at $0.<br>
Method C: "Buy" the additioanl 1200 shares from the stock split at $0.01 (in total, not unit price).</p>
<p>The results are:<br>
(B1) Security Details view ... Remaining Cost Basis $112,849.79 ... obviously wrong since MD will impute a share price of $100 rather than $0 for a $0 "Buy". (B3) Portofilio Report ... Cost Basis also $112,849.79 (B4) Cost Basis Report ... Running Total balance $4,889.04 ... remains correct ;)</p>
<p>(C1) Security Details view ... Remaining Cost Basis $4,889.05 ... now correct other than the extra $0.01 introduced by the notional "Buy" at $0.01 for all the additional 1,200 shares from the split. (C3) Portfolio Report ... Cost Basis also "correct" at $4,889.05 (C4) Cost Basis Report ... Running Total balance $4,889.05 also "correct"</p>
<p>Conclusion from all the above.<br>
1. Cost Basis Report remains correct for all methods of processing the stock split.<br>
2. A viable work around to get "correct" Cost Basis in the Portfolio Report and Securities Detail view is to use the notional "Buy/Sell" method rather than the "Stock Split" method in MD, but the notional amount cannot be $0. (I have used $0.01 as the total value for the transaction - not unit price.) This should apply at least for Average Cost method. The use of Lot Matching may also work, but I have not tried it, and Lot Matching is not acceptable for tax reporting in my case anyway.</p>
<p>These two questions remain:<br>
1. Can the Portfolio Report and Security Detail view adopt the (correct) calculation used in the Cost Basis Report please?<br>
2. Why would MD insist on defaulting to a unit price of $100 rather than $0 when the total transaction value is in fact $0? (Is this by design or is this a bug?)</p></div>Henry Chantag:infinitekind.tenderapp.com,2009-01-14:Comment/494944632021-11-18T00:18:53Z2021-11-18T00:18:58ZInconsistent Cost Basis amounts between different reports<div><p>Tried to do another tweak to get rid of the extra $0.01 from method C by:<br>
Method D: Method C + adding another notional "Sell" transaction for 0 shares for $0.01.</p>
<p>Results:<br>
(D1): Security Details view ... Remaining Cost Basis $4,889.04, correct without the notional $0.01 difference. (D3) Portfolio Report ... Cost Basis also correct" at $4,889.04 (D4) Cost Basis Report ... Running Total balance $4,889.05 remains with the $0.01 difference.</p>
<p>Conclusion:<br>
Still a messy workaround. While the Security Details view and Portfolio Report are now correct, we are now still left with an introduced difference to the Cost Basis Report. On balance, I don't believe this last tweak is necessary in the scheme of things.</p></div>Henry Chantag:infinitekind.tenderapp.com,2009-01-14:Comment/494944632021-11-18T01:03:38Z2021-11-18T01:03:41ZInconsistent Cost Basis amounts between different reports<div><p>Impact on price charts:</p>
<p>Stock split method: Prices are correctly shown, including the automatic adjustment made to pre-split prices to align with post-split prices.</p>
<p>Notional buy_sell method: Prices are distorted, with the pre-split prices remain unadjusted original prices making them non-comparable to post-split prices. Also chart is distorted with the notional $0.01 transaction.</p>
<p>Conclusion:<br>
On balance, I believe I will stick with using the MD stock split function rather than the notional buy_sell workaround. To obtain the correct Cost Basis, I will use the Cost Basis Report and discard the incorrect information shown in the Portfolio Report and Security Details views.</p>
<p>Would appreciate if IFK could please respond to my two queries:<br>
1. When can we expect the CB reporting in Portfolio Report and Security Details view be fixed to align with the correct Cost Basis Report calculation?<br>
2. Why does $0 or 0 share transactions trigger a $100 unit price in the system, rather than $0 unit price?</p></div>Henry Chan