Home › Automation Insights › Automation ROI Worksheet: Free Template to Price Any Workflo
Automation

Automation ROI Worksheet: Free Template to Price Any Workflow

By Ali · Oct 7, 2026 · Esipick.ai
Automation ROI Worksheet: Free Template to Price Any Workflow

Most automation projects get approved or killed on a gut feeling. This free worksheet replaces the gut feeling with five numbers you can collect in about ten minutes. It tells you what a manual process costs you each year, what automating it costs, and how quickly the build pays for itself. Copy the table into a spreadsheet, fill in one row per process, and sort by payback.

Five-step automation ROI worksheet: hours lost per week, loaded hourly cost, annual manual cost, build and run cost, payback and 12-month ROI

The worksheet

StepWhat to collectFormula
1. Hours lost per weekHow many times the task runs each week, and the minutes per run, including fixing mistakesruns × minutes ÷ 60
2. Loaded hourly costSalary plus overhead (taxes, tools, office), divided by hours actually workedannual cost of the role ÷ ~1,800 hours
3. Annual manual costWhat doing it by hand costs you each yearhours/week × hourly cost × 48 weeks
4. Build + run costOne-off build, plus monthly hosting, API and per-task fees for 12 monthsbuild + (monthly run cost × 12)
5. Payback and ROIHow fast it pays back, and the return over the first yearpayback (months) = build ÷ (monthly saving − monthly run cost); ROI = (annual saving − 12-month cost) ÷ 12-month cost

Worked example: invoice reminders

A finance assistant spends about 6 hours a week chasing unpaid invoices by email. Their loaded cost is $25 an hour.

Not every process looks this good. That's the point of the worksheet: it shows you which ones do. If you want to build this exact workflow yourself, the step-by-step guide is in our invoice automation post.

Automation readiness check

A high ROI only matters if the process can actually be automated reliably. Score each process with one point for every "yes":

Start with any process that scores 4–5 and has a payback under three months. Processes that score 2–3 usually need the process itself cleaned up before they're automated.

Hidden costs to include

Use and share this worksheet

You're welcome to copy, adapt or republish this worksheet, including the diagram, as long as you credit Esipick with a link to this page. If you'd like us to fill it in with you for your own processes, a free 30-minute call is enough to rank your top five.

Want this automated for your business?

I build n8n workflows, WhatsApp automations, and AI pipelines — starting from $300. Most go live in under a week.

Get a Free Audit →