How to Do a Work Inventory: Build the Sheet, Then Turn It Into a Process Flowchart

What Is a Work Inventory? Its Purpose and 3 Uses

A work inventory is a list of every task your company or team performs, laid out so you can see who does each one, how often, and how much time it takes.

Taking stock of your work, the way you'd count stock

Just as a stocktake counts the goods on your warehouse shelves, a work inventory counts the tasks in your business, one at a time. It has nothing to do with inventory management for products, so when you bring it up internally, calling it a "work inventory" or "task inventory" keeps people from mixing the two up.

Three uses for a work inventory

• A starting point for improvement: you see how many hours a year go into each task, so you can decide what to tackle first
• Preparing for handovers and time off: tasks only one person handles show up at a glance, so you can act before someone moves roles or leaves
• Finding where automation or AI fits: it gives you the raw material to answer "we don't know what to use it for"

Inventory sheet vs. process flowchart vs. work manual

Use them in this order: inventory sheet → process flowchart → work manual. Of the six steps in our "How to Improve Business Processes" guide, the inventory comes just before the step where you map the current process as a flowchart — it's how you decide which process to map. For drawing flowcharts, see "How to Map a Business Process Flow"; for manuals, see "How to Write a Work Manual."

Minami

Process improvement lead

Writing down every single task sounds like it'd take weeks on its own... Honestly, is it even worth it?

Spark

DrillSpark consultant

You don't need to get everything perfect on the first pass. The point is to learn where the time goes and which tasks only one person can do. For that, five columns are plenty.

How to Build a Work Inventory Sheet: Small Companies Start With 5 Columns

If one or two people are running the inventory, five columns — Task, Owner, Frequency, Time per occurrence, and Hands off to — plus a calculated Annual hours column are all you need to start.

The 5 basic columns, plus 1 calculated column

The most important column in this sheet is Hands off to. When you later open a row into a process flowchart, the order of the people you listed becomes the steps and the hand-off arrows.

A column layout you can use in Excel as-is, and the annual-hours formula

In row 1 of your spreadsheet, enter these headings starting from column A: Task / Owner / Frequency (times per year) / Time per occurrence (min) / Hands off to / Annual hours. In the frequency column, enter the number of times per year as a number — 240 for daily (working days), 52 for weekly, 12 for monthly — so a formula can do the math.

In cell F2, enter =C2*D2/60 and copy it down. For example, a 45-minute task done every day (240 times) comes to 45 × 240 ÷ 60 = 180 hours.

Columns to add if you have room

A guide by Bayes Management, a Japanese firm, shows an example sheet with 11 fields: task category, major, middle, and minor category, main owner, backup owner, frequency, time per occurrence, annual hours, whether someone else can cover, and improvement action. If only one or two of you are doing this, you're far more likely to finish if you go around once with 5 columns and add what you need on the second pass.

Filled-in example: 8 admin and accounting tasks at a kitchen equipment distributor

Take a 12-person company that sells commercial kitchen equipment (a fictional example), where Admin B inventories the admin and accounting work single-handedly. The admin team is just B and C, and the president handles payroll personally.

The example spells out frequency and time in words to make it easy to read, but in Excel you enter numbers only so the formula works. For "Issue invoices," that means 12 in the frequency column (C) and 720 (minutes) in the time column (D).

The 8 tasks add up to 764 hours a year. Sorted by annual hours, the small daily tasks (answering calls at 240 hours, order entry at 180 hours) turn out to weigh more than the big monthly job of issuing invoices (144 hours). Noticing that the work that looks hard and the work that actually eats time are not the same is the first discovery an inventory gives you.

In the example, follow the Hands off to column on the "Issue invoices" row and you have the flow of the work. Write the task and its hand-offs as a sentence, give it to AI, and you get a first draft of a process flowchart.

How to Do a Work Inventory in 5 Steps, Even on Your Own

Run a work inventory in 5 steps: set the scope and purpose → draft it yourself → spend 15 minutes with each owner → sort by annual hours → pick the task to map as a flowchart.

Step 1: Set the scope and purpose

Start by drawing the boundary around a department, such as "admin and accounting tasks." For your first round, pick a scope that fits into roughly 8 to 20 tasks, so one person can see it through to the end.

Set the purpose in one sentence too — for example, "Find the tasks only one person handles, to prepare for handovers," or "Improve the tasks with the most annual hours first." With a clear purpose, you won't hesitate later over which columns to add or which rows to pick.

Step 2: Draft it yourself from your calendar and records

If you write from memory alone, you'll list mostly daily tasks. Go back through one to two months of dated records — your calendar, sent emails, copies of invoices and slips — and far less will slip through. Month-end-only and once-a-year tasks are especially easy to miss, so always check your calendar around month-end and fiscal year-end.

