FINANCE
Revenue Variance Investigator
On demand, an agent reconciles a chosen day's Stripe revenue against the Snowflake ledger, drills into the specific transactions causing any gap.
How it runs
The automated pipeline, trigger to output.
- TriggerOperator runs agent with target date
- ActionPull itemized Stripe transactionsStripe
- ActionQuery ledger line items from SnowflakeSnowflake
- LogicIsolate unmatched entries and infer cause
- OutputWrite root-cause memo to Google DriveGoogle Drive
What it does
When a daily reconciliation comes back out of balance, this agent investigates why. It compares Stripe and ledger line items for the date in question, isolates the exact charges, refunds, or fee entries that don't reconcile, and produces a written explanation of the discrepancy with the offending transaction IDs.
When to use it
Reach for it after an automated check flags a variance and someone needs to know the cause before close — not just that a gap exists. It replaces the manual spreadsheet diffing an analyst would otherwise do.
How it works
- 1An operator triggers the agent with a target date.
- 2The agent pulls itemized Stripe balance transactions for that day.
- 3It queries the Snowflake ledger for the same day's line items.
- 4Reasoning over both sets, it identifies unmatched or mismatched entries and hypothesizes causes (late settlement, miscategorized fee, missing refund).
- 5It writes a root-cause memo with the variance, the implicated transactions, and a recommended fix to a Google Drive doc.
Set it up
What you configure once, before turning it on.
- 1Connect StripeCustomers, subscriptions, payments.
- 2Connect SnowflakeWarehouses, queries, shares.
- 3Connect Google DriveDocs, sheets, slides, files.
- 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.