Syntha Lab RU

Management report pack

A set of regular reports through which a brand and a retailer see sales, stock, turnover, customers and traffic in one language: brand, SKU, carryover, sell-out, sell-in, sell-through, receipts. It decides which indicators the manager looks at, and in what order, to spot deviations on time.

Commerce and buying Brand and retail Verified: 2026-11-13

Open interactively →

Why this document

When each department calculates indicators its own way, meetings argue about numbers rather than decisions: some call a sale the shipment, others the store till. A single pack with shared definitions ends that argument. The manager sees a short strip of key indicators and drills down only where there is a deviation. A brand gets data from retail partners on its sales and stock and can deliver sizes in time, and a retailer sees which brand performs below its promise.

At a glance

What is this document and why is it needed?
A set of regular reports through which a brand and a retailer see sales, stock, turnover, customers and traffic in one language: brand, SKU, carryover, sell-out, sell-in, sell-through, receipts. It decides which indicators the manager looks at, and in what order, to spot deviations on time.
Who owns the document and how often is it rebuilt?
Brand: analyst and the commercial director, weekly and monthly, for the owner and key customers. Retailer: analyst and category managers, daily (dashboard), weekly and monthly; partner brands receive a cut of their own sales.
What mistakes are the most common?
Reports are built from different sources → figures diverge and trust drops → one data model and definitions. Sell-in passes for sales → partner stock is underestimated → always show sell-out and stock. Too many reports → no decisions → keep only those that trigger action.

For whom

Brand
A brand keeps reports by brand, SKU and carryover and reconciles sell-in (shipments) with sell-out (sales at the customer) and partner stock. The main task is to see brand health on the partner shelf, not only shipments.
Retail
A retailer keeps reports by store, category and brand; for supplier brands it prepares a cut of sales and stock (sell-out, stock, sell-through) and reconciles with shipments. For management: receipts, UPT, traffic, conversion, sales per m².

What it consists of

Report catalog

  • Brand: Brand and SKU report: sales, margin, stock, sell-through; the share of new versus carryover.
  • Brand: Sell-in / Sell-out / stock / sell-through: SI, SO, closing stock, ST; the link: stock = opening + SI − SO − returns.
  • Retailer: Receipts: number of receipts, average basket (AOV), units per transaction (UPT); traffic, capture rate, conversion.
  • Top and low performers, defects and claims, customer (CRM) reports: cohorts, repeats.
  • The “Sell-through by category” report layout: category rows; columns opening stock, sell-in, sell-out, returns, closing stock, ST, WOS, check, UPT; filters: period, store or customer, collection season; traffic light: green ST at or above plan, yellow 5 pp below, red 10 pp or more below (thresholds are editable). Above the table cards: sell-out, ST, WOS, full-price share.
  • Customer report (CRM): the cohort of first purchases of month M; repeat purchase within 90 days = cohort customers with a second receipt ÷ cohort size; example: a cohort of 1,000 customers, 230 bought again, 90-day retention 23%. Definitions are fixed in the metric dictionary.

Frequency and audience

  • Retailer: Daily: sales and stock (operations); weekly: categories, sell-through, top; monthly: P&L, turnover, LFL; per season: collection results.
  • Retailer: Reconciliation tolerances: the sum of sell-out over stores equals the till within 0.1%; the report stock equals the warehouse ledger stock within 0.5%; the sum of categories equals the total; the same metric in two reports gives one number. A report with broken reconciliation is not sent out but returned for correction.
  • Retailer: Audience and volume: for the owner one page of five numbers (revenue, gross margin, sell-through, stock in weeks, cash) and three reasons for deviations; for the head of buying a report by categories and customers; for stores their indicators per shift. A wrong result: sell-through by the number of SKUs instead of units hides the depth of the remainder; the sign is ST rising while stock grows.

Data quality control

  • Retailer: Convergence: the sum of sell-out across stores equals POS sales; report stock equals the books; identical metric definitions.

Brand: how the document differs and what to add

  • Brand: the brand package is partner reports: sell-in, sell-out, partner stock, returns and weeks of supply; the brand reads the package as channel health.
  • Brand: example: wholesale partners received 5,000 units, sold 4,400, closing stock 11,510; sell-through 27.5%, 11.2 weeks of supply.
  • Brand: the quality of sell-out data depends on the partner: transfer date, SKU completeness, format; the brand publishes a data-quality grade with the report.
  • Brand: channel reports (wholesale, site, marketplace) are shown side by side by the brand: revenue, margin, returns, buyout; a report without channels hides the loss-making one.
  • Brand: the brand owner sees a short report: growth, margin, stock, cash, funding need; details are held by functions.
  • Brand: a customer report for a partner (its sell-through and order recommendations) helps wholesale: a partner orders more with clear analytics.

