Net sales formula by customer segment, after discounts and returns
The short answer
Net sales equals gross sales minus discounts, returns and allowances. To see it by customer segment, join order lines to returns and discount values, assign each customer to a segment, then total the net figure per segment. Segments that look strong on gross revenue often look average, or worse, once discounts and returns come off.
Net revenue vs gross revenue by segment
Why it matters
Gross revenue flatters segments that discount heavily or return often. Net sales by segment shows which customers add revenue you keep, so you can spend your retention budget where it earns the most and stop rewarding segments whose sales mostly come back.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Start with gross sales by customer. Total the pre-discount value of every order line for each customer over the same period, across online and in store.
2. Take off discounts and returns. Subtract the discount applied to each line and the value of anything returned, including store returns.
3. Group by segment. Assign each customer to a segment, then total net sales per segment and compare it with the gross figure.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a beauty retailer. It takes 12 months of gross sales by segment, then subtracts discounts and returns matched to the same customer, online and in store.
- Promotion-led skincare buyers: $1,240,000 gross, $248,000 discounts, $96,000 returns. Net sales = $896,000, 72% of gross.
- Full-price fragrance buyers: $980,000 gross, $39,000 discounts, $49,000 returns. Net sales = $892,000, 91% of gross.
What the data shows
On gross revenue the skincare segment leads by $260,000. On net sales the two segments are almost level.
What it means
Fragrance buyers keep 91 cents of every gross dollar against 72 cents for skincare. Retention spend weighted toward skincare is buying revenue that partly comes back.
What to do
Shift some retention budget to full-price fragrance buyers, and test a smaller discount on the skincare segment's next offer.
This stops at net sales, so product cost is not yet included. Want me to add gross margin by segment?
Frequently asked questions
What is the difference between net sales and net revenue?
Net sales is gross sales minus discounts, returns and allowances. Net revenue is a broader accounting term that can also include other income and adjustments. For a retail customer question they usually give the same answer, so use whichever term your finance team reports.
Do I need to include store returns?
Yes. Online-only returns understate the gap for customers who also return in store, and some segments return mostly in person. Join point of sale and ecommerce returns to the same customer record so each segment shows its true net figure.
Should I take off the cost of goods too?
Not for net sales. Net sales stops at the price customers paid after discounts and returns. Take off product cost as a second step to see gross margin by segment, which shows whether a segment's net sales also carry healthy margin.