Home › Finance manager toolkit › Wholesale Margin Analyzer (Excel)
Wholesale Margin Analyzer (Excel)
Paste your sales export. See who went quiet, who is under-priced, and how much gross profit that is.
Built by a finance manager who runs margin reviews on USD 200M of wholesale sales every month. Paste one export — date, invoice, customer, brand, product, salesman, qty, sales, cost — and the workbook answers the four questions a sales director actually asks:
- Which customers used to buy and have nearly stopped (QUIET flag, with the gross profit they used to bring)
- Which large accounts earn less than the house margin (UNDER-PRICED flag, with the gross profit left on the table)
- Where margin comes from by brand — share of sales vs share of gross profit
- Which salesman sells below the house margin, in points and in money
Sheets: Summary · Data (5,000 rows) · Customers (100) · Brands & Salesmen. Thresholds are yours: quiet window, pace ratio, under-priced gap, minimum account size. Sample data included so you see it working before you paste your own.
Formulas only — no macros, no add-ins. Excel 2016+, Google Sheets, Numbers.