How do you track ad spend against an insertion order or purchase order?
To track ad spend against an insertion order or purchase order, record the approved amount, dates and the campaigns it covers, then compare cumulative spend with the amount each day to calculate burn rate and the date the order will run out. Set alerts at agreed thresholds, and reconcile platform spend with the invoice at month end. Keep one record per order so a campaign is never counted against two.
Key takeaways
Set up the record
- Order number, client and approver
- Approved amount and currency
- Start and end dates
- The platform accounts and campaigns it covers
Calculate burn and run-out
Burn rate is cumulative spend divided by the amount. Run-out date is the remaining amount divided by recent average daily spend, added to today. Use a recent window, such as the last seven days, so it reflects current delivery.
Worked example, hypothetical numbers only: a $30,000 order with $18,000 spent and a recent average of $600 a day has $12,000 remaining, so it runs out in about 20 days.
Bring your funnel numbers to a 30-minute pipeline plan session. We show where spend is leaking against your CRM data and what to fix first.
Alerts and escalation
- Warn at an agreed share of the order consumed
- Warn when the run-out date falls before the end date
- Warn when spend is on pace to finish well under the amount
Reconcile with invoices
Compare platform spend with invoices each month and explain differences such as timing, taxes or credits. Pacing Console sends finance a month-end accrual by client and platform that can start the reconciliation.
Frequently asked questions
How do you track spend against a purchase order?
Record the amount, dates and covered campaigns, compare cumulative spend each day and estimate the run-out date from recent average daily spend.
What is a run-out date for an ad budget?
The date the remaining approved amount will be consumed at the recent average daily spend.
How often should I reconcile ad spend with invoices?
Monthly at least, and sooner if spend is volatile.
Related service: Paid media. See also pricing and client results.
We run enterprise B2B demand generation for teams in Montreal, Toronto, Ottawa and the United States.