INVOICE PROCESSING

Reconcile Vendor Statement Against Stripe AP and Flag Mismatches to Slack

When a vendor emails a monthly statement, this matches each line item against your Stripe payment records and posts any missing or amount-mismatched invoices to a Slack channel…

CategoryInvoice Processing
Enginesim
Difficultyintermediate
Triggerevent
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerVendor statement email receivedGmailGmail
  • ActionExtract invoice lines from attachmentOpenAI
  • ActionFetch matching Stripe payments for periodStripeStripe
  • LogicJoin lines and classify match / missing / mismatch
  • LogicBranch on whether discrepancies were found
  • OutputPost reconciliation summary to AP Slack channelSlack

What it does

Takes an incoming vendor statement (PDF or spreadsheet attachment), extracts every invoice line, and compares each one against payments recorded in Stripe. It surfaces three problem classes: invoices on the statement that have no matching Stripe payment, invoices where the statement amount differs from what was paid, and Stripe payments the vendor never listed. A clean summary lands in Slack so AP can act before the statement ages.

When to use it

Run this when vendors send recurring statements and your team manually ties them out line by line. It is ideal for AP teams that pay through Stripe and want a fast monthly close without exporting spreadsheets by hand.

How it works

  1. 1A new statement email arrives and triggers the flow.
  2. 2The attachment is parsed with OpenAI to pull invoice number, date, and amount per line.
  3. 3Stripe is queried for charges and invoices matching the vendor over the statement period.
  4. 4A reconcile step joins on invoice number and computes per-line status: matched, missing, or mismatched.
  5. 5If any discrepancies exist, a formatted breakdown is posted to the AP Slack channel; clean statements post a single confirmation.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GmailRead, draft, send, label.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect StripeCustomers, subscriptions, payments.
  4. 4
    Connect SlackChannels, DMs, threads, mentions.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    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.