lamp.
ResourcesPricingAbout
3 min readBy

Order-to-delivery: control and audit worksheet

This worksheet helps an owner, accounts head or internal reviewer test whether the order-to-delivery process is really followed. You pick a few closed orders, pull the paperwork for each, and record whether every step left proper evidence. It gives you facts about how orders are handled instead of impressions.

When to use it

Run it once a month on a small sample of orders, and again after a customer complaint about a missed promise. It is also useful before a bank, large customer or CA review, and when a new person joins the order desk or dispatch team.

The template

ControlWhat to test in the sampleEvidence to pullReviewerResult and noteCorrective action
Order recorded and validatedItem, quantity, price and promised date match what the customer asked forSales order, customer's order message or purchase orderOrder desk lead
People, stock and service time plannedAvailability was checked before the date was promisedSchedule, stock check notePlanning supervisor
Slot, shift or machine bookedBooking exists before work started and is not double-bookedJob card, booking calendarDispatch or service lead
Work completed against the promiseActual completion date and quantity compared with the promised onesJob card closure, dispatch noteOrder desk lead
Result checkedInspection or service check was recorded before handoverQuality check sheetPlanning supervisor
Handover proof heldSigned acknowledgement, photo or message from the customer is filed with the orderDelivery acknowledgementDispatch or service lead
Invoice and transport papers matchInvoice quantity and value agree with what was deliveredInvoice copy, dispatch papersAccounts head

How to fill it

  • Control: one line per step of the process. Add a line for any extra step your business has, such as installation sign-off.
  • What to test in the sample: the exact comparison the reviewer makes. Keep it to one comparison per line so the result is clear.
  • Evidence to pull: the document you actually open. If it cannot be produced, that is itself a finding.
  • Result and note: write met, partly met or not met, followed by the case ID and what you saw. Test at least three orders per control.
  • Corrective action: one action, one owner, one date. Where the line covers tax invoices or transport papers, check the current rule on the official portal or with your CA before acting.

Example row

CaseControlResult and noteCorrective action
OD-1042, ₹86,400 orderHandover proof heldNot met. Goods left on 12 Nov but the signed acknowledgement is dated 19 NovDispatch lead to collect proof on the day of delivery. Review again on 30 Nov

Review and sign-off

  • The owner or accounts head reviews the completed worksheet and signs it with the date. The people being tested should not review their own lines.
  • Run it monthly. Use the same controls each time so you can compare months.
  • Escalate to the owner when the same control fails in two samples in a row, or when an invoiced order has no handover proof at all.

Keeping up to date

  • Keep each worksheet with the sample orders it covers, for the period your CA or the law requires.
  • Add or remove control lines when you change how orders are taken, planned or delivered, and note the date of the change.
  • Never overwrite an old result. If a finding is closed, add the closing date and the evidence 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 →