Matrix for Media

Monarch - Budget Report Overview

The Budget Report provides an easy way for you to see if you, your team, or your entire enterprise are on track to make budget for a given time frame and, if not, what it will take to get there.

To create the Budget Report, please follow the below instructions:

  1. Please navigate to Reports on the menu bar.
  2. Click the Revenue tab.
  3. Click Budget 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 select the time frame of the report
  4. Budget Type Selection - In this drop-down you may select the budget type, Top Down or Bottom Up, you wish to see
  5. Metrics Selection - Choose which metrics you would like to view in the report
  6. Include a Projection alongside your Forecast - Select Yes to view your Projections in the report
  7. Include a Pitched Projects as part of my forecast - Select Yes to view your Pitched total from your Project in the report
  8. 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. Page Navigation - utilize the arrows or the box with the page number to move around to multiple pages of the report
  7. Report Data - the table at the bottom of the screen is the data from the report. The Budget Report is formatted so that the hierarchy is on the far left, followed by the following columns:
    1. Billed LY - The amount of dollars booked 1 year prior to the time frame selected
    2. Billed TY - The amount of dollars booked for the time frame selected
    3. Budget - The amount of dollars budgeted for the selected Budget Type (Bottom-Up or Top-Down) in the time frame selected
    4. Forecast - Calculation of ((Billed TY) + (Pending))   Note that pending is not visible on this report
    5. $ Diff TY/Budget - Calculation of ((Billed TY) – (Budget))
    6. % Diff TY/Budget - Calculation of ((Billed TY) / (Budget)-1)
    7. $ Diff Forecast/Budget - Calculation of ((Forecast) – (Budget))
    8. % Diff Forecast/Budget - Calculation of ((Forecast) / (Budget)-1)
    9. NEW CALCULATION $ Diff TY-LY Calculation ((Billed TY) – (Billed LY)) 
    10. NEW CALCULATION % Diff TY/LY Calculation ((Billed TY) / (Billed LY))

Did you find it helpful? Yes No