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

Marketing Analytics and Reporting › Intermediate

Reconciling Marketing Spend for a Garden Furniture Brand

An exercise in the month-end routine finance expects from marketing: match the ad platforms and marketing's tracker to the ledger line by line, find the cause of every difference, book the accruals and recodes that put cost in the right month, and restate the month as budget, actual and forecast with each variance explained as timing or permanent.
ExerciseIntermediate levelModule 3: Finance-facing reporting5 minUpdated

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.

Illustrative example — not a real result

Sallowfield's May budget, tracker and ledger

LineMay budgetMarketing 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
Pinterest£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 entryAmount
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

  1. List every difference between the tracker and the ledger, with its cause and amount.
  2. State the accruals and recodes to send to finance before close, and how the April invoice should be split.
  3. Build a bridge from the ledger as booked to May's underlying cost, and check it against the tracker.
  4. Restate May as budget, actual and variance by line, label each variance timing or permanent, and give the June forecast and full-season effect.
  5. Show how the reconciliation changes paid social's return on ad spend for May.

Worked answer

Illustrative example — not a real result

The bridge, the variances and the corrected return

Bridge from the ledger to May's underlying cost:

StepAmountRunning 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:

LineBudgetActualVarianceType and explanation
Paid search£20,000£21,050+£1,050Permanent: demand rose in warm weather and spend followed it
Paid social media£18,000£16,800−£1,200Timing: creative approval slipped; spend moves to June
Agency fee£4,000£4,000£0On budget
Pinterest£5,000£5,310+£310Permanent: exchange rate above the planning rate
Production£6,000£6,400+£400Permanent: an extra shoot day
Catalogue print£5,000£4,800−£200Permanent: 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 (KPI) 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 (ROAS) 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 (ROI) 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.

Pages this lesson applies

Terms used on this page

Also related

Related