Skip to content
CollMind
Menu

Guide

How to plan a promotion budget: a step-by-step FMCG guide

· 9 min read · CollMind

The promotion budget is one of the largest and least visible items in an FMCG trade marketing team’s hands. It is approved as a single number at the start of the year, split into dozens of campaigns, agreements and extra requests during the year, and at year-end the question “how did we spend it?” often goes looking for an answer across spreadsheets. This guide explains how to plan the budget from start to finish in eight steps. At the end of each step you will find a short check you can apply.

Before you start: what does the budget cover?

Before planning, draw the boundary of “promotion budget”. Even inside one company, different teams may mean different things:

  • On-invoice support: discounts and price support that appear on the sales invoice.
  • Off-invoice support: items paid after the invoice, such as visibility fees, turnover bonuses and campaign participation fees. See our Turnover ROI vs Gross Profit ROI article for more on the difference.
  • In-store execution costs: displays, promoters, non-standard materials.

Decide at the outset whether the three groups sit under one budget umbrella or are tracked separately. Because they are booked differently in accounting, most companies track on-invoice and off-invoice legs separately.

Check: Is the budget scope written down, and do finance and sales use the same definition?

Step 1: Set the total envelope

The starting point is usually one of two approaches:

  1. Top-down: A percentage of target revenue is set aside (for example, a share of net sales). Quick, but it may not reflect category realities.
  2. Bottom-up: The category and customer plans are added up. More accurate, but prone to inflation.

The healthiest approach is to compare both. If the gap is large, either targets are unrealistic or the plans at the base are ambitious. Discuss this gap openly with management.

Check: Were top-down and bottom-up totals placed side by side and the gap explained?

Step 2: Clean last year’s actuals

Last year’s spend is the best starting data for the plan, but in raw form it is misleading. Strip out:

  • One-off spend (for example, a launch or one-time penalties).
  • Period-shift effects: items made in December but booked in January.
  • Movements recorded in the wrong category.

From the cleaned data, derive the “normal” spend level by category × customer × period. This becomes the budget’s reference line.

Check: Were one-offs and period shifts corrected in last year’s data?

Step 3: Set the baseline

To know whether a promotion deserves budget, you need to know what would have sold without it. That figure is the baseline sales volume; everything above it counts as “incremental”. When planning the budget, the baseline serves two purposes:

  • It is the foundation for incremental volume and incremental profit estimates.
  • It lets you see promotion intensity (what share of sales is made on promotion).

Build the baseline excluding seasonality and the effect of earlier promotions, then calculate base gross profit. If the baseline is wrong, every return ratio calculated from it is wrong too.

Check: For each main product group, are the baseline volume and base gross profit methods written down and consistent?

Step 4: Split the budget into category, channel and period envelopes

A single total cannot be tracked. Split the budget into category (and, if needed, channel) × period envelopes. An example structure:

EnvelopeAllocation logic
Category A, Q1Last year’s cleaned spend + growth target
Category A, Q2Weighted to seasonality (summer)
Category B, Q1–Q4Flat spread, launch reserve held separately

When sizing an envelope, consider three inputs together: last year’s actuals, the category growth target and the main opportunities on the calendar (holidays, back-to-school, summer season). Slicing periods too finely (weekly, for example) kills flexibility; quarterly or monthly envelopes are enough for most teams.

Check: Does each category have an envelope per period and a named owner?

Step 5: Hold a reserve

If you distribute everything up front, opportunities that arise during the year (a competitor move, a supply surplus, a new customer deal) cannot be funded. Two kinds of reserve work in practice:

  • Central reserve: A small share managed by the commercial director for cross-category opportunities.
  • In-category reserve: A flexibility share each category manager can use toward the end of a period.

Rather than tying the reserve ratio to a fixed rule, set it by looking at the amount of unplanned demand in previous years. Also write down the usage rule: who approves, above which threshold.

Check: Are the reserve amount, its owner and its usage rule defined?

