Sarah Schlott
  • Home
  • About
  • Services
    • FP&A Consulting
      • Forecasting & Planning
      • Scenario Modeling
      • Management Reporting
      • Cash Forecasting
      • FP&A Systems & Processes
      • Variance Analysis
      • KPI Dashboards
      • Board Reporting
      • FP&A for PE-Backed Companies
    • Accounting Services
      • Bookkeeping Support
      • Month-End Close
      • Financial Statements
      • Accounts Payable
      • Accounts Receivable
      • Accounting Cleanup
  • FP&A Resources
    • FP&A Library
    • Tools & Templates
    • Blog
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu
FP&A, Finance

We rebuilt our churn reporting last quarter—because it burned us in a board meeting.

Financial model review and validation

Churn reporting can be wrong even when every number is technically correct.

That usually happens when people use the same word for different calculations.

Logo churn. Gross revenue churn. Net revenue retention. Contraction. Cancellation. Non-renewal.

Put six people in a room and ask, “What was churn?”

You may get six defensible answers.

That is not a dashboard problem.

It is a language problem.

I define the metric before automating it

This sounds painfully basic.

It is also where many reporting problems begin.

What is the numerator? What is the denominator? What period? Which customers are eligible? How are reactivations treated? What happens to partial contractions?

I want those rules written in plain English before anyone builds the SQL, spreadsheet or BI measure.

Automation makes a definition faster.

It does not make the definition correct.

Logo churn is about customer count

A simple logo churn measure might compare lost customers with the beginning customer population or renewal-eligible population, depending on methodology.

The denominator matters.

For a contractual business, I often prefer understanding the customers actually exposed to renewal during the period.

For other models, beginning population may be appropriate.

What matters is consistency and knowing what question the metric answers.

Revenue churn is about dollars

Losing a $10,000 customer and losing a $1 million customer are one logo each.

Financially, they are not the same event.

Gross revenue churn helps show recurring dollars lost through cancellations, and sometimes contraction depending on the company’s definition.

I want the definition explicit because people use “revenue churn” differently.

If contraction is separate, report it separately. If included, say so.

Gross retention removes the expansion cushion

Gross revenue retention asks how much recurring revenue remained before expansion from existing customers.

That makes it useful for understanding the durability of the base.

A company can have strong net retention because expansion is excellent while gross retention deteriorates.

Both facts matter.

I do not want the success of expansion to make losses invisible.

Net retention tells another story

Net revenue retention incorporates expansion as well as churn and contraction under the company’s methodology.

It answers a powerful question: what happened to the recurring revenue from the starting customer base after all those movements?

But it should not be described simply as “churn.”

That collapses several operating behaviors into one label.

Contraction deserves its own line

A customer who reduces seats is different from a customer who leaves.

The financial impact may still be material.

I like separating contraction when it helps management understand product usage, pricing or customer health.

If contraction is buried inside churn, operating teams may lose the distinction.

If it is buried inside net retention, the expansion dollars may hide it.

Expansion needs rules too

Upsell, cross-sell, seat growth, price increases.

Do all count as expansion?

Maybe.

What about a contractual price escalator? FX? A customer moving from monthly to annual billing?

The company needs a methodology.

I am less concerned with copying another SaaS company’s exact definition than with making ours internally consistent and decision-useful.

Renewal timing affects the denominator

If contracts renew annually, not every customer is equally exposed to churn every month.

A quarter with few renewals can produce a low churn rate that says very little about the next quarter.

I like pairing retention metrics with renewal exposure.

How much ARR was up for renewal? Which material accounts? What happened to those dollars?

That prevents seasonality from masquerading as trend.

Expired but negotiating needs a policy

A customer’s contract expires while the renewal is still being negotiated.

Sales believes it will close.

Customer Success agrees.

What does Finance do?

I want a documented treatment—perhaps a limited grace period with separate visibility—rather than letting each account manager decide whether ARR still exists.

Ambiguous states should be visible because they are forecast risk.

Reactivations should not erase churn

If a customer leaves and later returns, both events happened.

