FINANCE

Unmatched Bank Debit Investigator

On each incoming bank withdrawal webhook, checks Postgres for a matching expected AP payment and, when none is found, runs an agent to research the counterparty and draft…

CategoryFinance
EngineSim + Paperclip
Difficultyadvanced
Triggerwebhook
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerIncoming bank debit webhookHTTP webhook
  • ActionSearch Postgres for matching AP billPostgreSQLPostgres
  • LogicBranch: matched ends, unmatched escalates
  • ActionAgent researches descriptor and drafts finding
  • OutputPost investigation note to AP SlackSlack

What it does

Triages bank debits that do not map to a scheduled vendor payment. When a withdrawal hits and no open AP bill explains it, an agent investigates the counterparty descriptor, checks recent vendor activity and recurring charges, and drafts a plausible explanation so finance does not start every unknown debit from a cold descriptor string.

When to use it

Use this when surprise debits, auto-renewals, and merchant descriptors that do not match vendor names eat up your AP team's morning. It turns each unexplained outflow into a researched note instead of a raw line item, accelerating the keep-or-dispute decision.

How it works

  1. 1A bank debit webhook delivers the cleared withdrawal.
  2. 2An action queries Postgres for an open or recently paid AP bill matching the amount and counterparty.
  3. 3A logic branch ends quietly if matched; otherwise it escalates.
  4. 4The agent researches the bank descriptor against known vendors and recurring-charge history, then drafts a likely explanation and a recommended action.
  5. 5Posts the finding to the AP Slack channel with the debit details, the agent's hypothesis, and a keep-or-dispute prompt.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect PostgresAny Postgres URL — query, write, migrate.
  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.