Guide
How to reconcile your ad budget at month-end
Month-end ad budget reconciliation is the process of locking a month once final spend has landed, pulling actual spend per channel, calculating the variance against budget, and deliberately deciding what happens to any surplus — roll it forward, reallocate it, or release it — rather than letting it silently reset to zero. Done well, it's a short, repeatable discipline, not a manual spreadsheet rebuild: the month gets locked so past numbers stop moving, every channel's actual-vs-budget gap is visible individually (not just in aggregate), and the next month starts already set up instead of from a blank sheet. The audit trail — every change as a new entry, never an overwrite — is what makes the whole process trustworthy instead of a guess.
Month-end is where most of the value leaks out of a marketing budget. Actuals come in, someone exports them into a spreadsheet, wrestles the formulas, chases the variance, and rebuilds next month from a blank sheet. It takes hours, and surplus quietly disappears in the process.
It doesn't have to. Reconciliation is a short, repeatable discipline — and done well, it pays off twice: a clean close, and recovered budget. Here's the method.
The steps
- 1
Lock the month
Once final spend has landed, freeze the month. No more edits to the past — it becomes the record you reconcile against. Locking is what makes the numbers trustworthy instead of a moving target.
- 2
Pull actuals per channel
Bring in what each channel actually spent — from the platforms or your source of truth. Reconcile per channel, not just in aggregate, so you can see exactly where the plan and reality diverged.
- 3
Calculate the variance
For each channel, compare budget to actual. Note the gap in dollars and as a percentage. This is your honest scorecard — over-spenders and under-spenders both matter.
- 4
Decide what to do with surplus
Underspend is not "saved" — it is at risk of vanishing at the close. Decide deliberately: roll it forward to next month, reallocate it to a channel that can use it, or release it. A decision, never a default.
- 5
Carry budgets forward
Start next month set up — budgets in place and surplus allocated — instead of rebuilding from scratch. The best reconciliation makes next month's pacing a running start.
- 6
Keep an audit trail
Record every change as a new entry, never an overwrite. "Why is this budget what it is?" should always have an answer. An append-only ledger is what turns reconciliation from a guess into a record.
Frequently asked questions
What is month-end ad budget reconciliation?
The process of locking a month once final spend has landed, pulling actual spend per channel, calculating the variance against budget, and deliberately deciding what happens to any surplus — roll it forward, reallocate it, or release it — rather than letting it silently disappear.
Why lock the month before reconciling?
Locking freezes the numbers so they stop being a moving target. Without a lock, "actuals" can keep shifting as late spend lands or corrections get made, and reconciliation built on a moving number is never actually trustworthy.
What happens to underspent budget at month-end?
It shouldn't just reset to zero — that's budget that was approved but never accounted for. Treat it as a deliberate decision: roll it forward to next month, reallocate it to a channel that's pacing well, or formally release it. Any of the three is fine; silently losing track of it isn't.
Should reconciliation be done per channel or in aggregate?
Per channel. An on-target aggregate total can hide one channel badly over budget and another badly under, netting out to something that looks fine and isn't — the per-channel variance is where the real information is.
How long should month-end reconciliation take?
With actuals already reconciled against budget and an audit trail that doesn't need to be reconstructed from memory, it should be a short, repeatable close — not an hours-long spreadsheet rebuild every single month.
Keep reading
Do this automatically with Caeros.
Holiday- and cadence-aware pacing, an append-only ledger, one-click reconciliation that recovers surplus, and an honest scorecard of what it saved you — for every channel. $14.99/month, flat, budget and spend only.
Get startedTry the live demo