Leak 38 · Order-to-Cash & Operations - Excessive manual exception handling
Half the day goes to exceptions: the address that does not validate, the item that needs a substitute, the credit hold that needs a call. Most of them are the same exception, repeated.
Diagnostic note. Symptoms, required records, an initial check, and possible fixes. This shorter note does not include a full worked example.
What is it?
Every workflow has exceptions, and skilled people are needed for the unusual ones. The leak is the routine exceptions: the ones that recur daily, follow the same resolution, and still take a person each time because nobody has written the rule down or built the path. Finding them requires counting, which almost nobody does.
- Family
- Order-to-Cash & Operations
- Primary owner
- Operations Manager
- Secondary owners
- Customer Service Manager, IT
- Primary impact
- Labor
- Typical data source
- Time observation, exception logs if any
- Detection difficulty
- 30-day measurability
Ask yourself
Do you know which exceptions your team handles most often, and how many of them follow the same resolution every time?
Yes, partially, no, or don’t know. “Don’t know” is the most useful answer, because it points at the test below.
What does it look like?
Warning signs. None of these proves the leak exists. They tell you where to look.
- Staff who describe their day as “putting out fires.”
- The same exception handled the same way by different people, differently.
- No exception log, so frequency is unknown.
What data do I need?
The minimum viable set. Most of it is already in your ERP.
| Field |
|---|
| One week of exception tallies by type, from the people who handle them |
| Minutes per exception type |
| Resolution taken, to see how often it is the same |
The initial check
Start with a small sample. Gathering the exports, agreements, or observations is separate from running the check; agree that work with the person who owns the records.
- 1Ask three people who handle orders to keep a tally sheet of exceptions for one day: type, minutes, and what they did.
- 2Group the tallies by type and count.
- 3Mark the types where the resolution was the same nearly every time.
Routine exception load = Σ over same-resolution types of count × minutes; annualize
Then ask one question: For the top three routine exceptions, what rule would resolve them without a person?
How much could it be costing us?
A conservative range, not a headline. The goal is a number management can trust enough to investigate.
Annual hours on routine exceptions × loaded rate × share that a rule or a tool can resolve, keeping unusual cases with people
Common root causes
Fixes fall into three layers. Not every problem needs software, and almost none needs AI first.
- Process
- Exceptions are handled ad hoc with no documented resolutions.
- Data
- Root causes of exceptions, such as bad master data, are not fixed, so the exceptions recur.
- Technology
- No exception queue, so volume and pattern are invisible.
What should we do?
Start with the simplest intervention that could solve it. Move down the list only if the one above is not enough.
Level 1
Measurement
A one-week exception tally, then a monthly log.
Level 2
Rules
Written resolutions for the top routine exceptions, and master-data fixes for the ones caused by bad data.
Level 3
Workflow
An exception queue that applies the written rules, routes only the unusual cases to people, and records what happened.
Where AI helps
- Classifying exceptions from notes and emails, and proposing the resolution for a person to confirm on the routine ones.
Where AI probably doesn’t
Counting comes first. Many exceptions disappear when the master-data cause is fixed.
Before you call it a leak
- Judgment calls should stay with people. The goal is fewer routine interruptions, not fewer decisions.
Think this might be happening in your business?
Turn the finding into a next step.
If the numbers say there is something there, send us what you found and we will help you decide whether it is worth a full investigation. No transaction files needed for that conversation.
Related leaks
- Leak 34 · OperationsManual order-entry reworkA customer PO arrives as a PDF. Someone types it into the ERP, checks it against the quote, fixes the part numbers, and emails an acknowledgement. Fifteen minutes, forty times a day.
- Leak 39 · DataDuplicate customer and product recordsAcme Mfg, ACME Manufacturing, and Acme Manufacturing Inc. Three records, three price files, three credit limits, and a sales report that shows none of them as your biggest customer.
- Leak 41 · DataIncomplete product and customer master dataItems with no weight, no product class, no supplier part number. Customers with no segment, no terms, no default ship-to. Every automated decision downstream falls back to a guess or a person.
- Leak 40 · DataPoor substitute and cross-reference dataThe customer asks for a competitor’s part number. The rep asks the product manager, who checks a catalog, who calls the supplier. Two days later the customer has bought it elsewhere.
Let’s start with one thing.
What would better performance look like?
Bring a result you want to improve, a symptom, or a workflow you already understand. You do not need to know the bottleneck yet. We’ll help choose what to investigate first.
No transaction files needed for the first conversation.