How do I compare an invoiced line with the purchase order quantity, receipt and agreed price?
Flag overbilling against the smaller of ordered and received quantities, plus any price over the purchase order.
Open Three-Way MatchTry the worked example
These are the example inputs from Three-Way Match. Replace them in the tool to run your own case.
| Line | Ordered | Received | Invoiced | Order EUR/unit | Invoice EUR/unit |
|---|---|---|---|---|---|
| Paper | 20 | 18 | 20 | 4 | 4 |
| Ink | 5 | 5 | 5 | 25 | 27 |
| Labels | 12 | 12 | 12 | 3 | 3 |
Example result
2 lines need review
Who uses this?
Purchasing coordinator. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Compare an invoiced line with the purchase order quantity, receipt and agreed price. The source discusses procurement as a managed workflow with reviewable decisions. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video