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

Marketing Finance › Troubleshooting

Marketing Spend Not Matching the Ledger

Why marketing's spend figure and the finance ledger disagree: different numbers counted, accruals, wrong codes, costs booked elsewhere and unmatched invoices.
Troubleshootingintermediate12 min readUpdated

First, set the ledger lines beside the tracker and sort each difference by kind

Ask finance for the ledger extract for the period: every line booked to marketing's cost centres and cost types, with the supplier, the description and any order reference. Put the tracker's figures for the same lines and months beside it. Compare code by code, across cost centres, cost types and campaign codes, rather than only in total, because the coding tutorial points out that two coding errors can cancel each other and hide inside a total that matches.

Then label every difference: counting (platform spend on one side, an invoice on the other), timing (an accrual missing, late or never reversed), coding, a cost booked elsewhere by policy, an allocation finance charged in, an unmatched invoice or a changed history. Sorting first keeps the reconciliation from becoming an argument about the total.

Keep the roles straight while you work. The tracker tutorial treats the tracker as a working tool that never replaces the ledger: when a difference survives reconciliation, the tracker is brought into line with the ledger. Accounting policy, tax, approval limits and the ledger itself stay finance's; nothing here prescribes an accounting treatment. The RACI matrix gives each budget line and month-end step one accountable role, so every label has someone who will close it.

Two neighbouring problems have their own pages. If finance accepts the spend but rejects marketing's returns, the diagnosis for finance not trusting marketing numbers starts from the disputed return. If the figures agree but marketing is behind plan, the diagnosis for an underspent marketing budget separates timing from activity that did not happen.

Diagnosis table

Diagnosis

SymptomCheckLikely causeFix
The tracker runs ahead of the ledger on paid media every monthWhich column the tracker reports: platform spend, commitments or spent with accrualsThe two sides count different thingsCompare spent against invoiced plus accrued; keep commitments apart
A cost appears in the wrong month, or twiceLast month's accrual list against the invoices booked sinceAccruals missing, late or never reversedReverse from a list each month; check booked invoices before accruing
A known supplier's invoice is missing from marketing's linesThe supplier's invoices across all cost centres and cost typesInvoices coded elsewhereFinance recodes; code orders when raised and check coding at approval
Marketing's total is larger than its line in the accountsWhich marketing costs sit in cost of sales or central cost centresCosts booked outside marketing's lines by policyMap them once with finance and show them as reconciling items
A ledger line exists that nobody in marketing boughtAllocation entries and the basis finance usedShared costs allocated inAsk for the basis and add an allocated column beside direct costs
Ledger lines with no matching row in the trackerOrder references on each ledger lineInvoices paid without an order or against the wrong oneTrace each to its buyer and order; match invoices to orders before approval
Last month's reconciled figures no longer match what was sentThe tracker's closed months against the saved version from the closeClosed months edited in the trackerRestore from the version, post corrections in the current month and lock

Fix, verify and prevent each cause

The tracker and the ledger count different things

The guide to tracking spend against budget keeps committed, spent and invoiced apart and notes that a tracker holding only platform spend misses fees and production. The ledger holds invoices and accruals in finance's currency and month, while platforms report spend as delivered, sometimes in another billing currency or without tax.

Fix: compare like with like: the tracker's spent figure for each line against the ledger's invoices plus accruals, with commitments kept out of the comparison entirely, and lines added for fees and production if they are missing. Where platform spend is loaded into a warehouse, the guide to ad platform data in a warehouse explains differences against invoices here rather than patching the loaded data; currency and tax are finance's to confirm.

Verify: for a closed month, each line's spent figure roughly equals invoiced plus accrued, which the tracker tutorial treats as the test before a month is locked.

Prevent: label each tracker column with what it counts and report spend to finance only from the reconciled figure.

Accruals missing, late or never reversed

The tutorial on estimating marketing accruals sets the cycle: the line owner sends the estimate with a note of its evidence, finance posts it and reverses it once the invoice is booked, and last month's estimates are compared with the invoices that came in. Each break in that cycle moves the ledger away from the tracker: a missing or late accrual pushes the cost into a later month, and one never reversed, or raised for work already invoiced, counts the cost twice.

Fix: take last month's accrual list, find the invoice for each line, and ask finance to reverse any accrual still standing and to correct any duplicate. Before writing this month's note, check which invoices finance has already booked.

Verify: every accrual line pairs with a reversal when its invoice is booked, and no supplier appears twice for the same delivery.

