GRR and NRR Calculator

Know how much revenue you kept, how much you grew and where it leaked, so the number you show the board is the real one.

NRR can look incredible while your smallest customers walk out the door every single week. I've watched one fast-growing account carry the headline number while a whole tier churned underneath it, and nobody talked about it because the total looked great. This calculator puts GRR and NRR side by side for every period, with a customer-level cohort view underneath, so you can see the leak and explain it.

Enter your ARR movements each month or quarter and the Waterfall tab works out GRR, NRR and logo retention against your targets. Add each customer's ARR at the start and end of a 12-month window and the Cohorts tab shows annual retention by the year they signed and by segment. Pick a period on the Dashboard and the waterfall chart rebuilds, ready to paste into your board deck. The guide explains every metric in plain English, including why a quarterly number and an annual number are two very different things.

What's included

• GRR and NRR Calculator template in Excel, plus a make-a-copy link for Google Sheets

• 5 tabs: start here, dashboard, waterfall, customers and cohorts

• Per-period GRR, NRR and logo retention against your targets, plus annual cohort retention by start year and segment

• A dashboard with a period picker and two built-in charts

• A step-by-step PDF guide with plain-English definitions, a made-up worked example, how to present it to leadership and the mistakes to avoid

• A Steal This retention reporting check so you know your numbers are board-ready

Who it's for

CS leaders, RevOps teams and founders who report retention to a CEO, a board or investors.

How it works

Digital download. Your files are ready right after checkout. Open the Excel file, or use the link included with your download to make your own copy in Google Sheets. No physical item will be shipped.

Bundle and save

This template is part of the Metrics and Board Bundle: 8 templates for $79, about half the price of buying them one at a time. Want everything? The Complete Architect Collection has every template in the collection for $299.