I want the churn event preserved and the return categorized according to the company’s policy—reactivation, win-back or new business.

Restating history so the churn disappears makes retention look cleaner and teaches us less.

Reporting should preserve the customer journey, not optimize the metric’s appearance.

Product-level churn and customer-level churn can disagree

A multi-product customer can cancel one product and expand another.

The logo remains. Total ARR may even grow.

The canceled product still has a retention problem worth understanding.

I like choosing the reporting grain deliberately.

Customer-level metrics answer relationship questions. Product-level metrics answer product retention questions.

One should not accidentally substitute for the other.

I want a metric dictionary people actually use

Not a 90-page PDF hidden in SharePoint.

A concise reference: metric name, plain-English definition, formula, source, owner, important exclusions and treatment of edge cases.

If the definition changes, preserve the effective date.

This reduces the monthly ritual where everyone rediscovers what “churn” means.

Definitions should reconcile to the ARR bridge

If the ARR bridge shows $2 million of churn and the churn dashboard shows $1.7 million, there should be a documented reason.

Maybe the bridge includes contraction. Maybe the timing convention differs.

Fine.

I want the relationship explained.

Metrics become stronger when they live in a coherent system rather than a collection of individually reasonable dashboards.

Source ownership matters

Who records cancellation date? Who maintains subscription status? Who identifies contraction? Who approves an adjustment?

Finance can define and reconcile the metric.

It cannot create trustworthy source data through enthusiasm.

If churn reporting repeatedly requires manual cleanup, I look upstream at the process creating the customer record.

Reason codes need governance too

Pricing. Product. Competitor. Budget. Other.

These categories can be useful if people understand them and evidence supports them.

They become decorative if account teams select whatever closes the workflow fastest.

I like periodic review of reason-code quality and a way to capture nuance for material accounts.

“Other” should not become the company’s largest customer insight.

The dashboard should show movement, not only a rate

A 7.4% churn rate is precise.

It is not automatically informative.

I want dollars, logos, major movements, trend, renewal exposure and segmentation where it changes the story.

A rate tells me magnitude.

A bridge tells me what happened.

Management usually needs both.

Cohorts can reveal what the blended metric hides

If newer customers churn more quickly, the overall rate may remain stable for a while because older cohorts are large and healthy.

Cohort analysis can expose changes in acquisition quality, onboarding or product fit earlier.

I do not need cohort charts in every board deck.

I want Finance able to investigate when the blended number stops explaining the business.

Definitions should not change to make the quarter look better

This sounds obvious enough that I almost hate writing it.

Yet edge-case treatment gets strangely flexible when a KPI is under pressure.

Metric policy should be established before the outcome is known whenever possible.

If a definition genuinely needs to change, explain the change and consider restating history for comparability.

Governance is partly protecting the metric from our own incentives.

Board reporting should be consistent with operating reporting

I do not want the board seeing one churn definition while Customer Success manages another unless the difference is explicit and useful.

Multiple views can exist.

They should reconcile.

Otherwise management spends time debating the number instead of the customer behavior underneath it.

Good definitions make better questions possible

Once everyone agrees on the language, the conversation gets more interesting.

Why is gross retention declining in this cohort? Why is contraction increasing before churn? Why do discounted customers retain differently? Why is one product losing users inside otherwise healthy accounts?

Those are operating questions.

The metric definition should get us to them faster.

Clarity is a finance control

I think metric definitions are sometimes treated as analytics housekeeping.

I see them as controls over management information.

If leadership makes decisions from ARR, churn, margin or CAC, those measures deserve stable definitions, source ownership and reconciliation.

Not because every KPI needs to become GAAP.

Because decision-useful information needs enough discipline to be trusted.

When the board asks, “What was churn?” I want the room debating what the number means for the business.

Not what the word means.

Metric changes need version control

If the company changes its churn methodology, I want the old and new definitions documented with effective dates.

Then decide whether historical periods will be restated.

Without that, a trend line can show an “improvement” created entirely by methodology.

This is particularly important when KPIs appear in board materials, debt reporting or investor communications.

