🎯 NAV Pro Tip #8: The Stale Data & Overrides Control Check
Before you finalise the NAV, take 3 minutes to scan for stale data and manual overrides: ✅ Any stale or missing inputs?– Prices, FX, benchmarks, or rates still showing prior NAV date?– Any “default” values used (0 price, 1.00 FX, fallback sources)?– Any missing files or partial loads from vendors? ✅ Any manual overrides applied today?– Manual prices, FX, accrual adjustments, or trade edits?– Were they reviewed/approved per your control process?– Are they documented clearly (who/why/when)? ✅ Any breaks “fixed” by force?– Reconciliations cleared via plugs or temporary accounts?– Unmatched items moved to suspense without a resolution plan?– Anything that balances but doesn’t make sense? Why this matters: Many NAV issues start as “small” manual fixes and stale inputs. Overrides are not bad — undocumented overrides are. A clean audit trail and a quick sanity check prevents invisible errors from rolling forward. Pro move: If you had to override it, you must be able to explain it in one sentence and point to evidence.