Go Back

Failed Payments Can Cut MRR by 22% a Year: How to Protect It

Published date:

November 12, 2026

Authors

Victoria Stepanova

Victoria Stepanova

Content Specialist

Failed payments compound with every billing cycle: if they add two points to monthly churn, a business with €20,000 of MRR can end the year about €3,000 a month short. This guide shows how to calculate MRR and which payment settings keep it collected.

Subscription pricing is becoming more layered: in Zuora's Revenue Architecture Report 2026, 84% of seat-based SaaS companies also carry some form of usage-based charge. Every added plan, add-on or usage fee makes it easier to overstate monthly recurring revenue or to report cash as income too early. 

‍

This guide explains each formula in plain terms, runs it on a small example business and shows how subscription billing and payment setup decide how much of that revenue you actually collect. The accounting section is a general orientation rather than advice for your specific books.

‍

Key Takeaways

  • MRR is the sum of the monthly value of all active subscriptions: divide annual plans by 12 and leave out setup fees and taxes.
  • Net new MRR shows where growth comes from: new, expansion and reactivation MRR minus contraction and churned MRR.
  • Cash and revenue differ: under IFRS 15, FRS 102 and most national accounting rules, an annual prepayment is recognised month by month, with the rest held as deferred revenue.
  • Failed recurring payments remove MRR you have already won, so split churn into voluntary and involuntary before deciding what to fix.
  • Start with correct renewal flags, network tokens, account updater and rule-based retries, then add backup routing and a dedicated subscription management platform as volume grows.

‍

What Monthly Recurring Revenue Is and Why It Depends on Payments

Recurring revenue is income a business expects to receive at regular intervals because customers keep paying for ongoing access to a product or service. Monthly recurring revenue, or MRR, expresses that stream as one monthly figure, which makes it the working number for budgets, hiring plans and investor conversations. The figure only holds if the charges go through: recurring payments, meaning charges taken automatically on an agreed schedule from a stored card or account, turn into revenue only when the customer is actually debited.

‍

Take 1,000 subscribers paying €20 a month. On paper the business has €20,000 of MRR, but if 4% of renewals fail, 40 charges bounce:

‍

Collected revenue = billed MRR × (1 − failed payment rate)

‍

€20,000 × (1 − 0.04) = €19,200

‍

The missing €800 has nothing to do with pricing or demand, because these customers still want the service and the loss comes from how their payments are processed. That is why revenue planning and payment setup belong in the same conversation.

‍

Recover declined renewals with COLIBRIX ONE →

‍

The Formulas Behind Recurring Revenue

‍

Recurring Revenue Metrics and Formulas

‍

Metric What it tells you
MRR Sum of the monthly value of all active subscriptions Your current monthly run rate
Net new MRR New + expansion + reactivation − contraction − churned MRR Whether the base grew this month and why
ARR MRR × 12 Annual run rate for budgets and valuation
ARPU MRR ÷ number of paying customers What a typical customer pays per month
Customer churn rate Customers lost in the month ÷ customers at the start × 100 Share of customers who left
Revenue churn rate Churned MRR ÷ MRR at the start × 100 Share of revenue that left
NRR (Opening MRR + expansion − contraction − churned MRR) ÷ opening MRR × 100 Whether existing customers grow revenue without new sales
LTV ARPU × gross margin ÷ monthly churn rate Gross profit a typical customer brings over their lifetime
CAC payback Customer acquisition cost ÷ (ARPU × gross margin) Months needed to earn back acquisition spend

‍

In the LTV and CAC payback formulas, enter percentages as decimals: an 80% gross margin is 0.8 and 3% churn is 0.03.

‍

How to Calculate MRR Without Inflating It

‍

MRR = sum of the monthly value of every active subscription

‍

To work out how to calculate MRR, list every active subscription and convert it to a monthly amount: monthly plans count at face value, while annual and quarterly contracts are divided by 12 or 3. Leave out one-off charges such as setup fees, as well as VAT and other taxes, because none of them recur. Take an online tool with 200 customers on a €15 monthly plan and 30 customers on a €144 annual plan:

‍

How to Calculate MRR for Monthly and Annual Plans

‍

Plan Customers Monthly value per customer MRR contribution
Monthly plan at €15 200 €15 €3,000
Annual plan at €144 30 €144 ÷ 12 = €12 €360
Total 230 €3,360

‍

Free trials stay out of MRR until the first paid charge. Decide in advance how long a customer with a failed payment stays in MRR before you count them as churned, and apply that rule every month.

‍

Tracking Where MRR Comes From and Where It Goes

‍

