Home Page link  

Reconciling Brokerage 1099-B - is there such a thing as close enough?

 

Taxes General Forum - Tax professionals meeting place and answers to queries. (Moderated)

 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
Reconciling Brokerage 1099-B - is there such a thing as close enough? GSalisbury 04-01-2008
Posted by Mark Bole on April 1, 2008, 10:03 pm
Please log in for more thread options
GSalisbury wrote:
> Received a 1099-B from Broker.
> Have been able to reconcile it to within $129.
> Is that close enough?
[...]
> Is that within some tolerance or do we have to go on a search and destroy
> mission?

The thread has gone off on a discussion of rounding errors and what the
IRS considers de minimis on a 1099-B.

I would track back and ask, what is the "it" that you are able to
reconcile within $129? The gross proceeds reported on 1099-B? The net
proceeds reported on 1099-B? The Quicken TXF file? (not an official IRS
reporting document, by the way). Are commissions and transaction costs
being properly accounted for?

It is rare that you can't match the sales price number reported on
1099-B, although I have seen one case from a major brokerage (with
assistance from a colleague) where a single transaction was reported in
the brokerage detail both as a short term with zero gain/loss and a long
term with the actual gain/loss. It wasn't until the double entry was
eliminated that the numbers matched up.

-Mark Bole

--
<< ------------------------------------------------------- >>
<< The foregoing was not intended or written to be used, >>
<< nor can it used, for the purpose of avoiding penalties >>
<< that may be imposed upon the taxpayer. >>
<< >>
<< The Charter and the Guidelines for submitting posts >>
<< to this newsgroup as well as our anti-spamming policy >>
<< are at www.asktax.org. >>
<< Copyright (2007) - All rights reserved. >>
<< ------------------------------------------------------- >>

Posted by GSalisbury on April 2, 2008, 9:23 am
Please log in for more thread options

> GSalisbury wrote:
>> Received a 1099-B from Broker.
>> Have been able to reconcile it to within $129.
>> Is that close enough?
> [...]
>> Is that within some tolerance or do we have to go on a search and destroy
>> mission?
>
> The thread has gone off on a discussion of rounding errors and what the
> IRS considers de minimis on a 1099-B.
>
> I would track back and ask, what is the "it" that you are able to
> reconcile within $129? The gross proceeds reported on 1099-B? The net
> proceeds reported on 1099-B? The Quicken TXF file? (not an official IRS
> reporting document, by the way). Are commissions and transaction costs
> being properly accounted for?
>
[snip]
>
> -Mark Bole

The "it" reconciled so far was the gross on the 1099 to the "gross" reported
and extracted from Qkn.
I haven't yet matched the detail of the 1099 to the detail from Qkn.
That's what I looking to duck - there's enough of them that my eyes are
glassy before starting.
The Qkn numbers agree within the Tax Summary and Capital Gains Reports and
the TXF import into TaxCut agrees with them - they all better sync up
otherwise I don't even want to think about it.
I suspect that we lost some d/l'ing sometime during the year.
We connect to d/l nearly every day.
There had to be issues connecting etc. at least once - there always is - so
maybe a line got lost.
Geo.

--
<< ------------------------------------------------------- >>
<< The foregoing was not intended or written to be used, >>
<< nor can it used, for the purpose of avoiding penalties >>
<< that may be imposed upon the taxpayer. >>
<< >>
<< The Charter and the Guidelines for submitting posts >>
<< to this newsgroup as well as our anti-spamming policy >>
<< are at www.asktax.org. >>
<< Copyright (2007) - All rights reserved. >>
<< ------------------------------------------------------- >>

Similar ThreadsPosted
FIFO with two brokerage accts. July 12, 2007, 7:34 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