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.