Treasury FX exposure workbook and hedge coverage matrix — "Unhedged currency exposures surface only after a rate move hits the P&L"
Why the manual spreadsheet breaks financial controls and how a deterministic workflow replaces it.
Net FX exposure is measured in a treasury workbook that re-keys entity balances and hedge notionals, so coverage is whatever last week's paste produced.
Unhedged currency exposures hit the P&L after a rate move because the coverage matrix was not refreshed to current balances and hedge trades.
Position telemetry that reads entity balances and hedge notionals, computes net exposure by currency, and flags any pair above the policy limit.
Exposure assertion: each currency's net exposure must equal booked balances minus hedge notionals from the trade register, and a pair above the limit is escalated before the next session.
Three-stage comparison between manual workbook reconciliation and automated rule-based execution.
Entity balances and hedge notionals are re-keyed into an exposure matrix.
Unhedged exposures hit the P&L because the coverage matrix was not current.
Net exposure is balances minus live hedge notionals, flagged at the policy cap.
Each currency's net exposure must equal booked balances minus hedge notionals, or it is escalated.
Adjacent spreadsheet failure modes in the same APQC Category 9 process group.
Treasury foreign currency forward contracts model and MTM valuation sheet
Treasury intercompany netting sheet and bilateral payment calendar
Bank-portal CSV folder and daily cash-management report book
Scope the replacement architecture for manual measurement of fx exposure across operating entities or combine multiple failure modes in the directory.
