Connect with and learn from others in the QuickBooks Community.
Join nowI 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! Go to Solution.
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.
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.
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.
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:
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.
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:
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.
I am using QuickBooks online and I don't have the option to choose "job acutal cost detail" under reports. What I need is an open vendor bill/expense report for a specific job so we know what vendors we need to pay for that job.
Hey there, @blockheadnc.
Thanks for joining in on this thread and letting us know you use QuickBooks Online (QBO) instead of QuickBooks Desktop (QBDT). Allow me to give you the right steps for this information in your account.
Let's go through the instructions on how to get this report. Here's how:
Afterward, you can hit the Customize button to edit certain settings to see the information you want/need.
This should do the trick. Feel free to ask if you have any other questions. I'm always here to lend a helping hand. Take care!
I use QuickBooks Online, I don't have those options
Thanks for following up with the Community, blockheadnc.
Our Projects feature is only available with a Plus, Advanced, or Accountant subscription. If you're already subscribed to one of these plans, you'll want to confirm it's turned on.
Here's how:
Now you'll have a Projects tab in your left navigation bar.
In the event you're using Simple Start or Essentials, you can upgrade anytime to utilize Projects:
I've additionally included a detailed resource about working with projects that may come in handy moving forward: Create & manage projects
I'll be here to help if there's any questions. Have an awesome day!
I have the projects tab but only a few came up on that list. We have a few thousand job/project numbers in our system.
I’m here to help so you’re able to generate an open vendor bill/expense report for a specific job in QuickBooks, @blockheadnc.
In QuickBooks Online, you’ll want to make sure the vendor is set up and link properly to a project. This way, all related bills or expenses to that vendor will show up on your list.
If everything is set correctly, cached data might be the reason why the Projects page only came up with a few events on the list. You can perform some troubleshooting steps to resolve this.
You can start accessing your QBO account in a private or incognito window for testing. Refer to these key shortcuts for quick navigation:
Once signed in, check your project list if it’s now complete. If yes, get back to your main browser and clear its cache to start fresh. You can also utilize other supported browsers as an alternative.
You can run the Unpaid Bills or Vendor Balance Detail reports in QBO. This way, you’re able to know what vendors you need to pay for that job. Here's how:
You can visit these resources to learn more about projects:
If you need further assistance with your projects and reports, add a comment below. We'll always be around. Take care!