Retailer: how the document differs and what to add

  • Retailer: the retailer package is reports by category, store and channel: sales, stock, sell-through, WOS, average ticket and units per transaction.
  • Retailer: daily reports to the store manager are short (sales, traffic, conversion), weekly ones go to the category manager, monthly ones to the owner and bank.
  • Retailer: the in-season control week reconciles stock and sales by cluster: gaps between warehouse records and the till are resolved the same day.
  • Retailer: loyalty program reports (active customers, frequency, share of sales by card) are part of the package and tied to balance sheet liabilities.

How to read the result and which decisions follow

  • Category sell-through is below plan by 8 pp or more by week six of the season: freeze re-supplies and decide on transfers and price reductions; causes are analyzed in the category report, not in the summary.
  • Weeks of supply are above target by 30% or more: cut orders for the category and set a clearance plan; the brand checks the same at partners from the sell-out report.
  • Average ticket grows while the number of transactions falls: growth is not from customers; check traffic and conversion first, then decide on marketing.

Control checks

  • Stock ties in every category: opening + sell-in − sell-out − returns = closing; in total 12,000 + 7,600 − 6,640 − 145 = 12,815 units; chain sell-through 33.9%.
  • Balances in the report equal warehouse records at the date; receipts and sales agree with accounting documents (tolerance written down).
  • The same definitions (sell-through, WOS, LFL) in all reports; the same period and calendar.
  • Typical traps: sell-in mistaken for sell-out, returns inside sales, stock with the reserve in one report and without in another, a report without a generation date.

Where the data comes from

Data sourceFields
POS, CRM, countersReceipts, customers, traffic, returns.
Warehouse recordsStock, shipments, returns, receipts.
Reference books and master dataCategories, attributes, seasons, product codes (product, sales, stock templates).

How to build it step by step

  1. Step 1. Fix the metric dictionary: definitions, formulas, sources and owners.
  2. Step 2. Define the set of reports, audience and frequency; no more than needed for decisions.
  3. Retailer: Step 3. Build a single data model: product, store, date, channel; one source of truth.
  4. Step 4. Automate loading and convergence checks (POS versus books, stock versus flows).
  5. Step 5. Build the reports: tables first, then visuals; thresholds and a traffic light for each metric.
  6. Step 6. Tie actions to deviations: who does what when a metric is outside its threshold.
  7. Step 7. Check usefulness monthly: remove reports that drove no decisions.
  8. Brand: Step 8. Prepare partners a cut for their brand and agree the exchange format (EDI, files).

Formulas

MeasureFormulasNote
Sell-throughST, % = SO ÷ (Opening stock + SI) × 100SI: shipments or receipts for the period.
Closing stockStock = Opening + SI − SO − ReturnsA discrepancy with the books is a signal to check.
WOSWOS = Stock ÷ Average weekly salesUse 4-week sales or the forecast.
AOV and UPTAOV = Revenue ÷ Receipts; UPT = Units ÷ ReceiptsRevenue excluding VAT.
ConversionConversion, % = Receipts ÷ Visitors × 100Visitors from the entrance counter.

Formulas in notation

Weeks of supply
WOS = Close / (SO / (D / 7))
D is the number of days in the period; the divisor is average weekly sales.
Average ticket and units per transaction
AOV = Rev / Tx; UPT = SO / Tx
Tx is the number of transactions; AOV and UPT show what drove growth: the number of purchases or the size of one.

Worked example

A brand report at a retailer for 30 days by category (category rows are an independent example; the brand row uses Model B inputs)

CategoryOpening stock, unitsSell-in, unitsSell-out, unitsClosing stock, unitsSell-through, %WOS, weeksAOV, RUBUPT
Women5,2003,4003,0005,54034.97.98,4001.2
Men2,3001,5001,5002,28039.56.57,8401.2
Kids1,5001,1009001,67034.685,8061.45
Footwear1,9001,0007002,17524.113.39,8441.09
Accessories1,1006005401,15031.89.14,5831.13
Brand (Model B), wholesale partners11,0005,0004,40011,51027.511.2

