FINANCE
FX Weekly Hedge-Coverage Report to CFO
Each week joins Snowflake receivables with outstanding hedge positions, calculates coverage ratios and drift per currency.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly pre-review schedule
- ActionJoin receivables to hedge positionsSnowflake
- ActionFetch week-end spot and forward ratesHTTP webhook
- LogicCompute coverage ratios and drift
- LogicBuild ranked HTML coverage table
- OutputEmail digest to CFO via OutlookOutlook
What it does
Once a week this workflow reconciles open receivables against your booked forward and option hedges, computes the hedge coverage ratio per currency, and emails a clean digest to the CFO via Outlook. It surfaces which currencies are under-hedged, over-hedged, or drifting toward a threshold breach.
When to use it
Use it for the recurring treasury review where leadership needs a single, consistent coverage snapshot rather than ad-hoc spreadsheets. It standardizes the weekly hedging conversation and creates an auditable trail of coverage over time.
How it works
- 1A weekly schedule fires before the treasury review.
- 2A Snowflake query joins open receivables to outstanding hedge notional by currency.
- 3An HTTP webhook pulls week-end spot and forward rates for revaluation.
- 4A logic step computes coverage ratio, residual unhedged exposure, and week-over-week drift per currency, sorting by risk.
- 5A formatting step builds an HTML table flagging currencies below the target coverage band.
- 6An Outlook email delivers the digest to the CFO and treasury distribution list.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect HTTP webhookTrigger any URL on agent actions.
- 3Connect OutlookMail, calendar, contacts.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Finance workflows
Detect Annual-to-Monthly Downgrade Refunds Owed
Catches subscriptions switched from an annual term to monthly partway through the prepaid year, computes the unused prepaid balance owed back.
Detect Mid-Cycle Plan Change Mischarges and Queue Credit Memos
Listens for Stripe subscription plan changes, recomputes the correct prorated amount.
Expense Submission Webhook Instant Triage and Routing
Receives each expense submission via webhook the instant it's filed, classifies it as in-policy, needs-review, or hard-violation, and routes it to auto-approval.
Accrual Chase Board in Monday with Per-Owner Tasks
On a schedule it reads open uncoded expenses from Snowflake and creates or updates a Monday item per department owner.
Real-Time Uncoded Expense Nudge on New Spend Event
When a new expense lands without a GL code, a webhook fires and the workflow immediately Slack-nudges the spending owner to code it on the spot.
Monthly Vendor Spend Anomaly Brief for Finance Leads
Once a month, an agent analyzes the full expense ledger for vendor and category spend anomalies, drafts a narrative brief with the top outliers and likely causes.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.