Marketing Budget Template Free Download: Build Your Own

Quick Answer: The most useful free marketing budget template is one you build in about twenty minutes: a Plan sheet with one row per channel and one column per month, an Actuals sheet filled from your card and bank statements, and a summary that subtracts one from the other. Add a leads or sales column per channel and the sheet also tells you what each customer cost.

A downloadable marketing budget template usually gives you pretty headers and the wrong channels. A small business needs three things from the file: what it planned to spend on each channel, what it actually paid, and what that money produced. You can build all three in Excel or Google Sheets with plain formulas and no add-ins.

Why not just download a template?

Free templates from office suites and marketing blogs are fine as a starting picture, but most were designed for a marketing department with a dozen line items you will never use (trade show booth freight, agency retainers, analyst relations). The bigger problem is that they stop at the plan. A plan with no actuals beside it is a wish list.

Building your own takes about as long as deleting rows from someone else's, and the result matches the way your money really leaves the business: a handful of ad platforms charging your card, a printer you pay by transfer, a freelancer invoiced monthly, software subscriptions that renew on their own.

How do small businesses decide the total marketing budget?

There is no official rule. The U.S. Small Business Administration's marketing and sales guidance does not give a percentage; it tells owners to include a complete breakdown of the plan's costs and to compare marketing and sales costs with the revenue they generate. In practice owners use one of these methods, or a blend:

Whichever you choose, write the method and the reasoning in a note at the top of the Plan sheet. Six months from now you will want to know why you put $4,800 into search ads.

The four sheets

Keep one workbook with four tabs. Each has a single job.

1. Channels — a short list: name, type (paid ads, content, events, print, sponsorship, tools, contractor), and how you will count results (form leads, booked calls, coupon codes, tracked phone numbers).
2. Plan — channels down column A, January through December across B to M, an annual total in N.
3. Spend — every marketing payment as a row: date, payee, channel, amount, and the statement it came from.
4. Summary — plan, actual and difference by channel and by month, plus cost per result.

Convert the Spend range to an Excel table so new rows are picked up by formulas automatically. Microsoft's steps for creating and formatting a table are: select a cell in the data, choose Home > Format as Table, pick a style, confirm the range and tick that the table has headers. Give the table the name Spend so the formulas below read clearly.

Filling the Spend sheet from statements

This is the part that makes the template trustworthy. Marketing money tends to go out on a business credit card (ad platforms, software) and through the bank account (printers, sponsorships, contractors). Once a month:

• Download the card and bank statements for the period.
• Get the transactions into rows. If your bank offers a CSV export, use it. If you only have PDFs, QuickBankConvert reads the statement and gives you date, description and signed amount columns you can paste in; a free account covers a few statements a month, see pricing.
• Filter the descriptions for your marketing vendors and copy those rows to Spend. Add a helper column Month with =TEXT([@Date],"yyyy-mm").
• Tag each row with a channel. A drop-down from the Channels list stops "FB ads", "Facebook" and "Meta" becoming three channels.

If you already categorize statements for bookkeeping, you can lift the marketing rows straight from that work; bank statement categorization covers building the rules once, and business credit card expense tracking handles the card side, including receipts.

Watch for two traps. Ad platforms often bill in thresholds, so one month's card shows three charges for one campaign; that is fine, they still land in the right month. And annual software renewals hit one month hard; either budget them in that month or spread the plan evenly and accept a big variance in the renewal month.

Summary formulas

On the Summary sheet put channels in A, and month keys like 2026-03 in row 1 starting at B. Actual spend for a channel and month is a SUMIFS with the amount column first, then each range-and-criteria pair:

=-SUMIFS(Spend[Amount],Spend[Channel],$A3,Spend[Month],B$1)

The minus sign is there because statement exports usually show money out as negative numbers; flip it so spend reads as positive. Beside it, pull the planned figure from the Plan sheet and subtract. A conditional format that turns the difference red when actual exceeds plan by more than ten percent is enough of an alarm.

Worked example for one quarter

A small home-services company planned $1,500 each month across three channels. First-quarter actuals from statements and its lead log:

Cost per lead is =IFERROR(C2/E2,"") so channels with no leads yet show blank instead of a divide-by-zero error. If you can tag which leads became paying jobs, add a sales column and a cost per sale beside it; that number matters more than cost per lead.

What should you look at in the quarterly review?

The SBA's page says a marketing plan should be maintained at least annually and that measuring return shows which parts are working. Quarterly is a better rhythm for a small budget, because one bad channel can burn a meaningful share of a year's money in three months. Go through this list:

• Variance by channel. Overspends usually come from automatic ad budgets nobody capped. Underspends are often a campaign that never launched.
• Cost per result trend. Compare this quarter's cost per lead with last quarter's for the same channel, not with other channels that produce different kinds of leads.
• Unplanned vendors. Sort Spend by payee and look for names that are not on the Channels list. Subscriptions you forgot about live here.
• Reallocation. Move next quarter's planned dollars from the weakest channel to the strongest, in a small step, and note the change at the top of the Plan sheet.
• Cash check. Marketing is one line in the whole business budget. If the small business budget template shows tight cash next quarter, trim here first on the channels with the worst cost per sale.

Making it work in Google Sheets

Everything above works in Google Sheets with two changes. Sheets has its own tables feature, but plain ranges are fine: use Spend!D:D style references instead of Spend[Amount]. And for the month key, =TEXT(A2,"yyyy-mm") behaves the same. Drop-downs come from Data validation with a range pointing at the Channels list.

Related guides

• Small business budget template for the whole-business budget this one sits inside
• Bank statement categorization to tag marketing payments consistently
• Business credit card expense tracking for ad platform and software charges
• Bookkeeping spreadsheet template if you need the ledger behind all of it