Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello, I need to run a report that shows how much we have paid each subcontractor for each job. I do not want the report to include all vendors - only those that I have classified as subcontractors.
I tried running the Job Costs by Job and Vendor Detail report and customizing it. I went to customize report > filters > vendor type, and I selected "subcontractors" from the drop-down. However, now the report is completely blank and shows no info. I've checked the dates, and I have it set to "all." Any idea why there is no data available? Or does anyone have other suggestions for how to get this info?
Thank you!
You're doing the right thing when running the report you needed, KaitlynB.
I have a couple of solutions to help us fix the problem.
A data integrity issue can cause data damage to your company file. We can use the Verify and Rebuild utility to fix the issue. Before doing the Verify rebuild, as an initial step, updating the QuickBooks Desktop release version is a good start when it comes to fixing issues you've encountered.
Then we can proceed to Verify and Rebuild utility. Here's how:
After doing the rebuild process, let's go ahead and check the report if it's still showing blank and no info.
Another solution is to run and use QuickBooks Tool Hub and then QuickBooks File Doctor to resolve the issue. This program is a collection of tools that can help resolve major issues that a user might face while working on the QuickBooks Desktop. For the best experience, we recommend using this on Windows 10, 64-bit. Please follow the steps in this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.
Additionally, to learn more about personalizing your reports, please see this article: Customize reports in QuickBooks Desktop.
If you have any other questions, feel free to post here anytime. Thanks and have a nice day.
Thanks for the reply. I followed these steps, but it is still not working. When I rebuilt the data, it said there were no issues found.
Do you have any other ideas?
Hello, KaitlynB.
I have another way to run a report showing all the payments for your subcontractor.
When creating business and financial reports, QuickBooks follows the Sources and Targets concept. This indicates that each report's data is derived from the specifics of the transaction that served as its source.
The reports go blank since the system is unable to pull up subcontractor information in there. You can compare the data from two different reports that you can run. Run the Expenses by Vendor Detail report to see all of the subcontractor payments you've made, and Job Costs by Job and Vendor Detail to find out how much each job costs. I'll show you how.
Here's how to run the Expenses by Vendor Detail report:
After that, run the Job Costs by Job and Vendor Detail report:
If you want to combine the information, you can export your report to Excel. From there, you can customize based on your preference.
I've also included this article if you want to save the current customization for future use: Create, access, and modify memorized reports.
Let me know if you need further help with running reports in QuickBooks. We're always here to help you.
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