Automation Fundamentals

Time Audit for Small Businesses: Find Where the Admin Hours Go

By Yasen Katevski 7 min read

A time audit is a short, structured log of what you actually spend your working hours on, kept for one typical week and then totalled by task. It is the fastest way to find out which repetitive jobs are worth automating, because it replaces a guess with a ranked list. This guide gives you a log template you can copy, a summary sheet, a worked example with invented numbers, and a method for turning the results into an automation shortlist. The research quoted comes from published studies and surveys, and each is labelled with its source and limits.

Why log instead of guess

Most owners can name the tasks that annoy them. Fewer can say how many hours a week those tasks take, and the annoying ones are not always the expensive ones. A log shows which recurring jobs add up.

Published research gives a sense of the scale, but not your numbers.

  • The McKinsey Global Institute's 2012 report on social technologies estimated that the average high-skill knowledge worker spends about 28 percent of the workweek managing email and nearly 20 percent looking for internal information or tracking down colleagues who can help.
  • Microsoft's 2023 Work Trend Index, a survey of 31,000 people in 31 countries, found that email, meetings and chat took up an average of 57 percent of the workday, leaving 43 percent for creative work. The figures are self-reported.
  • Gloria Mark's research, reported by Gallup, shadowed 36 managers, analysts, developers and engineers for three days. Interrupted work that was resumed the same day was picked up again after 23 minutes and 15 seconds on average. That is a small, specialised sample, so treat it as an illustration of the cost of switching tasks, not a rule for your team.

These averages come from other populations and are several years old. They suggest that coordination work is large. They cannot tell you where your hours go, which is what the audit is for.

What you need

  • One typical week. Pick five working days without holidays or a launch deadline.
  • A place to log. A spreadsheet or a notes file. Keep it open all day.
  • Two minutes per entry. Log when you switch tasks, or at the end of each hour, not at the end of the day. Memory at 6 pm is unreliable.
  • A fixed set of categories, so that entries can be totalled.

Suggested categories:

CategoryWhat it covers
DeliveryThe work clients pay for
Sales and marketingEnquiries, calls, proposals, content
Admin and coordinationScheduling, data entry, status updates, invoicing, file searching, chasing
ManagementPlanning, hiring, supervising, finance review
OtherLearning, breaks that ran long, anything that does not fit

The log template

Copy this table into a spreadsheet. One row per task or per block of time. The last two columns are what make the audit useful for automation.

DateTask (short, verb first)CategoryMinutesRecurring? (Y/N)Rule-based? (Y/N/Part)
MonAdd new enquiry to CRM and send first replySales and marketing8YY
MonWrite weekly status update for Client AAdmin and coordination25YPart
MonSearch inbox for last quote sent to Client BAdmin and coordination4YN
TueRebuild proposal outlineSales and marketing40NN

Two rules keep the log honest:

  1. Write the task, not the project. "Update Client A status" is useful. "Client A work" is not.
  2. Mark a task Rule-based only if you could write down the rule. If it depends on gut feel, mark it N. If part of it follows rules, mark it Part.

The summary sheet

After five days, build two summaries.

By category. Total the minutes per category. This shows the shape of the week: how much goes to delivery, how much to admin.

By recurring task. Group the entries that are really the same task, and total them. Then add three columns: times per week, minutes each and hours per week. Sort by hours, largest first.

A worked example

The numbers below are invented to show the method. Imagine a five-person service agency where one person logs a week of admin.

Recurring taskTimes a weekMinutes eachMinutes a weekRule-based?
Log new enquiries and send first reply10880Yes
Book and reschedule calls12672Yes
Weekly client status updates625150Part
Chase unpaid invoices41040Part
Set up folders and forms for a new client24590Yes
Search for past files and emails15460No
Copy data between tools10550Yes
Total542

The total is 542 minutes, or about 9 hours a week. Four tasks are clearly rule-based: enquiries, booking, client set-up and copying data. Together they take 80 + 72 + 90 + 50 = 292 minutes, which is about 4.9 hours a week, or roughly 21 hours a month. The status updates and invoice chasing are partly rule-based, so they are candidates for a draft-and-approve automation rather than a fully automatic one. Searching for files is a filing problem, and the fix is a naming convention and a shared folder structure, not automation.

Two cautions apply to any result like this. First, minutes saved are only worth money if you spend them on something valuable. Second, an automation needs build time and upkeep, so the net saving is always smaller than the gross one.

Turn the results into a shortlist

  1. Take the top recurring tasks by hours. Ignore one-off tasks, however long they took.
  2. Remove tasks that are not rule-based. Some of these need a better process, not a tool.
  3. Score the rest. Use the four-question grid in the business process automation guide: how often it runs, how clear the rules are, whether the data is in one place and how cheap a mistake is.
  4. Do the payback arithmetic for the top two or three: monthly time saved, minus upkeep, against build time.
  5. Pick one and build it. Then run the same log again after four to eight weeks to see whether the hours really moved.

The same method works in any industry. In recruitment, the recurring tasks that usually surface are record creation, scheduling and status updates, which are covered in twelve processes you can automate in a recruitment agency.

Common mistakes

  • Logging from memory. Reconstructed logs underestimate small interruptions and over-round everything.
  • Logging only the tasks you dislike. Log everything for the week, or the totals mean nothing.
  • Letting categories drift. If "status update" is sometimes "reporting" and sometimes "admin", the totals split and the biggest task hides.
  • Counting one-offs. A single long task is not a recurring cost.
  • Using the log to monitor people. It will stop being honest. Use it to find processes to fix.
  • Auditing once and stopping. Repeat after a few months, because work patterns change.

Next step

Set up the log today and run it for the next five working days. If you would like a second pair of eyes on the results and what is worth automating, you can book a free audit. For a fuller treatment of one industry, see what to automate first and what to keep human in a recruitment agency, or browse the rest of the blog.

Sources

Frequently asked questions

How long should a time audit run?

+

One typical working week is enough to start. Log for five consecutive working days, avoiding holidays and unusual peaks, so that recurring tasks show up several times. If the week was clearly abnormal, run a second one. Repeat the audit after a few months to check what has changed.

Do I need time-tracking software?

+

No. A spreadsheet or a notes file with the columns in the template below is enough, and it keeps the effort to about two minutes per entry. Dedicated tracking tools can help if you already use one, but the quality of the audit depends on logging as you go, not on the tool.

What counts as admin work?

+

Admin is the work that supports the service but is not the service itself: entering data, scheduling, chasing replies, sending status updates, preparing invoices, searching for files and setting up new clients. Draw your own line and keep it consistent. What matters is that each task is logged under the same label every time.

How do I get my team to log time honestly?

+

Explain that the goal is to find tasks and processes to fix, not to rank people. Log at task level, keep the instructions short and share the combined results afterwards. If you collect personal data about employees, check the rules that apply where you operate. This is general information, not legal advice.

Want an outside view of this workflow in your business?

In a free audit we map the process and show where the quick wins are.

Book a free audit
Yasen Katevski, founder of Coreflow

Written by

Yasen Katevski - Founder, Coreflow

Yasen builds automation systems for operations-heavy businesses, including recruitment agencies, and writes about what works and what breaks.

Lead Generation

How to Write a Cold Email That Gets Replies

How to write a cold email that gets replies: pick the right list, write a short message, make a low-effort ask, follow up, and protect deliverability.

9 minRead