Step 3: Spend just 15 minutes with each owner to correct it

Handing everyone a blank sheet to fill in tends to stall at a busy small company. Show people the draft you made and ask, "Just tell me what's wrong and what's missing" — that takes about 15 minutes per person. Limit yourself to these three questions.

1. Is there anything you do only at month-end, year-end, or during the annual closing?
2. If you were out for a week, which of your tasks would stop?
3. Who do you get that work from, and who do you pass it to? Does it ever come back to you partway through?

The answers to the third question go straight into the Hands off to column. For tasks where the answer is "it comes back," jot "may send back" next to that person — you'll use it later when choosing which row to map. In the example company, Admin B's draft, done in half a day, had only 6 tasks. After 15 minutes each with the president, Admin C, and Sales D (45 minutes in total), "Check expense claims" and "Order office supplies" were added, bringing it to 8.

Step 4: Calculate annual hours and sort

Once the formula has calculated annual hours for every row, sort the sheet from the largest to the smallest. At the same time, color the rows where the Owner column says "sole owner," so they stand out in the next step. In the example, the top 3 rows alone (240, 180, and 144 hours) totaled 564 hours — more than 70% of all 8 tasks.

Step 5: Pick the task to map as a flowchart

From the sorted sheet, choose one row to turn into a process flowchart. The three criteria for choosing are explained in a later section, applied to the example. If no row meets any of them, widen the scope to the neighboring department and add more tasks. The trick to turning an inventory into improvement is not stopping at the sheet: put "map one row as a diagram" on the schedule from the start.

Minami

Process improvement lead

Everyone's so busy — if I hand out a sheet, I don't think I'll get it back...

Spark

DrillSpark consultant

That's why you draft it yourself first and just ask them, "Tell me what's wrong." That's much easier to answer than filling in a blank sheet. Fifteen minutes a person — even busy people will give you that.

Our "What Is ECRS?" guide lists "inventory and visualize the work" as the first step in applying ECRS. The 5 steps here break that first step down, up to the point where you have the sheet.

How Detailed Should You Get? 3 Rules of Thumb for Granularity

Aim for each row to be a task you could hand to someone else as-is. Any coarser and you can't fill in time or owner; any finer and the rows multiply until the inventory stalls.

Rule 1: Split at the level you could hand over to someone else

The Bayes Management guide also suggests breaking the finest category down to a unit you could hand over to someone. "Recruiting" is too coarse to give anyone, but "Schedule interviews with applicants" is something another person could take over tomorrow.

Rule 2: Write with a verb, not "…handling" or "…related"

Entries like "Client handling" or "Accounting-related" mean different things to different people. Write it down to the verb — "Answer quote requests from clients," "Check and reconcile incoming payments" — and the scope of the row becomes clear, and the time per occurrence gets easier to answer.

Rule 3: Group tasks into three levels: major, middle, minor

Once you pass about 20 rows, grouping by category makes the sheet easier to read. A guide from Teachme Biz, a Japanese manual-creation tool, describes one way to split it: major categories for work done company-wide, middle categories for work shared within a department, and minor categories for an individual's tasks. Each row of the inventory sheet is a minor category.

As a rule of thumb for this article, don't give tiny tasks that take less than 5 minutes their own row; fold them into the row above. For example, "Print the invoice address labels" belongs inside the "Issue invoices" row.

Procedures finer than a minor category belong inside the process flowchart, not the sheet. In DrillSpark, you can create a lower level (sub-process) under any step in a diagram and drill down into it, so the levels of your sheet and your diagrams line up: one row in the sheet → one diagram → the detailed procedure for each step.

Minami

Process improvement lead

I figured more detail meant more accuracy, so I split one task into 20 rows... and now I'll never finish.

Spark

DrillSpark consultant

The sheet has done its job once it shows which tasks take the time. Write the detailed procedures only for the tasks you pick, in a flowchart and a manual. Keep the sheet coarse and the diagram detailed — that's how you keep going.

3 Criteria for Choosing Which Tasks to Map as a Flowchart

Map the rows that meet the most of these three criteria: high annual hours, a single owner, and two or more hand-offs or send-backs. You don't need to map every row — one row is plenty for your first diagram.

Criterion 1: High annual hours

The more annual hours a task takes, the bigger the payoff from improving it. Cut a 180-hour-a-year task by 10% and you save 18 hours a year; do the same to a 12-hour task and you save 1.2 hours. For the same effort, start from the top rows.

Criterion 2: A single owner

A task with only one owner may stop if that person is out or leaves. Note, though, that the 5-column sheet only records who does the work; whether nobody else can cover it only becomes clear once you add a backup-owner column. Ways to deal with work concentrated on one person are covered in "How to Reduce Key-Person Dependency."

