lamp.
ResourcesPricingAbout
3 min readBy

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

ControlWhat to test in the sampleEvidence to pullReviewerResult and noteCorrective action
Requirement raised from real demandRequisition shows item, quantity, need date and who askedRequisitionBuyer
Quotations comparedMore than one supplier asked where practical, reason noted if notSupplier quotesStores supervisor
Purchase order approved before orderingPO is dated before goods arrived and signed by the right approverPurchase orderAccounts payable clerk
Goods counted on receiptQuantity received was counted against the supplier's document and the POGRNBuyer
Goods inspected, accepted or rejectedInspection result is recorded, with rejections returned or heldGRN, inspection noteStores supervisor
Three-way match before paymentPO, GRN and supplier bill agree on quantity and price, or the difference is explainedPO, GRN, billAccounts payable clerk
Tax details and deductions checkedSupplier invoice details and any tax deducted at payment are recordedSupplier bill, payment voucherAccounts 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

POControlResult and noteCorrective action
PO-0731Three-way match before paymentNot met. PO and bill were for 120 units at ₹85 (₹10,200). GRN shows 115 received (₹9,775). Bill was paid in full, ₹425 excessRecover ₹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 →