1099-B Worksheet Brokerage Statement Summary Table

Forum|Forum|4 years ago
February 22, 2022
3 replies
16 views

As of yesterday, 2/21/22, on the 1099-B worksheet, the Brokerage Statement (Form 1099-B or substitute) Summary Table and From 8949 and Schedule D Totals table are not populating with information entered on Form 8949 Reporting Exception Transactions smart worksheet. Any one else having this trouble? What am I missing?

ProSeries Professional

This topic has been closed for replies.

F

Frustrated-in-IL

Level 8

Not sure what you are missing but if I am understanding what you are saying, it is working fine. Can you be more specific what you are doing and what you want done?

A

Ali

Level 3

On the "Form 1099-B Worksheet" I use that top section titled "Form 8949 Reporting Exception Transactions." Prior to yesterday, the amounts entered there along with the amounts entered from the "Quick Entry Table," would be summarized in the table at the bottom of page one titled, "Brokerage Statement (Form 1099-B or substitute) Summary Table." This was helpful in reconciling a broker form 1099 totals to what's been entered. But it's not populating. I did "Refresh Updates for Installed Products" and that didn't correct this. Is this enough of an explanation? Thanks so much for you help.

A

Ali

Level 3

I'm same person as ScowlyOwl, by the way. Sorry about the two different handles.

E

Emmabob

Level 3

I called a couple of weeks ago and the person above the individual on the help line call said it was working the way it was supposed to then kicked us off of the call. The tables are useless now. I can't tie back to the 1099-Bs in full and there is no easy way to verify the accuracy. The way it worked in 2020 return was very helpful. This is again, useless. So when I have a client with 10 1099B's how on earth am I supposed to verify entries? No cap gain/loss shows next to entry lines even

F

Frustrated-in-IL

Level 8

I get it that things don't work the way they used to and it is frustrating. The mortgage interest deduction worksheet worked perfectly through 2019 and then in 2020 and now in 2021 it is useless. I have repeatedly complained but realistically, it is so low on the totem pole that Intuit has bigger issues to deal with.

I would imagine this is the same. But look, if I am understanding your problem, it is simple to work around it. Yes, I get it that for $7000 you shouldn't have to work around it. But just do this. Enter the name of the brokerage on the 1099-B worksheet. Then enter the totals in the Quick table Box (A,B,C, etc). The table will populate just fine for this broker.

Then open another 1099-B worksheet with a different name. Rinse and repeat as often as necessary. You will get your totals by broker, with the grand total showing up on the Schedule D. If you get caught up with the dates, use 12/31/21 as the sale date and Various as the purchase date.

S

sariscpa

Level 5

Holy cow it's magic! It's working now!!