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 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. 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
| Symptom | Check | Likely cause | Fix |
|---|---|---|---|
| The tracker runs ahead of the ledger on paid media every month | Which column the tracker reports: platform spend, commitments or spent with accruals | The two sides count different things | Compare spent against invoiced plus accrued; keep commitments apart |
| A cost appears in the wrong month, or twice | Last month's accrual list against the invoices booked since | Accruals missing, late or never reversed | Reverse from a list each month; check booked invoices before accruing |
| A known supplier's invoice is missing from marketing's lines | The supplier's invoices across all cost centres and cost types | Invoices coded elsewhere | Finance recodes; code orders when raised and check coding at approval |
| Marketing's total is larger than its line in the accounts | Which marketing costs sit in cost of sales or central cost centres | Costs booked outside marketing's lines by policy | Map them once with finance and show them as reconciling items |
| A ledger line exists that nobody in marketing bought | Allocation entries and the basis finance used | Shared costs allocated in | Ask for the basis and add an allocated column beside direct costs |
| Ledger lines with no matching row in the tracker | Order references on each ledger line | Invoices paid without an order or against the wrong one | Trace each to its buyer and order; match invoices to orders before approval |
| Last month's reconciled figures no longer match what was sent | The tracker's closed months against the saved version from the close | Closed months edited in the tracker | Restore 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 commitmentsMoney already promised to suppliers through a signed order, booking or statement of work, tracked apart from what has been spent or invoiced. 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 centreA code finance uses to group costs by the part of the business responsible for them; marketing's total is what has been booked to its cost centres. 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 orderFinance'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.. 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 closeThe point each month when finance books costs into the period and needs marketing's accruals, coded invoices and cleared orders by its deadline. 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 varianceThe gap between the budget, or the latest forecast, and the actual for a line, explained by its cause and marked as timing or permanent. 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)
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.
