Finance/ Operations_Project Performance Review

Intro: An overall review of your company's performance on a monthly basis. Allows you to evaluate worked hours, status updates, invoiced amounts and WIP.

In Kompass: Kompass stores several data for each project and each proposal item. The Projects list shows each project's status, budgeted and actual hours, invoiced amounts and WIP, but it does not compare a period or group the figures across projects. This file (commonly abbreviated as PPR) adds both: it combines the data for a chosen period so you can compare and group it across projects.

File Needed: The Projects Performance Report (PPR) can be exported directly from Kompass: page "Projects", "Actions", "Reports", "Projects Performance Report". Please contact our helpdesk if it's not available in your account. 

Uploading method: If you update your data in Kompass, you will need to export the file again.

The File: All tabs offer the same values in different slicing fields for each project, manager, and department, as seen in the screenshot below.

  • Each Project can be expanded to all its proposal items (rows 6-23). However, fields can be collapsed and provide information by a single manager/ department (rows 3-5 and 24-).
  • Any status notes added in Kompass will appear in the Status Notes column. The file shows the latest status as of the end of the exported period, which can be older than the period.
  • Valuations column returns any valuation recorded in the exported period. Valuations are recorded in the status update.
  • Invoices column returns any invoiced amounts in the period. You can choose whether to use the invoice date or the billing date as your reference.
  • WIP (Work In Progress) column returns the difference between the valuation and the invoiced amount. WIP is a key element of your performance as it weaves together financial data (invoicing) with project valuation (status updates).
  • Hours column returns the number of hours recorded. Cells highlight hours that have been recorded without a valuation, and cases where there is a valuation with no recorded hours.
  • Value per worked hour column returns the value per recorded hour. Conditional formatting marks the most and least profitable proposal items.

Slicers limit the information shown. They work in the same way as the column filter buttons, but are more user-friendly. The [Account] and [Price Type] slicers can be used in combination.

Further analysis: There are several ways to slice and dice the information. Any column found in the Projects Performance CSV export can also be used for slicing.

Please note that all projects not yet marked as fully invoiced will appear in the PPR, regardless of whether there have been any changes in the exported period.

Project performance reports can be tailored to your needs. With our help, it is easy to add, change or remove columns and data in the file. There is a wide variety of values you can retrieve from Kompass. More details in the article: Project performance report (PPR): concept

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us