Problem
Small calculation gaps can move real money. Gross-up, caps, pro-rata shares, and variance checks break down when the spreadsheet logic is hard to trace. The specific risk is that year-over-year anomalies look normal when each reconciliation is reviewed in isolation.