In this article

SBS ARCB MRR Report

You can use this report to project recurring revenue - monthly customer charges (excluding any one time, weekly, daily, miscellaneous charges). Recurring revenue is calculated using new contracts, renewals, cancellations, and any changes to existing contracts.

Also, you can print the report for all the contracts or restrict the report to certain contracts or certain customers.

Notes: :

  • Schedules with one-time, weekly, daily, and miscellaneous billing frequencies are excluded from the report.
  • Monthly revenue of schedules with a billing frequency other than monthly is prorated on the report (for example, divided by 3 for quarterly billing), regardless if ARED is used and an item is deferrable or not.
  • Meter items are included, but you must manually enter the expected revenue amount to the schedules.
  • Price adjustments and discounts are shown in within the upgrade or downgrade amount (the difference in price).
  • Holds are shown within the upgrade or downgrade amount.
    • When the hold is applied, the amount is negative. When the hold is removed, the amount is positive.
  • A terminated line is shown as if a line is ended, within the Churn amount.
  • If a line is terminated with the Bill Remaining option, the remaining billing amount is shown within the upgrade or downgrade amount.
    Notes: In the following month, the Bill Remaining amount should be removed from the MRR by displaying the negative value within the upgrade or downgrade amount.

For example:

A 100.00 line is terminated in April, and the remaining 500.00 is billed in May. The report shows the following:

Monthly Recurring Revenue Table
Churn (May) 100.00 (loss revenue)
Upgrade or Downgrade (April) 500.00 (revenue as remaining unbilled amount)
Upgrade or Downgrade (May) -500.00 (no more 500.00 charges after May)
  • If a billing line is not aligned to the calendar month, it is included in the month in which the billing start date begins. For example, billing line 2015-01-15 to 2015-02-14 is included in Jan 2015.
  • The amounts shown in this report are the average in each reporting period.

Generate Report

To generate a report, follow these steps: 

  1. Specify the date range for the report.
  2. Specify the filters you want and select how you want to view the generated report: 
    • Select Preview & Close to view the report on your screen.
    • Select Print to select the destination for the report.

The report shows the following information: 

Monthly Recurring Revenue Table
Column Name Description
Beginning MRR Calculated as the previous month Ending MRR (for example, Beginning MRR for Feb = Ending MRR for Jan).
New Sale Total of all new recurring lines started in this reporting period.
Renewals Total of all renewal amounts in this reporting period.
Churn Total of all billing amounts that will not continue (appears as a negative amount).
Ending MRR

Calculated as follows: 

Beginning MRR + New sales + Renewals + Upgrades/Downgrades - Churn

 

Options

This FastTab allows to you specify the date range for which you want to run the report.

Header Filters

The following default filters are readily available for the report. Add more filters as needed.

  • Billing schedule number
  • Sell-to customer number
  • Location code
  • End user number

Buttons

This page contains the following buttons: 

Report Buttons Table
Button Description
Send to

Generates the report or preview and sends it to the destination that you select.

Print Generates the report and prints it to the Selected Printer.
Preview & Close

Generates the report or preview and displays it on your screen.

Cancel

Cancels all changes and closes the page.