MRR Movement Tracker
A single MRR number tells you almost nothing. The same 74,000 can be a business adding 6,000 and losing 3,000 every month, or one adding 500 and losing nothing — and those two have completely different futures. This tracker splits the movement into its five parts.
The first sheet runs twelve months. New, expansion and reactivation are what you type in; contraction and churn are calculated from opening MRR using the two rates at the top, because both scale with size — that is the whole point. Closing MRR becomes the next month's opening, so the compounding is visible rather than assumed.
Three metrics come out of it. Net revenue retention asks what the existing base does on its own, before a single new sale: above 100% it grows by itself, and in the sample data it sits at 97.3%, meaning new business has to cover the gap before anything is left over. Gross revenue retention strips out expansion and can never exceed 100%. Quick ratio divides everything gained by everything lost — 1.54 here, against 41,242 lost across the year.
The second sheet is the part most trackers miss. Additions are an amount, losses are a percentage, so MRR does not grow forever at a steady sales pace: it converges on additions divided by loss rate. In the sample that is 5,600 ÷ 5.6%, or exactly 100,000 — and the business is already 74% of the way there after twelve months. Nothing about the sales team changes; the arithmetic simply catches up.
That reframes the growth conversation. Doubling the ceiling means either adding 5,600 more of new business every month or halving the loss rate, and the table prices both so you can see which is cheaper to buy. Finmap keeps the revenue side of this honest, separating recurring revenue from one-off work so the MRR you track is the MRR that actually recurs.
