Skip to content
TextArray1.87.0
100% local

MRR and ARR calculator

Turn a list of subscriptions into MRR, ARR and a per-customer revenue breakdown.

Input
Output
Related tools
Sum numbersNumbers
Invoice calculatornewNumbers
Sum and number statisticsNumbers
Birth number validatorNumbers
Inline math evaluatorNumbers
Percent calculatorNumbers
MRR and ARR calculator
Paste a list of subscriptions, one per line, as customer;amount;period — monthly, quarterly or yearly — and this tool normalizes every line to monthly recurring revenue, then adds it all up. The result shows MRR (monthly recurring revenue), ARR (annual recurring revenue), the number of paying customers, average revenue per customer, and a breakdown of revenue by billing period and by plan. It's built for the moment a spreadsheet export needs a quick sanity check without setting up a formula.
Each line can carry more than the basics. Add a license count to bill per seat (customer;price;monthly;5), a discount percentage to model a negotiated rate, a plan name to see revenue split by tier, and a currency code alongside the exchange rate option to blend foreign-currency deals into one total. Turn on "Amounts include VAT" when your export lists gross prices, so the reported revenue is net. A period of "onetime" (or "once") marks a line as non-recurring — it's totaled separately and never inflates MRR or ARR. Sorting by revenue and marking the top N customers makes it easy to spot who is actually driving the number.
Lines that don't parse — a typo in the period, a missing amount — are skipped and counted rather than stopping the whole calculation, so one bad row in a large export doesn't block the rest. Windows and Unix line endings both work, and the live tally under the output tracks customer count, MRR and ARR as you type.
Everything runs locally in your browser: revenue figures never leave your device, which matters for a metric this sensitive. Switch between a plain-text report and a pipe-delimited table, copy the result, download it as a .txt file, or send it straight into another tool to keep working.
FAQ
What format does each line need?
customer;amount;period at minimum, e.g. "Acme Inc;49;monthly". You can add up to four more optional fields, in order: licenses, discount percent, plan name, and currency code — leave any of them blank to use its default.
How are quarterly and yearly amounts converted to MRR?
A quarterly amount is divided by 3 and a yearly amount by 12 before it is added to MRR, so every line contributes its true monthly value regardless of how it was billed.
How does currency conversion work?
Set the base currency and an exchange rate; any line whose currency field differs from the base is multiplied by that single rate. It supports one shared rate for all foreign lines, not a separate rate per currency pair.
What happens to one-time charges?
A line marked "onetime" (or "once") is totaled on its own and shown separately — it never counts toward MRR or ARR. Turn on "Exclude one-time items" to drop those lines from the output entirely.
Is my revenue data uploaded anywhere?
No. The calculation runs entirely in your browser — your subscription list and revenue figures never leave your device.