The Vendor Performance report under Reports gives you a per-vendor scorecard for any date range. Use it for periodic vendor reviews — who’s making you money, who’s tying up shelf space without selling, and which vendor has the highest return rate.
Summary view (one row per vendor)
- Spend — total spent with this vendor in the period (vendor invoice subtotals + freight)
- Active SKUs — current count of in-stock items from this vendor (excludes returned / scrapped)
- Units Sold — units sold from this vendor’s inventory in the period
- Revenue — realized revenue (post-discount, post-trade-concession) on those units
- GM $ and GM % — gross margin in dollars and percent
- Returns # — vendor returns recorded in the period (active receipts only — voided don’t count)
Sorted by Spend by default. Click the toggle to switch to Detail view.
Detail view (one row per item)
Item-level breakdown of every sold piece in the period:
- Vendor, Type (J/W/S), Stock #, Style/Parcel, Description
- Cost, Units sold, Revenue, GM $, GM %
Use the Vendor filter (visible only in Detail view) to focus on a single vendor’s catalog.
What “good” looks like
Different shops weight these differently, but a few rules of thumb:
- GM % below 30% on a sustained basis means the vendor is undercutting your margins or you’re paying too much
- Returns # > 5% of units sold suggests quality issues
- Active SKUs high, Units Sold low = dead inventory you keep buying. Reorder less from this vendor.
- High Spend, low Active SKUs = fast-turning vendor, lean into them
- GM % above 50% with healthy units sold = your best vendors. Build deeper relationships.
Caveats
- Cost basis here is the snapshot purchase cost (per inventory row’s PurchasePrice). The Gross Profit Report uses live cost (snapshot + post-sale additional costs like recerts) and will give slightly different numbers for items with significant post-sale cost additions.
- Returns count is per-receipt-line, not per-piece — a single return receipt with a 5-piece line counts as 1.
- Vendor attribution comes from the inventory item’s VendorID. Items without a VendorID don’t appear.
- For straight purchase totals only, the simpler Vendor Purchases report has fewer columns.
Tips
- Run quarterly for vendor reviews — the date range filter lets you compare any two periods by exporting Excel and pasting into a sheet
- Combine with the Inventory Aging report — vendors whose items are aging out without selling are the ones to push back on
- A vendor with low spend but high GM % is often someone you should buy more from