¶ MRR net change report
- Overview
- Filters
- Table columns
- How MRR is calculated
- Why "New − Cancellations" may not equal "Net"
- Important notes
- Data export
- Related pages
¶ Overview
Monthly Recurring Revenue (MRR) is the predictable, recurring revenue your customers contribute every month — the value of their active services and any active discounts, before invoices or one-off charges are taken into account.
To find the report, navigate to Administration → Reports → MRR net change report.
The MRR net change report shows how monthly recurring revenue evolved across a chosen year — month by month, with new business and cancellations broken out so you can see what drove every change.
The MRR net change report answers a single question for an entire calendar year: how did MRR move each month, and why? For each month it shows:
- The MRR you started the month with.
- The new MRR added by services that began inside the month.
- The MRR lost to services that ended inside the month.
- The MRR you ended the month with.
- The resulting net change.
By examining the sources of new revenue and the areas of loss, you can pinpoint trends, evaluate growth, and identify aspects that need attention.
¶ Filters
The report has three filters:
- Year — required; the calendar year you want to analyze. Defaults to the current year.
- Partners — multi-select; restricts the report to customers belonging to the chosen partners. Defaults to All selected. Partner administrators are locked to their own partner and cannot change this filter.
- Locations — multi-select; restricts the report to customers in the chosen locations. Defaults to All selected.
After adjusting the filters, click Show to load the data.
¶ Table columns
The result is a single table with one row per month and the following columns:
| Column | Description |
|---|---|
| Month start | The recurring revenue at the beginning of the month. Marked (Estimated) when the exact date has no snapshot and the nearest available date is used instead. |
| New services (Estimated) | The MRR added during the month by services that started inside the month, prorated to the days each service was actually active. |
| Cancellations (Estimated) | The MRR removed during the month by services that ended inside the month, calculated the same way. |
| Month end | The recurring revenue at the end of the month, after all changes. Marked (Estimated) with the same fallback rule as Month start. |
| Net | Month end minus Month start — the actual change in MRR for the month. |
¶ How MRR is calculated
The report is built from a daily snapshot that Splynx maintains automatically. Once a day, every active customer contributes a single value: their recurring revenue normalized to one day. The report then sums those daily values to produce monthly figures and starting/ending balances.
For each customer, the daily contribution is the sum of every active service — Internet, Voice, Recurring, and Bundle — calculated as:
(quantity × unit price) ÷ billing-period length − discount
The billing-period length is taken from the tariff when the customer is on a prepaid-monthly tariff with a tariff-defined period; otherwise it is the number of days in the calendar month. This converts a monthly recurring price into a per-day value so partial months can be measured.
A service contributes to MRR only when:
- It is active and not deleted.
- It has a unit price.
- The snapshot date falls between the service start and end dates.
A discount is subtracted only when it is enabled, has a value greater than zero, and the snapshot date is inside its active period. Fixed-amount discounts are divided by the same billing-period length; percentage discounts are applied to quantity × unit price and then divided by the period length.
Customers with sub-accounts in Aggregated sub-billing mode are rolled up into the parent account so their MRR is counted once.
¶ Why "New − Cancellations" may not equal "Net"
Net compares the two month boundary snapshots, which include every kind of MRR movement — upgrades, downgrades, quantity changes, discounts starting or ending, and so on. New services and Cancellations only cover services that started or ended inside the month. The gap between them is everything else that moved a customer's MRR up or down during the month.
¶ Important notes
- MRR is recurring revenue, not invoiced revenue. The figure is built from active services and discounts, not from invoices, transactions, or payments. A customer who pays late still contributes MRR; a one-off charge does not.
- Daily snapshot, taken once a day. Numbers for today are typically available only after the daily cron runs. Same-day service or discount changes show up the next day.
- (Estimated) labels mean the exact target date had no snapshot, so the nearest available date was used. This is normal for the future and for dates before MRR collection was first enabled.
- Filters narrow the customer set, not the formula. Selecting partners or locations limits which customers are summed; the calculation rule for each customer's MRR does not change.
- Currency formatting. All money values use the system's currency settings. If Round each finance item is enabled in the system configuration, individual cells are rounded to two decimals; otherwise the report keeps full precision until the totals.
¶ Data export
Use the export button 
in the top-right corner of the table to print, copy, or export the data as Excel, CSV, or PDF. The Excel and CSV options are available with or without currency symbols.
