Procure-to-pay: control and audit worksheet
This worksheet helps an owner, accounts head or internal reviewer test whether purchases are made, received and paid for in the way you intend. You pick a sample of paid purchases, pull each document in the chain, and record where something is missing, late or does not agree. It suits factories, distributors, shops and clinics that buy regularly from several suppliers.
When to use it
Run it monthly on a sample of paid bills, and again before a year-end review or when a supplier raises a payment dispute. It is also useful when a new buyer or accounts clerk starts, or when you notice goods being received without a purchase order.
The template
| Control | What to test in the sample | Evidence to pull | Reviewer | Result and note | Corrective action |
|---|---|---|---|---|---|
| Requirement raised from real demand | Requisition shows item, quantity, need date and who asked | Requisition | Buyer | ||
| Quotations compared | More than one supplier asked where practical, reason noted if not | Supplier quotes | Stores supervisor | ||
| Purchase order approved before ordering | PO is dated before goods arrived and signed by the right approver | Purchase order | Accounts payable clerk | ||
| Goods counted on receipt | Quantity received was counted against the supplier's document and the PO | GRN | Buyer | ||
| Goods inspected, accepted or rejected | Inspection result is recorded, with rejections returned or held | GRN, inspection note | Stores supervisor | ||
| Three-way match before payment | PO, GRN and supplier bill agree on quantity and price, or the difference is explained | PO, GRN, bill | Accounts payable clerk | ||
| Tax details and deductions checked | Supplier invoice details and any tax deducted at payment are recorded | Supplier bill, payment voucher | Accounts payable clerk |
How to fill it
- Control: one line per step. Keep the order of the real process.
- What to test in the sample: one comparison per line, and the same comparison for every sampled purchase.
- Evidence to pull: the document in the file. If the buyer says it exists but cannot produce it, count that as a finding.
- Result and note: write met, partly met or not met, with the PO number and what you saw. Test at least three purchases per control.
- Corrective action: one action, one owner, one date. For tax invoice details and any deduction at payment, check the current rule on the official portal or with your CA before acting.
Example row
| PO | Control | Result and note | Corrective action |
|---|---|---|---|
| PO-0731 | Three-way match before payment | Not met. PO and bill were for 120 units at ₹85 (₹10,200). GRN shows 115 received (₹9,775). Bill was paid in full, ₹425 excess | Recover ₹425 by credit note. Accounts clerk not to release payment until GRN is attached. Retest on 30 Nov 2026 |
Review and sign-off
- The owner or accounts head reviews and signs the worksheet. Buyers and the clerks who pay bills should not review their own lines.
- Run it monthly with the same controls each time so that months can be compared.
- Escalate to the owner when a payment is made without a PO or GRN, or when the same control fails in two samples in a row.
Keeping up to date
- Keep each worksheet with the purchase files it tested for the period your CA or the law requires.
- Add a control line when you start a new kind of purchase, such as job work or imports.
- Do not overwrite earlier results. Record the date a finding is closed and the proof beside it.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →