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.
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.
| Record | Illustrative value | Review |
|---|---|---|
| Original contract | US$105 per unit. | Superseded for eligible orders. |
| Signed amendment | US$100 from 1 October. | Confirm supplier, item and effective date. |
| PO and invoice | 10 units at US$105. | PO and invoice match each other. |
| Potential variance | 10 × 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
| Stage | Illustrative record |
|---|---|
| Potential | US$50 variance flagged by the rule. |
| Validated | US$50 accepted after term and scope review, or reduced if an exclusion applies. |
| Recovered | Actual credit, corrected invoice or avoided payment tied to transaction evidence. |
| Reported | Finance-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.