How to Analyze Your Stripe Revenue — Beyond the Dashboard

You open Stripe, click on the Revenue section, and see a number. Gross volume: $47,300 this month. Up from last month. That feels good. But then the questions start. How much of that is new revenue versus expansions from existing customers? What's your actual churn rate? Is your average revenue per user going up or down? How much revenue did you lose to failed payments last month?

Stripe's dashboard tells you money moved. It does not tell you whether your business is healthy. And for SaaS founders, e-commerce operators, and subscription businesses, that distinction is the difference between growing confidently and flying blind.

This guide covers what Stripe's dashboard actually shows, what it's missing, the revenue metrics you should be tracking, and how to get the analysis you need without building a data pipeline or writing API code.

What Stripe's Dashboard Shows (And What It Doesn't)

Stripe's built-in reporting is designed for operational monitoring, not strategic analysis. It answers "what happened?" but not "what does it mean?" Here's the breakdown.

What You Get

• Gross volume: Total payment volume processed through your account
• Net volume: Gross minus refunds and disputes
• Successful payments: Count and amount of completed charges
• Refund totals: Aggregate refund amounts
• Basic time-series charts: Daily or monthly payment volume over time
• Subscription overview: Active subscriber count and MRR (Stripe Billing users only)

What's Missing

This is where the problems start. Stripe's dashboard does not provide:

• MRR decomposition: You can't see how much of your monthly recurring revenue comes from new customers versus upgrades versus reactivations. You can't see how much you lost to downgrades versus cancellations. This breakdown is essential for understanding growth quality.
• Cohort retention: Do customers who signed up in January retain better than those from March? Stripe won't tell you. Cohort analysis reveals whether your product is getting stickier or leakier over time.
• ARPU trends: Average Revenue Per User over time shows whether you're successfully moving customers to higher plans or whether discounting is eroding your per-customer economics.
• Revenue concentration risk: What percentage of your revenue comes from your top 10 customers? If one whale churns, how bad is the damage? Stripe shows you individual customer payments but doesn't surface concentration analysis.
• Churn analysis by segment: Your overall churn rate is a blended number. You need to know: are $49/month customers churning at 8% while $499/month customers churn at 2%? Or vice versa? The answer changes your entire strategy.
• Seasonal patterns: Is that dip in August a problem or a normal seasonal pattern? Time-series decomposition separates trend, seasonality, and noise. Stripe gives you a line chart.

The Revenue Metrics That Actually Matter

Whether you're a SaaS business, a subscription box, or a marketplace, these are the metrics your Stripe data can power -- if you extract and analyze it properly.

Monthly Recurring Revenue (MRR) Components

Total MRR is a vanity metric on its own. What matters is the composition:

Net New MRR = New + Expansion + Reactivation - Contraction - Churned. A business growing at $50K MRR with $40K from new customers and $10K from expansions has a very different trajectory than one growing at $50K with $80K from new customers and $30K lost to churn. Same growth number, completely different health.

Average Revenue Per User (ARPU)

ARPU = Total MRR / Active Customers. Track this monthly. Rising ARPU means your pricing power is increasing or customers are upgrading. Falling ARPU means you're acquiring lower-value customers or existing customers are downgrading. Both trends are invisible in Stripe's dashboard.

Revenue Churn Rate

Revenue churn is more important than logo churn (customer count). You can lose 10 customers paying $29/month and gain 2 customers paying $500/month -- logo churn looks terrible, but revenue churn is deeply negative (which is good).

Monthly Revenue Churn = (Churned MRR + Contraction MRR) / Starting MRR

Net Revenue Churn = (Churned + Contraction - Expansion) / Starting MRR

If net revenue churn is negative, you have "net dollar retention" above 100% -- meaning your existing customers grow faster than they leave. This is the gold standard for SaaS economics and a metric investors watch closely.

Customer Lifetime Value (LTV)

LTV tells you how much total revenue a customer generates before they churn. The simplest formula:

LTV = ARPU / Monthly Revenue Churn Rate

If ARPU is $150/month and monthly churn is 3%, LTV = $150 / 0.03 = $5,000. This number determines how much you can afford to spend on acquisition (CAC). A healthy business maintains an LTV:CAC ratio of at least 3:1.

Revenue Concentration

What percentage of your MRR comes from your top 5, 10, and 20 customers? If your top 10 customers represent 60% of revenue, you don't have a product business -- you have a consulting business with recurring billing. Concentration risk is invisible until a whale churns and revenue drops 15% in a single month.

How to Export Your Stripe Data for Analysis

Getting data out of Stripe is straightforward. You have two paths depending on your technical comfort level.

Option 1: CSV Export (No Code Required)

1. Log into your Stripe Dashboard
2. Navigate to Payments > All payments
3. Set your date range (at least 12 months for meaningful analysis)
4. Click Export and select CSV
5. For subscription data: go to Billing > Subscriptions > Export

The payment export includes: amount, currency, status, created date, customer ID, description, and metadata. This is enough for revenue trend analysis, ARPU calculation, and basic churn estimation.

