Build a Revenue Dashboard From Stripe Data

68% of SaaS founders check their revenue numbers daily, but only 12% say they trust their dashboard accuracy, according to a 2025 Baremetrics survey. The gap exists because most revenue dashboards are either Stripe's built-in charts (which lack SaaS-specific metrics like net MRR churn and expansion revenue) or custom spreadsheets that break when edge cases appear. A properly built Stripe revenue dashboard takes raw payment data and transforms it into the metrics investors, board members, and operators actually need.

This guide walks through building a revenue dashboard from Stripe data -- what metrics to include, how to calculate them correctly, what data sources to pull, and how to avoid the common mistakes that make dashboards unreliable.

The Metrics Your Stripe Revenue Dashboard Needs

Not every metric is worth tracking. Here are the ones that matter, organized by audience:

For the Founder (Daily View)

Metric	Why It Matters	Update Frequency
MRR (Monthly Recurring Revenue)	Core health metric	Daily
Net new MRR	Growth momentum	Daily
Today's charges	Operational pulse	Real-time
Failed payment count	Involuntary churn risk	Daily
Trial conversions (today)	Funnel health	Daily

For the Board (Monthly View)

Metric	Why It Matters	Update Frequency
MRR growth rate	Month-over-month trajectory	Monthly
Net revenue retention (NRR)	Expansion vs. contraction	Monthly
Gross churn rate	Customer loss rate	Monthly
ARPU (Avg Revenue Per User)	Pricing effectiveness	Monthly
LTV:CAC ratio	Unit economics	Monthly

For Finance/Ops (Weekly View)

Metric	Why It Matters	Update Frequency
Cash collected vs. recognized	Revenue recognition accuracy	Weekly
Deferred revenue balance	Balance sheet liability	Weekly
Payment failure rate	Collection health	Weekly
Refund rate	Product/service issues	Weekly
Processing fee total	Cost of revenue	Weekly

For a quick calculation of your current SaaS metrics from Stripe data, use the SaaS metrics calculator.

Step 1: Extract the Right Data From Stripe

Stripe provides several data access methods, each with different tradeoffs:

Stripe Dashboard + CSV Export

Best for: Companies under $50K MRR with simple billing.

Export monthly reports from Stripe Dashboard > Reports. Key reports:

Balance summary (charges, refunds, fees, payouts)
Subscription metrics (new, canceled, churned)
Customer list with subscription details

Limitation: CSV exports are point-in-time snapshots. You cannot backfill or recalculate historical metrics without re-exporting.

Stripe API

Best for: Companies building custom dashboards or integrating with BI tools.

Key API endpoints for revenue data:

/v1/subscriptions -- Active subscriptions with plan amounts
/v1/invoices -- All invoices with line items and payment status
/v1/charges -- Individual payment transactions
/v1/balance_transactions -- Fees, payouts, and balance changes
/v1/customers -- Customer metadata and subscription history

Rate limits: 100 read requests per second in live mode. For large datasets (10,000+ customers), use pagination and cache results.

Stripe Sigma (SQL Access)

Best for: Companies with $100K+ MRR and complex reporting needs.

Stripe Sigma lets you write SQL queries directly against your Stripe data. It is the most flexible option and updates daily.

Cost: $0.02 per row scanned. A query scanning 100,000 rows costs $2. Monthly costs typically range from $50-$500 depending on query volume.

Stripe Data Pipeline

Best for: Companies that want Stripe data in their own data warehouse (Snowflake, BigQuery, Redshift).

Stripe syncs your data hourly to your warehouse. You build dashboards with your existing BI tools (Looker, Metabase, Tableau).

Cost: Starts at $100/month.

Step 2: Calculate MRR Correctly

MRR is the most important SaaS metric and the most frequently miscalculated. Here is how to get it right from Stripe data.

MRR Calculation Rules

Include:

Active subscription amounts normalized to monthly
Annual plans divided by 12
Quarterly plans divided by 3
Usage-based revenue from the most recent month (or trailing 3-month average)

