Reporting on Financial Metrics

Reporting and monitoring the financial health of your projects is very easy in Project Pulse.

First create a report of the type “Projects with Project Financials”

Screen Shot 2015-12-17 at 11.24.25 AM

On the report editor, you want to make sure you add a filter for only the current month financials.

Screen Shot 2015-12-17 at 11.26.10 AM

Now you want to add the Project Name, and any other columns from the Financials object that you want to monitor. For example, Current Revenue. See below for a table of all available metrics.

Next you want to group the report by Project Name, and Summarize your other fields.

Screen Shot 2015-12-17 at 11.31.46 AM

Now save your report and run it. You can use this report to create Dashboard components so you can track margin, revenue, cost and all other metrics in one place.

Screen Shot 2015-12-17 at 11.34.39 AM

Available Financial Metrics

Cost Metrics

Actual Cost The actual cost for the project from the project start date thru the given revenue period. This value includes labor costs + expense costs.
Actual Labor Cost The actual labor cost for the project from the project start date thru the given revenue period.
Actual Service Exp Cost The actual service expense cost from the project start date thru the given revenue period. Direct charges that have the ‘Contributes_to_Service__c’ attribute = True will be included in this calculation. Valid for Cost Based revenue projects only.
Current Cost The actual project cost (labor + expenses) for the current revenue period. Billable and non-billable expenses are included.
Current Est Cost The estimated project cost for the current revenue period. This includes the estimated labor cost + estimated expense costs for the current period.
Current Est Cost MTD The estimated project cost (labor + expenses) for the current revenue period thru today’s date. Billable + non-billable expenses are included.
Current Est Labor Cost The estimated labor cost for the current period.
Current Est Labor Cost MTD The estimated labor cost for the current period thru today’s date.
Current Est Non-Service Exp Cost The estimated non-service expense cost for the current revenue period. Estimated expenses that have the ‘Contributes_to_Service__c’ attribute = False will be included in this calculation.
Current Est Non-Service Exp Cost MTD The estimated non-service expense cost for the current revenue period thru today’s date. Estimated expenses that have the ‘Contributes_to_Service__c’ attribute = False will be included in this calculation.
Current Est Service Exp Cost The estimated service expense for the current revenue period. Estimated expenses that have the ‘Contributes_to_Service__c’ attribute = True will be included in this calculation. This value will be calculated for Cost Based revenue projects
only.
Current Est Service Exp Cost MTD The estimated service expense for the current revenue period thru today’s date. Estimated expenses with ‘Contributes_to_Service__c’ attribute = True will be included in this calculation. Valid only for Cost Based projects.
Current Labor Cost The actual labor costs for the current month.
Current Non Service Exp Cost The actual non-service related expense costs for the current month.
Current Service Exp Cost The actual service related expense costs for the current month.
Est Cost The estimated cost (labor + expenses) for the project from the start date thru the given revenue period.
Est Cost MTD The estimated cost (labor + expenses) for the project from the start date thru today’s date for the given revenue period.
Est Labor Cost The estimated labor cost for the project from the project start date thru the given revenue period.
Est Labor Cost MTD The estimated labor cost for the project from the project start date thru today’s date for the given revenue period.
Est Non-Service Exp Cost The estimated non-service expense cost thru the given revenue period. Estimated expenses that have the ‘Contributes_to_Service__c’ attribute = False will be included in this calculation.
Est Non-Service Exp Cost MTD The estimated non-service expense cost thru today’s date for the given revenue period. Estimated expenses that have the ‘Contributes_to_Service__c’ attribute = False will be included in this calculation.
Est Service Exp Cost The estimated service expense
cost thru the given revenue period. Estimated expenses with ‘Contributes_to_Service__c’ attribute = True will be included in this calculation. Valid for for Cost Based revenue projects only.
Est Service Exp Cost MTD The estimated service expense
cost thru today’s date for the given revenue period. Estimated expenses with ‘Contributes_to_Service__c’ attribute = True will be included in this calculation. Valid for for Cost Based revenue projects only.
Is Over Cost?
Projected Total Cost The projected total cost for the project. This includes actual costs to-date + estimated remaining costs. Valid for Cost Based projects only.
Projected
Total Service Cost
The projected total service cost for the project. This includes actual service costs to-date + estimated remaining service costs. Valid for Cost Based projects only.
Remaining Cost The remaining project cost from the given revenue period. This value includes remaining labor + expense costs.
Remaining Labor Cost The remaining labor cost from the given revenue period.
Remaining Non-Service Exp Cost The remaining non-service expense costs from the given revenue period.
Remaining Service Exp Cost The remaining service expense costs from the given revenue period. Valid for for Cost Based revenue projects only.
Total Est Cost The total estimated project cost. This value will be the same for each revenue period. Total_Est_Cost__c = Total_Est_Labor_Cost__c + Total_Est_Service_Cost__c + Total_Est_Non-Service_Cost__c
Total Est Labor Cost The total estimated labor cost for the project.
Total Est Non-Service Exp Cost The total estimated non-service expense cost for the project. Estimated expenses that have the ‘Contributes_to_Service__c’ attribute = False will be included in this calculation.
Total Est Service Exp Cost The total estimated service expense cost for the project. Estimated expenses with ‘Contributes_to_Service__c’ = True will be included in this calculation.

Revenue Metrics

Actual Adjusted Revenue The accrued actual revenue including any revenue adjustments.
Actual Fixed Price Revenue The actual fixed price revenue from the project start date thru the given revenue period. This value will be the sum of the fixed price revenue values assigned to the task and/or phase.
Actual Labor Revenue The actual labor revenue for the project from the project start date thru the given revenue period. This value is only calculated for Time & Material projects.
Actual Net Revenue The actual net revenue for the project from the project start date thru the given revenue period. The formula is: Actual_Net_Revenue__c = Actual_Revenue__c – Actual_Cost__c
Actual Non-Service Revenue The actual non-service revenue from the project start date thru the given revenue period. Direct charges that have the ‘Contributes_to_Service__c’ attribute = False will be included in this calculation.
Actual Revenue The actual revenue for the project from the start date thru the given revenue period. How this metric is calculated will vary based on the revenue model assigned to the project.
Actual Service Revenue The actual service revenue from the project start date thru the current revenue period. Valid only for Cost Based revenue projects. Actual_Service_Revenue__c = Actual_Service_Cost__c / Total_Projected_Service_Cost *
MaxContractServicePrice
Actual Subscription Revenue The actual subscription revenue from the project start date thru the current revenue period. This value will only be calculated for Subscription revenue projects.
Actual Subscription Revenue MTD
Current Adjusted Revenue The revenue for the current period including the adjustment.
Current Est Labor Revenue The estimated labor revenue for the current period. This metric will only be calculated for Time & Material projects.
Current Est Labor Revenue MTD The estimated labor revenue for the current period thru today’s date. This metric will only be calculated for Time & Material projects.
Current Est Non-Service Revenue
Current Est Non-Service Revenue MTD
Current Est Revenue The estimated revenue for the current revenue period. How this metric is calculated will vary based on the revenue model assigned to the project.
Current
Est Revenue MTD
The estimated revenue for the current revenue period thru today’s date. How this metric is calculated will vary based on the revenue model assigned to the project.
Current Est Subscription Revenue The estimated subscription revenue for the current revenue period. Calculated for Subscription revenue projects only.
Current Est Subscription Revenue MTD The estimated subscription revenue for the current revenue period thru today’s date. Calculated for Subscription revenue projects only.
Current Fixed Price Revenue
Current Labor Revenue
Current Net Revenue The actual net revenue for the current revenue period. The formula is: Current_Net_Revenue__c = Current_Revenue__c – Current_Cost__c
Current Non Service Revenue
Current Revenue The actual revenue for the current revenue period. How this metric is calculated will vary based on the revenue model assigned to the project.
Current
Service Revenue
This metric is valid for Cost-Based projects only. Service revenue is recognized as expenses (labor and/or direct charges) are incurred.​ Current service revenue is the revenue earned during the given period.
Current Subscription Revenue
Current Subscription Revenue MTD
Est Fixed Price Revenue The estimated fixed price revenue from the project start date thru the given revenue period. This value will be the sum of the fixed price revenue values assigned to the task and/or phase.
Est Fixed Price Revenue MTD The estimated fixed price revenue from the project start date thru today’s date for the given revenue period. This value will be the sum of the fixed price revenue values assigned to the task and/or phase.
Est Labor Revenue The estimated labor revenue for the project from the project start date thru the given revenue period. Calculated for Time & Material projects only.
Est Labor Revenue MTD The estimated labor revenue for the project from the project start date thru today’s date for the given revenue period.. Calculated for Time & Material projects only.
Est Net Revenue The estimated net revenue for the project thru the given revenue period. The formula is: Est_Net_Revenue__c = Est_Revenue__c – Est_Cost__c
Est Non-Service Revenue
Est
Non-Service Revenue MTD
Est Revenue The estimated revenue for the project from the start date thru the given revenue period. How this metric is calculated will vary based on the revenue model assigned to the project.
Est Revenue MTD The estimated revenue for the project from the start date thru today’s date for the given revenue period. How this metric is calculated will vary based on the revenue model assigned
to the project.
Est Service Revenue The estimated service revenue thru the current revenue period. Valid for Cost Based revenue projects only. The formula is: Est_Service_Revenue__c = Est_Service_Cost__c / Total_Projected_Service_Cost__c * MaxContractServicePrice
Est Service Revenue MTD The estimated service revenue thru today’s date for the current revenue period. Valid for Cost Based revenue projects only. The formula is: Est_Service_Revenue__c = Est_Service_Cost__c / Total_Projected_Service_Cost__c *
MaxContractServicePrice
Est Subscription Revenue The estimated subscription revenue thru the given revenue period. Valid for Subscription revenue projects only.
Est Subscription Revenue MTD The estimated subscription revenue thru today’s date for the given revenue period. Valid for Subscription revenue projects only.
Is Under Revenue?
Revenue Adjustment Entering a positive amount adds to revenue for the current period. Entering a negative amount subtracts from revenue for the current period.
Revenue Adjustment Reason The reason for the financial adjustment.
Total Est Fixed Price Revenue The total estimated fixed price revenue for the project. This metric includes fixed price revenue from tasks and phases if provided. Valid for Fixed Price projects only.
Total Est Labor Revenue The total estimated labor revenue for the project. Valid for Time & Material projects only.
Total
Est Non-Service Revenue
The total estimated non-service revenue for the project. Estimated expenses with ‘Contributes_to_Service__c’ = False will be included in this calculation.
Total Est Revenue The total estimated revenue for the project. Total_Est_Revenue__c = Total_Est_Labor_Revenue__c + Total_Est_Service_Revenue__c + Total_Est_Non-Service_Revenue__c + Total_Est_Fixed_Price_Revenue__c + Total_Est_Subscription_Revenue__c.
Total Est Service Revenue The total estimated service revenue for the project. Valid for Cost Based revenue projects only. The value of this field is equal to the value of the MaxContractServicePrice field (on the project).
Total Est Subscription Revenue The total estimated subscription revenue for the project. The value of this field is equal to the value of the Subscription_Price__c field (on the project).

