|
#6
| |||
| |||
| In microsoft.public.money, Steve wrote: - quote - > Thanks Cal. I'll play around with it when I have some time. I
Good to hear.> appreciate that idea of using return of capital. Steve An alternative would be to not display the portfolio columns that you don't find valid for your purposes for the IRA. In particular, don't display the Gain or PriceAppreciation columns. For comparing investments and performances, you might customize in the various TotalReturn columns and the Ann.Ret column, and The return columns are in percent, but they do seem to be compatible to your uses. They are in percent rather than dollars, so perhaps they will not meet your wants. The TR All column still seems that it would be valid for your purposes. |
|
#5
| |||
| |||
| On Jan 27, 11:36�am, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote: - quote - > In microsoft.public.money, Steve wrote:
Thanks Cal. I'll play around with it when I have some time. I > > On Jan 26, 5:16?pm, Cal Learner-- MVP <via_newsgr...[at]please.tnx> > wrote: > > > In microsoft.public.money, Would you care to clarify what you "would like to see"? Would a > > > graph of ((account value)-contributions) over time meet your > > > criterion? > > Cal, a graph is OKWhat I had in mind with that was to create a new tax deferred > retirement account to which you transferred your incoming > contributions (named OriginalContributions perhaps), such as the > original contribution. That should cause a negative in the > contributions account of the IRA. Then customize a NetWorthOverTime > report to include the IRA and Contributions accounts only, and not > the new OriginalContributions account. > > but what I'm really looking for is a "play by play" > > on recording distributions and possible future buys and sales of my > > IRA account. I do all of these transactions manually based on very > > SPECIFIC detail provided by Fidelity on their web site. I know Money > > has the "reinvest dividend" or "reinvest capital gain" buttons but is > > there a better way to show total gain or loss for each stock and fund? > > When I get more shares of a mutual fund in the account it doesn't cost > > me anything and I don't really gain anything at that time. But Money > > wants to add to my "cost" of the fund. I understand the rationale for > > this, but in the case of IRA accounts it should be a different > > rationale. Do you understand what I mean?At least partially. You want tosee the results of the account as if > it is a black box, yet you also want to gather data on the pieces > inside. > Using that extra OriginalContributions account you could continue > normally, but the IRA account numbers would also have a hypothetical > negative cash position as a burden. > ========== new idea================== > Suppose you turned every distribution (LT-CG, interest, etc) from a > fund into a ReturnOfCapital transaction. A $100 distribution would > also reduce the pseudo basis of the fund by $100, which you would > then Buy $100 of the fund to account for the new shares and > reinstate your basis. You would then have your new shares with no > increase in basis from Money's perspective. > If you later sell out of one fund and buy anther fund, then that > would require some other adjustment consideration. > > I am a retired accountant > > who has lived with Money's accounting *ways for 12 years so I can > > "work around" any of this. I'm just wondering if you know of a better > > way of recording IRA transactions in Money. Thanks for your input. > > Steve.You could try one or both of these ideas out in a copy of your file > to see if either approaches what you want to achieve. > Customize *a Portfolio view that only includes the accounts and > columns that make sense for this purpose. appreciate that idea of using return of capital. Steve |
|
#4
| |||
| |||
| In microsoft.public.money, Steve wrote: - quote - > On Jan 26, 5:16?pm, Cal Learner-- MVP <via_newsgr...[at]please.tnx> wrote:
What I had in mind with that was to create a new tax deferred> > In microsoft.public.money, Would you care to clarify what you "would like to see"? Would a > > graph of ((account value)-contributions) over time meet your > > criterion? > Cal, a graph is OK retirement account to which you transferred your incoming contributions (named OriginalContributions perhaps), such as the original contribution. That should cause a negative in the contributions account of the IRA. Then customize a NetWorthOverTime report to include the IRA and Contributions accounts only, and not the new OriginalContributions account. - quote - > but what I'm really looking for is a "play by play"
At least partially. You want to see the results of the account as if> on recording distributions and possible future buys and sales of my > IRA account. I do all of these transactions manually based on very > SPECIFIC detail provided by Fidelity on their web site. I know Money > has the "reinvest dividend" or "reinvest capital gain" buttons but is > there a better way to show total gain or loss for each stock and fund? > When I get more shares of a mutual fund in the account it doesn't cost > me anything and I don't really gain anything at that time. But Money > wants to add to my "cost" of the fund. I understand the rationale for > this, but in the case of IRA accounts it should be a different > rationale. Do you understand what I mean? it is a black box, yet you also want to gather data on the pieces inside. Using that extra OriginalContributions account you could continue normally, but the IRA account numbers would also have a hypothetical negative cash position as a burden. ========== new idea================== Suppose you turned every distribution (LT-CG, interest, etc) from a fund into a ReturnOfCapital transaction. A $100 distribution would also reduce the pseudo basis of the fund by $100, which you would then Buy $100 of the fund to account for the new shares and reinstate your basis. You would then have your new shares with no increase in basis from Money's perspective. If you later sell out of one fund and buy anther fund, then that would require some other adjustment consideration. - quote - > I am a retired accountant
You could try one or both of these ideas out in a copy of your file> who has lived with Money's accounting ways for 12 years so I can > "work around" any of this. I'm just wondering if you know of a better > way of recording IRA transactions in Money. Thanks for your input. > Steve. to see if either approaches what you want to achieve. Customize a Portfolio view that only includes the accounts and columns that make sense for this purpose. |
|
#3
| |||
| |||
| On Jan 26, 5:16?pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote: - quote - > In microsoft.public.money, Would you care to clarify what you "would like to see"? Would a
Cal, a graph is OK but what I'm really looking for is a "play by play"> graph of ((account value)-contributions) over time meet your > criterion? on recording distributions and possible future buys and sales of my IRA account. I do all of these transactions manually based on very SPECIFIC detail provided by Fidelity on their web site. I know Money has the "reinvest dividend" or "reinvest capital gain" buttons but is there a better way to show total gain or loss for each stock and fund? When I get more shares of a mutual fund in the account it doesn't cost me anything and I don't really gain anything at that time. But Money wants to add to my "cost" of the fund. I understand the rationale for this, but in the case of IRA accounts it should be a different rationale. Do you understand what I mean? I am a retired accountant who has lived with Money's accounting ways for 12 years so I can "work around" any of this. I'm just wondering if you know of a better way of recording IRA transactions in Money. Thanks for your input. Steve. |
|
#2
| |||
| |||
| In microsoft.public.money, Steve wrote: - quote - > This is an excellent question. Most of my investments are now in an IRA
That varies. Since you have knowledge of the actual holdings, then> transferred from my 401K when I retired. In Money, when I receive > dividend or capital gain distributions on my funds I have been looking > for the BEST way of recording the transactions. you can be more precise. - quote - > Tax wise, I know that
Would you care to clarify what you "would like to see"? Would a> the total value when I sell will be taxable income to me. I would like > to see my gain/loss since initial deposit over time until sold. Anyway > to accurately reflect this in Money 2007? Thanks. Steve graph of ((account value)-contributions) over time meet your criterion? |
|
#1
| |||
| |||
| On Jan 26, 4:30*pm, Cal Learner-- MVP <via_newsgr...[at]please.tnx> wrote: - quote - > In microsoft.public.money, D wrote: > > When you rebalance shares in your 401K, how do you input the transacation? * > > Do you use the "add shares" and "remove shares" or the "buy" and "sell" *If > > you use the buy and sell transactions, it triggers "realized" gaines or > > losses. *If you use the "add share" or remove share transaction, the "Return > > YTD" becomes way off.It is better to use Buy and Sell if you are actually tracking > securities. Because the transactions are in a tax-deferred account, > they will not be entered onto your schedule D information for Money. This is an excellent question. Most of my investments are now in an IRA transferred from my 401K when I retired. In Money, when I receive dividend or capital gain distributions on my funds I have been looking for the BEST way of recording the transactions. Tax wise, I know that the total value when I sell will be taxable income to me. I would like to see my gain/loss since initial deposit over time until sold. Anyway to accurately reflect this in Money 2007? Thanks. Steve |
| | |||
| |||
| In microsoft.public.money, D wrote: - quote - > When you rebalance shares in your 401K, how do you input the transacation?
It is better to use Buy and Sell if you are actually tracking> Do you use the "add shares" and "remove shares" or the "buy" and "sell" If > you use the buy and sell transactions, it triggers "realized" gaines or > losses. If you use the "add share" or remove share transaction, the "Return > YTD" becomes way off. securities. Because the transactions are in a tax-deferred account, they will not be entered onto your schedule D information for Money. |
|
#-1
| |||
| |||
| When you rebalance shares in your 401K, how do you input the transacation? Do you use the "add shares" and "remove shares" or the "buy" and "sell" If you use the buy and sell transactions, it triggers "realized" gaines or losses. If you use the "add share" or remove share transaction, the "Return YTD" becomes way off. d |
| Tags |
| 401k, rebalance, treat |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| 401K Manager or Balancing 401K Account Joe Doe: Can anyone make the case for me to go through th exercise of balancing a 401k account or balancing through the 401K manager? I am careful to enter... | Microsoft Money | 2 | 01-08-2007 05:14 PM | |
| OT IRA and 401k Joseph A. Zupko: Can you have both a IRA and 401k? | Microsoft Money | 4 | 02-02-2005 01:09 AM | |
| Closed End Fund-How to treat? Mike: A closed end fund trades like a stock. Should it be characterized as a stock or as a mutual fund in MONEY? -- Mike | Microsoft Money | 1 | 01-27-2004 07:17 PM | |
| Quicken 401k to Money 401k Jim: Just replaced my Quicken with Money 2004. Everything converted well. Only thing I can't figure out: I have an account "My 401k" ... in Quicken.. ... | Microsoft Money | 1 | 10-05-2003 01:07 PM | |
| Thread Tools | |
| Display Modes | |
| |