FINANCE
Month-end FX variance recompute and materiality report from BigQuery
On a month-end schedule, reads the booked foreign invoices from BigQuery, revalues them at the period-close rate, ranks the largest variances.
How it runs
The automated pipeline, trigger to output.
- TriggerMonth-end close schedule
- ActionQuery booked foreign invoicesBigQuery
- ActionPull official period-close ratesHTTP webhook
- LogicCompute and rank variances by materiality
- ActionWrite ranked report to close workpaperAirtable
- OutputPost aggregate adjustment summary to TeamsMicrosoft Teams
What it does
At period close, it revalues the full book of foreign-currency invoices against the official close rate, computes the variance versus the originally booked amount per invoice and in aggregate, and produces a ranked list of the most material movements so the close team knows exactly which lines drive the FX adjustment.
When to use it
Run this as part of the monthly or quarterly close to size the FX revaluation entry and justify it line by line. Best when your invoice ledger already lands in BigQuery and you need a defensible, ranked materiality view rather than a raw dump.
How it works
- 1A month-end schedule triggers the recompute.
- 2The flow queries all open foreign invoices and their booked rates from BigQuery.
- 3It pulls the official period-close rates and revalues every invoice.
- 4Logic computes per-invoice and aggregate variance, then ranks by materiality.
- 5The ranked report is written back to an Airtable close workpaper.
- 6A summary with the aggregate adjustment and top movers posts to Teams.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect Microsoft TeamsChannels, chats, files.
- 4Connect HTTP webhookTrigger any URL on agent actions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Finance workflows
Month-End Uncoded Spend Chaser via Snowflake to Slack
On a month-end schedule, queries Snowflake for unaccrued or uncoded expenses, groups them by department owner.
Receipt Upload OCR Policy Check with Manager Escalation
When an employee drops a receipt into a Drive folder, it extracts the line items, checks them against expense policy.
Weekly Proration Anomaly Audit to Notion
Each week it aggregates all flagged proration discrepancies from Snowflake, scores them against anomaly thresholds, and publishes a finance-ready audit page in Notion with totals.
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.
Detect Mid-Cycle Plan Change Mischarges and Queue Credit Memos
Listens for Stripe subscription plan changes, recomputes the correct prorated amount.
Draft and Send Proration Over-Billing Correction Emails
For each confirmed over-billing credit, an agent drafts a clear, customer-specific apology email explaining the proration error and the credit applied.
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.