Report by Vendor Type and Customer: Job

Hey there, @dmancuso. 

I hope you're enjoying your day so far. 

I recommend to run a transaction detail report and customize it to fit your needs. I've included the steps below to create this report. 

1. Open the Reports menu at the top. 

2. Choose Custom Reports, then Transaction Detail. 

3. Under the Display tab, choose what columns you wish to include in the report, such as Name, Terms, etc. 

4. Next, go to the Filter tab. Here you can choose your Vendor Type or Customer Types. 

You can customize the report how you see fit. Check out, Customize reports in QuickBooks Desktop for more details about customizing reports. 

Please don't hesitate to let me know if you have further questions or concerns. I'll be here every step of the way. You can always come to the Community or me anytime you find you need help. Take care and have a good one! 

Thank you for your response, Tori!

I'm able to filter by vendor type, but I'm running into problems filtering the projects.  If I use the Name filter, select Multiple Names, then choose the Customers (projects) I want, the report is blank and I know it shouldn't be.

Any ideas?

Not the answer I was hoping for, but it makes perfect sense.  Thanks for the clarification!

So I have the same need for reporting diverse spend and realized QBs deficiency with creating a report that accomplishes what I need. So my work around solves the problem, but is of course not ideal and crude way of getting what I need.

Here is what I did:

1. In Vendor Center, select the specific vendor that is diverse

2. Edit there information by clicking the pencil

3. Under "Payment Settings", locate "Account #"

4. Input "Diverse" in this field, and click "OK"

• This of course assumes you do not use this field; you can enter "Diverse" or any other denominator you'd like.
• Note, the name your choose to input here must be exactly the same for every other vendor that qualifies as a diverse vendor.

5. Repeat steps above for every qualifying vendor

6. Next run a P&L for the specific job that had diverse spend

7. To get a basic overview of the total diverse spend for each COGS/Exp category:

• Click, "Customize Report"
• "Filters"
• Scroll down to and select: "Name Acc.Num/Note"
• Enter "Diverse" (or whatever name you originally chose for the qualifying vendors)
• Click "OK"

The P&L will now only show COGS/Exp account totals for those vendors which have this specific account number.

The one draw back is that when you double click a specific account to see the detail of each transaction (to figure out the exact spend per vendor), you will have to apply the filter for "Name Acc.Num/Note" again. Not a big deal really.

You can then just change the title of the report, memorize it, and save it for the future, needing only changing the specific job going forward.

Hope this helps! I spent a lonnnnnngggg time trying to find a better way. These seemed to work the best.