Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 14, 2022
Question

Need report! Vendor bills that are missing customer name

  • October 14, 2022
  • 5 replies
  • 55 views

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 replies

Level 9
October 14, 2022

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.

 

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.

October 14, 2022

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
Level 15
October 14, 2022

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.

 

 

October 15, 2022

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!

June 29, 2023

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!