FINANCE

Flag Out-of-Policy Expense Reports and Route to the Right Manager for Sign-Off

When an expense report is submitted, checks each line against your spend policy in Snowflake.

CategoryFinance
Enginesim
Difficultyintermediate
Triggerwebhook
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerExpense report submitted (webhook)HTTP webhook
  • ActionLoad policy limits and submitter's managerSnowflakeSnowflake
  • LogicCompare each line item to its category cap
  • LogicBranch: any violations vs. fully compliant
  • ActionSend Slack sign-off request to the managerSlack
  • OutputWrite approval decision back to SnowflakeSnowflakeSnowflake

What it does

Intercepts every submitted expense report, scores its line items against your written spend policy, and turns silent over-limit charges into a clear approval decision owned by a named manager. Clean reports pass straight through; flagged ones get a structured Slack sign-off request so nothing approves itself by default.

When to use it

Use this when finance is rubber-stamping reports because reviewing each line by hand is too slow, and out-of-policy meals, hotels, or one-off purchases are slipping through. It gives you an audit trail of who approved what and why.

How it works

  1. 1An expense-report-submitted webhook fires with the report, its line items, and the submitter's employee ID.
  2. 2A Snowflake query pulls the active policy limits and the submitter's reporting manager.
  3. 3A logic step compares each line to its category cap and flags any overage, missing receipt, or restricted merchant.
  4. 4If no violations exist, the report is marked auto-cleared and the flow ends.
  5. 5If violations exist, a Slack message is sent to the resolved manager with the flagged lines and Approve/Reject buttons.
  6. 6The manager's decision is written back to Snowflake as the report's audit outcome.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  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.