Stripe Payout Reconciliation

Payouts explained: fees, refunds, and what hit the bank.

PipelinesAgent: claude

Integrated Services

Stripe

Required Configuration

This use case works best with the following environment variables, which are injected into your sandbox at runtime:

STRIPE_SECRET_KEY

Prompt

Build a Stripe payout reconciliation tool: 1. Pull recent payouts, charges, refunds, and fees via the Stripe API 2. For each payout, show the exact composition: gross charges, refunds, Stripe fees, and net amount, reconciled to the payout total 3. Flag any payout where the math does not tie out 4. Monthly summary view: revenue, fees as a percentage, refund rate 5. Export a clean CSV a bookkeeper can import into any accounting tool Use the Stripe Node SDK with pagination handled properly. If the account has no data, generate a demo mode with realistic sample payouts so every view renders.

Use this