Guide

How to calculate NRR in Excel (and Google Sheets)

To calculate net revenue retention (NRR) in Excel, list the customers you had at the start of the period with their ARR then and now, divide the total now by the total then, and leave out anyone who signed during the period. The sample below gets to 85% in 7 formulas, with GRR next to it so you can see what expansion is hiding.

1. Lay out the cohort

One row per customer that had ARR on the first day of the period, with their ARR on that day and on the last day. Use the same two dates for everyone. (Example numbers.)

RowA: AccountB: Start ARRC: End ARRWhat happened
2Acme$60,000$72,000Expanded by $12,000
3Birch$48,000$48,000Renewed flat
4Cobalt$36,000$0Churned
5Delta$30,000$24,000Downgraded by $6,000
6Ember$26,000$26,000Renewed flat
7Fjord$0$20,000New logo, signed in month 4. Stays out of the calculation

Fjord is on the list only to show the most common mistake. Its start ARR is 0, and every formula below uses "start ARR above 0" as the test for who counts.

2. The formulas

Put the labels in A9:A15 and the formulas in B9:B15. They work the same in Excel and Google Sheets. Format B11 and B15 as percentages.

CellWhat it isFormulaResult
B9Starting ARR=SUMIF(B2:B7,">0",B2:B7)$200,000
B10Ending ARR from the same customers=SUMIF(B2:B7,">0",C2:C7)$170,000
B11NRR=B10/B985%
B12Expansion=SUMPRODUCT((B2:B7>0)*(C2:C7>B2:B7)*(C2:C7-B2:B7))$12,000
B13Churn=SUMPRODUCT((B2:B7>0)*(C2:C7=0)*B2:B7)$36,000
B14Contraction=SUMPRODUCT((B2:B7>0)*(C2:C7>0)*(C2:C7<B2:B7)*(B2:B7-C2:C7))$6,000
B15GRR=(B9-B13-B14)/B979%

The parts reconcile with the total: $200,000 − $36,000 − $6,000 + $12,000 = $170,000, which is B10. If your version doesn't reconcile, a customer is counted twice or a row is in the wrong column. B12 to B14 are also the three numbers the GRR and NRR calculator asks for.

To try it, copy this block and paste it into cell A1 of a new sheet. The columns split and the formulas calculate.

Account	Start ARR	End ARR
Acme	60000	72000
Birch	48000	48000
Cobalt	36000	0
Delta	30000	24000
Ember	26000	26000
Fjord (signed in month 4)	0	20000

Starting ARR	=SUMIF(B2:B7,">0",B2:B7)
Ending ARR, same customers	=SUMIF(B2:B7,">0",C2:C7)
NRR	=B10/B9
Expansion	=SUMPRODUCT((B2:B7>0)*(C2:C7>B2:B7)*(C2:C7-B2:B7))
Churn	=SUMPRODUCT((B2:B7>0)*(C2:C7=0)*B2:B7)
Contraction	=SUMPRODUCT((B2:B7>0)*(C2:C7>0)*(C2:C7<B2:B7)*(B2:B7-C2:C7))
GRR	=(B9-B13-B14)/B9

3. Mistakes that change the number

4. Monthly and annual reporting

Monthly. The cohort is everyone with MRR on the first of the month; the two columns are MRR on the first and on the last day. The same formulas apply. Monthly NRR sits close to 100%, so small differences matter: 98.5% a month compounds to 83.4% over 12 months (0.985 to the power of 12), and 99% a month compounds to 88.6%. Don't multiply a monthly loss by 12.

Annual. The cohort is everyone with ARR on the first day of the year, measured again on the last day. For a line the board can follow between year ends, report a trailing 12-month NRR each month: the cohort from 12 months ago, measured today.

Whichever you report, say which it is ("NRR for the 12 months to 30 September, existing customers only") and show it next to GRR and logo retention. In the sample, 85% NRR and 79% GRR tell different stories, and the 79% is the one that needs explaining. The board retention report guide covers how to present both.

Horizon reports GRR, NRR and logo retention and checks them against your finance figures before showing them, then splits every lost dollar into reasons with an owning team. See retention reporting.

Updated November 3, 2026

See which of your renewals are at risk.

A 30-minute call on a demo book, or on your own top 25 accounts.

Book a call