Project Progress

Group

Project

Description

Compare actual costs and profit figures to budgeted costs and profit figures for multiple projects

Business Purpose

Ensure projects are running to budget and making the required profit

Ideal For

Project Manager

Director

Filter Name

Selection

Criteria

Expense Types

Type of Expenses to include.

Entered in Expense entry

Defined in Admin > Company Settings > Expense Types

Approval Status

Whether to include draft, submitted, approved or rejected time and costs

Time and Disbursements

Whether to include time costs, expenses costs, or both

All logged time and expenses

Include Extra Time

Whether to include non-core hours

Time entered in Core section of timesheet is included.

Time entered in the Extra time section can optionally be excluded

Cut Off Date

The date used to determine the cut-off between historic and future data for Current figures (Please note forecast data is not relevant to Small Practice Edition users.)

Current values are the sum of actual data up to the cut-off date and forecast data after the cut-off date.

Weight budgets by

Choose to display a percentage of the budget figures equal to the percentage complete, or the percentage of time consumed, or the full amounts. This enables you to see what the costs and profits should be to date.

Percentage complete and task start and end dates are entered via Projects > Gantt or Project > Work Structure* or Project > Resources*.

Show Actual / Forecast

Whether to include actual, forecast or all time and costs (Please note forecast data is not relevant to Small Practice Edition users.)

If ‘Weight budgets by’ is set to time consumed or percentage complete, it is advisable to only show Actual data. This way you are comparing the amount of budget that should have been used to date with the actual totals to date.

Warn Variance greater than %

Specify the percentage variance threshold of Current figures to Budget figures, above which Current figures will be coloured  red

Warn Variance less than %

Specify the percentage variance threshold of Current figures to Budget figures, below which Current figures will be coloured  green

Group by (Filter available in report window)

Group and total report values by Status, Project Type, Department, Industry Sector, Project Owner, Project Manager, Client or no grouping

Project fields are set in project summary. Industry Sector is set in Contacts > Clients > Details.

Field Name

Description

Criteria

Project code

Project code

Entered into the Project > Summary

Project name

Project name

Entered into the Project > Summary

Task

Project task name

Entered in the Project > Work Structure or Project > Gantt

Budget Fee

The total budget fee

The total budgeted fee.

Set in the Project > Fee Allocation or Project > Estimate page.

(Can be weighted using ‘Weight budgets by’ filter)

Current Fee

Total fee

Actual sent and paid invoices and / or forecast invoices from invoice rules

Budget Cost

The total budget cost

The budgeted cost of time and expenses.

Set in the Project > Fee Allocation or Project > Estimate page.

(Can be weighted using ‘Weight budgets by’ filter)

Current Cost

Total cost of time and expenses logged to date

Includes all time, expenses and purchases invoices

Budget Profit

The total budget profit

Budget  Fee – Budget Costs

Current Profit

The profit so far

Current Fee – Current Costs

Budget Margin

The budget profit margin

(Budget Fee – Budget Costs) / Budget Fee

Current Margin

The profit margin so far

(Current Fee – Current Costs) / Current Fee

Percent Complete /Time Consumed

An indication of the progress on each task

If the Weight by filter is set to ‘Percent Complete’ or ‘None’ the percent complete (set in Projects > Work Structure or Gantt) will be shown.

If the Weight by filter is set to ‘Time consumed’ the percentage of planned calendar days will be shown.