Skip to main content
Start your 14-day free trial — full platform access, no credit card required.Start Free Trial →
Skip to article content
Workflow Automation

Three-Way Media Invoice Reconciliation: Matching Insertion Orders, Proof of Execution & Make-Goods in 2026

Stop losing 3% to 7% of your media budget to billing discrepancies. Learn how automated 3-way matching across Insertion Orders, Proof of Execution, and Vendor Invoices works in 2026.

11 min read
Media finance controller matching insertion orders, proof of execution affidavits, and vendor invoices

Direct Answer: What Is Three-Way Matching in Media Buying and Marketing Procurement?

Three-way matching in media buying is the automated financial control that verifies three independent records before a publisher or agency invoice is approved for payment: (1) the Commercial Authorization (InsertionOrder or PurchaseOrder tied to an approved MediaPlanVersion and MediaCommercialTerm), (2) Verified Delivery & Proof of Execution (MediaDeliveryRecord + verified proof_of_execution affidavits/screenshots + resolved MediaMakeGood credits), and (3) the Vendor Invoice (AgencyInvoice).

In corporate procurement for physical goods, no ERP would ever pay a factory invoice without matching the Purchase Order against the warehouse receiving dock slip. Yet in advertising, brands routinely wire millions of dollars to publishers and media agencies based on two-way (or even one-way) review—checking only that the invoice total roughly matches the overall campaign budget. Industry audits consistently show that unreconciled media invoices leak 3.2% to 7.8% of working media spend through uncredited under-delivery, rate-card overbillings, and unauthorized flight extensions.


Key Takeaways

  • Never Pay on Invoice Alone: An invoice is a vendor's claim for payment, not proof that the media actually ran at the contracted rate and guaranteed volume.
  • Lock the Insertion Order to the Exact Media Plan Revision: Every InsertionOrder must stamp the media_plan_version_id and negotiation_term_ids that authorized it. If a planner edits a spreadsheet without a governed IO amendment, the 3-way match breaks.
  • Require Verified Proof of Execution Before Invoice Match: Screenshots, broadcast affidavits, tear sheets, and third-party ad server delivery logs must be transitioned to Verified status before the finance team releases funds.
  • Resolve Under-Delivery via Make-Goods or Credit Memos First: When delivered impressions or GRPs fall below guaranteed_volume, log a MediaMakeGood (bonus weight or invoice credit) before marking the Insertion Order Matched and financials_locked: true.

The Anatomy of the Media 3-Way Match

| Leg of the Match | Mediasphere Entity & Ledger | What Is Verified | Common Discrepancies Caught | | :--- | :--- | :--- | :--- | | Leg 1: Commercial Authorization | MediaPlanVersion → MediaCommercialTerm → InsertionOrder / PurchaseOrder | Contracted buy type (CPM, CPC, CPA, Flat, GRP), negotiated rate, flight dates, and guaranteed_volume | Vendor bills standard rate-card CPM instead of the negotiated 18% agency discount | | Leg 2: Physical Delivery & Proof | MediaDeliveryRecord + InsertionOrder.proof_of_execution + MediaMakeGood | Actual delivered impressions/clicks/spots, verified tear sheets/affidavits, and make-good fulfillment | Flight under-delivered by 14% or ran the wrong regional creative cut | | Leg 3: Financial Settlement | AgencyInvoice + MediaReconciliationEntry | Line-item billed quantities, unit rates, taxes, discounts, and currency against Leg 1 & Leg 2 | Duplicate billing of a prior month's flight or unapproved production pass-throughs |


Why Traditional Accounts Payable (AP) Teams Cannot Audit Media Invoices

Corporate Accounts Payable teams use ERPs (NetSuite, SAP, Coupa) built for unit-priced widgets. When a publisher or media agency submits a $340,000 monthly invoice containing 45 line items across Programmatic Display, CTV, Paid Social, and Print:

  • The AP clerk has no access to the ad server or MediaDeliveryRecord ledger to check whether Line Item #12 actually delivered its guaranteed 8,000,000 impressions.
  • The AP clerk cannot tell whether a CPM buy was contracted on a Bill-on-Actuals (Capped at IO Ceiling) basis or a Flat Sponsorship basis.
  • The AP clerk has no visibility into whether the publisher promised a 1,200,000-impression Make-Good in next month's flight to compensate for a dark week in October.

Because AP lacks media context, they simply forward the PDF invoice to a busy Marketing Director with the message: "Please reply 'Approved' so we can pay this." The Marketing Director glances at the bottom-line total, replies "Approved," and $22,000 in under-delivery walks out the door.


Step-by-Step: Running an Automated 3-Way Media Reconciliation Workflow

Step 1: Authorize Insertion Orders From Locked Plan Revisions

