INVOICE PROCESSING

Match incoming SaaS charges to your known vendor registry

Reconciles each new Stripe outbound charge against a Snowflake registry of approved SaaS vendors.

CategoryInvoice Processing
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew Stripe charge postedStripeStripe
  • ActionLook up merchant in Snowflake vendor registrySnowflakeSnowflake
  • LogicBranch: known vendor vs unknown merchant
  • ActionMark known charge reconciled in SnowflakeSnowflakeSnowflake
  • OutputPost unknown charge to Slack for owner reviewSlack

What it does

Every time a SaaS charge posts, this workflow checks it against your authoritative vendor list. Recognized recurring subscriptions are reconciled silently; charges from vendors you have never approved get surfaced before the money is forgotten.

When to use it

Run this when your card or Stripe account pays dozens of software vendors a month and finance keeps discovering charges nobody remembers approving. It turns a monthly spreadsheet audit into a continuous, charge-by-charge match.

How it works

  1. 1A new Stripe charge event fires the workflow with the descriptor, amount, and last-four.
  2. 2The vendor registry table in Snowflake is queried for a matching normalized merchant name.
  3. 3A branch splits the charge: known vendor versus unknown merchant.
  4. 4Known charges are written back to Snowflake as `reconciled` with the matched vendor id.
  5. 5Unknown charges post to a Slack review channel tagging the finance owner with the descriptor and amount, asking them to approve or dispute.
  6. 6The owner's reaction or reply is logged so the same merchant auto-clears next cycle.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect StripeCustomers, subscriptions, payments.
  2. 2
    Connect SnowflakeWarehouses, queries, shares.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.