Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #1  
Old 04-26-2007, 07:06 AM
John Simon
Guest
 
Posts: n/a
Default Re: Restricted Stock Units

David,

Actually...I just found out that my employer DOES sell shares to pay the tax
witholding.

Can you please give me some advice on how to deal with that...


Thanks,
John

"David Arnstein" <arnstein[at]panix.com> wrote in message
news:dvuu98$bmo$1[at]reader2.panix.com...
- quote -

> In article <_K6dnZCtE6C0wL_ZnZ2dneKdnZydnZ2d[at]comcast.com> ,
> John Simon <darkavenger2000[at]pleaseremove.hotmail.com> wrote:
> > I recently received RSUs from my employer, and was wondering how to add
> > them
> > into Money 2006. I found a suggestion by Cal Learner to enter them as $0
> > Employee Stock Options.
> > > That mostly works. However, the issue is that once they vest, I will have

> > to
> > pay tax on them, and then will be entitled to dividends.

> I tried this method, and it is a grave mistake. It screws up the cost
> basis of the shares. It also screws up your tax records in MS Money,
> if you care about that.
> I believe that on the day your RSUs are vested (deposited to your
> account) a taxable event occurs. Your employer witholds income tax
> immediately. The cost basis of the vested shares is the market value
> on the day of vesting. And, you should receive paperwork documenting
> these numbers.
> I modeled the above assumptions in MS Money as follows:
> 1. Do nothing until RSUs vest. Wait for documentation of vesting to
> arrive in the mail. When the documentation arrives, record the
> following in the MS Money brokerage account that you have set up
> to track the RSU vesting:
> 2. Record a purchase of the RSU shares at the stated share price in
> the documentation. The account now has a negative cash balance.
> 3. Record a cash deposit to the MS Money account. The total amount of
> the deposit should bring the cash balance to zero. But the deposit
> transaction should be split into positive salary and negative tax
> categories. The amount of the taxes is copied from the
> documentation you got from your employer.
> If you do the following, I *think* that you will correctly record your
> taxable salary, your tax witholding, and the cost basis of your
> shares. I have to admit that I find tax computations to be confusing.
> I hope that I got it right this time.
> There is an additional complication. Your employer might sell a few of
> your shares in order to raise money to pay the tax witholding. It is
> not difficult to model this too, but you didn't mention it in your
> original post, so I don't know if you care.
> --
> David Arnstein | Have fun with your spams:
> arnstein+usenet[at]pobox.com | http://www.bluesecurity.com



 
Old 03-23-2006, 06:52 PM
David Arnstein
Guest
 
Posts: n/a
Default Re: Restricted Stock Units

In article <_K6dnZCtE6C0wL_ZnZ2dneKdnZydnZ2d[at]comcast.com> ,
John Simon <darkavenger2000[at]pleaseremove.hotmail.com> wrote:
- quote -

> I recently received RSUs from my employer, and was wondering how to add them
> into Money 2006. I found a suggestion by Cal Learner to enter them as $0
> Employee Stock Options.
> That mostly works. However, the issue is that once they vest, I will have to
> pay tax on them, and then will be entitled to dividends.


I tried this method, and it is a grave mistake. It screws up the cost
basis of the shares. It also screws up your tax records in MS Money,
if you care about that.

I believe that on the day your RSUs are vested (deposited to your
account) a taxable event occurs. Your employer witholds income tax
immediately. The cost basis of the vested shares is the market value
on the day of vesting. And, you should receive paperwork documenting
these numbers.

I modeled the above assumptions in MS Money as follows:

1. Do nothing until RSUs vest. Wait for documentation of vesting to
arrive in the mail. When the documentation arrives, record the
following in the MS Money brokerage account that you have set up
to track the RSU vesting:

2. Record a purchase of the RSU shares at the stated share price in
the documentation. The account now has a negative cash balance.

3. Record a cash deposit to the MS Money account. The total amount of
the deposit should bring the cash balance to zero. But the deposit
transaction should be split into positive salary and negative tax
categories. The amount of the taxes is copied from the
documentation you got from your employer.

If you do the following, I *think* that you will correctly record your
taxable salary, your tax witholding, and the cost basis of your
shares. I have to admit that I find tax computations to be confusing.
I hope that I got it right this time.

There is an additional complication. Your employer might sell a few of
your shares in order to raise money to pay the tax witholding. It is
not difficult to model this too, but you didn't mention it in your
original post, so I don't know if you care.
--
David Arnstein | Have fun with your spams:
arnstein+usenet[at]pobox.com | http://www.bluesecurity.com
  #-1  
Old 03-23-2006, 07:27 AM
John Simon
Guest
 
Posts: n/a
Default Restricted Stock Units

I recently received RSUs from my employer, and was wondering how to add them
into Money 2006. I found a suggestion by Cal Learner to enter them as $0
Employee Stock Options.

That mostly works. However, the issue is that once they vest, I will have to
pay tax on them, and then will be entitled to dividends.

There seems to be no easy way to keep track of all that. (If someone has any
ideas, please post!)

So now that a lot of employers (including Microsoft) are making the switch
to RSUs, can Cal Learner, or some other MVP push the Money folks to add this
feature into Money 2007? :-)


Thanks!


 

Tags
restricted, stock, units
Similar Threads
Thread Forum Replies Last Post
Restricted Stock
Doubleagle: What is the best way to set up restricted stock in Money 2005? Does Money 2006 have any specific functionality for restricted stock?
Microsoft Money 2 03-19-2006 09:44 PM
Restricted Stock
mfogarty: Many companies are moving away from granting stock options to granting restricted stock. It does not appear, however, that Money 2005 or Money 2006...
Microsoft Money 1 08-03-2005 04:01 AM
restricted stock units
eggdrunk: How do I create a restricted stock unit (RSU) account in Money 2003? Thanks in advance.
Microsoft Money 1 01-30-2005 05:56 PM
Restricted Stock
Least: I would like to enter restricted stock i received from my company. The stock vests over 4 years and are immediately available to sell. These are...
Microsoft Money 1 06-12-2004 04:01 PM
Restricted stock grant
Chris: Anyone know how to enter employee restricted stock grants into Money 2004? I thought it would be in there since Microsoft itself has switched from...
Microsoft Money 1 05-01-2004 09:16 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 06:00 PM.