Financials: Financial Forecast Only

Modified on Thu, 12 May, 2022 at 6:13 PM

User roles:  ✔ Project Access   ✔ Financial Access   


The Financial Forecast Only file contains the complete list of financial Forecast records for the project and its subprojects posted in the selected date range. 


You can export data for the current financial month, current, previous or next financial or calendar year, or choose a completely custom time span.


The report also includes the reportable custom properties for the project, the resources and the community plan.



  • The Financial Forecast Only file rolls up financial data from all sub projects too. It therefore aggregates the financial records of the projects and its sub projects.
  • Only users with Financial Access permissioning on their account can download the Financial Forecast Only file.



Field description<


Column & Title
Description
A. LineTypeIndicates whether the financial record is a Resource or Non Resource record.
B. LineSubTypeThe value is always set to Forecast in this report.
C. YearThe financial year the financial record is posted to.
D. FullYearForecastIndicates if the financial record is included in the project full year forecast.
E. MonthThe month the financial record is posted to.
F. DateThe date the financial record is posted to.
G. ProjectThe project name.
H. ProjectIdFluid project unique ID.
I. ProjectRefProject external reference.
J. Alternate ReferenceThe alternate unique identifier of the project (different to the project external reference).
K. PhaseN/A
L. ProjectTypeThe project type.
M. PrimaryPMThe primary manager responsible for the project.
N. PrimaryPMIdFluid unique identifier for the project primary manager.
O. PrimaryPMRefThe primary manager's username.
P. OwnerThe owner of the project.
Q. OwnerIdFluid unique identifier for the project owner.
R. OwnerRefThe project owner's username.
S. BusinessOwnerThe project business owner.
T. BusinessOwnerIdFluid unique identifier for the project business owner.
U. BusinessOwnerRefThe project business owner's username.
V. ProjectStatusThe project status.
W. ResourceThe name of the resource the record applies to in the case of Resource financial records. The value is left blank for Non Resource financial records. 
X. ResourceIdThe Fluid unique identifier of the resource the record applies to in the case of Resource financial records. The value is left blank for Non Resource financial records. 
Y. ResourceRefThe username of the resource the record applies to in the case of Resource financial records. The value is left blank for Non Resource financial records. 
Z. ApproverThe name of the manager of the resource the record applies to in the case of Resource financial records. The value is left blank for Non Resource financial records. 
AA. ApproverIdThe Fluid unique identifier for the manager of the resource the record applies to in the case of Resource financial records. The value is left blank for Non Resource financial records. 
AB. ApproverRefThe username of the manager of the resource the record applies to in the case of Resource financial records. The value is left blank for Non Resource financial records. 
AC. ParentThe Top Parent project of the project in the Project Hierarchy.
AD. ParentIdThe unique ID of the Top Parent project.
AE. ParentRefThe Top Parent project external reference.
AF. EngagementThe resource engagement type.
AG. TaskThis column is only applicable to Resource financial records.
  • Resource Forecast record: the value represents the resource role in the community plan.
  • Resource Actuals record: the value represents the timesheet sub activity.
AH. HoursThis column is only applicable to Resource financial records. 
  • Resource Forecast record: the value represents the number of hours forecasted for the month the financial record applied to.
  • Resource Actuals record: the value represents the number of hours booked in the timesheet week.
AI. AllocationThis column is only applicable to Resource financial records. 
  • Resource Forecast record: the value represents the resource monthly allocation to the project.
  • Resource Actuals record: the value represents the allocation equivalent to the number of hours booked in the timesheet week.
AJ. ValueThe amount value of the financial record in the default currency.
AK. RateThis column is only applicable to Resource financial records and represents the resource hourly rate.
AL. DetailThis value differs depending on the financial record type.
  • Non Resource Forecast record: the comment associated to the month forecast. 
  • Non Resource Actuals record: the description associated to the month actuals.
  • Resource Forecast record: the description associated to the resource community plan.
  • Resource Actuals record: the rate card used for the timesheet entry.
