Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #6  
Old 10-31-2008, 07:26 PM
JRV
Guest
 
Posts: n/a
Default Re: Dividend Tax

Thanks for this information. I was trying to reconcile an investment
performance report to the transactions this morning and I couldn't determine
the difference. The investment was a Canadian Trust with taxes withheld on
dividends. So I assume this is my "difference".


"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Pablot wrote:
> > Thanks, your answer is clear, but the problem is in your own words "...and
> > 1,5 cash expense that you will assign to a category for the withheld tax". In
> > this category I will have ALL the withheld taxes of different stocks. So when
> > I want to know the real performance of a stock the withheld tax do not be
> > considered.

> Yes, if it is in a tax-deferred account, the withheld tax is lost
> money. In a taxable account, it may be fully refundable for small
> enough amounts. In that case, it could be properly ignored when
> figuring performance. You *could* enter the transaction as an
> OtherExpense for the particular stock manually, and then Delete or
> Void the downloaded withholding amount.
> It is also possible to have WithheldTax:StockA and
> WithheldTax:StockZ as categories, using the dual category hierarchy.
> This, as would the method in the last sentence of the preceding
> paragraph, be a lot of work for the amount of benefit.

  #5  
Old 10-30-2008, 07:41 PM
Pablot
Guest
 
Posts: n/a
Default Re: Dividend Tax

Thanks a lot.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Pablot wrote:
> > Thanks, your answer is clear, but the problem is in your own words "...and
> > 1,5 cash expense that you will assign to a category for the withheld tax". In
> > this category I will have ALL the withheld taxes of different stocks. So when
> > I want to know the real performance of a stock the withheld tax do not be
> > considered.

> Yes, if it is in a tax-deferred account, the withheld tax is lost
> money. In a taxable account, it may be fully refundable for small
> enough amounts. In that case, it could be properly ignored when
> figuring performance. You *could* enter the transaction as an
> OtherExpense for the particular stock manually, and then Delete or
> Void the downloaded withholding amount.
> It is also possible to have WithheldTax:StockA and
> WithheldTax:StockZ as categories, using the dual category hierarchy.
> This, as would the method in the last sentence of the preceding
> paragraph, be a lot of work for the amount of benefit.

  #4  
Old 10-30-2008, 03:03 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Tax

In microsoft.public.money, Pablot wrote:

- quote -

> Thanks, your answer is clear, but the problem is in your own words "...and
> 1,5 cash expense that you will assign to a category for the withheld tax". In
> this category I will have ALL the withheld taxes of different stocks. So when
> I want to know the real performance of a stock the withheld tax do not be
> considered.


Yes, if it is in a tax-deferred account, the withheld tax is lost
money. In a taxable account, it may be fully refundable for small
enough amounts. In that case, it could be properly ignored when
figuring performance. You *could* enter the transaction as an
OtherExpense for the particular stock manually, and then Delete or
Void the downloaded withholding amount.

It is also possible to have WithheldTax:StockA and
WithheldTax:StockZ as categories, using the dual category hierarchy.
This, as would the method in the last sentence of the preceding
paragraph, be a lot of work for the amount of benefit.
  #3  
Old 10-30-2008, 02:51 PM
Pablot
Guest
 
Posts: n/a
Default Re: Dividend Tax

Thanks, your answer is clear, but the problem is in your own words "...and
1,5 cash expense that you will assign to a category for the withheld tax". In
this category I will have ALL the withheld taxes of different stocks. So when
I want to know the real performance of a stock the withheld tax do not be
considered.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Pablot wrote:
> > What I want to mean is that if you go to the report "Performance by
> > investment account", and if you look into the fields "realized gain/loss",
> > and "return for the period", the withheld tax DOES NOT APPEAR there. For me,
> > if you want to know the real performance of a stock you have to consider the
> > dividend (this is well done by Money Plus) AND the tax withheld (this field
> > is not linked with the dividend transaction).

> You get $10 in dividends from a foreign stock. $1.50 is withheld, so
> you get a net $8.50 in cash.
> You enter, or download, a $10 Dividend, and a $1.50 cash expense,
> that you will assign to a category for the withheld tax.
> The performance reports show $10.
> When you get your US 1099, there is a corresponding $10 dividend
> listed there, and a $1.50 of foreign tax. You include the $10
> amount in your gross income. The $1.50 may be credited 100% to you
> along with wage withholding etc. Alternatively goes on form 1116 if
> your foreign tax dividend withholding reaches a $300 or $600 total
> threshhold, from which at least part makes it back as a credit.
> So the method used in Money matches the US tax treatment. Now if
> this is a tax-deferred account, the foreign tax is lost to you.
> Entering a $8.50 dividend would make sense in analysis, but the
> reality is that you are probably going to download a $10 dividend
> from your broker, even in a tax-deferred account and the separate
> expense. This download treatment may vary with the broker; there may
> be some where you only download the $8.50, but that is not the
> common way in my opinion.
> > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, Pablot wrote:
> > > > > > I download transactions from my broker into my Money Plus, in case of
> > > > dividends appears a cash transaction of the tax payment, but this transaction
> > > > is not associated with the dividend transaction. Is there any chance to
> > > > download this cash transaction as an investment transaction?
> > > > > It is a function of your broker.
> > > > > It is not clear what you mean that the cash transaction "is not
> > > associated with the dividend transaction." That would almost imply
> > > that there was a dividend properly downloaded, and a separate cash
> > > transaction, possibly "withheld tax" on a foreign stock. In that
> > > case, a cash transaction may be the correct handling anyway.
> > > > > > > > > >
  #2  
