Skip to main content
February 9, 2024
Question

Is there a way to create a list of vendors that we paid in the last 12 months (just the vendors for that period)

  • February 9, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

February 9, 2024

Hi there, sherryb. I'd be pleased to share some details on creating a list of vendors that you've paid for the last 12 months. 

 

We can pull up the Transaction List by Vendor report in QuickBooks Online so we can view your vendor's list. Here's how: 

 

  1. Go to Reports.
  2. Enter the Transaction List by Vendor on the search field. 

 

Once done, we can customize this report so you can meet your specific requirements and create the list you need. I'll gladly walk you through how you can personalize this. 

 

  1. On the right corner, click Customize. 
  2. Set the appropriate reporting period. 
  3. From the Rows/Columns section, uncheck all the boxes except for the Vendor.
  4. Head to Filters, then select Bill Payment (Check), Bill Payment (Credit Card), Cash Expense, Check, Credit Card Expense, Credit Card Credit, and Vendor Credit from the Transaction type dropdown.
  5. Click Run report and collapse all the vendor's names to avoid duplicates.

 

You can check the attached screenshot to see how will it looks like.

 

 

Additionally, you can check this article that will guide you on remembering your report: Memorize reports in QuickBooks Online.

 

You can always get back to this post by replying if you need further assistance with creating a vendor list in QBO. The Community space is always available for you.