Automation
What to automate first: a simple way to rank your manual work
Not every manual task deserves automating. A quick scoring method to find the ones that will pay back soonest.
Codexan
5 min read
Every business runs on a few processes nobody designed: the spreadsheet that gets emailed round on Mondays, the customer details typed into three systems, the report assembled by hand at month end. Automating all of it at once is a project that never finishes. Ranking it takes an afternoon.
List the work
Ask each person on the team one question: what do you do every week that a computer should be doing? Write every answer down without judging it. Ten to twenty items is typical.
For each item, note three numbers:
- How often it happens
- How long it takes each time
- How often it goes wrong
Score it
Multiply frequency by duration to get hours per month. Then adjust:
- Add weight for errors. A task that takes ten minutes but causes a wrong invoice once a month costs far more than its ten minutes.
- Add weight for waiting. If a customer or colleague is blocked until it is done, delay is part of the cost.
- Subtract for complexity. A task with many exceptions and judgement calls is harder to automate than its duration suggests.
The best first candidates are frequent, rule-based and dull.
Typical winners
These come up in almost every list:
- Moving data between systems. A new customer in the CRM should appear in the accounting tool without retyping.
- Scheduled reports. If the same figures are pulled every week, they can arrive on their own.
- Onboarding and offboarding. Creating accounts, granting access and, just as important, removing it.
- Chasing. Reminders for unpaid invoices, unsigned documents and overdue tasks.
- File handling. Renaming, filing and extracting data from documents that arrive by email.
Typical traps
- Automating a broken process. If the steps do not make sense by hand, they will make less sense at speed. Fix the process, then automate it.
- The rare, complicated task. The year-end job that takes two days feels painful, but twelve small weekly tasks usually cost more.
- Automation nobody watches. A script that fails silently is worse than a manual task, because everyone assumes it ran.
Build it so it can be trusted
Whatever tool you use, three things separate automation people rely on from automation people fear:
- It reports. Every run leaves a record of what it did.
- It alerts. A failure tells a named person straight away.
- It can be re-run safely. Running it twice does not create two invoices.
Then repeat
Automate the top item, measure the time it returns, and use part of that time for the next one. After three or four rounds the list looks very different, and the team has started spotting candidates on their own. That habit is worth more than any single script.
- automation
- process
- integration
- it