cancel
Showing results for 
Search instead for 
Did you mean: 
jstabler
Level 3

1099 Reports Don't Have Vendor Addresses

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

Solved
Best answer January 12, 2021

Best Answers
Mark_R
QuickBooks Team

1099 Reports Don't Have Vendor Addresses

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.

View solution in original post

15 Comments 15
Mark_R
QuickBooks Team

1099 Reports Don't Have Vendor Addresses

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.

SLHartzog
Level 1

1099 Reports Don't Have Vendor Addresses

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.

SLHartzog
Level 1

1099 Reports Don't Have Vendor Addresses

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
Moderator

1099 Reports Don't Have Vendor Addresses

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.

SLHartzog
Level 1

1099 Reports Don't Have Vendor Addresses

Thanks so much for your quick response, but I already did all the steps you recommended during a several-hour support session with a QB support tech this past Friday.  

 

If it helps to know, I'm using Desktop Pro Plus 2022.  When we ran the data verification and rebuild it found and fixed 0 issues. 

 

Summer

ShiellaGraceA
QuickBooks Team

1099 Reports Don't Have Vendor Addresses

Thanks for coming back to us, @SLHartzog.

 

I know a report you can use to view your 1099 vendor transactions. You can pull up the 1099 Detail report and filter it to add the EIN, address, and set the date to view 2021 transactions. Let me guide you how.

 

  1. Go to Reports.
  2. Choose Vendors & Payables.
  3. Select 1099 Detail.
  4. Tap the Customize button at the top.
  5. Under Columns, search and mark Name Address and SSN/Tax ID.
  6. Change the Dates drop-down to Custom and then enter the From and To date.
  7. Click OK.

 

 

 

With the above steps, you're able to view 1099 vendor transactions as well as their address and EIN. For more information about customizing reports in Desktop, check out this guide: Customize reports in QuickBooks Desktop.

 

Here's our help content in case you need help managing vendor-related tasks. It has our general vendor topics with articles.

 

Still have questions? Please drop them below and I'll be glad to answer them for you. Take care and have a wonderful day ahead.

 

 

 

 

 

 

 

 

 

 

 

SLHartzog
Level 1

1099 Reports Don't Have Vendor Addresses

Thanks for your response, but I actually tried tweaking the 1099 detail report already.  1) There's no way to filter out 1099 eligible vendors we paid less than $600, and 2) our accountant doesn't need the transactions, they need the total paid each vendor. 

Frankly both the 1099 Summary Report and 1099 Detail Report are useless given their limited filtering options.

 

GlinetteC
Moderator

1099 Reports Don't Have Vendor Addresses

I appreciate the steps you've taken, SLHartzog.

 

I understand how this option is beneficial to you and your business. 

 

The ability to have the total paid for each vendor is unavailable yet. I'll take this as a product suggestion. QuickBooks continuously improve the product's features to meet our customers' needs.

 

I encourage you to submit feedback by going to the Help icon and choosing to Send Feedback Online. These requests and suggestions are forwarded to the Product Development Team for consideration in any future updates. 

 

Also, you may visit our QuickBooks blog page to keep up with the recent news and product release: Firms of the Future.

 

I'll be here to keep helping if you have any other concerns.

SLHartzog
Level 1

1099 Reports Don't Have Vendor Addresses

Thank you!  And just to be clear the 1099 Summary Report would be a perfect snapshot of the necessary info  to provide our accountants for prep of 1099s if it simply provided the vendor addresses. 

 

The 1099 Detail Report would be fine if it filtered out clients who didn't meet the annual threshold of $600 for the year.     

serenada27
Level 1

1099 Reports Don't Have Vendor Addresses

We have been using QB desktop for the past 6 years. We found the issue with 1099 report in our first year of using QB. We have made suggestion right there and then, 6 years later, Intuit have done exactly zero efforts on this. Due to the nature of our business, we need very limited accounting software, therefore we are stuck with QB but I wish Intuit would spend few developers hours and add this function to the 1099 Summary report to be able to pull addresses as well.

Our workaround is to have database with vendors and their addresses in Excel and do a vlookup based on the name. It is PITA but this is the only solution we have found as well since we print 1099s outside of QB system.

luckyu
Level 1

1099 Reports Don't Have Vendor Addresses

Completely agree. It's ridiculous that as long as Quickbooks has been around and as much as they charge, they can't fix this simple little thing. I should be able to at least build a report to include whatever I want in it. 1099 summary should have a column with vendor address and the "use threshold" on the top should have a function that. I'm assuming it's supposed to be able to filter out all vendors that were paid less then $600 but I can't see it serves any purpose at all.

RoseJillB
QuickBooks Team

1099 Reports Don't Have Vendor Addresses

Hi there, @luckyu.

 

I understand how you wanted to pull up vendor addresses to one of our 1099 reports in QuickBooks Desktop (QBDT). This will benefit you and other users waiting for this option to be added.

 

We want to comprehend your preferences for the application. Thus, extend this concern to our product development team by sending Feedback directly to them. This will enable us to better understand how to meet your business's needs. Depending on how many requests they get, they could also add this functionality to later editions. You can accomplish this by following the instructions listed below:

 

  1. At the top, select the Help menu.
  2. Choose to Send Feedback Online, then click Product Suggestion.
  3. Type in your feedback or feature request.
  4. Click the Send Feedback button.

 

If you have any further queries, let me know in the comments below. I'll be here immediately to assist you.

dae53
Level 1

1099 Reports Don't Have Vendor Addresses

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
QuickBooks Team

1099 Reports Don't Have Vendor Addresses

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.

serenada27
Level 1

1099 Reports Don't Have Vendor Addresses

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.

Need to get in touch?

Contact us