All articles

Statistics

Check Sheet: Turn Scattered Observations Into a Tally You Can Defend

The Check Sheet tool in the Measure phase builds a structured tally from raw observations without any spreadsheet preparation. This walkthrough follows one fictional invoice defect case from blank setup to a finished frequency pattern.

Ci Flow editorial team 18 October 2026 8 min read
Check Sheet, Measure phase tool guide from Ci Flow

What the Check Sheet is for, and when to reach for it

A check sheet is the simplest structured data collection form in improvement work. You decide what you are counting. You decide when or where it happened. Then you record each observation as it occurs. The tool builds a reliable tally without you preparing the data anywhere else.

In RDMAICS, the Check Sheet sits in the Measure phase. Recognise and Define have already told you which process matters and what problem you are chasing. Measure is where you stop arguing from memory and start counting. The check sheet is often the first thing a team builds, because almost every later tool depends on having counts you trust.

Reach for it when the team can describe a problem but cannot size it. You hear that invoices keep bouncing back, or that one step causes most of the rework, but nobody can say which category occurs most often. A check sheet answers that question in a week of observation. Set up the check, enter or upload rows, then review the frequency pattern and the live tally.

It is also the right tool when you want the people doing the work to collect the data. The form is short. The categories are fixed. A person can tick a row in seconds without leaving the task.

The case: a week of invoice processing defects

The example used throughout this guide is fictional. It is the sample data built into the tool, and it exists so you can see every field behave before you load anything of your own.

A finance team processes supplier invoices. The flow runs from intake, through validation, through vendor master checks, through approval. Invoices come back for correction often enough that the team has stopped counting. Rework is absorbed into the day. Nobody can say whether the problem sits in one step or across all of them.

The team agrees to run a check sheet for one working week. They name it the Process Defect Check Sheet. The decision it must support is written down before any data is collected: record where and when defects or events occur so the team can see the most frequent pattern.

They settle on five defect categories: wrong amount, wrong vendor, unapproved PO, missing information, and duplicate entry. Each observation also records the day, the location or process step, the shift, and any note worth keeping. Twelve observation rows are collected across Monday to Friday.

Setting up the check before you collect anything

The setup section is short, and it does the heavy lifting. Three answers drive the whole tally.

First, what are you counting. In this case, the answer is the Defect / category column. That column holds the five named defect types. Second, when or where did it happen. The team chooses Date / period, which holds Mon through Fri. Third, which column contains the count. The team points the tool at the Count column, because each row carries a number rather than a single tick.

That last choice matters more than it looks. A check sheet can work two ways. One row can mean one occurrence, or one row can carry a count of several occurrences recorded together. This case uses the second pattern. Row 1 is eight wrong amount defects at validation on Monday, not one.

Write the decision statement before the first row is entered. If you cannot say what the tally will help you decide, you will collect columns nobody uses.

  • Name the sheet so a reader six months later knows what it covered.
  • Fix the category list before collection starts, and keep it short.
  • Decide whether a row is one event or a count of events, then stay consistent.
  • Keep the period column simple, such as day of week or shift.
  • Record location and team as separate columns so you can cut the data later.

Entering the rows

Rows go straight into the tool. You can type them or upload them. Each row gets an observation identifier, in this case CS-001 through CS-012, so you can trace a tally entry back to a specific record.

The sample rows show the shape of good collection. CS-001 records eight wrong amount defects at validation on Monday day shift, with the note that a tax field mismatch was involved. CS-004 records eleven wrong amount defects on Tuesday, noted as a peak volume day. CS-008 records twelve wrong amount defects on Thursday evening shift, marked as the highest tally. The notes column carries the context that a number alone cannot.

Not every row needs a note. CS-002, CS-005, CS-006 and several others leave it blank. That is fine. Notes are for the exceptions and the explanations, not for narration.

The Count column is where discipline shows. Every row in this case carries a number: 8, 5, 3, 11, 3, 9, 6, 12, 3, 7, 5 and 3. They sum to 75 defects across the week.

The twelve observation rows with their identifiers, days, categories, counts, process steps, shifts and notes. Notice that the count column carries numbers rather than single ticks.
The twelve observation rows with their identifiers, days, categories, counts, process steps, shifts and notes. Notice that the count column carries numbers rather than single ticks.

Reading the result

The tool produces two things from this data. A frequency by category view and a live tally.

The frequency view sorts the highest-frequency categories first, so the team can identify where to investigate. Wrong amount leads at 47. Wrong vendor follows at 16. Unapproved PO sits at 6. Missing information and duplicate entry both sit at 3. The gap between first and second is large, and it is visible without any calculation.

