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
| Control | What to test in the sample | Evidence to pull | Reviewer | Result and note | Corrective action |
|---|---|---|---|---|---|
| Order recorded and validated | Item, quantity, price and promised date match what the customer asked for | Sales order, customer's order message or purchase order | Order desk lead | ||
| People, stock and service time planned | Availability was checked before the date was promised | Schedule, stock check note | Planning supervisor | ||
| Slot, shift or machine booked | Booking exists before work started and is not double-booked | Job card, booking calendar | Dispatch or service lead | ||
| Work completed against the promise | Actual completion date and quantity compared with the promised ones | Job card closure, dispatch note | Order desk lead | ||
| Result checked | Inspection or service check was recorded before handover | Quality check sheet | Planning supervisor | ||
| Handover proof held | Signed acknowledgement, photo or message from the customer is filed with the order | Delivery acknowledgement | Dispatch or service lead | ||
| Invoice and transport papers match | Invoice quantity and value agree with what was delivered | Invoice copy, dispatch papers | Accounts 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
| Case | Control | Result and note | Corrective action |
|---|---|---|---|
| OD-1042, ₹86,400 order | Handover proof held | Not met. Goods left on 12 Nov but the signed acknowledgement is dated 19 Nov | Dispatch 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 →