What columns should a basic churn tracking spreadsheet include?

Start with six columns: Customer ID, Subscription Start Date, Cancellation Date, MRR at Cancellation, Cancellation Reason (dropdown with fixed options), and Plan. This covers the minimum data needed to calculate monthly churn rate, revenue churn, and reason distribution. Add acquisition channel and customer segment columns once you have 30+ cancellations to analyze.

How do you calculate monthly churn rate in a spreadsheet?

Divide the number of customers who cancelled during the month by the number of customers who were active at the start of the month. Use COUNTIFS to count cancellations within the month's date range, and COUNTIFS with two conditions (start date before month start, and cancellation date blank or after month end) for the denominator. Always use start-of-month count, not end-of-month, to avoid understating churn.

When should a SaaS company stop using a spreadsheet for churn analysis?

The clearest trigger is when manual data entry exceeds two to three hours per month, which typically happens around 50 active customers. Other signals: you want cohort-level segmentation, you need to analyze cancellation reason trends over time, multiple team members need access to the data, or you are making product decisions based on data that is two to four weeks out of date.

Can a spreadsheet track cohort retention?

Yes, with COUNTIFS formulas. Create a table with acquisition month in rows and months-since-acquisition in columns. Each cell tracks the percentage of a cohort still active at that tenure point. It takes two to three hours to set up and works well through a few hundred customers. Beyond that, formula complexity and manual update burden make a dedicated analytics tool the more practical choice.

What is the difference between customer churn and revenue churn in a spreadsheet?

Customer churn counts cancelled subscriptions as a percentage of total active customers. Revenue churn measures MRR lost to cancellations as a percentage of total MRR at the start of the period. In a spreadsheet, track both in parallel. Revenue churn is more useful for business decisions because it weights cancellations by their financial impact rather than treating a $30/month and a $500/month cancellation identically.

How to Build a Churn Analysis Spreadsheet (And When to Stop)

Why Spreadsheets Are the Right Starting Point

Every SaaS founder tracking churn should start with a spreadsheet. Not because spreadsheets are the best long-term tool, but because building one forces you to define exactly what you are measuring. Many early-stage teams discover mid-build that they have not agreed on how to count a cancellation, whether to include trials, or how to handle paused accounts. Working through those questions in a spreadsheet before committing them to a database schema saves significant pain later.

The spreadsheet approach is also fast. You can have a functional churn tracker running in under an hour with no engineering work, no vendor evaluation, and no procurement process. For a product under 50 customers, that is the right tradeoff.

The Core Columns You Actually Need

Resist the temptation to build a sprawling 20-column tracker on day one. Most of those columns will have data missing for 80% of rows and will make the sheet harder to maintain. Start with these six columns and add others only when you have a specific analysis question that requires them.

Column	Data Type	Notes
Customer ID	Text	Match to your billing system identifier
Subscription Start Date	Date	When the paid subscription began, not trial start
Cancellation Date	Date	Leave blank for active customers
MRR at Cancellation	Currency	Monthly value of the cancelled subscription
Cancellation Reason	Dropdown	Fixed list: Price, Missing Feature, Competitor, Not Using, Business Change, Other
Plan	Text	Starter, Pro, Enterprise — enables plan-level segmentation

The cancellation reason column is the most important and the most commonly misconfigured. Use a dropdown with a fixed list of five to seven options. Free-text fields seem more informative but produce data you cannot aggregate. A column full of unique free-text strings is an archive, not a dataset. For a deeper breakdown of how to structure cancellation reasons into a taxonomy, see how to analyze cancellation feedback.

The Monthly Churn Rate Formula

The standard monthly churn rate calculation: divide the number of customers who cancelled this month by the number of customers who were active at the start of the month. Multiply by 100 to express as a percentage.

In spreadsheet terms, if column A contains cancellation dates and you want March churn: count customers where cancellation date falls in March, divide by count of customers where start date is before March 1 and cancellation date is blank or after February 28. The denominator is the tricky part. Use COUNTIFS with two conditions on the start and cancellation date columns.

A common mistake is using end-of-month active count as the denominator instead of start-of-month. This understates churn because cancelled customers are excluded from the denominator. Use start-of-month customer count consistently and your month-over-month trends will be comparable.

For a step-by-step formula reference with examples, use the free churn rate calculator. For the full formula derivation, see churn rate formula explained.

Adding Revenue Weighting

Once you have basic customer count churn working, add revenue churn in a parallel set of calculations. Revenue churn divides MRR lost to cancellations by MRR at the start of the month. This number matters more than customer count churn because a single $500/month cancellation has ten times the business impact of a single $50/month cancellation.