The live tally gives the same data cut by period. It reports five categories across five periods. Wrong amount appears on every day: 8 on Monday, 11 on Tuesday, 9 on Wednesday, 12 on Thursday, 7 on Friday. Wrong vendor appears on Monday, Wednesday and Friday at 5, 6 and 5. Unapproved PO appears twice, at 3 on Tuesday and 3 on Friday. Missing information appears once, 3 on Monday. Duplicate entry appears once, 3 on Thursday.

Then look at the period totals: 16, 14, 15, 15, 15. The daily volume barely moves. Total defects for the week are 75. The problem is not a bad day. It is a steady pattern dominated by one category.

The tool also offers an AI review that explains what the result shows, if you want a written reading alongside the numbers.

The frequency by category view with wrong amount at the top, and the live tally showing counts by day. Notice how flat the daily totals are across the week.
The frequency by category view with wrong amount at the top, and the live tally showing counts by day. Notice how flat the daily totals are across the week.

What the check sheet lets you decide

With 47 of 75 defects in one category, the team has a clear place to start. Wrong amount outnumbers the next category by a wide margin. Every one of those rows sits at the validation step. That narrows the scope of the next investigation from a whole process to a single step and a single defect type.

The check sheet also tells you what not to chase yet. Missing information and duplicate entry each occur at 3 for the week. They are real, and they are worth logging, but they are not where the effort belongs this month.

The period view supports a second decision. Because wrong amount appears on all five days, and daily totals sit between 14 and 16, the team can rule out a theory that defects spike on one day. Tuesday was noted as a peak volume day, yet Tuesday has the lowest total at 14.

From here the natural next steps are a Pareto view to confirm the concentration, and a cause analysis on wrong amount at validation. The check sheet does not do those jobs. It gives them a starting point built on counts rather than opinion.

The whole tool screen, from the setup fields through the data table to the frequency result and live tally.
The whole tool screen, from the setup fields through the data table to the frequency result and live tally.

Common mistakes

The most common mistake is too many categories. If every defect gets its own label, every category ends up with a count of one or two, and no pattern appears. Five categories handled 75 observations here without strain.

The second mistake is changing the definition mid-collection. If wrong amount means a tax field mismatch on Monday and something broader by Thursday, the tally is not comparable. Agree the definitions in writing, then hold them.

The third is mixing row types. If some rows mean one event and others carry a count of eight, the totals are wrong and nobody notices until a later tool contradicts them. Pick one convention.

The fourth is collecting for too short a period. This case ran five days. That is enough to see a dominant category, but it is not enough to see monthly or seasonal behaviour. Match the collection window to the cycle of the work.

The fifth is leaving the decision statement blank. Without it, the sheet becomes a log rather than a measurement.

Honestly, what the Check Sheet will not do

A check sheet counts. It does not explain. Knowing that wrong amount occurred 47 times tells you nothing about why. The tax field mismatch note on CS-001 is a hint, not a cause. You still need to go and look at the work.

It will not tell you whether a change is statistically significant. Five days of data with totals of 16, 14, 15, 15 and 15 look stable, but a check sheet carries no control limits and no test. It cannot distinguish normal variation from a real shift. That is the job of other tools in Measure and Control.

It will not correct for exposure. The counts here are raw. If Thursday processed twice as many invoices as Monday, a count of 12 against a count of 8 means something quite different. The check sheet does not know your volumes, so it cannot give you a rate.

It will not validate your categories. If the team defined the wrong five buckets, the tool will tally them faithfully and the result will mislead you with confidence. Garbage in, tidy tally out.

It will not capture what was never observed. Defects caught informally and fixed without a record never reach the sheet. Nor will it tell you the cost or the customer impact of any category. Wrong amount at 47 and duplicate entry at 3 may carry very different consequences, and the tally treats them the same.

Used with those limits in mind, the check sheet does exactly one job well. It replaces a shared impression with a count the team can point at. That is usually enough to decide where to look next.

check sheet toolmeasure phase RDMAICSdefect tally sheetfrequency by categorydata collection lean six sigmaprocess defect check sheetcontinuous improvement measure tools

Run this method inside Ci Flow

RDMAICS, A3, Just Do It and Kaizen projects with the full Lean Six Sigma toolset, AI interpretation and tollgate presentations built from your real evidence.

Keep reading

Ci Flow

Ci Flow connects improvement methodologies, guided tools, project evidence, AI support, collaboration and tollgate presentations in one operational-excellence workspace.

RDMAICS · A3 · Just Do It · Kaizen

© 2026 Ci Flow. All rights reserved.

Built for evidence-led continuous improvement