Exclude:

One-time charges (setup fees, implementation fees)
Refunded subscriptions
Free trials (no revenue)
Paused subscriptions

Edge cases:

Metered billing: Use the most recent invoice amount
Coupons: Use the discounted amount, not the list price
Multi-currency: Convert to a single currency using a consistent exchange rate (beginning-of-month rate is standard)

MRR Movement Categories

Break MRR changes into five categories:

Category	Definition	Stripe Data Source
New MRR	First subscription for a new customer	`customer.subscription.created` where customer had no prior subscriptions
Expansion MRR	Existing customer increases spend	`customer.subscription.updated` with increased amount
Contraction MRR	Existing customer decreases spend	`customer.subscription.updated` with decreased amount
Churn MRR	Customer cancels	`customer.subscription.deleted`
Reactivation MRR	Previously churned customer returns	`customer.subscription.created` where customer had prior canceled subscriptions

Net new MRR = New + Expansion + Reactivation - Contraction - Churn

For a detailed guide on MRR tracking methodology, see how to track MRR.

Worked Example: Monthly MRR Bridge

MRR Category	Amount	Count
Starting MRR (March 1)	$85,000	425 customers
+ New MRR	+$4,200	21 new customers
+ Expansion MRR	+$2,800	14 upgrades
+ Reactivation MRR	+$600	3 reactivations
- Contraction MRR	-$1,100	8 downgrades
- Churn MRR	-$3,400	17 cancellations
Ending MRR (March 31)	$88,100	424 customers
Net new MRR	$3,100

Step 3: Build Cohort Analysis From Stripe Data

Cohort analysis reveals whether your revenue quality is improving over time. Group customers by their signup month and track revenue retention.

Revenue Retention Cohort

Cohort	Month 0	Month 1	Month 2	Month 3	Month 6	Month 12
Jan 2026	$10,000	$9,200	$8,900	$8,600	$7,800	--
Feb 2026	$12,000	$11,400	$11,100	$10,800	--	--
Mar 2026	$8,500	$8,100	$7,900	--	--	--

Reading this: The January cohort generated $10,000 MRR in their first month. By month 3, they retained $8,600 (86% revenue retention). If revenue retention exceeds 100% in later months, you have negative net churn -- expansion revenue from existing customers exceeds churn losses.

Building Cohort Data From Stripe

Query all customers with their created date (signup month = cohort)
For each cohort, sum active subscription amounts at each month boundary
Divide each month's revenue by Month 0 revenue to get retention percentage

This requires either Stripe Sigma SQL queries or API calls paginated across your full customer base.

Step 4: Add Financial Context

A revenue dashboard without cost context is only half the picture. Layer in these financial metrics:

Gross Margin by Revenue Stream

Revenue Stream	MRR	COGS	Gross Margin
Core SaaS subscriptions	$70,000	$8,400 (hosting, support)	88%
Add-on features	$12,000	$1,200	90%
Professional services	$6,100	$4,900 (labor)	20%
Total	$88,100	$14,500	83.5%

Cash vs. Recognized Revenue

Month	Cash Collected	Revenue Recognized	Difference	Explanation
January	$142,000	$85,000	+$57,000	Annual plan collections
February	$88,000	$86,500	+$1,500	Slight timing
March	$91,000	$88,100	+$2,900	Slight timing

Large gaps between cash and recognized revenue indicate heavy annual billing. Track the deferred revenue balance to ensure you are not spending cash that is not yet earned.

See our guide on building a financial dashboard for startups for additional financial context layers to add.

Step 5: Set Up Alerts and Thresholds

A dashboard you check daily is less useful than a dashboard that tells you when something needs attention.

Critical Alerts (Immediate Notification)

Alert	Trigger	Action
Payment failure spike	Failure rate > 2x average	Check Stripe status, investigate
Large churn event	Single customer > 5% of MRR cancels	Outreach from founder/CSM
MRR decline	MRR decreased week-over-week	Review churn and new sales pipeline

