Skip to main content
J
jstabler
January 12, 2021
Solved

1099 Reports Don't Have Vendor Addresses

  • January 12, 2021
  • 3 replies
  • 0 views

I'm trying to get a report for our accountant that has the 1099 information. I have no trouble getting the report but it won't print with vendor addresses. This is information that my accountant has to have in order to prepare the 1099. How do I report with addresses?

 

Thank you,

Jennifer

Best answer by Mark_R

Let's get the vendor's addresses printed in 1099, @jstabler.

 

QuickBooks is dependent on the information entered on the vendor's profile. You'll want to make sure that the addresses are included in the fields. Here's how:

 

  1. Go to the Vendors menu, then select Vendor Center. 
  2. Select each vendor to review their profile.
  3. Click the Address Info tab, then verify if the address is entered from there.
  4. Hit OK.

If there's no information entered, fill out the vendor's address and prepare your 1099 again to verify.

 

If the addresses are entered, let's update your QuickBooks Desktop to the latest release. This way, we can make sure that the software is up-to-date.

 

  1. Go to the Help menu, select Update QuickBooks Desktop.
  2. Select the Update Now tab.
  3. Put a checkmark in the Reset Update checkbox.
  4. Click Get Updates to start the download.
  5. Wait for the download to finish, then restart QuickBooks.
  6. Then, accept the option to install the new release.

I'm adding this article for more guidance: Update QuickBooks Desktop to the latest release.

 

After updating your QuickBooks, go back and try to prepare your 1099 to verify if the vendor addresses are already showing.

 

If the issue persists, I suggest contacting our QuickBooks Support Team. One of our support agents will investigate this matter further and provide additional steps to get your vendor's addresses in 1099.

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back.

3 replies

M
Mark_RAnswer
January 12, 2021

Let's get the vendor's addresses printed in 1099, @jstabler.

 

QuickBooks is dependent on the information entered on the vendor's profile. You'll want to make sure that the addresses are included in the fields. Here's how:

 

  1. Go to the Vendors menu, then select Vendor Center. 
  2. Select each vendor to review their profile.
  3. Click the Address Info tab, then verify if the address is entered from there.
  4. Hit OK.

If there's no information entered, fill out the vendor's address and prepare your 1099 again to verify.

 

If the addresses are entered, let's update your QuickBooks Desktop to the latest release. This way, we can make sure that the software is up-to-date.

 

  1. Go to the Help menu, select Update QuickBooks Desktop.
  2. Select the Update Now tab.
  3. Put a checkmark in the Reset Update checkbox.
  4. Click Get Updates to start the download.
  5. Wait for the download to finish, then restart QuickBooks.
  6. Then, accept the option to install the new release.

I'm adding this article for more guidance: Update QuickBooks Desktop to the latest release.

 

After updating your QuickBooks, go back and try to prepare your 1099 to verify if the vendor addresses are already showing.

 

