The financial audit of a brand: P&L, profit bridge, loss map and checklist
How to run an express audit of a brand’s finances in one or two weeks: assemble a P&L that agrees with cash, break the profit into causes with a bridge, build a loss map and check the financial model for assumptions. The owner or the finance director uses the document to decide where money is lost, which losses to recover first and whether the numbers on which the plan and the talk with the bank are built can be trusted.
Why this document
The profit report usually shows the result but does not explain where it came from and rarely agrees with the cash in the account. The audit answers five questions: do the numbers agree, where does the margin hold, which losses hide inside the lines, does the model withstand a blow and what to do first. The document is read by the owner and the finance director before a crisis plan, a talk with a bank or an investor and before a revision of the assortment and price. It turns a set of reports into a short list of decisions with money.
At a glance
- What is this document and why is it needed?
- How to run an express audit of a brand’s finances in one or two weeks: assemble a P&L that agrees with cash, break the profit into causes with a bridge, build a loss map and check the financial model for assumptions. The owner or the finance director uses the document to decide where money is lost, which losses to recover first and whether the numbers on which the plan and the talk with the bank are built can be trusted.
- Who owns the document and how often is it rebuilt?
- Carried out by the finance director or an external analyst on the owner’s order; the audit period is the last 12 months split by quarters; the result is handed to the owner, then to the bank or the investor; repeated every six months and before an important decision.
- What mistakes are the most common?
- Brand: gross margin is counted on a single line without splitting channels → the margin on the platform and in wholesale is averaged and the wrong thing is seen → count margin and contribution by channel. Retailer: a store’s loss is assessed after general costs → points that cover rent and staff are closed → count the point’s contribution after direct costs. Brand: revenue is not reconciled with cash → part of the revenue turns out to be in the receivables of platforms or in returns → build the bridge from profit to cash without a remainder.
For whom
- Brand
- A brand’s losses hide in discounts and returns, in stock at the purchase price, in prepayments to factories and in the deductions of platforms and chains. For a brand the audit starts with margin by channel and by season and with the age of stock: that is where money is most often found. The main thing: reconcile revenue by channel with platform reports and the bank.
- Retail
- A retailer’s losses hide in the rent and staff of weak stores, in stock that does not sell, in stocktaking differences and in supplier terms. For a retailer the audit starts with contribution by store and with stock turnover. The main thing: reconcile till sales with stock and cash and find the points that do not cover direct costs.
What it consists of
What the audit checks and in what order
- Question 1: does the P&L agree with cash. Revenue from the report is checked against the bank, the till and platform reports; a difference is either a delay of money, an accounting error or lost revenue.
- Question 2: where the margin holds. Gross margin by channel, category and season and the margin bridge between periods by cause: price and discounts, channel mix, cost, freight.
- Question 3: what is hidden in losses. The loss map by line: discounts deeper than plan, returns, dead stock, lost sales, advertising without return, deductions, exchange rate, defects.
- Question 4: does the model withstand a blow. Scenarios, sensitivity and the break point of the plan: which factor must worsen for profit to become zero.
- Question 5: what to do first. Each large loss is turned into a hypothesis in the register with money, confidence, hours and an owner.
The P&L for the audit: lines and checks
- Structure: revenue after returns excluding VAT, cost of goods sold, gross profit, variable costs (marketing, logistics, commissions), contribution, fixed costs, EBITDA. For the audit the contribution matters more than the bottom-line profit.
- Reconciliation with cash: the change of cash over the period must be explained by profit, depreciation, the change of stock, receivables and payables, purchases of equipment and loans; the bridge from profit to cash must leave no unexplained remainder.
- Brand: reconcile revenue by channel: own site, platforms, wholesale, showroom; each channel has its own delay of money and its own level of returns. Check cost by materials, sewing and logistics and not by a single line.
- Retailer: reconcile revenue by till and stores; divide costs into direct (rent, store staff) and general. Count a store’s contribution after direct costs and before general ones.
Profit bridge and margin bridge
- The profit bridge shows what a gain or a fall is made of: volume at full price, price, mix, cost, costs. It answers the question “why is profit not what the plan said”.
- The margin bridge splits the change of gross margin in points by causes and leaves a remainder: a large remainder means insufficient data or an error in the accounting.
- Brand: the main causes of falling margin are discounts deeper than plan, a change of channel mix (more platforms with commission), a rise of cost from the exchange rate and freight and a provision for leftovers.
- Retailer: the main causes are lower footfall, the depth of clearance sales, stocktaking losses and rising rent and staff against falling turnover.
The loss map: how to fill it
- For each line choose a base (the amount the loss refers to), estimate the loss rate and the share that can be recovered within a year; the loss equals base × loss rate.
- Brand: typical lines are price reductions deeper than plan, returns that did not go back to sale, dead stock, lost sales, advertising above the target share, platform deductions, purchase exchange rate, defects.
- Retailer: typical lines are dead stock, stocktaking losses, loss-making stores, discounts above plan, returns to suppliers that are not accepted and staff idle time.
- Lines overlap (a deep discount and lost revenue may be one situation) so the sum gives an order of magnitude and not an exact value.
The audit checklist (template)
- 1. Revenue by channel agrees with the bank, the till and platform reports; the difference is explained. 2. Returns and their handling are recorded: how much went back to sale, how much was written off.
- 3. Stock at cost is reconciled with the records and the stocktake; the share older than six months is known. 4. The provision for the fall in stock value is created and explainable.
- 5. Receivables and payables by due date, overdue and client concentration are visible. 6. Prepayments to factories and delivery terms are compared with the sales plan.
- 7. The profit bridge and the margin bridge leave no large unexplained remainder. 8. The loss map is filled and sorted, the three main lines are named.
- 9. The model is checked on scenarios and the break point; the assumptions (price, volume, exchange rate, returns) are recorded. 10. The result is turned into a hypothesis register with money, confidence and owners.
Where the data comes from
| Data source | Fields |
|---|---|
| Management and accounting records | turnover and balance sheets, the profit report, the balance sheet, settlements with suppliers and buyers |
| Bank, till, platform and chain reports | statements, sales reports, deductions, returns, commissions |
| Warehouse and purchasing | stock at cost and age, open orders, prepayments, purchase exchange rates |
How to build it step by step
- Step 1: Fix the period (12 months by quarters), the audit owner and the list of documents; agree access to the bank, the records and platform reports.
- Step 2: Assemble the P&L for the audit by the structure of the document and reconcile revenue with cash; split the difference into delay, error and lost revenue.
- Step 3: Brand: reconcile revenue by channel with platform reports and the bank; check returns and cost by materials, sewing and logistics.
- Step 4: Retailer: reconcile till sales with stock and cash; calculate the contribution of each store after direct costs.
- Step 5: Build the profit bridge and the margin bridge between the current period and the plan or last year; a remainder above 10% means data are needed.
- Step 6: Brand: assess the age of stock and the provision for the fall in value; decide what part to sell outside the main channel.
- Step 7: Retailer: assess turnover and stocktaking losses; decide which stores to watch, renegotiate or close.
- Step 8: Fill in the loss map, sort in descending order, find the three main lines and estimate the recoverable part by an action plan.
- Step 9: Check the model with scenarios and the break point; record the assumptions and their source; prepare the hypothesis register and the presentation to the owner.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Contribution after variable costs | Contribution = revenue − cost − marketing − logistics − commissions | The contribution shows what is left to cover fixed costs; the break-even point is fixed costs ÷ the contribution share. |
| Loss and recovery per line | Loss = base × loss rate; recovery = loss × recoverable share | For lost sales the rate is the gross margin and the base is the lost revenue. |
| EBITDA after recovery | EBITDA after = EBITDA + Σ recoveries | Compare the margin after recovery with the target; gap coverage = recovery ÷ (target × revenue − EBITDA). |
Formulas in notation
- Contribution and break-even
CM = R − C − V, B = F / (CM / R)
CM: contribution; R: revenue; C: cost; V: other variable costs; F: fixed costs; B: break-even revenue.- Losses and recovery
L = Σ b_i·r_i, Q = Σ b_i·r_i·q_i
b_i: the base of a line; r_i: the loss rate; q_i: the recoverable share; L: losses; Q: the recoverable part.
Worked example
The women’s apparel brand’s P&L for the audit, 12 months (illustrative numbers)
| Line | Amount, RUB | Share of revenue, % |
|---|---|---|
| Revenue after returns, excluding VAT | 120,000,000 | 100.0 |
| Cost of goods sold | −62,400,000 | −52.0 |
| Gross profit | 57,600,000 | 48.0 |
| Marketing | −14,400,000 | −12.0 |
| Logistics, warehouse, packaging | −8,400,000 | −7.0 |
| Platform commissions | −9,600,000 | −8.0 |
| Contribution after variable costs | 25,200,000 | 21.0 |
| Fixed costs | −21,600,000 | −18.0 |
| EBITDA | 3,600,000 | 3.0 |
Gross margin 48%, contribution 21%, EBITDA 3%. The losses by the map are RUB 20.4 million (17% of revenue, 5.7 times EBITDA); the recoverable part of RUB 8.0 million lifts EBITDA to RUB 11.6 million (9.7%). The numbers are illustrative and calculated by code (the lossmap calculation).
Figures
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| Revenue | — | 120 |
| Cost of goods | −62.4 | 57.6 |
| Marketing | −14.4 | 43.2 |
| Logistics | −8.4 | 34.8 |
| Commissions | −9.6 | 25.2 |
| Fixed costs | −21.6 | 3.6 |
| EBITDA | — | 3.6 |
From revenue to EBITDA, RUB million. Gross profit of RUB 57.6 million less variable and fixed costs leaves RUB 3.6 million.
- Loss
- Recoverable
Data as a table
| Measure | Loss | Recoverable |
|---|---|---|
| Price reductions deeper than p… | 4.32 | 1.73 |
| Sales lost to empty sizes (at … | 3.46 | 1.21 |
| Dead stock: storage and cost o… | 3.15 | 1.58 |
| Returns that did not go back t… | 3 | 0.9 |
| Advertising above the target s… | 2.88 | 1.73 |
| Platform deductions and fines … | 1.44 | 0.36 |
| Unfavourable purchase rate | 1.2 | 0.24 |
| Defects and claims | 0.94 | 0.28 |
The loss map: loss and the recoverable part by line, RUB million. The three main lines give 53.6% of losses; the recoverable part is almost RUB 8 million.
- positive
- negative
- total
Data as a table
| Step | Change | Level |
|---|---|---|
| EBITDA now | — | 3.6 |
| Price reductions deepe… | +1.73 | 5.33 |
| Sales lost to empty si… | +1.21 | 6.54 |
| Dead stock: storage an… | +1.58 | 8.12 |
| Returns that did not g… | +0.9 | 9.02 |
| Advertising above the … | +1.73 | 10.8 |
| Platform deductions an… | +0.36 | 11.1 |
| Unfavourable purchase … | +0.24 | 11.4 |
| Defects and claims | +0.28 | 11.6 |
| EBITDA after | — | 11.6 |
The bridge from EBITDA now to EBITDA after recovery, RUB million. Each line adds its recoverable part; overlaps between lines are not subtracted so this is an order of magnitude.
Specifics by category
- Apparel
- Apparel: the main losses are in season discounts, dead stock and sizes; the audit looks at sell-through by season and the age of stock. For a season audit compare sell-through by week with the plan and the full-price share: that is where discounts deeper than plan are visible.
- Footwear
- Footwear: returns and losses on the size run are higher, stock per pair is dearer; the audit looks separately at returns by size and seasonal prepayment. Besides returns look at the cost of tooling per model and its payback: tooling on small lots quickly turns into losses.
- Accessories
- Accessories: margin is higher and returns lower but there is a concentration on a few hits and the gift season; the audit looks at sales concentration and the hits’ stock. For the audit look separately at the share of a few items in revenue and the seasonal gift peak: a failed peak makes a hole in the cash at once.
- Kids
- Children’s: the school season and a child’s growth make leftovers expensive; the audit checks documents under the regulation, returns by size and the application of the reduced VAT rate. Reconcile the costs of documents and tests under the regulation on a separate line and check that the correct tax rate on the goods is applied.
- Men
- Men’s: demand is steadier, losses are more often in price and purchasing; the audit looks at basic items, size availability and cost. For the audit compare the margin of basic items between periods: a small fall of margin on a permanent range gives a noticeable loss over a year.
- Women
- Women’s: more fashion and sizes, dead stock accumulates faster; the audit emphasizes the age of stock, returns and lost sales. For the audit compare the full-price share of novelties and of carried-over models: novelties carry a higher risk, carried-over ones aging stock.
Common mistakes
- Brand: gross margin is counted on a single line without splitting channels → the margin on the platform and in wholesale is averaged and the wrong thing is seen → count margin and contribution by channel.
- Retailer: a store’s loss is assessed after general costs → points that cover rent and staff are closed → count the point’s contribution after direct costs.
- Brand: revenue is not reconciled with cash → part of the revenue turns out to be in the receivables of platforms or in returns → build the bridge from profit to cash without a remainder.
- Retailer: stocktaking is done once a year → losses accumulate and are explained as “shrinkage” → introduce cyclic stocktaking and reconciliation of balances.
- They add up the losses of all lines as independent → they get an overstated sum → remember the overlaps and count an order of magnitude.
Russian specifics
- Revenue and costs for tax and accounting are kept under the accounting law; the management P&L for the audit does not replace the accounting statements but must agree with them on the totals. Rule: Law 402-FZ of 06.12.2011: Federal Law of 06.12.2011 No. 402-FZ on accounting (rule check not completed).
- Brand: inventory is valued by the rules of FSBU 5/2019 and a provision is created when value falls; for the audit it matters that the provision can be explained by age and sales. 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).
- Retailer: provisions for doubtful debts and their tax treatment are described in article 266 of the Tax Code; check the conditions for recognizing a debt as doubtful with an accountant. Rule: Tax Code Art. 266: Tax Code, Art. 266 (doubtful debt reserves) (rule check not completed).
- Brand: the VAT rate of 22% and the deduction procedure affect cash but not revenue excluding VAT; compare the P&L without VAT and cash with VAT through the bridge. Rule: Tax Code Art. 164: Tax Code, Art. 164 (VAT rates) (rule check not completed).
- Retailer: for deductions, bonuses and supplier terms reconcile the audit’s figures with contracts and acts; check the tax consequences of bonuses and returns with a tax adviser.