Hours

Actual Hours The actual hours (billable + non-billable) logged for the project from the project start date thru the given revenue period.
Current Est Hours The estimated hours for the current period.
Current Est Hours MTD The estimated hours for the current period thru today’s date.
Current Logged Hours The actual hours logged for the current revenue period.
Est Hours The estimated hours for the project from the start date thru the given revenue period.
Est Hours MTD The estimated hours for the project from the start date thru today’s date for the given revenue period.
Is Over Hours? If the project actual hours has exceeded the baseline estimated hours or the project estimated hours, then return true.
Remaining Hours The remaining hours for the project from the given revenue period.
Total Est Hours The total estimated hours for the project.

Margin

Actual Margin Overall margin for the project
Current Margin The actual margin for the current revenue period. The formula is: Current_Margin__c = (Currentl_Revenue__c – Current_Cost__c) / Current_Revenue__c
Est Margin The estimated margin for the project thru the given revenue period. The formula is: Est_Margin__c = (Est_Revenue__c – Est_Cost__c) / Est_Revenue__c

Other Metrics

% Complete Project % complete based on record type: Cost Based: actual / total cost Fixed Price & Custom FP: actual / estimated revenue T&M and Custom T&M: actual / total estimated hours Subscription: actual / estimated subscription revenue
Is Current Is this the current period as defined in the Project Pulse Financials Custom Setting?
Is Locked? Setting this attribute to True will prevent Project Pulse from recalculating the given revenue period financial metrics. In addition, the underlying time and expense data used to calculate the given revenue period will be protected from change.
Is Over Schedule?
Period End Date The last day of the given revenue period.
Period Start Date The first day of the given revenue period.

About Alex Sartogo

I'm the VP of Engineering @ Configero, overseeing the design and implementation of all our products. I've served many roles in the past 10 years, all revolving around the Salesforce.com platform, from developer, to solution architect, to managing our entire delivery organization.

Entries by Alex Sartogo