Monthly net revenue retention worksheet template
By Kivrelune Studio

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.
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.


