Ledger-as-Table Mistake Cost Six Months

A single balance column in a payments API caused a production incident requiring two days of manual reconciliation and a full architecture rewrite. The design passed testing and code reviews but failed when the system needed to answer questions it was never designed for. The mistake cost the team six months.