Three-Way Match
Compare an invoiced line with the purchase order quantity, receipt and agreed price.
Prepare your sheet
Use one row per line observation. Enter Ordered, Received, Invoiced, Order EUR/unit, Invoice EUR/unit. Check that every row belongs to the same review scope.
Decision rule
Flag overbilling against the smaller of ordered and received quantities, plus any price over the purchase order.
Worked result
The fictional example contains 3 input rows. Its result is 2 lines need review.
| Line | Excess units | Excess price / unit | Decision |
|---|---|---|---|
| Paper | 2 | €0.00 | Review |
| Ink | 0 | €2.00 | Review |
| Labels | 0 | €0.00 | Matched |
Run it on your own inputs
- Open the tool and choose Start empty or edit the example.
- Enter the inputs, resolve validation messages and review the decision sheet.
- Download the text report or print the summary for the responsible person.
Source and support
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. Reviewed source · Greg Isenberg at 21:46.
Request a custom workflow. €149 one-time pilot after written scope agreement. JB Codex adapts one repeated job with a worked example and owner review.