After uploading the 1099-B, both the cost basis & proceeds do not match my 1099-B due to rounding of each individual trade, leaving a difference of $18 between TurboTax and the reported 1099-B values. Is this expected?
Fred58,
The short answer is Yes, TurboTax is permitted to round figures. These appear on IRS form 8949 "Sale and other Disposition of Assets". The instructions for that form (https://www.irs.gov/pub/irs-pdf/i8949.pdf) state on page 2:
Rounding Off to Whole Dollars
You can round off cents to whole dollars on Form 8949. If you do round to whole dollars, round all amounts. To round, drop cent amounts under 50 cents and increase cent amounts over 49 cents to the next dollar. For example, $1.49 becomes $1 and $1.50 becomes $2.
In fact, at least the last time I looked into it, IRS blessed software is required to round and report dollar figures.
If the 1099B total gain is less that what TurboTax computes, by all means be happy you are saving a few bucks. If it went the other way, you may be able to close the gap by reporting only 1099-B totals in TurboTax. This is available through one of the two Exceptions listed on page 3 of those instructions. Exception 2 is a bit onerous as you would essentially have to make an equivalent of 8949 showing the pennies and any adjustments and then attach it as a PDF or print it out and mail it separately using form 8453.
Hi hbl3973,
The Turbo Tax rounded value is underreporting the capital gains from the 1099-B, shouldn’t the values match on the form 8949? I did read through the exceptions, but wouldn’t Turbo Tax ask before marking the item as completed on its software?
How many transactions?
If it is many hundreds then the rounding should all cancel out in the end since it should be random.
I have a problem with this too. This behavior in TurboTax 2020 is different than the behavior in TurboTax 2019 where TT2019 only rounded at the end of all of the transations.
>> Intuit, will you be fixing this in a new update? Or is this a new permanent "feature" of TurboTax 2020? It's not cool. Totally ready to ditch 20+ years of TT returns to try another product.
About a hundred transactions. They don't cancel out, I'm looking at the totals after the upload and they don't match the 1099-B.
As an example, if you had 100 transactions, all for $0.49, would you be expected to report your $49 in earnings, or round down to $0 on each transaction and report $0?
Trick question.
What is the profit shown on your consolidated 1099-B for that sales category.?
The totals Line 2 on the bottom of Form 8949 has to match that.
If you choose to aggregate category A with no adjustments,
the totals on Schedule D must match your broker 1099-B.
After rounding that would be +/- one dollar.
Form 8949 is not required.
Then, if you choose to use Form 8949, the totals on Form 8949 Line 2 must match the totals on the corresponding lines on Schedule D.
------
P.S.
Meanwhile TurboTax exhibits various kinds of rounding behaviors that cause problems. not just with stock transactions.
8949 instructions are missing the clarifying sentence in Schedule D instructions:
'If you have to add two or more
amounts to figure the amount to enter on
a line, include cents when adding the
amounts and round off only the total."
In the old days all your transactions were on Schedule D and there were no categories.
Fred58,
As the rounding results in a smaller capital gain than what keeping the cents would have given, just relax, you've saved some tax. There's no penalty for using the pennies vs. the dollars to save some tax. I do that every year to save a couple of bucks. TurboTax has handled the values consistently, including transferring the dollar totals to Schedule D.
As to the exceptions, which aren't advantageous for your current situation, Exception 1 is taken care of by TurboTax. Exception 2 arises only if you manually opt to provide sums of transactions as a single entry. In that case, you may be asked to fill out and mail in Form 8453 if you cannot upload the statements with the details of what would have appeared on 8949 for those composited entries.
Fred58,
Your example is a correct, if extreme situation. Basic statistics says that the standard deviation, i.e. the approximate width of the spread of values in a sum, grows proportionally to the square root of the number of entries summed. So with a 100 entries, you would expect a 10-fold growth in the range of possible swings away from the penny-precise average. (I ignore the technicality that the +/- 50 cent penny range is a uniform distribution and not a normal (bell-shaped) distribution.) For 100 entries, 95% of the time the swing will fall within about $5.75 each way. $18 is an outlier, but, as you have seen, not impossible.
Thanks so much! I appreciate you helping & taking the time to look into this!
fanfare,
So true that it was much easier before 2010 to handle capital gains before the rules were changed to discourage fraud. In that setting then, yes, one added the pennies and rounded the sum onto Schedule D.
With regards to needing to match the brokerage statement penny-correct totals, I respectfully disagree. Neither the Schedule D instructions nor the Form 8949 instructions impose such a requirement. They simply say that 8949 individual line entries can be individually rounded and their sum(s) transferred to Schedule D on the appropriate line(s).
That said, I always maintain my computer tax spreadsheets with penny accuracy and choose, if I am ambitious, to enter it into TurboTax to see if I save money by rounding.
As an active investor, if you aggregate Category A or D transactions without adjustments, Form 8949 is not required and does not come into the picture. No mailing is necessary.
That's the simplest way to report your activity.
Clearly in that case your Schedule D is going to match up with your consolidated 1099-B.
That's all I was saying..
Then I argued that if you do use Form 8949, logically the Line 1b totals should be the same as the Line 1a totals would have been.
But you don't have a problem with a 5-18 dollar difference, I won't argue the point.
As far as your statistics analysis goes, I'll take your word for it.
If you are arguing that the clarifying instruction for Schedule D is not applicable to form 8949 because it is not in the 8949 instructions, I would argue that point.
The answers here seem to miss the point entirely. It's not that TT2020 is rounding, it's that this behavior is DIFFERENT than how TT2019 and earlier years handled this. In prior years, TT would keep each individual transaction to the penny and only round the total, so that the brokerage 1099-Bs matched the total in TT within $1.
This is now completely different in TT2020 and each transaction is now rounded at the transaction level. I appreciate your discussion of randomness, but the sales prices are not random. They're usually to a whole dollar amount when trading 100 shares, less consistent SEC fees and commissions that do not lead to random sales prices, even across hundreds of transactions.
What I would appreciate in an answer is an explanation as to why this changed from previous years, not simply, "it's okay, it's just rounded" and if Intuit has any plans to update this. It's sloppy and I personally don't like it. If it's deemed a new feature and I should just accept and be happy with it, I'm going elsewhere. Clearly the inflated amounts do not support "Let's get your maximum refund, guaranteed" if I'm paying more taxes as a result, and manually completing lots of extra forms kind of takes away the whole benefit of using tax software. If Intuit would like to reach out to me directly, I'd welcome their response.
Thank you for your help and any additional clarity you may be able to provide.
This is not Cool
Who thought this was a good Idea ???????
Time for a different Tax Program
I agree that this is NOT a positive change. I like to check the totals to see everything is ok in uploads and this change does not allow that as the 1099B and form 8949 totals will NOT match what Turbo Tax is doing. If they can at least allow an option not to round the individual transactions then we could choose.
Hope they fix this soon..
You're correct, the issue with regard to the negative proceed on 1099-B isn't due to a mistake. It's a rounding issue. If the adjustment is $0.49 or less, then it is automatically rounded to zero. This type of rounding is allowed by the IRS. Unfortunately, zero is not a valid value for this field -- thus the error message.
To resolve the issue, you can still import the transactions but you'll need do delete anything that is .49 or less. This will clear the error message.
To do this, you will need to revisit the input section for the Form 1099-B transactions. Use the following steps:
Here is more information about IRS guidelines and rounding: https://www.irs.gov/publications/p17/ch01.html
Computations
The following information may be useful in making the return easier to complete.
Rounding off dollars.
You can round off cents to whole dollars on your return and schedules. If you do round to whole dollars, you must round all amounts. To round, drop amounts under 50 cents and increase amounts from 50 to 99 cents to the next dollar. For example, $1.39 becomes $1 and $2.50 becomes $3.
If you have to add two or more amounts to figure the amount to enter on a line, include cents when adding the amounts and round off only the total.
Here is a TurboTax article that explains Form 1099-B Proceeds from Broker transactions
How Form 1099-B is used
The 1099-B helps you deal with capital gains taxes. Usually, when you sell something for more than it cost you to acquire it, the profit is a capital gain, and it may be taxable. On the other hand, if you sell something for less than you paid for it, then you may have a capital loss, which you might be able to use to reduce your taxable capital gains or other income.
0
Not sure you understand the issue. Regardless of whether the IRS says it is ok to do this, it is messing up the users. As someone pointed out, the program is supposed to make doing the taxes easier, not harder. This was a change for 2020 and it is not a good one.
Turbo Tax no longer matches the 1099-b or 8949 from my broker. After import the totals are different. They should match to allow checking the totals.
As I have said, I do not care if it is allowed by the IRS, Turbotax should do it the way it used to and make our lives easier, not harder.
I and many others bought Turbo Tax to make doing taxes easier not Harder!
Your customers think your rounding of each transitions is causing a problem not matching 1099B ammounts reported to the IRS
Is the program incapable of adding and subtracting than rounding the final amount so that the results match all us brokerage firm reporting on 1099B sales?
They fully understand the issue but continue to just regurgitate the same post whenever they see a user post raising this issue. It’s getting old for sure.
This is completely unacceptable.
In my case, TT shows a total gain of over $200 less than my 1099-B. Maybe the IRS will accept that, maybe it won't, I don't know--but it was purely a matter of luck that TT ended up $200 less than my 1099-B rather than $200 more, which even if the IRS allowed it, TT shouldn't force rounding that requires people to pay *more*.
The problem is that TT is rounding both the basis and the proceeds prior to doing the subtraction. They should be rounding the result not the two numbers prior to the subtraction. This is completely new this year and was never done this way in all the prior years that I used TT...which goes back many years. It really needs to be fixed.
Turbotax seems to import the "Gross Proceeds" correctly from the 1099B broker statements. The individual transactions seem to have the proceeds/cost information, andTurbotax displays it correctly when you select the "edit" button and verify the information.
However, the consolidated entries in Schedule D (1a, 1b, 8a) have drifted apart due to the rounding. The net of it is that my Gross Proceeds from all sales are showing up $90 short and the Net Gains exceed what they should be by $210.
In prior years, I was able to reconcile the Turbotax Schedule D with the 1099B statements down to the penny. Clearly, there is a problem this year.
Will Turbotax stand behind its product if the return gets flagged by the IRS for the discrepency????
That is for sure not true in my case.
I have hundreds of option trades with Vanguard. Vanguard charge you $1 commission for each written or bought-back contract and, only for each written contract, a small fee which is in all my cases lower than 50 cents.
That means that the amounts of all my buy-backs are always in whole dollars and the amounts for a written option contract are always less than 50 cents smaller than a whole dollar amount. The result is that all my profits (and losses) are always less than 50 cents below the whole dollar amount (Just by the fee amount).
TurboTax round all these profits (and losses) up, basically it ignores my paid fee. In my case, that made my gains $ 76 higher than they really were. The averaging out with more transactions works only if the fees would have a uniform distribution from 0.1 to 0.99 cents. In my case, more trades would only result in a larger rounding error.
Just to prevent anyone else wasting their time trying this--the rounding was causing my total gains to show around $200 less than reported on my 1099-B imported directly from the TDA website.
So I decided to see what would happen if instead I manually exported from TDA to a .txf file then imported that file.
For some reason that came up with a new *third* number for the total gains that disagreed with both the 1099-B and with TT's previous total--this time around $300 less than my 1099-B. Worse, it didn't know which transactions were Box A, Box B, etc., so wanted me to manually enter that for every single trade.
So--yeah, don't waste your time trying that.