Input 1099 divs from spreadsheet

Forum|Forum|1 year ago
February 1, 2025
1 reply
2 views

I have a spreadsheet showing all the 1099 information for approximately 100 separate 1099 DIVs. I also have what looks like a 1099, consisting of the sums of every box (except for name and TIN) Is there any way I can input these 100 1099's from the spreadsheet rather than tediously typing them all? BTW, this is not a broker who provides a consolidated statement .

KeshaH

Level 11

TurboTax Desktop program allows for the import of TXF files, but not excel or CSV. Because you have a 1099 that shows the sum of all of the data listed in your spreadsheet, you can use that to enter your 1099-DIV information instead of entering each 1099-DIV separately.

alexy0211Author

Level 2

Thanks. That would be ideal if it will work. What should I use as the name and FEIN on this aggregate 1099? (Remember this is not a consolidated statement like you would get from Vangard e.g.)

I was able to put in this total info as a 1099 in forms. I left FEIN blank, but step-by-step flags that as an error. Maybe use all zeros or will that freak out IRS computers?

Should I attach the spreadsheet showing a line for each individual 1099 as an attachment, if there is a way to do that in TT?

LenaH

Employee Tax Expert

You do not have to input the FEIN for your combined 1099-DIV entry and can leave it blank. If you do get a review message, you should be able to bypass it and e-file your return.

Lastly, you cannot attach a PDF or any type of document to your return. I would suggest keeping it in your records in case the IRS asks for backup documentation.

@alexy0211

**Say "Thanks" by clicking the thumb icon in a post. **Mark the post that answers your question by clicking on "Mark as Best Answer"