Why I'll Never Trust a Live File As a Source of Truth Again
I've been burned by this exact problem twice in production, and both times I blamed the wrong thing. A client's usage numbers drifted by ~15% month-over-month. We assumed it was a calculation error in our reconciliation logic. Spent three days tracing through aggregation queries....