If the issue persists, I suggest contacting our QuickBooks Support Team. One of our support agents will investigate this matter further and provide additional steps to get your vendor's addresses in 1099.

 

Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back.

    S
    SLHartzog
    January 24, 2022

    All due respect  but I don't see that Jennifer's question was solved.  I also need a 1099 vendor REPORT (not the actual 1099s) to provide my accountant with 2021 NEC paid to 1099 eligible vendors.  The 1099 report on the QB report  menu provides the vendor name, EIN, and 1099 wages paid for 2021 but doesn't include addresses. I have addresses entered for all my vendors. This report simply doesn't include them.  Another online "solution" to this problem was to use the vendor contact list and select only those vendors who are 1099 eligible, then also select to show their EINs.  This provides all the necessary information EXCEPT the amount paid reflected is 2022 YTD with no option to selection 2021. Can you help? 

     

    Summer H.

    JoesemM
    JoesemM
    January 24, 2022

    Thanks for joining this thread and sharing detailed information about your concern, @SLHartzog.

     

    This can be fixed by updating your payroll to the latest release. This is to ensure you get the latest payroll updates which include your taxes and forms. Before doing so, make sure that you run as administrator when you open QuickBooks Desktop.

     

    If you haven't done this yet, I recommend following the steps below:

     

    1. Go to the Help menu.

    2. Click Update QuickBooks Desktop.

    3. Go to the Options tab and click Mark All, then Save.

    4. Tap the Update Now tab.

    5. Make sure Critical Fixes are checked.

    6. Then click Get Updates.

     

    Once done, open the file to install the update after the download is finished. After the installation, restart your computer. For more details, see this article: Update QuickBooks Desktop to the latest release.

     

    If the issue persists, I'd recommend the Verify and Rebuild Utility Tool to check the integrity of your data on your company file. This way, way we can fix your issue with 1099 reports. You can browse this article for detailed instructions: Fix data damage on your QuickBooks Desktop company file.

     

    Lastly, I recommend visiting the links below to help you in preparing your company and tax forms for the upcoming tax season:

     

     

    Reach out to me if you have any questions or other concerns. I’ll jump right back in to answer them for you. Have a good one, @SLHartzog.

    S
    SLHartzog
    January 24, 2022

    I'm also trying to run a 2021 1099 REPORT for my accountant that provides total NEC paid to vendors in 2021 and also provides their EIN and mailing address. The 1099 report in the report menu does not provide vendors addresses. A "solution" I found online said to use the vendor  contact list and select EIN and 1099 eligible, but there's no option to select dates for data pulled. It provides YTD balances for the current year. This needs to be addressed.  Thank you,

     

    Summer H.

    D
    dae53
    March 15, 2024

    Does anyone have a solution to generate a 1099 Summary Report (this report maps payments with thresholds) that includes the vendor addresses so that it can be given to an accountant with all the information in one report? The 1099 Detail Report includes addresses but does not map the payments. Has there been a solution to this?

    AlverMarkT
    AlverMarkT
    March 15, 2024

    Thanks for joining the thread, @dae53. 

     

    I'm here to help you create a 1099 report in QuickBooks Desktop (QBDT) that includes the vendor addresses and map payments with thresholds.

     

    While the 1099 Detail report includes vendor addresses, only the 1099 Summary report contains the information on which vendors have reached the payment thresholds for 1099 reporting. To resolve this, you can consider generating a 1099 Detail report and a 1099 Summary report, exporting them, and combining them within Excel. You can follow these steps. 

     

    1. In your QBDT, go to the Reports menu.
    2. Choose Reports Center.
    3. In the search field, type "1099 Detail report" and select the report. 
    4. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet. 
    5. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
    6. When you’re ready to export, select OK.
    7. Repeat Steps 1 to 6 for the 1099 Summary report.

     

    After this, you can combine both reports in Excel. 

     

    However, I understand that it's important for the software to accommodate various business needs, in this case, generate a single report to provide your accountant with comprehensive data. Your experience highlights where the software needs to improve. With this, I encourage sending feedback to our product engineers to implement this option in generating 1099 Summary reports in the future. 

     

    1. Select the Help option.
    2. Select the Send Feedback Online option.
    3. Select the Product Suggestion option. A pop-up window displays.
    4. Enter your feedback suggestion.
    5. Click the Send Feedback button. 

     

    For future reference, let me add this article in creating and filing 1099s with QBDT: Create and file 1099s with QuickBooks Desktop. 

     

    You're always welcome in the Community should you have further questions about generating a 1099 report to give to your accountant. We're committed to offering ongoing support. Take care.

    S
    serenada27
    March 15, 2024

    I have asked for this kind of report years ago, Intuit and QB have yet to work on it, so imho, it is not a priority for the development team, obviously. And having to download and manipulate reports out of QB at this stage of technology is PITA.

    Terms & ConditionsAccessibility statement