How do I run a vendor report and group it by customer job

Where is Job Actual Cost Detail report?

I'm here to help you, @tlrod.

To clarify we're on the same page, are you referring to the Job Cost Detail report? If so, you can search the report in the Reports menu. I'll be glad to guide you on how.

1. Go to Reports from the left menu.
2. Type in Job Cost Detail in the search tab.
3. Then, click Run to run the report.

As EEV said, as long you've entered the Customer:Job on the vendor bill, this will show the details you need in the report.

In the top part under the Source Name column, you'll see the Customer:Job and below are vendors that are linked to the Job. Please see the image below for reference.

Also, you can check these helpful articles for reference in case you want to learn how to customize report in QuickBooks Desktop:

• Customize reports in QuickBooks Desktop
• Set report preferences

Feel free to leave a comment below if you have any other questions or concerns. I'll be around to help.

I believe the issue is that I am using QB Pro 2016 and not Contractors Edition.  

Thanks for getting back to us, @tlrod.

You're right. The Job Actual Cost Detail report is only available in QuickBooks Premier and Enterprise, not in QuickBooks Pro. However, if you're trying to run a report that shows how much you owe or have paid a vendor, you can pull up and customize the Unbilled Costs by Job report. Let me guide you how.

1. Go to the Reports menu.
2. Select Jobs, Time & Mileage.
3. Choose Unbilled Costs by Job.
4. Click the Customize Report, then go to the Filters tab.
5. Search for Billing Status from the field, then select Any.
6. Search for Paid Status, then select Open.
7. Click OK.

I've got you an article you can read on to learn more about how to customize vendor reports.

You can also read this article to know about the comparison between QuickBooks Pro, Premier, and Enterprise: Compare Features of QuickBooks Desktop.

In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBDT Self-help. 
 
Feel free to visit us again if you have any other questions with QuickBooks. We're always here to help.

Thank you this will be a helpful report.  I can get the information I need.  It is just a little clunky since I only want 1 vendor.

Hi there, @tlrod!

I'm glad to know that the report I shared get you the right amount of information you needed. But if you only want to see one vendor on the report, you can still utilize the Filters tab on the report.

To do that, just search for Preferred Vendor from the field, then select the specific vendor from the drop-down. Once done, the report will now show one vendor with the transactions filtered.

Please know that the Community team and I are always here to help. Just leave a comment below if you have any other concerns.

Hello, I have a similar problem. I would to see all transactions with only 1 vendor on 1 job. I have contractor edition. I followed the instructions above, but the "preferred vendor" filter does not do anything.  I still see all the vendors. It appears the vendor name is in the Source Name column which is not listed as a filter option. 

Hi there, bergman1.

I'll share some information about how Unbilled Costs by Job Report works.

The Preferred Vendor filter isn't applicable to this report since the vendor name is the source data. Please know that QuickBooks looks at individual transaction lines when generating the information in a report. If a line matches the report set, then the line is added to the report. I encourage visiting our Report Guide to learn more about how the program populates the data in your report.

For now, we can export this report to an Excel file then customize it from there. I'll guide you how:
 

1. Select Reports from the top menu bar.
2. Go to Jobs, Time & Mileage.
3. Choose Unbilled Costs by Job.
4. Click the Customize Report button, then set the appropriate report date.
5. Go to the Filters tab, then search for Billing Status from the field and select Any.
6. Search for Paid Status, then click Open.
7. Select OK to apply the changes.
8. From the Excel drop-down, choose Create New Worksheet then click the Export button.

In case you'll need to track where your company stands in terms of AP and expenses, we can customize the vendor reports according to your business needs.

If I can be of any additional assistance, please don't hesitate to visit the Community again. Stay safe and healthy.