Sellers often present polished Dashboards, but the raw data tells the real story. Mastering the analysis of Stripe MRR is the difference between a profitable acquisition and a bad investment.
Deal Alert AI is reader-supported. We earn commissions from affiliate links at no cost to you.
This post is based on a video from our Deal Alert AI YouTube channel. Watch the original or read the full breakdown below.
When you start looking at Software as a Service (SaaS) acquisitions, the most common mistake buyers make is trusting the summary metrics provided by the broker or the seller. Every seller wants to show that their Month-over-Month (MOM) growth is trending upward and that their churn rate is minimal. While these high-level KPIs are important, they are easily manipulated or misunderstood if you do not have access to the underlying data. In the SaaS world, revenue is not a zero or one; it is a stream of recurring transactions that can pause, refund, or cancel at any moment. Without the raw data, you are just looking at a snapshot that may have been edited to look better than it actually is.
This is where analyzing Stripe MRR data becomes your single most powerful tool. Stripe is the most common payment processor for SaaS businesses, and its export functions allow you to download the granular details of every customer, every invoice, and every payment. By digging into this raw data, you can see the exact lifecycle of a customer. You can determine if a customer remained active for six months or if they churned in the first week. You can identify if a "lifetime value" is being propped up by a few large enterprise deals rather than a broad base of small, recurring users. This level of granularity is the only way to build a defensible valuation model.
I have seen buyers overpay by hundreds of thousands of dollars because they failed to spot a hidden spike in refunds or a sudden drop in renewal rates that was masked by net number of new logos added. When you inherit a business, you inherit its problems. If the data shows a pattern of high initial acquisitions followed by rapid churn, the business model is fundamentally broken, no matter how high the current MRR looks. At Deal Alert AI, we emphasize that due diligence is not just about looking at financial statements; it is about forensic accounting of customer behavior. You need to prove that the revenue is sticky, sustainable, and scalable. If you cannot prove it with data, you should not pay full price for it.
We scan Empire Flippers, Flippa, Acquire.com and Quiet Light daily — scoring every listing. Start free.
Before you can analyze the data, you need to be precise about what Monthly Recurring Revenue (MRR) and Annual Recurring Revenue (ARR) actually mean. MRR is the normalized, predictable revenue you can expect to receive every month from your customer base. It excludes one-time fees, usage-based charges, and refunds. ARR is simply MRR multiplied by 12. However, the composition of MRR matters more than the total number. MRR can be broken down into New MRR (new customers), Expansion MRR (existing customers upgrading), Churn MRR (customers cancelling), and Contraction MRR (customers downgrading). A sophisticated buyer looks at the delta between these components to understand the health of the business.
Many sellers will quote "Net Revenue" which might include non-recurring items or even revenue from services that are not part of the software license. If you are buying a SaaS company, you are buying the code and the recurring revenue stream, not necessarily the one-off setup fees. Therefore, when you receive the Stripe data, your first task is to filter out all non-MRR transactions. Look for invoice line items that do not repeat monthly. If a significant portion of the revenue comes from one-off projects, you must value that portion at a much lower multiple, often treating it as a service business rather than a software asset.
It is also crucial to understand the difference between "Gross Churn" and "Net Churn." Gross churn is the total revenue lost from cancelled customers. Net churn takes into account expansion and downgrades. A business can have 10% gross churn but only 2% net churn if upsells are strong. However, high gross churn is still dangerous because it increases your Customer Acquisition Cost (CAC). You have to keep buying new users to offset the ones leaving, which burns cash. When analyzing Stripe data, you must calculate both to get the full picture of unit economics.
When you enter first-phase due diligence with a broker or directly with a seller, you must request specific data formats. Do not ask for a CSV dump of the entire Stripe account history if the business is large, as it may not work in Excel. Instead, ask for specific exports: the "Customers" report, the "Invoices" report, and the "Subscriptions" report. You need these separate files to cross-reference data integrity. The "Customers" file gives you the contact info and creation date. The "Invoices" file gives you the transaction history. The "Subscriptions" file tells you the current plan and status of each active user. Combining these three datasets allows you to build a complete timeline of each customer’s relationship with the platform.
You should also request data for at least the last 12 to 24 months. If the business claims to have a three-year growth history, ask for data for that entire period. You are looking for seasonality and long-term trends. A business that shows 50% growth in the last two months might be running a temporary discount campaign or a viral marketing push that is not sustainable. You need to see the baseline performance to determine if recent spikes are the new normal or a temporary anomaly. Additionally, ask for data on pricing structure changes. If the seller recently changed their price tiers, the historical MRR data will look distorted by quantity shifts rather than value shifts. You need to adjust for this to make accurate year-over-year comparisons.
Finally, ensure you have access to the data in a raw, unaltered format. While PDFs are great for visual checks, they are useless for deep analysis. You need computer-readable formats like CSV or JSON. If a seller is reluctant to share raw Stripe data, citing privacy or technical issues, that is a massive red flag. Legitimate SaaS businesses have no issue sharing anonymized transaction data. Their confidence in the data is their best asset. If they hide the numbers, there is likely something in the numbers they want you to miss. Be firm on your data requests; this is not the time to be polite, it is the time to be thorough.
Once you have the files, the raw data will be messy. Stripe exports often contain duplicate entries for refunds, credit notes, and failed payments. Your first step is to clean the invoice data. Filter out any transaction with a status of "Failed" or "Uncollected." Only include "Paid" or "Refunded" transactions in your initial review. For refunded transactions, you must subtract the refund amount from the original payment month to calculate net revenue for that period. If you do not do this, you will overestimate MRR. I have seen buyers count $10,000 in MRR when $5,000 of it had been refunded within 30 days. This is a common error that leads to wrong valuation multiples.
Next, you need to join the data. Using a tool like Python (Pandas library) or even advanced Excel Pivot Tables, you need to link the Invoice ID to the Customer ID. This allows you to track each customer individually. Create a new column for "First Invoice Date" and "Last Invoice Date." The "First Invoice Date" is your start date for calculating Customer Lifespan. The "Last Invoice Date" is crucial for identifying churn. If a customer's last invoice was three months ago and their billing cycle is one month, they have churned. Do not rely on the "Status" field in the Customers report alone, as it can sometimes lag or be manually adjusted by the seller's admin. The transaction history is the source of truth. The money moved, or it didn’t.
After joining the data, you should aggregate by month. Create a monthly summary table that shows: Total MRR, New MRR, Expansion MRR, Contraction MRR, Churn MRR, and Net New MRR. This monthly trend line is the heartbeat of the business. Look for consistency. Is the MRR growing linearly, exponentially, or sporadically? If the growth is sporadic with big jumps and dips, you need to investigate the cause. Were there major product launches? Seasonal demand? If the growth is linear and steady, it is a safer bet for prediction. Use this cleaned and aggregated dataset to build your forward-looking financial projections. Every number in your projection model must be traceable back to this cleaned historical data.
Churn is the enemy of SaaS valuation. Buying a business with high churn is like buying a ship with a hole in the bottom; you can patch it, but you have to work hard to keep it afloat. In your Stripe data analysis, you will implement a Cohort Analysis. You will group customers by the month they signed up (e.g., January 2022 Cohort) and track their survival rate over time. A curve that drops steeply in the first month and then flattens out is a "High Acquisition, Low Retention" model. A curve that drops slowly and stays high is a "Sticky Product" model. The latter commands a much higher valuation multiple (often 5x-8x ARR) compared to the former (often 2x-3x ARR).
You must also look at "Log Churn" vs. "Dollar Churn." Log Churn is the percentage of customers leaving. Dollar Churn is the percentage of revenue lost. A business can have high Log Churn if it has many low-value users, but low Dollar Churn if it has a few high-value users who stay. However, volume is king in SaaS. Trading thousands of small users for a few large users often creates concentration risk. If your top 10 customers account for 40% of your MRR, you are not in the mid-market SaaS business; you are in the enterprise service business with SaaS pricing. This requires a different due diligence approach, including reviewing the contract length and renewal terms of those specific large accounts. In the Stripe data, flag any customer whose average monthly spend is more than 2 standard deviations above the mean. Review those accounts manually.
Another subtle pattern to watch for is "Contraction Churn." This happens when customers do not cancel, but they downgrade their plan. For example, a team of 10 downgrades to a team of 5. In the Stripe data, this shows up as a negative difference in subscription price for the same Customer ID. Contraction is often a sign of product dissatisfaction, even if the customer stays. It indicates they are using less of the product, which is a precursor to full cancellation. If you see a trend of contracting cohorts over several months, the product value proposition is weakening. You need to adjust your MRR growth forecasts downward to account for this leakage. It is not as obvious as a full cancellation, but it is just as damaging to long-term revenue predictability.
Expansion Revenue is the magic ingredient that turns a 3x ARR business into a 6x ARR business. It comes from existing customers upgrading to higher tiers or adding more seats. In the Stripe data, this appears as an increase in the invoice amount for an existing Customer ID. However, not all expansion is created equal. You need to distinguish between organic expansion and "Gross Ups." Organic expansion happens when a customer grows their business and naturally needs more seats. Gross Ups are often one-time upgrades that do not recur. If you see a customer upgrade to Enterprise for $2,000/month, but they paid a one-time onboarding fee of $5,000, ensure that one-time fee is excluded from your MRR calculation. It should not be part of the recurring revenue stream.
Calculate your "Net Dollar Retention" (NDR) rate for each cohort. NDR is calculated as: (MRR from last month + Expansion - Contraction - Churn) / MRR from last month * 100. An NDR above 100% means the business grows its revenue from existing customers alone. An NDR above 110% is considered excellent in the SaaS world. If your data shows NDR dropping below 100%, the business is bleeding value. Even if total MRR is growing, it is being driven by new customer acquisition, which is more expensive and less predictable. You need to know which engine is driving the growth. If it is new acquisition, your CAC payback period must be short to make the deal financially viable. If it is expansion, you have a safter, stickier business.
Look for the "Time to Expansion." How long does it take for a customer to upgrade after signing up? If the median time is three months, and the average churn is four months, you have a problem. Customers are churning before they have the chance to expand. This suggests the onboarding process might be too slow or that the entry-level product is not compelling enough to keep them around until they grow. In your analysis, create a timeline visualization. Plot the average monthly revenue per customer (ARPU) over the customer's life. You want to see a curve that rises. If the curve is flat or declining immediately after onboarding, the product value is not increasing, which caps your lifetime value potential. Use these insights to negotiate a lower price or demand a longer price protection period for your deal.
Armed with this deep-dive analysis, you are no longer at the mercy of the seller's slide deck. You have hard data. If you find that the 12-month churn rate is 15% higher than the industry benchmark, you have leverage to reduce the purchase price. A common rule of thumb is that for every 1% increase in annual churn, you might discount the valuation by 10-15% of the enterprise value. This seems aggressive, but consider that high churn forces the new owner to hustle immediately to replace lost revenue. You are not just buying assets; you are buying a time burden. The market knows this, and if you document the high churn, you can justify a lower offer. Use specific examples from the data in your counter-offers. Show the seller the cohort analysis that proves the point. Data is a neutral arbiter; it removes emotion from the negotiation.
Additionally, use your data to structure the Sale Agreement. If you identify specific risks, such as a high dependence on a few large customers who have short contract terms, you can request an "Escrow Holdback." This means a portion of the purchase price is held in escrow and only released if certain metrics (like retention of those key customers) are met after 6-12 months. For example, if 20% of MRR comes from 3 customers, you might hold back 10% of the total deal value to secure their retention. This aligns the seller’s incentives with yours. They want their money, so they are motivated to transfer those key accounts smoothly and ensure those customers remain happy post-close. This is a professional and standard technique in SaaS M&A, and it is only possible because you understood the data.
Finally, if your analysis reveals fundamental flaws in the data integrity, such as manipulated timestamps or missing invoices, walk away or demand a complete forensic audit. Trust is the foundation of any business transaction. If the data provided in phase one is clean and accurate, that is a positive signal for the rest of the process. If it is sloppy, expect the books to be messy elsewhere. We have helped buyers save significant capital by sticking to rigorous data verification. You can find more case studies and data templates on Deal Alert AI. The goal is to buy with confidence, knowing exactly what you own. Do not let vague promises of "high growth" cloud your judgment of the current reality. The Stripe data is the reality. Respect it, and you will make profitable decisions.
While this guide focuses on analyzing data you already have, the first step is finding businesses that are worth analyzing in the first place. Most leads on the market are overhyped. You need to start with a platform that filters for quality. Empire Flippers is one of the most reputable marketplaces for buying and selling online businesses. They have a rigorous vetting process that ensures the financial data is, at least on the surface, legitimate. However, "legit" does not mean "perfect." You must still apply the deep-dive analysis techniques described above. Empire Flippers connects you with businesses that have verified revenue, which saves you the time of filtering through scams. Their broker team can also answer preliminary questions about churn and expansion trends, giving you a head start before you request the raw Stripe files.
Another excellent resource is Flippa. Flippa has a massive inventory of SaaS businesses at every price point, from micro-SaaS to enterprise-level software. Because the volume is high, the quality varies significantly. This makes Flippa a dangerous but rewarding place for experienced buyers. You must be more vigilant here. Many listings on Flippa are "self-listed" or listed by less experienced brokers. When you see a SaaS listing on Flippa, check the "Financial Data" section. Look for the trend lines. If the graph shows a sharp vertical spike in the last month, run your Stripe analysis immediately upon requesting access. Do not pay an option fee until you have verified the export capability of the Stripe account. Verify that the customer count matches the MRR. If the numbers do not add up, the listing is likely flawed.
Ultimately, the best SaaS assets are those that have survived multiple economic cycles and have a diversified customer base. When you combine the platform of Deal Alert AI with a disciplined due diligence process, you become a formidable buyer. You are not just looking for a deal; you are looking for a asset class that compounds in value. The Stripe MRR analysis is your microscope. It reveals the cellular health of the business. Use it to separate the wheat from the chaff. In the world of SaaS acquisition, knowledge is literally currency. Every point of churn you identify is a dollar you can save. Every point of expansion you verify is a multiple you can afford to pay. Take the time to do the work. The data will always tell the truth, even if the seller tries to hide it. Your diligence is your insurance policy. Invest in the analysis, and you will be protected for years to come.
We scan Empire Flippers, Acquire, Flippa, and Quiet Light daily. The best sub-$500K businesses are gone within 48 hours.
We scan Empire Flippers, Flippa & Acquire every morning. The best deals sell in 48 hours.