Net new MRR = new MRR + expansion MRR + reactivation MRR − contraction MRR − churned MRR; closing MRR = opening MRR + net new MRR

‍

A single MRR figure hides movement, so split it into five components: new MRR from first-time subscribers, expansion MRR from upgrades and add-ons, reactivation MRR from former customers who return, contraction MRR lost through downgrades and churned MRR lost to cancellations. Each line is the number of customers multiplied by the monthly amount that changed.

‍

Net New MRR for One Month

‍

Movement Example for the month Amount
New MRR 40 new subscribers × €15 +€600
Expansion MRR 6 customers × €20 add-on +€120
Contraction MRR 5 customers × (€15 − €6) −€45
Churned MRR 4 subscribers × €15 −€60
Reactivation MRR 3 returning subscribers × €15 +€45
Net new MRR 600 + 120 − 45 − 60 + 45 +€660
Closing MRR €3,360 + €660 €4,020

‍

Under IFRS 15, the international standard for revenue from customer contracts, revenue recognition follows the delivery of the service, and a subscription is delivered month by month. FRS 102 revenue recognition, which applies to UK and Irish companies that do not use IFRS, follows a comparable model for periods beginning on or after 1 January 2026, as the FRC explains, while smaller companies elsewhere often report under national accounting rules, which generally spread prepaid subscription income across the months of service in the same way.

‍

Two situations come up often in SaaS revenue recognition:

‍

  • Mid-month upgrades (proration). Amount charged today = (new monthly price − old monthly price) × share of the month remaining. A customer moving from a €10 plan to a €30 plan on day 16 of a 30-day month pays (€30 − €10) × 15/30 = €10 that day, and MRR rises by €20.
  • Refunds on annual plans. Refund = monthly value × unused months. Cancelling a €120 annual plan after three months returns €10 × 9 = €90, keeps €30 as recognised revenue and clears the deferred balance.

‍

These examples describe general principles only, so agree your recognition policy and edge cases with your accountant or auditor before applying them.

‍

Billing Models Change How Predictable MRR Is

Fixed subscriptions charge the same amount every period, which makes MRR easy to forecast. Per-seat pricing scales with the number of users, so MRR moves whenever a client adds or removes staff. Usage-based pricing charges for consumption, which lets revenue grow quickly but makes it harder to predict: many teams count only the committed monthly fee in MRR and report usage separately, while others use a trailing three-month average, and either approach works if applied consistently.

‍

Many SaaS billing operations blend these models, and the mix tends to lift revenue per customer: in Zuora's 2026 report, companies with four or more revenue models grew average revenue per account by 2.2% year on year, while single-model companies saw it fall by 2.3%. For a young business, the practical lesson is to add usage fees or add-ons only once your subscription billing platform can calculate them automatically, and to write subscription billing rules for upgrades, downgrades and cancellations before the first customer asks.

‍

Billing Cycles and the Charge Date

Monthly billing charges customers on a repeating date, while annual and quarterly cycles collect larger amounts less often and bring cash in upfront. Billing on each customer's signup anniversary spreads payment volume across the month, whereas billing everyone on the first of the month simplifies reporting but concentrates volume and failed payments into a single day. Choose one rule, document it and set it in your recurring billing software, then keep it consistent with how you report MRR.

‍

Where Recurring Revenue Leaks and How to Protect Unit Economics

Subscription income leaks through a few familiar points: cards expire or get reissued, banks issue temporary (soft) declines, customers hit insufficient funds, a single processor becomes a point of failure, cross-border charges attract extra issuer scrutiny, chargebacks reverse collected revenue and trial abuse inflates acquisition costs. Recurring card payments also start at a disadvantage because renewals are card-not-present: Visa's European network data for 2024 shows authorisation rates up to 6% lower for card-not-present transactions than for in-store ones.

‍

Those losses compound through unit economics. The table compares a subscription with €20 ARPU, an 80% gross margin (€16 of gross profit per customer each month) and €300 acquisition cost at 3% and 5% monthly churn, assuming the extra two points come from failed payments.

‍

How Two Extra Points of Churn Change Unit Economics

‍

Metric At 3% monthly churn At 5% monthly churn
LTV ARPU × gross margin ÷ churn €20 × 0.8 ÷ 0.03 ≈ €533 €20 × 0.8 ÷ 0.05 = €320
Average customer lifetime 1 ÷ churn ≈ 33 months 20 months
CAC payback €300 ÷ €16 ≈ 19 months ≈ 19 months
Months of profit after payback Lifetime − payback ≈ 14 months ≈ 1 month

‍

