lamp.
ResourcesPricingAbout
4 min readBy

Idea-to-improvement: control and audit worksheet

This worksheet lets a reviewer test whether improvement ideas in your business really move from suggestion to measured result. An owner, quality head or outside reviewer picks a few ideas from the past quarter and traces each one through assessment, trial, results and rollout, checking that the claimed benefit is backed by figures.

When to use it

Use it every quarter on a small sample, and after a change that was announced as a success but whose benefit nobody can show. It is also useful before you approve a larger spend that depends on an earlier improvement having worked. Ideas that cannot show a measured result still cost time, so the worksheet helps you stop doing things that feel useful but make no difference.

The template

Choose at least four ideas: one rolled out, one rejected, one still on trial and one that was dropped. Use one worksheet per review.

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
I1Every idea has a written entry with a name, date and expected benefitTrace the sampled idea to its entryIdea logReviewer
I2A baseline was measured before the changeFind the starting figure and where it came fromBaseline sheet, production or sales recordReviewer
I3The decision to try the idea was made by the right personMatch the decision to the approval matrixApproval noteReviewer
I4The trial had a defined scope, period and ownerRead the trial planTrial planReviewer
I5Results were measured the same way as the baselineCompare the method and period in bothTrial results, baselineReviewer
I6The claimed saving or gain in ₹ can be reproducedRecompute from source recordsBills, output records, time sheetsReviewer
I7Rollout was recorded, with who was told and trainedFind the notice and the attendance of trainingNotice, training sheetReviewer
I8Benefit was checked again after a few weeksLook for a follow-up readingFollow-up noteReviewer

How to fill it

  • Ref: keep the numbers fixed so reviews can be compared.
  • How to test: write the idea numbers sampled so another person can repeat the test.
  • Evidence to check: name the document and the date.
  • Tester: must not be the person who proposed or ran the idea.
  • Result and note: write Pass or Fail and one line on what you found. A saving that cannot be recomputed is a fail.
  • Corrective action: name an owner and a date, and say if the change should be reversed.
  • Sampling: include ideas that were rejected or dropped as well as those that were rolled out, because the reasons for rejecting an idea are as useful to check as the proof behind a success.

Example row

RefControlHow to testEvidence to checkTesterResult and noteCorrective action
I6The claimed saving in ₹ can be reproducedIdea 018, switch to larger carton, claimed saving ₹14,000 a monthCarton bills, dispatch countAnitaFail. Bills show ₹6,900 saved, but damaged goods credits rose by ₹4,200Dispatch head to restate the net benefit by 20 Nov and review the carton size

Review and sign-off

  • The reviewer signs and dates the worksheet and gives it to the owner.
  • Run it quarterly, and after any idea that involved significant spend.
  • Escalate to the owner if a rolled-out idea cannot show a benefit, or if the benefit figure was claimed without a baseline.

Keeping it up to date

  • Add rows for controls you introduce, for example a mandatory baseline reading, and remove none without the owner's sign-off.
  • File completed worksheets together to see whether claimed benefits hold up over time.
  • Keep records for the period your CA or the law requires, and keep trial data as long as the change it supports remains in use.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →