Skip to main content
evan802
Jan 31, 2024 6:24 PM UTC
Question

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 replies

BigRedConsulting
BigRedConsulting
Jan 31, 2024 7:30 PM UTC

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

 

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

julie31415
Jan 28, 2025 7:50 PM UTC

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.  

    rvrfrf
    Jan 31, 2024 7:40 PM UTC

    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!

    Terms & ConditionsAccessibility statement