Budget Variance Report

Click to View Video Tutorial

The Budget Variance Report is an incredibly powerful tool that allows deep understanding of the financial performance of Projects and Members. With this report, original estimates can be compared with actual spending. This information is presented in a clear and concise format, which helps quickly identify any discrepancies and take corrective action. All filters and selected Projects in this report are automatically saved for future use.

The Budget Variance Report can be viewed by Members or Projects.

• Projects Selector: Use this button to select the Projects you would like to view.

• View button: Select to view spent budget vs different budget amounts (Project Fee, Project Budget, etc.).

• No Variance: Located next to the filter button, this button hides or shows Projects with no variance.

  

Next to the Report title, the number of filtered Projects is displayed alongside the total count.

For the Planned Time view, the option to view different time periods is available by selecting the All Time button.

On this page, the "Planned Time" and "Spent Time" values show data from past dates only. This is different from the "Planned Time" displayed in the "Time" tab, which includes future planned hours. To see all time periods, including future planned hours, you can use the "Custom Date" option.

View and Modify Project Details

Click on the three dots of a Project. You can go to the Project in a new tab, view Project budget, edit Project information, set Project color, manage Project members and edit Phases in this Project.

Filter

Filtering capabilities allow for quick refinement of both Members and Projects, making it easy to drill down into the necessary data. Projects can be filtered by Billable, People, Phase, and Phase reference numbers, depending on the selected view.

View More Details

A Project can be expanded to display the budget variance breakdown of its Phases and Subphases. A Phase can be expanded to display the breakdown of its Work Categories and Members.

Member View

When viewing the report by Members, the displayed Members can be selected by using the Members selector. A Member can be expanded to display a breakdown of the Projects and Phases that that Member belongs to.

Click on "Members" if you would like to view this report by member rather than by project. Select the Members you want to view on the tab by clicking Members button on the top.

Filter the list of Members by clicking on the Filter button on the top.

The Role filter considers only the member's Default Role, which are listed on Org settings > Members > All Members tab. For example, if a member has "Editor" as their default role and "Viewer" as a non-default role, the role filter will only show them if "Editor" is selected in the filter options.

Click All Members to group Members by Departments, Disciplines, Offices, Portfolios, Roles, Regions, Skills.

Private Projects

Budget Managers with the following permissions:

• Budget Manager > Can Edit > Projects they are a Member of

• Budget Manager > Can Edit > Projects they are a Project Manager

can only view Projects they have access to (either as a Member or as a Project Manager).

Projects without access permissions will be consolidated into a single row labeled "Private Projects" with the total count displayed. Planned and Spent bars, as well as numerical values, will not be displayed for this row.