Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
evan802
Level 1

Export 1099 into Excel in QB enterprise

I am looking for simple step by step instructions how to export 1099NEC info into Excel so I can use the Tax1099 portal.  I will enter each vendor by hand as today is the deadline for 2023 filing but for future tutorials and to be ready for next year, any assistance would be helpful.  I am using QB desktop Enterprise Solutions 22.0.  Thank you ! 

3 Comments 3
BigRedConsulting
Community Champion

Export 1099 into Excel in QB enterprise

It's not possible to export the 1099 to Excel.

 

You can export the 1099 report to Excel and then reformat it.

ZackE
Moderator

Export 1099 into Excel in QB enterprise

Thanks for reaching out to the Community, evan802. I appreciate your detailed information.

 

I can certainly understand how an ability to export 1099-NEC forms into Excel could be useful and have submitted a suggestion about it as of today.

 

You can also submit your own feature requests while using QuickBooks.

 

Here's how:

 

  1. In the top menu bar, go to Help, Send Feedback Online, then Product Suggestion....


     
  2. Choose a Type of Feedback and Product Area (optional) from your available drop-down menus.


     
  3. Enter any suggestions/feedback in the Here is my suggestion: field.


     
  4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.


     
  5. Select Send Feedback.

 

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.

 

As a workaround, if you need to export 1099s, you can use the steps in Tax1099's Where Can I See My Submitted Forms article. In the event you have any trouble, you can check their support page for troubleshooting steps.

 

If there's any additional questions, I'm just a post away. Have a wonderful day!

julie31415
Level 1

Export 1099 into Excel in QB enterprise

It is not in any sensible format.  It takes a lot of rework to make it into the correct format. Quickbooks SHOULD be able to format in the correct way for Zenwork, since they are a partner.  What they have for us to use is garbage.  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us