Monthly Ad Spend Reconciliation for Agencies: A Practical Guide
A step-by-step process agencies can use to reconcile platform-reported advertising spend with internal expense and billing records every month, and the most common causes of variances.
Ad spend reconciliation is the monthly check that the spend reported by each advertising platform matches what the agency recorded and billed. Pull final platform spend per account, line it up with agency records for the same period and currency, investigate every variance above a set threshold, and mark the period as reconciled once differences are explained.
Why reconciliation matters
Agencies often pay for media on behalf of clients and re-bill it, sometimes with a fee or margin. If platform spend and agency records drift apart, the result is under-billing, over-billing or disputes with clients. A consistent monthly routine catches differences while they are still small and easy to explain.
A five-step monthly process
- Wait for final numbersAdvertising platforms can adjust recent days for a short period, for example after removing invalid activity. Run reconciliation a few days after month end so the month's figures have settled.
- Collect platform spend per accountExport spend for every ad account for exactly the calendar month, in the account's billing currency. Make sure the time zone used for the month matches your records.
- Line it up with agency recordsMatch each ad account to the client and to the expense, invoice or purchase-order entries for that month. Keep the original currency next to any converted amount.
- Investigate variancesCalculate
variance = platform spend − agency recordfor each account. Agree a threshold (an absolute amount or a percentage) and explain every variance above it. - Close the periodRecord the explanation, adjust invoices if needed, and mark the account and month as reconciled so the period is not reopened by accident.
Common causes of variances
| Cause | What it looks like | How to resolve |
|---|---|---|
| Time zone mismatch | Small differences at the start and end of the month | Use the ad account's time zone for both sides |
| Late platform adjustments | Spend changes after the first export | Reconcile after figures settle; re-pull final numbers |
| Currency conversion | Converted totals differ from invoices | Reconcile in the billing currency; document the rate used |
| Missing or extra accounts | Spend with no matching record, or vice versa | Review the account-to-client mapping |
| Taxes and fees | Records include VAT or fees, platform spend does not | Compare net to net, add fees separately |
| Credits and refunds | Negative adjustments on invoices only | Record credits as separate lines with references |
A reconciliation checklist
- Every active ad account is mapped to exactly one client.
- Platform spend and records cover the same dates and time zone.
- Comparisons are made in the billing currency, with converted values clearly labeled.
- A variance threshold is agreed with finance.
- Every variance above the threshold has a written explanation.
- Reconciled periods are marked and locked.
How AdNumora helps
AdNumora synchronizes spend from the ad accounts you authorize through official platform APIs, groups accounts by client, and lines up platform-reported spend with your agency records month by month. Variances are highlighted and each client and period carries a reconciliation status, so month end takes fewer spreadsheets. See the reconciliation feature.
FAQ
How often should agencies reconcile ad spend?
At least monthly, in line with client billing. High-spend accounts may benefit from a weekly check as well.
Should reconciliation be done in the billing currency or the reporting currency?
In the billing currency, because that is what invoices are based on. Converted values are useful for portfolio reporting but add exchange-rate differences.