Marketing budget tracking in one sheet, updated monthly

Aug 22
3 min read

Updated: 5 days ago

Introduction

Ask most small business owners what they spent on marketing last month and you get an estimate. Ask what it produced and you get a stronger estimate.

Neither is a criticism of anyone's memory. The information exists across four platforms, two card statements and an invoice folder, and nobody has ever put it in one place.

1. Marketing budget tracking needs one sheet with five columns

Date, channel, description, amount, and what it was for.

That is enough to answer every question you will realistically ask: what did we spend, where, and what is the trend. More columns get abandoned by month three.

One row per cost, entered monthly. It is a twenty-minute job once the habit exists and an archaeology project if you leave it a year.

2. Include the costs that are not ad spend

The number most businesses quote is media spend, which is often less than half the real figure.

Add the tools and subscriptions, the design and photography, the printing, the sponsorships, the commission paid to platforms and marketplaces, the discounts given as promotions, and anything paid to a contractor or agency.

Also add the value of free stock given away. It comes out of margin whether or not it appears on a statement.

3. Decide about staff time and be consistent

Whether to include your own or your team's hours is a genuine choice with no universal answer.

Including it gives a truer cost per customer and makes the sheet harder to maintain. Excluding it makes channels that consume labour look cheaper than they are, which distorts comparisons — organic work in particular.

Either approach is defensible. Changing approach halfway through the year is not, because the year-on-year comparison becomes meaningless.

4. Group by channel the way you make decisions

The categories should match the choices you actually face.

If you decide between paid search, paid social, local listings, email and referrals, those are your categories. Do not split by platform if you never make platform-level decisions, and do not lump everything into "advertising" if you do.

Keep the list short — six or seven categories — and stable, so the comparison across months holds.

5. Record what it produced in the same place

Spend on its own is only half a sheet. Next to each month, record enquiries and customers by channel.

You do not need perfect attribution. Asking every enquiry where they heard about you, and recording the answer, gets you most of the way for nothing.

Once both sides sit in one sheet, cost per enquiry and cost per customer by channel calculate themselves, and those two numbers are what the whole exercise is for.

6. Compare against a benchmark you set yourself

Industry benchmarks are mostly unhelpful — different margins, different lifetime values, different markets.

The comparisons that matter are internal: this channel against your other channels, and this month against the same month last year. Seasonal businesses should never compare consecutive months, which is the default in most reporting tools and the source of a great deal of unnecessary panic.

Set a target cost per customer from your own margin, and judge everything against that.

7. Reconcile against the bank, quarterly

The sheet drifts from reality. Subscriptions renew unnoticed, a trial converts, a platform charges in another currency.

Once a quarter, check the total against actual outgoings. The gap is nearly always upward, and the usual culprits are tools nobody uses and platform fees nobody counted.

That reconciliation frequently pays for itself immediately, before any of the analysis is used.

8. Keep the history, and keep it boring

The sheet becomes genuinely valuable in year two, when you can see what a channel cost over time and whether it degraded.

Which argues for stability over sophistication. A plain sheet maintained for three years beats an elaborate dashboard rebuilt every eight months, because the value is in the continuity.

Store it where more than one person can reach it, and put the update in a recurring monthly slot with a name attached. Tracking that depends on someone remembering stops the first busy month.

Conclusion

One sheet, five columns, updated monthly: date, channel, description, amount, purpose.

Include tools, commission, discounts and giveaways rather than only media spend, take a consistent position on staff time, group by the decisions you actually make, record enquiries and customers alongside cost, compare against your own history and your own target, reconcile with the bank quarterly, and keep the format stable for years.