Skip to content
Skip to content
  • There are no suggestions because the search field is empty.

Financial Status

The Financial Status within the Governance tab allows you to define and maintain the Revenue and Capital expenditure Targets, Forecasts and Actuals of Projects. Note that these financial values are 'rolled up' into parent Plans (so, for example, the Finances tab of a Programme will sum the Finances tabs of all its dependent Projects).

Certain controls (in the expandable region under the main matrix) can be enabled/disabled via the admin flag on Admin > General “Enable Capex controls”.

Other points about Financial Status:

  • In R3.2 onwards, the new fields Drawdown and Forecast2/3 are hidden unless set via the admin flags “Use Drawdown” and “Use Extended Forecast”, respectively.
  • The variance algorithm seen in the bottom row on the financial status page can be fine-tuned via the controls on admin general.
  • Variance is always disabled.
  • Total columns are disabled unless manual totals is enabled (not implemented in cloud)
  • Actual+Forecast row cells are disabled; they are calculated from the first non-empty cell above it. I.e. takes the first non-empty value in the following order: Actual, Forecast 3, Forecast 2, Forecast.
  • Cells are disabled if the source for the plan is detail driven, in which case values are pulled from the Finance details screen.
  • Cells are disabled in historical records if the schema the history record is using has no record of the columns existing when the history record was created.
  • By default, only Admins can modify historical periods, users with a Team (UT), Executive (EX), Creator (UW) or Reader (UR) licence type cannot.

o However, admins may change settings under Admin > General to allow users with write access to the plan to edit historical periods up to X days ago, where X is the admin defined “X days left of redline” value.

  • Period duration for financial status is set on the Admin > General page.
  • The default “source” (summary-driven or detail-driven) is defined on the Admin > General page.
  • Acutal+F’Cast column was added in R6.4 to portfolios and projects.

For Detail driven projects, values will be used from Plan > Finances

  • For Summary driven projects values can be entered directly on Financial Status

  • Actual+F'Cast values are calculated fields. These calculations are based on following algorithms:
  • Actual + Forecast To Date: Considers only completed periods. Start period is the first period where ANY figures have been entered.  
  • For each period: If Actuals total is NOT Null, uses Actuals total, otherwise uses Forecast (if Forecast 2/3 is available then prioritises Forecast 3 first, then Forecast 2, then Forecast) total for that period. If Forecast is NULL then uses NULL as the total for that period. Sums all periods up to and including the last completed period.
  • Actual + Forecast This Period: If Actuals total for this period is NOT Null, uses Actuals total, otherwise uses Forecast (if Forecast 2/3 is available then prioritises Forecast 3 first, then Forecast 2, then Forecast) total for the period. If Forecast is also NULL then uses NULL as the total for the period.
  • Actual + Forecast To End: “Actual+Forecast to Date” + “Actual + Forecast This Period” + any future forecasts (ie for periods after the current period)