Warning Alerts (Daily Digest)

Alert	Trigger	Action
Expansion MRR declining	3 consecutive weeks of lower expansion	Review upgrade prompts and pricing
Trial conversion drop	Conversion rate below 30-day average	Check onboarding flow
ARPU declining	ARPU dropped > 5% month-over-month	Investigate discount usage, plan mix shift

Monthly Review Metrics

Metric	Healthy	Warning	Critical
Gross churn rate	< 3%	3-5%	> 5%
Net revenue retention	> 105%	95-105%	< 95%
Quick ratio (new+expansion / contraction+churn)	> 4x	2-4x	< 2x
Payment failure rate	< 5%	5-10%	> 10%

Tools for Building Stripe Revenue Dashboards

No-Code Options

Tool	Best For	Starting Price	Stripe Integration
Baremetrics	SaaS-specific metrics	$108/month	Native
ChartMogul	Subscription analytics	$99/month	Native
ProfitWell	Free basic metrics	Free	Native
Stripe Dashboard	Simple overview	Free	Built-in

BI Tool + Data Pipeline

Stack	Best For	Monthly Cost	Setup Effort
Stripe Data Pipeline + Looker	Enterprise reporting	$300+	High
Stripe Sigma + Google Sheets	Ad-hoc queries	$50-200	Medium
Fivetran + Snowflake + Metabase	Full data warehouse	$500+	High

Custom Built

For companies with engineering resources, building a custom dashboard using Stripe webhooks and a time-series database gives you the most control. Store every relevant event, calculate metrics on read, and build exactly the views you need.

Common Dashboard Mistakes

Mistake 1: Using Stripe's MRR Instead of Calculating Your Own

Stripe's built-in MRR metric does not handle all edge cases correctly for every business. It may include paused subscriptions, miscategorize plan changes, or use different normalization rules than you expect. Always validate Stripe's MRR against your own calculation.

Mistake 2: Showing Vanity Metrics

Total revenue all-time, total customers ever, and gross bookings are feel-good numbers that do not help you make decisions. Focus on rate metrics (growth rate, churn rate, conversion rate) and per-unit metrics (ARPU, LTV, CAC payback).

Mistake 3: Not Accounting for Timezone Differences

Stripe records timestamps in UTC. If your team operates in PST, "today's revenue" might include charges from yesterday or miss charges from early this morning depending on how you filter. Standardize on UTC for all dashboard calculations.

Mistake 4: Ignoring Currency Conversion

If you bill in multiple currencies, your MRR fluctuates with exchange rates even when no subscriptions change. Lock exchange rates at the beginning of each month for MRR calculations to separate currency effects from real business changes.

FAQ

How long does it take to build a Stripe revenue dashboard?

Using a no-code tool like Baremetrics or ChartMogul: 1-2 hours to connect and configure. Using a BI tool with Stripe Data Pipeline: 1-2 weeks to set up the pipeline, define metrics, and build views. Custom-built: 2-6 weeks of engineering time depending on complexity.

Should I build or buy my revenue dashboard?

Buy if you have under $500K ARR and standard SaaS billing. The $100-200/month cost of a dedicated tool is far less than the engineering time to build and maintain a custom solution. Build if you have complex billing (usage-based, multi-currency, marketplace), need custom metrics, or want to integrate revenue data with product analytics.

Most dashboard tools offer read-only sharing via email digests or shared links. Set up a monthly automated report that emails board members a PDF snapshot on the 5th of each month (allowing time for reconciliation). Include MRR bridge, churn analysis, and cash position.

Sources

Baremetrics, "State of SaaS Revenue Reporting 2025"
Stripe Documentation, "Stripe Sigma" and "Data Pipeline" (2026)
ChartMogul, "SaaS Metrics Guide" (2026)
SaaStr, "The Dashboard Every SaaS CEO Should Have" (2025)

Get a real-time revenue dashboard without building one from scratch. Create your free culta.ai account to connect your Stripe data and track MRR, churn, and growth metrics automatically.