What it means
An order can remain open for many reasons, since a custom item may take weeks by design while a standard product might be stuck because one component is missing. A simple count of open orders does not show which need action.
Age bands such as 0-7, 8-30 and over 30 days provide a first view, but each business should set bands suited to its products and customer promises. Choose the clock, because some teams measure from order placement and others from acceptance or release to fulfilment, and these dates should stay separate when approval can take time.
A customer-requested hold may be excluded from an operational lateness measure but should remain visible in the order list. Do not reset the original date when a salesperson changes the expected delivery; the revised promise is useful, but it should not erase how long the customer has waited.
Segment by order type, value, customer, promised date and blocker, since a high-value order waiting for customer artwork needs a different action from a paid order awaiting stock. Check partial fulfilment, because an order may be 90% delivered while one item remains open and delays final billing.
State whether ageing is measured for the whole order or individual lines, as a single old low-value line can distort order-level averages. Give each aged order a named owner and next step: inventory may need to confirm supplier dates, production may need a capacity decision and sales may need customer approval for a substitute.
A status of "pending" without a reason is not a plan. Review orders approaching their promise date before they become overdue, not only after a month-end report flags them.
Avoid gaming. Closing an order without delivery or cancellation evidence reduces the backlog count but creates customer and financial errors, and reissuing it as a new order can make the age look younger while the original commitment remains.
Preserve the history of split orders, partial deliveries and agreed changes, and verify the actual shipment or service acceptance before calling an order complete. Use trends to improve upstream processes, since repeated ageing in one product may point to unreliable supply and in another to unclear customisation approvals.
Compare median age, oldest orders and value overdue, because a favourable average can hide a few critical long-waiting customers, and link the measure to cash forecasts since unfulfilled orders may delay invoicing and collection. For owners, ageing is a way to find promises at risk before customers have to chase, and the point is not a perfectly empty queue but a clear, honest plan for each order that matters.
In practice
Real-world examples.
Example
A distributor sees a 45-day-old order that was promised in ten days; purchasing checks the supplier and gives the customer a verified option.
Example
A custom manufacturer records a 60-day open order with a 90-day agreed lead time separately from overdue standard orders.
Example
A partial shipment leaves one item open and prevents final billing; the account owner agrees a substitute or revised completion date.
Formula
Calculation
Open order age = Reporting date - Original accepted order date
Worked example. An invented order accepted on 1 September remains open on 30 September.
- Open order age is 29 calendar days under the stated date convention.
- If it was promised for 15 September, it is also 15 days past that promise; if promised for 15 October, it is not yet late.
Report both age and promise performance rather than using either alone.Case study
Seen in the real world.
This illustrative and entirely fictional example follows Pine Equipment, an invented supplier of workshop tools. Its dashboard showed only orders due this week. One older order for a custom bench had no delivery date because an approval field was blank. It sat unseen for six weeks while the customer assumed production had begun. Pine added an ageing report showing original acceptance, agreed promise, blocker and owner.
The team found the missing specification approval, contacted the customer and revised the plan openly. Other old orders revealed partial shipments awaiting one small accessory. Operations and sales reviewed the oldest and highest-risk items weekly. The owner did not demand that every open order be closed. The new measure made hidden waiting visible and helped prevent a customer from discovering the problem first.
Watch out
Common mistakes.
- Resetting order age by changing or reissuing an order after a delay.
- Calling every old order late without checking the customer's agreed future delivery date.
- Closing a partially unfulfilled order merely to improve the backlog report.
Questions
People also ask.
When does the age clock start?
Define it consistently, often from accepted order date, while retaining placement and release dates for diagnosis.
Should customer-held orders count?
Keep them visible, but segment them from avoidable operational delays with evidence of the request.
What is more useful than average age alone?
Age bands, oldest and highest-value orders, promise status, blockers and named next actions.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%