FINANCE

Reconcile corporate card charges to receipts

Daily, pulls new corporate card charges from Stripe and matches each to a submitted receipt in the tracker.

CategoryFinance
Enginesim
Difficultyadvanced
Triggerschedule
Steps5
Setup~25 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily reconciliation schedule
  • ActionPull new corporate card chargesStripeStripe
  • ActionLoad submitted receipts from trackerAirtableAirtable
  • LogicMatch charges to receipts; isolate exceptions
  • OutputSend unmatched charges and receipts to financeSlack

What it does

Each day it fetches new corporate card transactions from Stripe and tries to match every charge to a receipt the employee submitted in the expense tracker, using amount, date, and vendor. Matched charges are marked reconciled; charges with no receipt and receipts with no charge are surfaced as exceptions for finance to chase.

When to use it

Use this when employees spend on corporate cards and you need month-end reconciliation without combing two systems by hand. Running it daily keeps the unmatched list short and gets employees reminded while the spend is still fresh.

How it works

  1. 1A daily schedule triggers the reconciliation run.
  2. 2The flow pulls the day's new card charges from Stripe.
  3. 3It loads submitted receipts from the expense tracker for the same window.
  4. 4Matching logic pairs charges to receipts on amount, date, and vendor, marking matches reconciled.
  5. 5Unmatched charges and orphan receipts are compiled into an exceptions report sent to the finance channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect StripeCustomers, subscriptions, payments.
  2. 2
    Connect AirtableBases, tables, views, automations.
  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.