Management balance sheet
A snapshot at a date: what the company owns (cash, inventory, customer receivables) and what it owes (suppliers, the bank, customers for loyalty points). It drives decisions on how much cash can be frozen in stock, whether capital is enough for growth and whether to take on more debt.
Why this document
The P&L and cash flow show flows over a period, while the balance sheet shows the accumulated result: how much cash is stuck in stock, which debts grew, whose money the business runs on. The bank uses it to judge creditworthiness and covenants, the owner sees what the company really owns, and the finance director catches errors: if it does not balance, a payment or a stock count went missing. Without it you cannot compute inventory turnover or leverage, so you cannot tell whether growth is safe.
At a glance
- What is this document and why is it needed?
- A snapshot at a date: what the company owns (cash, inventory, customer receivables) and what it owes (suppliers, the bank, customers for loyalty points). It drives decisions on how much cash can be frozen in stock, whether capital is enough for growth and whether to take on more debt.
- Who owns the document and how often is it rebuilt?
- The finance director and chief accountant; monthly at month end, to the owner together with the P&L and cash flow; the statutory balance sheet annually.
- What mistakes are the most common?
- Inventory at retail instead of cost → the asset is overstated by the markup, warehouse profit is virtual → value at cost and reconcile with the P&L. No reserve for old collections → a pretty balance sheet that cannot be sold → compute the reserve by age and exit price. Supplier advances hidden in inventory → you cannot see how much cash is “on the way” → show them as a separate line.
For whom
- Brand
- A brand’s balance sheet is heavy in inventory and advances to factories: in Model B inventory at cost is RUB 59.324 million (48% of assets at the net 55,765 after the reserve; the share is taken on the net figure because inventory stands net in assets), wholesale receivables 22,533. Part of the stock is unsellable leftovers of past seasons that need a reserve. There are usually no loyalty liabilities but there are deferred obligations for returns and preorders. Net debt 9,649 to EBITDA 35,048 gives 0.28x.
- Retail
- A retailer holds stock on the shelf and in the DC, small receivables (acquiring in 1 to 2 days), large payables to brands and loyalty liabilities. In Model R inventory is 108,394, payables 54,579, loyalty liabilities 5,046. A separate topic is leases: under FSBU 25/2018 the lessee shows a right-of-use asset and a lease liability that our model lacks (rent is in expenses); for a bank and valuation keep a second balance sheet version with leases. Net debt 48,234 to EBITDA gives 1.39x.
What it consists of
Assets
- Cash: on accounts, in tills, in transit at the acquirer. Show restricted cash (letter of credit deposit, collateral) separately.
- Brand: Receivables: wholesale (incl. VAT, aged), settlements with marketplaces and acquiring. Overdue beyond 90 days is shown separately with a doubtful debt reserve.
- Brand: Advances to suppliers: prepayment to factories, brokers, carriers. This is money that has not yet become inventory; a critical line for a brand.
- Inventory: finished goods, materials, goods in transit, goods on commission with others (on the balance sheet while risk is retained). Valued at cost, no more than net realizable value; the reserve as a separate line.
- Retailer: Fixed and intangible assets: tooling, equipment, store fit-out, IT systems, trademarks; net book value.
Liabilities
- Trade payables: incl. VAT, by term; for a retailer the largest line. Consignment payables separately (if title stays with the supplier, they are off the balance sheet).
- Payroll and contribution debts, VAT and corporate income tax: accrued but not paid at the reporting date.
- Loyalty liabilities: unused points net of expected breakage, measured at the fair value of the future discount. Gift cards: a separate line “advances received”.
- Loans, leases (if kept under FSBU 25/2018), leasing, overdraft; short-term and long-term parts separately.
Equity
- Opening equity + net profit − dividends ± owner contributions = closing equity. This line links the balance sheet to the P&L and cash flow.
Working capital and controls
- Net operating working capital (one definition for the whole package: Balance, Working capital and CCC, Capital, ROIC and FCFF) = receivables + net inventory + advances to suppliers − payables to suppliers − payroll debt − deferred loyalty revenue. Taxes payable (VAT, profit), loans and cash are excluded. It is the amount It is the amount the business must “freeze” to operate. Its turnover sets the cash conversion cycle (CCC).
- Control checks: assets = liabilities + equity; cash = the cash flow closing balance; inventory = the stock system total; receivables = reconciliation acts.
- Models B and R do not show them, but a working balance sheet needs separate lines: VAT recoverable (the models show only net payable), prepayments of wholesale customers (preorder deposits of the brand: a liability, not revenue), a deferred tax asset on the reserve (the reserve is non-deductible, a temporary difference arises under accounting standard PBU 18/02: the norm was not checked), property tax and trading fee for the retailer (where applicable in the region).
Brand and retailer: what is computed differently
- Brand: assets hold factory advances, stock in transit and wholesale receivables; liabilities hold deferred customer preorders and return obligations; fixed assets are few (tooling, IT).
- Retailer: assets hold store and warehouse stock, store fit-out and the right of use under leases (FSBU 25/2018); liabilities hold payables to brands, loyalty liabilities and lease liabilities.
Brand: how the document differs and what to add
- Brand: the main asset is inventory: RUB 55.765 million net, 48% of the balance sheet; it includes goods in the warehouse, in transit and on consignment at partners until sold.
- Brand: receivables split into wholesale (45 days) and marketplace (14 days); wholesale partners need limits and a doubtful-debt reserve, the marketplace needs reconciliation with the agent report.
- Brand: advances to factories (RUB 4.877 million) are an asset that can be lost if delivery fails; they are kept by contract with a shipment date and checked at every acceptance.
- Brand: payables are small (RUB 9.781 million at DPO 30 days): factories and carriers demand quick payment; longer deferral is the cheapest source of cash but depends on the contract.
- Brand: brand intangible assets (trademark, collection development, software) are not valued in the model; in a real balance they are accounted for separately, while seasonal development costs are generally expensed.
- Brand: foreign-currency obligations to factories are revalued at each report date at the Bank of Russia rate; the difference is shown in the P&L, not in inventory.
- Brand: the inventory write-down reserve (RUB 3.559 million) is tied to collection age: last autumn-winter stock is valued separately from the current one.
- Brand: loans (RUB 24 million) are often taken by a brand against inventory and receivables: check covenants on net debt to EBITDA and the collateral base.
Retailer: how the document differs and what to add
- Retailer: fixed assets (RUB 66 million) are store fit-out, equipment and refurbishment: 37% of the balance sheet, with a useful life equal to or shorter than the lease term.
- Retailer: under FSBU 25/2018 the assets show a right of use of leased premises and the liabilities a lease liability; the illustrative model omits them, but they matter for debt and multiples.
- Retailer: inventory in stores, the distribution center, in transit and online: RUB 99.722 million net; it is counted by storage location to see imbalances between points.
- Retailer: supplier payables (RUB 54.579 million, DPO 60 days) finance inventory; their reduction when suppliers tighten terms hits cash harder than any expense.
- Retailer: loyalty program liabilities (RUB 5.046 million) and gift cards are deferred revenue and a cash obligation; they are valued by the probability of use.
- Retailer: receivables are small (RUB 3.41 million): acquiring and marketplace payments for the retailer’s goods; reconciled with the bank daily.
- Retailer: property tax and settlements with landlords (security deposits, rent advances) are shown in separate lines: cash frozen in leases.
- Retailer: loans (RUB 50 million) are tied to covenants on debt to EBITDA and interest cover; the threshold is breached more often when lease debt grows.
How to read the result and which decisions follow
- Inventory grows faster than revenue two quarters in a row: first check inventory age and the purchase plan, then cut orders and speed up clearance; do not borrow against inventory until this is settled.
- The equity share of assets (brand 65%, retailer 31%) is below the bank contract threshold (often 30%, check the contract): freeze dividends and new investment until it is restored.
- Overdue wholesale receivables have grown: stop shipments to the customer above the limit, agree a repayment schedule; the doubtful-debt reserve is created in the period when the risk became probable.
Control checks
- Assets equal liabilities plus equity at opening and closing (brand 116,326 = 40,795 + 75,531; retailer 176,341 = 121,679 + 54,662).
- Inventory on the balance sheet equals warehouse records at the date; a gap before stocktaking is shown as a separate line.
- Typical traps: inventory without a reserve, supplier advances inside payables with the opposite sign, loyalty liabilities in other items, a loan without accrued interest.
Where the data comes from
| Data source | Fields |
|---|---|
| Trial balance and account analytics | balances by line at the date, turnovers, counterparties |
| Stock snapshot by SKU and stock age | quantity, cost, receipt date, last sale date; the “Stock snapshot” template |
| Receivables and payables aging register | invoice, due date, amount, overdue days, reconciliation act |
| Loyalty and gift card registers | issued, redeemed, expiry, breakage share |
| Lease, loan and leasing contracts | payment schedule, rate, term |
How to build it step by step
- Step 1: Set the date and the cut-off rule: all documents up to 24:00 of the last day; shipments without acts shown separately.
- Step 2: Take account balances and group them into management balance lines; fix the account-to-line mapping once and do not change it.
- Step 3: Reconcile cash with the bank and till, inventory with the warehouse system, receivables and payables with reconciliation acts.
- Step 4: Estimate the inventory reserve by age and exit price; the doubtful debt reserve by overdue days.
- Step 5: Estimate the loyalty and gift card liability separately: points × value per point × (1 − expiry probability).
- Step 6: Show leases under FSBU 25/2018 separately (if kept): right-of-use asset and lease liability.
- Step 7: Compute equity: opening equity + profit − dividends; check that assets equal liabilities plus equity.
- Step 8: Compute working capital, net debt, DIO, DSO, DPO, CCC and the equity ratio; compare with the previous period.
- Step 9: Reconcile equity with links: profit from the P&L, cash balance from the cash flow; a mismatch means an error.
- Step 10: Show the owner four figures (cash, working capital, net debt to EBITDA, equity) and a breakdown of changes.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Balance equation | Assets = Liabilities + Equity | If it does not balance, one of the source reports has an error. |
| Working capital | NWC = Receivables + Inventory (net) + Advances − Payables − Payroll debt − Deferred loyalty revenue | The main definition for the balance sheet, ROIC and FCFF (the Lab dictionary also has the trade view: inventory + receivables − payables, used for CCC). Taxes payable are not in NWC: keep NWC with taxes as a separate line if they are large. For CCC compute trade working capital (without payroll and loyalty) in days, not in money. |
| Net debt and leverage | ND = Loans + Leases − Cash; Leverage = ND ÷ EBITDA | Whether to include FSBU 25 leases in debt, agree with the bank in advance. |
| Inventory reserve | Reserve = Σ max(0; Cost − Net selling price) | Net selling price = expected price − costs to sell; compute by age group. |
| Loyalty liability | Liability = Points × Value per point × (1 − Breakage rate) | Take the breakage rate from cohort history, not by eye. |
Formulas in notation
- Balance identity
A = L + E
A is assets, L is liabilities, E is equity; the balance always agrees if every transaction is recorded twice.- Net working capital
NWC = AR + Inv_net + Adv − AP − PP − Bon
AR is receivables, Inv_net is inventory net of reserve, Adv is advances, AP is payables, PP is payroll payable, Bon is deferred loyalty revenue.- Closing equity
E_1 = E_0 + NP − Div
E_0 is opening equity, NP is net profit, Div is dividends for the period.- Net inventory
Inv_net = Inv_gross − Res
Inv_gross is inventory at cost, Res is the write-down reserve.- Net debt
ND = Loan − Cash
Loan is borrowings, Cash is cash; for the retailer the lease liability is added if recognized.
Worked example
End-to-end example: balance sheet of the brand and the retailer at the start and end of the year, RUB thousand
| Line | Brand, opening | Brand, closing | Retailer, opening | Retailer, closing |
|---|---|---|---|---|
| ASSETS | ||||
| Cash | 12,000 | 14,351 | 20,000 | 1,766 |
| Receivables (incl. VAT) | 22,500 | 22,533 | 3,000 | 3,410 |
| Advances to suppliers | 5,000 | 4,877 | 2,000 | 5,443 |
| Inventory at cost | 52,000 | 59,324 | 100,000 | 108,394 |
| Inventory write-down reserve | −3,120 | −3,559 | −8,000 | −8,672 |
| Fixed assets and IT (net book value) | 18,000 | 18,800 | 62,000 | 66,000 |
| Total assets | 106,380 | 116,326 | 179,000 | 176,341 |
| LIABILITIES AND EQUITY | ||||
| Trade payables (incl. VAT) | 9,000 | 9,781 | 50,000 | 54,579 |
| Payroll and contributions payable | 1,500 | 1,389 | 6,000 | 3,740 |
| VAT payable | 3,800 | 3,871 | 5,000 | 7,342 |
| Corporate income tax payable | 1,600 | 1,754 | 3,000 | 972 |
| Loyalty points liability | 0 | 0 | 4,000 | 5,046 |
| Loan | 30,000 | 24,000 | 60,000 | 50,000 |
| Total liabilities | 45,900 | 40,795 | 128,000 | 121,679 |
| Equity | 60,480 | 75,531 | 51,000 | 54,662 |
| Total liabilities and equity | 106,380 | 116,326 | 179,000 | 176,341 |
| Check: assets − liabilities − equity | 0 | 0 | 0 | 0 |
| METRICS | ||||
| Net debt (loan − cash) | 18,000 | 9,649 | 40,000 | 48,234 |
| Net operating working capital (receivables + net inventory + advances − payables − payroll debt − deferred loyalty revenue) | 65,880 | 72,005 | 37,000 | 45,210 |
Control: closing assets equal liabilities plus equity (116,326 for the brand and 176,341 for the retailer). Equity grew by net profit less dividends: for the brand 60,480 + 21,051 − 6,000 = 75,531. Closing cash comes from the cash flow (14,351 and 1,766). This balance sheet feeds the working capital, cash conversion cycle and covenants in other documents.
Figures
- Cash
- Receivables
- Inventory, net
- Advances
- Fixed assets
Data as a table
| Measure | Cash | Receivables | Inventory, net | Advances | Fixed assets |
|---|---|---|---|---|---|
| Brand (Model B) | 14,351 | 22,533 | 55,765 | 4,877 | 18,800 |
| Retailer (Model R) | 1,766 | 3,410 | 99,722 | 5,443 | 66,000 |
Asset structure at year end. How much money sits in inventory, receivables, advances and fixed assets: with the brand in stock, with the retailer also in stores.
- Payables
- Payroll and taxes payable
- Loyalty liabilities
- Loans
- Equity
Data as a table
| Measure | Payables | Payroll and taxes payable | Loyalty liabilities | Loans | Equity |
|---|---|---|---|---|---|
| Brand (Model B) | 9,781 | 7,014 | 0 | 24,000 | 75,531 |
| Retailer (Model R) | 54,579 | 12,054 | 5,046 | 50,000 | 54,662 |
How the assets are funded. Payables, taxes and payroll, bonuses, loans and equity: the retailer’s assets rest on supplier payables, the brand’s on equity.
Specifics by category
- Apparel
- Apparel: stock splits by season; past seasons need a reserve, the current one does not; look at stock structure by age, not one number.
- Footwear
- Footwear: a costlier size inventory and slower turnover; the share of dead stock in tail sizes is higher, compute the reserve by size.
- Accessories
- Accessories: basic models do not age quickly, so the reserve is lower; valuable items (jewelry, leather) require inventory counts and insurance.
- Kids
- Kids: stock ages by size and season at once; leftovers cannot be carried over, a higher reserve; back-to-school preorders create customer advances.
- Men
- Menswear: more basics, less age risk, stock can be carried to the next season without losing price.
- Women
- Womenswear: fast trend change, a high share of fashion items with a short life: a higher reserve and dead stock, the balance sheet is sensitive to forecast accuracy.
Common mistakes
- Inventory at retail instead of cost → the asset is overstated by the markup, warehouse profit is virtual → value at cost and reconcile with the P&L.
- No reserve for old collections → a pretty balance sheet that cannot be sold → compute the reserve by age and exit price.
- Supplier advances hidden in inventory → you cannot see how much cash is “on the way” → show them as a separate line.
- Loyalty liabilities not recorded → a hole appears when the program changes → estimate from expiry history and reconcile quarterly.
- Receivables not reconciled with customers → false debts and wrong reserves → reconciliation acts quarterly.
- The balance sheet is not linked to the P&L and cash flow → figures disagree → fix the links in the financial model and check the identities.
Russian specifics
- The statutory balance sheet follows FSBU 4/2023 and the accounting law; the management balance sheet is broader: with VAT, advances separate, with loyalty and lease measurement. Rule: Order 157n of 04.10.2023: Ministry of Finance Order of 04.10.2023 No. 157n (FSBU 4/2023 Financial statements) (rule check not completed).
- Inventories are stated at actual cost, and at the reporting date at no more than net realizable value (FSBU 5/2019); a fall creates an impairment reserve. Rule: Order 180n of 15.11.2019: Ministry of Finance Order of 15.11.2019 No. 180n (FSBU 5/2019 Inventories) (rule check not completed).
- Leases: the lessee recognizes a right-of-use asset and a lease liability (FSBU 25/2018, from reporting for 2022); for a retailer these are large lines that change the debt burden. Rule: Order 208n of 16.10.2018: Ministry of Finance Order of 16.10.2018 No. 208n (FSBU 25/2018 Lease accounting) (rule check not completed).
- The doubtful debt reserve for corporate income tax is created under Art. 266 of the Tax Code (by overdue terms); the statutory reserve may differ. Rule: Tax Code Art. 266: Tax Code, Art. 266 (doubtful debt reserves) (rule check not completed).
- A supply contract with a deferral and title: goods on consignment stay with the supplier until sale and are not on the recipient balance sheet; check the contract (Civil Code chapter 30 on sale and the commission provisions). Rule: Civil Code part 2: Civil Code, part two (including Arts. 513, 713, 990, 1027) (rule check not completed).