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 team 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 position titles 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 type and position title: the green bar indicating the planned amount(costs or revenues) at specified date, another bar indicating actual amount(red for costs, yellow for revenus). 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 position titles 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 losange in the heading on the right. A green losange indicates a positive variance (planned ≥ actual) and a red losange 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 position titles 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 position titles to be updated accordingly.

Budget Variance report parameters

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