Project financials - budget control report
Screen reference
This report provides a detailed overview of the estimated and executed financial performance of projects. It allows users to analyze contract amounts, costs, prices, hours, and profits for each project or task. The report can be grouped by client or project and helps to identify profitability and budget execution status.
Filters
How Filters work in the Budget Control Report
| Filter | Description |
|---|---|
| Group by | Defines the main grouping level of the report. Options: *Project type, Project manager, *Client, Contract phase, Rate schedule, Billing client. |
| Aggregate information by | Defines how the information is aggregated within each group. Options: Task, Job task. |
| Display profit details | Checkbox. When selected, the report will add two new columns at the end: Estimated Profit and Executed Profit. These show the difference between price and cost. |
| Exclude tasks with empty values | Checkbox. When selected, tasks with no numeric values in cost, price, or hours will be excluded from the report. |
| Generate report | Button that runs the report based on the selected filters. |
Columns retrieved
Explanation of which information each column of the report includes.
| Column Name | Calculation & Logic |
|---|---|
| Project number | The automatically generated project code. |
| Project name | The name of the project. |
| Project managers | The assigned project manager(s). |
| Contract stages | Current contract stage. |
| Contract amount | The total contract value. |
| Task | Task name (visible when aggregation includes tasks). |
| Estimated hours | Total number of planned hours for the project or task. |
| Worked hours | Total number of actual worked hours recorded. |
| Remaining hours | Estimated hours - Worked hours |
| Estimated cost | Planned total cost. |
| Executed cost | Actual cost recorded (based on worked hours and rates). |
| Remaining cost | Estimated cost - Executed cost |
| Estimated price | Planned total price or revenue. |
| Executed price | Actual executed price (earned value). |
| Remaining price | Estimated price - Executed price |
| Estimated profit | Estimated price - Estimated cost. Visible only if Display profit details is selected. |
| Executed profit | Executed price - Executed cost. Visible only if Display profit details is selected. |
Calculations and logic details
- Remaining hours = Estimated hours - Worked hours
- Remaining cost = Estimated cost - Executed cost
- Remaining price = Estimated price - Executed price
- Estimated profit = Estimated price - Estimated cost
- Executed profit = Executed price - Executed cost
If the result of a profit calculation is negative, it will be displayed in red to indicate a loss.
Export options
The report can be exported using the buttons available at the top-right corner:
- Print: Opens a printable version of the report.
- CSV: Exports the data as a CSV file.
- PDF: Generates a PDF version of the report.
- Excel: Exports the data to Excel format.
Example
When the Display profit details option is selected, the report will include two additional columns at the end: Estimated Profit and Executed Profit, which show the profitability for each project, client, etc.
When the Exclude tasks with empty values option is selected, any task with no financial or hour data will be excluded from the output.