Reconcile Stripe payouts against Airtable records

An Orkeste agent pulls each Stripe payout, matches it line-by-line against the related invoices and bookings in your Airtable ledger, and proposes a reconciliation. Finance approves each batch before any write happens.

How the workflow runs

1. Pull payout: Agent fetches the latest Stripe payout with full line items.
2. Match to Airtable records: Pairs each charge to an invoice or booking using rules and IDs.
3. Flag exceptions: Surfaces unmatched lines, fee deltas and FX rounding issues.
4. Finance approves: Finance reviews matches and exceptions, approves the batch.
5. Write reconciliation: Approved matches are written to Airtable with audit trail.

Human-in-the-loop: No reconciliation is written to Airtable without finance explicitly approving the batch, including exceptions.

Works with your stack

• stripe
• airtable
• gmail

Related workflows

• Detect failed Stripe payments and drive dunning with AI
• Track subscription churn signals in Stripe with AI
• Export the monthly revenue report from Airtable

Questions about this workflow

Does it handle multi-currency payouts?

Yes. FX rates are pulled from Stripe's payout report and rounding deltas surface as exceptions, not silent writes.

What about refunds and disputes?

Refunds and dispute deductions are reconciled against the original charge and flagged if context is missing.

Can finance roll back a write?

Yes. Every approved write is logged with the matching reasoning so it can be inspected and reverted.