Home Page link  

how to make "adjusting entry" in investment registers

 

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
how to make "adjusting entry" in investment registers jo 01-13-2008
Posted by jo on January 13, 2008, 1:30 pm
Please log in for more thread options
I'd like my Quicken (H&B 2006) records to match my brokerage
statements as much as possible (just humor me, ok?). When I sold a
security at the end of Dec 2007 I detected a discrepancy between the
cost basis in Quicken and the one indicated by my brokerage. I've
figured out that it happened at the end of 2006 when some dividends
were reclassified for tax purposes as ROP. Apparently there was no
transaction created at the brokerage, or at least not a downloaded
one, that accounted for that. By Jan of 06, my brokerage statement
reflects the new cost basis, and I'd like to make some kind of entry
back on Dec, 31, 2006, for instance, that would effect this change in
Quicken. Just can't figure out how to do it. Any ideas?

jo

Posted by vcardx on January 13, 2008, 7:51 pm
Please log in for more thread options
Change the dividend transaction to "Return of Capital" transaction. (You
may also want to check how you reported it for tax purposes - if as
dividend income, depending on materiality you may want to see about
adjusting your 2006 return, because you've already paid tax on it.)

vcardx

: I'd like my Quicken (H&B 2006) records to match my brokerage
: statements as much as possible (just humor me, ok?). When I sold a
: security at the end of Dec 2007 I detected a discrepancy between the
: cost basis in Quicken and the one indicated by my brokerage. I've
: figured out that it happened at the end of 2006 when some dividends
: were reclassified for tax purposes as ROP. Apparently there was no
: transaction created at the brokerage, or at least not a downloaded
: one, that accounted for that. By Jan of 06, my brokerage statement
: reflects the new cost basis, and I'd like to make some kind of entry
: back on Dec, 31, 2006, for instance, that would effect this change in
: Quicken. Just can't figure out how to do it. Any ideas?
:
: jo




--
Posted via a free Usenet account from http://www.teranews.com


Posted by jo on January 14, 2008, 12:16 pm
Please log in for more thread options
> Change the dividend transaction to "Return of Capital" transaction. =A0(Yo=
u
> may also want to check how you reported it =A0for tax purposes - if as
> dividend income, depending on materiality you may want to see about
> adjusting your 2006 return, because you've already paid tax on it.)
>
> vcardx
>

The Return of Capital amount doesn't match a single dividend payment.
I was hoping there was a way to do this which would reflect a year end
recategorization event, rather than going in and fudging individual
dividends to match the amount.

I did check the 2006 return and the amount was listed under
"nondividend distributions", as it was on my 1099, so I reported it
correctly. I'm confused why it wasn't in the list of return of
principle on any statement I can find. Guess if I really want to know
the nitty gritty, I'll have to bug my broker.

Thanks,

jo


>
> : I'd like my Quicken (H&B 2006) records to match my brokerage
> : statements as much as possible (just humor me, ok?). =A0 When I sold a
> : security at the end of Dec 2007 I detected a discrepancy between the
> : cost basis in Quicken and the one indicated by my brokerage. =A0I've
> : figured out that it happened at the end of 2006 when some dividends
> : were reclassified for tax purposes as ROP. Apparently there was no
> : transaction created at the brokerage, or at least not a downloaded
> : one, that accounted for that. By Jan of 06, my brokerage statement
> : reflects the new cost basis, and I'd like to make some kind of entry
> : back on Dec, 31, 2006, for instance, that would effect this change in
> : Quicken. =A0Just can't figure out how to do it. =A0Any ideas?
> :
> : jo
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com


Posted by R. C. White on January 14, 2008, 10:16 pm
Please log in for more thread options
Hi, Jo.

Without knowing any of the details of the corporation involved, I can't be
specific, of course. But many accounting determinations cannot be made
until the corporation's year-end. Estimates are recorded periodically
during the year and, sometimes, dividends are declared based on these
estimates. When the books are closed after the year-end, the final
calculations are made and it just might turn out that the profits were less
than the dividends that had been paid out. If the company paid out $1
million in dividends, but only $900,000 profits were realized, then where
did the other $100,000 come from? Must have been paid from borrowings or
from capital that had been previously paid in by stockholders, rather than
from earnings of the company. (In a regular corporation, the dividends
might have been paid from prior years' accumulated earnings, but mutual
funds are not supposed to have any earnings carried over from year to year;
they are supposed to pay out everything each year.)

At any rate, some of the dividends that have already been paid and reported
preliminarily as having come from profits, must have come from some source
other than profits, that is, a return of capital. So an adjustment must be
made, and it is very difficult, perhaps impossible, to assign it to any
specific monthly dividend during the year. It's just an adjustment to the
year's total dividends. Sometimes a determination is made that a prior
year's profit was miscalculated and amended reports are issued - and the
shareholders must file amended returns.

Since the shareholder is taxed only on the fund's profits, these additional
amounts are not currently taxable to him/her, but reduces his/her basis in
the shares held. When the shares are eventually sold, the gain will be
larger because of the reduced basis. If the return of capital is so large
that it exceeds the basis, then all such amounts received after the basis is
reduced to zero are taxable gains.

I hope this "generic" explanation helps a little. But remember: I've been
retired a long time. Check with your own CPA to be sure of the current
rulings and accounting treatments.

RC
--
R. C. White, CPA
San Marcos, TX
(Retired. No longer licensed to practice public accounting.)
rc@grandecom.net
Microsoft Windows MVP
(Currently running Quicken 2008 Deluxe in Vista Ultimate x64)

>> Change the dividend transaction to "Return of Capital" transaction. (You
>> may also want to check how you reported it for tax purposes - if as
>> dividend income, depending on materiality you may want to see about
>> adjusting your 2006 return, because you've already paid tax on it.)
>>
>> vcardx
>>
>
> The Return of Capital amount doesn't match a single dividend payment.
> I was hoping there was a way to do this which would reflect a year end
> recategorization event, rather than going in and fudging individual
> dividends to match the amount.
>
> I did check the 2006 return and the amount was listed under
> "nondividend distributions", as it was on my 1099, so I reported it
> correctly. I'm confused why it wasn't in the list of return of
> principle on any statement I can find. Guess if I really want to know
> the nitty gritty, I'll have to bug my broker.
>
> Thanks,
>
> jo
>
>
>>
>> : I'd like my Quicken (H&B 2006) records to match my brokerage
>> : statements as much as possible (just humor me, ok?). When I sold a
>> : security at the end of Dec 2007 I detected a discrepancy between the
>> : cost basis in Quicken and the one indicated by my brokerage. I've
>> : figured out that it happened at the end of 2006 when some dividends
>> : were reclassified for tax purposes as ROP. Apparently there was no
>> : transaction created at the brokerage, or at least not a downloaded
>> : one, that accounted for that. By Jan of 06, my brokerage statement
>> : reflects the new cost basis, and I'd like to make some kind of entry
>> : back on Dec, 31, 2006, for instance, that would effect this change in
>> : Quicken. Just can't figure out how to do it. Any ideas?
>> :
>> : jo


Posted by jo on January 16, 2008, 9:48 pm
Please log in for more thread options
Great explanation for how this happens. Still not sure if there is a
better way to get my Quicken files to match the cost basis other than
picking, say, the last n dividend payments that collectively match the
Return of Principal and changing their category. It's not as pretty
as I'd like but I can't think of any other "adjusting" entry to make
that would tie into the specific security's cost, can't you?

jo


> Hi, Jo.
>
> Without knowing any of the details of the corporation involved, I can't be=

> specific, of course. =A0But many accounting determinations cannot be made
> until the corporation's year-end. =A0Estimates are recorded periodically
> during the year and, sometimes, dividends are declared based on these
> estimates. =A0When the books are closed after the year-end, the final
> calculations are made and it just might turn out that the profits were les=
s
> than the dividends that had been paid out. =A0If the company paid out $1
> million in dividends, but only $900,000 profits were realized, then where
> did the other $100,000 come from? =A0Must have been paid from borrowings o=
r
> from capital that had been previously paid in by stockholders, rather than=

> from earnings of the company. =A0(In a regular corporation, the dividends
> might have been paid from prior years' accumulated earnings, but mutual
> funds are not supposed to have any earnings carried over from year to year=
;
> they are supposed to pay out everything each year.)
>
> At any rate, some of the dividends that have already been paid and reporte=
d
> preliminarily as having come from profits, must have come from some source=

> other than profits, that is, a return of capital. =A0So an adjustment must=
be
> made, and it is very difficult, perhaps impossible, to assign it to any
> specific monthly dividend during the year. =A0It's just an adjustment to t=
he
> year's total dividends. =A0Sometimes a determination is made that a prior
> year's profit was miscalculated and amended reports are issued - and the
> shareholders must file amended returns.
>
> Since the shareholder is taxed only on the fund's profits, these additiona=
l
> amounts are not currently taxable to him/her, but reduces his/her basis in=

> the shares held. =A0When the shares are eventually sold, the gain will be
> larger because of the reduced basis. =A0If the return of capital is so lar=
ge
> that it exceeds the basis, then all such amounts received after the basis =
is
> reduced to zero are taxable gains.
>
> I hope this "generic" explanation helps a little. =A0But remember: =A0I've=
been
> retired a long time. =A0Check with your own CPA to be sure of the current
> rulings and accounting treatments.
>
> RC
> --
> R. C. White, CPA
> San Marcos, TX
> (Retired. =A0No longer licensed to practice public accounting.)
> r...@grandecom.net
> Microsoft Windows MVP
> (Currently running Quicken 2008 Deluxe in Vista Ultimate x64)
>
>
>
>
.
> >> : I'd like my Quicken (H&B 2006) records to match my brokerage
> >> : statements as much as possible (just humor me, ok?). When I sold a
> >> : security at the end of Dec 2007 I detected a discrepancy between the
> >> : cost basis in Quicken and the one indicated by my brokerage. I've
> >> : figured out that it happened at the end of 2006 when some dividends
> >> : were reclassified for tax purposes as ROP. Apparently there was no
> >> : transaction created at the brokerage, or at least not a downloaded
> >> : one, that accounted for that. By Jan of 06, my brokerage statement
> >> : reflects the new cost basis, and I'd like to make some kind of entry
> >> : back on Dec, 31, 2006, for instance, that would effect this change in=

> >> : Quicken. Just can't figure out how to do it. Any ideas?
> >> :
> >> : jo- Hide quoted text -
>
> - Show quoted text -

Similar ThreadsPosted
Adjusting an Investment Account Balance April 25, 2008, 10:53 am
Investment entry problem April 16, 2007, 12:33 pm
Cannot accept downloaded transactions into Ameritrade-Cash account "You should make this change from the investment account" message July 8, 2006, 9:15 am
make money? April 13, 2006, 5:52 am
Have bank make payment September 4, 2007, 9:19 pm
MAKE EASY MONEY FAST!!!! August 24, 2007, 12:26 pm
Want to make money fast online ? September 9, 2007, 6:11 am
Re: Adjusting cost basis June 30, 2006, 7:55 pm
Re: Adjusting cost basis July 1, 2006, 1:31 pm
Q2005-Adjusting Paycheck August 20, 2006, 7:00 pm

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