Spreadsheet Failure ModeManual Workflow
Root Operational Bottleneck
Interest-rate swaps are typed into a blotter from dealer confirmation emails after the reset, so the register receives the ticket only when the paste finishes.
Control Hazard & Audit Exposure
Swap resets post from a blotter that was typed after the dealer confirm arrived, and interest starts on a ticket that does not match the dealer.
Deterministic Software ReplacementClient-Owned Architecture
Interest-Rate Swap Gateway that Posts Only After Dealer Confirm Matches the Ticket
IR-swap execution gateway that captures the dealer confirm and posts the reset only when notional, rate, and reset date match the ticket.
Continuous Assertion Rule
Swap assertion: an interest-rate swap reset cannot post unless a dealer confirmation matches the ticket on notional, rate, and reset date.