Media Plan and Buying Tracker for Agencies and Brands (Excel)

Plan, buy, track and pay for media in one workbook. Every plan line pulls its vendor, rate, discount and currency from your rate card, units flow in from a weekly flowchart or a daily spot schedule, and every purchase order, delivery entry, invoice and client bill rolls up to the campaign budget and the dashboard. Formula-driven, no macros, protected formulas.

• Masters: clients (terms, agency fee), markets and audience universes, vendors and a rate card with validity dates
• Campaigns with approved budget, approval record, budget used and a control check
• Media plan: gross, discount, net, agency fee and total cost by line, with GRPs, impressions, net CPM and CPP; bonus and FOC spots; negotiated rate and discount overrides
• Weekly flowchart for every channel and a day-by-day spot schedule for TV and radio, with 12-month phasing
• Purchase orders with VAT and a required approver from your approval matrix
• Delivery log (proof of performance) feeding delivery % and delivered value
• Vendor invoices with a 3-way match against PO and delivered value, due dates, ageing and payment status
• Client billing with receipts, ageing and a check against the planned total
• Dashboard: 12 KPIs, spend by channel, monthly phasing, line status, top vendors and control exceptions, filtered by campaign
• One-page Budget Summary by channel and month for client sign-off
• Base currency of your choice (AED by default) with GCC and major exchange rates, spot-length factors and VAT rates you can edit
• Illustrative GCC example campaign so you can see every module working before you enter your own data

Questions buyers ask

Who is it for?

Media agencies and in-house marketing teams that plan, book and pay for media across TV, radio, digital, outdoor and print, and want one workbook from rate card to client invoice.

Does it need macros or special software?

No macros. It runs on formulas in Microsoft Excel, and the formula cells are protected (without a password) so they are hard to break by accident.

How does the 3-way match work?

Each vendor invoice is checked against its purchase order and against the value delivered in the delivery log, so over-billing, missing spots and invoices that are ready to pay show up straight away.

Can I plan in more than one currency?

Yes. Choose a base currency (AED by default) and plan lines in other currencies using the GCC and major exchange rates in the settings. VAT rates can be edited.

Can I send the plans to my clients?

Yes. The licence lets you send clients the plans, budget summaries and reports the workbook produces. The workbook itself may not be passed on.

What does it calculate?

Gross, discount, net, agency fee and total cost per line, GRPs, impressions, net CPM and cost per point, delivery % and delivered value, and a dashboard with 12 KPIs that you can filter by campaign.

Licence: one purchaser downloads the file and may use, adapt, rebrand and share it inside their own company, and send clients the plans and reports it produces. No resale or redistribution of the workbook. Full terms are in the MPE-LIC License Terms included with your download.

A template, not financial, tax or legal advice. Check VAT treatment, exchange rates, audience data and approval limits with your finance team before use. Example vendors, rates and audiences are fictitious.