Formula Audit Case: The Shortage Flag Was Reducing Expected Cash
Recording a cash-shortage flag could reduce expected cash by the same amount as the observed shortage, making the drawer appear closer to balanced.
The dangerous formula
Suppose expected cash is USD 1,000 and the owner counts USD 950. The system correctly has a USD 50 shortage. If “Cash Shortage / Missing Cash Flag = USD 50” also posts a USD 50 cash outflow, expected cash falls to USD 950. The reported variance disappears—but no evidence has explained where the money went.
Flag the shortage without posting it
Expected cash remains USD 1,000. Actual cash remains USD 950. Difference remains USD -50. The shortage flag records that USD 50 is under investigation. Only a later owner-approved resolution should create an accounting adjustment, recovery or loss entry.
Why this matters for fraud and error detection
An unexplained variance is evidence. Automatically reducing expected cash destroys that evidence and can turn every shortage into a “balanced” close. The system would become a balancing tool instead of a control system.
Control lesson
- Investigation flags must be non-posting unless they represent a real movement.
- Preserve expected-versus-actual difference until evidence resolves it.
- Separate “we found a shortage” from “owner approved a write-off/correction.”
- Regression-test flags and reversals against known balances.
- Never let a label change the ledger merely to make the close agree.
This case publishes the control principle, not proprietary implementation. The V20.2 build was regression-tested so a shortage flag no longer changes expected cash.