Prevent: keep one accrual list that carries forward, make ticking it off against invoices the first task of each close, and send the new note before the cut-off.

Invoices coded to another cost centre or cost type

The tutorial on mapping marketing spend to finance codes starts from a simple constraint: the ledger reports cost only in the form it was coded. An agency invoice booked to a general or central cost centre vanishes from marketing's total and shows up in another team's; when media and fees share one cost type, the media line looks too large.

Fix: ask finance to search the period's invoices from marketing's suppliers across every cost centre, list the ones that belong to marketing, and let finance correct the ledger as it sees fit. Then fix the cause: every order carries its full coding (cost centre, cost type and a campaign code where one applies) from the day it is raised, and the approver checks the coding along with the amount before the invoice is approved.

Verify: the next reconciliation by code matches line by line, not only in total.

Prevent: keep one coding map with an owner and a change log, share it with everyone who raises orders or approves invoices, and tell regular suppliers which codes their invoices are booked to.

Costs that finance books outside marketing's lines

Some differences are not errors. The marketing P&L guide explains that classification is company accounting policy: affiliate commission and marketplace fees are often booked to cost of sales, discounts often reduce revenue, software may sit in a central technology budget, with salaries in a central people budget. A tracker that includes these costs will always exceed marketing's line in the accounts; one that adds them before checking how finance classifies them may count them twice against finance's figures.

Fix: with finance, map each such cost once: what it is, where the ledger holds it and whether marketing's reports include it. Show those costs as named reconciling items between the tracker total and marketing's ledger lines rather than asking for them to be moved.

Verify: the bridge from the tracker total to the ledger closes item by item.

Prevent: agree the conventions, including whether people costs count, and keep them stable, because a basis that changes between years makes every comparison meaningless.

Shared costs allocated in on a basis the tracker never shows

Finance may share a tool, a retainer or a central service across several cost centres, and marketing's share then appears in the ledger without any order or invoice marketing approved. The coding tutorial asks the two teams to settle where the ledger records such costs, and the guide to allocating shared marketing costs adds that direct and allocated costs belong in separate columns and that a method stays stable once agreed with finance.

Fix: ask finance for each allocation's basis and the period it covers, add an allocated-cost column to the tracker beside the direct lines, and record the method with the tracker. The basis itself, and any recharge between parts of the business, remain finance's.

Verify: each month the tracker's allocated column equals the ledger's allocation entries.

Prevent: write the method down with its sources, change it only when the business changes, and when it does, show the old and new basis side by side for a period with the date of the change.

Invoices paid without an order, or matched to the wrong one

The tutorial on purchase orders and invoice approval raises the order before the work, matches each invoice to the order and the delivery evidence, and checks the coding and the split between media and fees before approval. A supplier briefed by email with no order produces an invoice that reaches the ledger but never the tracker; an invoice matched to an old order lands on the wrong budget line; a combined media and fee invoice cannot be split once it is booked.

Fix: trace each ledger line with no tracker counterpart to the person who bought it, enter the cost on the right line, and ask finance to move any invoice matched to the wrong purchase order. For agreed extra work, update the order rather than leaving the invoice to stand alone.

Verify: every ledger line for the period carries an order reference that exists in the tracker's commitments log.

Prevent: no work without an order, no approval without the order and the evidence side by side, and an agency asked at the quote stage to bill media and fees as separate items.

Closed months edited in the tracker

A reconciliation needs a fixed starting point. The tutorial on setting up a marketing budget tracker locks each month once it has been reconciled to the ledger, saves a dated version at every close and reforecast, and puts corrections found later into the current month with a note, so what finance received at the close never changes. When someone reopens a closed month to correct a cost, the tracker's history moves and every later reconciliation starts from a figure finance never saw.

Fix: restore each closed month from the version saved at its close, post the corrections in the current month with a note of what they relate to, and lock the closed columns.

Verify: the totals for each closed month equal the figures sent to finance at its close, and the next reconciliation opens from the same position on both sides.

Prevent: lock every month as part of the month-end close and keep the dated versions where both teams can find them.

Prevention: one coding map, an accrual list reversed every month and a locked tracker

These gaps open in the same few places, so prevention is a short routine run at every close. The Chartered Institute of Marketing places financial control among the skills every marketer needs and stresses accounting for marketing's contribution the same way each time; in practice that means the same codes, the same accrual cycle and the same tracker history every month.

