cancel
Showing results for 
Search instead for 
Did you mean: 
KaitlynB
Level 1

Subcontractor Costs by Job

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!

3 Comments 3
AileneA
QuickBooks Team

Subcontractor Costs by Job

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: 

 

  1. Go to File, then hover on Utilities
  2. Pick Verify Data.
  3. Follow the prompts to proceed with the data verification process.
  4. When it's done, go to the Utilities menu again.
  5. Select Rebuild Data, then follow the prompts. 

 

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.

KaitlynB
Level 1

Subcontractor Costs by Job

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?

Giovann_G
Moderator

Subcontractor Costs by Job

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:

 

  1. Go to the Reports menu at the top.
  2. Select Company & Financial.
  3. Choose Expenses by Vendor Detail.
  4. Click on Customize Report.
  5. Go to the Filters tab.
  6. Search and check Vendor Type.
  7. Under the Vendor Type drop-down, select Subcontractor.
  8. Click OK to display the customized report.

 

After that, run the Job Costs by Job and Vendor Detail report:

 

  1. Go to the Reports menu at the top.
  2. Select Industry Specific.
  3. Choose Contractor Reports.
  4. Click Job Costs by Job and Vendor Detail.
  5. Enter the correct reporting period.
  6. Hit Refresh.

 

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us