Create an Executive Summary

Summarize the key elements of your business for stakeholders

The Executive Summary defaults to display a summary graph, cash metrics, an Income Statement summary and Headcount by Department. This default data shows YTD Actuals for the Current Year by month. You may also wish to display additional key metrics for your business in addition to the cash position, for example, the roll forward of annual recurring revenue (ARR)*. Additionally, you may wish to display data from a different Source or time period.

To update the Executive Summary report to display these additional metrics for the current plan by quarter, follow the steps below. 

1. Select the Executive Summary Report type
2. Select Edit Columns
   
3. Check Show Notes
4. Adjust the Source to the current plan, e.g., 2024 Rolling Fcst
5. Verify the Date Range is set to the time frame you'd like to report on, e.g., This Year
6. Adjust the Report Columns to show the granularity you'd like to see for your analysis, e.g., Quarters & Total
   
   
7. Select Apply - the Report should now show data for the plan by Quarter
8. Select Edit Rows
   
   
   
9. Select + Add Section
   
10. Add a Section called Cash and select + Add Line to add Cash Balance (Category: KPI Library, Group: Cash, KPI: Cash on Hand) and Change in Cash (Category: KPI Library, Group: Cash, KPI: Change in Cash) lines coming from Jirav KPI Library
    
    
11. Select + Add Section
    
12. Name the Section ARR Rollforward
    
13. Select + New Line in the ARR Rollforward section
    
14. Name the new line ARR Rollforward
    
15. Edit the Series by selecting IS - Revenue - All - All under to open the UA Picker, select ARR Rollforward from the SaaS Metrics Custom Table, set the Depth to Children up to 1st Level and the Subtotal to Hide and Save
    
16. Select Apply
17. Show or Hide the Executive Summary's Chart by clicking on the three dots next to the Executive Summary Title
    
    
18. Customize the Executive Summary's Chart Period by clicking on the three dots next to the Overview
    
    
19. Save Changes

After completing these steps, you should see the data for the plan by Quarter and the ARR Rollforward highlighted at the top of the report under the Cash section. 

*Assumes that MRR & ARR Forecast has been completed.