INVOICE PROCESSING

Three-Way Match Exception Routing with Slack Approval

Runs the three-way match on each new invoice and, when quantities or prices fail to reconcile, posts a structured discrepancy card to Slack so an AP approver can release…

CategoryInvoice Processing
Enginesim
Difficultyintermediate
Triggerevent
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew invoice row inserted in PostgresPostgreSQLPostgres
  • ActionFetch linked PO and receipt linesPostgreSQLPostgres
  • LogicCompute per-line variance vs tolerance
  • ActionPost discrepancy card to Slack with approve/rejectSlack
  • ActionRelease payment via Stripe on approvalStripeStripe
  • OutputRecord override decision and approver in PostgresPostgreSQLPostgres

What it does

This workflow catches the invoices that do not cleanly match their PO and receipt, and turns each mismatch into an actionable Slack approval rather than a silent block. The approver sees exactly which lines disagree and decides whether to override and pay.

When to use it

Reach for this when matched invoices already pay automatically elsewhere, but you need a fast, auditable human path for the exceptions: short shipments, price changes, or partial receipts. It keeps held invoices from aging in a queue nobody watches.

How it works

  1. 1A new invoice row is inserted into Postgres (by your ingestion step or ERP sync), triggering the run.
  2. 2Postgres returns the linked PO and goods-receipt lines for comparison.
  3. 3A logic step computes per-line variances and flags any that exceed tolerance.
  4. 4Clean invoices exit immediately; mismatched ones build a discrepancy summary.
  5. 5A Slack message posts the variance card with Approve and Reject actions to the AP channel.
  6. 6On approval, Stripe releases the payment and Postgres records the override, approver, and reason.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect SlackChannels, DMs, threads, mentions.
  3. 3
    Connect StripeCustomers, subscriptions, payments.
  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.