You might already have a rough idea of your MRR. A good first draft is right there in Stripe. A bigger problem is operationalizing it by getting it into HubSpot, where you actually need it for day-to-day decisions, reporting, and board prep. Right now, that probably means exporting data and working in spreadsheets, which isn't a great use of your time.
ClearSync takes your raw Stripe billing data, calculates accurate MRR values, and syncs them to HubSpot, ensuring your dashboards are built on accurate, high-quality revenue data. This guide walks you through the full process in six steps, from connecting your accounts to setting up automated workflows.
By the end, your Stripe subscription and MRR data will live in HubSpot and update automatically as subscriptions change in Stripe, in near real time.
Quick Guide: How to Get Stripe MRR/ARR Dashboards in 6 Steps
Connect ClearSync to Stripe and HubSpot: Link your accounts with ClearSync's no-code setup.
Import your historical subscription data: Import your full Stripe history so reports and views can include important historical context.
Build a current MRR snapshot dashboard: Create a real-time view of your subscription footprint, including total MRR and ARR in HubSpot.
Build MRR trend reports by category: Track new, expansion, contraction, and churn revenue over time with monthly, quarterly, and annual reporting.
Create segment analysis reports: Slice your MRR by product, owner, customer type, or acquisition source.
Set up workflows for revenue events: Automate alerts, sequences, and Deal creation based on subscription changes in Stripe.
How to Build Stripe MRR and ARR Dashboards in HubSpot
This section is your hands-on guide to building MRR and ARR dashboards in HubSpot with ClearSync. By the end, you'll have real-time revenue reporting and automated workflows triggered by subscription events in Stripe.
Step 1: Connect ClearSync to Stripe and HubSpot
Sign up at clearsync.ai and connect your Stripe account via read-only access. Once the connection is live, ClearSync calculates current MRR and ARR for each customer and creates change events over time that you can review in ClearSync.
From there, you can connect your HubSpot portal. ClearSync will then create two app objects in HubSpot and automatically map your Stripe subscriptions and MRR change events to the corresponding HubSpot company and contact records. You can then use that data in HubSpot to build reports in later steps.
Step 2: Import Your Historical Subscription Data
ClearSync doesn't just sync data from the day you connect. It extracts your full Stripe subscription history and transforms it into MRR & ARR change events, so your trend reports and churn analysis include data going back to when you first started using Stripe.
The initial historical import includes past subscription changes and a full account of churned customers and their revenue history.
Once the import is complete, take some time to explore the historical data in HubSpot. You can see patterns that weren't visible before, such as seasonal churn or expansion trends tied to specific products or customer segments.
Step 3: Build a Current MRR Snapshot Dashboard
Start with the number that matters most: your total current MRR and ARR.
In HubSpot, go to Reports, then Create Report. Select Custom Report and set your data source to the ClearSync Stripe Subscription object. Choose KPI as the visualization type, and add Current MRR, Current ARR, and a count of active subscriptions as your values.
Filter to show only active, paying subscriptions, then save the report to your revenue dashboard. This gives you a real-time view that updates automatically as subscriptions change in Stripe. If you use this for board reporting, pin it to a shared dashboard so everyone who needs it has direct access.
Step 4: Build MRR Trend Reports by Category
Your next dashboard shows how MRR moves over time, broken down by new business, expansion, contraction, and churn.
Create a new custom report using the ClearSync Stripe Events object as your data source. Choose a vertical bar chart, set the X-axis to Event Date grouped by month, and the Y-axis to MRR Change summed. Break the data down by event type: New, Upgrade, Downgrade, Churn.
This report tells you where your revenue growth is coming from and where you're losing it. You can click into any bar to see the specific customers behind that number.
Step 5: Create Segment Analysis Reports
Now you can slice your MRR by any dimension that matters to your business: product, employee size ranges, customer acquisition source, or by segment.
In HubSpot, you can create custom reports that group MRR by Contact and/or Company properties. Because ClearSync associates subscription data with Company records, you can cross-reference billing data with CRM properties like industry, owner, segment, or customer health score.
You can build and share these reports directly in HubSpot without exporting anything to a spreadsheet.
Step 6: Set Up Workflows for Revenue Events
With your Stripe subscription data in HubSpot, every revenue event becomes something you can automate around.
Start with high-impact automations: enroll customers with failed payments into a recovery sequence, alert account owners when someone downgrades, or create a task when a subscription is scheduled to cancel.
You can also automatically create Deals, trigger notifications when a customer upgrades or expands, set up renewal reminders, or launch win-back campaigns for churned customers.
What MRR Metrics Should You Track in Your Dashboards?
Once your dashboards are set up, focus on five core metrics:
Current MRR & ARR from your install base
New & Expansion MRR by month and quarter from upgrades and add-ons
Downgrade & Churn MRR by month and quarter from customers changing plans or reducing quantities
Net new MRR, which is the sum of all four
Together, these tell you whether your revenue is growing and where that growth is coming from.
ClearSync automatically derives each of these MRR & ARR change types from your Stripe data and syncs them to HubSpot. You can track them individually in the trend reports you built in Step 4, or combine them into a single net MRR movement chart.
Tracking these over time helps you spot patterns early, such as a rise in contraction MRR, which might signal a pricing or product issue.
How Do You Use MRR Dashboards for Board Reporting?
Start with three numbers: current MRR, current ARR, and net MRR change from the previous quarter. These give your board a quick read on where the business stands and whether revenue is trending up or down.
From there, include your MRR calculation breakdown by type to show where growth is coming from. A segment view by product or customer size adds context on which parts of the business are driving results.
ClearSync keeps these numbers updated automatically in HubSpot, so you can pull your board reporting directly from your dashboards without rebuilding anything in a spreadsheet.
How ClearSync Helps You Build Stripe MRR Dashboards in HubSpot
ClearSync connects your Stripe billing data to HubSpot and translates it into clean, accurate MRR values you can use to build dashboards and reports. It handles the calculation logic that makes these dashboards reliable, including prorations, tiered pricing, discounts, and billing interval normalization.
Once you connect Stripe, ClearSync reconstructs your complete Stripe subscription history from data already in your account. Your trend reports and segment analysis will have full historical context from day one.
Every subscription event then becomes available as a HubSpot workflow trigger. ClearSync includes ready-made automation playbooks for common revenue workflows like churn prevention, failed payment recovery, and expansion alerts.
Start a free trial to see your Stripe MRR in HubSpot.
FAQs About Getting Stripe MRR Dashboards in Your CRM
How often should MRR data sync to your CRM?
It depends on how you use the data. For automated workflows like failed payment recovery, real-time syncing matters. For monthly reporting, daily syncs may be enough. ClearSync syncs every five minutes, so your dashboards are always up to date.
What if you have multiple Stripe accounts?
Some SaaS companies run separate Stripe accounts for different products or regions. Your integration needs to support multiple accounts feeding into one HubSpot portal. ClearSync handles multi-Stripe setups with account-level filtering in reports.
How do you handle multi-currency billing in MRR dashboards?
Your MRR needs to be normalized to a single default currency before it reaches your dashboards. This should happen at the data transformation level, not in your dashboard filters. Otherwise, you'll end up summing different currencies as if they were the same unit.
What's the difference between MRR from Stripe subscriptions vs. invoices?
The Stripe Subscription object is a high-quality data source with up to 30 days of history. Stripe Invoices show what was actually billed further back, but lack the same level of detail. ClearSync uses a hybrid approach: invoices for historical accuracy and subscriptions for real-time precision, giving you the most reliable MRR values.
