Marketing budget template: how much to spend, on what and month by month

Free marketing budget template in Excel: line items by month, planned versus actual and the variance in colour, with an example.

The template's “Example” tab, completed using the case of an employment consultancy.

The template in figures

10 budget items over 12 months, forecast and actual
6 figures at the top, with the variance shown in color
5 to 10% of revenue, the usual benchmark
Leave us these three details and the download will appear right here, instantly.
Name *
Business email *
Company *

What the marketing budget template includes

The year's marketing money on one sheet, tracked month by month.

From percentage to budget

Projected revenue and the share you allocate to marketing determine the year's budget.

Editable categories

Ads, agency, tools, content, events, in-house team, and others, customizable to your needs.

Budgeted and actual figures for each month

With the variance in green or red and the total for each category.

Year to date, at the top

Budgeted, spent, variance, and the share of revenue spent on marketing.

How to create a marketing budget step by step

Half an hour for the initial allocation; then five minutes at the end of each month.

Enter projected revenue

And the share you want to allocate to marketing. The sheet gives you the year's budget.

Allocate by category

Where the money goes: ads, agency, tools, content, events.

Allocate by month

If there are peak seasons, allocate more to the preceding months.

Record what you spend each month

From that month's invoices.

Correct the variance

If a budget item spikes, decide in time where the money will come from.

Frequently asked questions about the marketing budget

Answers to your most common questions

What is a marketing budget template for?

To decide how much money you allocate to marketing and what you spend it on, distribute it by month, know each month whether you are overspending, and explain to management where the money went.

What is a marketing budget?

It is the money a company sets aside for marketing over a given period, broken down by budget item (ads, agency, tools, content, events) and by month, with actual spending shown alongside it.

How much should a company invest in marketing?

Many service companies allocate between 5% and 10% of their revenue, but this is a benchmark, not a rule: it depends on how much you want to grow and how much it costs you to acquire each customer.

How is a marketing budget allocated?

By budget item according to the channels in the marketing plan, and by month according to your seasonal patterns. The template lets you change the budget items and the monthly allocation.

How is it different from the CAC calculator?

The budget tracks how much you spend; CAC tells you how much each customer costs based on that spending. Together, they show you whether the money is being well spent.

What do I need to use the template?

Excel. It includes instructions and a sample budget for a labor consultancy.