Syntha Lab RU

Stock shrink: share, threshold and cost to profit

From book and counted stock by store it calculates shrink, its share of revenue, the comparison with your threshold and what part of gross profit it eats. Shows the worst store and a breakdown by cause.

Stock accuracy, shrink and availability For whom: Finance directors, operations and security heads of a chain.

Calculate on your data →

At a glance

What question does it answer?
How much goods we lose, whether it is above our threshold and what part of gross profit it eats.
What data is needed?
For each store: revenue excl. VAT for the period, book and counted stock at cost.
How to read the result?
Compare shrink as a percent of revenue with the threshold and between stores: an anomaly in one points to process or staff; high everywhere points to records and receiving. The share of gross profit shows the true cost of shrink for the result. Example on the default values: Shrink (net) — RUB 870,000; Shrink, % of revenue — 0.7%; Share of gross profit eaten by shrink — 1.3%; Shortages without offsetting surpluses — RUB 870,000 · surpluses RUB 0.

Why and how to reason

Inventory shrink is the difference between what should be there per records and what is there. It is measured at cost: goods were lost, not their selling price. Share of revenue = loss / revenue ex VAT: a comparable measure across stores. Share of gross profit = loss / (revenue x gross margin): how much of what was earned it eats.

Causes are divided into external theft, internal theft and process errors; what is not explained stays “unknown”. This is needed so as not to treat everything in one way: process helps against receiving errors, security against theft.

Example. Four stores: book RUB 54.5 m, actual RUB 53.63 m: loss RUB 0.87 m. Revenue RUB 131.5 m: 0.66%. Gross profit 131.5 x 0.52 = RUB 68.4 m: the loss eats 1.27%. The worst store (no. 4): 0.28 / 14.5 = 1.93% of revenue. Causes 30 + 20 + 35% are explained, 15% unknown = RUB 130.5 k.

When to use it

It is useful after a stocktake to compare stores, find the worst and judge whether measures (security, cameras, training) pay back. Assumption: the book balance is correct on the stocktake date. To limit the acceptable threshold set your own, it depends on format and category. Surpluses are netted against shortages: if you need them without offset, see the separate line. Compare losses over equal intervals between stocktakes.

How to read the result

First look at the share of revenue for the network and for each store: the worst has 1.93% against 0.66% for the network. Then the share of gross profit: even a small share of revenue can eat a noticeable part of earnings. Compare with the threshold if set. The breakdown of causes shows what to treat: 35% process errors means work on receiving and records, not on security. Decision: focus on the worst stores, measure the effect of measures at the next stocktake. Write down the acceptable loss threshold for your category and compare against it, not against others' norms. Review stores above the threshold separately: cameras, receiving processes, staff schedule, and make sure measures work.

Common mistakes

The usual mistakes: computing loss at selling price; not separating surpluses from shortages; comparing stores with different stocktake periods; attributing “unknown” causes to theft. Also: not updating the book balance to the date. Also: attributing all losses to theft, although they are often receiving errors and mix-ups, which cost less to fix than guarding.

What data is needed?

  • For each store: revenue excl. VAT for the period, book and counted stock at cost.
  • Your shrink threshold (empty by default: there is no single standard in Russia) and gross margin.
  • Optional: an estimate of cause shares.

Inputs

FieldUnitValue in the exampleMeaning
Acceptable shrink threshold% of revenue—Enter your own figure: there is no single shrink norm for apparel in Russia, and foreign averages (for example, for all US retail) do not carry over to a Russian store. Empty: no comparison with a threshold, only the actual shrink is shown.
Gross margin% of revenue52To show the share of gross profit eaten by shrink. Empty: not calculated.
Causes: external theft% of shrink30An estimate from your data; the causes add up to at most 100%. The rest is unknown.
Causes: internal theft% of shrink20The share of shrink you attribute to internal theft, an estimate from your data. The causes add up to at most 100%.
Causes: process and record errors% of shrink35Receiving, mis-sorting, unscanned sales, damage.

How it is calculated

StepFormula
Shrinkbook stock − counted stock, at cost
Share of revenueshrink ÷ revenue excl. VAT
Share of gross profitshrink ÷ (revenue × gross margin)

Worked numbers

Default values from the app; in the interactive version you enter your own.

Shrink (net)
870,000 ₽Book minus count at cost; positive is a shortage.
Shrink, % of revenue
0.7 %The single basis in Lab: shrink at cost (book minus count) ÷ revenue excl. VAT for the period. Shrink to the cost of sales gives another figure: do not compare them.
Share of gross profit eaten by shrink
1.3 %Shrink ÷ gross profit. At a 50% margin, losing 1% of revenue eats 2% of gross profit.
Shortages without offsetting surpluses
870,000 ₽ · surpluses 0 ₽Shortages without offsetting surpluses. Surpluses are a record error too.
Worst store
1.9 % · Store 4
Unknown causes
130,500 ₽The part of shrink you did not assign to any cause.
For reference: shrink to the cost of sales
1.4 %Another basis, another figure: shrink ÷ cost of sales (revenue excl. VAT × (1 − margin)). Keep the threshold and the store comparison on the “% of revenue” basis; this line is for comparing with sources that count shrink against the cost of sales.

Shrink by store

StoreRevenueShrink% of revenueAgainst threshold
Store 152 m ₽360,000 ₽0.69 %—
Store 238 m ₽180,000 ₽0.47 %—
Store 327 m ₽50,000 ₽0.19 %—
Store 414.5 m ₽280,000 ₽1.93 %—

Breakdown by your estimate: external theft 261,000 ₽, internal 174,000 ₽, process errors 304,500 ₽.

An anomaly in one store points to process or staff, high shrink in all stores to records and goods receiving. Do not confuse shrink with markdown and count all stores on one basis (stock at cost to revenue excl. VAT).

The tax treatment of shortages (VAT, profit tax) is not calculated here: check with an accountant.

Nuances and limits

  • Do not confuse shrink with markdown.
  • One basis for all stores: stock at cost to revenue excl. VAT.
  • Surpluses are a record error too, they cannot simply be “offset”.
  • The tax treatment of shortages is not calculated here.

Terms used

Calculate on your data →