Practical perspectives

Contract Rate vs Invoice: A Variance Review Worksheet

Work through an invoice that matches the PO but conflicts with an effective contract rate, and document the resolution.

On this page
  1. Find the term
  2. Normalize the line
  3. Resolve with owners
  4. Measure the result

A three-way match can pass while the supplier still charges more than the current contract rate. The buyer needs to identify the governing term, compare like units, and resolve the claim before reporting any recovered value.

This fictional worksheet complements the contract price compliance software guide. It does not estimate the performance of any vendor product.

1. Find the applicable agreement and amendment

Start with supplier legal entity, item or service, contract version, amendment, date, geography and volume tier. A price table without an effective date may be the wrong benchmark. Preserve the signed clause and reviewer correction when extraction is uncertain.

Fictional rate check
RecordIllustrative valueReview
Original contractUS$105 per unit.Superseded for eligible orders.
Signed amendmentUS$100 from 1 October.Confirm supplier, item and effective date.
PO and invoice10 units at US$105.PO and invoice match each other.
Potential variance10 × US$5 = US$50.Provisional until charges and eligibility are checked.

2. Explain the apparent variance

Check unit of measure, contracted quantity tier, freight, tax, currency conversion, rebates and whether the invoice line falls inside the amendment scope. If the PO was issued before the amendment but delivered after it, ask which date legally governs; do not let the model silently choose.

  • Source: keep the exact clause and amendment page beside the invoice line.
  • Timing: record contract and PO dates plus the invoice service period.
  • Math: show quantity, unit conversion and excluded charges.
  • Exception: mark unresolved terms as review needed rather than a confirmed overcharge.

3. Route the claim and reconcile the outcome

Procurement may negotiate the commercial interpretation, AP may hold or adjust the invoice, and the supplier may issue a credit. Capture the owner, supplier response, credit-note reference and final paid amount. If the business authorizes a higher price, preserve that exception rather than rewriting the contract history.

Fragment describes using contract prices alongside PO, receipt and invoice records in exception investigations ↗. Spendkey presents commercial spend and contract controls ↗. Ask each provider to demonstrate where the contract term is linked and how the final resolution appears in AP.

4. Separate detected, accepted and recovered value

Outcome stages for the example
StageIllustrative record
PotentialUS$50 variance flagged by the rule.
ValidatedUS$50 accepted after term and scope review, or reduced if an exclusion applies.
RecoveredActual credit, corrected invoice or avoided payment tied to transaction evidence.
ReportedFinance-approved treatment under the organization’s savings policy.

The detected amount should never be described as realized savings until the payment outcome and Finance’s accounting treatment are known.

Sources