Map Extract
Free tool

MRR, ARR and retention from your client list

Monthly recurring revenue (MRR) is the regular income from retainers, subscriptions and care plans. Paste each client's monthly amount at the start and end of a period, or type the totals, and see where MRR moved: new clients, upgrades, downgrades and losses, with annual run rate, net and gross revenue retention and a quick ratio.

Runs in your browser. Nothing you enter is uploaded.

Calculating MRR movements

  1. Choose how to enter the data

    From a customer list works out every movement for you from per-client figures. From totals suits you if you already know the opening MRR and the new, expansion, contraction and churned amounts.

  2. Paste or open the list

    Three columns: customer, MRR at start, MRR at end. A client who was 0 at the start is new; one who is 0 at the end has churned; higher or lower is expansion or contraction.

  3. Read the figures

    MRR now with the net change, ARR, net revenue retention with gross retention beneath it, and the quick ratio. A Movements table lists start, each movement and end.

  4. Check each client and export

    In list mode, each client is shown with its start, end and the movement it was counted as. Export the rows as CSV or Excel, or copy a summary line for a board update.

Example: a design agency's retainers over one quarter

A design agency with five retainer clients compared what each paid in the first and last month of the quarter. One client upgraded, one cut back, one left and one new client joined.

MRR fell from £2,450 to £2,000 because the lost client was the largest. Net revenue retention was 63.3%: of every pound of MRR the agency started with, it kept about 63p. The quick ratio of 0.57 means it added less recurring revenue than it lost, which was the trigger to focus on keeping clients before chasing new ones.

Input
Client,MRR at start,MRR at end
Hollin Bakery Supplies,650,650
Pike & Daughter Joinery,400,550
Northgate Dental,900,0
Brightline Bookings,0,450
Oakfield Vets,500,350
Result
MRR now: £2,000.00 (-£450.00 in the period)   ARR: £24,000.00
Net revenue retention: 63.3% (gross 57.1%)   Quick ratio: 0.57

Start £2,450.00 | + New £450.00 | + Expansion £150.00 | - Contraction £150.00 | - Churn £900.00 | End £2,000.00

The measures explained

MRR
Monthly recurring revenue: the total of all regular monthly charges at a point in time. One-off project fees are left out.
ARR
Annual recurring revenue, here 12 times the closing MRR. It is a run rate, not a forecast of next year's income.
Expansion and contraction
Increases and decreases in what existing clients pay, from upgrades, extra services, downgrades or discounts.
Net revenue retention (NRR)
Opening MRR plus expansion, minus contraction and churn, divided by opening MRR. Above 100% means existing clients grew in value overall, even before new sales.
Gross revenue retention (GRR)
As NRR but without expansion, so it can never exceed 100%. It shows how well you hold on to what you had.
Quick ratio
New plus expansion MRR, divided by contraction plus churned MRR. Above 1 means recurring revenue grew; below 1 means it shrank.

Recurring revenue for service firms

These measures come from subscription software, but they work well for any business with regular monthly fees: website care plans, SEO and social media retainers, bookkeeping, cleaning or maintenance contracts. Tracking them monthly shows early when a few large clients carry too much of the income, or when losses are quietly outpacing new business.

Questions people ask

How do you calculate MRR?

Add up what every active client pays you each month for ongoing services, converting annual or quarterly fees to a monthly figure, and leave out one-off charges. To see how MRR changed, compare each client's monthly amount at the start and end of a period, which is what the list mode does.

How do you calculate ARR from MRR?

Multiply MRR by 12. £2,000 of MRR is £24,000 of ARR. It tells you what a year of income would be if nothing changed, so treat it as a snapshot of the run rate rather than a prediction.

What is a good net revenue retention rate?

Anything above 100% means your existing clients are worth more than a period ago, even after losses, which is a strong position. Below 100%, you need new clients just to stand still. What counts as good varies with the type of business and contract length.

Can I enter totals instead of a client list?

Yes. Switch to From totals and type the opening MRR, new MRR, expansion, contraction and churned MRR. The same measures are worked out, although you will not see the movement for each client.

Where your data goes

Client names and amounts are processed in your browser only. The list is not uploaded or saved, so commercial details about your clients stay private.

Checked against the tool on

Top