ZeroDelay Academy · Follow-up and handoff worksheet
Supplier price variance: agreed unit price vs invoice
When a supplier invoice does not match what you expected, several different things may be going on at once: a unit price that differs from the agreed price, a quantity that differs from what was accepted, a substitution, an approved change, or freight and tax lines. Lumping them together makes every difference look the same. This worksheet isolates the price question by comparing the agreed unit price with the invoiced unit price at the same accepted quantity, and records the other causes in their own columns. A difference is a question to review with the supplier, not proof of an error, and not a reason on its own to withhold payment.
By ZeroDelay.ai · An educational framework, not a customer case study
A question to start with
For each invoice line, at the quantity you actually accepted, does the invoiced unit price match the agreed price, and if not, what explains the difference?
Step 1
Match the line to the agreement and receipt
For each invoice line, find the purchase order or written price agreement and your record of what was received and accepted (a delivery note or goods received record). Use the accepted quantity for the price comparison, so a quantity difference does not show up as a price difference.
Step 2
Compare price at the accepted quantity
Multiply the accepted quantity by the agreed unit price and by the invoiced unit price. The gap between the two is the price difference for that line. Record quantity differences, substitutions, approved changes, and freight or tax lines in separate columns rather than folding them into this figure.
Step 3
Classify, assign and resolve
For any difference, note whether a recorded change approval exists, name an owner to raise it with the supplier, and record the outcome as the supplier and your records show it: confirmed price change, credit agreed, corrected invoice, or accepted as is. Payment decisions follow your own terms with that supplier and your accountant's advice.
Records to gather first
- The purchase order, quote or written price agreement for each item.
- Delivery notes or goods received records showing accepted quantities.
- The supplier invoice, with unit prices and any freight, fees or tax lines.
- Any recorded approval for price changes or substitutions.
- Notes of supplier conversations and the resolution agreed.
Copy or print this blank worksheet
Copy the table into your own document or use your browser's Print command, then fill it in there or on paper. There are no entry fields here, nothing is saved, and numbers you write do not transfer into the diagnostic.
| PO / ref | Item | Accepted qty | Agreed unit price $ | Invoiced unit price $ | Price difference $ | Change approval ref | Owner | Resolution |
|---|---|---|---|---|---|---|---|---|
| Line 1 | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
| Line 2 | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
| Line 3 | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
| Line 4 | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
| Line 5 | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
| Line 6 | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
| Total | ______ | ______ | ______ | ______ | ______ | ______ | ______ | ______ |
Fictional worked example
All figures are made-up assumptions to show the arithmetic. They are not industry benchmarks, customer data, achieved outcomes or a forecast for your business.
Assumptions
- Fictional single invoice line: 10 units received and accepted, matching the quantity ordered.
- Agreed unit price on the purchase order: $18. Invoiced unit price: $20.
- No substitution, no recorded change approval, and freight and tax are on separate lines and excluded from this comparison.
Simple math
- Agreed cost at accepted quantity: 10 × $18 = $180.
- Invoiced cost at accepted quantity: 10 × $20 = $200.
- Price difference: $200 − $180 = +$20.
- As a share of the agreed amount: $20 ÷ $180 = 0.111, or 11.1% rounded.
- The $20 is an open review question. It is not automatically a recoverable credit, a supplier error or a confirmed margin loss.
What this suggests checking: One owner raises the $20 line with the supplier, attaching the purchase order and receiving record. The answer might be a corrected invoice, an agreed credit, or a legitimate price change you had not recorded. Only once it is resolved does it belong in your job cost or completed-job review.
What this cannot tell you
- Not legal, tax, accounting or payment-terms advice, and not a rule about when to withhold or delay payment.
- A price difference does not imply error, fraud or theft. Many differences have documented explanations.
- Separate from outgoing customer invoicing (see the service invoice readiness check) and from completed-job cost review.
- No supplier, purchasing or payment system integration is provided. Fictional figures only.
Public reading and methodology
The worksheet, steps and fictional arithmetic on this page are original to ZeroDelay.ai. The public pages below cover related topics; they were read for context and do not validate any outcome from this worksheet or from ZeroDelay.
- Invoice Reconciliation in Construction: Match POs, GRNs & Invoices (Site Samurai). UK software vendor resource. Used only for matching terminology (purchase order, goods received note, invoice). Its UK VAT, CIS, legal or payment-terms content and software claims are not adopted, and no outcome evidence, integration or endorsement is implied.
Choose a next step from your worksheet
After verifying the supplier difference, compare the job's estimated and actual costs before assuming a customer price change is needed. Carry verified costs into your own job-cost review.
If this worksheet raises a wider business question, the diagnostic below uses the answers you provide about your business; it does not import this worksheet or calculate its results. View the fictional sample 90-Day Plan to see an illustrative complete paid report, not your free results or a promised outcome. Available market research varies.