MRR calculator
The short answer
This calculator adds the monthly price of subscriptions that are active or past due. Divide an annual price by 12, use the net price when a discount repeats, and leave out trials, taxes, one-off fees, and usage. The formula is customers times the monthly price, with yearly prices divided by 12 first.
How to use it
The fields open on the October example. That ledger is sample data for a fictional product. Type your own counts and prices. The total updates as you type. Reset puts the example back.
Full price, repeating discount, team, and past due are customers times a monthly price. Annual is customers times the yearly price, divided by 12. One-off fees and sales tax sit beside the total. They are not added to it.
The same rows, with the notes column marking them as example data, are in the MRR worksheet (CSV).
The formula
MRR equals the monthly price of every subscription that is active or past due.
A monthly line is customers times the price per month. An annual line is customers times the price per year, divided by 12. A repeating discount uses the net price, not the list price. Past due uses its monthly price and stays in the total.
On the sample fields the sum is 31 × $20 + 5 × $15 + 9 × $240 / 12 + 3 × $50 + 4 × $20 = $1,105. Those counts are sample data.
FAQ
How does this MRR calculator work?
Add the monthly price of every subscription that is active or past due. Divide a yearly price by 12 before you add it. Trials, sales tax, one-off fees, and usage stay out. A past-due subscription stays in until it is canceled or marked unpaid.
Do annual plans count toward MRR?
Yes. Divide the yearly price by 12 and include that amount every month of the term, including months when the card is not charged. Booking the whole year in the month you charge the card is cash, not MRR.
Does a failed payment lower MRR?
Not while the subscription is only past due. The form keeps that monthly price in the total and says it is unpaid. The price leaves MRR when the subscription is canceled or marked unpaid.
Are the starting numbers real?
No. They are the labeled October example from the MRR guide, for a fictional product. On those fields the total is $1,105. Replace every field before you treat the result as yours.