FINANCE
Multi-Processor Reconciliation Workpaper Archive
Nightly, assembles a reconciliation workpaper combining Stripe settlements and Snowflake ledger detail, writes it as a dated CSV to Google Drive.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly post-cutoff schedule
- ActionRetrieve Stripe settlement detailStripe
- ActionPull matching ledger entries from SnowflakeSnowflake
- LogicJoin sources into reconciled workpaper rows
- ActionWrite dated CSV to Google DriveGoogle Drive
- OutputPost workpaper link to SlackSlack
What it does
Builds and files the daily reconciliation workpaper your auditors ask for. It joins processor settlement detail with ledger entries into one matched, dated file and stores it in a structured Google Drive folder so close support is always one click away.
When to use it
Use this when your audit trail for cash reconciliation lives in ad-hoc exports and someone's downloads folder. It gives you a consistent, timestamped paper trail without manual exporting and uploading every night.
How it works
A nightly scheduled trigger fires after settlement cutoff. An action retrieves the day's Stripe balance transactions and payout detail. A Snowflake query pulls matching ledger entries. A logic step joins the two sources into a reconciled row set, tagging each line as matched or open. An action writes the result as a dated CSV into the month's Google Drive folder. A final output posts the file link plus a one-line summary (rows matched, rows open) to Slack for the close team.
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.
- 4Connect SlackChannels, DMs, threads, mentions.
- 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.