Delete the report before you automate it: the test most owners skip

Many recurring reports that business owners request to automate are completely useless. The report goes to a WhatsApp group that has not received a reply for months. A stock report is emailed to a partner who checks the actual stock by visiting the warehouse. A monthly MIS deck is assembled by an accountant, opened once, skimmed, and filed away.

When an owner asks to automate a report, the first question should not be about tools or cost, but rather if anyone actually uses this report. The most cost-effective way to determine this is to stop sending the report and observe who notices its absence.

Dead reports accumulate because no one wants to admit they were unnecessary. The person compiling the report has no authority to stop, and those receiving it rarely say no. Recurring, well-defined tasks are easy targets for automation, making these reports an attractive proposition for automation consultants. However, automating a report that no one uses results in wasted resources, as the script will continue running indefinitely, even after the original purpose is no longer needed.

To determine if a report is truly needed, the "two-week silence test" can be employed. Choose one recurring report and ask the person compiling it to pause it for two weeks without informing the recipients. Do not send any announcements, as these can lead to misleading responses. After two weeks, watch for one of three outcomes: someone asks about the report, they notice the absence, or there is complete silence.

If someone asks about the report within the first few days, it is probably a critical piece of information. If they notice its absence after two weeks, it was likely a habit rather than a useful tool. If there is complete silence, the report can be safely deleted and the time previously spent on it re-allocated to more valuable tasks.