Skip to main content
Planview Customer Success Center

Getting started with Aggregated Project Financials

In the initial stages of financial tracking, it's helpful to start by capturing a project's high-level budgeted costs and expected revenue.

With this approach, you focus on simplified, aggregated financials, where the budget is either manually set or based on the effort outlined in the work plan. AdaptiveWork handles the rest, automatically providing key financial indicators. Once you input basic project details—such as during the PID (Project Initiation Document) submission stage—the tool calculates metrics like expected margin, CPI, budget status, and more for you.

           

Prerequisites

If you can't configure your organization system settings or set User permissions, contact your administrator to ensure that the following prerequisites are met. These prerequisites are common to all Maturity levels described below. Additional settings will need to be enabled from Level 2 up.

Global System settings

  • Enable the system settings 9.1: Budget Management. Defines whether to activate the budget module which enables budgeted cost and actual cost management
  • Enable the system settings 9.3: Projects are Billable by default. Defines whether projects are billable by default, where revenue fields and variances are calculated.

User Permissions and Profile

  • Enable the Financial permissions for Users so that they can access financial fields and the financial planning view
  • Ensure the User Profile Property Card includes a Financial section with the following standard fields: 
    • Budgeted Cost, Actual Cost, CPI
    • Expected Revenue, Actual Revenue, RPI
    • Planned Profit, Profit, Earned Value, % Profitability

Project settings

  • Add the Calculate Financials field to the grid and toggle ON at the project level. This will enable the application to run aggregated financials in the background. 
  • Add the Billable field to the grid and toggle OFF for all work items that shouldn't be included in revenue calculation. Alternatively, you can ask your administrator to uncheck the 9.3 system settings so that you can turn ON only relevant items. 

           

           

 

 

Scenario Description

Set manually Project Budgeted Cost and Expected Revenue

In the early stages of financial tracking, Project Managers may want to start capturing on a high level a project’s budgeted cost and expected revenue.

When setting up manually aggregated Project budget and Actual effort, there is no worry about creating work plan, estimate, and defining rates. It can be very useful to get quickly financials data when for example you are at the stages of a PID (project initiation document) submission. 

Calculate automatically Budget and Actuals using Organizational Rates

Project Managers can define Budget and Actuals through calculation using Organizational Billing and Cost Rates. 

Organizational Rates are used in Professional Services Automation (PSA) financial management to standardize cost and billing rates across projects and resources. These rates streamline budgeting, forecasting, and financial tracking by providing consistent baseline values. They’re particularly useful for organizations aiming to streamline operations and maintain financial accuracy at scale.

Track actuals with timesheets

When projects are large and many resources contribute to your projects, tracking actuals directly from the Work Plan becomes cumbersome and overtime can be less accurate. As a best practice, Resources can use Timesheets and track actual minutes, hours and/or days of work on individual work items. It is recommended that data is provided as accurately and timely as possible so you can have the most accurate progress, utilization and cost metrics on your projects. 

Once time entries (work duration + details) are entered for a given time frame, the Timesheet can be submitted to your project manager or direct manager for approval. As soon as approval is granted, the hours are reflected in the related project and percentage complete is shown on individual work items. Actual effort is automatically updated from the approved time reported by the labor resources and actual cost and actual revenue derived automatically. Learn more about timesheets

In this scenario, Project Managers created a work plan, estimates, and organizational rates were setup by your administrator. Team Members are reporting time in AdaptiveWork for the tasks they are assigned to. 

In addition to timesheets reporting for calculating Actual Effort, Project Managers can use Organizational Billing and Cost Rates to calculate Budgeted and Actual Cost, Actual and Expected Revenue. 

Add approved expense sheets to actuals costs

Use Expense sheets and actuals to feed into Project actual Cost and Revenue