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! Go to Solution.
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:
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.
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.
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:
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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:
If you have any further queries, let me know in the comments below. I'll be here immediately to assist you.
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?
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.
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.
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.
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.
Good evening all, and thanks for your attentiuon.
For reference, we are running QB Desktop Premier Non-Profit Release R17P, Activated R17_36. We expect to move to QB Online 'soon' but it looks like that will not happen until January 2025; I'd rather not run any updates at this time and risk disturbing something before we are ready to produce the Accountant file.
That being said, our 1099s are produced by our payroll service based on information we give them. This needs to be: for each vendor over the threshhold,
the name,
last known address,
total paid (balance)
I especially do not need the individual transactions, which for some, because of the way we allocate costs involves seven lines for each payment. Fixing this in excel gets to be tedious and time consuming.
As suggested above I will submit a help request soon, but right now I need to get back to work.
This works perfectly !! Thanks!
This solution works perfectly thanks!
Hello there, ljkentucky.
We’re thrilled to hear that the solution provided was able to resolve your concerns. Your feedback is invaluable to us, and we appreciate your engagement in the Community.
Please remember that we are always here to assist you with any issues you might encounter while using the program. Whether you have questions or need support, don’t hesitate to reach out.
Thank you for being a part of our Community, ljkentucky. Have a fantastic day!
File your business taxes with confidence thanks to our 100% accurate guarantee.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.