Sourcing

Checking invoices against agreed prices

Updated 6 min readMarkdown
In short

A negotiated price is worth what later invoices bill. Check every invoice line against the agreement that applies to it: same supplier, same item, same unit, invoice date within the validity, delivery site within the scope. A line billed above the agreed price is an overcharge of (price billed minus agreed price) times quantity, to be claimed as a credit note. The saving is measured on the same lines as quantity times (price before minus price billed), month by month. It is a different figure from the saving the offer promised, because quantities and billed prices differ from the plan.

An agreed price is a promise until the next invoice arrives. Whether it was kept is decided line by line: the supplier's system has to bill the new price for the right item, in the right unit, from the right date, for the right site. Each of these goes wrong often enough that the check is worth making on every invoice, and the same check tells you what the agreement has actually saved.

What an agreement must record to be checkable

An agreement that lives in an email thread cannot be compared with an invoice. Write down these fields for every item:

FieldWhy it is needed
SupplierAn agreement binds one supplier, not the market
Item, with the supplier's article numberThe invoice line has to be matched to it
UnitA price per box says nothing about a price per carton
Agreed unit price and currencyThe figure the invoice is compared with
Valid from, valid untilAn invoice dated outside the period is not covered
Delivery sitesA price agreed for certain sites applies only there
Price beforeWithout it no saving can be measured later
SourceThe offer and the award the price comes from

The price before is the field that is easiest to forget. It is known on the day of the award, from the last invoices, and hard to reconstruct a year later.

Check every line

  1. Match the invoice line to an item: by the supplier's article number, otherwise by its wording.
  2. Find the agreement with this supplier for this item that was valid on the invoice date and covers the place of delivery.
  3. Compare the unit. If the invoice bills another unit or pack size, do not convert; clarify.
  4. Compare the unit price. Allow a small rounding tolerance and nothing more.
  5. If the price billed is higher: difference × quantity is the overcharge.

The possible results:

ResultWhat it meansWhat to do
Billed at the agreed priceThe agreement worksNothing. The line counts towards the measured saving
Billed above the agreed priceOvercharge of (billed − agreed) × quantityAsk for a credit note and the correct price from now on
Same item bought from another supplier at a higher priceBought outside the agreement: quantity × (paid − agreed)Find out who ordered and why, and point orders to the agreement
No agreement applies: other site, other unit, expiredNo breachDecide whether the agreement should be extended

An overcharge is an amount to recover once. It is not a yearly saving and should not be added to one. How to spot price changes on items that have no agreement is covered in finding price increases on invoices, and the other checks an invoice should pass are in the invoice audit checklist.

Measure the saving on what is billed

The saving from an agreement is measured on the invoices that follow it:

Saving of a line = quantity × (price before − price billed).

An example with invented figures. Gloves cost 6.00 a box before the award, the agreed price is 5.50, and the request assumed 1,200 boxes a year.

MonthBoxesPrice billedCalculationSaving
January1005.50100 × (6.00 − 5.50)50.00
February1205.50120 × (6.00 − 5.50)60.00
March1005.80100 × (6.00 − 5.80)20.00
April806.2080 × (6.00 − 6.20)−16.00

The measured saving after four months is 114.00. Three things can be read from the table.

First, the measured figure follows the quantity. At the award the expectation was 1,200 × 0.50 = 600.00 a year; whether it is reached depends on how much is ordered.

Second, March and April were billed above the agreed price. The overcharges are 100 × (5.80 − 5.50) = 30.00 and 80 × (6.20 − 5.50) = 56.00, together 86.00 to claim as a credit note.

Third, April counts negative. A line billed above the old price makes the agreement worse than no agreement for that month, and an honest measurement shows that instead of leaving the line out.

The difference between a saving that is in question, one that is agreed and one that is realised is the subject of proving procurement savings.

Sites and validity

Two limits of an agreement are behind many false alarms and many missed overcharges.

Sites. A price agreed for certain delivery sites applies to deliveries there and nowhere else. An invoice for another site at the old price is no breach, and an invoice that names no delivery address cannot be assigned to a site agreement. How site-specific awards come about is described in sourcing for multiple sites.

Validity. An agreement starts on a date and usually ends on one. An invoice dated before the start is checked against the earlier agreement, if there was one. Note the end date where someone will see it in time: the day after it, the supplier may bill any price, and the check against the agreement will not object.

What goes wrong

  • The agreement is not recorded as data. A PDF in a folder is checked by nobody.
  • The invoice words the item differently. Without the article number or a known alias, the line is not matched and not checked.
  • The pack size changes. The price per box stays the same and the box holds less. Units have to match before prices are compared.
  • The price drifts back. Correct for three months, then the old price returns with a new price list.
  • The expected saving is reported as realised. What the offer promised and what the invoices show are two figures.
  • Orders go elsewhere. A colleague buys the same item from another supplier at a higher price, and the agreement saves nothing on those orders.

How Cureman does it

When a sourcing event is awarded in Cureman, the offered prices become price agreements: supplier, item, unit, price, valid from the award and, where the offer named a term, until its end, for the event's delivery sites where it names any, and with the price before. Every later invoice line is checked by code. A unit price above the price agreed with that supplier for that item on the invoice date, in the same unit and beyond a small tolerance, is a finding with the amount (billed − agreed) × quantity, shown as an amount to recover once. An item under an agreement that was bought elsewhere at a higher price is a finding as well. For every line bought under an agreement from a sourcing event the saving is measured as quantity × (price before − price billed), by invoice month, and a line billed above the old price counts negative. This measured figure, not the offer's promise, is what the statement for the sourcing module is based on. An invoice that a model read from a PDF is labelled as such until a person reviewed it, and a finding that rests on it is never shown with high confidence. The checks belong to invoice audit and spend analysis, the agreements to sourcing and negotiation.

Questions and answers

How do you check an invoice against a price agreement?

Line by line. Match the line to an item, find the agreement with that supplier for that item that was valid on the invoice date and covers the delivery site, make sure the unit is the same, and compare the unit price. If the line was billed above the agreed price, the difference times the quantity is the amount to claim back.

How is the saving from a negotiated price measured?

On the invoices that follow, as quantity times (price before minus price billed) for every line bought under the agreement. The price before is what a unit cost when the agreement was made. This is the realised saving. The figure computed at the award, yearly quantity times the price difference, is an expectation until the invoices confirm it.

What should be done when a supplier bills more than the agreed price?

Ask for a credit note over the difference, (price billed minus agreed price) times quantity, and for the agreed price on future invoices. Attach the agreement or the award notice. Check the following invoices too, because a price that was wrong once in the supplier's system is usually wrong until someone corrects the master data.

Does an agreed price apply to every delivery site?

Only to the sites it was agreed for. A price agreed for certain delivery sites applies to deliveries there and nowhere else, so an invoice for another site at another price is no breach. An invoice that names no delivery address cannot be checked against a site-specific agreement at all.

Where do the agreed prices in Cureman come from?

From the award of a sourcing event. The prices of the awarded offer become price agreements with the supplier, the item, the unit, the validity, the delivery sites of the event and the price before. From then on every invoice line is checked against them, and the saving is measured on what is billed.