Over, Under, On Track: Flagging Marketing Budget Lines

The line that looked fine until you opened it

Your monthly total looked healthy. Spend was at 94% of plan, which is the kind of number that lets you close the laptop and move to the next meeting. Then someone on the team asked why paid social had been dark for two weeks, and you found the line: 140% of its monthly allocation, burned through by day twelve, quietly offset by an events line that hadn't spent a dollar yet. The total was fine. The line wasn't. Nobody caught it because nobody was looking at lines — they were looking at a total that happened to average out.

This is the failure mode that a single "budget vs. actual" number can't catch. A plan-level rollup tells you whether the month was fine in aggregate. It doesn't tell you which channel got there by overspending and which got there by not spending at all. Both are problems. Both need a different response. And both are invisible until you build a system that flags the line itself, not just the total.

This article walks through how to set over/under thresholds so each budget line tells you its own status — over, under, or on track — the moment an actual is logged, and what to actually do once a flag fires.

Why "over" and "under" are both flags, not just "over"

Most budget-tracking habits are built around one fear: overspending. That's understandable — overspending is the version that gets escalated to a director. But an underspent line carries its own cost. Money sitting unspent in a channel that was supposed to be running a campaign this month means that campaign isn't running. It means the plan and the calendar have quietly drifted apart, and nobody decided that on purpose.

A well-built flagging system treats both directions as signal:

• Over a line is spending faster than planned, and at the current pace will run out before the period ends.
• Under a line is spending slower than planned, and the funded activity may not be happening at all.
• On track a line's actual-to-date is within an acceptable range of where it should be, given how much of the period has elapsed.

The point of marketing budget over under flag tracking is to make all three states visible at a glance, on every line, every time an actual is entered — not just at month-end when it's too late to redirect anything.

Setting thresholds so lines flag themselves

A threshold is the percentage variance you're willing to tolerate before a line needs a human decision. Below the threshold, a variance is normal noise — timing of an invoice, a vendor bill that landed early. Above it, someone should look.

There's no universal number here; it depends on how tightly you want to run the plan and how much natural lumpiness your channels carry (agency retainers post monthly and evenly; event costs post once and hit hard). Pick a starting threshold for your own plan — many teams start somewhere in the 10–15% range — and treat it as an assumption you'll tune after a quarter of watching how your own lines actually behave.

Once you've picked a number, the flag logic is simple arithmetic run on every line:

1. Variance = Actual − Planned (for the period so far).
2. Variance % = Variance ÷ Planned.
3. Compare Variance % against your threshold, adjusted for how much of the period has elapsed — a line at 60% of its monthly budget on day 10 is a very different flag than the same 60% on day 28.

That third step is the one most spreadsheets skip, and it's the one that turns a flag from noise into a decision.

A worked example — plug in your own numbers

Say you've set a 12% threshold and you're checking status on day 15 of a 30-day month, so 50% of the period has elapsed. These are example inputs only — swap in your own planned and actual figures when you build this for your own plan.

• Paid social: Planned $4,000 for the month. Actual to date: $2,950. Variance = $2,950 − ($4,000 × 50%) = $950 over the expected pace. Variance % = $950 ÷ $2,000 = 47.5% — well past a 12% threshold. Flag: Over.

• Content/SEO: Planned $2,500 for the month. Actual to date: $600. Variance = $600 − $1,250 = −$650 under the expected pace. Variance % = −$650 ÷ $1,250 = −52% — also past threshold, in the other direction. Flag: Under.

• Email/lifecycle: Planned $1,200 for the month. Actual to date: $610. Variance = $610 − $600 = $10 over expected pace. Variance % = $10 ÷ $600 = 1.7% — inside the 12% band. Flag: On track.

Three lines, three different stories, and a plan-level total that — if you only checked the total — would have looked reasonably close to on-pace. That's the case for flagging at the line, not the plan. For the full mechanics of turning logged actuals into a rollup like this across an entire plan, see how to track marketing budget vs. actual and the deeper walkthrough on marketing budget variance analysis.

What each flag should actually trigger

A flag that doesn't lead to an action is just a color. Build a short, standing rule for each state so a flag tells you what to do next without a meeting:

• Over: Confirm the spend was intentional (a campaign pulled forward, an unexpected vendor increase) versus a mistake (double-booked invoice, wrong cost center). If intentional, decide now whether to pull funding from an under-pacing line to cover it, or accept the overage and note why. If it's a mistake, correct the entry before it distorts next month's baseline.
• Under: Check the campaign calendar for that channel. Is the funded activity actually running late, or not running at all? An underspent line tied to a campaign that's stalled is worth surfacing before the money quietly rolls into "we didn't get to it this quarter."
• On track: No action required — but on-track lines are worth a glance too, since a line that's on track in dollars but behind on the calendar deliverable it's funding is its own kind of drift.

A flag without an assigned action is just a color on a spreadsheet — the threshold only earns its keep once someone commits to what happens the moment it fires.

Building this rule set once, in writing, is what turns a monthly check-in from a debate into a checklist. It's also the backbone of a usable budget vs. actual variance report — the report is only as good as the thresholds and actions behind each flag.

Rolling flags up without losing the line-level detail

Once every line has a status, the rollup for a leadership or board review becomes a summary, not a reconstruction: how many lines are over, how many under, how many on track, and — critically — what action is already underway on each flagged line. That's a materially different conversation than walking in with a single percentage and hoping nobody asks which channel drove it.

The mechanics scale the same way whether you're tracking five lines or fifty: same variance formula, same threshold comparison, same three-state flag, applied per line and rolled up per channel, then per plan. If you're setting this up in a spreadsheet for the first time, a structured marketing budget tracker spreadsheet saves you from building the formulas from scratch and getting the period-elapsed adjustment wrong on the first pass — which is the single most common reason a threshold flags things that were never actually a problem.

Building this without redoing the spreadsheet every quarter

You can build all of this by hand: a variance column, a threshold cell, a conditional format for three colors, and a note field for the action tied to each flag. It works. It also needs to be rebuilt, checked, and re-formatted every time a line or a channel changes, and it only updates when you remember to open it.

If you'd rather start from a version that already has the variance formulas, the threshold logic, and the flag columns built in, the Marketing Budget Tracker Workbook is a standalone spreadsheet built to this exact structure — planned, actual, variance, and flag, line by line, ready to fill in with your own numbers.

If you'd rather the flags compute themselves the moment you log an actual — no formulas to maintain, no conditional formatting to re-apply next quarter — that's what the MarketPlans workspace does natively, with the thresholds set once per line and the flags recalculated automatically as spend is entered. See pricing for how that works across a full annual or quarterly plan.