An Empty Report Has to Prove It's Empty
"We found nothing" and "we couldn't look" produce the same sentence. A good report tells you which one it means.
Every week a report lands in the owner's inbox. One section lists transactions that still need a category. For a month, that section says the same thing: none. All clear.
It wasn't clear. Earlier that quarter, someone tightened the permissions on the accounting system, which was a sensible move. But the report's login lost access to one of the bank accounts in the process. When it asked for that account's uncategorized transactions, the system didn't refuse. It returned an empty list. Given an empty list, the report behaved exactly as designed. It printed none.
Why nobody noticed
Everything else in the report was accurate. Sales were right. The other accounts were right. That is exactly why the gap survived. A report that crashes gets attention the same morning. A report that is right on nine lines and silently empty on the tenth can run for weeks before anyone wonders.
On the page, the good news and the bad news were word for word identical.
A zero needs a receipt
This goes far beyond software. "No customer complaints this month": was everyone happy, or did no one check in with them? "No open items": none found, or none checked? "No exceptions in the reconciliation": every line matched, or the statement never loaded?
A zero on its own can't tell you which of those happened. So make it carry evidence. A quiet result should say what it looked at, not only what it found:
- "3 bank accounts and 2 cards checked, 418 transactions read, 0 uncategorized" is information.
- "0 uncategorized" on its own is a coin flip.
Make failure look like failure
The other half of the fix is to make it impossible for a failed check to pass for a clean one. If a section can't read its data, it shouldn't print a reassuring zero. It should print something like DATA UNAVAILABLE, in capitals, at the top. Ugly is the point. Things will still break sometimes. When they do, the report should look broken too.
That is the standard for every summary we send. Each section states what it checked and how many records it read. If a source couldn't be reached, the summary says so before anything else, so a blank is never mistaken for a clean result.
The takeaway: Ask that every "nothing found" in your reports also says how many accounts and records were checked to find it.
Want these checks running on your books?
We set this up on your books and your rules, and nothing posts without your approval.
Book a call