top of page

Project Summary Financial Business Rules

  • 5 hours ago
  • 3 min read

Overview


The Project Summary page aggregates financial information from multiple UniPhi modules, primarily the Costs, Revenue, and Chart of Accounts (CoA) structures.


Financial values displayed in the summary are dynamically calculated based on:


  • Phased Actuals

  • Phased Forecasts

  • Budget values

  • Contracted values

  • The Primary Chart of Accounts selected for the project


Most cost-related fields are driven by the configuration in:


Project Details > Primary Chart of Accounts > Project Cost CoA


Core Cost and Revenue Logic


Most cost-related fields are calculated using the Chart of Accounts selected in the Project Details configuration.

Column Name

Business Rule / Logic

Source Data

Project Actual Cost

Total phased actuals for all closed periods

Costs Tab (Actuals)

Project Forecast Cost

Total phased forecast values for all open periods

Costs Tab (Forecast)

Project Total Cost

Total contracted cost of the project

Costs Tab (Contracted View → Forecast column)

EAC Cost

Estimated cost at completion: Phased Actual + Forecast from the specified Cost CoA

Costs Tab

EAC Revenue

Estimated revenue at completion: Phased Actual + Forecast from the specified Revenue CoA

Revenue Tab

Profit and Margin Calculations

These fields are calculated dynamically based on the project’s budgeted and estimated financial performance.

Profit Budget

Profit Budget = Revenue Budget − Cost Budget

Profit Margin Budget

Profit Margin Budget = Profit Budget / Cost Budget

EAC Profit

EAC Profit = EAC Revenue − EAC Cost

EAC Profit Margin

EAC Profit Margin = EAC Profit / EAC Cost

Equity Metrics

Equity values are calculated using codes categorised as "Equity" at Code Level 2 within the Chart of Accounts.

Column

Business Rule

Equity Actual

Sum of phased actuals for codes categorised as Equity (Code Level 2)

Peak Equity Budget

Maximum value of the running total of phased budget for Equity code types

Peak Equity

Maximum value of the running total of Actual + Forecast for Equity code types

These values represent the maximum equity exposure across the project lifecycle.


Additional Columns and Project Details Fields


Additional financial fields have been added to the All Projects view and Project Details page to provide expanded financial visibility.


All Projects View

Field

Description

All Costs

Total cost budget tied to the selected cost chart (not phased)

All Revenue

Total revenue budget tied to the selected revenue chart (not phased)

Profit Return

All Revenue − All Costs

Margin %

Profit Return / All Costs

Total Cost

Uses the same business logic as Total Revenue

Project Baseline Start

Baseline start date of the project

Project Baseline Finish

Baseline finish date of the project

Project Details Page Fields

Field

Business Logic

Profit Return

All Revenue − All Costs

Margin %

Profit Return / All Costs

Equity Committed

Sum of phased actual equity values

Budget Equity Required

Maximum value of the phased budget equity profile

Act/Fcst Equity Required

Maximum value of the phased Actual + Forecast equity profile

Frequently Asked Questions


Why does Project Total Cost differ from Actual + Forecast?


Project Total Cost represents the contracted total value of the project.


If you need the current anticipated spend, including:

  • variations

  • updated forecasts

  • estimated remaining costs refer to:


EAC Cost or the combined value of Project Actual + Forecast Cost.


Where do I change which accounts are used in these calculations?


Navigate to:


Project Details > Primary Chart of Accounts


From here you can configure:


  • Project Cost Chart of Accounts

  • Project Revenue Chart of Accounts

  • Equity code mappings


These selections determine which accounts are included in the Project Summary calculations.

 
 
 

Comments


Subscribe to our UniPhi newsletter

Thanks for submitting!

  • Twitter
  • Youtube
  • Linkedin

© 2024 by UniPhi

bottom of page