Marketing Budget Template for Small Business: How to Plan and Track Spend

Short answer: a useful marketing budget template does three jobs: it sets how much you plan to spend on each channel each month, it records what you actually spent, and it connects that spend to results — leads, customers and revenue. Build it with five tabs (Settings, Plan, Spend, Campaigns and Summary), use SUMIFS to compare plan with actual, and review it once a month so money moves from channels that do not pay back to the ones that do.

Small businesses rarely overspend on marketing because of one big decision. It happens through many small ones: a tool subscription here, a boosted post there, a market stall, a batch of free samples. A simple spreadsheet makes all of it visible in one place. This guide explains how to set one up in Excel or Google Sheets and how to read it.

What a marketing budget template should include

Keeping planned and actual figures on separate tabs matters. Planned figures change only when you deliberately revise the budget; actual figures grow every time you pay for something. Mixing them in one table makes both unreliable.

Step 1: Decide how much to spend

There is no correct marketing budget for every business. Most small businesses use one of three approaches, or a mix of them:

A practical mix for a small business: start with an amount you can afford to spend on testing without hurting cash flow, write down the goal each channel should reach, and increase spend only on channels that show they pay back. The template below makes that last part measurable.

Step 2: List your channels and cost types

In Settings, list every channel you use or plan to test — for example email, marketplace ads, social media ads, search ads, content and photography, events and markets, samples and giveaways, influencer or affiliate costs. Then add the cost types that apply to each:

• Fixed costs you pay whether or not a campaign runs: email platform, scheduling tools, design software, retainers.
• Variable costs that rise with activity: ad spend, product samples, postage for giveaways, event fees, commissions.
• One-off costs such as a product photo shoot or a new logo.

Decide once how you treat discounts and marketplace advertising fees, and stick to it. Many sellers record discount codes as reduced revenue in their books but also log them in the Campaigns tab, so the campaign’s true cost is visible. Marketplace fees that are charged only on ad-driven sales (Etsy’s Offsite Ads, for example) belong under the same channel every month. Our Etsy profit calculator guide explains how those fees work.

Step 3: Build the plan by month

In the Plan tab, put channels in column A and the first day of each month in row 1 (1 Jan, 1 Feb and so on — real dates, formatted to show only the month). Fill in planned amounts and add totals with =SUM() across each row and down each column.

A small maker’s first quarter might look like this (an illustrative example, not a recommendation):

Shape the plan around your own sales pattern. If your sales history shows that a season brings most of your orders, plan more spend in the weeks leading up to it rather than spreading the budget evenly. A simple bookkeeping system gives you that history month by month.

Step 4: Log every cost as it happens

The Spend tab is a plain list: A date, B channel (drop-down from Settings), C campaign, D vendor, E amount, F notes. Enter costs when you pay them, or paste them from your card or ad account statements once a week.

A copy of the Plan tab, renamed Actual, then fills itself. With channel in column A and month-start dates in row 1, the formula for each cell is:

=SUMIFS(Spend!$E:$E,Spend!$B:$B,$A2,Spend!$A:$A,">="&C$1,Spend!$A:$A,"<"&EDATE(C$1,1))

In the Summary tab, compare the two for each channel:

• Variance: =Actual - Planned — positive means overspent.
• % of budget used: =IFERROR(Actual/Planned,0)

Add conditional formatting that turns a cell amber above 90% and red above 100%. Overspending is not always wrong — a campaign that is working may deserve more — but it should always be a decision rather than a surprise.

Step 5: Connect spend to results

Spending on plan says nothing about whether the money worked. The Campaigns tab adds results. Pull each campaign’s spend from the log with =SUMIFS(Spend!E:E,Spend!C:C,A2), then add leads, new customers and revenue from your shop, email or ad reports. Four ratios do most of the work:

Wrap each formula in IFERROR(…,0) so empty rows do not show errors.

Why ROAS alone can mislead

Revenue is not profit. A campaign must cover the cost of the products it sells before it earns anything. The break-even point is:

Break-even ROAS = 1 ÷ gross margin

Take two campaigns for a shop with a 40% gross margin (illustrative figures):

The ad campaign brought in more revenue, but with a 40% margin its break-even ROAS is 1 ÷ 0.40 = 2.5, so it only covered its own costs. That can still be worth it if those customers buy again, which is why it helps to track repeat orders as well. If you are unsure of your margin, our profit margin calculator guide shows how to work it out.

Make the results trustworthy

• Tag your links. Add UTM parameters to links in emails, social posts and ads so your analytics can tell channels apart.
• Ask buyers. A “How did you hear about us?” question at checkout or in your thank-you email catches word of mouth and markets that no tool records.
• Compare like with like. Use the same date range for spend and results, and remember that some sales arrive weeks after the click.

Step 6: Review once a month

1. Check that every cost for the month is in the Spend tab.
2. Look at variance by channel and note why anything is over or under.
3. Update campaign results and compare cost per customer across channels.
4. Move budget from channels that have not paid back after a fair test to channels that have — and write down the reason in a notes column.
5. Revise next month’s plan, not this month’s, so the original plan remains a record of what you intended.

Your marketing spend should also appear as its own expense line in your accounts. If you are not sure where to find it, see how to read a profit and loss statement.

Common mistakes

• Leaving out small subscriptions. Tools billed monthly add up; list them as fixed costs.
• Counting only ad spend. Samples, postage for giveaways, photography and event fees are marketing too.
• Judging a channel too early. Decide in advance how long and how much a test will run before you judge it.
• Measuring revenue instead of profit. Use gross profit and break-even ROAS, not revenue alone.
• Rewriting the plan to match what happened. Keep the original plan and explain the variance instead.

Frequently asked questions

How much should a small business spend on marketing?

There is no single right figure: it depends on your margins, how established the business is and how fast you want to grow. Start with an amount you can afford to test with, measure cost per customer, and scale the channels where a customer is worth more in gross profit than it costs to win them.

What is the difference between a marketing plan and a marketing budget?

The plan describes what you will do and why — audiences, messages, channels and timing. The budget puts a cost on each part of the plan and tracks whether you kept to it. The template above covers the budget; the plan sets the goals that the Campaigns tab measures.

Should I include my own time?

It is worth tracking hours in a separate column even if you do not pay yourself for them. A channel that costs little money but many hours may be more expensive than it looks.

Can I build this in Google Sheets?

Yes. SUMIFS, EDATE and IFERROR work the same way in Google Sheets, and sharing the sheet makes it easy for a partner or freelancer to log costs.

How do I budget for a product launch or a sale?

Treat it as a campaign with its own name in the Spend and Campaigns tabs. Plan its cost in the months it runs, and compare its cost per customer with your regular channels afterwards.

More guides on planning and tracking marketing are collected in Marketing Plans & Trackers, part of our Online Selling & Inventory section.