Calculating the sales margin: The Complete Guide
The margin, the Gross margin , and the Markup do not measure the same thing, and confusing them distorts all the resulting pricing decisions.
Once the formulas are in place, the challenge becomes operational: tracking a margin that fluctuates weekly, item by item, and assigning each category its own target rather than a single rate recalculated once a quarter.
The profit margin is calculated as follows:selling price (excluding tax) − purchase cost (excluding tax). An item purchased for €20 (excluding tax) and resold for €50 (excluding tax) yields a profit of €30, representing a Gross margin of 60% and a Markup of 150%.
Confusing margin with markup can be costly—and it happens quietly, without ever appearing as an identified error in reports. This guide provides the definitions that matter for managing profitability—gross margin, Gross margin, Markup, multiplier coefficient, front margin, and back margin—along with their formulas and numerical examples. It then explains why managing product by product in a spreadsheet quickly reaches its limits as soon as the product assortment grows.
Sales Margin: Definition and Formula
The sales margin is the difference between the pre-tax selling price of a product and its pre-tax purchase cost. The formula is:sales margin = pre-tax selling price − pre-tax purchase cost.
In accounting, it is calculated for the fiscal year as follows: sales of merchandise minus the cost of goods sold, that is, purchases adjusted for changes in inventory.
Three ways of saying the same thing—that don't actually mean the same thing
For the same product, a management controller, a category manager, and a sales representative may cite three different figures to describe the same profitability: a margin in euros, a percentage- Gross margin , and a multiplier.
All three describe the same difference between a product's cost and its revenue, but they are not calculated in the same way, and can never be directly compared with one another without conversion.
This confusion is not just an accounting detail. It explains some of the profitability discrepancies that a retailer discovers too late—when two teams that thought they were working toward the same margin target were actually aiming for two different figures.
Companies improved their 2024 margins primarily through pricing, compared with 38% that did so primarily through volume.
(Simon-Kucher, Global Pricing Study 2025)
How to Calculate the Sales Margin: A Numerical Example
Gross margin is the starting point for any profitability calculation: the difference between the pre-tax selling price and the pre-tax cost of goods sold.
For an item purchased for €20 (excluding tax) and resold for €50 (excluding tax), the gross profit per unit is €30, representing a gross Markup of 60% (30 / 50).
Once operating expenses (logistics, personnel, rent) have been deducted, what remains is the net margin—the actual profit generated.
Details on the formulas, common mistakes, and a complete example with figures for each of these two concepts can be found in the dedicated fact sheets:gross margin and net margin.
Gross margin vs Markup : The Confusion That Costs the Most
The Gross margin expresses the margin as a percentage of the selling price excluding tax. It Markup relates it to the purchase cost excluding tax. For the same margin in euros, the two percentages are never equal: the Markup is always greater than the Gross margin.
In the previous example (margin of €30, selling price of €50, purchase cost of €20), the Gross margin is 60%, while the Markup is 150%.
Details about the formulas and how to switch between them are in the worksheet Gross margin.
A "30% margin" target set without specifying whether it refers to a " Gross margin " or a " Markup " can encompass two radically different economic realities.
Even official statistics contribute to the ambiguity. WhatINSEE refers to as “ Markup e commerciale” (gross profit) represents the ratio of profit to sales: in business terminology, this is known as a “ Gross margin.”
Average sales Markup e in the retail sector in 2023, as a percentage of sales: 20.8% in non-specialty stores, 39.1% in home goods stores.
(INSEE, Retail Ratios by Activity, 2023 data, published September 2025)
Comparing one's Markup to these averages without checking the denominator is like comparing two different quantities: 28.7% of Gross margin corresponds to approximately 40% of Markup.
Margin = selling price − purchase cost
The basic calculation, in euros. It says nothing about relative profitability unless it is compared to a benchmark.
Gross margin = margin / selling price
The standard French retail pricing convention, based on the price the customer sees.
Markup = margin / cost of goods sold
The concept of return on investment made at the time of purchase, which is more commonly used by suppliers.
Coefficient = selling price / purchase price
A third reading, expressed as a multiple rather than a percentage; details below.
The multiplier coefficient: a third interpretation of the same difference
The multiplier (or markup factor) expresses the same margin in a third form:Sales price (excluding tax) ÷ Purchase cost (excluding tax). In the previous example, the factor is 2.5 (50 / 20); the sales price is 2.5 times the purchase cost.
To use these rates as a basis for setting a price, see the sales price calculation.
This is the most commonly used method in certain industries (textiles, home decor) for quickly setting a price based on the purchase cost, without having to recalculate a percentage for each item: target selling price = purchase cost × multiplier.
It's useful for getting results quickly, but it hides the same thing as an isolated " Gross margin ": an identical coefficient across two categories can mask completely different issues related to volume and turnover.
What a discount Really Costs in Terms of Gross Margin
The main purpose of calculating the markup is to determine the cost of an item before making a decision. The most misleading situation is when there's a sale.
Let's take a product that sells for €10 (excluding tax) and is purchased for €7.50 (excluding tax): a margin of €2.50, or 25% Gross margin. A 20% discount brings the price down to €8, and the margin drops to €0.50.
To generate the same amount of profit as before, we need to sell five times as many units. Volume must increase by 400 percent, not 20 percent.
The rule can be summed up in one line: required volume = Gross margin ÷ (Gross margin − discount). The lower the Gross margin , the higher the cost of the discount, which is why deep discounts are so expensive in the grocery industry.
Conversely, a 5% price increase remains profitable as long as the volume declines by less than 16.7%. Whether this threshold will be crossed depends onthe price elasticity of demand.
Front-end margin, back-end margin: The margin doesn't end with the receipt
All of the above is calculated based on the price displayed on the shelf, which is known as the pre-tax margin.
But in the retail sector, part of a product's actual profitability lies elsewhere—in the back-end margin.
It includes the commercial cooperation agreements negotiated with the supplier: year-end rebates, compensation for product placement, and contributions to promotional campaigns.
This is a topic significant enough to warrant separate discussion: see the dedicated article in this series, which explains how these two margins are interrelated and why managing them separately changes how profitability is interpreted.
Why the margin calculated in a spreadsheet differs from reality
Calculating gross margin is simple in and of itself. What becomes difficult is keeping it accurate at scale, when a product lineup includes several thousand SKUs and purchase costs and selling prices fluctuate every week.
Supplier discounts, free shipping, purchase promotions, competitive adjustments: a spreadsheet frozen at a specific point in time gradually drifts away from reality.
Selling Price (Excluding Tax)
The starting point for the calculation—the one the customer sees and which is displayed on the web Gross margin.
Invoiced purchase cost
The gross supplier price, which is often the only one included in the spreadsheet.
Discounts and Terms of Purchase
Invoice discounts, free shipping, and purchase promotions: they affect the actual cost and are rarely updated.
Rear margin
Commercial cooperation and year-end rebates, paid separately from the sales receipt.
Actual Margin Realized
What remains once all these lines have been incorporated, and which shifts away from the displayed margin as soon as the source data changes.
The extent of this discrepancy depends on the size of the discounts and the pace of renegotiations specific to each retailer: it is measured based on actual catalog data, not on a market average.
Manage margins on an ongoing basis, not just once a quarter
The shift from one-time calculations to continuous monitoring changes the very nature of decision-making.
Continuous management first requires moving away from a one-size-fits-all approach. Different categories of traffic, revenue, and margins do not have the same optimal price, and a stable Markup can mask an ongoing drift.
The example below illustrates the impact of this single choice, which was tested on a limited range of products before being expanded.
Not the lowest price: the right price, plus a little extra margin.
The company used to apply a single " Markup " to the entire store. Now, each category has its own focus: foot traffic, sales, or profit margin. Complaints about prices being too high have disappeared, and competitors are raising their prices.
- Issue
- Rebuilding a tarnished brand image in an insular market where everyone compares prices.
- What Has Changed
- One role per category, a rating scale from A to E, and a three-month trial period before expansion.
Markup s on the products tested, over the course of a quarter.
Pricing Management · Retail Group, Caribbean. Case study written by Booper based on an actual client project; client identity has been anonymized.
At Booper, this analysis is supported by the Pricing Analytics : margin, Gross margin , and competitive positioning are continuously tracked, line by line.
Source: Interview with Hugues Lafitte, *Informations Entreprise*, September 15, 2026.
These orders of magnitude depend on the scope selected and the quality of the source data: they can be verified at your catalog, not based on an average.
Errors That Skew Margin Calculations in Retail
The most costly errors aren't formula errors. They're scope errors: a purchase cost that doesn't account for discounts, a back-end margin that's never consolidated, or a single rate applied to products that serve different purposes.
Before relying on a margin calculation, you need to ask just one question: Does the displayed margin take all purchasing terms into account, and how often is it recalculated?
If the solution involves a monthly export, the discrepancy is already in place by the time it becomes apparent.
In a chain of 90 stores (garden and home), an analysis of sales history showed that 10% of the products account for 80% of sales across the entire chain.
A simple average " Markup " for the product line therefore tells us almost nothing about actual profitability. The "Price Index " was weighted by sales volume, not calculated as a simple average.
The margin gap was then measured between products exposed to competition and the others. It is this gap—rather than the overall rate—that indicates where margins are gained or lost.
The Booper Team, price analyses based on our clients' sales history.
Do you want to make your margin management more reliable?
Spend 30 minutes with our team to objectively assess your profit margin—item by item—and track it continuously rather than just once a quarter.
See also: Essential pricing KPIs for building your dashboard.
See also in this feature
- Price Margin and Price Flexibility: How Low Can You Go Without Undermining Profitability?
- MSRP and suggested retail price: How much pricing flexibility does a retailer have?
- Market Penetration vs. Skimming: What These Two Strategies Really Cost in Terms of Margin
FAQ
The gross margin is calculated by subtracting the pre-tax purchase cost from the pre-tax selling price: Margin = Pre-tax selling price − Pre-tax purchase cost. It can then be expressed as a Gross margin r (relative to the selling price) or as a Markup r (relative to the purchase cost).
The " Gross margin " (margin as a percentage of sales) expresses the margin as a percentage of the selling price excluding tax, while the " Markup " (margin as a percentage of cost) expresses it as a percentage of the purchase cost excluding tax. For the same margin in euros, the " Markup " is always higher than the " Gross margin"; confusing the two in reporting distorts any comparison.
Markup = Gross margin / (1 − Gross margin). For example, a 40% Gross margin corresponds to a 66.7% Markup . The inverse relationship is: Gross margin = Markup / (1 + Markup).
The multiplier (or markup) is the ratio of the selling price (excluding tax) to the purchase cost (excluding tax). A multiplier of 2.5 means that the product sells for 2.5 times its purchase cost; this is a third way of expressing the same difference as the margin or the Gross margin.
Most often, this is because the purchase cost recorded in the file does not include the latest supplier discounts, or because a formula copied across several thousand rows contains an error that goes unnoticed.
A calculation that is fixed at a specific point in time automatically shifts as soon as the source data changes upstream without a manual update.
The gross margin is calculated based on the price displayed on the shelf (selling price minus the invoiced purchase cost).
The back-end margin includes payments made separately by the supplier to the retailer (commercial cooperation, year-end rebates)—a portion of the profit that does not appear on the sales receipt.
According to INSEE, the retail trade com Markup t was 28.7% in 2023, and 20.8% in non-specialty stores, including large grocery stores.
Note the denominator: INSEE reports the margin as a percentage of sales, which corresponds to a " Gross margin." Expressed as a " Markup " of the cost of goods sold, 28.7% is equivalent to approximately 40%.
In the fashion and selective retail industries, the wholesale markup is the percentage that a brand applies to its cost of goods sold to set its wholesale price. The retail markup is the percentage that a retailer applies to that wholesale price to set its selling price.
Always check whether it is calculated based on a selling price excluding tax or including tax: a "tax-inclusive" multiplier includes VAT and therefore appears more favorable than it actually is.
First, protect the products that define the price image (KVI) and focus on maximizing margins on the rest of the product lineup, where price sensitivity is lower. Then, measure the impact through simulation before rolling out the strategy.
Product-based evaluation is broken down into margin, competitiveness, and price image, and the measurement is described in "Measuring a Retailer's Price Image."
Sources: Simon-Kucher, Global Pricing Study 2025 · INSEE, Trade Ratios by Industry, 2023 annual data, published September 18, 2025 · Hugues Lafitte, interview with *Informations Entreprise*, September 15, 2026 · Booper pricing feedback and analyses (anonymized clients)
Management doesn't approve a price; it approves a trade-off between margin, volume, and price image. Presenting a single recommendation means asking management to trust you. Presenting the cost of each option gives management the information it needs to make a decision.
A sound projection provides a range rather than a single figure, specifies what is being excluded, and anticipates the gap between the projected increase and the actual increase. When compared with actual results, it establishes the credibility of the next projection.
A franchisor cannot impose a minimum resale price: doing so is punishable by law; the franchisor may only recommend a price or set a maximum. A franchisee’s margin is therefore governed by a documented target, defined by network segment and applied uniformly across each segment.
The best indicator of this governance is not adherence to the suggested retail price, but the rate of compliance with it by segment. A suggested retail price that franchisees in a given area do not follow often signals a poorly set price, not a lack of discipline.
Optimix merged with Maxxing in July 2025, and PricingHUB was acquired by Akeneo in June 2026. For their customers, the question of the independence of the pricing roadmap has become a legitimate concern.
What sets a query apart in France isn't the processing speed: it's the native support for French rules, pricing by store or by zone, the validation process, and testing with your own data.