Budget control report
The Budget control report puts what each project was estimated to take next to what it has taken so far: hours, cost, and price, task by task. Run it to see which projects are spending faster than planned, and which tasks are behind it. It reads the estimates on your tasks and the time and expenses your team records against them.
Anyone with access to the Reporting tab can run it. It shows only the projects you have permissions for.
The report compares estimated and executed figures for each task.
Jump to:
Run the report
- Open the Reporting tab and click Project financials - Budget Control. In EVX Software's suggested setup, it is under Other reports; your firm may have moved or renamed it.
- Choose the filters.
- Click Generate report.
Group by and Display profit details change the output before you generate it.
Filters
| Filter | What it does |
|---|---|
| Group by | Groups the projects: None, Project Type, Client, Contract Stages, Rate Schedules, Locations, or Billing client. |
| Aggregate information by | Lists each project's rows by Task or by Job phases. |
| Display profit details | Adds two columns at the end, Estimated profit and Executed profit. |
| Exclude tasks with empty values | Leaves out tasks with no hours, cost, or price. |
Columns
| Column | What it shows |
|---|---|
| Project Number, Project Name | The project. |
| Contract stages | Where the project stands commercially. |
| Contract Amount | The project's contract amount. |
| Task | The task or job phase, depending on Aggregate information by. |
| Estimated Hours, Worked Hours | The hours estimated on the task, and the hours recorded on it. |
| Remaining Hours | The estimated hours not worked yet. |
| Overrun Hours | The hours worked beyond the estimate. |
| Estimated Cost, Executed Cost, Remaining Cost | The cost estimated, the cost of the time and expenses recorded, and what is left of the estimate. |
| Estimated Price, Executed Price, Remaining Price | The price estimated, the value of the work done so far, and what is left of the estimate. |
| Estimated profit, Executed profit | The price less the cost, estimated and executed. Shown with Display profit details. A loss shows in red. |
The first row of each project adds up its tasks.
Print or export
Use Print, CSV, PDF, or Excel at the top of the report. Close goes back to the filters. See Exports.
Example: a monthly budget review
Before the monthly review, a principal groups the report by Contract Stages and turns on Display profit details. Under Active, a parking expansion shows overrun hours on its draft report task and an executed cost close to its estimate, with the fieldwork still to come. She brings the project to the meeting with the task that needs a change order.
What you can do next
- Project budget by task report for one project in detail.
- Budget status report for a project's budget, invoices, and what remains.
- Prebuilt reports for the other ready-made reports.