|
#15
| |||
| |||
| "Gil Faver" <rowdy'sboss[at]xxyz.com> wrote in message news:mSzIj.118716$cQ1.27656[at]bgtnsc04-news.ops.worldnet.att.net... - quote - > you could just use the higher number on the 1099, and save yourself the
I tracked it down to a single line in Qkn that WAS dl'ed from the broker but> trouble. Of course, you won't. Neither would I. But we COULD . . . > -- was "mis-coded" in Qkn so it wasn't included in the Qkn Cap Gains TXF. Once I corrected the shares buy/sell history in Qkn the item was corrected to a Sell and everything matched - the Qkn Cap Gain agrees with the Broker 1099B. phew! Thx for all of the ideas. 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. > << ------------------------------------------------------- > |
|
#14
| |||
| |||
| "dpb" <none[at]non.net> wrote in message news:ft1q3l$81t$1[at]aioe.org... - quote - > But, being (the engineer) who suggested the pragmatic approach, that's
Time spent ensuring that my preferred brewery remained productive is more> getting to the point of effort that for $20 or less I'd probably think my > time more entertainingly spent elsewhere... ![]() I agree! worthy. -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#13
| |||
| |||
| GSalisbury wrote: - quote - > "DF2" <replyvia[at]newsgroup_please.com> wrote in message
Should be able to save the pdf to a file and then import that file into> > Can't you paste a Quicken [note tht I ws abl 2 dfr yr stct] report > > into a spreadsheet sorted by date to produce a running total, do the > > same with the schedule from your broker, and see where the totals > > diverge? > This is a good idea and I can see how it would make it easier to narrow the > focus. > Unfortunately, for me, the brokerage schedule is only in paper form on the > 1099 detail. Their site doesn't have a d/l of it other than an image PDF. ..... a spreadsheet as a text file I'd think... But, being (the engineer) who suggested the pragmatic approach, that's getting to the point of effort that for $20 or less I'd probably think my time more entertainingly spent elsewhere... ![]() -- -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#12
| |||
| |||
| In misc.taxes.moderated, GSalisbury wrote: - quote - > Their site doesn't have a d/l of it other than an image PDF.
You can often do a text copy from the PDF. Then paste into yourspreadsheet. If pasting into Excel, do the special paste as text. This may or may not be formatted well enough to work with. -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#11
| |||
| |||
| "DF2" <replyvia[at]newsgroup_please.com> wrote in message - quote - > Can't you paste a Quicken [note tht I ws abl 2 dfr yr stct] report
This is a good idea and I can see how it would make it easier to narrow the> into a spreadsheet sorted by date to produce a running total, do the > same with the schedule from your broker, and see where the totals > diverge? focus. Unfortunately, for me, the brokerage schedule is only in paper form on the 1099 detail. Their site doesn't have a d/l of it other than an image PDF. - quote - > Otherwise, consider adding an extra item schedule D labeled as "Cash
If I can't somehow spot the difference by eyeballing the two documents and> in lieu" with a Various acquisition date for the difference. There > is a fair chance that CIL was where the difference came from anyway. crossing off matches then I'll probably just go ahead and do the add something route - the tax difference too me would be in the noise. Thx -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#10
| |||
| |||
| In misc.taxes.moderated, GSalisbury wrote: - quote - > Although, as was noted concerning the minimal impact and also being
Can't you paste a Quicken [note tht I ws abl 2 dfr yr stct] report> pragmatic (I call it lazy), I would like to do nothing but I know I can't<g> I just hope matching a Qkn Report to the 1099 detail is all I have to do - > not travel thru twelve months of statements - that would be a pain. into a spreadsheet sorted by date to produce a running total, do the same with the schedule from your broker, and see where the totals diverge? Otherwise, consider adding an extra item schedule D labeled as "Cash in lieu" with a Various acquisition date for the difference. There is a fair chance that CIL was where the difference came from anyway. -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#9
| |||
| |||
| "Gil Faver" <rowdy'sboss[at]xxyz.com> wrote in message news:mSzIj.118716$cQ1.27656[at]bgtnsc04-news.ops.worldnet.att.net... - quote - > "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote in message
pragmatic (I call it lazy), I would like to do nothing but I know I can't<g> news:a7ydnf9HcKk9X2_anZ2dnUVZ_o6knZ2d[at]comcast.com... > > > "Paul Thomas, CPA" <paulthomascpapc[at]bellsouth.net> wrote in message > > news:bBtIj.25508$dT.21998[at]bignews1.bellsouth.net... > > > > > "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote > > > > Received a 1099-B from Broker. > > > > Have been able to reconcile it to within $129. > > > > Is that close enough? > > > > > > > > > > > That's a tad outside of just a rounding error. > > > > > > > > > > > > As far as we know now all of the brokerage lines have been d/l'ed into > > > > Qkn thruout the year. > > > > The Qkn TXF export sums to the $129 shortage. > > > > Is that within some tolerance or do we have to go on a search and > > > > destroy mission? > > > > > > > > > You need to figure it out. It's probably a grouping of fractional > > > shares on splits, spins, mergers, etc. > > > -- > > > Paul A. Thomas, CPA > > > Athens, Georgia > > > > Dang! > > I kinda expected that I'd have to chase after kind of the difference > > but... > > I was hoping maybe to get some sort of a free pass - you know "take a > > chance..." > > Oh Well. > > It's just a couple of hundred lines on both the 1099 and the Qkn Report - > > can knock that out in a couple of days<g> > Thx. > > Geo. > you could just use the higher number on the 1099, and save yourself the > trouble. Of course, you won't. Neither would I. But we COULD . . . Although, as was noted concerning the minimal impact and also being I just hope matching a Qkn Report to the 1099 detail is all I have to do - not travel thru twelve months of statements - that would be a pain. 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. > << ------------------------------------------------------- > |
|
#8
| |||
| |||
| "Mark Bole" <makbo[at]pacbell.net> wrote in message news PBIj.36810$J41.12951[at]newssvr14.news.prodigy.net...- quote - > GSalisbury wrote:
The "it" reconciled so far was the gross on the 1099 to the "gross" reported> > 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 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. > << ------------------------------------------------------- > |
|
#7
| |||
| |||
| GSalisbury wrote: - quote - > Received a 1099-B from Broker.
The thread has gone off on a discussion of rounding errors and what the> 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? 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. > << ------------------------------------------------------- > |
|
#6
| |||
| |||
| "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote in message news:a7ydnf9HcKk9X2_anZ2dnUVZ_o6knZ2d[at]comcast.com... - quote - > "Paul Thomas, CPA" <paulthomascpapc[at]bellsouth.net> wrote in message > news:bBtIj.25508$dT.21998[at]bignews1.bellsouth.net... > > > "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote > > > Received a 1099-B from Broker. > > > Have been able to reconcile it to within $129. > > > Is that close enough? > > > > > > That's a tad outside of just a rounding error. > > > > > > > As far as we know now all of the brokerage lines have been d/l'ed into > > > Qkn thruout the year. > > > The Qkn TXF export sums to the $129 shortage. > > > Is that within some tolerance or do we have to go on a search and > > > destroy mission? > > > > > You need to figure it out. It's probably a grouping of fractional shares > > on splits, spins, mergers, etc. > > -- > > Paul A. Thomas, CPA > > Athens, Georgia > > Dang! > I kinda expected that I'd have to chase after kind of the difference > but... > I was hoping maybe to get some sort of a free pass - you know "take a > chance..." > Oh Well. > It's just a couple of hundred lines on both the 1099 and the Qkn Report - > can knock that out in a couple of days<g> Thx. > Geo. you could just use the higher number on the 1099, and save yourself the trouble. Of course, you won't. Neither would I. But we COULD . . . -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#5
| |||
| |||
| GSalisbury wrote: .... - quote - > I kinda expected that I'd have to chase after kind of the difference but...
going to contest their 1099 number, I'd probably simply fudge one or two> I was hoping maybe to get some sort of a free pass - you know "take a > chance..." > Oh Well. > It's just a couple of hundred lines on both the 1099 and the Qkn Report - > can knock that out in a couple of days<g Frankly, unless I were convinced the brokerage was in error and were trades to match it unless it became obvious after a relatively short time--the amount of difference in taxes has to be $20 or so, max. IIF (if and only if) I were completely done w/ the whole return otherwise and had time to kill would I bother more -- but then again, I'm not a pro, either, just pragmatic and willing to bend where it seems there's nothing to be gained otherwise... ![]() -- -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#4
| |||
| |||
| "Paul Thomas, CPA" <paulthomascpapc[at]bellsouth.net> wrote in message news:bBtIj.25508$dT.21998[at]bignews1.bellsouth.net... - quote - > "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote
I kinda expected that I'd have to chase after kind of the difference but...> > Received a 1099-B from Broker. > > Have been able to reconcile it to within $129. > > Is that close enough? > That's a tad outside of just a rounding error. > > As far as we know now all of the brokerage lines have been d/l'ed into > > Qkn thruout the year. > > The Qkn TXF export sums to the $129 shortage. > > Is that within some tolerance or do we have to go on a search and destroy > > mission? > You need to figure it out. It's probably a grouping of fractional shares > on splits, spins, mergers, etc. > -- > Paul A. Thomas, CPA > Athens, Georgia Dang! I was hoping maybe to get some sort of a free pass - you know "take a chance..." Oh Well. It's just a couple of hundred lines on both the 1099 and the Qkn Report - can knock that out in a couple of days<gThx. 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. > << ------------------------------------------------------- > |
|
#3
| |||
| |||
| "Gil Faver" <rowdy'sboss[at]xxyz.com> wrote - quote - > "Paul Thomas, CPA" <paulthomascpapc[at]bellsouth.net> wrote > > "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote > > > Received a 1099-B from Broker. > > > Have been able to reconcile it to within $129. > > > Is that close enough? > > > > > > That's a tad outside of just a rounding error. > does your advise assume a certain level of total income shown on the > 1099B? It is based on the fact that the IRS will get a total gross sales on the B that is $129 more than the shown gross proceeds listed on the D. I'm quite sure the computer will catch that one. - quote - > If it were $1M, would you say $129 is close enough? It's not when the computer is looking for gross of $1,000,129. Would you do that on the W-2? Just round off to the nearest grand? -- Paul A. Thomas, CPA Athens, Georgia -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#2
| |||
| |||
| On Tue, 1 Apr 2008 13:10:04 EDT, "Gil Faver" <rowdy'sboss[at]xxyz.comwrote: - quote - > does your advise assume a certain level of total income shown on the 1099B? > If it were $1M, would you say $129 is close enough? Just curious how these > things are handled. I've never been so far off as $129, but at some point > for a couple of taxable years, I just threw in the towel. The IRS has a threshhold amount, but they won't come out and say what it is; I've heard $50 and $100, both from people in a position to know. The IRS compares your return to the 1099s and if it's within the threshhold amount, then it's close enough. If it's not within the threshhold amount, then it is not close enough. It does not depend on the level of total income as far as I know. -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#1
| |||
| |||
| "Paul Thomas, CPA" <paulthomascpapc[at]bellsouth.net> wrote in message news:bBtIj.25508$dT.21998[at]bignews1.bellsouth.net... - quote - > "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote
does your advise assume a certain level of total income shown on the 1099B?> > Received a 1099-B from Broker. > > Have been able to reconcile it to within $129. > > Is that close enough? > That's a tad outside of just a rounding error. If it were $1M, would you say $129 is close enough? Just curious how these things are handled. I've never been so far off as $129, but at some point for a couple of taxable years, I just threw in the towel. -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
| | |||
| |||
| "GSalisbury" <salsburyg.at.comcast.dot.net[at]giganews.com> wrote - quote - > Received a 1099-B from Broker. > Have been able to reconcile it to within $129. > Is that close enough? That's a tad outside of just a rounding error. - quote - > As far as we know now all of the brokerage lines have been d/l'ed into Qkn > thruout the year. > The Qkn TXF export sums to the $129 shortage. > Is that within some tolerance or do we have to go on a search and destroy > mission? You need to figure it out. It's probably a grouping of fractional shares on splits, spins, mergers, etc. -- Paul A. Thomas, CPA Athens, Georgia -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
|
#-1
| |||
| |||
| Received a 1099-B from Broker. Have been able to reconcile it to within $129. Is that close enough? As far as we know now all of the brokerage lines have been d/l'ed into Qkn thruout the year. The Qkn TXF export sums to the $129 shortage. Is that within some tolerance or do we have to go on a search and destroy mission? Thanks for your thoughts. Geo. Salisbury Long Valley, NJ -- << ------------------------------------------------------- > << 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. > << ------------------------------------------------------- > |
| Tags |
| 1099b, brokerage, close, reconciling, thing |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| The Hardest Thing To Do W. Wells: I have found the hardest thing to do is to rebalance your portfolio to a more conserative stand. I have retired and have been advised to rebalance... | Financial Planning | 8 | 03-01-2006 10:36 AM | |
| Best Thing for the Kids? JACK-CALI: Hi everyone.. am I doing the right thing (as a complete novice) or can someone point me in a better direction. I like putting a bit away for the... | Financial Planning | 8 | 01-10-2006 09:03 AM | |
| Another goofy thing I just noticed about M05 Dick Watson: A new M05 file gets an Income category named "Not an expense". (Well duh!) I halfways expected to find an Expense category named "Not an income".... | Microsoft Money | 1 | 05-18-2005 03:01 AM | |
| And another thing.... rex: ....automatic update just simply does not work correctly. When I first open MM2004 each morning it reports that I have, say, 1 statement to read. ... | Microsoft Money | 4 | 12-15-2004 04:20 AM | |
| Thread Tools | |
| Display Modes | |
| |