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 one spreadsheet formula can change tenant charges without leaving a clear trail.