Available Columns

The list below contains the different metrics available in the HR, Company Groups and Projects modules. There are a number of panes available and it is entirely up to yourselves which ones you want to be displayed to users on their home page. It is about tailoring the panel to include the ones which are most relevant, and appropriate.

Project Metrics

ColumnDescription
Actual Labour DaysThe actual number of processed timesheet days up to and including the current month
Actual vs Forecast DaysActual days minus forecast days up to and including the current month. A positive number means more days have been worked than the budget. A negative number meansthe actual days are within budget.
Invoiced (Fee)The amount invoiced in the current month. Includes feesonly. Please note that all amounts are NET.
Invoiced (All)The amount invoiced in the current month (including recharged income). Please note that all amounts are NET.
Billing Plan (Fee)The amount in the billing plan for the current month - non rechargeable.
Billing Plan (All)The amount in the billing plan for the current month, including rechargeable amounts.
To InvoiceShows amount to be invoiced (Total Fee - Invoiced)
Total CostThe total cost to date (excluding rechargeable). Green = Total Cost less than target budget. Amber = Total Cost less than total fee. Red = Total Cost greater than total fee.
Cost (inc. rechargeable)The total cost to date (including rechargeable).
P/L CurrentThe current Profit / Loss of the project, corresponding to the value in the Project Summary panel.
P/L Current %The current Profit / Loss % of the project, corresponding to the value in the Project Summary panel.
Forecast Labour DaysThe number of forecast days up to and including the current month
Aged DebtAged debt for live projects in this group
Gateway Status 
Revenue – Last MonthFee allocated to you in project billing plans in the last month
Revenue – This MonthFee allocated to you in project billing plans in the current month
Revenue – YTDFee allocated to you in project billing plans so far in this financial year
Total InvoicedThe total fee invoiced to date.
Labour ProgressShows the actual labour progress against planned based on Estimated % Complete. Calculation = (Total Budget labour days x % complete) – Actual labour days
P/L TotalTotal current profit of all selected jobs in the project summary panel
P/L Current – Jobs Below TargetTotal jobs below target (current profit)
P/L Forecast TotalTotal forecast profit of all selected jobs in the project summary panel
P/L Current – Jobs Above TargetTotal jobs above target (current profit)
P/L Current – Jobs Loss MakingTotal jobs loss making (current profit)
Number of JobsNumber of jobs matching the project summary filter
Total FeeTotal fee of all selected jobs in the project summary panel
% CompleteThe estimated percentage complete of the project, based on the WIP Estimated % Complete values. A single project percentage is calculated, weighted by Workstage fee.
P/L ForecastThe forecast Profit / Loss of the project, corresponding to the value in the Project Summary panel.
P/L Forecast %The forecast Profit / Loss % of the project, corresponding to the value in the Project Summary panel.
Project StatusThe current status of the project.
Target BudgetThe target budget, based on the profit margin set in the fee/ Workstage’s page.
Budget Labour DaysThe total number of budget labour days for the whole life of the project.
Total FeeThe Workstage total fee (based on the Workstage filter in the Project Summary panel)

HR Metrics

ColumnDescription
Current GradeCurrent project grade
Current Grade CostCurrent project grade cost. Applied to forecast labour costs.
Live Cost RateCurrent project base cost rate * overhead factor. Applied to actual timesheet costs.
Average Hours WorkedAverage weekly hours worked in the past 3 months
Sick DaysSick days taken this holiday year
Length of ServiceTotal number of years & weeks service
Bradford ScoreThe calculation includes all sickness with a start date within the past 12 months. Please note that sickness absence which is booked as individual days rather than in a block will increase the Bradford score. This score should be used as a guide in conjunction with the leave calendar. The Bradford score also takes no account of mitigating circumstances such as staff with a disability who may have a higher trigger point for absence.

Company Group Metrics 

ColumnDescription
Number of CompaniesNumber of companies in this company group
Number of ContactsNumber of contacts in this company group
Number of bidsNumber of bid / speculative projects in this company group
No of WinsNumber of ongoing / complete projects in this company group
Number of LostNumber of lost projects in this company group
Last Project CreatedThe registration date of the most recent project in this company group
Last BD NoteThe date of the most recent business development note for this company group
Open BD NotesNumber of open business development notes
Project FeeProject fee for live projects in this group
Average Live FeeAverage fee for live projects
Aged DebtThe current outstanding debt for the project. Please note that all amounts are net of tax.