Excel templates · SaaS & subscriptions

MRR & ARR Tracker Template (Excel) — Free

Start, new, churned, end — then MRR, ARR and the movement behind them. It is the sheet that turns “we grew a bit” into new MRR against churned MRR, which is the only version of that sentence you can act on.

Free download

Download: MRR & ARR tracker

Customer movement: start, new, churned, end
MRR and ARR from the closing customer count
New MRR against churned MRR, side by side
Monthly customer churn rate, calculated

Download for Excel/Sheets Download as CSV

No email, no sign-up. Formulas already wired up.

The sheet itself

Customer movement: start, new, churned, end
MRR and ARR from the closing customer count
New MRR against churned MRR, side by side
Monthly customer churn rate, calculated

foreqast-mrr-and-arr-tracker.xlsx

HomeInsertDrawPage LayoutFormulasDataReviewView

Calibri11€

B11=B8*B10

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	MRR & ARR tracker
2	Fill in the blue cells — every other cell is a formula and works itself out. foreqast.app
3		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
4	Customers
5	Customers at start	120	130	141	156	167	183	201	216	226	246	268	296
6	New customers	14	16	19	17	21	24	22	18	26	29	34	31
7	Churned customers	4	5	4	6	5	6	7	8	6	7	6	9
8	Customers at month end	130	141	156	167	183	201	216	226	246	268	296	318
9	Recurring revenue
10	ARPA — revenue per customer (€)	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00	€89.00
11	MRR (€)	€11,570	€12,549	€13,884	€14,863	€16,287	€17,889	€19,224	€20,114	€21,894	€23,852	€26,344	€28,302
12	ARR (€)	€138,840	€150,588	€166,608	€178,356	€195,444	€214,668	€230,688	€241,368	€262,728	€286,224	€316,128	€339,624
13	Where the MRR moved
14	New MRR (€)	€1,246	€1,424	€1,691	€1,513	€1,869	€2,136	€1,958	€1,602	€2,314	€2,581	€3,026	€2,759
15	Churned MRR (€)	€356	€445	€356	€534	€445	€534	€623	€712	€534	€623	€534	€801
16	Net new MRR (€)	€890	€979	€1,335	€979	€1,424	€1,602	€1,335	€890	€1,780	€1,958	€2,492	€1,958
17	Customer churn rate	3.3 %	3.8 %	2.8 %	3.8 %	3.0 %	3.3 %	3.5 %	3.7 %	2.7 %	2.8 %	2.2 %	3.0 %

Sheet1

The blue cells are yours to fill in. Every other cell is a formula and works itself out.

How to use it

1
Type only the first opening balance
Every later month reads the one before it, so the customer count can never drift out of line with the movements you recorded.
2
Count a downgrade as churn, not as a smaller customer
This sheet uses one ARPA for everyone. If your plans differ a lot, run one block per plan rather than averaging them into a number nobody pays.
3
Read net new MRR, not MRR
MRR almost always goes up. Net new MRR is the row that tells you whether it went up because you sold, or because you happened to lose fewer customers.
4
Watch the churn rate against your growth
At 4% monthly churn you replace half your customer base every 17 months before you grow at all. That ceiling is what the row is for.

A worked example

A year that doubles MRR and hides a problem

MRR, January: €11,570
MRR, December: €25,976
Net new MRR, March: €1,335
Net new MRR, December: €1,958
Churn rate, December: 3.4%

MRR more than doubles, which reads as a very good year. But churned MRR grows from €356 to €801 a month while the churn rate stays around 3.4% — churn is not getting worse, it is getting bigger. At this base, holding 3.4% means losing €10,000 of MRR a year, and every new customer is replacing rather than adding.

The mistakes that break it

Counting annual contracts as one month of MRR
An annual plan is its yearly price ÷ 12 in every month of the term. Booking the whole amount once produces a spike and eleven months of decline.
Measuring churn against the closing count
Churn is measured against the customers you started the month with. Using the closing count flatters the rate in every growing month.
Never separating new from expansion
Growth from existing customers upgrading is a different business than growth from new ones, and they need different responses.