Contract value realisation means checking that an agreed supplier benefit is delivered and evidenced. This free worksheet connects each commitment to its clause, calculation, owner and receipt record, with a fictional rebate example.
Use this worksheet for one contract and one benefit. Copy the fields into your approved working system. It is an operational tracking aid. The signed agreement and the appropriate contract owner determine the actual entitlement.
1. Turn the clause into a working record.
Field | What to record |
|---|---|
Commitment ID | A reference that connects the contract, evidence and action. |
Agreement and clause | Document version, clause and any relevant amendment. |
Trigger and eligibility | What must happen before the benefit applies? Which spend, sites or services qualify? |
Calculation | Rate, period, units, exclusions and agreed baseline. |
Evidence source | Invoice report, purchase ledger, delivery record or service data. |
Owner and reviewer | Who checks it, who challenges it and who confirms receipt? |
Dates | Measurement period, evidence due date and any notice or claim deadline. |
Current status | Expected, evidenced, submitted, disputed, received or closed. |
2. Separate entitlement from receipt.
Keep three amounts visible: the forecast, the amount supported by evidence and the amount actually received or reconciled. Do not count a claim and its later credit as two benefits. Record the reason whenever an estimate changes.
A useful action row is: commitment ID | issue | evidence link | supplier response | next action | owner | due date | amount outstanding.
3. Worked example: an annual rebate.
Illustrative terms: a supplier pays a 2% rebate on eligible net purchases once annual eligible spend reaches £100,000. The fictional agreement applies the rate to all qualifying spend once that threshold is met.
The buyer’s ledger shows £120,000. Checking the exclusions removes £10,000 of ineligible freight and £5,000 of returns. Eligible spend is £105,000. Under these example terms, the evidenced rebate is £2,100.
The supplier issues a £2,000 credit. Keep £100 open for reconciliation. Record £2,000 as received only when Finance confirms the credit has been correctly applied. A different contract might use marginal tiers, another measurement basis or different exclusions, which would change the result.
4. Give non-cash commitments their own evidence.
A response-time commitment needs a start event, a stop event, an agreed clock and service records. Training needs attendance or completion evidence. A price hold needs the correct item, period and invoice comparison.
Do not force every outcome into a savings number. Service reliability, risk reduction and released capacity can be reported separately with their assumptions. Use the member business-case guide when you need to explain the distinction.
5. Run a short monthly check.
Review commitments due before the next meeting.
Check whether the evidence is complete and the correct version is being used.
Reconcile receipts with Finance.
Assign disputed or missing amounts to a named owner.
Carry unresolved issues into the supplier review and renewal decision.
Finish with one clear record: what was due, what arrived, what remains open and who acts next.
This is an original WOP working template, developed around the ownership and supplier-review themes in the member library. For fuller templates and prompts, use contract ownership and handover, supplier performance reviews and renewal decisions.
Put this to work.
Explore the contract management guides to connect obligations, performance and renewal decisions.