Skip to main content
February 20, 2024
Question

Generating Sales Report for items purchased from a specific Vendor

  • February 20, 2024
  • 1 reply
  • 0 views

Hi! 

 

I am trying to generate a sales report or a report of the the amount we invoiced by year, 2023, 2022, 2021, 2020, 2019. I need to limit this report to include only the items we sold that had been purchased from a specific vendor. How would i go about generating this report? When I have tried to generate a sales report that has been customized to filter for a specific preferred vendor only the report has still included invoices for items purchased from other vendors. What am I missing here?

 

Thanks! 

Annie 

1 reply

February 20, 2024

Hello there, Annie.

 

We'll have to generate two sets of reports to gather all the data you need. We're here to guide you on how to do this below.

 

For the items you sold for the specific year, we'll pull up and customize the Sales by Item Summary report, and for your purchases, run Purchases by Vendor Summary. Then, make sure to Filter their dates and by your Preferred Vendor

 

 

After that, export both reports as Excel workbooks to merge the accumulated data and create a single record.

 

Also, you can consider memorizing the previously mentioned reports to retain the same settings for future use.

 

We're always ready to lend a hand if you have any other reporting concerns or questions about managing sales and expenses. Don't hesitate to leave a reply below. Have a good day ahead. 

DometricsAuthor
February 20, 2024

Thank you very much! What do you mean by merging the reports in Excel?