REVIEW ORDERS · TOOL 1 · BETA
Order & Contract Validator
Check advertising orders against contract terms before log preparation.
Saved on this device in this browser. Cloud and organization storage are not connected. Tool membership is required for exports. Passing checks does not approve a contract.
Illustrative sample data. All advertisers, orders, contracts, and delivery summaries in this sample are fictional.
Imports, validation scope, and data storage
Orders and contract terms are entered manually or imported from CSV. PDFs may be attached locally as references; the tool does not extract or interpret their terms automatically. Match each order to an explicit Contract ID and Version.
Required order CSV headers: order_id,advertiser. Supported columns: . Missing operational values are flagged during validation. Invalid dates, negative numbers, duplicate IDs, or malformed CSV are rejected before import.
Required contract CSV headers: contract_id,advertiser,service,start,end,rate. Supported columns: . Times are whole seconds; Spot quantity is a count of spots, CPM quantity is impressions, and Flat Fee quantity is fee units. Rates retain up to six decimals; totals round to two. All comparisons require matching currency and pricing units.
Imports append new records after confirmation, without replacing existing IDs. Limits: 5 MB per CSV, 5,000 orders, 2,000 contract versions. A contract attachment is limited to 10 MB. Files and records stay in this browser; deleting browser data can remove them.
Validation is dated and tied to the supplied records. Changes to an order, its contract, linked quantity, or the current date require revalidation. Reports show Unreviewed for stale results. Checks are operational comparisons, not contract approval or legal certification.
Delivery and makegood summaries are user-entered references. Reconciliation and Makegood Manager are not connected to this tool yet. Unknown delivery is not zero delivery. Open makegoods may overlap undelivered quantities; they are not added together or automatically treated as money owed. Credit adjustments require review; this is not an accounts-receivable balance.