FICILCOM Inc. LogoFICILCOM Inc.
  • Company
  • Company Overview
  • Mission · Vision · Values
  • Guidelines
  • Services
  • NeX-Ray
  • Xtrategy
  • Trial Job Change
  • Tsurugi
  • Recruit
  • Culture
  • Benefits
  • Process
  • FAQ
  • Open Positions
Contact
  1. Home
  2. Blog
  3. Campaign Management
  4. Annual Marketing Budget Template: Example and Quarterly Reviews

Annual Marketing Budget Template: Example and Quarterly Reviews

マーケティング年間予算計画テンプレート|四半期レビューの進め方付き

Published: 03/29/2026

Last Updated: 10/07/2026

Category: Campaign Management

Authors: Shusaku Yosa

Ready to put this into practice?

Start Xtrategy for free→

1-minute signup, free, cancel anytime

An annual marketing budget connects business objectives to planned initiatives, costs, and timing. Keep the original approved budget, revised budget, actuals, and forecast separate so you can explain changes rather than overwrite them.

The tables below are copyable worksheet content, not a newly supplied download. For an existing Excel file, visit our marketing budget spreadsheet guide. Do not assume that its workbook contains every table shown here.

Set the budgeting assumptions first

Record the fiscal year, currency, tax treatment, cost scope, accounting basis, and owners. An advertising-only budget differs from one including labor and contractors. Avoid counting agency fees under both advertising and outsourcing.

Field

Copyable entry

Year and dates

[Start and end dates; quarter boundaries]

Currency and tax

[Currency; tax-inclusive or tax-exclusive]

Included costs

[Media, production, labor, tools, other]

Recognition and close

[Cash or accrued management view; closing date]

Responsibilities

[Input owner, reviewer, approver]

Build the total from objectives, gross profit, previous acquisition efficiency, capacity, and contracted costs. A universal percentage of revenue or mandatory contingency ratio is not a substitute for this work. Give new initiatives a test budget and evaluation date.

Copyable annual allocation table

Initiative

Owner

Original budget

Q1

Q2

Q3

Q4

Approved revision

[Category or project]

[Name]

[Amount]

[Amount]

[Amount]

[Amount]

[Amount]

[Amount and date]

Total

[Reviewer]

[Annual total]

[Total]

[Total]

[Total]

[Total]

[Current approval]

Confirm that quarterly allocations sum to the annual original budget. Ordering, delivery, payment, and cost recognition can occur in different months. Use initiative IDs to connect monthly detail with the annual summary.

A hypothetical midyear forecast

The following independent example uses thousands of dollars. No revision has been approved. The original $120,000 budget was allocated equally across four quarters. These figures are illustrative, not spending benchmarks.

Category

Original

H1 actual

Committed, unrecognized

Uncommitted forecast

Year-end forecast

Advertising

60

28

4

29

61

Production and contractors

30

13

5

10

28

Tools and labor

30

14

2

12

28

Total

120

55

11

51

117

Year-end forecast = $55,000 actual + $11,000 committed + $51,000 uncommitted = $117,000. The remaining-period forecast is $62,000, giving a $3,000 underspend against the original budget. Commitments are excluded from the uncommitted column to avoid double counting.

An underspend is not automatically a success. Check for delayed work, missing invoices, and missed objectives. Available funds alone do not justify additional spending.

Compare CPA, ROAS, and ROI consistently

Google Ads defines average CPA using the cost of specified conversions divided by their count. If the conversion is an inquiry, CPA is not the total cost of acquiring a new customer. CAC has a different customer unit and cost scope.

Measure

Calculation

Required agreement

CPA

Included cost ÷ specified outcomes

Success condition, duplicates, included costs

ROAS

Attributed revenue ÷ advertising spend × 100

Attribution, window, returns, tax

ROI

Profit from the investment ÷ investment cost × 100

Profit definition, cost of goods, additional costs

Suppose fictional revenue is $10,000, product costs $4,000, advertising $2,000, and production and management $1,000. Advertising-only ROAS is 500%. Using $3,000 as the investment and profit after those costs, ROI is ($10,000 − $4,000 − $2,000 − $1,000) ÷ $3,000 × 100 = approximately 133.3%. Other overhead is excluded; different allocation rules change the result.

Google's ROI explanation likewise considers costs beyond revenue. Separate incomparable channels instead of ranking them mechanically. See our ROAS guide for advertising interpretation.

Run a quarterly review in order

  1. Check missing invoices, duplicate costs, measurement gaps, and immature outcomes.
  2. Explain differences between original budget, revisions, actuals, and forecast.
  3. Review lead quality, sales-cycle delays, gross profit, and operating capacity.
  4. Compare maintaining, testing, increasing, reducing, or stopping investment.
  5. Record the amount, owner, approver, and next review date.

CPA above target is a reason to investigate, not automatically cut a fixed percentage. Consider delayed sales, marginal efficiency, and contractual restrictions before a small adjustment. Our budget allocation guide covers these choices.

Preserve the baseline and revision history

Microsoft's budgeting documentation distinguishes original budgets, transfers, and revisions. This is a reference implementation, not a description of Xtrategy.

Review log

Entry

Date, scope, data quality

[Period, categories, outstanding gaps]

Observation and hypothesis

[Changed measure, evidence, uncertainty]

Decision and amount

[Maintain, test, increase, reduce; amount]

Responsibility

[Owner, approver, next check]

Set month-end responsibilities and one authoritative file location. To manage monthly media, labor, and contractor budgets and actuals across projects, review Xtrategy's features.

 

 

 

 

Table of Contents

  1. Set the budgeting assumptions first
  2. Copyable annual allocation table
  3. Compare CPA, ROAS, and ROI consistently
  4. Run a quarterly review in order
  5. Preserve the baseline and revision history

 

Company

  • Company
  • Company overview
  • Mission · Vision · Values
  • Guidelines

Services

  • Services

Blog

  • Blog
  • Categories
  • Authors

Estimate

  • Estimate simulator

Careers

  • Careers
  • Culture & Work Style
  • Benefits & Systems
  • Hiring Process
  • FAQ
  • Open Positions

Policies

  • Privacy Policy
  • Anti-Social Policy
  • Information Security Policy

Contact

  • Contact

Social

  • X
  • LinkedIn
  • Facebook
  • Pinterest
© 2026 Ficilcom Inc.

Related Articles

施策、営業への引き継ぎ、受注をつなぐ流れ / A connected path from a campaign through sales handoff to a won deal
Campaign Management11/16/2026

Revenue Marketing: Connect Campaigns, Sales, and Won Deals

Build a revenue marketing workflow with shared sales definitions, deal IDs, and cohort reviews. Compare campaigns withou...

Shusaku YosaRead more
進捗とは?読み方・意味・使い方と短い報告の例
Campaign Management09/18/2026

What Does Shinchoku Mean? Business Progress and Status Update Examples

Learn how to read and use 進捗 (shinchoku), distinguish related Japanese terms, and write concise progress updates with cl...

Shusaku YosaRead more
やることリストの作り方|空き時間・完了条件・相手待ちを入れた記入例
Campaign Management09/18/2026

How to Make a To-Do List: A Worked Plan with Available Time, Completion Criteria, and Waiting Tasks

Build a to-do list with completion criteria, calendar capacity, and waiting states. A worked example shows how to replan...

Shusaku YosaRead more