Criterion 3: Two or more hand-offs, or send-backs

Tasks that pass through two or more people, or that get sent back partway, tend to pick up waiting time between hand-offs. That waiting and rework is invisible in a single row and only shows up once you draw the flow, which makes these the rows most worth mapping. For send-backs, use the notes you made in the Hands off to column from the third question in Step 3.

Applying the criteria to the 8 example tasks

At this company, 7 of the 8 tasks had a single owner. Only "Issue invoices" meets all three criteria, so that becomes the first diagram. Candidates for the second are the two tasks that meet two: "Enter orders into the sales system" or "Check expense claims."

Answering incoming calls, which has the most annual hours, is shared by everyone and follows a simple flow. Rather than mapping it, the question there is "Can we reduce the number of calls?" or "Can we automate it?" — how to make that call is covered in "How to Choose Which Tasks to Automate."

Opening One Row Into a Process Flowchart in 4 Steps: The Invoicing Example

Line up the chosen row's Hands off to entries in order, then add branches, send-backs, and the time for each step — and one row becomes one process flowchart. Let's walk through it with the example's "Issue invoices" row (144 hours a year, 12 hours each time).

Step 1: Line up the Hands off to entries as the skeleton

Take "Sales (checks content; may send back) → President (approves) → Customer" from the sheet, add the person who starts the work and the person who produces it, and you get the skeleton "Sales → Admin → Sales → President → Customer." Write what each person does before passing it on, using a verb, and each one becomes a step box.

Step 2: Ask "What happens when it doesn't go smoothly?" to add branches and send-backs

With the skeleton in place, ask the owner, "Is there anywhere along the way where things go wrong?" At the example company, when Sales found an error in an amount or address, the invoice went back to Admin to be redone. Asking how many clients this affects each month turned up an average of 6 out of 40. Invoices also went out two ways: by post and by email.

Step 3: Add working time and waiting time for each step

Break down the "12 hours each time" from the sheet by asking which steps use it. While you're at it, ask how long each step waits before the next person picks it up.

Three of the 12 hours — a quarter — went into redoing invoices that were sent back. What had been a single row on the sheet, "Issue invoices: 12 hours," only showed what was inside it once it was drawn as a flow.

Step 4: Decide your next move from the diagram

What you find in the diagram determines which method to use next. The guides covering each method explain how to take it from here.

Minami

Process improvement lead

On the sheet it just said "Invoices: 12 hours," but once we drew it, 3 of those hours were going into redoing invoices that got sent back!

Spark

DrillSpark consultant

Exactly. The sheet tells you where to look, and the diagram tells you why it takes so long. So don't stop an inventory at the sheet — take at least one row all the way to a diagram.

4 Common Work Inventory Mistakes and How to Avoid Them

Most work inventories go wrong for one of four reasons: the sheet is the finish line, the detail gets too fine, owners aren't asked, or it's done once and never updated.

Mistake 1: Stopping once the sheet is done

Once the sheet exists, just seeing all the work in one list feels like an achievement. But the sheet only tells you where to look — not why things take so long. When you start the inventory, put a date on the diagram too, such as "map one row as a process flowchart within a week of finishing the sheet."

Mistake 2: Getting so detailed you never finish

The harder you try to be precise, the more rows you add — and what was meant to be 20 tasks turns into 200 rows and grinds to a halt. Keep every row at the size of something you could hand to someone else as-is, and on the first pass focus on filling in just the 5 basic columns. Detailed procedures only need to be written inside the diagrams for the tasks you pick.

Mistake 3: Writing it without asking the owners

If you build the sheet only from the work you can see yourself, you'll miss month-end and once-a-year tasks and hand-offs with other people. In the example, too, interviews added 2 tasks to the 6 in the draft. The question "If you were out for a week, which of your tasks would stop?" also helps you find tasks only one person handles.

Mistake 4: Making it once and never updating it

Work changes as people move roles and new systems come in. Set review dates in advance — every quarter, or at the start of each fiscal year. On top of that, whenever an owner changes or you switch software, update just those rows, and the sheet won't go stale.

Summary: Once the Sheet Is Done, Map One Row as a Process Flowchart

A work inventory is one package: grasp the volume of work with a 5-column sheet, then map one row, chosen with the 3 criteria, as a diagram.

An inventory sheet is like a map of your company's work. Once the map shows you where to go, the next job is to look at that spot up close — and that's the process flowchart. Open one row into a diagram, and time the sheet couldn't show, like waiting and rework, comes into view.

With DrillSpark, describe a process in plain language and AI drafts a flowchart that you can refine through conversation. There's a free plan, and no credit card is required.

Start by picking the row on your sheet that met the most criteria, and turn that one task into a diagram.

Related Templates

Related Guides

FAQ