User roles: ✔ Project Access ✔ Financial Access
The Full Year Financial Report is our most comprehensive project report as it gives a complete financial view of the project.
Contrary to the Financial Detailed Export that returns the details of each financial records posted in the selected date range, the Full Year Financial Report gives the aggregated view of the project financials, rolling up financials from the sub projects. The report includes among others:
- life to date actuals
- forecast for the remaining duration of the project
- capex and opex forecast and actuals
- estimated project cost at completion
- full year profit and loss
Only users with Financial Access permissioning on their account can download the Full Year Financial Report file. |
Field description
Column & Title | Description |
A. Project | Project name |
B. ProjectId | Fluid project unique ID |
C. ProjectRef | Project external reference |
D. Executive | Project Executive names |
E. Executive Id | Project Executive's IDs |
F. Project manager | Project Manager names |
G. Project manager Id | Project Manager's IDs |
H. Status | Project's status |
I. Tier | Project's tier |
J. PriorYearActuals | Sum of actuals for the previous financial years |
K. YTDCashActual | Current Year Actuals (up to locked month) |
L. LifeToDateActuals | PriorYearActuals + YTDCashActual |
M. ROYCashForecast | Sum of forecast amount for the open months in current financial year |
N. Current Year Cash EAC | Current Year Full Year Forecast i.e. actuals up to locked month + remaining forecast (YTDCashActual + ROYCashForecast) |
O. FY2020 Forecast | Sum of forecast amount for current financial year + 1 |
P. FY2021 Forecast | Sum of forecast amount for current financial year + 2 |
Q. FY2022 Forecast | Sum of forecast amount for current financial year + 3 |
R. FY2023 Forecast | Sum of forecast amount for current financial year + 4 |
S. Total Future Years Remaining Forecast | Sum of next years forecast amount (columns O+P +Q+R+following years) |
T. Total Project EAC | Estimated Project Cost at completion (PriorYearActuals + Current Year Cash EAC + Total Future Years Remaining Forecast) |
U. YTDCapActual | Current Year Capex Actuals |
V. YTDOpexActual | Current Year Opex Actuals |
W. ROYCapForecast | Current Year Remaining Capex Forecast |
X. CYCapEAC | Full Year Capex Forecast (YTDCapActual + ROYCapForecast) |
Y. TotalCapPercentFY | Full Year Capex Forecast / Current Year Full Year Forecast (CYCapEAC / Current Year Cash EAC) |
Z. YTDProjectExpActual | Current Year Project Expense = Current Year Actuals - current year Capex Actuals (YTDCashActual - YTDCapexActual) |
AA. ROYProjectExpForecast | Current Year Remaining Net Cost Forecast = Current Year remaining Forecast - Current Year Remaining Capex Forecast (ROYCashForecast - ROYCapForecast) |
AB. CYProjectExpEAC | Current Year Net Cost Expected at Completion = Full Year Forecast - Full Year Capex Forecast (Current Year Cash EAC - CYCapEAC) |
AC. YTDAmortActual | Current Year Amort Actuals |
AD. ROYAmortForecast | Current Year Amort Forecast |
AE. CYAmortEAC | Full Year Amort Forecast (YTDAmortActual + ROYAmortForecast) |
AF. YTDPandLActual | Current Year Actuals P&L = current year Actuals - (current year Capex Actuals + current year Amort Actuals) |
AG. ROYPandLForecast | Current Year remaining P&L Forecast = current year remaining forecast - (current year Remaining Capex Forecast + current year Amort Forecast) |
AH. CYPandLExpEAC | Full Year P&L = Full Year Forecast - Full Year Capex Forecast + Full Year Amort Forecast |
AI. Release Funding | Life to Date Release Funding |
AJ. Current Year Funding | Current Year Release Funding |
AK. FullFundingVFullActuals | Current Year Funding Balance = Life to Date Release Funding - (Prior year Actuals + current year Actuals) |
AL onwards | Project custom properties that have been set to Reportable |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article