In Mediasphere, an InsertionOrder is never created in a vacuum. Using generateIOFromMediaPlan, the system stamps:

  • media_plan_version_id: The exact approved snapshot of the media plan.
  • negotiation_term_ids: The approved commercial rate cards, volume rebates, and added-value terms (MediaCommercialTerm).
  • Structured line_items: Each specifying buy_type, rate, quantity, guaranteed_volume, amount, flight_start, flight_end, and authorized creative_ids.

Step 2: Collect and Verify Proof of Execution (proof_of_execution)

As flights go live and complete, traffickers or agency partners upload structured proof_of_execution items to the Insertion Order (insertionOrderAction):

  • Screenshot (digital/social placements)
  • Broadcast Affidavit (linear TV and radio station logs)
  • Tear Sheet (print publications)
  • Publisher Confirmation / Platform Report (first- and third-party verification exports)

An internal media verifier inspects each submission and transitions verification_status from Pending to Verified (or Rejected with a rejection_reason), writing an immutable entry to InsertionOrder.audit_trail.

Step 3: Reconcile Delivery Against Guaranteed Volume

Using getFlightDelivery and reconcileMediaLedger, compare cumulative delivered volume (MediaDeliveryRecord) against each IO line item's guaranteed_volume:

  • Scenario A: Full Delivery ($\ge 100%$ of Guarantee). The line item is eligible for full contracted billing up to the IO ceiling.
  • Scenario B: Under-Delivery ($< 100%$ of Guarantee on CPM/GRP Buy). The system flags a Discrepancy. Before paying the full IO amount, the media buyer must either:
    1. Require the vendor to issue a Revised Invoice / Credit Memo billed strictly on actual delivered units, OR
    2. Authorize a formal MediaMakeGood (tracking bonus impressions, replacement flight dates, and make-good verification).

Step 4: Match Invoice Lines & Lock Financials (InvoiceLineMatcher & IOReconcileDialog)

When the AgencyInvoice arrives, open the IO Reconcile Dialog to link the invoice (matched_invoice_ids) and run line-by-line matching:

  • If billed amount, contracted rate, and verified delivery align within tolerance, transition reconciliation_status to Matched.
  • If a variance exists, set reconciliation_status to Discrepancy, record discrepancy_notes, and place the invoice in Disputed status via agencyInvoiceAction.
  • Once reconciled and settled, the Insertion Order stamps financials_locked: true, preventing any retroactive tampering with historical line items.

Financial Control Checklist for Marketing Procurement & CFOs

  1. Ban Un-Versioned Media Plan Edits: Require every mid-campaign budget shift or flight extension to generate a new MediaPlanVersion and a governed IO amendment.
  2. Enforce Proof of Execution Gates by Channel: Require at least one Verified Broadcast Affidavit or Tear Sheet for every offline IO line item and a Verified Platform Report for every digital line item before invoice approval.
  3. Audit Make-Good Fulfillment Before Year-End Close: Run a quarterly sweep of all MediaMakeGood records in Pending or In Flight status so owed bonus inventory is never forgotten across fiscal years.

Frequently Asked Questions (FAQ)

What happens when an agency invoice exceeds the approved Insertion Order total?

In Mediasphere, the reconciliation engine (reconcileMediaLedger and IOReconcileDialog) immediately flags any invoice whose total exceeds the authorized InsertionOrder.total_amount or whose unit rate exceeds the contracted MediaCommercialTerm rate. The IO is placed into Discrepancy status and the invoice can be marked Disputed with mandatory decision_notes until the vendor issues a corrected bill or a formal IO amendment is approved.

How are make-goods tracked so we don't pay twice for under-delivered media?

When a flight under-delivers, the media buyer creates a MediaMakeGood record linked to the original MediaFlight and InsertionOrder. The make-good tracks the owed value/impressions, the agreed remedy (Bonus Inventory, Flight Extension, or Credit Note), and its own delivery verification status—ensuring the credit or bonus weight is fully delivered before the parent IO is closed.

Can non-admin users alter an Insertion Order after it has been reconciled?

No. Insertion Order lifecycle transitions (status), proof_of_execution verifications, reconciliation_status, and financials_locked flags are server-owned fields protected by Row-Level Security (RLS) and governed exclusively through the insertionOrderAction and reconcileMediaLedger backend functions, with every action logged in InsertionOrder.audit_trail.

  • Insertion Orders
  • Invoice Reconciliation
  • Proof of Execution
  • Make-Goods
  • Media Finance
  • automotive
  • agencies_holdings
Share:

Ready to transform your creative workflow?

Join teams using Mediasphere to streamline asset management, approvals, and creative production.

Start Free Trial

Related Articles

Comments (0)

Sign in to post a comment or join the discussion.

Sign In

No comments yet. Be the first to share your thoughts!

We respect your privacy. We use essential cookies to keep MediaSphere secure and optional analytics and marketing cookies to measure performance. Read our Privacy Policy or Trust Center.