Revenue vs Target

Group

Finance

Description

Compare actual and forecast revenue to target

Business Purpose

Monitor historic (actual) revenue and forecast future revenue at individual project or task level or across the whole practice

Ideal For

Project Manager, Director, Financial Administrator

Filter Name

Selection

Criteria

Monthly Start Date

Beginning of the month to start data selection from

Earliest date from which revenue will be included

Monthly End Date

End of the month to finish data selection from

Latest date from which revenue will be included

Monthly Cut-off Date

The date used to determine the cut-off between historic revenue and future revenue

Data displayed up to the cut-off date will be actual and data after the cut-off date will be forecast

Factor Project Probability

Yes or No

Determines whether to factor in project probability percentage from project summary

Factor Task Probability

Yes or No

Determines whether to factor in task probability percentage from work structure task details

Warn Revenue Over

0% to 50%

Display data in red for variances greater than the specified percentage over target.  Target revenue as set in Admin > Departments

Warn Revenue Under

0% to 50%

Display data in red for variances greater than the specified percentage under target.  Target revenue as set in Admin > Departments

Revenue Calculation

Month Totals or Cumulative

Display either total income for the month or month-on-month cumulative figures

Task Status

All configured task statuses available for selection

As configured in Admin > Project Settings > Task Statuses – tasks will be flagged as Pending, In Progress, Dormant or Complete

Invoice Status

All invoice statuses available for selection

As pre-set in ProjectMinder – Draft, Sent, Part-paid or Paid

Expense Types

All configured expense types available for selection

As configured in Admin > Company Settings > Expense Types – expense types will be applicable to expenses and/or purchase invoices

Field Name

Description

Criteria

Revenue Graph

Colour coded graphical display of revenue

Revenue values displayed colour coded by project status, compared to total and target.

Revenue Table

Tabular display of monthly revenue broken down by department, drill down to individual project and task level

Values displayed will be either month total or cumulative depending on the filter selection.  Monthly grand totals are displayed at the bottom and compared to target revenue as set in Admin > Departments.  Variances colour coded as specified in the filter selection.  Cut-off displayed as a red line.