FinanceBeginner

Track Budget vs Actual Spending

Compare planned budget against actual expenditures month by month to spot overruns early. Dual-line charts make variance analysis intuitive for any stakeholder.

Interactive Preview

Open in Line Graph Maker

TLDR

A budget vs actual chart plots planned spending and real expenditures as two lines on the same time axis, making overruns and underspends immediately visible. This template includes 12-month sample data for a marketing department budget so you can load it and start comparing instantly.

Overview

Budget variance analysis is a cornerstone of financial management. The Harvard Business Review notes that organizations reviewing budget variances monthly are 40% more likely to stay within 5% of planned spending. A dual-line chart is the clearest way to show the gap between plan and reality — the space between the two lines tells the story.

This template plots a planned budget line alongside actual monthly expenditures for a single department. Where the actual line rises above the budget line, you have an overrun; where it dips below, you have savings. The visual gap makes variance analysis intuitive even for non-financial stakeholders.

When to Use This Template

  • Monthly finance reviews: Present variance analysis to department heads
  • Project budget tracking: Monitor capital project spend against approved budget
  • Marketing spend optimization: Compare ad spend plan vs actual to reallocate mid-quarter
  • Annual planning: Use prior-year actual vs budget to calibrate next year's plan

Step-by-Step Guide

Step 1: Prepare Your Data

Format your data as CSV with three columns: month, budget, and actual. Each row represents one month. Both budget and actual values should be in the same unit (e.g., USD thousands). If tracking multiple departments, add a department column and filter to one department per chart.

Step 2: Configure the Chart

Set the chart type to Line with two series: Budget and Actual. Use a solid line for actual spending and a dashed line for the budget baseline. Enable Show Points on the actual line to emphasize monthly data points. Set Y-axis to start at zero to avoid exaggerating small variances.

Step 3: Customize and Export

Color the budget line in a neutral gray and the actual line in your company's primary color. If actual exceeds budget, the visual "crossing" creates an instant alert signal. Export as PNG for monthly reports or use the shareable link for a living dashboard.

Sample Data (CSV)

month,budget,actual
2026-01,45000,43200
2026-02,45000,46800
2026-03,50000,48500
2026-04,50000,53200
2026-05,55000,54100
2026-06,55000,58900
2026-07,48000,47200
2026-08,48000,51400
2026-09,52000,50800
2026-10,52000,55600
2026-11,60000,58200
2026-12,60000,64500

Best Practices

  • Always start Y-axis at zero: Truncating the axis exaggerates small variances and misleads viewers about the magnitude of overruns.
  • Add a variance threshold line: Use a mark line at your acceptable variance percentage (e.g., +/- 10%) to make the tolerance zone explicit.
  • Cumulative view for YTD: Consider a second chart showing cumulative budget vs cumulative actual to see if monthly overruns are being offset by earlier savings.
  • Use annotations for context: Mark months where budget was intentionally adjusted (reforecasts) so reviewers understand the baseline shifted.

Common Mistakes to Avoid

  • Comparing budgets across departments on one chart: Each department has different scales. Use one chart per department, or normalize to percentage of budget.
  • Ignoring timing differences: A January overrun and February underspend may simply be a timing issue (e.g., invoice arrived early). Note these in annotations.

FAQ

How do I show budget variance as a percentage?

Add a third calculated column: variance_pct = (actual - budget) / budget * 100. Plot this as a separate series on a secondary Y-axis, or create a dedicated variance chart below the main budget vs actual chart.

Can I track multiple departments on one chart?

Technically yes, but it clutters the visualization. Instead, create one budget vs actual chart per department and arrange them in a grid layout. If you must combine, use a stacked area chart for actuals with a single total budget line overlay.

Related Templates