Treasury foreign currency forward contracts model and MTM valuation sheet — "Unrecorded MTM balance sheet adjustments surprising auditors at fiscal year end"
Why the manual spreadsheet breaks financial controls and how a deterministic workflow replaces it.
FX forward settlements and mark-to-market values are typed from broker confirms into a hedge workbook, so MTM moves wait until someone opens the sheet.
Unrecorded MTM balance-sheet adjustments surprise auditors at year end because the workbook was not refreshed to the valuation date.
Market telemetry feed that values each hedge contract at the stored curve and posts MTM and settlement entries with the hedge relationship cited.
MTM assertion: every open hedge must have a valuation on the reporting date from the stored curve, and the posted MTM must equal that valuation or the period cannot close.
Three-stage comparison between manual workbook reconciliation and automated rule-based execution.
Forward settlements and marks are keyed from broker emails.
Unrecorded MTM adjustments appear only when auditors revalue the book.
Each contract values from the stored curve and posts MTM with the relationship cited.
Every open hedge must have a reporting-date valuation, and posted MTM must equal it.
Adjacent spreadsheet failure modes in the same APQC Category 9 process group.
Treasury FX exposure workbook and hedge coverage matrix
Intercompany treasury debt tracker and tax documentation binder
Treasury intercompany netting sheet and bilateral payment calendar
Scope the replacement architecture for manual tracking of treasury fx hedge contract settlements and mtm gains or combine multiple failure modes in the directory.
