Stripe Payment Reconciler
Match every Stripe payment, fee, and refund against your orders — mismatches, duplicates, and fee oddities flagged in real dollars, staged for review.
This recipe pulls both sides of the money ledger for a window — Stripe charges, payouts, refunds, and exact fee lines on one side; store orders and transactions on the other when Shopify is connected — and matches them with the evidence shown, never a silent guess. Unmatched rows are classified into named buckets (payment-without-order, order-without-payment, duplicate-charge, amount-mismatch, refund-mismatch, unexpected-fees), each with the computed dollar delta and the exact transactions behind it. The report rolls up gross, fees, refunds, and net with a per-class gap analysis, and drafts one discrepancy note per material finding with a suggested next action. Nothing is charged, refunded, or written externally — the analysis is read-only and the notes are staged for your approval. Reruns within the window upsert the same reconciliation record instead of forking a duplicate.
How it runs
Multi-agent orchestration — here's the flow, step by step.
Pull the Stripe side of the window: charges, payments, refunds, disputes, payout entries, and exact fee lines per transaction, with timezone and window stated. Reads the read-only Stripe ledger via stripe_list_charges and stripe_get_customer only — payment mutation tools are never in scope for this phase.
payment scannerPull the store side when Shopify is connected: orders, totals, transaction records, and fulfillment state for the same window; flag the absence plainly when not connected.
ecommerce scannerMatch payments to orders on amount, timestamp, and reference with fuzzy matches labeled and evidence shown; isolate unmatched rows.
reconciliation checkerClassify unmatched rows into named buckets (payment-without-order, duplicate-charge, amount-mismatch, refund-mismatch, unexpected-fees) and check every fee line against the account's known fee schedule with computed deltas.
revenue analystRoll up gross charged, total fees, refunds, net received, and the per-class gap in real currency, each number tied to its row count; rank anomalies by dollar impact.
data analystDraft one discrepancy note per material finding: amounts, both sides' records, evidence, and a suggested next action — staged, never executable.
document writerAssemble the reconciliation report: matched summary, per-class discrepancy tables, fee analysis, and ranked gap analysis with the materiality threshold shown.
report formatterUpsert the window's reconciliation record for idempotency — reruns refresh, never fork — and gate the staged package for approval.
workflow orchestratorDeliver the report in-hub and stage the optional Slack alert; on approval, post approved notes and return receipts.
distributorRequired Agents
9- payment-scanner
- ecommerce-scanner
- reconciliation-checker
- revenue-analyst
- data-analyst
- document-writer
- report-formatter
- workflow-orchestrator
- distributor
Connections
Required
Optional
What it does
- Matches Stripe payments against store orders with match evidence shown
- Classifies mismatches into named buckets with dollar deltas per class
- Detects duplicate charges (same customer, amount, card, tight window)
- Flags unexpected fees vs the account's known fee schedule with computed deltas
- Per-customer and per-period refund/fee baselines computed from your own history
- Rollup of gross, fees, refunds, and net with an internally-consistent gap
- Staged discrepancy notes with suggested next actions — never auto-actions
- Idempotent per window: reruns upsert the same reconciliation record
Example prompt
Reconcile last week's Stripe payments against my Shopify orders and show me anything that doesn't match, including any fees that look off.
Ready to deploy Stripe Payment Reconciler?
Start free. One click, full agent orchestration.
Get Started Free →