Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
An annual financial plan made of linked budgets: sales, purchases, expenses, marketing, staff, investment and cash. The owner takes spending limits from it for each block, and the team gets targets and decision limits: how much can be spent without approval and what to do when results deviate.
Why this document
A budget turns strategy into numbers that can be checked. Without it each manager asks for money separately and the sum of requests exceeds what exists. The finance director consolidates the requests and sees whether cash and covenants hold, the owner approves limits, and budget owners know what they answer for. That is why the budget is built as a linked set: the sales plan drives purchasing, purchasing drives cash, and cash tests loan terms. Without the links the figures look tidy and a gap appears mid-year.
At a glance
- What is this document and why is it needed?
- An annual financial plan made of linked budgets: sales, purchases, expenses, marketing, staff, investment and cash. The owner takes spending limits from it for each block, and the team gets targets and decision limits: how much can be spent without approval and what to do when results deviate.
- Who owns the document and how often is it rebuilt?
- The finance director compiles; line owners (commercial director, marketing, HR, operations) submit their budgets; the owner or board approves; revised quarterly.
- What mistakes are the most common?
- The budget is assembled from separate files → the figures do not tie between P&L, cash budget and balance sheet → one linked model. A top-down target is cascaded without a bottom-up check → the plan is unrealistic, the team does not believe it → reconcile both approaches and record the gap and decisions. Purchases computed from revenue, not from COGS and stock → overstock → derive purchases from COGS, target stock and IMU.
For whom
- Brand
- A brand budget starts from the collection: the channel plan (wholesale, site, marketplace) sets production volume, then the purchase and prepayment budget, and only then expenses. In Model B the bottom-up gives revenue of RUB 206.665 million against the owner target 211,600: a gap of -4,935. The purchase budget 97,546 sets prepayments to factories and the cash need before the season.
- Retail
- A retailer budget starts from stores: traffic × conversion × basket by outlet (and online), then the purchase budget (OTB), rent and staff by store. In Model R the bottom-up is 510,159 against the target 517,440: a gap of -7,281. The purchase budget 272,152 must fit the OTB, otherwise stock grows faster than sales.
What it consists of
Components of the budget system
- The P&L budget: a forecast income statement by month and channel; the basis for corporate income tax and EBITDA estimates.
- The cash budget: when and how much cash comes and goes; the basis for the payment calendar and funding decisions.
- The purchase budget: how much goods and materials to order by date and category; linked with OTB and production lead times.
- The marketing budget: by channel, with a revenue or ad-cost-ratio target and payback control.
- Retailer: The payroll budget: headcount plan, rates, bonuses, contributions, turnover; for a retailer by store from traffic norms.
- The CAPEX budget: refurbishments, openings, equipment, IT with a payback calculation for each project.
- The monthly template: rows of P&L and cash budget lines, 12 month columns, a year total and seasonal coefficients on a separate line (month share of annual revenue); the cumulative total runs as a running sum. Without a monthly split and seasonality coefficients an annual budget is not fit for control.
How the documents link
- Sales plan → P&L revenue. Revenue and target stock → purchase budget: purchases = COGS + closing − opening inventory. Purchases and payment terms → cash budget. All together → year-end balance sheet.
- A change in one budget recomputes the others: so the budget lives in a linked model, not in separate files.
Top-down and bottom-up order
- Top-down: the owner sets targets (revenue growth, EBITDA, debt ceiling); finance cascades them to channels and units. Fast, but targets may be unrealistic.
- Retailer: Bottom-up: every store and channel builds its plan from drivers (traffic, conversion, basket, assortment width), finance sums them. Realistic, but may be sandbagged.
- In practice: reconcile both approaches and close the gap with a list of concrete decisions (a new store, a promo with proven payback, a price rise), not by stretching conversion.
Brand and retailer: what is computed differently
- Brand: the budget starts from the collection: the channel plan sets the production volume, then the purchase and factory prepayment budget, and only then costs; the key check is minimum batches and order windows.
- Retailer: the budget starts from stores: traffic × conversion × check by store and online, then OTB by category, rent and staff by store; the key check is purchasing within OTB and IMU.
Brand: how the document differs and what to add
- Brand: the budget starts from the production order and factory MOQs rather than weekly sales: the order is placed one or two seasons ahead and determines the whole cash flow.
- Brand: the sales plan is built by channel: wholesale (60,000 units), site (9,000), marketplace (11,000); each has its own return rate, commission and payment term.
- Brand: wholesale partner preorders drive the purchase: the budget is split into a confirmed part and a reserve for top-ups; without this stock piles up against unconfirmed demand.
- Brand: the marketing budget is set from channel revenue and target customer cost, separately for the platform and the site; a blanket percentage of revenue hides loss-making channels.
- Brand: the collection development budget (samples, patterns, photoshoots, showroom) is expensed before revenue appears and needs its own line by season.
- Brand: the cash budget includes advances to factories (5% of purchases in the model), import payments and the foreign-currency part; the rate is set in the base and the stress variant.
- Brand: wholesale receivable limits enter the budget as a shipment constraint: a customer above the limit is not shipped until the overdue amount is paid.
- Brand: brand capex is tooling, IT, showroom and warehouse: small in amount, but the season sets their timing, so they are in the budget by quarter.
Retailer: how the document differs and what to add
- Retailer: the budget starts from the store plan: traffic, conversion, average ticket and space; network revenue is the sum of points, not a general growth rate.
- Retailer: the store plan separates comparable and new points: a new store reaches capacity in 2 to 3 years, and the budget carries a ramp curve rather than mature revenue.
- Retailer: the purchase budget follows OTB by category and season: sales, markdowns, shrink and closing stock minus opening stock and what is on order.
- Retailer: price reductions (15% in stores and 18% online) are put into the revenue budget as a separate line: the planned margin without them is overstated.
- Retailer: the rent budget is computed from contracts with indexation and turnover rent: RUB 42.336 million a year; it is reviewed at every renewal.
- Retailer: the store staff budget depends on shift schedules and hourly traffic rather than headcount tables; the variable part is tied to sales.
- Retailer: the capex budget is store openings and refurbishments (RUB 15 million in the base): each project goes through an investment case, and only approved ones enter the budget.
- Retailer: the loyalty program and card discounts are planned as deferred revenue and a margin offset: without this loyalty growth shows up as a fall in profit.
How to read the result and which decisions follow
- Revenue actuals below plan by more than 5% two months in a row (set the threshold in the budget policy): revisit purchasing and costs for the rest of the period rather than waiting for the quarter end.
- The budget agrees on profit but the quarterly cash minimum is below the fixed base: a profitable budget is not approved without a cash plan; move the purchase or payment or arrange a line before the season starts.
- Costs grow faster than revenue: check which lines are fixed and freeze new commitments until the forecast is revised; cancellable costs are cut by priority, not proportionally.
Control checks
- Budget revenue and costs equal the forecast sum by channel and department; the sum of quarters equals the year.
- Purchases from OTB equal supplier payments in cash after payment terms (brand: purchases RUB 97.546 million).
- Typical traps: the bottom-up budget does not match the top-down target and this is hidden, functions hold different cost versions, VAT is treated inconsistently in cash flow, there is no reserve for the seasonal peak.
Where the data comes from
| Data source | Fields |
|---|---|
| Sales plan by channel, store, category and season | traffic, conversion, basket, seasonality, preorders, LFL |
| Last year actual P&L, cash flow and balance sheet | revenue, gross margin, expenses by line, balances, DIO, DSO, DPO |
| Contracts: leases, suppliers, loans, contractors | rates, indexation, payment schedules, terms |
| Headcount plan and staffing norms | positions, rates, bonuses, norms by traffic |
| Macro inputs for assumptions | FX rate, inflation, key rate, VAT rate; take current values from the Bank of Russia and the Ministry of Finance |
How to build it step by step
- Step 1: Approve assumptions: FX rate, inflation, VAT rate, loan rates, rent indexation, payroll growth. They are the same for all budgets.
- Step 2: Set targets top-down: revenue growth, EBITDA margin, debt ceiling, minimum cash balance.
- Retailer: Step 3: Build the sales plan bottom-up by channel, store and category; the seasonal monthly split.
- Step 4: Compute gross margin: prices, reductions, cost, losses; for a brand by style, for a retailer by category.
- Step 5: Derive the purchase budget from COGS and target stock; reconcile with OTB and production lead times.
- Step 6: Collect expense budgets from line owners: marketing, payroll, rent, IT, logistics, management.
- Step 7: Assemble the P&L budget and find EBITDA, tax and net profit; compare with the top-down target.
- Step 8: Assemble the cash budget by month or week: receipts by payment terms, payments by schedules; find the minimum balance.
- Step 9: Close the gap between target and plan with decisions and estimated effects; make sure the balance sheet ties.
- Step 10: Approve the budget, assign line owners and limits; set a monthly plan versus actual and a quarterly revision.
Formulas
| Measure | Formulas | Note |
|---|---|---|
| Purchase budget | Purchases = COGS + Closing stock − Opening stock + Losses (shrink and returns to the supplier) | Closing stock = COGS × DIO ÷ 365 or weeks of cover × the sales forecast of the next period. Compare the purchase budget at cost excluding VAT with OTB at retail prices only through purchase IMU: OTB at cost = retail OTB × (1 − IMU), otherwise different quantities are compared. |
| Marketing budget | Marketing = Revenue target × ad-cost ratio (or % of revenue) by channel | The ratio is computed on revenue excl. VAT; cap it by payback. |
| Payroll with contributions | Payroll = Σ(rate × headcount) × (1 + bonus) × (1 + contributions) | Contributions are also charged on the bonus, so the multipliers are multiplied, not added. Set the contributions tariff as a parameter (30% general, lower for SMEs), not a constant; mind the cap base (see the contributions calculation). |
| Plan gap | Gap = Bottom-up plan − Top-down target | A negative gap is closed with decisions with an estimated effect. |
| Minimum cash balance | Minimum balance = min by quarter or week (Opening balance + Inflow − Outflow) | Compare with the buffer and arrange funding in advance. |
Formulas in notation
- Budget revenue
Rev = Σ_c Σ_s U_cs · P_cs · (1 − r_c)
U_cs is planned units of channel c in season s, P_cs is the price excluding VAT, r_c is the channel return share.- Purchase budget (OTB)
OTB = S + MD + Sh + EOP − BOP − OO
S is sales, MD is markdowns, Sh is shrink, EOP is closing stock, BOP is opening stock, OO is already on order.- Closing stock
EOP = S_next / W · C
S_next is next-period sales, W is the number of weeks in it, C is the weeks of cover we want at the end.- Variance to budget
Δ% = (Fact − Plan) / Plan
A positive value for costs is an overspend, for revenue an overperformance; the review threshold is set by the budget policy.
Worked example
End-to-end example: linked annual budgets of the brand and the retailer, RUB thousand
| Budget | Brand | Retailer | How it links |
|---|---|---|---|
| TOP-DOWN AND BOTTOM-UP | |||
| Last year revenue | 184,000 | 462,000 | |
| Owner target, growth % | 15 | 12 | |
| Revenue target (top-down) | 211,600 | 517,440 | last year × (1 + growth) |
| Channel and store plan (bottom-up) | 206,665 | 510,159 | sum of channel plans |
| Gap: bottom-up − top-down | −4,935 | −7,281 | closed by decisions, not by stretching |
| P&L BUDGET | |||
| Net revenue | 206,665 | 510,159 | |
| Gross profit before reserve | 116,443 | 246,401 | |
| Marketing budget | 18,600 | 30,610 | 9% and 6% of revenue |
| Payroll budget with contributions | 33,800 | 91,000 | headcount × rate × (1 + bonus) × (1 + contributions); the bonus is included in the rate in the model |
| EBITDA | 35,048 | 34,800 | |
| Net profit | 21,051 | 11,662 | |
| PURCHASE AND CAPEX BUDGET | |||
| Cost of goods sold | 90,222 | 263,758 | |
| Closing inventory (by DIO) | 59,324 | 108,394 | |
| Opening inventory | 52,000 | 100,000 | |
| Purchase budget = COGS + closing − opening inventory | 97,546 | 272,152 | the main link of P&L and cash budgets |
| CAPEX (excl. VAT) | 4,000 | 15,000 | |
| CASH BUDGET | |||
| Operating cash flow | 19,231 | 18,066 | |
| Investing and financing | −16,880 | −36,300 | |
| Closing cash for the year | 14,351 | 1,766 | |
| In-year minimum balance | −3,500 | −15,898 | a funding need |
How to read: the P&L budget gives EBITDA 35,048 and 34,800; the purchase budget is derived from COGS and target stock, not from thin air; the cash budget shows that despite a positive profit the in-year minimum balance is -3,500 for the brand and -15,898 for the retailer: a funding need that neither the P&L nor the year-end balance reveals.
Figures
How the budgets connect: from the sales plan to the balance sheet. An arrow shows whose result feeds the next document; figures are from the brand Model B.
- Sales plan by channel: 206,665 → Purchase budget: 97,546; P&L: EBITDA 35,048
- Purchase budget: 97,546 → P&L: EBITDA 35,048; Cash flow: closing cash 14,351
- Expense and headcount budget → P&L: EBITDA 35,048
- P&L: EBITDA 35,048 → Cash flow: closing cash 14,351; Balance sheet and covenants
- Capex: 4,000 → Cash flow: closing cash 14,351
- Cash flow: closing cash 14,351 → Balance sheet and covenants
- Balance sheet and covenants
- Receipts
- Operating payments
- Investing and financing
Data as a table
| Measure | Receipts | Operating payments | Investing and financing |
|---|---|---|---|
| Q1 | 55,462 | 61,187 | 0 |
| Q2 | 60,504 | 59,399 | 10,880 |
| Q3 | 65,545 | 57,036 | 0 |
| Q4 | 70,587 | 55,245 | 6,000 |
Brand receipts and payments by quarter. The quarterly cash budget: receipts grow towards year end, supplier payments fall, capex and repayments cluster in the second and fourth.
Specifics by category
- Apparel
- Apparel: the budget splits into two to four seasons with different IMU and markdowns; purchases and prepayments are fixed 4 to 6 months ahead.
- Footwear
- Footwear: a stricter purchase budget (minimum runs, size grid, last), a higher return share; include a separate reserve for returns.
- Accessories
- Accessories: the budget is steadier by season, reordering by actuals is possible; for bags and jewelry the gifting periods carry a higher share.
- Kids
- Kids: a large share of the first half of the year for school and autumn-winter; the certification and labeling budget is included in cost in advance.
- Men
- Menswear: a simpler budget: stable core lines, fewer reductions; forecast error is usually lower.
- Women
- Womenswear: the budget includes more fashion items with a reserve for reorders and markdowns; split into core, fashion and image.
Common mistakes
- The budget is assembled from separate files → the figures do not tie between P&L, cash budget and balance sheet → one linked model.
- A top-down target is cascaded without a bottom-up check → the plan is unrealistic, the team does not believe it → reconcile both approaches and record the gap and decisions.
- Purchases computed from revenue, not from COGS and stock → overstock → derive purchases from COGS, target stock and IMU.
- Payroll without contributions and bonuses → an overrun of 30% and more → compute the full cost of an employee.
- The budget is approved once a year → it is stale by autumn → revise quarterly (rolling forecast).
- No line owners or limits → nobody answers for an overrun → assign an owner and a limit to each line.
Russian specifics
- A budget is a management document, the law does not set its format; but tax assumptions (corporate income tax 25%, VAT 22%, contributions) must come from current norms. Rule: Tax Code Art. 284: Tax Code, Art. 284 (corporate income tax rates) (rule check not completed).
- VAT of 22% applies from 2026 (Law 425-FZ): include it in purchases, expenses and prices, distinguishing preferential-rate goods. Rule: Law 425-FZ of 28.11.2025: Federal Law of 28.11.2025 No. 425-FZ (amendments to parts one and two of the Tax Code; VAT 22%) (rule check not completed).
- For USN the tax budget follows different rules (income or income minus expenses); the VAT threshold for USN has changed, see the “VAT threshold on USN” calculation. Rule: Law 228-FZ of 04.07.2026: Federal Law of 04.07.2026 No. 228-FZ (income threshold under Art. 145 of the Tax Code).
- Social contributions: a general tariff and a reduced one for SMEs; the cap base is indexed by a Government decree; take the value for the year from the current decree. Rule: Decree 1705 of 31.10.2025: Government Decree of 31.10.2025 No. 1705 (contribution base limit).