The definition is part of the data.

Acquisitions can create two churn languages overnight

Combine businesses and the same KPI may have different rules.

One company includes downgrades in churn. Another reports them separately. One uses beginning ARR. Another uses renewal-eligible ARR.

I would not simply add the metrics.

Finance needs a harmonization plan and a bridge during transition.

Integration is difficult enough without pretending two percentages mean the same thing because the label matches.

Currency can distort revenue retention

For international businesses, exchange-rate movement can change reported recurring revenue without any customer behavior changing.

I like deciding whether retention is measured on a constant-currency basis, reported-currency basis, or both.

The choice depends on the management question.

What matters is that FX does not accidentally get described as expansion or contraction.

Price increases deserve their own interpretation

A contractual price increase can lift net retention even if customers buy exactly the same amount.

That may be excellent economics.

It is different from seat expansion or cross-sell.

If management is trying to understand product adoption, I want those drivers separated.

If management is trying to understand recurring-dollar durability, the combined number may be appropriate.

Again, definition follows the question.

Usage-based revenue complicates the classic SaaS metrics

When recurring customer relationships contain material usage, a fixed ARR concept may need adaptation.

Annualizing one month of usage can create volatility that looks like expansion and contraction even when the customer relationship is healthy.

I would define a methodology appropriate to the commercial model rather than forcing a subscription metric onto economics it does not describe well.

Finance should serve the business model, not the acronym.

Customer migrations can create fake churn

A customer moves from a legacy product to a new platform.

One subscription terminates and another begins.

At product level, that may legitimately be churn and new ARR. At customer level, the relationship may be retained.

I want migration rules that preserve both views where useful.

Otherwise a successful product transition can make retention reporting look like a customer crisis.

Small differences become material at scale

A one-point difference in retention methodology may not feel dramatic.

On a $200 million recurring-revenue base, it can represent millions of dollars.

That is why I become less casual about definitions as companies grow.

The metric may not be an audited financial statement.

Management decisions, valuation discussions and operating plans can still depend heavily on it.

The owner should be able to explain edge cases

A metric is not governed because a formula exists.

Someone should own the methodology and be able to answer the uncomfortable cases.

What happens to a paused customer? A disputed renewal? A partial product cancellation? A merger between two customer entities?

We do not need to predict every future edge case.

We need a principle and an owner capable of applying it consistently.

I would audit a sample of customer movements

Even automated reporting benefits from periodic ground-truth review.

Pick material churn, contraction and expansion events and trace them back to contracts and source records.

Does the category make sense? Is the amount right? Did the event land in the correct period?

This catches definition drift and source-process problems that a top-level reconciliation may miss.

The reporting stack should not invent business meaning

BI tools are excellent at calculation and presentation.

I do not want a dashboard developer quietly deciding how to classify a renewal because nobody else wrote the rule.

The business meaning should be owned upstream by Finance and the relevant operating teams.

Then the reporting layer implements it.

That keeps methodology from becoming accidental software behavior.

The simplest metric set that answers the questions usually wins

It is possible to create dozens of retention measures.

I would resist.

Choose the handful management actually uses, define them rigorously, and keep deeper diagnostic cuts available underneath.

More metrics do not automatically create more understanding.

Sometimes they create more opportunities to choose the one that tells the nicest story.

The real rebuild is shared language

That was the useful idea in the original version of this article, and I still believe it.

When churn reporting breaks, the fix is often not another dashboard.

It is agreement.

Agreement on the population, movement categories, timing, edge cases, sources and ownership.

Once that exists, the technology becomes much easier.

Without it, even a beautiful dashboard is just rendering the disagreement faster.

October 9, 2025/1 Comment/by Sarah Schlott
Share this entry
  • Facebook Facebook Share on Facebook
  • X-twitter X-twitter Share on X
  • Linkedin Linkedin Share on LinkedIn
  • Reddit Reddit Share on Reddit
  • Mail Mail Share by Mail
