Forecasting
The Forecast vs Actuals report spreads each project's forecast over the months of a period, next to what actually happened, in revenue or in cost. Use it to see which months will be busy, and whether projects are spending as planned. The forecast comes from your tasks: their estimates and their due dates.
Jump to:
- Run the report
- What the report shows
- Other forecast views
- Print or export
- Example: planning field staff
Run the report
- Open Reporting and click Forecast vs Actuals, under 4. Sales in EVX Software's suggested setup.
- Choose the Start month and End month, each with its month and year.
- Choose Revenue or Cost in Revenue/Cost.
- Choose Group by: none, or Services.
- Click Generate report.
What the report shows
The report has two tables for the months of the period, one row per project, with a Totals row at the top and a Totals column at the end:
- FORECASTED COST: what the tasks estimate for each month.
- ACTUAL COST: what was recorded in each month.
With Revenue, the two tables show revenue instead of cost.
The forecast reads the tasks' estimates and due dates.
Tasks need a due date to count in the forecast. A task without one has no month to fall in. Check the Tasks status widget on the dashboard for tasks without a due date.
Other forecast views
- Cost/Revenue Forecast, also under 4. Sales, gives the estimated cost of labor and expenses by project for a period.
- Forecasted revenue on the dashboard compares earned value with the forecast over time. See Overview and dashboard.
Print or export
Use Print, CSV, PDF, or Excel at the top of the report. See Exports.
Example: planning field staff
In August, an operations manager runs the report from August to December in cost. November shows almost $49,000 of forecasted cost, against less than $8,000 in each month before, with several Phase I assessments due at once. She brings in a contract field technician for November and moves two report deadlines to December.
What you can do next
- Budget control report to compare estimates with what was executed.
- Utilization report to follow each person's billable hours.
- Tasks to set due dates and estimates.