Customer Order Exception Aging Log Worksheet
Late and problem orders need an owner, a reason and a next action date, or they quietly age. This worksheet gives customer service a single log with computed penalty exposure, ready to export to Excel for the daily review.
| Sales order | Customer | Exception reason | Order value | Days late (days) | Penalty rate per week (%) | Penalty exposure | Owner | Next action date | |
|---|---|---|---|---|---|---|---|---|---|
$720 | |||||||||
$0 | |||||||||
$730 | |||||||||
$0 | |||||||||
$49 |
Update the log daily. Set the penalty rate from the customer contract and leave it at 0 where none applies.
Live late order list from your ERP
Optional review of how to build an exception view over open order lines.
Optional. The tool and every export work without this. No spam.
How to use it
Add one row per exception order. Record the customer, the primary reason, the order value, days late and the contractual penalty rate per week. The sheet calculates exposure and totals. Assign an owner and a next action date to every row, and review rows with the longest delay and the highest exposure first. Export to Excel or CSV to share with sales and operations.
The method
Penalty exposure equals order value times the weekly rate times days late divided by seven. It is a pro rata estimate, so apply any grace period or cap from the contract before you quote it externally. The reason column lets you build a Pareto of causes over time. If material shortages dominate, the fix sits with planning and purchasing, not with the order desk.
- Use one primary reason per order, with detail in notes
- Track days late against the contractual date, not the latest promise
- Close rows only when the customer has confirmed receipt
Common mistakes
Logs fail when they have no owner, when reasons are free text that cannot be counted, or when the log is a copy of the ERP that nobody updates. Keep the reason list short and agreed across planning, quality and logistics. Review the log in a short daily meeting and remove rows once resolved, keeping a history sheet for monthly analysis of the most frequent causes and customers.
Frequently Asked Questions
How often should I review it?
Daily for orders at risk, with a weekly summary by reason and customer. Longer intervals let small slips become penalties.
Where do the days late come from?
Subtract the contractual delivery date from today or the actual ship date. Use calendar days unless the contract uses working days.
Can I add columns?
Export to Excel and add what you need, such as carrier or part number. Keep the reason column controlled so it can be counted.
Why track exposure when no penalty applies?
Customers also respond with lost business and escalations. A zero rate still lets you rank by value and days late.
Netray can generate this exception list directly from open sales order lines in your ERP, so the log is a live view with people adding the commentary.
Related Tools
Late Delivery Liquidated Damages Exposure Calculator
Work out what a liquidated damages clause actually pays when a supplier ships late, and how far it falls short of your real cost of delay.
Supply Chain & InventoryOTIF Compliance Fine Exposure Calculator
Turns separate on-time and in-full percentages into one OTIF score and estimates the fines a customer scorecard would charge.
Costing & FinanceOrder Credit Hold Release Checklist
A step by step checklist for deciding whether to release, partially release or keep a sales order on credit hold.
ERP OperationsCSR Order Desk Staffing Calculator
Converts daily orders, lines and customer contacts into the number of customer service reps required after shrinkage and occupancy.