Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 01-27-2007, 04:36 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?

In microsoft.public.money, Steve wrote:

- quote -

> Thanks Cal. I'll play around with it when I have some time. I
> appreciate that idea of using return of capital. Steve


Good to hear.

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  
Old 01-27-2007, 04:08 PM
Steve
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?



On Jan 27, 11:36�am, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

> In microsoft.public.money, Steve wrote:
> > 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.


Thanks Cal. I'll play around with it when I have some time. I
appreciate that idea of using return of capital. Steve

  #4  
Old 01-27-2007, 03:36 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?

In microsoft.public.money, Steve wrote:

- quote -

> 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 OK


What 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.

- quote -

> 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 to see 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.


- quote -

> 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.

  #3  
Old 01-27-2007, 03:07 PM
Steve
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?



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
> graph of ((account value)-contributions) over time meet your
> criterion?


Cal, a graph is OK 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? 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  
Old 01-26-2007, 09:16 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?

In microsoft.public.money, Steve wrote:

- quote -

> 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.


That varies. Since you have knowledge of the actual holdings, then
you can be more precise.

- quote -

> 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


Would you care to clarify what you "would like to see"? Would a
graph of ((account value)-contributions) over time meet your
criterion?
  #1  
Old 01-26-2007, 08:41 PM
Steve
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?



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

 
Old 01-26-2007, 08:30 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: How do you treat a 401k rebalance?

In microsoft.public.money, D wrote:

- quote -

> 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.

  #-1  
Old 01-26-2007, 08:07 PM
D
Guest
 
Posts: n/a
Default How do you treat a 401k rebalance?

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 10:50 PM.