tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/5585-no-actions-in-investment-registers-for-interest-incomeInfinite Kind: Discussion 2021-06-18T11:50:25Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T00:35:59Z2020-12-23T00:35:59ZNo Actions in Investment Registers for Interest Income<div><p>I'm a fellow user.</p>
<p>Some programs use the "Action" field to determine the complete processing of transactions, including the category to be used.</p>
<p>Moneydance does not do this, it uses the Action field to determine just how the transaction is to be processed, the category used is what you determine. This allows Moneydance to be used in various countries that have different requirements.</p>
<p>On this basis Div and MiscInc are processed in an identical way. The names do not mean much, the names are ones that historically been used, there is no generic name like Inc.</p>
<p>Div is used for any sort of regular income event, this name is used simply because it was the name determined by the QIF specifications.</p>
<p>They could have potentially have inserted other actions but they would just be an alias.</p>
<p>In short Moneydance does not need actions like Int, MargInt, CgShrt etc as Quicken has because it does not handle transactions in the same way.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T01:25:48Z2020-12-23T01:25:48ZNo Actions in Investment Registers for Interest Income<div><p>Dear dwg,<br>
Thanks for your feedback.<br>
in short, I don’t care what Quicken or other programs do or don't. I have noted in other threads (like re Security Price Loader) that MD does not cater much to bond holders, who are relegated to use MiscInc. Bonds, aka Obligations in some countries or Fixed Income Securities, pay Interest across the world, not Dividends.<br>
Merry Christmas<br>
F</p></div>Fredtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T01:59:12Z2020-12-23T01:59:12ZNo Actions in Investment Registers for Interest Income<div><p>Fred</p>
<p>Personally I could not care less what the action names are, my main concern is to have the actions available to do what needs to be done to process transactions correctly. The names I see as largely immaterial and are there to drive how the transaction is to be processed, so long as name indicates to me how a transaction is processed I find satisfactory. I do not see a lot of value in having multiple actions that all work the same way.</p>
<p>Des</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T02:09:59Z2020-12-23T02:09:59ZNo Actions in Investment Registers for Interest Income<div><p>Fred</p>
<p>FWIW, from a user perspective, rather than what was really needed, I put a suggestion up to the Developer some time ago asking if it was possible that in the software could Alias for various action types be added.</p>
<p>In other words there would be one block of code that various actions like Div, Int could all point to. Hence you would not see a blow out in redundant code that has to be maintained but just different front end names given to the same action.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T02:38:16Z2020-12-23T02:38:16ZNo Actions in Investment Registers for Interest Income<div><p>Thank you, dwg. That would be a good & simple way - probably some time in the future …</p>
<p>At this point, I would like them to spend some time on allowing users to correct the often erroneous Cost Basis. Maddy’s universal answer to use Lot rather than Average Costing rarely works.</p>
<p>Stay Safe.<br>
F</p></div>Fredtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T03:06:59Z2020-12-23T03:06:59ZNo Actions in Investment Registers for Interest Income<div><p>In my experience incorrect cost basis usually comes down to one of two reasons.</p>
<ol>
<li>Incorrect transactions</li>
</ol>
<p>2, Using transactions to mimic actions that do not exist but that do not complete mimic what the missing transaction would do. My cost basis for accounts where I have returns of capital are stuffed, I know they are correct at the total level but at a lot level they are wrong and they are wrong in the Cost Basis report.</p>
<p>To delve into what is happening around cost basis in an account it would need going through each transaction and stock split to trace what is happening and what should be happening and see where it may diverge.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T05:15:38Z2020-12-23T05:15:38ZNo Actions in Investment Registers for Interest Income<div><p>We are diverging from the Subject of this thread. Have a look here, if you like - a rather simple, documented case of one Buy, 4 splits, (and a few Sell, which have no impact on Cost Basis): <a href="https://infinitekind.tenderapp.com/discussions/investments/5573-cost-basis-incorrect">https://infinitekind.tenderapp.com/discussions/investments/5573-cos...</a><br>
Your evaluation & feedback is welcome. IK support has gone silent.<br>
F</p></div>Fredtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T06:21:43Z2020-12-23T06:21:43ZNo Actions in Investment Registers for Interest Income<div><p>Hi Fred, for interest I use an Xfr in and assign my interest category (just like you would in a normal bank category.</p>
<p>There is actually a way to adjust the cost basis, but not as you would like it. I worked with the developer a while ago to get buy/sell zero shares working. Hence if you do this with a value then it does adjust the cost basis. The intent behind this is to account for transaction types that MD does not do, like return of capital, or accumulation funds. They do work and the portfolio and gains reports too, but not the cost basis report. I also remember him saying there was a problem with splits. But you could carefully try one and see what happens.</p>
<p>What version of MD are you on, these enhancements are only in later versions of the program?</p>
<p>Separately, I did make some suggestions to you before but I don’t know the outcome:<br>
- confirm you are on lot or avg cost control on these these accounts? - run my extract script so we can see the actual records in case we can see a data issue - perhaps create new identical buy/sells and delete the old txns (I have seen corruption before). Do this by duplicating a line and deleting the old one. This may trigger a CB recalculation. - finally, last resort, sell all, buy again (as a fake transaction.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442020-12-23T17:35:37Z2020-12-23T17:35:37ZNo Actions in Investment Registers for Interest Income<div><p>Hi Stuart,<br>
I am using MD 2021 (2010).</p>
<p>I do not reinvest the Div, I cash out Div.</p>
<p>I use avg costing, but this is immaterial, when you have only a one time purchase in the account<br>
The screenshot I posted for my 2 AAPL holdings are all there is, no other txn.</p>
<p>For the 1999 holding it is a simple one time purchase, that is only one (1) lot, a few sales in recent years and 4 splits as noted in the Security Detail screenshot:</p>
<p>06/21/00 :2<br>
02/28/05: 2<br>
06/07/14: 7<br>
08/31/20: 4</p>
<p>The number of shares currently held is shown correctly in the Security Detail.</p>
<p>I see these big cost basis discrepancies only with my AAPL holdings.<br>
F</p></div>Fredtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-16T21:50:26Z2021-03-16T21:50:27ZNo Actions in Investment Registers for Interest Income<div><p>This just doesn't work for me. For example, if I have excess cash in investment account, and they give me $2 in interest income, I should be able to code it as a 'deposit', credit it to 'interest income'. When I use the MiscIncome action, it keeps inserting a security,,, very frustrating. Why not a general 'Deposit' action code?</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-16T22:09:07Z2021-03-16T22:09:07ZNo Actions in Investment Registers for Interest Income<div><p>As I said above, you use Xfr to deposit cash coming in and set the category to interest. No security involved.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-16T23:01:34Z2021-03-16T23:01:35ZNo Actions in Investment Registers for Interest Income<div><p> I will try this again, but I could not get my category to work, nor could I 'outrun' the auto population of a security.</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-17T00:18:14Z2021-03-17T00:18:14ZNo Actions in Investment Registers for Interest Income<div><p>I'm a fellow user.</p>
<p>If you select the Xfr action whatever is in the Security file will be greyed out and unselectable. This means that whatever is displayed in the field will not become part of the saved record. It is just a placeholder in the display.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-17T00:27:35Z2021-03-17T00:27:35ZNo Actions in Investment Registers for Interest Income<div><p>I lost control of the category when I did this. did not work. Defaulted<br>
to a misc category.</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-17T00:46:15Z2021-03-17T00:46:15ZNo Actions in Investment Registers for Interest Income<div><p>You should be able to change the category field value to whatever is required.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-19T10:26:10Z2021-03-19T10:26:10ZNo Actions in Investment Registers for Interest Income<div><p>Surprisingly and yet entirely logically too, with a XFR action, you set the category in the Transfer field, not the greyed-out and inaccessible Category field.</p></div>Bentag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-19T10:51:21Z2021-03-19T10:51:21ZNo Actions in Investment Registers for Interest Income<div><p>Ah yes that was a mistake on my part.</p>
<p>Investment accounts have a field called category and a field called transfer.</p>
<p>Investment accounts have the ability to have two transactions in one. DivXfr being an example both recording an income event as well as a transfer event in the one transaction.</p>
<p>Internally Accounts and categories are largely the same in Moneydance. In accounting they are the same and Moneydance is based on accounting principles.Having both a category field as well as a transfer field facilitates have two transactions in one.</p>
<p>Hence in Moneydance in the transfer field you can select an account but you can instead select a category. When using a XFR action to record say interest, you can select the interest category in the transfer field.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/489239442021-03-19T11:41:05Z2021-03-19T11:41:05ZNo Actions in Investment Registers for Interest Income<div><p>... and guess what. Internally.... categories are accounts. Thus, transfer field is also an account. Thus, account, category, transfer fields are actually all the same thing.....</p></div>Stuart Beesley (Mr Toolbox)