Reconcile Stripe Payouts Against the GL

For a controller running weekly reconciliation who wants variances caught early. One prompt pulls Stripe payouts, matches them to Xero bank transactions, flags anything off by more than $50, and posts the report to #finance.

Stripe logoStripe
Xero logoXero
Slack logoSlack
THE GRIND

Variances get caught at close, not weekly

By the time month-end reconciliation starts, there are 4 weeks of tiny variances to trace. Each one could be a fee reversal, an FX blip, or a real bug — but investigating them at month-end takes days.

Refund fees booked without the reversal line

FX noise hidden inside real variances

Reconciliation done monthly means problems compound

Composio collapses all of this into one prompt — here's what that looks like.

THE FLOW
5 steps · 3 toolkits

Your agent runs it end-to-end.

  1. 01
    List the week's Stripe payouts with gross and net amounts
    stripe logo
  2. 02
    Match each payout to a Xero bank transaction by reference + date
    xero logo
  3. 03
    Calculate variance per payout — flag anything over $50
  4. 04
    For flagged items, trace the transaction-level breakdown
    stripe logo
  5. 05
    Post the weekly variance report to #finance with JEs suggested
    slack logo
THE PAYOFF

Variances caught in days, not weeks

Weekly cadence surfaces the real problems (missed fee reversals, pricing bugs) before they compound. Month-end close ties out on the first pass.

Paste this into Claude, Cursor, or Codex. It'll install the CLI, connect your apps, and run the task — end to end.