← More templates

Monthly net revenue retention worksheet template

By Kivrelune Studio

Monthly net revenue retention worksheet

Monthly net revenue retention worksheet

Reconcile movement in an opening customer cohort and explain the drivers of retention.

Opening cohort

Month: [period]. Opening recurring revenue from existing customers: [amount]. Currency and adjustment policy: [rules]. Keep new-customer revenue outside this cohort.

Reconcile movement

Expansion [amount]; contraction [amount]; churn [amount]. Closing cohort revenue = opening + expansion − contraction − churn. NRR = closing cohort revenue ÷ opening revenue × 100. If opening is zero, record N/A.

Explain the change

Largest expansion or loss: [account event and cause]. Compare with [prior period using same basis]. Follow-up action, owner and expected signal: [details].

Using this template

Freeze the opening customer cohort and reconcile expansion, contraction and churn using consistent currency and period rules. Review the largest movements with account owners so the monthly result leads to an action grounded in a known customer event.

Download Markdown

Questions & answers

Looking for more help? Visit the Help center.

Do new customers acquired during the month count toward NRR?

Keep their revenue outside the opening cohort calculation and report it separately. Reconcile the closing value of the original cohort against expansion, contraction and churn from those accounts.

What is included in this template?

Opening cohort · Reconcile movement · Explain the change. Each section includes prompts you can adapt to your team.

What should carry over to the next account review?

Capture the customer’s stated outcome, the most recent evidence and the next commitment. Add a date so the next account owner can pick up the conversation.

How do I use my own copy?

Choose “Start with this doc” to open an editable copy on this device. You can also copy the Markdown or download the file and use it in your own editor.

A shared library for your team
and the AI they work with.