AM. ExpenseCategoryThe expense category of the financial record.
AN. ExpenseTypeThe expense type of the financial record.
AO. NoteThis values is only applicable to Actuals financial records.
  • Non Resource Actuals record: the reference of the financial actuals record.
  • Resource Actuals record: the note associated to the timesheet entry.
AP. ProviderCostCentreThis value differs depending on the financial record type.
  • Non Resource Forecast record: N/A
  • Non Resource Actuals record: the provider cost centre of the financial actual record (value that can be set when uploading actuals using the Non Resource Load functionality).
  • Resource Forecast record: the resource cost centre.
  • Resource Actuals record: the resource cost centre.
AQ. ReceiverCostCentreThis value differs depending on the financial record type.
  • Non Resource Forecast record: the project cost centre.
  • Non Resource Actuals record: the receiver cost centre of the financial actual record (this value that can be set when uploading actuals using the Non Resource Load functionality).
  • Resource Forecast record: the project cost centre.
  • Resource Actuals record: N/A
AR. ResourceRegionThis column is only applicable to Resource financial records and represents the region of the resource.
AS. ResourceUnitThis column is only applicable to Resource financial records and represents the resource business unit.
AT. TimesheetStatusThis column is only applicable to Resource Actuals records (i.e timesheet records) and represents the timesheet status (Submitted/Approved/Amended/Amend).
AU. ClassificationThis column is only applicable to Resource financial records and represents the resource rate card.
AV. RecordIdThis column is only applicable to Resource Actuals records (i.e timesheet records) and represents the timesheet Fluid ID.
AW. EntryIdThis column is only applicable to Resource Actuals records (i.e timesheet records) and represents the time entry (sub-activity) Fluid ID.
AX. MonthlyRateThis column is only applicable to Resource financial records and represents the resource monthly rate.
AY. MonthlyHoursThis column is only applicable to Resource financial records and represents the resource hourly rate.
AZ. CurrencyThe currency the financial record was entered in.
BA. LocalValueThe amount value in the currency the financial record was entered in.
BB. RestatedValueThe amount value in the restated currency.
BC. CappedProportionThis column is only applicable to Resource Actuals records and represents the capped percentage that was applied to the timesheet entry. A capped percentage is only applied if the resource is on a capped hours rate card. The capped percentage value is a number between 0 and 1.

This value is defaulted to 1 for all other financial record types.
BD. CapitalizationIdThe capitalisation Fluid record ID. This is only applicable to financial records that are capitalisable.
BE. AmortizationPeriodsThe financial record amortisation period.
BF. AmortizationStartN/A
BG. PercentageAmortizedN/A
BH. AmortizationIdThe amortisation Fluid record ID. This is only applicable to financial records that have an amortisation trail.
BI. CapPercentageThe financial record capitalisation percentage. This is only applicable to financial records that are capitalisable.
BJ. DirectRateThis value differs depending on the financial record type.
  • Non Resource Forecast record: the financial record amount value in the default currency.
  • Non Resource Actuals record: the financial record amount value in the default currency.
  • Resource Forecast record: the monthly rate calculated as: Allocation * Monthly Hours from the resource rate card. 
  • Resource Actuals record: the monthly rate calculated as: Timesheet entry hours * Monthly Hours from the resource rate card.
BK. PlaceholderThis column is only applicable to Resource financial records and indicates if the resource represents a placeholder resource.
BL. ProjectCategoryThe project category. 
BM. FundingSourceThe project funding source.
BN. ResourceRoleThis column is only applicable to Resource financial records and represents the resource profile role
BO. ModifiedThe date the financial record was last modified.
BP. ModifiedByThe name of the user who last modified the financial record.
BQ. ModifiedByIdThe Fluid ID of the user who last modified the financial record.
BR. ModifiedByRefThe username of the user who last modified the financial record.
BS. EditorsThe project editors.
BT. EditorsIdThe editor's username.
BU. ExecutiveThe project executive.
BV. ExecutiveIdThe executive's username.
BW. PortfolioThe project portfolio.
BX. SubPortfolioThe project sub-portfolio.
BY onwards
  • Project custom properties that have been set to Reportable
  • Resource custom properties that have been set to Reportable
  • Community Plan 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article