Option 2: Stripe API (For Larger Datasets)

If you process more than 10,000 transactions per month, the CSV export becomes unwieldy. The Stripe API gives you programmatic access to every data point. The key endpoints are:

• /v1/balance_transactions -- every money movement in your account
• /v1/subscriptions -- all subscription data including status changes
• /v1/invoices -- detailed line items for each billing event
• /v1/charges -- individual payment details with failure reasons

For a quick total revenue query, you'd use the balance transactions endpoint filtered by type and date range. But for most founders, the CSV export is faster and sufficient.

What Patterns to Look For

Once you have your data exported, here are the patterns that separate a healthy business from one heading for trouble.

The MRR Waterfall

Plot your MRR components month over month as a waterfall chart. Healthy pattern: New MRR consistently exceeds Churned MRR, and Expansion MRR grows as your customer base matures. Unhealthy pattern: Churned MRR accelerating even as New MRR stays flat. This means you're filling a leaky bucket faster and faster.

Cohort Revenue Retention Curves

Group customers by their signup month and track what percentage of their initial MRR you retain over time. Good businesses see curves that flatten after month 3-4 (early churn is normal, then survivors stick). Concerning businesses see curves that never flatten -- revenue keeps declining at a steady rate month after month, which means there's no "sticky" segment.

ARPU Direction

If ARPU is declining quarter over quarter, investigate why. Common causes: introducing a cheaper plan that attracts lower-value customers, offering aggressive discounts to reduce churn, or losing enterprise customers while adding SMB customers. A declining ARPU with growing customer count can mask a deteriorating business.

Failed Payment Patterns

Involuntary churn (failed payments that don't get recovered) is often 20-40% of total churn for subscription businesses. Look for patterns: do failures spike at the start of each month (card limits resetting)? Are certain card types failing more often? Are international payments failing at higher rates? Each pattern has a specific fix.

From Export to Insight: Running Real Analysis

You've exported your Stripe data. Now what? You have three options, each with different trade-offs.

Spreadsheets (Free, Slow, Error-Prone)

You can build MRR calculations in Google Sheets or Excel. Pivot tables on customer ID and month will get you partway. The problems: formulas break when data grows beyond a few thousand rows, calculating churn correctly requires tracking subscription state changes (not just payment presence), and you'll spend hours on formula debugging instead of analysis.

BI Tools (Expensive, Requires Setup)

Tools like Looker, Metabase, or Tableau can connect to Stripe via data warehouses. The analysis is powerful once configured, but setup requires a data engineer, ongoing maintenance, and a data warehouse (Snowflake, BigQuery). For businesses under $5M ARR, this is typically over-engineered.

Upload and Analyze (Fast, Purpose-Built)

Export your Stripe payment data as a CSV, upload it to MCP Analytics, and get automated revenue analysis. The platform runs revenue overview analysis and MRR decomposition on your actual data, producing the metrics and visualizations described in this article -- without spreadsheet formulas or data engineering.

What a Real Revenue Analysis Report Looks Like

When you run proper analysis on your Stripe data (whether you build it yourself or use a tool), here's what the output should include:

1. MRR trend with decomposition: A time-series chart showing total MRR broken into New, Expansion, Contraction, Churned, and Reactivation components. This tells the growth story.
2. Net revenue retention by cohort: A heatmap or line chart showing how each monthly cohort's revenue evolves over time. This tells the retention story.
3. ARPU trend: Monthly ARPU with a trendline. This tells the pricing power story.
4. Churn analysis: Revenue churn rate by month, segmented by plan type or customer size if possible. This tells the risk story.
5. Revenue concentration: A Pareto chart showing cumulative revenue contribution by customer. This tells the dependency story.
6. Revenue forecast: Based on current MRR, churn rate, and new customer acquisition rate, where will revenue be in 3, 6, and 12 months? This tells the future story.

Common Mistakes in Stripe Revenue Analysis

Mistake #1: Confusing Gross Volume with Revenue

Stripe's headline "gross volume" number includes refunds, disputes, tax collected on behalf of customers, and payments to connected accounts (if you're a platform). Your actual revenue is net of all these. For some businesses, gross volume overstates true revenue by 15-25%.

Mistake #2: Counting One-Time Charges as MRR

If you sell implementation fees, consulting hours, or one-time add-ons alongside subscriptions, these must be excluded from MRR. Including them inflates your recurring revenue figure and makes churn calculations meaningless.

Mistake #3: Ignoring Currency Conversion

If you have international customers paying in different currencies, you need to normalize everything to a single currency for analysis. Stripe stores amounts in the settlement currency, but if you price in EUR and GBP alongside USD, your MRR calculation needs consistent conversion rates.

Mistake #4: Not Accounting for Trials

Free trial customers who haven't converted yet are not MRR. They're pipeline. If your Stripe subscription data includes active trials at $0, exclude them from MRR and track trial-to-paid conversion rate separately. It's a leading indicator of future MRR, not current MRR.