Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Marketing Finance › Budgeting

Setting Up a Marketing Budget Tracker

How to build a marketing budget tracker finance can reconcile: lines and codes, a commitments log, spent, invoiced and accrued columns, headroom and owners.
Tutorialbeginner10 min readUpdated

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 orders, 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 accrual 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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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 pacing and this column in step.

  7. 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 (ROAS) 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 (KPI) 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.

  8. 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.

  9. 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.

ColumnComes fromWhat it is for
Line, cost code, cost centreThe approved budgetMatching the ledger line by line
OwnerThe approved budgetSomeone answers for each figure and variance
Budget by month and yearThe approved budget, lockedThe baseline every figure is compared with
Latest forecastThe last approved reforecastThe current target after money has moved
CommittedThe commitments log, summed by lineHeadroom; what a cut can and cannot touch
SpentPlatform reports, warehouse feed, delivery evidenceWhat finance should recognise in each month
InvoicedApproved invoices or finance's extractChecking bills against delivery
AccruedThe month-end accrual noteDelivered cost not yet billed
HeadroomBudget or latest forecast minus committedWhether a new purchase fits
VariancePhased budget to date minus spent to dateTiming and permanent differences to explain
Outcome target and actualThe approved budget and reportingCost and outcome variances side by side
Variance noteThe line owner after closeCause, 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)

Illustrative example — not a real result

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.

Frequently asked questions

Can the tracker just be a list of invoices?

Not if you want to know how much money is left. A list of invoices shows what suppliers have billed, which lags behind what has been promised and delivered. Headroom calculated from invoices looks larger than it is, so teams commit money that is already spoken for. The tracking guide's rule is that headroom is budget minus committed, which needs a commitments log, not just invoices.

What happens when the tracker and finance's ledger disagree?

Reconcile them line by line after finance closes the month and find the cause of each difference: a coding error, a missed or duplicated accrual, a currency or tax difference, a cost marketing did not know about, or timing. Correct what can be corrected and record the rest as known differences. When they still disagree after reconciliation, the ledger wins and the tracker is corrected, as the tracking guide says.

How often should the tracker be updated?

Commitments should go in the day they are made, because that is when headroom changes. Spent figures, invoices and accruals follow the month-end routine finance sets, with platform spend checked more often where the platforms spend quickly. Agree the routine with your finance business partner and write it at the top of the tracker; the right frequency depends on how fast your money moves, and there is no standard.

Terms used on this page

Tools to try

Frameworks

Where this page is used

Also related

Sources

  1. Chartered Institute of Marketing — CIM

Related