Project performance report (PPR): concept

The Project Performance Report (PPR) offers a comprehensive collection of fields that can help you accurately monitor and understand your projects. However, with nearly 150 columns available, most of which are numerical metrics, things can get a bit complicated without a helpful guide. In this article, we will explore most of these fields.

A key point to note is that the PPR is designed to compare two specified dates: the start and end date when you export it from Kompass.

Therefore, each numeric value (such as price, hours, costs, etc.) will return three columns:

_start: value at the start date
_end: value at the end date
_change: difference between the start and end dates

costs_budget	cost of proposal item as set by the cost options in the proposal item page.
costs_hours_actual_total	sum of all the products of the hours the users have worked, multiplied by their cost rate (based on their set user rate).
costs_hours_actual_field	as above but only for hours recorded under field task type.
costs_hours_actual_office	as above but only for hours recorded under office task type.
costs_hours_actual_other	as above but only for hours recorded under any other task types.
expenses_billable	sum of all expenses marked as billable to the client.
expenses_nonbillable	sum of all expenses that are not marked as billable to the client.
expenses_total	sum of all expenses.
hours_actual_worked_total	sum of all hours worked.
hours_actual_worked_field	sum of hours worked under field task type.
hours_actual_worked_office	sum of hours worked under office task type.
hours_actual_worked_other	sum of hours worked under any other task types.
hours_actual_paid_total	if your company is using overtime multipliers, Kompass applies them to the relevant hours.
hours_actual_paid_field	as above but only for hours recorded under field task type.
hours_actual_paid_office	as above but only for hours recorded under office task type.
hours_actual_paid_other	as above but only for hours recorded under any other task types.
hours_actual_billable_total	sum of all billable hours (it subtracts any hours booked as non-billable)
hours_actual_billable_field	as above but only for hours recorded under field task type.
hours_actual_billable_office	as above but only for hours recorded under office task type.
hours_actual_billable_other	as above but only for hours recorded under any other task types.
hours_actual_nonbillable_total	sum of all non-billable hours as recorded under timesheet entries (not all Kompass costumers are using this field).
hours_actual_nonbillable_field	as above but only for hours recorded under field task type.
hours_actual_nonbillable_office	as above but only for hours recorded under office task type.
hours_actual_nonbillable_other	as above but only for hours recorded under any other task types.
invoices_standard	sum of all invoiced amounts based on the invoice date.
invoices_billing	sum of all invoiced amounts based on the billing dates.
payments	sum of all payments.
price_budget	price of proposal item as set in the proposal item page.
price_hours_actual_total	sum of all the products of the hours the users have worked, multiplied by their billing rate (based on their set user rate).
price_hours_actual_field	as above but only for hours recorded under field task type.
price_hours_actual_office	as above but only for hours recorded under office task type.
price_hours_actual_other	as above but only for hours recorded under any other task types.
status_start	information of valuations on the start date of the report.
status_end	information of valuations on the end date of the report.
status_change	information of the difference in valuations between start and end date.
wip_standard	any standing work in progress based on the invoice dates.
wip_billing	any standing work in progress based on the invoice billing dates.