Procurement variance control
A higher invoice total does not always mean the unit price increased. Quantity, pack conversion, currency, discount, freight, specification and order changes can move the total in different directions and need different owners.
Direct answer
Analyze purchase price variance by defining two comparable baselines before calculating a percentage. Use the latest authorized purchase order or amendment for expected unit price, currency, unit of measure, quantity tier, Incoterm, discount, allowance and separately agreed charges. Use the invoice plus accepted receipt for actual payable scope. Normalize SKU, variant, revision, selling unit, pack conversion and currency. Calculate price variance on comparable accepted quantity: actual comparable unit price minus authorized comparable unit price, multiplied by the quantity under review. Then isolate drivers that are not true unit-price changes: quantity-tier movement, exchange-rate timing, freight or fuel, tooling, packaging, expedite fees, tax, discounts, rebates, substitutions, specification changes, order amendments, over-delivery and invoice errors. Keep market movement or supplier explanation separate from authorized commercial change. Link each driver to evidence and owner, state whether it is favorable, unfavorable, planned, approved, disputed or timing-only, and reconcile the sum to the invoice difference. Use the result to correct invoices, forecasts, sourcing decisions or controls; do not use purchase price variance alone as a supplier-performance verdict or product-margin calculation.
Use this before requesting a quotation
Identify PO, revision, supplier acknowledgment, approved change, receipt, acceptance and invoice. Record line IDs and dates. Expected cost should come from the controlling authorized document, not an old quote or budget unless the analysis is explicitly budget-to-actual. Actual payable scope should exclude rejected, held or disputed quantity according to the agreement and control process.
Match buyer SKU, supplier model, variant, revision and pack level. Convert pieces, inner packs, cases, kilograms or other units through an approved factor. Separate free goods and samples. A case-price comparison against a piece-price baseline creates a large false variance even when commercial terms did not change.
Record PO currency, invoice currency, exchange-rate source, rate date and whether purchasing or finance owns exchange variance. Show the supplier price in transaction currency before translation. Do not label currency movement as supplier price increase, and do not choose a favorable rate date after seeing the outcome.
Compare authorized and actual unit prices on the same price basis, currency and accepted quantity. Show gross price, discounts, allowances and net unit price separately. State formula and sign convention. If several tiers or deliveries apply, calculate by line and tier before adding totals; an average can hide an unauthorized price on one SKU.
Break total difference into true price, quantity tier, mix, specification or material change, packaging, tooling, expedite, freight, fuel, duty or tax treatment, discount, rebate, rounding and invoice error. Link every driver to an order change, rate or source record. The bridge total should reconcile to the defined actual-versus-expected amount without an unexplained plug.
Mark each driver as planned, approved, disputed, timing, system or unknown. Assign purchasing, finance, logistics, quality, warehouse or supplier owner. Separate commercial reason from accounting treatment. A supplier explanation may describe cause but does not prove buyer approval; an approved order change should update future baselines rather than recur as a surprise.
Correct invoice or PO data, request credit, approve supported change, update forecasts or address contract and process gaps. Track large or recurring drivers without punishing suppliers for buyer-authorized scope. Preserve calculation, source versions and approval. Compare later periods using the same formula and revise baselines only through controlled authority.
Reusable buyer brief
Supplier, PO, revision, receipt, invoice and line IDs: SKU, model, variant, revision and accepted quantity: Expected currency, unit, tier, price, discount and Incoterm: Actual currency, unit, price, discount and payable scope: Pack or unit conversion and approved source: Exchange-rate source, rate date and translated value: Comparable expected and actual net unit price: Unit-price variance formula, quantity and result: Quantity, mix, freight, tax, packaging and other drivers: Approved change, dispute, timing or error classification: Driver owner, evidence, credit/correction and due date: Reconciled total, approval and updated future baseline:
Fill only the details relevant to your request
Before you send the request
It is a comparison between an expected or authorized purchase price and an actual purchase price on a defined comparable basis. The exact accounting definition must be set internally.
A common operational view multiplies actual comparable unit price minus authorized comparable unit price by the comparable quantity. State currency, unit, quantity and sign convention.
Only if the defined measure includes it. Otherwise show freight as a separate driver so base product price and transport cost are not confused.
It is one input, not a verdict. Buyer changes, quantity tiers, currency, mix and approved scope can create variance without supplier underperformance.
Keep the request specific
Accounting definitions, standard cost, exchange treatment, tax, freight allocation and materiality vary by company and jurisdiction. Define the measure with qualified finance staff. This template does not determine fair price, supplier liability, customs value, retail margin or the accounting entry.
Send this checklist on WhatsAppEditorial method
MINJI defines comparable expected and actual records before isolating price, quantity, currency and scope drivers. UN/CEFACT sources support ordered-price, invoice-price, received-quantity and dispute relationships without prescribing one accounting formula.
Ready with the key details
Send the product reference, estimated quantity and destination so the conversation starts with useful context.
Continue on WhatsApp