Cost Profitability

Group

Project

Description

Profitability gained from costs incurred (expenses,  purchase invoices, timesheets) plus any fixed fees

Business Purpose

Identify any work or expenses carried out that has not been invoiced to the client and ensure a profit is made for this work

Ideal For

Project Director

Project Manager

Financial Controller

Filter Name

Selection

Criteria

Start date

Earliest project start date

Project start date selected in project summary

End date

Latest project start date

Project start date selected in project summary

Include Timesheets

Select whether or not to include timesheet data in report

Submitted timesheets that have been approved

Expense Types

Expense Type selection

Expense types listed in Admin -> Company Settings page

Field Name

Description

Criteria

Project Code

Project code

Entered into the Project Summary. Can be expanded to show the cost/invoice breakdown for each task

Project Name

Project name

Entered into the Project Summary

Account

Client name

Entered into the Contacts page

Status

Project Status

Entered in the Project Summary

Sector

Industry Sector of project

Entered in the Project Summary

% Done

% of project complete

Sum of the percentages complete (as defined in Work Structure) for all tasks in the Project divided by the number of tasks. This is not weighted by the planned work of each task.

E.g.

Task 1 is 20% complete

Task 2 is 100% complete

% done will be 60%

Line

The invoice item type

Time, Expense or Fixed Fee

Line Description

Invoice item description based on invoice item type

Invoiced time from timesheets (where a time charge rule has been run) are marked as Timesheet, Expenses that have been invoiced through an expenses rule are referred to by the Expense Type. With the exception of Fixed fee items (which are referred to as Fixed Fee) all items manually created through Invoices > Invoice Items or through Projects > Invoice Items are referred to as Manual

Last Invoiced

The invoice item date

Invoiced Total

The invoice item value

Costs Total

Cost amount for the timesheet, expense or fixed fee invoice item

Gross Profit

Gross profit of invoice item

Invoice Total - Costs Total

Rejected

Total time, expense and purchase invoice costs on rejected sheets

Rejected only

Submitted

Total time and expense costs on submitted (but not approved) sheets

Submitted only