FINANCE
Month-End Sweep to Reconcile Amended Contracts Against the Recognized Waterfall
Runs on a close-day schedule, finds every contract amended since the last close, recomputes each affected deferred-revenue schedule.
How it runs
The automated pipeline, trigger to output.
- TriggerClose-day schedule fires
- ActionQuery Snowflake for period amendmentsSnowflake
- LogicRecompute schedules and find true-up deltas
- ActionWrite reconciliation results to SnowflakeSnowflake
- OutputPost exception list to MS Teams close channelMicrosoft Teams
What it does
Amendments that land between closes silently desync the waterfall. This scheduled sweep gathers all contracts amended in the period, rebuilds their recognition schedules, compares recognized-to-date against the corrected plan, and surfaces only the contracts that need a true-up entry — so the close team chases exceptions, not the whole book.
When to use it
Run it as a pre-close control on the last business day, or the morning of close. It is for revenue accountants who need assurance that mid-period changes have been absorbed into the schedule before they lock the period.
How it works
- 1A schedule fires the workflow on close day.
- 2An action queries Snowflake for all contracts with an amendment effective in the current period.
- 3A compute step recomputes each contract's straight-line schedule from the amended terms.
- 4A logic step compares recognized-to-date against the recomputed plan and isolates contracts past a materiality threshold.
- 5The exception list with required true-up amounts is posted to an MS Teams close channel and written to a reconciliation table in Snowflake.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect Microsoft TeamsChannels, chats, files.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Finance workflows
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.
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.
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 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.
Overdue Accrual Escalation Emails to Owners and Managers
On a schedule it flags uncoded spend that has stayed open past the chase deadline and emails each delinquent owner via Gmail.
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.