cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Level 3

Purchases by Vendor Summary Report - Missing Vendors

I need to run a Purchases by Vendor Summary report for 2016. For some reason, one of my main vendors is not included in this report, but we purchased from this vendor quite a bit in 2016. Why is this report not including vendors?

 

Any help would be greatly appreciated! Thank you!

Solved
Best answer 06-25-2019

Best Answers
Highlighted
QuickBooks Team

Purchases by Vendor Summary Report - Missing Vendors

I’ll be glad to help you understand your reports, @OfficeMgr3336,

 

The Purchases by Vendor Summary report only shows the total amount for all of your vendor transactions. Let add more details about this to help you.

 

As mentioned by my colleague @Kristine Mae above, purchases made from your vendor only shows when they include inventory items. Thus, vendor transactions which have the Expenses tab filled out rather than the Items tab, won’t show.

 

In addition, if you want to view the purchases you’ve made, you can pull up the Purchases by Vendor Detail report. This way, you can customize which columns and filter to apply on the report.

 

Here’s how you can pull up and customize the report:

  1. Click on Reports from the menu bar.
  2. Choose Purchases.
  3. Select Purchases by Vendor Detail.
  4. Click on Customize Report.
  5. From the Columns box, choose which fields to add or remove.
  6. Click on the Filters tab.
  7. Select the filter you want to apply to the report.
  8. Click on OK.

Once done, you can click on Memorize to keep the report in your Memorized Reports list.

 

Please don’t hesitate to let me know if you need help with anything else. I’ll be sure to get back to you.

View solution in original post

6 Comments
Highlighted
QuickBooks Team

Purchases by Vendor Summary Report - Missing Vendors

I've tried it in my company file, OfficeMgr3336.

 

A vendor will only show on the Purchases by Vendor Summary report once you've purchased items (example: inventory item) only. 

 

You may want to pull up the Transaction List by Vendor report instead. This will show you all transactions created for each vendor in a specific date. Here's how:

  1. Click Reports.
  2. Go to Vendors & Payables.
  3. Select Transaction List by Vendor.
  4. Change the dates to 2016. 
  5. Click Refresh.

You also have the option to customize the report

 

If you have more questions, please let us know. Have a nice day! 

Highlighted
Level 3

Purchases by Vendor Summary Report - Missing Vendors

Thank you Kristine! I followed your instructions and it worked...what I am confused about is why, if we made these purchases, are they not appearing on the Purchases by Vendor Summary Report? I need to run this report as a summary only of what we purchased in 2016, without all the detail that the Transaction List by Vendor Report provides.

 

Thank you!

Highlighted
QuickBooks Team

Purchases by Vendor Summary Report - Missing Vendors

I’ll be glad to help you understand your reports, @OfficeMgr3336,

 

The Purchases by Vendor Summary report only shows the total amount for all of your vendor transactions. Let add more details about this to help you.

 

As mentioned by my colleague @Kristine Mae above, purchases made from your vendor only shows when they include inventory items. Thus, vendor transactions which have the Expenses tab filled out rather than the Items tab, won’t show.

 

In addition, if you want to view the purchases you’ve made, you can pull up the Purchases by Vendor Detail report. This way, you can customize which columns and filter to apply on the report.

 

Here’s how you can pull up and customize the report:

  1. Click on Reports from the menu bar.
  2. Choose Purchases.
  3. Select Purchases by Vendor Detail.
  4. Click on Customize Report.
  5. From the Columns box, choose which fields to add or remove.
  6. Click on the Filters tab.
  7. Select the filter you want to apply to the report.
  8. Click on OK.

Once done, you can click on Memorize to keep the report in your Memorized Reports list.

 

Please don’t hesitate to let me know if you need help with anything else. I’ll be sure to get back to you.

View solution in original post

Highlighted
Level 3

Purchases by Vendor Summary Report - Missing Vendors

Thank you SO much this completely clarified the issue...I appreciate your help so much!!

Kate

Highlighted
Level 3

Purchases by Vendor Summary Report - Missing Vendors

This makes complete sense, I really appreciate you clarifying - thank you SO much!!

Highlighted
QuickBooks Team

Purchases by Vendor Summary Report - Missing Vendors

Thank you for getting back to me, @OfficeMgr3336.

 

I'm really glad that I was to provide you with the explanation about your vendor reports. It was my pleasure to help you understand the reports you're pulling up. 

 

You can also visit our Help Articles page if you want to learn more "How do I" steps in QuickBooks Desktop. 

 

Always know that you can get back to me anytime if you have any other questions or concerns. I'll be sure to get back to you. Have a good one!

Need to get in touch?

Contact us