Marketing budget format: the columns, the line items and the structure finance will approve

A marketing budget should be laid out as one row per spending line and one column per month, with a small set of fixed columns in front of the months: category, line item, owner, supplier, commitment type, cost basis, and the outcome the line is meant to produce. That shape works because it answers the three questions anyone reviewing it will ask, which are what is this money for, who committed it, and what can be changed if the plan changes. Keep a separate sheet for actuals pulled from your accounting system, and a third that compares budget to actual by month. Three sheets with a consistent line structure is the whole format, and it holds up from a small business plan to a departmental budget reviewed by finance.

This page covers the structure and format of the budget document. For deciding how much to spend in total, see a page on setting a marketing budget from unit economics.

The column layout

Use these columns, in this order, and resist adding more.

Category | Line item | Owner | Supplier | Commitment | Cost basis | Intended outcome |
Jan | Feb | Mar | Q1 | Apr | May | Jun | Q2 | ... | FY total | Notes

Column	What goes in it	Why it earns its place
Category	Paid media, agency fees, software, content, events, brand, research, salaries if included	Lets you roll the budget up for a board slide without rebuilding it
Line item	The specific thing being bought	One row per decision, so every number is traceable
Owner	A named person	Unowned lines are the ones that overspend
Supplier	Who gets paid	Finance needs this to match invoices and it reveals concentration risk
Commitment	Committed, planned or flexible	Shows instantly how much you could redirect this quarter
Cost basis	Fixed monthly, variable with spend, per unit, or one off	Makes reforecasting arithmetic instead of guesswork
Intended outcome	The measure this line is meant to move	Turns a cost list into a plan, and it is the column that wins approvals
Monthly columns	Cash expected to be spent that month	Monthly phasing is what finance actually needs for cash flow
Quarter and year totals	Formulas only, never typed	Typed totals break the moment a line changes
Notes	Contract end date, notice period, assumptions	Answers next quarter's questions before they are asked

The categories to split by

Use a small, stable set so the same report works month after month.

• Paid media, split by channel: search, social, display, retail or marketplace, offline. This is normally the largest variable block.
• Agency and contractor fees, separated from the media they manage so you can see the cost of the management itself.
• Software and tools, with renewal dates in the notes column, because this category grows quietly.
• Content and creative production, including photography, video, design and writing.
• Events and sponsorships, with the full cost including travel, stand build and collateral rather than the ticket price alone.
• Brand and research, including surveys, brand tracking and design work.
• Partner and channel marketing, where it applies.
• Contingency, a named line of roughly five to ten percent that stops every unplanned opportunity becoming a negotiation.

Whether salaries belong in the marketing budget depends on how your company reports. Ask finance once and then be consistent, because switching mid year makes every comparison useless.

Committed, planned and flexible

This single column does more work than any other. Committed money is contracted and cannot be moved this quarter. Planned money is agreed internally but not yet contracted. Flexible money can be redirected within weeks, which in most budgets means paid media and production.

When the plan changes, and it will, you can answer the only question that gets asked in that meeting: how much can move, and by when. A budget that cannot answer it gets cut by percentage across every line, which is the worst possible outcome because it damages the strong lines and the weak ones equally.

The actuals and variance sheets

Keep three sheets with identical line structures so formulas line up.

• Budget. The approved plan. Lock it after approval and keep it unchanged as the baseline.
• Actuals. Pulled from the accounting system monthly, matched to the same line items. Use the supplier column to reconcile against invoices.
• Variance. Budget minus actual by month and year to date, with a short written reason on any line more than ten percent out either way.

Overspend and underspend both need a reason. Underspend is usually a plan that did not happen, which matters more than the money, because the outcome that line was meant to produce did not happen either.

The reforecast cycle

Set the rhythm once and keep it, so the budget stays a working document instead of a file that was accurate in January.

• Monthly. Load actuals, write variance reasons, adjust the next two months on the flexible lines only.
• Quarterly. Reforecast the remaining quarters, move money between lines based on what the results show, and record what you moved and why.
• Annually. Rebuild from objectives rather than from last year's numbers, and review every software renewal and every retainer against what it delivered.

How to present it for approval

Finance wants monthly cash phasing and a clear total. Leadership wants to know what the money buys. Give them one page with three things: total by category as a simple breakdown, the monthly phasing line, and the intended outcome column summarised into three or four sentences. Keep the full spreadsheet attached for anyone who wants the detail. Approvals are won on the outcome column, so write it in plain commercial language rather than channel jargon.

Should a marketing budget be built monthly or quarterly?

Monthly columns with quarterly rollups. Monthly is what finance needs for cash flow and it is the only way to show seasonality properly. Quarterly totals are for the summary view, calculated rather than typed.

What percentage of revenue should marketing be?

Percentages are a sense check, not a method. Build the number from what you want to achieve: the customers you need, what you can afford to pay to acquire one, and the capacity of the channels available. Then compare the total with your revenue as a sanity test and be ready to explain the difference.

How much contingency should I include?

A named line of five to ten percent. It is the difference between saying yes to a late opportunity and reopening the whole budget, and reviewers accept it far more readily when it is labelled rather than hidden inside other lines.

Spreadsheet or budgeting software?

A spreadsheet is enough for most teams and it is what finance can read without training. Move to software when you have multiple cost centres, purchase order workflows or several people editing at once. Keep the same column structure either way.

How do I budget for a channel with no history?

Give it a test line with a fixed amount, a start month, a defined success measure in the outcome column, and a note saying what happens if it works. That framing gets approved far more often than an unexplained figure in a new category.

A budget line for the answer your buyer is given

Finance will approve columns it can reconcile: channel, owner, amount, period. One thing worth adding sits outside those columns, a recurring check of what assistants tell buyers about your category.

It costs little. Someone asks the same ten buyer questions each quarter and records who is named, which gives the budget a baseline to discuss. AI Knows Us is a tool for doing that across the main assistants, and it fits under measurement or research.