1. Marketing Plan Overview

This sheet serves as the strategic core of the template. It features a table with columns for:

This sheet includes a formula in the “Expected Revenue” column: =Budget Allocation * (Predicted ROI / 100) This auto-calculates projected returns per campaign, helping small business owners prioritize high-yield activities.

2. Invoices & Payments

This sheet functions as the financial backbone of the template, linking marketing spend directly to client revenue. It mirrors a professional invoice structure:

A conditional formatting rule highlights overdue invoices: If “Due Date” < TODAY() AND “Payment Status” ≠ “Fully Paid”, then cell turns red with bold text.

3. Expense Tracker

This sheet logs actual marketing expenditures against planned budgets:

A SUMIF formula in the “Marketing Plan Overview” sheet pulls total actual spend per campaign: =SUMIF(Expense Tracker!D:D, MarketingPlanOverview!A2, Expense Tracker!C:C) This allows real-time comparison between budgeted and spent amounts.

4. Dashboards & Charts

This sheet consolidates key performance indicators into visual dashboards:

• Bar Chart: Campaign Budget vs Actual Spend — Compares planned vs actual expenditures per campaign.
• Pie Chart: Marketing Channel Allocation — Shows % of total spend by channel (Social, Email, etc.).
• Line Graph: Monthly Revenue from Marketing Invoices — Tracks invoice revenue over time to correlate with campaign timing.
• KPI Cards: Total Invested, Total Revenue Generated, Overall ROI % (calculated as =SUM(Invoices!E:E) / SUM(Expense Tracker!C:C) - 1)

INSTRUCTIONS FOR THE USER

Step 1: Begin by filling out the Marketing Plan Overview with your upcoming campaigns. Use the dropdowns for consistency.

Step 2: As you spend money on ads or services, record each expense in the Expense Tracker and link it to a campaign.

Step 3: Once a client pays for your marketing services, create an invoice using the Invoices & Payments sheet. Link it back to the campaign that generated the service.

Step 4: Check the Dashboard weekly. If actual spend exceeds budget by more than 10%, investigate and adjust future allocations.

Step 5: At month-end, review ROI by comparing revenue (Invoices) to expenses. Use this data to refine next month’s strategy.

EXAMPLE ROWS

Marketing Plan Overview:
Campaign Name: "July Social Media Boost"
Start Date: 7/1/2024
End Date: 7/31/2024
Budget Allocation: $800
Channel: Social Media
Target Audience: Women aged 25–45 in Austin, TX
Predicted ROI: 35%
Status: Completed
Expected Revenue (Formula): $2,800

Invoices & Payments:
Invoice ID: INV-20240715-001
Date Issued: 7/15/2024
Client Name: “Austin Boutique Co.”
Service Description: "July Social Media Boost"
Amount: $3,150
Payment Status: Fully Paid
Due Date: 8/1/2024
Marketing Campaign ID: "July Social Media Boost"
    

RECOMMENDED CHARTS & DASHBOARDS

Always use the Dashboard sheet to monitor performance. The ROI bar graph is critical—it visually answers, “Was this campaign worth it?” For small businesses with limited budgets, understanding which campaigns yield the highest return is not optional; it’s survival. By integrating invoice data directly into your marketing plan, this template transforms abstract promotional efforts into tangible financial outcomes.

Download and customize this template to fit your niche—whether you’re a local bakery running Instagram ads or a freelance copywriter billing for SEO content. The small business ethos of simplicity, clarity, and accountability is embedded in every formula and dropdown. With this template, your marketing isn’t just an expense—it’s an investment with receipts.