Profitability Detail
The Profitability Detail is obtained by clicking on the Profitability Detail option within the Reports menu within the Projects Listing page.
(Click here to see a picture of the menu location)
Access Right: Project Profitability View in Web and/or Project targeting view in web
Purpose
The Profitability Detail provides an analysis of profit and loss for a project showing all transactions. Each daily transaction is shown from timesheets, expenses and invoices. The enquiry requires a date range. Any transactions before the date range are shown as monthly totals, whilst the full detail of all transaction is shown for those within the date range.
The report shows not only the current profit and loss for the project, but also shows how much time has been written off or remains unbilled. At the end of the report a graph is drawn of the invoiced income and costs.
Operation
To obtain the report, select a date range for which you need the detail and click the refresh button 
. You may wish to limit the detail to just one or two months as the number of transaction could be quite large.
The columns on the report are as follows:
Date |
The date of the transaction. Ie. Timesheet date, invoice date, etc. |
Staff/Supplier |
The staff member for the timesheet or expense, or the supplier name for the external expense (outsourced fees or project purchase expense) |
Service |
The service within the project |
Group |
The group allocated to the transaction (The service and group may be used to filter the grid and obtain separate totals for each) |
Description |
A description of the transaction, ie. The task or activity for the timesheet records, or the expense description for expenses, or the invoice narrative for invoices. |
Hours |
The timesheet hours – zero for non timesheet records. |
Time Costs |
The timesheet costs – zero for non timesheet records. |
Other Costs |
The costs of expense records, either from staff expenses or project purchases. |
Total Costs |
The previous two cost columns added together. |
Written Off |
The value of timesheet income written off. This will only apply to time-charged projects. |
Unbilled |
The value of income not yet billed. This column only includes un-billed time-charge timesheets and unbilled expenses. Fees earned by schedule or percentage completion but not yet billed are not included in this column. |
Billed |
The value of invoices (all income types [fee/time/expenses] after discounts) |
Inv Profit |
A straightforward cash profit/loss: Billed – Total Costs |
Invoice Date |
The date the transactions were invoiced |
Graph |
At the end of the report, a graph is drawn of Billed vs Total Costs, and also for the unbilled values over time. |
Sample Report