Keep one coding map: each kind of spend with its cost type, cost centre and any campaign code, agreed with finance, owned by one person and changed only through its change log. Orders carry the codes from the day they are raised, and approvers check them before an invoice is paid.

Keep an accrual list that is reversed every month. The list carries forward from close to close: each line is ticked off against its invoice and reversal, the new estimates are added with their evidence, and the note reaches finance before the cut-off.

Keep the tracker locked behind each close. Closed months do not change, corrections land in the current month with a note, and a dated version is saved at each close. An allocated-cost column and a short list of costs held outside marketing's lines make the bridge to the ledger part of the file rather than a monthly investigation.

Give the routine owners. Marketing holds commitments, delivery evidence, accrual estimates and the tracker; finance holds the ledger, the close and the accounting treatment; the reconciliation is decided together, which is the split the guide to working with a finance business partner suggests writing down line by line. A RACI row has one accountable role, so agree which side holds the reconciliation. The marketing budget month-end close checklist makes the monthly part a list to tick, and a variance explained only after the figures reconcile is one finance can act on. Other finance-side diagnoses are collected on the marketing finance troubleshooting hub.

A craft brewery walks the gap between its tracker and the ledger (illustrative)

Illustrative example — not a real result

Bragglefin Brewing reconciles a quarter with finance

Bragglefin Brewing, an invented craft brewery, closes a quarter with £148,600 of marketing spend in its tracker and £124,500 in finance's management accounts. The finance business partner asks which figure is right.

The marketing manager walks the £24,100 gap line by line. Four differences explain it, pointing both ways. The tracker holds £11,800 of March paid social taken from the platform, while the ledger holds nothing yet: the invoice arrived in April and no accrual was sent. The design agency's three invoices, £19,200 in total, were coded to a central brand cost centre and never reached marketing's lines. In the other direction, a £4,500 accrual for a beer festival stand was counted twice, because the February accrual was never reversed when the invoice was booked in March. And finance had allocated £2,400 of a shared design tool to marketing, which the tracker never showed. The ledger is £31,000 lower on the first two items and £6,900 higher on the last two, which nets to the £24,100.

Finance recodes the agency invoices and reverses the stale accrual, and treats the uninvoiced March spend as its policy sets once marketing sends the delivery evidence. The brewery then agrees one coding map with finance, keeps an accrual list that is reversed line by line every month, adds an allocated-cost column to the tracker and locks each month once it is reconciled. The next quarter's three closes reconcile line by line, with a single known difference of £310 from currency conversion on a platform invoice.

Common mistakes

  • Arguing about the total. The gap is a list; sort each difference by kind first.
  • Comparing platform spend with invoices. They count different things; compare spent with invoiced plus accrued.
  • Putting commitments in the comparison. A signed order reaches the ledger only when invoiced or accrued.
  • Reconciling only in total. Errors in opposite directions cancel out and hide.
  • Correcting the tracker to match a miscoded ledger. Ask finance to fix the ledger and fix the cause at source.
  • Asking finance to move costs it books elsewhere by policy. Show them as reconciling items instead.
  • Editing a closed month. Post the correction in the current month with a note.
  • Deciding accounting treatment in marketing. Classification, allocation bases and tax are finance's.

Frequently asked questions

Which figure is right, marketing's tracker or finance's ledger?

The ledger is the company's record of what it spent, and the tracker is a working tool that adds commitments and outcomes the ledger does not hold. When the two still disagree after a line-by-line reconciliation, the tracker is corrected to the ledger. The exception is a ledger line that is itself wrong, such as an invoice coded to another team's cost centre: then finance corrects the ledger in its own way, marketing fixes the cause at source, and nobody adjusts the tracker to match an error.

How close do the tracker and the ledger need to be?

There is no standard figure. Agree with your finance business partner the size of difference that needs no explanation, then list every difference above it as a known item with its cause, such as a currency difference or an invoice still in approval. Reconcile each cost centre, cost type and campaign code separately rather than only the total, because two errors in opposite directions can produce a total that matches while both lines are wrong.

Can marketing ask finance to change how its costs are coded or allocated?

Marketing can propose; finance decides. Cost centres, cost types, whether a cost sits in cost of sales or operating expense, and the basis for sharing costs across teams are company accounting policy and finance's systems. Marketing's part is to describe each purchase, its delivery date and the campaign it supported, to request codes that help it make decisions, and to show any allocation finance applies in its own reports so the figures can be traced.

Terms used on this page

Frameworks

Where this page is used

Sources

  1. Chartered Institute of Marketing — CIM

Related