Skip to main content
D
dmancuso
April 1, 2020
Solved

Report by Vendor Type and Customer: Job

  • April 1, 2020
  • 2 replies
  • 0 views

Our company is required to submit quarterly vendor diversity reports for specific projects showing how much we've paid them, and I'm looking for a report that will give me this information.  All of our vendors are set up with this information under Vendor Type, so I can easily run a report that shows the diversity status across all projects.  What I can't find is how to run a report that only shows specified projects.  For example, let's say I want to run a report showing how much we paid to each woman owned vendor for projects ABC, QRS and XYZ only. How can I do this? We do have the Customer:Job field filled out on every invoice and payment. We're using QB Premier Contractor Edition 2019 Desktop.

Thank you!

Best answer by ReyJohn_D

Thanks for keeping in touch with us here in the Community, @dmancuso.

Currently, QuickBooks doesn't have the option to filter reports by Customer Projects because the Filter option is used for the owner of the transaction. This is the reason why it's blank when you run your reports. 

However, you can export your file to Excel and add more filters in there. To export reports from QuickBooks to Excel, here's how:

1. Go to the Reports menu.
2. Choose the report/s you wanted to pull up.
3. Under the Excel drop-down, click Create New Worksheet then hit Export.



Also, you'll want to learn how to customize your reports in QuickBooks Desktop: Customize Reports in QuickBooks Desktop.

 

Feel free to post for any questions you have. I’ll be here to help. Have an awesome day ahead!

2 replies

Tori B
Tori B
April 1, 2020

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! 

 

 

D
dmancusoAuthor
April 1, 2020

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?

R
ReyJohn_DAnswer
April 1, 2020

Thanks for keeping in touch with us here in the Community, @dmancuso.

Currently, QuickBooks doesn't have the option to filter reports by Customer Projects because the Filter option is used for the owner of the transaction. This is the reason why it's blank when you run your reports. 

However, you can export your file to Excel and add more filters in there. To export reports from QuickBooks to Excel, here's how:

1. Go to the Reports menu.
2. Choose the report/s you wanted to pull up.
3. Under the Excel drop-down, click Create New Worksheet then hit Export.



Also, you'll want to learn how to customize your reports in QuickBooks Desktop: Customize Reports in QuickBooks Desktop.

 

Feel free to post for any questions you have. I’ll be here to help. Have an awesome day ahead!

    O
    OCS Builders
    March 11, 2021

    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.

     

    Terms & ConditionsAccessibility statement