Operations

Every Stripe transaction is reconciled daily; discrepancies are flagged with a resolution note

A daily financial controls pipeline that reconciles Stripe payments against your internal records. It pulls the day's charges, refunds, and subscription changes from Stripe, matches each transaction to its corresponding invoice or customer record, and flags any mismatches: underpayments, overpayments, duplicate charges, or missing invoices. An agent investigates each flagged item and drafts a resolution note. The reconciliation report is posted to your finance channel so your books stay clean and audit-ready.

How it works

TriggerRuns every weekday at 9:00 AM
  1. 01
    Job

    Pull the day's Stripe transactions

    Pull all charges, refunds, subscription changes, and invoice payments from Stripe for the previous calendar day. Pull the corresponding internal records from your database: invoices, customer accounts, and payment logs.
  2. 02
    Agent

    Match and reconcile every transaction

    For each Stripe transaction, match it to an internal record by customer ID, invoice ID, and amount. Flag any:
- **Unmatched charge**: Stripe shows a payment with no matching internal invoice
- **Amount mismatch**: the charged amount differs from the expected invoice amount
- **Duplicate charge**: the same invoice appears to be paid twice
- **Missing payment**: an internal invoice marked paid has no matching Stripe transaction
  3. 03
    Agent

    Investigate flagged items and draft resolutions

    For each flagged item, investigate the likely cause (timing issue, currency conversion, manual adjustment, system error) and draft a one-line resolution note. If the issue is systemic (multiple items with the same root cause), flag it for engineering review.
  4. 04
    Tool

    Post reconciliation report to #finance on Slack

    Post a reconciliation summary to #finance: total transactions processed, matched count, flagged count, and the list of flagged items with their resolution notes. If the day is fully reconciled with zero flags, post a clean confirmation.
ResultA daily reconciliation report matching every Stripe transaction to internal records, with resolutions for every discrepancy