cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

I need to see how much we owe or have paid a vender by job. Because i need to make sure that I am making a draw by job.

Solved
Best answer 12-10-2018

Accepted Solutions
EEV
Not applicable

Try "Job Acutal Cost Detail". As long as you entered the...

Try "Job Acutal Cost Detail". As long as you entered the "Customer:Job" on the Vendor's bill, this should work. You will probably need to build the report that works best for you.

8 Comments
EEV
Not applicable

Try "Job Acutal Cost Detail". As long as you entered the...

Try "Job Acutal Cost Detail". As long as you entered the "Customer:Job" on the Vendor's bill, this should work. You will probably need to build the report that works best for you.

Established Community Backer ***

Unbilled Costs by Job, filter (top left Customize) then F...

Unbilled Costs by Job, filter (top left Customize) then Filter on Billable status = Any, and on Paid Status = Open.
Not applicable

Re: Try "Job Acutal Cost Detail". As long as you entered the...

Where is Job Actual Cost Detail report?

QuickBooks Team

Re: Try "Job Acutal Cost Detail". As long as you entered the...

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. 1.png

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. 1.png

 

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

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

Not applicable

Re: Try "Job Acutal Cost Detail". As long as you entered the...

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

QuickBooks Team

Re: Try "Job Acutal Cost Detail". As long as you entered the...

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.

Not applicable

Re: Try "Job Acutal Cost Detail". As long as you entered the...

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.

QuickBooks Team

Re: Try "Job Acutal Cost Detail". As long as you entered the...

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.

Need to get in touch?

Contact us