Home Page link  

Reinvesting dividends and gains

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Reinvesting dividends and gains Gary 09-28-2008
Posted by Gary on September 28, 2008, 8:29 am
Please log in for more thread options


An annoyance with Quicken comes from downloading transactions involving
reinvestment. As an example, I frequently will have two or three
transactions that look like

Previous cash balance is $0.00
09/20/08        Buy                10 shrs VABD @ 50.00 = $500.00        which produces a -$500.00
cash balance
09/20/08        Div                 $300.00
        producing a -$200.00 cash balance
09/20/08        LTCapGn        $200.00
        producing a $0.00 cash balance

I would rather have one of two things:

(1) Order the three transactions as Div, LTCG, Buy and avoid the
annoying negative cash balance, or even better

(2)

09/20/08        ReinvDiv        6 shrs VABD @ 50.00
09/20/08        ReinvLT                4 shrs VABD @ 50.00

How can I accomplish either of these two methods with a minimum of
effort (after initial setup)?


Posted by Han on September 28, 2008, 9:05 am
Please log in for more thread options



> An annoyance with Quicken comes from downloading transactions
> involving reinvestment. As an example, I frequently will have two or
> three transactions that look like
>
> Previous cash balance is $0.00
> 09/20/08 Buy 10 shrs VABD @ 50.00 = $500.00 which
> produces a -$500.00 cash balance
> 09/20/08 Div $300.00
> producing a -$200.00 cash balance
> 09/20/08 LTCapGn $200.00
> producing a $0.00 cash balance

The sequence here is wrong (IMNSHO).
You don't buy before you "sell" or get dividends/cap gains.
You first get the payout, then reinvest, lke you indicate under (1). If
the download puts these things in this order, contact your broker to
correct it (he may have other things on his mind right now, so don't hold
your breath).
Is it possible that you have your register ordered in a way other than by
date?

> I would rather have one of two things:
>
> (1) Order the three transactions as Div, LTCG, Buy and avoid the
> annoying negative cash balance, or even better
>
> (2)
>
> 09/20/08 ReinvDiv 6 shrs VABD @ 50.00
> 09/20/08 ReinvLT 4 shrs VABD @ 50.00
>
> How can I accomplish either of these two methods with a minimum of
> effort (after initial setup)?

I think method (2) disappeared several years ago. At least, I seem to
remember it worked that way at one time, but in reality, the dividends
are paid out, and the proceeds used to buy new stock. Quicken should
follow reality <grin>.

--
Best regards
Han
email address is invalid

Posted by John Pollard on September 28, 2008, 9:45 am
Please log in for more thread options


Han wrote:
>
>> An annoyance with Quicken comes from downloading transactions
>> involving reinvestment. As an example, I frequently will
>> have two or
>> three transactions that look like
>>
>> Previous cash balance is $0.00
>> 09/20/08 Buy 10 shrs VABD @ 50.00 = $500.00
>> which
>> produces a -$500.00 cash balance
>> 09/20/08 Div $300.00
>> producing a -$200.00 cash balance
>> 09/20/08 LTCapGn $200.00
>> producing a $0.00 cash balance
>
> The sequence here is wrong (IMNSHO).
> You don't buy before you "sell" or get dividends/cap gains.
> You first get the payout, then reinvest, lke you indicate
> under (1).
> If the download puts these things in this order, contact your
> broker
> to correct it (he may have other things on his mind right now,
> so
> don't hold your breath).
> Is it possible that you have your register ordered in a way
> other
> than by date?
>
>> I would rather have one of two things:
>>
>> (1) Order the three transactions as Div, LTCG, Buy and avoid
>> the
>> annoying negative cash balance, or even better
>>
>> (2)
>>
>> 09/20/08 ReinvDiv 6 shrs VABD @ 50.00
>> 09/20/08 ReinvLT 4 shrs VABD @ 50.00
>>
>> How can I accomplish either of these two methods with a
>> minimum of
>> effort (after initial setup)?
>
> I think method (2) disappeared several years ago. At least, I
> seem to
> remember it worked that way at one time, but in reality, the
> dividends
> are paid out, and the proceeds used to buy new stock. Quicken
> should
> follow reality <grin>.

Quicken just takes what the financial institution gives.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by Han on September 28, 2008, 9:50 am
Please log in for more thread options


@attbi_s22:

> Quicken just takes what the financial institution gives.

I know, John, but is it correct in this case? If not, even if the outcome
remains the same (I think the OP is making a mountain out of a mole hill,
but so what?), is there a way to fix this?

--
Best regards
Han
email address is invalid

Posted by John Pollard on September 28, 2008, 10:03 am
Please log in for more thread options


Han wrote:
>
>> Quicken just takes what the financial institution gives.

> I know, John, but is it correct in this case? If not, even if
> the
> outcome remains the same

> (I think the OP is making a mountain out of
> a mole hill, but so what?),

I agree, I've never cared about the order of transactions for a
given date.

> is there a way to fix this?

You can delete the Buy, then re-enter it. That should cause it
to follow the dividend in the "Transactions" list (at least in
newer versions of Q).

But I do it differently: I never accept the Dividend
transaction; and I modify the Buy transaction to be a Reinvest
transaction. I only see these type transactions from Brokerage
accounts, not from Mutual Fund accounts.

[There are some occasions (stocks) where the Dividend occurs
several days before the Buy; those I accept as downloaded.]

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Similar ThreadsPosted
Unrealized Gains January 20, 2008, 3:43 pm
dividends? April 19, 2007, 5:54 pm
Help! - Q2007 Cap Gains is Incomplete January 6, 2007, 10:23 pm
how to edit capital gains March 4, 2007, 4:02 pm
Capital gains alternatives March 31, 2007, 6:24 am
Capital Gains Distribution in an ETF April 9, 2007, 9:45 pm
Weird Capital Gains Report December 20, 2007, 6:13 pm
Return of Capital, on dividends August 10, 2006, 9:41 pm
Q2007 for Mac - does it have Qualified Dividends now? November 8, 2006, 8:32 am
Dividends that are invested in a different account December 14, 2006, 11:48 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap