-
Excel workbook preview
Purchase Orders, Requisitions and Purchasing
Three-Way Match Checker (PO, goods receipt, invoice)
3 downloads per free account, no card needed.
Who this is for
An accounts payable clerk or finance controller who must prove to the auditor that no invoice was paid without an order and a goods receipt.
What is inside
- 12 sample invoice lines across 5 purchase orders
- Quantity and price variances with % and value by live formula
- Match, or Hold for no receipt, over the PO quantity, quantity or price
- Price tolerance % and amount and quantity tolerance on the Settings sheet
- Summary sheet: lines and invoice value by result
- Hold results turn red, owner and resolved date columns for follow-up
How to use it: Set your tolerances on the Settings sheet, paste the PO, receipt and invoice values for each invoice line, and pay only the lines that show Match or a hold that has been resolved.
Files & formats
- XLSXthree-way-match-checker.xlsx15 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.



