cancel
Showing results for 
Search instead for 
Did you mean: 
JGonzales21
Level 2

Need report! Vendor bills that are missing customer name

Does anyone have a report design that would show all vendors (also have the ability to sort by date range) that are missing a customer name?  I need to ensure our vendor bills are being linked to their appropriate customer but have not found a report design that will do so, and my customizing of existing designs is pulling the vendor name (Source Name) into the customer (Name) field which is not helping me to identify those entries that are missing the customer.  Please help!

5 Comments 5
Charies_M
Moderator

Need report! Vendor bills that are missing customer name

It's my pleasure to assist you today, JGonzales21.

 

While there isn't a specific report in QuickBooks Desktop (QBDT) that shows vendors bills with missing customer name, you'll want to run the Job Cost Detail report as an alternative. The report shows all the vendor bills that are under a Customer:Job.

 

 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. 

Once you open the report, you'll see under the Source Name column the Customer:Job. 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:

Visit us again if you need further assistance in tracking your vendors transactions. We're always here to help. Have a great day.

JGonzales21
Level 2

Need report! Vendor bills that are missing customer name

Hello,

Thank you for the suggestion, however this does not provide me with what I need.  I need to see the Bill entries which are missing the customer.  Your report suggestion will provide me with entries including the customer.  Please provide a report design/suggestion where I can obtain this information.

BigRedConsulting
Community Champion

Need report! Vendor bills that are missing customer name

RE: my customizing of existing designs is pulling the vendor name (Source Name) into the customer (Name) field which is not helping me to identify those entries that are missing the customer.

 

Unfortunately that is (I think) the only way to determine the detail lines missing a customer: If the detail line on the report has the Vendor name in the Name column, then there isn't a customer:job on that row of the bill.

 

 

JGonzales21
Level 2

Need report! Vendor bills that are missing customer name

Hi BigRed,

I ran into the same scenario, which is frustrating as my reports can run quite long.  It would be so nice to be able to identify just the entries that are blank, not having to scan over the entries that duplicate the vendor name into the customer field.  Thank you so much for trying to help.  I hope you have a great weekend!

Jrwagler
Level 1

Need report! Vendor bills that are missing customer name

I hope you found your answer already but I ran across your question and wanted to see if I could help. I think the report you could use is under Job Costing and is called Expenses Not Assigned to Jobs. Hope that helps!

Need to get in touch?

Contact us