Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 5, 2020
Question

Vendor (Specific) purchases Report by years (All) broken out by year

  • October 5, 2020
  • 1 reply
  • 6 views

I use Desktop Pro 2018. I would like to create a Vendor (specific) report of purchases Broken out by year for multiple years.  Basically a comparison.

1 reply

QuickBooks Team
October 5, 2020

Hello there, @tj1953.

 

When pulling up a Purchases by Vendor Summary report, you can customize the reporting period as well as the columns to have a Previous YearYear-To-Date, or Previous Period. However, running the report you need that's broken out by years is unavailable. In the meantime, you can run the report by year, then export them to excel file and merge them to view them as one. 

 

To export the report, here's how:

  1. Open the report you want. 
  2. Click the Excel drop-down arrow at the top of the report.
  3. Select whether you want to create a new worksheet or use the report data to update or replace an existing worksheet.

See this article for more information about this process: Export reports as Excel workbooks in QuickBooks Desktop.

 

On the other hand, if you want to have a more detailed version of the purchases by vendor summary report, you can pull up the Purchases by Vendor Detail report

 

For additional reference, here's a great resource about running vendor reports and how you can customize them: Customize vendor reports.

 

 If you need anything else in running vendor reports, comment down below. I'll be more than happy to answer it for you. Have a great day.