top of page

Project Summary Financial Business Rules

  • Mar 5
  • 3 min read

Updated: Mar 6

Overview


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


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


  • Timephased Actuals

  • Timephased Forecasts

  • Budget values

  • Contracted values

  • The Primary Chart of Accounts selected for the project


Most financial fields displayed in the Project Summary are driven by the configuration set in:


Project Details > Primary Chart of Accounts > Project Cost CoA


This configuration determines which Cost and Revenue Chart of Accounts are used to calculate the financial summary values.


Chart of Accounts and Financial Calculations

Financial values in the Project Summary are derived from the Chart of Accounts configured for the project.

UniPhi distinguishes between two different cost structures:


Project Cost Chart of Accounts


Used to calculate the Project Cost financial fields.


Internal Cost Chart of Accounts


Used to calculate the Internal Cost financial fields.


Revenue values are calculated using the Revenue Chart of Accounts.


Core Cost and Revenue Logic

Column Name

Business Rule / Logic

Source

Project Actual Cost

Total timephased actuals for all closed periods using the Project Cost CoA

Cost Module (Actuals)

Project Forecast Cost

Total timephased forecast values for all open periods using the Project Cost CoA

Cost Module (Forecast)

Project Total Cost

Total contracted cost of the project based on the Project Cost CoA

Cost Module (Contracted View → Forecast column)

EAC Cost

Estimated cost at completion: Timephased Actual + Forecast using the Project Cost CoA

Cost Module

EAC Revenue

Estimated revenue at completion: Timephased Actual + Forecast using the Revenue CoA

Revenue Module

Profit and Margin Calculations

Profit values in UniPhi are calculated based on Revenue minus Internal Cost.

These values represent the projected financial performance of the project based on both budgeted and estimated financial data.


Profit Budget

Profit Budget = Revenue Budget − Internal Cost Budget

Profit Margin Budget

Profit Margin Budget = Profit Budget / Internal Cost Budget

EAC Profit

EAC Profit = EAC Revenue − EAC Internal Cost

EAC Profit Margin

EAC Profit Margin = EAC Profit / Internal 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 timephased actuals for codes categorised as Equity (Code Level 2)

Peak Equity Budget

Maximum value of the running total of timephased 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

Total Cost

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

Total Revenue

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

Profit Return

Total Revenue − Total Cost

Margin %

Profit Return / All Costs

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

Equity Committed

Sum of phased actual equity values

Budget Equity Required

Maximum value of the timephased budget equity profile

Act/Fcst Equity Required

Maximum value of the timephased 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 Cost + 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

  • Internal Cost Chart of Accounts

  • 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