Merchandise stock balance
The stock balance links opening stock, receipts, sales, price reductions, write-offs and closing stock in units and money, at cost and at retail price. It decides how much more to buy and how much to write off, and checks that the warehouse, accounting and sales agree.
Why this document
If closing stock does not equal opening plus receipts minus outflows, units or money were lost somewhere: a shortage, a mis-sort, an unrecorded return. The balance shows that gap by category rather than as one total. The planner takes stock in weeks of sales from it for purchasing decisions, the financial controller reconciles inventory in the company balance sheet, and the owner sees the losses. A brand keeps separate balances for its warehouse, own retail and consignment: money in goods at a client must not be mixed with its own warehouse.
At a glance
- What is this document and why is it needed?
- The stock balance links opening stock, receipts, sales, price reductions, write-offs and closing stock in units and money, at cost and at retail price. It decides how much more to buy and how much to write off, and checks that the warehouse, accounting and sales agree.
- Who owns the document and how often is it rebuilt?
- Retailer: financial controller and category manager, monthly and weekly on owner request. Brand: warehouse controller and planner, monthly, separately for the brand warehouse, own retail and goods at customers (consignment).
- What mistakes are the most common?
- The balance is kept at cost only → markdowns and real margin are invisible → keep two balances, retail and cost. Sales with VAT in one column and without in another → balances do not converge → keep the whole balance excluding VAT. Losses not shown separately → shrink dissolves into sales and record errors → a separate line.
For whom
- Brand
- A brand keeps the balance by zones: warehouse, in transit, at partners (consignment and buyout), own stores. For consignment the goods remain on the brand balance until sold, so they appear on a separate line; mismatches with the partner reconciliation are recorded separately.
- Retail
- A retailer keeps the balance in two dimensions: at cost (for accounting and the books) and at retail (for category management and OTB). The difference gives initial and maintained margin, and markdowns appear only in the retail balance.
What it consists of
Balance lines
- Retailer: Opening stock (units, cost, retail).
- Retailer: + Receipts: by supplier, transfers from other warehouses and stores.
- − Sales: revenue excluding VAT and cost of goods sold.
- Retailer: − Markdowns (retail only): the difference between the original and realized price.
- Retailer: − Losses: shrinkage, theft, write-off of defects (shrink), sorting errors.
- ± Transfers between locations; ± returns from shoppers and to suppliers.
- = Closing stock; check against the physical count.
- Brand: stock by zones (Model B, stock at cost at year end 59,324 thousand): Brand warehouse 70% (41,527); In transit (sea, customs) 18% (10,678); Consignment at partners 12% (7,119). The zone shares are illustrative; in-transit stock belongs to the brand from the transfer of title, consignment remains brand stock until sold to the end customer.
Measures below the balance
- Period sell-through: sold ÷ (opening stock + received).
- Weeks of supply (WOS) and stock-to-sales.
- Retailer: Implied margin of the closing stock: 1 − closing cost ÷ closing retail.
- Retailer: Period control checks: closing stock at retail = opening stock + receipts − sales − markdowns − losses; stock at cost from the ledger equals retail stock × (1 − closing IMU) within 0.5%; receipts equal the goods receipt documents; a difference above the threshold is resolved before the period closes, not carried to the next.
- A wrong result and how to notice it: WOS computed on the sales of one week instead of four jumps several times over and shifts purchase decisions; in the example stock of RUB 101 m at weekly sales of RUB 8 m gives 12.7 weeks, while with sales of a peak week 1.5 times higher it would show 8.5. The rule: take a rolling four weeks or the forecast.
Control checks
- The closing stock ties by formula: 96 + receipts 43 − sales 34 − price reductions 3.1 − losses 0.95 = RUB 100.95 m; second zone 40 + 18 − 14.6 − 0.4 = RUB 43 m; WOS 12.7 = stock 100.95 ÷ weekly sales RUB 7.93 m.
- Convergence: the closing stock computed by formula equals the books; the tolerance is set by policy (for example no more than 0.5% in money, an editable setting).
- Retailer: Warehouse-book stock equals the sum of stores, warehouse and in transit.
- Typical traps: receipts without a receipt date, price reductions and losses deducted twice or not at all, WOS on one week of sales, stock without goods in transit and consignment.
Brand and retailer: what is computed differently
- Brand: the brand stock balance is kept by zone: warehouse, in transit, consignment at partners; partner sell-through is reconciled with shipments (sell-in) so as not to overload wholesale.
- Retailer: the retailer stock balance is kept by category and store at retail, with the retail inventory method and accounting for markdowns and losses.
Brand: how the document differs and what to add
- Brand: the brand balance by zone: warehouse, in transit (sea, customs), consignment at partners; in Model B closing stock is RUB 59.324 million at cost.
- Brand: goods in transit are the brand’s from the moment risk passes under the delivery terms (Incoterms): the moment is written in the contract and the balance.
- Brand: consignment stock remains in the brand’s records until sold to the end customer: partner reports are reconciled with the balance every period.
- Brand: the brand balance is kept by collection and season: remnants of the past collection are shown separately with their own clearance rule and reserve.
- Brand: partner returns and factory defects go in separate lines: they return units to the balance and change the stock valuation.
- Brand: finished goods and materials (fabric, trims) in the brand balance are separated: materials at a contractor belong to the brand.
- Brand: metrics under the balance: sell-through of shipments, weeks of supply at partners and the share of stock older than a season.
Retailer: how the document differs and what to add
- Retailer: the retailer balance by point and channel: stores, distribution center, online, in transit; imbalances between points are visible at once.
- Retailer: stocktaking and shrink correct the balance to actual; the planned shrink norm is provisioned and compared with the result.
- Retailer: online returns return units to the warehouse with a delay: the balance shows them separately until condition is checked.
How to read the result and which decisions follow
- Weeks of supply of a category are above target by 30% or more (a guide): stop receipts, plan clearance and transfers; the decision is taken by category before sell-through falls.
- The share of stock older than a season grows: create a reserve and a clearance plan; the longer a remnant stays, the more its price falls, not just demand.
- The gap between the balance and the physical stocktake is above the shrink norm: investigate causes by point, do not spread the difference proportionally.
Where the data comes from
| Data source | Fields |
|---|---|
| Warehouse system (WMS) and ERP | Balances and flows: dates, SKUs, quantities, cost. |
| POS | Sales and returns by receipt: quantity, price, discount. |
| Receiving and stocktaking | Receiving documents, discrepancies, stocktake results. |
| The “Stock” template | The common stock upload format (the stock template). |
How to build it step by step
- Step 1. Close the period: post all receipts, issues, returns; fix the cut-off date.
- Retailer: Step 2. Take opening and closing stock at cost and at retail.
- Step 3. Collect receipts and transfers; reconcile receiving with supplier invoices.
- Step 4. Take revenue and COGS from POS and books; compute markdowns as the original minus the realized price.
- Step 5. Account for losses and sorting errors from the acts.
- Step 6. Compute closing stock by formula and compare with the actual; allocate the difference by cause.
- Step 7. Compute sell-through, WOS and the implied margin.
- Step 8. Roll up by category and location; flag dead stock and imbalance zones.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Retail balance | Closing = Opening + Receipts − Sales − Markdowns − Losses ± Transfers | At retail markdowns reduce stock even though goods physically remain. |
| Cost balance | Closing (cost) = Opening + Receipts − COGS − Losses | Markdowns do not appear in the cost balance. |
| Weeks of supply | WOS = Stock (retail) ÷ Average weekly sales | Use sales of the last 4-8 weeks or the forecast; a seasonal peak distorts the average. |
| Sell-through | ST % = Sold ÷ (Opening stock + Receipts) × 100 | The “Season sell-through” calculation. |
| Implied margin of stock | Stock margin = 1 − Stock (cost) ÷ Stock (retail) | A fall relative to the start of the period shows that markdowns ate the margin. |
| Sell-through in units and in money | ST (units) = Units sold ÷ (Opening units + Received units); ST (RUB) = Retail sales ÷ (Opening retail + Received retail) | Units are not mixed: in the example ST in money is 24.5%; if the average sales price is RUB 4,700 and the average stock price is RUB 5,100, the same data give 26.5% in units, because markdowns and mix lower the average sales price. For purchase decisions look at units, for finance at money. |
Formulas in notation
- Stock balance
Close = Open + Rec − Sales − MD − Sh
Open is opening stock, Rec is receipts, Sales is sales, MD is markdowns, Sh is shrink; all at retail.- Markup in stock
IMU = 1 − Cost / Retail
Cost is stock at cost, Retail is at retail; a fall shows growing price reductions.
Worked example
Retailer: a monthly balance, RUB m excluding VAT (an independent example, not tied to Models B and R)
| Line | Retail | Cost |
|---|---|---|
| Opening stock | 96 | 40 |
| + Receipts | 43 | 18 |
| − Sales | 34 | 14.6 |
| − Markdowns | 3.1 | 0 |
| − Losses (shrink) | 0.95 | 0.4 |
| = Closing stock | 100.95 | 43 |
Month sell-through is 24.5%; closing stock covers 12.7 weeks of sales. The implied margin of stock is 57.4% against 58.3% at the start: markdowns and losses consumed part of the margin. If the books show a closing stock different from the computation, the difference is assigned to sorting errors, unposted deliveries and sales errors before the period is closed.
Figures
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Opening stock | — | 96,000 |
| Receipts | +43,000 | 139,000 |
| Sales | −34,000 | 105,000 |
| Markdowns | −3,100 | 101,900 |
| Shrink | −950 | 100,950 |
| Closing stock | — | 100,950 |
Network stock balance at retail. Opening stock plus receipts less sales, markdowns and shrink gives closing stock; the control total for all document checks.
- Retail
- Cost
Data as a table
| Measure | Retail | Cost |
|---|---|---|
| Opening | 96,000 | 40,000 |
| Receipts | 43,000 | 18,000 |
| Sales | 34,000 | 14,600 |
| Closing | 100,950 | 43,000 |
Balance at retail and at cost. The same goods in two valuations: the difference is the margin embedded in stock; it shrinks if sales go through at reduced prices.
Specifics by category
- Apparel
- The balance by size and color: one SKU grows into dozens of stock positions; seeing stock by size matters most because a broken size run turns stock into dead stock.
- Footwear
- The balance is in pairs; the size run is wider (8-12 sizes), so the share of stock in extreme sizes grows fast. Pairing errors and defect tracking by last complicate checks.
- Accessories
- The balance is simpler: no sizes, fewer units of account, a high unit price and theft risk; shrink is higher, so it is shown on a separate line with its own recount policy.
- Kids
- Stock “ages” with age and season: sizes of an unsold winter collection will not fit next season, so the seasonal stock share is tracked separately; deliveries at the start of the school season are critical.
- Men
- The balance is steadier; basic items can carry over to the next season without losing price, so carryover is shown separately from seasonal stock.
- Women
- More fashion: stock devalues faster, markdowns are higher and so is the gap between retail and cost valuation; the balance is refreshed weekly and split by season group.
Common mistakes
- The balance is kept at cost only → markdowns and real margin are invisible → keep two balances, retail and cost.
- Sales with VAT in one column and without in another → balances do not converge → keep the whole balance excluding VAT.
- Losses not shown separately → shrink dissolves into sales and record errors → a separate line.
- Convergence is not checked → discrepancies accumulate → a monthly check with a tolerance and root-cause analysis.
- WOS is computed on average sales including the peak → stock is understated → use future or recent sales.
- Sell-through is counted sometimes in units and sometimes in money → the figures of two reports do not match → fix one unit of measure in the metric dictionary.
Russian specifics
- The provision for inventory impairment is computed under FSBU 5/2019; the platform does not replace accounting policy: check the method with your accountant.
- Cash receipts under Federal Law 54-FZ are the basis for sales in the balance; mismatches between POS and books must be closed before the stocktake. Rule: Law 54-FZ of 22.05.2003: Federal Law of 22.05.2003 No. 54-FZ on the use of cash registers (rule check not completed).
- Marked goods are tracked by codes: the stock of marking codes must match the books. Rule: Decree 1956 of 31.12.2019: Government Decree of 31.12.2019 No. 1956 (marking rules for light-industry goods) (rule check not completed).