# MRR (monthly recurring revenue): the formula, and where new, expansion and churned MRR come from in CRM deals

https://salesbond.app/blog/mrr-monthly-recurring-revenue-sales-owner-new-expansion-churn-from-crm-deals/
Published: 2026-11-16 · Updated: 2026-11-16

MRR, monthly recurring revenue, is the predictable revenue a business expects every month from active subscriptions or contracts, with one-off payments left out. The formula: MRR at the end of the month = MRR at the start + new MRR + expansion MRR − contraction MRR − churned MRR.

Each of those four lines comes from a kind of deal in your CRM: newly won customers, upgrades, downgrades and cancellations. Paddle’s guide to annual recurring revenue (read November 16, 2026) gives the yearly version as MRR multiplied by 12 ( [Paddle: annual recurring revenue](https://www.paddle.com/resources/annual-recurring-revenue)).

Wikipedia’s article on revenue streams defines recurring revenue as revenue “likely to continue to be generated regularly for a significant period of time” and says the tracked number “excludes all one-time, non-recurring payments”, naming implementation and professional service fees and hardware ( [Wikipedia: recurring revenue](https://en.wikipedia.org/wiki/Revenue_stream#Recurring_revenue), read November 16, 2026). Apply that sentence to a list of deals and most MRR arguments in a sales meeting go away.

## The MRR formula and a worked example

Say a service business sells monthly retainers and starts March with $50,000 of MRR. The numbers here are an illustrative example, made up so the arithmetic is easy to follow.

During March the CRM shows eight deals that touch recurring revenue:

| Deal | What happened | Monthly recurring amount | Goes into |
| --- | --- | --- | --- |
| A | New customer, $1,200 a month | +1,200 | New MRR |
| B | New customer, $800 a month, plus a $4,000 setup fee | +800 | New MRR (setup fee stays out) |
| C | New customer, annual plan, $18,000 paid up front | +1,500 | New MRR (18,000 ÷ 12) |
| D | Existing customer adds seats | +400 | Expansion MRR |
| E | Existing customer moves to a higher tier | +300 | Expansion MRR |
| F | Existing customer drops an add-on | −250 | Contraction MRR |
| G | Customer cancels a $900 plan | −900 | Churned MRR |
| H | Customer doesn’t renew a $600 plan | −600 | Churned MRR |

Add the lines up. New MRR is 1,200 + 800 + 1,500 = $3,500 and expansion MRR is 400 + 300 = $700. Against that, contraction takes $250 and churn takes 900 + 600 = $1,500, so net new MRR for the month is 3,500 + 700 − 250 − 1,500 = $2,450. The business ends March at 50,000 + 2,450 = $52,450 of MRR, which is 52,450 × 12 = $629,400 of ARR.

Growth is the same arithmetic divided by where you started. MRR growth rate = (MRR at the end − MRR at the start) ÷ MRR at the start, so March grew 2,450 ÷ 50,000 = 4.9%. One month of it tells you little. Put twelve months side by side and you can see whether growth comes from new logos or from customers who already pay you.

The three new customers were invoiced 1,200 + 800 + 4,000 + 18,000 = $24,000 in March. New MRR is $3,500. Both figures are correct and they answer different questions, which is why a report that mixes them can’t be reconciled with the bank account.

![Bridge chart of one month of MRR: new and expansion lift it, contraction and churn pull it down to the end-of-month total](https://salesbond.app/wp-content/uploads/2026/11/mrr-monthly-recurring-revenue-sales-owner-new-expansion-chur-2.png)

Stripe’s guide gives a shorter formula, MRR = number of customers × average monthly revenue per customer ( [Stripe: monthly recurring revenue explained](https://stripe.com/resources/more/what-is-monthly-recurring-revenue), read November 16, 2026). It works for a quick check. We wouldn’t run a sales team on it. An average hides which customer moved, and the owner’s next question is always “who left, and who upgraded?” If you have a CRM, add MRR up deal by deal, the way the table does.

## New, expansion, contraction and churned MRR

[Stripe’s guide to monthly recurring revenue](https://stripe.com/resources/more/what-is-monthly-recurring-revenue) (read November 16, 2026) splits MRR into new, expansion, churn, reactivation and contraction, and defines net new MRR as new plus expansion minus churn and contraction. For a sales owner each of those maps to a kind of deal, and to a person who owns it.

New MRR comes from a customer who wasn’t paying you last month. Deals A, B and C above. This is the line a new-business rep moves.

Expansion MRR is extra monthly money from a customer you already have: more seats, a higher tier, an add-on. Only the difference counts. [Upsell and cross-sell deals](https://salesbond.app/blog/upsell-vs-cross-sell-pipedrive/) both land here. If a customer goes from $1,000 to $1,400 a month, expansion is $400, because the other $1,000 was in the total already.

Contraction is the reverse. The customer stays and pays less, and it’s the easiest line to lose (a downgrade rarely gets a deal of its own, so there’s nothing in the pipeline to count). After a few quiet downgrades the CRM total sits above what billing collects, and nobody can say by how much.

Churned MRR is the full monthly amount of a customer who left, counted in the month the contract actually stops. A customer who cancelled in January and comes back in June is reactivation in Stripe’s list; in a small team its simpler to book it as new MRR and tag the deal “returning”.

How much churn is too much? That depends on your contracts and your market, and this article won’t hand you a benchmark. Track your own line for six months first. Counting lost customers from closed deals is covered in our piece on [customer churn in a B2B CRM](https://salesbond.app/blog/customer-churn-b2b-crm-closed-won/).

## What stays out of MRR

Big deal, small MRR. A $22,000 deal can carry very little recurring money once you strip out setup, implementation, onboarding and migration fees (plus training days, one-off project work and hardware, which go too). A non-refundable deposit stays out unless it’s credited against the monthly fee. A paid pilot with nothing agreed beyond the pilot is plain one-time revenue.

Deal B in the example shows how it goes wrong. Suppose the customer signed for $800 a month and $4,000 of setup, and the rep typed 4,800 into the amount field. The March report would then show $4,800 of “new MRR” from one deal.

Unsure about a line? Ask whether the customer will be invoiced for it again next month (or next year, on an annual plan) without anyone selling it again. A yes puts it in MRR. The $4,000 setup fee fails that test.

## Where each part of MRR lives in a CRM deal

A deal usually comes with one main amount field, and one field can’t hold a monthly figure, a one-time fee and a contract total at once. Whichever CRM you use the MRR table above needs five things on every deal that touches a subscription or retainer:

| Deal field | What it holds | Which MRR line it feeds |
| --- | --- | --- |
| Deal type | New business, expansion, downgrade, renewal | Sorts the deal into new, expansion, contraction or churn |
| Monthly recurring amount | The recurring part, brought to one month | The number itself |
| One-time amount | Setup, training, hardware | None; kept apart so it can’t leak in |
| Billing frequency | Monthly, quarterly, annual | Tells you how to divide (annual ÷ 12) |
| Contract start and end date | When billing starts, when the term ends | The month MRR appears, and the month it’s at risk |

For expansion and downgrade deals the monthly recurring amount holds the change only: +400, −250. That one convention is what lets you sum the column.

Churn needs a deal too. The cleanest way is a renewal deal per customer, opened ahead of the contract end date. Won means the MRR stays (and adds nothing new). Lost means the customer’s monthly amount goes to churned MRR in the the month the contract ends, with a lost reason attached. Without a renewal deal, churn exists only in the billing system, and sales hears about it a quarter later.

Field names and setup differ by CRM. For HubSpot, the steps are in [ARR and MRR on a HubSpot deal amount](https://salesbond.app/blog/hubspot-arr-mrr-deal-amount/); for Pipedrive, see [recurring products vs installments](https://salesbond.app/blog/pipedrive-recurring-products-vs-installments/); for Salesforce, [record types for new vs renewal opportunities](https://salesbond.app/blog/salesforce-record-types-new-vs-renewal-opportunities/).

All of this assumes the fields are filled in and the close dates are honest. You can check that. SalesBond’s free CRM audit reads the last 30 days of your connected CRM and sends a PDF report covering money at risk, deal health, repeat customers and what to fix, and a second PDF arrives seven days later showing what changed. [Check your CRM with SalesBond](https://salesbond.app/).

## MRR vs ARR vs revenue

Three questions, three numbers. They tend to come up in the same meeting. “How big is the recurring base right now?” is MRR, or ARR if your contracts are mostly annual; ARR is the same base multiplied by twelve. What counts toward the annual figure, including multi-year contracts and month-to-month plans, is covered in [annual recurring revenue from CRM deals](https://salesbond.app/blog/annual-recurring-revenue-from-crm-deals-what-counts-owner/).

“What did we sign, and what did we invoice?” Bookings and billings. In the March example the three new deals produced $24,000 of invoices and $3,500 of new MRR. The gap between those terms is laid out in [bookings vs billings vs revenue](https://salesbond.app/blog/bookings-vs-billings-vs-revenue-pipedrive/).

Revenue in the accounting sense belongs to your accountant, and it’s recognized over the period the service is delivered. MRR is a management number that stays out of the financial statements, so expect the two to differ line by line.

If you want a single figure for how well the existing base holds, that’s [gross revenue retention](https://salesbond.app/blog/gross-revenue-retention-pipedrive/), built from the same churned and contraction lines.

## Four common mistakes

### The whole deal amount goes in as MRR

Setup fees and project work ride along, and new MRR looks great in the month of a big implementation. A separate one-time field fixes it. So does a required-field rule on the won stage, if your CRM has one.

### An annual prepayment is booked as one month

$18,000 paid up front is $1,500 of MRR for twelve months. Booked as $18,000 in March, it creates a spike, and then eleven months where the customer seems to have vanished.

### Renewals are counted as new MRR

A customer who renews at the same price adds zero. If renewal deals sit in the same pipeline with the same deal type as new business, every anniversary doubles that customer in the total. Does your new MRR jump in the months when many contracts come up for renewal?

### MRR is dated by the close date

A deal won on March 28 with a contract starting May 1 belongs to May MRR. A cancellation notice in March on a contract that runs to June is June churn. It should still show up as at-risk MRR from the day the notice arrives. Use the contract start and end dates, and you’ll stop restating last month’s number.

## FAQ

### What does MRR mean in digital marketing?

It means monthly recurring revenue there too, the regular monthly income from subscribers or retainer clients. An agency with ten clients on $2,000 retainers has $20,000 of MRR.

### What does $1,000 MRR mean?

It means active contracts bring in $1,000 of recurring revenue every month, which is about $12,000 a year in ARR. Ten customers paying $100 a month get you there.

### How do annual plans count toward MRR?

Divide the recurring part of the contract by the number of months in the term. A $12,000 annual plan is $1,000 of MRR, whether it’s paid up front or quarterly. A three-year contract for $36,000 is also $1,000.

### Do discounts reduce MRR?

A standing discount does. If the list price is $1,000 a month and the contract says $800, MRR is $800, and a later renewal at $1,000 shows up as $200 of expansion. A free first month is a one-time concession; the rate on the invoice in month two is the MRR.

### Does MRR include customers who haven’t paid yet?

MRR follows the active contract, so an overdue invoice doesn’t remove a customer from it. Flag the deal as at risk, chase the payment, and move the amount to churned MRR only when the contract ends or is cancelled.
