Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #13  
Old 07-31-2005, 09:38 PM
harrelsonesq
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

No-load funds & don't use Money to calculate cost basis, so a couple of
these considerations don't apply. However, I think I'll change the way I
enter these transactions, in the interest of ease and accuracy.

Thanks, guys.

Susan

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:ftppe11kank3vqe7q5q6aad5e90a8tlr9k[at]4ax.com...
- quote -

> In microsoft.public.money, Chris Cowles wrote:
> > Entering the quantity first, then the total (gross proceeds, not net) and
> > commission, I never have a problem. Money accurately reduces the total by
> > the amount of the commission without revising the quantity or price.
> > Money's
> > calculated price may differ from the broker by cents, but holdings and tax
> > reports are accurate as a result.

> I like Commission, Total, Quantity or Total, Commission, Quantity
> some such if I remember. I usually end up rubbing something out
> because Money assumes $0 commission if you have not entered it yet.
> If I am buying or selling a stock, then the order does not really
> matter. The amounts are computed from the transaction, and I am
> working in whole shares.
> With a mutual fund, you don't usually buy a whole number of shares.
> You buy some specified value of shares, and they compute how many
> shares they will give you for that amount of money.
> > > You could debate the wisdom of labeling that field 'total' (ie, it's

> > really
> > not total if you count the commission, rather, it's a net value), but the
> > numbers are correct.

> "Total" seems fine to me to indicate a result computed with signed
> arithmetic. I might still call the bottom number of a grocery
> receipt a total, even tho there might be a credit mixed into the
> expenses.
> In OFX, the numbers for a transaction are tagged
> <UNITS> <UNITPRICE> <COMMISSION> <TOTAL> > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> > news:1v4me1tbikdshtktd9ffi84gucoc1dfosr[at]4ax.com...
> > > > > The most important is the Quantity. The second most important is the
> > > Total. Let Money compute the price.
> > > > > Throw in the commission, and entering the data is trickier.

>


  #12  
Old 07-31-2005, 03:16 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

In microsoft.public.money, Chris Cowles wrote:

- quote -

> Entering the quantity first, then the total (gross proceeds, not net) and
> commission, I never have a problem. Money accurately reduces the total by
> the amount of the commission without revising the quantity or price. Money's
> calculated price may differ from the broker by cents, but holdings and tax
> reports are accurate as a result.


I like Commission, Total, Quantity or Total, Commission, Quantity
some such if I remember. I usually end up rubbing something out
because Money assumes $0 commission if you have not entered it yet.

If I am buying or selling a stock, then the order does not really
matter. The amounts are computed from the transaction, and I am
working in whole shares.

With a mutual fund, you don't usually buy a whole number of shares.
You buy some specified value of shares, and they compute how many
shares they will give you for that amount of money.

- quote -

> You could debate the wisdom of labeling that field 'total' (ie, it's really
> not total if you count the commission, rather, it's a net value), but the
> numbers are correct.


"Total" seems fine to me to indicate a result computed with signed
arithmetic. I might still call the bottom number of a grocery
receipt a total, even tho there might be a credit mixed into the
expenses.

In OFX, the numbers for a transaction are tagged
<UNITS<UNITPRICE<COMMISSION<TOTAL



- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:1v4me1tbikdshtktd9ffi84gucoc1dfosr[at]4ax.com...
> > > The most important is the Quantity. The second most important is the

> > Total. Let Money compute the price.
> > > Throw in the commission, and entering the data is trickier.


  #11  
Old 07-31-2005, 02:13 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

Entering the quantity first, then the total (gross proceeds, not net) and
commission, I never have a problem. Money accurately reduces the total by
the amount of the commission without revising the quantity or price. Money's
calculated price may differ from the broker by cents, but holdings and tax
reports are accurate as a result.

You could debate the wisdom of labeling that field 'total' (ie, it's really
not total if you count the commission, rather, it's a net value), but the
numbers are correct.

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:1v4me1tbikdshtktd9ffi84gucoc1dfosr[at]4ax.com...
- quote -

> The most important is the Quantity. The second most important is the
> Total. Let Money compute the price.
> Throw in the commission, and entering the data is trickier.



  #10  
Old 07-31-2005, 02:05 PM
Michael Gordon, MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

The total becomes the cost basis for the transaction; given that the IRS
rounds up or down [at] 50¢, it could affect the basis by $1.00.

--
Michael Gordon
MVP


"harrelsonesq" <harrelsonesq2[at]yahoo.com> wrote in message
news:%23jrHwyWlFHA.3300[at]TK2MSFTNGP15.phx.gbl...
- quote -

> I have always entered quantity and price, and let Money calculate the
> total. It is occasionally off by a penny of two, which I assume is due to
> rounding, but not enough to matter, given normal price volatility (it'll be
> different tomorrow!). Is there anything in that method that might have
> unintended consequences?
> Susan
> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:1v4me1tbikdshtktd9ffi84gucoc1dfosr[at]4ax.com...
> > In microsoft.public.money, harrelsonesq wrote:
> > > > I thought you could enter any two of the three, and Money would calculate
> > > the third.
> > > Suppose you paid $100 for 33 shares. Enter $100 for the total and 33

> > for the Quantity. The actual price for the shares is
> > 3.030303030303030303030303030303, which would be represented with
> > fewer decimals.
> > > If you entered the price as 3.0303 , Money would calculate you have

> > 33.000033 shares. If you later sold your 33 shares, Money would
> > think you still have 0.000033 shares.
> > > The most important is the Quantity. The second most important is the

> > Total. Let Money compute the price.
> > > Throw in the commission, and entering the data is trickier.
> > > > > > > > > Susan
> > > > > "Chris Cowles" <NoSpam[at]For.me> wrote in message
> > > news:ujzdXbJlFHA.708[at]TK2MSFTNGP09.phx.gbl...
> > > > Is it not slightly incorrect, in that the OP should have a *quantity*
> > > > and
> > > > a total amount?
> > > > > > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> > > > news:75cle1lar2uprcter6j80tlhm4nl1u4moc[at]4ax.com...
> > > > > In microsoft.public.money, unique display name wrote:
> > > > > > > > > > So to be clear, even though i never see the actual income (because it
> > > > > > is
> > > > > > reinvested) I should absolutely have a price and total amount so that
> > > > > > the
> > > > > > ROI
> > > > > > numbers are accurate?
> > > > > > > > > > > I should NOT be entering zeroes under price and total?
> > > > > > > > > > > > > Correct.
> > > > > > > > >


  #9  
Old 07-31-2005, 05:00 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

In microsoft.public.money, harrelsonesq wrote:

- quote -

> I have always entered quantity and price, and let Money calculate the total.
> It is occasionally off by a penny of two, which I assume is due to rounding,
> but not enough to matter, given normal price volatility (it'll be different
> tomorrow!). Is there anything in that method that might have unintended
> consequences?


If you let it compute the Total, you can make an adjusting entry for
the pennies. No big deal. Just don't let it compute the Quantity.

Enter Quantity and Total, and it will not be off a penny, however.

  #8  
Old 07-31-2005, 01:20 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

If there's a cash account involved--granted this isn't the case for dividend
reinvestment--it may not balance. For this reason, I do it the same way
every time, including dividend reinvestments.

"harrelsonesq" <harrelsonesq2[at]yahoo.com> wrote in message
news:%23jrHwyWlFHA.3300[at]TK2MSFTNGP15.phx.gbl...
- quote -

> I have always entered quantity and price, and let Money calculate the
> total. It is occasionally off by a penny of two, which I assume is due to
> rounding, but not enough to matter, given normal price volatility (it'll be
> different tomorrow!). Is there anything in that method that might have
> unintended consequences?



  #7  
Old 07-31-2005, 01:12 AM
harrelsonesq
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

I have always entered quantity and price, and let Money calculate the total.
It is occasionally off by a penny of two, which I assume is due to rounding,
but not enough to matter, given normal price volatility (it'll be different
tomorrow!). Is there anything in that method that might have unintended
consequences?

Susan

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:1v4me1tbikdshtktd9ffi84gucoc1dfosr[at]4ax.com...
- quote -

> In microsoft.public.money, harrelsonesq wrote:
> > I thought you could enter any two of the three, and Money would calculate
> > the third.

> Suppose you paid $100 for 33 shares. Enter $100 for the total and 33
> for the Quantity. The actual price for the shares is
> 3.030303030303030303030303030303, which would be represented with
> fewer decimals.
> If you entered the price as 3.0303 , Money would calculate you have
> 33.000033 shares. If you later sold your 33 shares, Money would
> think you still have 0.000033 shares.
> The most important is the Quantity. The second most important is the
> Total. Let Money compute the price.
> Throw in the commission, and entering the data is trickier.
> > > Susan
> > > "Chris Cowles" <NoSpam[at]For.me> wrote in message

> > news:ujzdXbJlFHA.708[at]TK2MSFTNGP09.phx.gbl...
> > > Is it not slightly incorrect, in that the OP should have a *quantity*
> > > and
> > > a total amount?
> > > > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> > > news:75cle1lar2uprcter6j80tlhm4nl1u4moc[at]4ax.com...
> > > > In microsoft.public.money, unique display name wrote:
> > > > > > > > So to be clear, even though i never see the actual income (because it
> > > > > is
> > > > > reinvested) I should absolutely have a price and total amount so that
> > > > > the
> > > > > ROI
> > > > > numbers are accurate?
> > > > > > > > > I should NOT be entering zeroes under price and total?
> > > > > > > > > > Correct.
> > > > >


  #6  
Old 07-30-2005, 04:51 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

In microsoft.public.money, harrelsonesq wrote:

- quote -

> I thought you could enter any two of the three, and Money would calculate
> the third.


Suppose you paid $100 for 33 shares. Enter $100 for the total and 33
for the Quantity. The actual price for the shares is
3.030303030303030303030303030303, which would be represented with
fewer decimals.

If you entered the price as 3.0303 , Money would calculate you have
33.000033 shares. If you later sold your 33 shares, Money would
think you still have 0.000033 shares.

The most important is the Quantity. The second most important is the
Total. Let Money compute the price.

Throw in the commission, and entering the data is trickier.




- quote -

> Susan
> "Chris Cowles" <NoSpam[at]For.me> wrote in message
> news:ujzdXbJlFHA.708[at]TK2MSFTNGP09.phx.gbl...
> > Is it not slightly incorrect, in that the OP should have a *quantity* and
> > a total amount?
> > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message

> > news:75cle1lar2uprcter6j80tlhm4nl1u4moc[at]4ax.com...
> > > In microsoft.public.money, unique display name wrote:
> > > > > > So to be clear, even though i never see the actual income (because it is
> > > > reinvested) I should absolutely have a price and total amount so that the
> > > > ROI
> > > > numbers are accurate?
> > > > > > > I should NOT be entering zeroes under price and total?
> > > > > > > Correct.

> >

  #5  
Old 07-30-2005, 05:40 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

In microsoft.public.money, Chris Cowles wrote:

- quote -

> Is it not slightly incorrect, in that the OP should have a *quantity* and a
> total amount?


It is correct that the person should not be entering zeroes under
price and total.

It would also be correct to say that the person should not be
entering zeros under Quantity and Total.

The person should enter the actual Quantity and Total. Let Money
compute Price.

- quote -

> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:75cle1lar2uprcter6j80tlhm4nl1u4moc[at]4ax.com...
> > In microsoft.public.money, unique display name wrote:
> > > > So to be clear, even though i never see the actual income (because it is
> > > reinvested) I should absolutely have a price and total amount so that the
> > > ROI
> > > numbers are accurate?
> > > > > I should NOT be entering zeroes under price and total?
> > > > Correct.


  #4  
Old 07-30-2005, 02:42 AM
harrelsonesq
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

I thought you could enter any two of the three, and Money would calculate
the third.

Susan

"Chris Cowles" <NoSpam[at]For.me> wrote in message
news:ujzdXbJlFHA.708[at]TK2MSFTNGP09.phx.gbl...
- quote -

> Is it not slightly incorrect, in that the OP should have a *quantity* and
> a total amount?
> "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
> news:75cle1lar2uprcter6j80tlhm4nl1u4moc[at]4ax.com...
> > In microsoft.public.money, unique display name wrote:
> > > > So to be clear, even though i never see the actual income (because it is
> > > reinvested) I should absolutely have a price and total amount so that the
> > > ROI
> > > numbers are accurate?
> > > > > I should NOT be entering zeroes under price and total?
> > > > Correct.



  #3  
Old 07-29-2005, 11:39 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

Is it not slightly incorrect, in that the OP should have a *quantity* and a
total amount?

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:75cle1lar2uprcter6j80tlhm4nl1u4moc[at]4ax.com...
- quote -

> In microsoft.public.money, unique display name wrote:
> > So to be clear, even though i never see the actual income (because it is
> > reinvested) I should absolutely have a price and total amount so that the
> > ROI
> > numbers are accurate?
> > > I should NOT be entering zeroes under price and total?

> Correct.



  #2  
Old 07-29-2005, 10:42 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

In microsoft.public.money, unique display name wrote:

- quote -

> So to be clear, even though i never see the actual income (because it is
> reinvested) I should absolutely have a price and total amount so that the ROI
> numbers are accurate?
> I should NOT be entering zeroes under price and total?



Correct.

If this is in a taxable account, you will pay tax on those
dividends. It is important that Money knows you did not pay $0 for
those shares, because it is Money's job to compute the capital gains
amounts for your tax use.

If it is in a tax-free or tax-deferred account, it only matters for
purposes of tracking your performance. So in those cases it is
optional.



- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, "unique display name" <unique display
> > name[at]discussions.microsoft.com> wrote:
> > > > I receive multiple dividend reinvestment statements. Over the years, i have
> > > recorded each of these statements into my portfolio by ONLY entering the
> > > stock amount, and putting zeroes in for stock price and total amount.
> > > Thereby avoiding having an income associated with the transaction.
> > > > > I have a feeling, though, that all along I should have been entering a price
> > > and (therefore automatically) a total amount. I have a feeling that my
> > > method is giving me bad data on cost basis, return, etc.
> > > > > How EXACTLY should i enter these dividends that are automatically reinvested?
> > > There are two equally proper ways: one way is enter a Dividend

> > transaction and a separate Buy transactions for the same Total.
> > > The easier way is to enter a ReinvestDividend transaction. If you

> > scroll down the drop-down list, you can also find some ReinvestCG
> > variations that might apply for capital gains distributions.
> > > In any case, it is always a good idea to enter the Quantity and

> > Total. Let Money compute Price. The reason is, that you know
> > Quantity and Total. The [per-share] Price can be a rounded amount.
> > > > > >

  #1  
Old 07-29-2005, 10:11 PM
unique display name
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

So to be clear, even though i never see the actual income (because it is
reinvested) I should absolutely have a price and total amount so that the ROI
numbers are accurate?

I should NOT be entering zeroes under price and total?

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, "unique display name" <unique display
> name[at]discussions.microsoft.com> wrote:
> > I receive multiple dividend reinvestment statements. Over the years, i have
> > recorded each of these statements into my portfolio by ONLY entering the
> > stock amount, and putting zeroes in for stock price and total amount.
> > Thereby avoiding having an income associated with the transaction.
> > > I have a feeling, though, that all along I should have been entering a price

> > and (therefore automatically) a total amount. I have a feeling that my
> > method is giving me bad data on cost basis, return, etc.
> > > How EXACTLY should i enter these dividends that are automatically reinvested?

> There are two equally proper ways: one way is enter a Dividend
> transaction and a separate Buy transactions for the same Total.
> The easier way is to enter a ReinvestDividend transaction. If you
> scroll down the drop-down list, you can also find some ReinvestCG
> variations that might apply for capital gains distributions.
> In any case, it is always a good idea to enter the Quantity and
> Total. Let Money compute Price. The reason is, that you know
> Quantity and Total. The [per-share] Price can be a rounded amount.

 
Old 07-29-2005, 09:59 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Dividend Reinvestment - Am I recording this correctly?

In microsoft.public.money, "unique display name" <unique display
name[at]discussions.microsoft.com> wrote:

- quote -

> I receive multiple dividend reinvestment statements. Over the years, i have
> recorded each of these statements into my portfolio by ONLY entering the
> stock amount, and putting zeroes in for stock price and total amount.
> Thereby avoiding having an income associated with the transaction.
> I have a feeling, though, that all along I should have been entering a price
> and (therefore automatically) a total amount. I have a feeling that my
> method is giving me bad data on cost basis, return, etc.
> How EXACTLY should i enter these dividends that are automatically reinvested?


There are two equally proper ways: one way is enter a Dividend
transaction and a separate Buy transactions for the same Total.

The easier way is to enter a ReinvestDividend transaction. If you
scroll down the drop-down list, you can also find some ReinvestCG
variations that might apply for capital gains distributions.

In any case, it is always a good idea to enter the Quantity and
Total. Let Money compute Price. The reason is, that you know
Quantity and Total. The [per-share] Price can be a rounded amount.





  #-1  
Old 07-29-2005, 09:33 PM
unique display name
Guest
 
Posts: n/a
Default Dividend Reinvestment - Am I recording this correctly?

I receive multiple dividend reinvestment statements. Over the years, i have
recorded each of these statements into my portfolio by ONLY entering the
stock amount, and putting zeroes in for stock price and total amount.
Thereby avoiding having an income associated with the transaction.

I have a feeling, though, that all along I should have been entering a price
and (therefore automatically) a total amount. I have a feeling that my
method is giving me bad data on cost basis, return, etc.

How EXACTLY should i enter these dividends that are automatically reinvested?
 

Tags
correctly, dividend, recording, reinvestment
Similar Threads
Thread Forum Replies Last Post
Dividend and Interest Reinvestment
glenwcan: I have stocks that I manually enter the dividends for each month. I also have bonds that I manually enter the interest payments for each month. ...
Microsoft Money 1 05-11-2005 03:06 AM
How to enter reinvestment of dividends
DL: I have been entering as 1) dividend then 2) buy However, in my income vs spending report, this is showing up as investment income. Is this...
Microsoft Money 4 10-13-2004 03:18 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
Recording dividend transactions
: When you record a dividend, then a reinvestment of that dividend, it removes the amount from the (cash) account that corresponds to that account. ...
Microsoft Money 3 01-11-2004 04:53 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 09:59 AM.