Document toolboxDocument toolbox

This article is for Budgets for Data Center.

Budget Variance Report

The Budget Variance report presents the planned costs versus actual costs variance OR planned revenues versus actual revenues variance at a given date, broke down by the staff members roles and expense types you defined.  To access this report, click on the Report tab or hit the tab number ('5') and then click on the 'View report' button next to the Budget Variance report preview. This will bring up the report with today's date and all expense types and roles selected as default.  The report will be automatically refreshed when one of its parameters changes.

The report first presents a bar chart showing two bars for each selected expense types and roles: the green bar indicating the planned amount(costs or revenues) at specified date, another bar indicating actual amount(red for costs, yellow for revenues). Hovering the bars will open a tooltip showing the precise amounts.  The labels on y-axis can be clicked to navigate to the detailed expense information for that expense type.

 

Costs Variance

Revenues Variance

 

Detailed information for all expense (or revenue) types and roles follow the chart.  Each of these sections shows the list of expenses (or revenues), ordered alphabetically and grouped by category (OPEX, CAPEX or FINEX). The variance appears in a lozenge in the heading on the right.  A green lozenge indicates a positive variance (planned ≥ actual) and a red lozenge indicates negative variance.

Detailed budget heading variance section

Configuring the report

You can display budget variance for costs or budget variance for revenues simply select Costs or Revenues option form the 'For' field.

To change the date for which to get the variance, simply change the date in the 'Date' field.  The expenses considered are the ones occurring between the start date of the folio and the one specified in the date field.  The user can also limit the expenses (or revenues) considered to a certain number of types and/or roles or even for a specific label.  Simply select/deselect the types you are interested in and the report will be instantly refreshed to reflect the new selection.  Selecting or deselecting a category will cause the list of available types and roles to be updated accordingly.

 

 

Budget Variance report parameters

 

For

This parameter allows you to produce EVM report based on Costs or Revenues

From

Start of the time frame for that report.
Note that clicking on folio start link set the report start date to folio start date.
Also note that if the report start date is before folio start date, only expenses with a incurred date equal to or after folio start date will be taken into account.

To

End of the time frame for that report.

 Notes:

  • Clicking on folio end link to set the report end date to folio end date.

  • There is no end date limitation as for start date, therefore expenses incurred after today are future known cost

  • Unassigned positions in folios are not include in the expenses report.

Account

This allows you to display amounts of all expenses/revenues and worklogs of issues link to the selected account.

Label

This allows you to display amounts for the selected Jira Issue Label. (not available at the portfolio level)
Note : see Using Labels   for more info on.

Custom fields

All custom fields of the type SELECT and TEXT will be added as parameters. The options will be based on the values used by the folio items.

This allows you to display amounts for the selected custom field values.

Categories

Categories to be included in the report

Roles

Roles to be included in the report

Types

Expense or revenue types to be included in the report

 

Printing the report

Selecting the "Printable" item in the report's action menu found at the top right of the report's parameters panel to get a printer-friendly version of the report.

 

Printable version of the report

Exporting to Excel

The Budget Variance report can be exported to Excel format to give you all the latitude you need to further digest, analyze or graph the data. Do it by selecting the "Export to Excel" item in the report's action menu found at the top right of the report's parameters panel. The parameters that were used to generate the report can be found on the second tab of the generated spreadsheet

 

 

 

 

Â