Monarch - Revenue Summary Report Overview

The Revenue Summary Report provides a way for you to see how you, your team, or your entire enterprise are offsetting Lost dollars with New and Returning business in order to continue growing.

To create the Revenue Summary Report, please follow the below instructions:

1. Please navigate to Reports on the menu bar.
2. Click the Revenue tab.
3. Click Revenue Summary Report link.

On the Options screen, you will be presented with the below options to build your report.

1. Hierarchy Selection - in this drop-down you may select the attribute(s) that are to be on the report
2. Calendar Selection - in this drop-down you may select what calendar type the report will utilize
3. For Time Frame Selection - in this drop-down you may pick the time frame for the results of the report
4. Roll Up Results By Selection - in this drop-down you may select the way that the results are reported in a lump sum or by month
5. Run Button - once all options have been selected, clicking the Run button will run the report

Clicking the Filters tab will allow you to select or not select various data points or groups within the report.

Once the report is run, the screen will display the report based on the Options and Filters selected. A view like the below will appear.

1. Show Option - clicking this button will show the Options and Filters dialog to edit the report and allow you to re-run the report
2. Hide Chart - clicking this button will remove the chart from the view
3. Chart Field - the report will display a line chart showing the trending over the time frame that was selected
4. Favorite Icon - clicking the Star icon will allow you to save the report has a favorite. Once saved as a favorite, the report can be shared to other users
5. Download - in the drop-down a user can select to export the data in either a .csv format or Microsoft Excel format. Clicking the icon next to the drop down will download the report in the selected format
6. Report Data - the table at the bottom of the screen is the data from the report. The Revenue Summary Report is formatted so that the hierarchy is on the far left, followed by a columns for:
   1. $ Lost - Booked dollars that were spending with you 1 year prior to the time frame selected but are no longer spending on the same Outlet(s) in the time frame selected
   2. Billed LY - The amount of dollars booked 1 year prior to the time frame selected
   3. LY $ Returning - Booked dollars that spent with you 2 years prior to the time frame selected and are also spending with you again 1 year prior to the time frame selected on the same Outlet(s)
   4. Billed TY - The amount of dollars booked for the time frame selected
   5. TY $ Returning - Booked dollars that spent with you 1 year prior to the time frame selected and are also spending with you again during the time frame selected on the same Outlet(s)
   6. $ Var Returning - Calculation of ((TY $ Returning) – (LY $ Returning))
   7. %$ Var Returning - Calculation of ((TY $ Returning) / (LY $ Returning)-1)
   8. $ New by Definition - Booked dollars that are new to the time period based upon the Matrix New Business Definition
   9. %$ New by Definition - Calculation of (($ New by Definition) / (Billed TY))
   10. $ Brand New - Booked dollars that have never spent with you before on any Outlet
   11. %$ Brand New - Calculation of (($ Brand New) / (Billed TY))
   12. $ New to Period - Booked dollars that are new to the selected time frame, but may have spent with you in other time periods before
   13. %$ New to Period -  Calculation of (($ New to Period) / (Billed TY))