Home › Guides

AI automation audit template: find the automations worth doing

How to run a simple automation audit on your own business: the columns to track, the formulas, and how to rank what you find. About 8 minutes to read.

Most small businesses already know they should "automate more". The hard part is deciding what. Without a method you end up automating whatever is loudest this week, or whatever a tool demo made look easy. An automation audit fixes that. You list your recurring tasks, put rough numbers on each one, and rank them by what they're worth and how risky they are to hand to software.

This guide walks through a template you can build yourself in a spreadsheet. It works whether you plan to use n8n, Make, Zapier, the automations built into your existing tools, or AI assistants.

What an automation audit is (and isn't)

An audit is a short, structured review of the repetitive work in a business. The output is a ranked list of candidates with an estimate of hours saved, cost to build and risk for each. It is not a technology strategy, and it doesn't need consultants. A business owner or office manager can do a first pass in an afternoon if they're honest about the numbers.

Step 1: list every recurring task

Spend 30 minutes writing down tasks that happen at least monthly. Walk through a normal week and look at your inbox, calendar, accounting software and shared drives. Common ones:

• Chasing overdue invoices
• Logging and replying to website enquiries
• Sending appointment reminders
• Sorting a shared inbox
• Compiling a weekly numbers report
• Asking customers for reviews
• Filing supplier bills and receipts
• Setting up new clients
• Checking stock levels
• Writing up meeting actions

Describe each task by its trigger and result ("invoice is 7 days overdue → client gets a reminder"), not by the tool you use today.

Step 2: the columns your template needs

One row per task. Keep the inputs few enough that you'll actually fill them in.

Step 3: the formulas

Keep the maths transparent so anyone can check it:

• Hours saved per week = runs per week × minutes per run × % automatable ÷ 60
• Annual value of time = hours saved per week × working weeks (say 48) × hourly cost
• Year-1 cost = build hours × hourly cost + tool cost per month × 12
• Year-1 net benefit = annual value − year-1 cost
• Payback (months) = year-1 cost ÷ (annual value ÷ 12)
• Risk score = sum of the four risk ratings (4 = low, 12 = high)

An illustrative example, not a benchmark: 15 invoice reminders a week at 4 minutes each, 90% automatable, is 0.9 hours a week. At $50 an hour over 48 weeks that's $2,160 of time a year. If the build takes 4 hours and the tool costs $20 a month, year-1 cost is $440, net benefit is $1,720, and payback is about 2.4 months.

One caution: freed-up time is capacity, not cash. It only becomes money if you use the hours for paid work, sales or growth, or avoid a hire.

Step 4: rank into four groups

Sort by net benefit, then sort the top half by risk:

• Quick wins: good benefit, risk score 4–6. Build these first.
• Worth planning: good benefit, higher risk. Automate part of it and keep a human approval step.
• Nice to have: low benefit, low risk. Do these when a tool makes them trivial.
• Leave alone: low benefit, high risk. Not worth it yet.

Most businesses find two or three quick wins. That's plenty. Build one, run it for two weeks, check the output daily, then move to the next.

Step 5: sense-check the numbers

The template is only as good as its inputs. Before trusting a row:

• Time the task for a week. People routinely guess too low or too high.
• Check the rules are written down. If two staff do the task differently, standardise first, then automate.
• Check the inputs are digital and consistent. Scanned PDFs, free-text emails and messy spreadsheets add build time.
• Be strict about AI steps. If AI drafts replies or extracts data, plan for a human to review the output. Add that review time back into minutes per run.

Step 6: write it up

Even for your own business, a short write-up keeps you honest and makes it easier to get buy-in from a partner or team. Cover:

• The current-state time baseline
• The ranked list
• A value-vs-risk chart
• The top five priorities with ROI and payback
• The risks and the control for each (for example "human approves before any payment")
• A 90-day roadmap

If you're a consultant or bookkeeper doing this for clients, the same structure becomes a paid deliverable.

Common mistakes

• Automating a broken process. Fix the steps first.
• Counting tool cost but not build and maintenance time. Allow an hour or two a month to keep each workflow healthy.
• Skipping the risk column. Anything that moves money, contacts customers in bulk or handles sensitive data needs a review step and a way to undo mistakes.
• Ignoring the rules. Check anti-spam, privacy and review-site rules for your country before automating outbound messages.
• Starting with the hardest, most exciting project. A boring quick win that works builds confidence and frees time for the bigger ones.

A ready-made version

You can build everything above in a blank spreadsheet. If you'd rather not, the Spare Afternoon Audit Workbook has these columns and formulas set up. You fill in the yellow cells, a summary sheet ranks your top five, and a 15-slide report template is included for the write-up.

Before you start any of it, run your candidate tasks through the free checklist below. It catches the tasks that look automatable but aren't ready.