Once the envelopes are ready, every campaign plan must be linked to one. While planning, the team should be able to see:

  • How much is left in the envelope?
  • How much will the envelope shrink if this plan is approved?
  • What are the plan’s expected incremental profit and Gross Profit ROI?

An important distinction: allocation (the amount set aside for the envelope), commitment (the amount tied to approved plans) and consumption (actual spend). If you do not track the three separately, the appearance of “we have budget” drifts away from the real available balance. When the budget lives in spreadsheets, an approved plan does not reduce the balance by itself, and two teams can plan the same money separately.

Check: Does every approved plan reduce the envelope as a commitment, and who can see the available balance?

Step 7: Define approval thresholds and the overrun rule

Decide in advance what happens when an envelope fills. Possible rules:

  • A warning at 80%, a block on new plans at 100%.
  • A separate approval chain for overruns (for example, category manager → commercial director → finance).
  • A mandatory justification for transfers from the reserve.

Tying approval thresholds to plan amount and expected ROI also helps: low-value plans with healthy returns pass quickly, while high-value plans or plans forecast to lose money go to senior approval. A written rule closes the “who had the authority?” debate from the start.

Check: Is it written down what happens when an envelope fills and who approves an overrun?

Step 8: Compare with actuals every month

A budget is not a document you build once and leave. In a monthly rhythm, answer three questions:

  1. Variance: What is the difference between planned and actual in each envelope?
  2. Pace: What share of the period has passed, and what share of the budget has been consumed?
  3. Efficiency: Does the money consumed actually produce the forecast ROI?

Read pace and efficiency together. Spending too slowly or too quickly are both signals, but the real question is whether the money is being spent well. Moving funds from weak campaign types to the reserve or to more efficient categories is one of the most valuable in-year levers.

Check: In the monthly budget meeting, are variance, pace and efficiency on the same page?

Common mistakes

  • Managing with a single total. Without envelopes there is no accountability.
  • Not tracking commitments. If an approved plan does not reduce the balance, an overrun is noticed only after the spend.
  • Mixing on-invoice and off-invoice. The accounting difference distorts budget reports.
  • Planning without a reserve. The budget is exceeded at the first opportunity, or the opportunity is missed.
  • Looking only at turnover. Profit-based measurement is needed to spot campaigns with a high Turnover ROI that still lose money.
  • Calculating ROI on a faulty baseline. If the baseline is inflated, every campaign looks successful.

Budget planning checklist

  • Budget scope (on-invoice, off-invoice, in-store) written down
  • Top-down and bottom-up totals compared
  • Last year’s data cleaned
  • Baseline volume and base gross profit method set
  • Category × period envelopes and owners defined
  • Central and in-category reserves set aside
  • Allocation, commitment and consumption tracked separately
  • Warning, block and overrun approval rules written down
  • Monthly variance, pace and efficiency meeting on the calendar

Frequently asked questions

What percentage of sales should the promotion budget be? There is no single ratio that fits everyone. It varies with the category’s competitive intensity, channel structure and margin level. Cleaning your own history and deriving a reference line is more reliable than looking at general ratios.

Should I plan the budget annually or quarterly? Use an annual total together with quarterly or monthly envelopes. The annual figure gives direction; the period envelopes make day-to-day management possible.

How large should the reserve be? The amount of unplanned demand in previous years is a good starting measure. The usage rule matters more than the size.

Can this be managed in Excel? At small scale, yes. As the number of plans, people and approval steps grows, version confusion, untracked commitments and late-noticed overruns become problems. Ask yourself at what point you should consider changing tools: can two people plan the same budget at the same time?

Next step

In CollMind TPM the budget is split into category and period envelopes, approved plans are committed from the envelope and movements are written to an append-only ledger. If you would like to see how your current budget structure could be set up on this logic, get in touch.

Ask yourself: today, can you see at a glance how much budget is left in your category and how much of it approved plans have already committed?

Let’s bring your trade marketing data together

Request a demo to see our TPM solution, which brings promotion planning, budget control and KPI analytics under one roof.