"Profit margin" in retail means two different numbers, and most arguments about it come from mixing them up. Gross margin is what's left of a sale after paying for the thing sold: sales less the cost of the goods, as a share of sales. Net margin is what's left after everything else too: rent, wages, card fees, shrink. A shop can make 50% gross and 5% net and both are true. In the example below, a made-up gift shop sells $38,000 in a month at a 49.0% gross margin and has 13.6% left, $5,177, before the owner is paid. Below is the month line by line, what each line contributes, where the other 35 points go, and a calculator. Every figure is the example's own, and no two shops share them.
The short version
- Gross margin = (sales − cost of the goods sold) ÷ sales.
- Net margin = what's left after every expense ÷ sales.
- Work out gross margin by line. The average hides the lines that carry the shop.
- A line's share of gross profit matters more than its share of sales.
- Markdowns and shrink come out of margin before rent does.
- Sales needed to cover expenses = expenses ÷ gross margin.
- TaroStack values the stock and shows margins on what things actually cost. More below.
The month, by line
| Line | Sales | Cost of the goods sold | Gross profit | Gross margin | Share of sales | Share of gross profit |
|---|---|---|---|---|---|---|
| Gifts and home goods | $14,200 | $7,100 | $7,100 | 50.0% | 37.4% | 38.1% |
| Cards and stationery | $5,400 | $2,160 | $3,240 | 60.0% | 14.2% | 17.4% |
| Candles and bath | $6,800 | $3,536 | $3,264 | 48.0% | 17.9% | 17.5% |
| Local food and drink | $4,300 | $2,795 | $1,505 | 35.0% | 11.3% | 8.1% |
| Jewelry and accessories | $5,900 | $2,596 | $3,304 | 56.0% | 15.5% | 17.7% |
| Sale rack | $1,400 | $1,190 | $210 | 15.0% | 3.7% | 1.1% |
| Total | $38,000 | $19,377 | $18,623 | 49.0% |
The rep was nearly right, about one number. Gifts make exactly 50%: bought at half the price on the tag. The shop as a whole makes 49.0%, because the lines around it differ.
Cards carry more than their weight. 14.2% of sales and 17.4% of gross profit, at a 60% margin. They take one spinner of floor space.
Food carries less. 11.3% of sales and 8.1% of gross profit, at 35%. That doesn't make it a mistake: jam and coffee bring people in who buy a card. It makes it a line to keep small on purpose.
The sale rack is where margin goes to die. $1,400 of sales on goods that cost $1,190. At the shop's usual 50%, the same goods were tagged at $2,380. The $980 of markdowns never shows up as an expense. It's simply missing from gross profit. The sum behind a markdown is in retail markdown formula.
From gross to what's left
| Amount | Share of sales | |
|---|---|---|
| Sales | $38,000 | 100.0% |
| Cost of the goods sold | $19,377 | 51.0% |
| Gross profit | $18,623 | 49.0% |
| Shrink and damage | $570 | 1.5% |
| Card fees | $1,026 | 2.7% |
| Rent | $4,200 | 11.1% |
| Wages, two part-time staff | $5,600 | 14.7% |
| Utilities, phone, internet | $520 | 1.4% |
| Insurance | $310 | 0.8% |
| Bags, tissue, supplies | $380 | 1.0% |
| Marketing | $450 | 1.2% |
| Software and bookkeeping | $390 | 1.0% |
| Total expenses | $13,446 | 35.4% |
| Left, before the owner's pay and tax | $5,177 | 13.6% |
Rent and wages are $9,800 of the $13,446, nearly three quarters. They don't move with sales, which is why a slow month hurts so much more than its sales suggest.
The break-even. Expenses ÷ gross margin: $13,446 ÷ 0.49 is about $27,400 of sales. Below that the month loses money. Above it, about 49 cents of each extra dollar is kept, less card fees.
The 13.6% isn't profit yet. The owner works the shop five days a week and isn't in the wages line. Pay the owner $4,000 and the net margin is 3.1%.
What moves it
| If | Gross profit | Left | Change |
|---|---|---|---|
| As it is | $18,623 | $5,177 | |
| Gross margin falls five points, to 44% | $16,720 | $3,274 | −37% |
Five points of gross margin is more than a third of what's left. Five points is easy to lose: a supplier's price rise not passed on, a bigger sale rack, a little more shrink.
- Buying. Margin is made when the order is placed. Freight in is part of the cost: a $6.00 candle with 60 cents of freight costs $6.60.
- Markdowns. Buy less of what's uncertain. A sold-out line costs a few sales. An overbought one costs the margin on everything left.
- Shrink. Theft, damage and miscounts were 1.5% of sales here. A shop only knows its own number by counting: see store inventory sheet. How a grocer looks at it is in grocery store shrink.
- Mix. Moving a display from food to cards changes the month more than a price rise would.
How fast the stock turns is the other half of the picture: see inventory turnover example. The difference between margin and markup is in markup vs margin.
Get the calculator
Download the retail profit margin calculator. Two sheets and a read-me: the month by line, with gross profit, gross margin and each line's share worked out, and a second sheet from gross profit down to what's left. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The whole table rests on "cost of the goods sold", and a shop that doesn't track stock doesn't know it. It knows what it paid suppliers this month, which is a different number: it includes boxes still in the back room and leaves out last month's stock sold today. Without a count at the start and the end, the 49.0% is a guess, and the line-by-line margins can't be worked out at all.
How TaroStack does it
TaroStack keeps the stock, so the cost of what sold is a fact.
Each delivery comes in at what you paid, freight included.
Stock value by month, so the cost of the goods sold comes from what left the shelf, not from what was bought.
Margins on what things actually cost, by product.
Counts on a phone, with what a difference is worth shown before you post it.
Adjustments carry a reason: damaged, lost, expired, a correction. Shrink becomes a number with causes.
| The number | Spreadsheet | In TaroStack |
|---|---|---|
| Cost of the goods sold | Purchases, roughly | From stock that left |
| Margin by product | Not possible without a count | On what each cost |
| Shrink | The gap, found once a year | Adjustments, by reason |
| What the stock is worth | A year-end count | Stock value, by month |
TaroStack isn't an accounting system: rent and wages stay in your books. It connects to Square. Stock, counts and margins are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