https://sarahgschlott.com/wp-content/uploads/2025/10/pexels-leeloothefirst-5561913-modified-1.jpg 801 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-300x300.png Sarah Schlott2025-10-09 07:30:202026-10-05 11:55:40We rebuilt our churn reporting last quarter—because it burned us in a board meeting.
1 reply
  1. Sarah Schlott
    Sarah Schlott says:
    October 2, 2026 at 12:33 pm

    Which SaaS metric has caused the most reporting debate in your organization? Churn definitions have a special talent for looking simple until the board asks a second question.

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Join the Discussion Cancel reply

What do you think? No account or email required.

Latest Posts

  • Contractor+ Is Growing. I’m More Interested in What the Cash Has to Do Next.
  • Private Colleges Have a Revenue Problem That Looks Familiar
  • The Orlando Housing Story I’m Watching Isn’t Home Prices. It’s Household Pressure.
  • Bookkeeping vs. Accounting: What Does Your Business Actually Need?
  • The 2,232-Acre Osceola Data Center Story Needs One Important Asterisk
  • Orlando Tourism Doesn’t Get to Coast on Being Orlando
  • Statusphere Just Made a Very Physical Bet on Scaling Software
  • A $103 Million Orlando Industrial Deal Says More Than the Price Tag
  • How Much Do Accounting Services Cost in Orlando?
  • Carvana Is Adding 100 Orlando-Area Jobs. The Number I’m Watching Is What Comes Next.
  • Accounting Services in Orlando: What Should a Growing Business Actually Expect?
  • The FP&A Calendar: Build a Finance Rhythm That Leaves Time to Think
  • How Often Should You Update a Financial Forecast?
  • Capital Expenditure Forecasting: The Annual CapEx Number Is Not the Forecast
  • Gross Margin Forecasting: Revenue Can Be Right and the Economics Still Be Wrong
  • Forecast Assumptions: The Model Should Remember What Changed
  • Working Capital Forecasting: Why the P&L Can Be Right and Cash Still Be Wrong
  • Operating Expense Forecasting: Stop Treating Every Cost the Same
  • Month-End Close and FP&A: When Are the Actuals Actually Ready?
  • Ad Hoc Reporting in FP&A: When the Same Quick Question Keeps Coming Back
  • Headcount Forecasting: Why Approved Hires Keep Breaking the Plan
  • Management Reporting Pack: What CFOs Actually Need Every Month
  • Budget Variance Analysis: How FP&A Finds What Actually Matters
  • FP&A Software vs. Excel: When Has Finance Actually Outgrown Spreadsheets?
  • What Is FP&A? A Practical Guide to Financial Planning & Analysis
  • FP&A Software: When Does Your Finance Team Actually Need It?
  • Driver-Based Forecasting: How to Find the Right Business Drivers
  • Financial Forecasting Methods: How to Choose the Right One
  • Financial Scenario Planning: How FP&A Can Build Scenarios That Actually Help Management
  • AI Agents in Finance: What Should CFOs Actually Let Them Do?

Sarah Schlott

FP&A consulting, forecasting, accounting support and finance strategy for CFOs and growing finance teams.

Work With Sarah →

FP&A

FP&A ConsultingForecasting & PlanningScenario Modeling & Decision SupportManagement ReportingCash ForecastingFP&A Function & Finance SystemsVariance AnalysisKPI DashboardsBoard ReportingFP&A for PE-Backed CompaniesOrlando FP&A Consulting

Accounting

Accounting ServicesAccounting & Bookkeeping SupportMonth-End Close & Financial ReportingFinancial Statements & ReportingAccounts Payable SupportAccounts Receivable SupportAccounting Cleanup & Catch-UpOrlando Accounting Services
© Copyright - Sarah Schlott
Link to: Your calendar isn’t full because you’re important. It’s full because you’re reactive. Link to: Your calendar isn’t full because you’re important. It’s full because you’re reactive. Your calendar isn’t full because you’re important. It’s full because you’re... Link to: The night before the board meeting, my forecast broke. Link to: The night before the board meeting, my forecast broke. The night before the board meeting, my forecast broke.
Scroll to top Scroll to top Scroll to top