cancel
Showing results for 
Search instead for 
Did you mean: 
christianaw
Level 1

Vendor Report

Hi, I need step by step instructions on pulling a vendor report that will show all the vendors I paid in 2023 (1/1/23 - 12/31/23). I need this report to show total spend amount, transaction count, payment type (CC, ach or check), and Vendor data (ID, Name, Address, Phone Number).

1 Comment 1
KayePe
QuickBooks Team

Vendor Report

I see the importance of having a report that shows your paid transaction from vendors, @christianaw. I'm here to provide steps on how to achieve your goal using QuickBooks Desktop (QBDT)

 

To achieve your desired outcome, you will need to pull up two specific reports. Firstly, I suggest that you use the Transaction list by vendor report. This report will show you the total spend amount and the payment type. Note that the report will not populate the transaction count. You can export it to Excel to determine the number of transactions with the count function. Secondly, you should use the Vendor contact list report. This report will display all the data, providing a comprehensive overview of their contact information. To proceed, follow the provided steps below.

 

  1. In Reports, select Transaction list by vendor from the Vendors & Payables
  2. Choose the date you want to pull up in the Dates dropdown.
  3. Click the Customize Report tab and go to Filters.
  4. If you want to see the report for the specific vendor, you can tap the Name in the filters and decide who you like to pull up.
  5. Select Payment method for the filter, and tick All payment methods, then hit OK

 

transaction list by vndr.png

 

If done, you can proceed with the Vendor contact list to see their data. I'll show you how:

 

  1. From the Reports, choose Vendors & Payables, then select Vendor Contact List. 
  2. To filter the specific vendor, go to Customize report, click Filters, and select Vendor.
  3. In the All Vendors dropdown, decide what vendor you want to pull up. 
  4. Once done, tap OK.

 

vndr cntct lst.png

 

To help you more with customizing a report in QBDT, you can see this article for assistance: Customize reports in QuickBooks Desktop.

 

Please touch base with me here if you have other questions or concerns about reviewing your transaction list by vendor report. I'll be around to help you in any way I can. Stay safe!

Need to get in touch?

Contact us