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 multi-year cap carryovers are lost between reconciliations, which changes recoverable expense timing.