Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe are trying to create a report where we can pull a list of 1099 subcontractors who did work in a specific county so we can provide that information to the county government. Currently to get that information we print three reports: 1099 Summary, Job Revenue-Summary by County, and then Job Costs by Vendor with Job Summary. We use the 1099 Summary to locate the the 1099 subs on the Job Costs Report. Then we take the Job Revenue Report by County and go through the Job Costs by Vendor Report to select the jobs performed by the subcontractors in their summary. We then manually total and create a document to submit to the county government.
We've tried contacting Quickbooks though their online support and after 4 hours chatting they still were unable to assist in customizing a report to meet our needs. We feel there must be other businesses who need to access this specific type of information and would appreciate any assistance in trying to create this report. We utilize Quickbooks Desktop.
I'm here to help you with this, KSP. I know you've been through a lot in trying to get the specific report.
We can export the reports to Excel. From there, you're able to customize them to get the information you'd like to see. I'll guide you how.
Once done, you can also get the latest version of the report from QuickBooks while you're in Excel. Here's how:
To learn more about personalizing your reports in QuickBooks, please see this article: Customize Reports.
In case you'll need to file both 1099-MISC and 1099-NEC in the future, please see this article to learn what you'll need to do: How to Modify your Chart of Accounts for your 1099-MISC and 1099-NEC Filing.
If you'll need help in managing your reports, please don't hesitate to add a comment below. I'll always have your back.
Thank you for replying, however I am not looking to export reports to Excel. I need information provided in all 3 reports and have been unable to customize a report to draw the information into one report.
I need to know who are 1099 Subcontractors (1099 Summary)
I need to know the jobs that were performed in a specific county (Job Revenue-Summary by County)
I need to know which of the 1099 Subcontractors performed the work for those jobs in said county (Job Costs by Vendor and Job Summary). I then go through each report to cross reference and manually create a document.
Can you assist in pulling this information into one report that lists the Subcontractors that worked in a said county and the amount paid them for work solely in that county?
Thanks for getting back in here, @KSP. Let me clarify things for you.
I can see here how it is important for you to have all the data in one report. However, the option of pulling up all the information into one report is unavailable.
As mentioned above, you can export all 3 reports that you want. From there, you can merge them into one report to have all the information you want. You may consider following the steps given above on how to export the report in QuickBooks Desktop.
Additionally, I'll be adding these resources to learn more about reports in QuickBooks Desktop:
Don't hesitate to post again or leave a comment on this thread if you have any follow-up questions. Take care and enjoy the rest of the week.
I am attempting to export all 3 reports into one workbook in excel (each report having it's own worksheet). However when I export the 3rd report, it simply replaced the 2nd report in Sheet 2. It's as if Excel/QB won't allow more then 3 reports to be exported into one workbook. Any help would be appreciated.
Thanks for the quick response, @KSP.
I'll share with you some information about exporting reports in QuickBooks Desktop.
The 3 reports should have their own worksheets, workbooks, and unique file name to avoid replacement. With this, I'd suggest exporting the reports to their personal workbooks.
For more information, you may refer to this article: Export reports as Excel workbooks.
But if the issue persists, I'd recommend running verify and rebuild data to isolate the problem.
Here's how:
For the detailed steps, check out this article: Verify and Rebuild Data.
After that, re-export the reports to verify if it's already functioning well.
In case you've encountered some issues, please visit this article for the troubleshooting steps: Fix export to Excel issues in QuickBooks Desktop.
Additionally, I've added some pages that might help you personalizing, retain reports, and other related topics.
Let me know if you have follow-up questions. I'm eager to help. Keep safe!
I have each report downloaded into Excel into their own workbook. How do I combine them into one report? I also don't see a Quickbooks tab in Excel which someone said would be visible after I downloaded my first report. Thank you!
Hi there, KSP.
Thanks for stopping by the Community, I'm happy to help you out today. If you're trying to combined two reports into one you can follow this helpful article that was provided earlier in this thread by my colleague. Also I was able to find a useful article about consolidating data in multiple worksheets on the Microsoft support page. That should definitely help get you get your reports combined in Excel. If you have any other questions, feel free to post here anytime. Thanks and I hope you have a nice day.
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.