
The short answer
What to know before you act
Calculate product-line gross profit as net revenue minus the cost of goods sold assigned to that line. Divide gross profit by net revenue to obtain gross margin percentage. Keep returns, discounts, inventory timing and cost classification consistent, and distinguish gross margin from markup and operating profit.
- Use net revenue: discounts and returns affect the amount actually earned.
- Reconcile costs: inventory purchases are not automatically the cost of goods sold in the same period.
- Compare like with like: a cost-allocation change can alter the margin without changing operations.
A company-wide margin can hide a product line that consumes purchasing effort, rework and scarce capacity while contributing little gross profit. It can also make a healthy line look weak if costs are allocated inconsistently.
Start by agreeing what revenue and cost of goods sold mean in your accounts. A product-line comparison is useful only when those definitions and the measurement period are consistent.
Check the inputs before acting on the ranking
| What you see | What to check | Next move |
|---|---|---|
| A line has high sales but weak gross profit | Realised prices, returns and direct product costs | Investigate price, mix and purchasing economics. |
| Margin changes sharply between months | Inventory movements, cut-off and cost allocation | Reconcile accounting timing before changing the offer. |
| A low-volume line looks unusually expensive | Minimum orders, freight and consistent cost treatment | Separate structural costs from one-off batches. |
| Gross margin is positive but cash is tight | Collections, stock holdings and commitments | Build a cash view rather than treating margin as available cash. |
Two product lines with different economics
Hypothetical example · not a client case study
Suppose line A records ₹5 lakh net revenue and ₹3 lakh cost of goods sold. Gross profit is ₹2 lakh and gross margin is 40%. Line B records ₹4 lakh revenue and ₹3.2 lakh cost of goods sold: ₹80,000 gross profit and a 20% margin.
These figures do not automatically mean line B should be discontinued. It may support other sales, use otherwise idle capacity or have costs that could change. The team also checks working capital, overhead, customer relationships and the effect of removing the line. The example assumes the revenue and costs have already been classified consistently.
- 01Net salesAfter discounts and returns
- 02COGSConsistent cost assignment
- 03Gross profitNet sales less COGS
- 04DecisionMargin plus operating context
Create a product-line margin view you can trust
1. Reconcile revenue by line
Choose a period and map invoices, discounts, returns and credit notes to the product lines. Keep tax treatment consistent with your accounting records rather than treating tax collected on behalf of authorities as ordinary sales income. Ask your accountant to confirm the classification.
2. Agree the cost policy
Document the costs included in COGS, the treatment of freight and direct labour, and the basis for shared cost allocation. Reconcile opening stock, purchases and closing stock where relevant. Keep management contribution measures separate if their definitions differ from the accounts.
3. Review the commercial explanation
Compare gross profit in rupees, margin percentage and the capacity or capital required. Investigate significant movements with purchasing, sales and operations. Test a targeted price, sourcing or process change before making a product decision solely from one period’s ratio.
Put it to work
Product-line gross margin worksheet
Work through the four prompts using evidence from your business. These notes stay in this page, are not sent or saved, and disappear when you reload. Copy them before leaving.
Define the period and line
Record net sales and the adjustments included.
Reconcile COGS
Document cost policy and inventory timing with the finance owner.
Calculate the comparison
Record gross profit and gross margin using the same definitions.
Choose the investigation
Explain the movement before changing price or product range.
Choose your next step
Keep the cost policy with the report. A margin view becomes a management tool when different teams can explain the same number and connect it to a practical decision.
Further reading