Old 10-30-2008, 12:51 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Tax

In microsoft.public.money, Pablot wrote:

- quote -

> What I want to mean is that if you go to the report "Performance by
> investment account", and if you look into the fields "realized gain/loss",
> and "return for the period", the withheld tax DOES NOT APPEAR there. For me,
> if you want to know the real performance of a stock you have to consider the
> dividend (this is well done by Money Plus) AND the tax withheld (this field
> is not linked with the dividend transaction).


You get $10 in dividends from a foreign stock. $1.50 is withheld, so
you get a net $8.50 in cash.

You enter, or download, a $10 Dividend, and a $1.50 cash expense,
that you will assign to a category for the withheld tax.

The performance reports show $10.

When you get your US 1099, there is a corresponding $10 dividend
listed there, and a $1.50 of foreign tax. You include the $10
amount in your gross income. The $1.50 may be credited 100% to you
along with wage withholding etc. Alternatively goes on form 1116 if
your foreign tax dividend withholding reaches a $300 or $600 total
threshhold, from which at least part makes it back as a credit.

So the method used in Money matches the US tax treatment. Now if
this is a tax-deferred account, the foreign tax is lost to you.
Entering a $8.50 dividend would make sense in analysis, but the
reality is that you are probably going to download a $10 dividend
from your broker, even in a tax-deferred account and the separate
expense. This download treatment may vary with the broker; there may
be some where you only download the $8.50, but that is not the
common way in my opinion.



- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Pablot wrote:
> > > > I download transactions from my broker into my Money Plus, in case of
> > > dividends appears a cash transaction of the tax payment, but this transaction
> > > is not associated with the dividend transaction. Is there any chance to
> > > download this cash transaction as an investment transaction?
> > > It is a function of your broker.
> > > It is not clear what you mean that the cash transaction "is not

> > associated with the dividend transaction." That would almost imply
> > that there was a dividend properly downloaded, and a separate cash
> > transaction, possibly "withheld tax" on a foreign stock. In that
> > case, a cash transaction may be the correct handling anyway.
> > > > >
  #1  
Old 10-30-2008, 10:43 AM
Pablot
Guest
 
Posts: n/a
Default Re: Dividend Tax

What I want to mean is that if you go to the report "Performance by
investment account", and if you look into the fields "realized gain/loss",
and "return for the period", the withheld tax DOES NOT APPEAR there. For me,
if you want to know the real performance of a stock you have to consider the
dividend (this is well done by Money Plus) AND the tax withheld (this field
is not linked with the dividend transaction).

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Pablot wrote:
> > I download transactions from my broker into my Money Plus, in case of
> > dividends appears a cash transaction of the tax payment, but this transaction
> > is not associated with the dividend transaction. Is there any chance to
> > download this cash transaction as an investment transaction?

> It is a function of your broker.
> It is not clear what you mean that the cash transaction "is not
> associated with the dividend transaction." That would almost imply
> that there was a dividend properly downloaded, and a separate cash
> transaction, possibly "withheld tax" on a foreign stock. In that
> case, a cash transaction may be the correct handling anyway.

 
Old 10-29-2008, 10:59 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Tax

In microsoft.public.money, Pablot wrote:

- quote -

> I download transactions from my broker into my Money Plus, in case of
> dividends appears a cash transaction of the tax payment, but this transaction
> is not associated with the dividend transaction. Is there any chance to
> download this cash transaction as an investment transaction?


It is a function of your broker.

It is not clear what you mean that the cash transaction "is not
associated with the dividend transaction." That would almost imply
that there was a dividend properly downloaded, and a separate cash
transaction, possibly "withheld tax" on a foreign stock. In that
case, a cash transaction may be the correct handling anyway.




  #-1  
Old 10-29-2008, 10:35 PM
Pablot
Guest
 
Posts: n/a
Default Dividend Tax

I download transactions from my broker into my Money Plus, in case of
dividends appears a cash transaction of the tax payment, but this transaction
is not associated with the dividend transaction. Is there any chance to
download this cash transaction as an investment transaction?
 

Tags
dividend, tax
Similar Threads
Thread Forum Replies Last Post
Bad dividend data
banjolicious@netscape.net: I noticed today that MSMoney (2005 premium) has a dividend of $296.45 scheduled for 1/7/07 on my 12 shares of WLT. That would be fine with me of...
Microsoft Money 1 01-03-2007 02:00 PM
Dividend Income
John Lehman: When I enter dividends as transactions in my investment accounts, they show up in Category Transfer From in my Cash account (for example Transfer...
Microsoft Money 3 02-13-2005 07:48 PM
Dividend Reinvestment
jplasater@NOSPAMjuno.com: Is there some way to have Delux Portfolio automatical detect dividends to mutual funds and reinvest them in new shares. My portfolio is mutuals...
Microsoft Money 6 06-24-2004 11:52 PM
dividend transfers
Pete: I have Money 2002 deluxe. I just put all of my investments on Money in Nov. I received my statement today and am trying to balance it. Several...
Microsoft Money 1 01-09-2004 10:54 PM
reinvest dividend
alan: please help i have money 2001 running on xp pro and when i enter a reinvested dividend it does not add up properly and gives a large figure...
Microsoft Money 1 07-20-2003 09:27 AM



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 04:11 AM.