Add a second summary table below or beside your main tracker with these four cells: MRR Start of Month, MRR Lost to Churn, MRR Churn Rate (Lost divided by Start), and MRR Retained Rate (1 minus Churn Rate). Update it at the end of each month by filtering your tracker for cancellations in that month and summing the MRR column.

For context on how revenue churn and customer count churn diverge at different company stages, see revenue churn vs. customer churn.

Tracking Trends Over Time

A single-month snapshot of churn is nearly meaningless without context. The value of the tracker comes from accumulating 6 to 12 months of data and watching the trend. Build a summary tab with one row per month and columns for: month, starting customers, cancellations, new customers, ending customers, monthly churn rate, MRR lost, and MRR churn rate.

Populate this manually at the end of each month by pulling from the main tracker. A simple line chart of monthly churn rate over time is more actionable than any single month's number. It shows whether churn is improving, worsening, or flat, and lets you correlate spikes with specific events: a pricing change, a feature launch, a support incident, or a new acquisition channel that brought in poor-fit customers.

Cohort Analysis in a Spreadsheet

The most advanced useful analysis you can do in a spreadsheet is a basic cohort retention table. Group customers by the month they started and track what percentage of each cohort is still active one month, two months, three months, and six months later. This takes about two hours to set up with COUNTIFS formulas but reveals whether newer cohorts retain better than older ones, which is the key early-stage product-market fit signal.

The cohort table has acquisition month in rows and months-since-acquisition in columns. Each cell contains a retention percentage: customers from that cohort still active at that tenure point divided by cohort starting size. Color-scale formatting makes the pattern immediately visible. For a full guide on cohort analysis construction and interpretation, see cohort retention analysis.

When Spreadsheets Break Down

A spreadsheet churn tracker has a useful lifespan. The signals that you have hit its limits are specific and consistent across early-stage SaaS companies.

50+ active customers: Manual data entry becomes a weekend chore. At 50 customers you are maintaining 50+ rows across multiple tabs, cross-referencing with billing data, and making data entry errors that corrupt trend calculations. The maintenance burden exceeds the analytical value.

Qualitative trend analysis: You want to know whether the share of churn attributed to pricing is increasing or whether competitor mentions are clustering in a specific cohort. This requires filtering and pivot tables that become increasingly brittle as the dataset grows. What starts as a two-minute analysis becomes a 30-minute debugging session for mismatched dropdowns.

Segmented churn by cohort or plan: Asking whether Pro customers churn at a different rate than Starter customers requires a level of filtering and formula complexity that most spreadsheets cannot sustain cleanly beyond a few hundred rows. The answer is usually technically correct but fragile.

Real-time data: A spreadsheet is a snapshot you update monthly. If a customer churns on the 14th and you update the tracker on the 30th, you have two weeks of blind spot. At low volume this is acceptable. At higher volume you are making decisions based on two-week-old data.

Sharing and collaboration: When a customer success team member needs churn data and you are the only person who knows how the spreadsheet works, the tracker becomes a bottleneck. Spreadsheets do not scale organizationally even when they still scale technically.

The Transition to Automated Analysis

The transition from spreadsheet to dedicated churn analysis tool is not about abandoning the work you did. The columns and taxonomy you built in your spreadsheet become the data model for your automated system. The definitions you established (how to count a cancellation, which date to use, how to classify reasons) carry forward directly.

The case for transitioning is a time calculation. If you spend four hours per month on manual churn tracking at 50 customers and that grows linearly to eight hours at 100 customers, the monthly time cost of manual tracking exceeds the monthly cost of most SaaS analytics tools before you hit $1M ARR. The spreadsheet is no longer saving money. It is costing founder time that has a higher opportunity cost than any tool subscription.

Automated churn analysis tools connect to your billing system (Stripe, Paddle, or Chargebee), pull cancellation data in real time, and calculate cohort retention, revenue churn, and reason distribution without manual data entry. The cancellation survey you built into your product feeds directly into the dashboard. You stop spending Sunday nights updating a spreadsheet and start spending Monday mornings reviewing trends and acting on them.

If your manual tracker has outgrown its usefulness, RetentionCheck connects to Stripe in minutes and replaces the spreadsheet workflow with automated cohort analysis, revenue-weighted churn reason reporting, and a real-time dashboard. The setup takes less time than your next monthly spreadsheet update.

Churn Health Scoring

One thing spreadsheets cannot do well is generate a composite health score that synthesizes multiple churn risk signals into a single actionable number. Tracking usage frequency, support ticket volume, cancellation survey responses, and payment failure rate as separate columns produces a lot of data but not a clear priority list for which customers need attention this week. For an overview of how churn health scoring works and when it is worth implementing, see churn health score methodology. For current benchmarks across SaaS categories, see RetentionCheck churn benchmarks.