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 is the item’s total cost: its purchase price plus every additional cost recorded on it (cert fees, repairs, recutting). It’s the same cost the Gross Profit report uses, so the two agree. For the vendor’s price alone, use the Vendor Cost Sheet.
- 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