Reporting & Analytics MCP Server

Stripe Reporting & Analytics

Read-only analytical view across your Stripe account: transaction history, customer profiles, subscription metrics, invoice records, and event audit logs. Includes Customer 360 and Timeline for deep per-customer analysis, plus full-text Search APIs for complex queries.

Capability areas

• Balance transactions — the financial ledger. Every charge, refund, payout, and fee creates a balance transaction. List or fetch individual transactions. Use created[gte]/created[lte] for date ranges.
• Charges and refunds — list charges filtered by customer, payment intent, or date. List refunds filtered by charge or payment intent.
• Subscriptions — list all subscriptions or search with complex criteria (metadata, status, date ranges) using Stripe's query syntax with AND/OR operators.
• Customers — list by email or date, or search with fuzzy name matching and metadata queries. Customer 360 returns a full profile (charges + subscriptions + invoices + payment methods + computed MRR and lifetime spend) in one call. Customer Timeline shows chronological activity.
• Invoices — list with filters (customer, subscription, status, collection method) or search with complex criteria.
• Events — audit log of account activity (payments, refunds, customer changes). Retained for 30 days.
• Balance — current available and pending amounts by currency.

Workflows

• Revenue analysis: list balance transactions over a date range to calculate net revenue, fees, and refund rates.
• Customer deep-dive: search for a customer → get their 360 view (lifetime spend, MRR, outstanding balance) → get their timeline for chronological activity.
• Subscription health: list subscriptions filtered by status to identify at-risk (past_due, unpaid) or churned (canceled) subscriptions.
• Invoice reconciliation: search invoices by date range and status to find unpaid or overdue invoices.
• Event monitoring: list recent events to audit account activity and detect anomalies.

Gotchas

• Amounts in cents: all monetary values are in the smallest currency unit (e.g., 2000 = $20.00 USD).
• Search vs List: Search APIs support full-text queries with AND/OR and fuzzy matching but are slower. List APIs are faster for simple filters (email, status, date).
• Event retention: events are only retained for 30 days. For longer history, use balance transactions or charges.
• Date filters: use created[gte] and created[lte] (Unix timestamps) for date range filtering on list endpoints.
• Customer 360 aggregation: makes multiple API calls internally — use judiciously when reviewing many customers.