What the tracker is and is not
The guide to tracking spend against budget explains the three figures a tracker must keep apart: committed money, which has been promised; spent money, the value of what has been delivered; and invoiced money, what suppliers have billed. It sets the rule that matters most: the remaining headroom on any line is budget minus committed, not budget minus invoiced. This tutorial builds the file that applies those definitions. For what each figure means and why, read that guide; this page is about the columns, the logs and the routine.
The tracker is a working tool. It is where a line owner checks whether a purchase fits before saying yes, where the marketing head sees which lines are running ahead, and where the month-end figures for finance are assembled. It adds two things the ledger lacks: commitments that have not yet reached an invoice, and the outcome each line was budgeted to buy.
The tracker is not the ledger. Finance's ledger is the record of what the company spent. When the two disagree after the monthly reconciliation, the ledger wins and the tracker is corrected, as the tracking guide says. A tracker that drifts from the ledger and is never corrected becomes a rival version of the truth, and finance will stop trusting anything that comes from it.
The Chartered Institute of Marketing treats financial control as part of the marketer's core competence, and the tracking guide spells out what that means in practice: a named owner for the tracker, a standing month-end routine and a shared calendar of close dates and reforecasts. The tracker is where all three meet.
Before you start
- The approved budget. The signed-off version from the budget-building tutorial, with every line, its cost code, cost centre, owner, phasing and outcome measure. Build the tracker from this file, not from a draft.
- Finance's codes. The cost codes and cost centres marketing books to. The tutorial on mapping marketing spend to finance codes sets these up if they are not yet clear.
- Every open order. A list of purchase ordersFinance's authorisation for a supplier to deliver against a named cost line, raised for the agreed amount before work starts and used to check the invoice., insertion orders, statements of work and bookings already agreed for the year, with their values and dates.
- Access to delivery records. Platform spend reports, or the warehouse feed if your data team has one, and wherever agencies send status reports.
- Finance's month-end calendar. Close dates, the accrualAn estimate of what was received in a month but not yet invoiced, booked so the cost lands in the month that benefited rather than whenever the invoice arrives. deadline and the reforecast points, from your finance business partner.
- A shared file that marketing and finance can both open, with a clear name and one owner. Any spreadsheet that can hold several tabs will do.
The steps
Take the lines and codes from the approved budget
Copy every line of the approved budget into the tracker exactly as it was approved: name, cost code, cost centre, owner, supplier where known and cost type. Do not rename, merge or split lines now; the point is that each row in the tracker matches one row in the budget and one code in the ledger, so the month-end comparison can be made line by line. If the approved budget has a line that combines cost types, such as media and an agency fee, raise it with finance and split it into two lines with their own codes before the year starts, because the marketing P&L guide explains why media and fees are booked apart.
Lay out the budget by line and month
Put the lines in rows and the months of the budget year in columns, with the approved phasing in each cell and a year total at the end. Keep the budget on its own tab, untouched once approved: every later figure is compared with it. Add a column for the latest forecast beside the budget, initially the same as the budget, which changes only at a reforecast. Group lines by objective or channel with subtotals if that is how the marketing head reads them, but keep every individual line visible so variances can be traced.
Add a commitments log with order references
On its own tab, list every commitment as one row: the order or booking reference, the supplier, the budget line, the amount, the months it covers, the date agreed, who agreed it and its next break or cancellation point. Record the break point because the guide to cutting a marketing budget starts any cut from the list of commitments and their break points; record the date as the order or contract states it and leave its interpretation to whoever signs contracts. Add each commitment the day it is made, ideally as the order is raised, as the tutorial on purchase orders and invoice approval describes. Sum the log by line and month so it feeds the main sheet.
Feed spent figures from platforms and delivery records
Spent is the value of what was delivered in the month. For ad platforms bought directly, take spend from each platform's report, or from the warehouse feed the guide to ad platform data in a warehouse describes, which is reconciled to the platforms before it reaches the tracker. For agency media, ask the agency for delivered spend by account. For fees, freelancers, production and events, use the delivery evidence: status reports, day logs, stages reached, events that took place. Record the source beside each figure so anyone can check it. Use the same campaign and line names the platforms use, following the data operations guide's campaign taxonomy, so platform figures map to lines without manual translation.
Add invoiced and accrued columns
Beside spent, add invoiced: the amount suppliers have billed, by line and month, from the invoices approved or from finance's extract. Then add accrued: what the line owner has told finance was delivered but not yet invoiced at the month-end, taken from the accrual note the tutorial on estimating marketing accruals produces. With all three in place, a closed month should show spent roughly equal to invoiced plus accrued for each line, and any gap is a question to answer before the month is locked. The budget month-end close checklist lists the routine these columns support.
Calculate headroom from commitments, not invoices
Headroom for each line is the year's budget, or the latest forecast after a reforecast, minus everything committed. Calculate it from the commitments log, not from invoices: an order agreed this morning has reduced headroom even though nothing will be billed for weeks. For lines with no orders, such as ad platforms bought directly, agree with finance how commitments are counted; a common practice is spend to date plus any platform budget already set to run, so that a raised daily budget shows up as soon as it is made. Add a variance column too: phased budget to date against spent to date, so timing differences are visible month by month. Platform settings that pace evenly against the phased line, as the Google Ads budgets and pacing guide describes, keep budget pacingHow fast a campaign spends its budget across the flight compared with the plan. and this column in step.
Add the outcome each line was budgeted to buy
For each line, carry over the outcome measure and target from the approved budget: leads, orders, new customers, return on ad spend (ROASRevenue generated per unit of ad spend.) or a brand measure. Add the actual outcome month by month beside the spend. The tracking guide asks for cost and outcome variances to be reported together, because a line on budget whose key performance indicator (KPIA metric tied directly to an objective.) is well below plan will soon be questioned. A KPI tree shows how each line's measure rolls up to the company's revenue and profit, which helps decide which outcome belongs on which line. Keep outcomes on the same row as the spend, not on a separate report.
Name an owner for every line and set the update routine
Every line already has an owner from the budget. In the tracker, make that owner responsible for the line's commitments, spent figure, accrual and variance note, and name one person who owns the tracker as a whole. Write the update routine at the top of the file: commitments added when made, platform spend checked as often as the platforms need, invoices and accruals updated to finance's month-end calendar, variance notes written after close, reconciliation against the ledger once finance sends its extract. Agree the routine with your finance business partner so it matches their close dates.
Lock each closed month and keep versions
Once a month is reconciled to the ledger, lock its columns so nobody changes a closed month by accident. Corrections found later go into the current month with a note, not back into the closed one, so the figures sent to finance stay as sent. Save a dated version of the whole file at each close and at each reforecast, and record each approved move between lines with a link to its budget reallocation memo. When someone asks why a line changed, the version history answers in minutes.
The tracker's columns
The main sheet holds one row per budget line. The table shows the columns, where each comes from and what it is for. Monthly columns repeat for each month of the year.
| Column | Comes from | What it is for |
|---|---|---|
| Line, cost code, cost centre | The approved budget | Matching the ledger line by line |
| Owner | The approved budget | Someone answers for each figure and variance |
| Budget by month and year | The approved budget, locked | The baseline every figure is compared with |
| Latest forecast | The last approved reforecast | The current target after money has moved |
| Committed | The commitments log, summed by line | Headroom; what a cut can and cannot touch |
| Spent | Platform reports, warehouse feed, delivery evidence | What finance should recognise in each month |
| Invoiced | Approved invoices or finance's extract | Checking bills against delivery |
| Accrued | The month-end accrual note | Delivered cost not yet billed |
| Headroom | Budget or latest forecast minus committed | Whether a new purchase fits |
| Variance | Phased budget to date minus spent to date | Timing and permanent differences to explain |
| Outcome target and actual | The approved budget and reporting | Cost and outcome variances side by side |
| Variance note | The line owner after close | Cause, timing or permanent, full-year effect |
The commitments log sits on its own tab, one row per order, and feeds the committed column. Closed-month versions and reallocation memos sit beside it. A finished month's figures, with the accruals included, are what feed the marketing P&L template.
An outdoor clothing retailer's tracker (illustrative)
Ovrindale Outdoor finds its real headroom on paid social
Ovrindale Outdoor, an invented outdoor clothing retailer, has run its marketing money from a single sheet of invoices. For the new year it builds a tracker from its approved budget of £360,000 across eleven lines, with a commitments log holding the agency retainer, two trade shows and the annual email platform contract.
The paid social line has a budget of £96,000 for the year and £8,000 phased for each month. At the end of the first month, the old sheet of invoices would have shown £3,100 billed on the line and £92,900 left. The tracker tells a different story. Spent on the platforms is £7,600. Two creator bookings for the spring launch, agreed by email the week before, go into the commitments log at £9,500 and £6,000, neither yet delivered or billed. With the platform budget already set for the rest of the quarter counted as committed at £16,400, committed on the line comes to £39,500 and headroom is £56,500, not £92,900.
The paid social manager had been about to agree a third creator booking at £12,000 on the strength of the old figure. She checks headroom first, sees the line is committed through the spring, and takes the booking to the marketing head, who moves money from a cancelled print run with a reallocation memo. At month-end the line owner adds the £4,500 accrual for platform spend not yet invoiced, the ledger matches the tracker within £60 of currency difference, and the month is locked.
For quick what-if checks on the full-year total, such as how a move between lines changes the year, the marketing budget calculator is enough; the line-by-line work stays in the tracker. The budgeting hub shows where the tracker sits in the year.
Common mistakes
- Building from a draft budget. Lines that do not match the approved version cannot be compared with it. Start from the signed-off file.
- Tracking invoices only. Headroom looks larger than it is and money gets committed twice.
- Adding commitments at month-end. Headroom is wrong for the whole month. Add them the day they are agreed.
- Combining media and fees on one line. The tracker cannot match the ledger and every return figure is distorted.
- Leaving out raised platform budgets. A daily budget set to run is money about to be spent; count it.
- Keeping outcomes on a separate report. Cost and outcome variances belong on the same row.
- Editing closed months. Figures already sent to finance change silently. Lock them and correct in the current month.
- Treating the tracker as the ledger. When the two disagree after reconciliation, the ledger wins.
