Skip to main content

Vendor Ranking Report

Assess vendor and brand performance with accurate profit insights

Updated this week

The Vendor Ranking Report in Appliance.io helps you evaluate vendor and brand performance with precision. By grouping vendors and their brands, it provides accurate reporting on sales, margins, and profits โ€” making it easier to spot trends, track performance, and make smarter, data-driven decisions.


๐Ÿ“ Accessing the Report

  • From the sidebar, click Reports

  • Select Vendor Ranking Report

Inside, youโ€™ll find two tabs:

  • By Vendor

  • By Brand


โš™๏ธ By Vendor Filters

When viewing the By Vendor tab, you can fine-tune your report using these filters:

  • Date Comparison โ†’ Choose Last 30 Days, This Month, Q1โ€“Q4, or All Time. You can compare against the previous Month, Quarter, Year, or select No Comparison.

  • Vendor Filter โ†’ Displays all vendor groups available for your selected date range.

  • Condition Filter โ†’ Defaults to โ€œSelect All.โ€

  • Reset Filter โ†’ Clears all applied filters and returns to the default view.

๐Ÿ“ค Need to share the data? Click Export to download the report in PDF, Excel, or CSV format. (The export will reflect any filters youโ€™ve applied.)


๐Ÿ” Expand vs. Collapse All

You can switch between two report views:

  • Expand โ†’ Shows vendor totals only (no brand details).

  • Collapse All โ†’ Drills down to show each vendor with their associated brands.

No matter which view you use, the data columns remain the same:

  • Sales

  • Quantity

  • Profit

  • Profit Margin

  • Change in Sales

  • Change in Quantity

  • Change in Profit

  • Change in Profit Margin

The only difference is the first column: Vendors in Expand, or Brands in Collapse All.


๐Ÿท๏ธ By Brand Tab

The By Brand tab works the same way as By Vendor:

  • Same filters

  • Same export options

  • Same data columns

The only change? It lists brands directly, without grouping them under vendors.


๐ŸŽ‰ Youโ€™re Ready!

With its flexible filters, multiple views, and export options, the Vendor Ranking Report makes it simple to evaluate both vendors and brands. Use it to measure profitability, compare performance, and guide your business decisions with confidence.

Did this answer your question?