Why this matters
Marketing reports spend from the platforms; finance reports it from the ledger; the two rarely agree, and when they differ the ledger wins. The guide to tracking spend against budget sets out the routine: keep committed, spent and invoiced apart, supply accruals, reconcile monthly and explain each variance as timing or permanent. The guide to the marketing P&L explains why cost lands in the month the service was delivered and how coding errors move it between cost centres. This exercise applies both to one month, and shows what an unreconciled month does to the return figures built on it.
The brand and its two spend figures
Sallowfield Garden Furniture is an invented brand selling outdoor furniture online. May is its busiest month. It runs paid search directly, uses an agency for paid social, which bills media and fee together in arrears, buys a small amount of Pinterest advertising billed in euros, and prints a summer catalogue.
Sallowfield's May budget, tracker and ledger
| Line | May budget | Marketing tracker (spent) |
|---|---|---|
| Paid search | £20,000 | £21,400 (from the platform) |
| Paid social media | £18,000 | £16,800 (from the agency's report) |
| Agency fee | £4,000 | £4,000 |
| £5,000 | £5,190 (€6,100 at the planning rate) | |
| Production (photo shoot) | £6,000 | £6,400 |
| Catalogue print | £5,000 | £4,800 |
| Total | £58,000 | £58,590 |
The ledger extract for marketing's cost centre for May:
| Ledger entry | Amount |
|---|---|
| Paid search invoice, after a £350 billing adjustment credit | £21,050 |
| Agency invoice for April paid social media and fee, booked to media | £19,900 |
| Pinterest card charges, converted at the billing-date rate | £5,310 |
| Catalogue print invoice | £4,800 |
| Total | £51,060 |
No April accrual was booked for the agency. The photo shoot invoice was approved by the operations manager and coded to the operations cost centre. The agency's May invoice will arrive in June.
Reconciling platform and ledger
Work from the ledger outwards. For each ledger line, find the tracker line it matches; for each tracker line, find where its cost sits in the ledger. Every difference falls into one of the causes the tracking guide lists: a coding error, a missed or duplicated accrual, a currency or credit difference, a cost marketing did not know about, or timing. Fix what can be fixed with an accrual or a recode request, and record the rest as known differences.
Task
- List every difference between the tracker and the ledger, with its cause and amount.
- State the accruals and recodes to send to finance before close, and how the April invoice should be split.
- Build a bridge from the ledger as booked to May's underlying cost, and check it against the tracker.
- Restate May as budget, actual and variance by line, label each variance timing or permanent, and give the June forecast and full-season effect.
- Show how the reconciliation changes paid social's return on ad spend for May.
Worked answer
The bridge, the variances and the corrected return
Bridge from the ledger to May's underlying cost:
| Step | Amount | Running total |
|---|---|---|
| Ledger as booked | £51,060 | £51,060 |
| Accrue May paid social media from the agency's report | +£16,800 | £67,860 |
| Accrue May agency fee | +£4,000 | £71,860 |
| Recode the photo shoot from operations to marketing | +£6,400 | £78,260 |
| Remove the April agency invoice, a prior-period item | −£19,900 | £58,360 |
Check against the tracker: £58,590 − £350 billing credit + £120 currency difference (£5,310 − £5,190) = £58,360. The two agree, so every difference is explained. Ask finance to split the April invoice into £15,900 media and £4,000 fee.
May as budget, actual and variance:
| Line | Budget | Actual | Variance | Type and explanation |
|---|---|---|---|---|
| Paid search | £20,000 | £21,050 | +£1,050 | Permanent: demand rose in warm weather and spend followed it |
| Paid social media | £18,000 | £16,800 | −£1,200 | Timing: creative approval slipped; spend moves to June |
| Agency fee | £4,000 | £4,000 | £0 | On budget |
| £5,000 | £5,310 | +£310 | Permanent: exchange rate above the planning rate | |
| Production | £6,000 | £6,400 | +£400 | Permanent: an extra shoot day |
| Catalogue print | £5,000 | £4,800 | −£200 | Permanent: lower print quote |
| Total | £58,000 | £58,360 | +£360 |
June forecast: £60,000 budget plus the £1,200 timing variance = £61,200. Permanent variances total +£1,050 + £310 + £400 − £200 = +£1,560, which goes into the next reforecast as a full-season overspend unless another line absorbs it.
Paid social attributed £61,000 of revenue in May. On the ledger as booked, its media line shows £19,900, a return on ad spend of 61,000 ÷ 19,900 = 3.07. On May's own media cost it is 61,000 ÷ 16,800 = 3.63.
The points to carry into the review:
- The ledger total finance sees for May will be higher than the budget once the accruals and recode are booked, because it still contains April's invoice. Say so before finance asks: the excess is a prior-period item, April was understated by the same amount, and the year is unaffected.
- Explain variances in finance's language. "Paid social underspent because creative approval slipped; the spend moves to June; no full-season change" is complete. "Optimising towards efficiency" is not.
- Report cost and outcome together. The paid search overspend matters less if its key performance indicator (KPIA metric tied directly to an objective.) beat plan; set the two side by side.
- Fix causes at source. Ask the agency to invoice media and fee separately and to send a month-end figure for accrual; agree with operations that shoots are coded to marketing.
Return on ad spend (ROASRevenue generated per unit of ad spend.) calculated on unreconciled cost is wrong in both directions, depending on which month the invoice lands in. The comparison of ROI and ROAS explains why finance builds return on investment (ROIProfit relative to cost.) only on reconciled ledger cost.
Common mistakes
- Treating the tracker as the record. After reconciliation, the ledger wins and the tracker is corrected.
- Leaving accruals to finance. Only the line owner knows what was delivered but not invoiced.
- Calling every variance timing. A price or exchange-rate change does not reverse next month.
- Netting differences. Two errors that cancel still need two explanations.
- Reporting return before close. Ratios on unreconciled cost mislead in whichever direction the timing falls.
Next, bring the whole level together in the quarterly marketing performance review capstone, or return to the intermediate marketing analytics level.
