Marketing Budget Template: Monthly Tracking, Quarterly Reviews and Annual Totals
Published:
Last Updated:
Category: Marketing Budget & KPI
Authors: Shusaku Yosa
A marketing budget template should show planned costs, actual costs and results for comparable periods. Spending the budget is not the same as achieving a business target. This workbook separates cost tracking from advertising performance so that a low spend rate does not automatically look like success.
The Excel file contains monthly detail, a quarterly summary and an advertising KPI sheet. All amounts and results are fictional examples, expressed in Japanese yen; they are not benchmarks or Xtrategy customer results.
Download the Excel workbook
The files contain formulas and no macros. Make a working copy, then replace the sample budgets and actuals. Yellow cells with blue text are inputs. A blank actual means incomplete; enter 0 only when zero spending has been confirmed.
Sheet | What it does | Important rule |
|---|---|---|
Monthly | Tracks budgets, actuals and variance notes for 12 months and six categories | Actual minus budget is the cost variance |
Quarterly | Shows full budgets and comparable closed-month results | A month closes only when all six budgets and actuals are numeric |
KPI | Tracks impressions, clicks, conversions, attributed revenue and targets | Recalculates rates from complete-month totals |
Set the reporting rules before entering data
Choose a fiscal start, currency, tax treatment and cost-recognition policy. The sample starts in April 2026 and uses JPY excluding tax. Change the start year and month on Monthly before entering your figures. The period labels and quarter boundaries update, but existing amounts do not move to different months. Use a new copy when changing an established reporting year.
The six categories are paid media, content production, tools, events, labor/outsourcing and other costs. Record a creative supplier invoice once, rather than under both content production and outsourcing. Keep detailed invoices and allocation rules in a supporting ledger; this workbook stores category totals.
Read a monthly variance in context
In the fictional April example, paid-media spending is JPY270,000 against a JPY300,000 budget. The variance is −JPY30,000 and utilization is 90%. That could reflect lower delivery, better efficiency or a missing invoice. The variance alone cannot distinguish them.
Cost category | Budget | Actual | Variance | Follow-up question |
|---|---|---|---|---|
Paid media | JPY300,000 | JPY270,000 | −JPY30,000 | Did delivery fall, or is a cost missing? |
Content production | JPY100,000 | JPY100,000 | JPY0 | Was the work accepted? |
Tools | JPY50,000 | JPY50,000 | JPY0 | Is the contract period correct? |
Labor / outsourcing | JPY150,000 | JPY150,000 | JPY0 | Are hours and allocations documented? |
Events and other costs also need confirmed zero values if no spending occurred. Do not use zero merely to complete the sheet. A missing category keeps the month out of closed actuals.
Compare the same months in quarterly reviews
With April and May closed and June incomplete, Q1 shows its full JPY1.8 million budget separately from the JPY1.2 million budget for completed months. Compare the latter with JPY1.2 million of completed actuals. This does not mean all Q1 results are final.
Likewise, comparing two months of spending directly with the JPY7.2 million annual budget does not measure performance. Utilization describes cost progress; review conversion attainment, contribution and payback separately. Preserve the original approved budget and record the reason and approval for revisions.
Recompute annual rates from totals
April has 1,000 clicks and 40 conversions, giving a 4% click-based conversion rate. May has 9,000 clicks and 180 conversions, giving 2%. The combined rate is 220 ÷ 10,000 = 2.2%, not the 3% arithmetic average of the monthly percentages.
Metric | Combined-period formula | Fictional two-month result |
|---|---|---|
CTR | Total clicks / total impressions | 10,000 / 1,000,000 = 1% |
Click-based conversion rate | Total conversions / total clicks | 220 / 10,000 = 2.2% |
CPA | Total ad spend / total conversions | JPY600,000 / 220 ≈ JPY2,727 |
ROAS | Total attributed revenue / total ad spend | JPY2.2m / JPY600,000 ≈ 366.7% |
Conversion target attainment | Total conversions / same-period targets | 220 / 200 = 110% |
Use one consistent source, conversion definition, attribution model and reporting window. Deduplicate overlapping platform claims before combining results. Conversions are not necessarily new customers, and ROAS is a revenue ratio rather than profit-based ROI.
A zero denominator produces a blank rate, distinguishing an undefined result from 0%. The KPI total includes only months with all B–F inputs and a numeric ad-spend value. The spend reference points to the paid-media row in Monthly; renaming a category does not change the reference.
Customize and run the first close
Aggregate additional line items within an existing category when possible. Adding a new category requires updating all 12 monthly blocks, the quarterly completeness tests and sum ranges, and any KPI spend references. Inserting a row alone does not automatically extend the model. Test the edited copy with known amounts before using it for a decision.
Assign an input owner, reviewer and monthly deadline. Check that invoice dates and recognition periods follow your policy, missing expenses remain visible, and the same bill has not been counted twice. For material variances, record a reason, action, owner and due date in the notes column.
Use the workbook while it fits the team's reporting needs. Review the process when permissions, version control or reconciliation effort become a recurring problem; a tool change should solve a specific operating issue.
Related practical guides
Keep budgets and execution connected
Xtrategy supports monthly budget and actual tracking, including variance and spending progress. Define your cost categories and close process first, then evaluate the workflow with a 30-day free trial.