Two extra points of involuntary churn cut LTV by 40% and leave almost no time to earn a profit once acquisition cost is recovered. Unlike voluntary churn, this loss can be reduced at the payment layer, starting with steps that suit a business of any size.

‍

Set Up From the First Subscription

  1. Authenticate the first payment and flag renewals correctly. The first payment that sets up a subscription needs strong customer authentication, while later charges the merchant initiates under that mandate do not, as the EBA confirms. Ask your payment provider to mark renewals as merchant-initiated transactions using the stored card, so issuers recognise them and decline fewer.
  2. Use network tokens and account updater services. A network token replaces the card number with a credential that the card scheme keeps current, and Visa reports up to 5% higher authorisation rates for tokens than for raw card numbers. Visa Account Updater and Mastercard ABU refresh expired or reissued card details before the next charge, and both are usually switched on through your acquirer.
  3. Retry within the card scheme rules. Space retries around likely paydays rather than repeating the charge the same day, and never retry a decline the issuer marks as final: Visa allows up to 15 retries within 30 days only for declines the issuer cannot approve at that moment.
  4. Warn customers before the charge. A reminder before a card expires or an annual plan renews lets customers update details in time and reduces disputes from people who forgot they subscribed.
  5. Read decline codes every month. Grouping failures by reason shows where the fix belongs: insufficient funds points to charge timing, expired cards to account updater coverage and generic declines to routing or issuer risk rules.

‍

Get more renewals approved with COLIBRIX ONE →

‍

Add as Volume Grows

  1. Add a backup acquiring route. A second acquirer gives an eligible soft decline another chance, which pays off once failed volume is large enough to justify a second integration.
  2. Offer more ways to pay. Wallets and local payment methods give customers an alternative when a card keeps failing, provided each method supports recurring charges.
  3. Keep card data and billing logic portable. A card vault independent of any single processor and dedicated subscription management software above the payment layer let you change or add providers without asking subscribers to re-enter their cards or rebuilding plans, trials and proration.

‍

How COLIBRIX ONE Helps You Collect the MRR You Calculate

COLIBRIX ONE works as a subscription payment gateway and card acquirer for digital businesses. As a principal member of Visa and Mastercard, it handles subscription payment processing through one payment API for fixed, per-seat and usage-based billing across the UK, Europe and the US, with cards, Apple Pay, Google Pay, open banking and PayPal at checkout and plugins for WooCommerce, PrestaShop, OpenCart and Magento. Compliance verification is completed within 48 hours and a personal account manager supports you from the first transaction, so questions about renewals, decline codes or new markets go to a person who knows your business.

‍

Enable recurring payments with COLIBRIX ONE →

‍

As your subscription base grows, recovery and billing tools come through partners already integrated with COLIBRIX ONE acquiring.

  • Primer adds processor-independent card vaulting, dunning, smart routing and automatic fallback to a backup processor without customers re-entering card details.
  • Yuno, a subscription management tool, lets you accept subscription payments from more than 130 countries and moves subscription management (trials, retries, card updating and analytics) into a dedicated layer while COLIBRIX ONE remains your acquirer.

FAQ

Is MRR the same as revenue?

MRR is an operating metric that estimates the monthly value of active subscriptions, while recognised revenue is an accounting figure governed by IFRS 15, FRS 102 or national accounting standards. The two differ whenever annual prepayments, refunds or one-off fees are involved, so use MRR for management decisions and recognised revenue for statutory reporting.

Is deferred revenue a liability?

Yes. Money collected before the service is delivered represents an obligation to the customer, so it sits on the balance sheet as a contract liability. It moves into income gradually as each period of service is provided, which is why a €120 annual payment adds only €10 to January revenue.

How do you calculate MRR for annual plans?

Divide the annual subscription value by twelve and add the result to MRR. Thirty customers paying €144 a year contribute €360 of MRR, because each plan is worth €12 per month. Exclude setup fees and taxes and apply the same method to quarterly plans by dividing by three.

What is a good SaaS churn rate?

No single benchmark fits every business, because enterprise contracts and consumer apps behave very differently. Track your own trend over time, separate voluntary cancellations from payment-driven losses and judge progress by whether both are falling. A low headline figure can still hide expensive involuntary churn if failed payments are never analysed.

What should a subscription payment gateway support?

Look for stored-credential and merchant-initiated transaction handling, network tokens, account updater services, wallets and local methods alongside cards and clear decline reporting. Support for your billing models and access to recovery tooling through partners matter just as much, because recurring revenue depends on renewals succeeding month after month.

Authors

Victoria Stepanova

Victoria Stepanova

Content Specialist