The lowest sell-through (sold ÷ received) is in “Footwear” (24.1%) and “Accessories” (31.8%), the longest cover in “Footwear” (13.3 weeks) and “Accessories” (9.1): shipments outrun sales, so sell-in should be slowed exactly there. “Men” sells faster than “Women” (sell-through 39.5% against 34.9%). Closing stock is built by formula with returns (60, 20, 30, 25, 10 units) and reconciled with the customer stock. Brand row (Model B): sell-in 5,000 units worth RUB 12 million excluding VAT (60,000 wholesale units a year ÷ 12 at RUB 2,400), partner sell-out 4,400, sell-through 27.5%, partner cover 11.2 weeks: the brand ships more than partners sell, so partner stock grows and a second shipment wave is at risk.

Figures

Sell-through by category
Bar chart: Women 34.9, Men 39.5, Kids 34.6, Footwear 24.1, Accessories 31.8, Brand: wholesale partners 27.5010203040WomenWomenSell-through: 34.934.9MenMenSell-through: 39.539.5KidsKidsSell-through: 34.634.6FootwearFootwearSell-through: 24.124.1AccessoriesAccessoriesSell-through: 31.831.8Brand: wholesale partnersBrand: wholesalepartnersSell-through: 27.527.5%
Data as a table
MeasureSell-through
Women34.9
Men39.5
Kids34.6
Footwear24.1
Accessories31.8
Brand: wholesale partners27.5

Sell-through by category. The share of available stock sold in the period: the lowest is footwear, so re-supplies there are made with care.

Weeks of supply by category
Bar chart: Women 7.9, Men 6.5, Kids 8, Footwear 13.3, Accessories 9.1, Brand: wholesale partners 11.2051015WomenWomenWOS: 7.97.9MenMenWOS: 6.56.5KidsKidsWOS: 88FootwearFootwearWOS: 13.313.3AccessoriesAccessoriesWOS: 9.19.1Brand: wholesale partnersBrand: wholesalepartnersWOS: 11.211.2weeks
Data as a table
MeasureWOS
Women7.9
Men6.5
Kids8
Footwear13.3
Accessories9.1
Brand: wholesale partners11.2

Weeks of supply by category. How many weeks of sales sit in closing stock: the most is in footwear, and it is the category that draws money into stock.

Specifics by category

Apparel
Reports by size and color: broken runs, share of new versus carryover, sell-through of season groups; the bulk of analytics.
Footwear
A size run and last report is added, plus returns and defects (warranty and claims); WOS is higher because stock holds longer; UPT is near one.
Accessories
Reports by model and material with no sizes, shrink and losses; AOV and UPT are higher thanks to cross-selling; sell-through is less seasonal.
Kids
Cuts by age and height, school season and winter; return share and size carry-over; the basket depends on the number of children and the occasion.
Men
Repeat purchase metrics and the core share, stable reports; a customer (CRM) report with repeats matters more than seasonal cuts.
Women
Reports by micro-season, new styles and drops; sell-through of new styles in the first weeks; full-price share versus sale.

Common mistakes

  • Reports are built from different sources → figures diverge and trust drops → one data model and definitions.
  • Sell-in passes for sales → partner stock is underestimated → always show sell-out and stock.
  • Too many reports → no decisions → keep only those that trigger action.
  • No thresholds or actions → reports are just read → set a traffic light and owners.
  • Convergence is not checked → an error reaches management → automatic control checks.
  • Stock in the report is counted without returns → the difference from the ledger grows unnoticed → the stock formula includes returns and the report is reconciled with the warehouse stock.

Russian specifics

  • Customer data in CRM reports is covered by the personal data law: store and share with partners in anonymized form. Rule: Law 152-FZ of 27.07.2006: Federal Law of 27.07.2006 No. 152-FZ on personal data (rule check not completed).
  • Data exchange with partners via EDI and marketplaces follows their formats; for marked goods data is kept by Chestny ZNAK codes. 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).
  • Cash data in reports is backed by receipts under Law 54-FZ. 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).
  • Price tags with the name and the price per unit are mandatory in a store (the retail sales rules, item 3, decree 657 in force from 01.09.2026, the text was read in the register): in the defects and claims report keep a separate line “the tag price did not match the till price”. Rule: Decree 657 of 30.05.2026: Government Decree of 30.05.2026 No. 657 (rules of retail sale of goods).

Open interactively →