Financials: Financial Detailed Export

Modified on Fri, 13 May, 2022 at 8:25 AM

User roles:  ✔ Project Access   ✔ Financial Access

The Financial Detailed Export file is our most used export file as it returns the complete list of forecast, actuals and approved financial records for 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 Detailed Export 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 Detailed Export file.

Field description

Column & Title	Description
LineType	Indicates whether the financial record is a Resource or Non Resource record.
LineSubType	Indicates whether the financial record represents a Forecast, Actuals or Approved amount.
Year	The financial year the financial record is posted to.
FullYearForecast	Indicates if the financial record is included in the project full year forecast.
Month	The month the financial record is posted to.
Date	The date the financial record is posted to.
Project	The project name.
ProjectId	Fluid project unique ID.
ProjectRef	Project external reference.
Phase	N/A
ProjectType	The project type.
PrimaryPM	The primary manager responsible for the project.
PrimaryPMId	Fluid unique identifier for the project primary manager.
PrimaryPMRef	The primary manager's username.
Owner	The owner of the project.
OwnerId	Fluid unique identifier for the project owner.
OwnerRef	The project owner's username.
BusinessOwner	The project business owner.
BusinessOwnerId	Fluid unique identifier for the project business owner.
BusinessOwnerRef	The project business owner's username.
ProjectStatus	The project status.
Resource	The 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.
ResourceId	The 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.
ResourceRef	The 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.
Approver	The 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.
ApproverId	The 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.
ApproverRef	The 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.
Parent	The Top Parent project of the project in the Project Hierarchy.
ParentId	The unique ID of the Top Parent project.
ParentRef	The Top Parent project external reference.
Engagement	The resource engagement type.
Task	This 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.
Hours	This 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.
Allocation	This 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.
Value	The amount value of the financial record in the default currency.
HourlyRate	This column is only applicable to Resource financial records and represents the resource hourly rate.
Detail	This 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.
ExpenseCategory	The expense category of the financial record.
ExpenseType	The expense type of the financial record.
Note	This 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.
ProviderCostCentre	This 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.
ReceiverCostCentre	This 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
ResourceRegion	This column is only applicable to Resource financial records and represents the region of the resource.
ResourceUnit	This column is only applicable to Resource financial records and represents the resource business unit.
TimesheetStatus	This column is only applicable to Resource Actuals records (i.e timesheet records) and represents the timesheet status (Submitted/Approved/Amended/Amend).
Classification	This column is only applicable to Resource financial records and represents the resource rate card.
RecordId	This column is only applicable to Resource Actuals records (i.e timesheet records) and represents the timesheet Fluid ID.
EntryId	This column is only applicable to Resource Actuals records (i.e timesheet records) and represents the time entry (sub-activity) Fluid ID.
MonthlyRate	This column is only applicable to Resource financial records and represents the resource monthly rate.
MonthlyHours	This column is only applicable to Resource financial records and represents the resource hourly rate.
LocalCurrency	The currency the financial record was entered in.
LocalValue	The amount value in the currency the financial record was entered in.
LocalHourlyRate	This represents the resource hourly rate.
RestatedValue	The amount value in the restated currency.
CappedProportion	This 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.
CappedHours	This indicates the number of booked hours that have been billed. This number can be less than the hours that were submitted if the resources are on a capped hour rate card.
CapitalizationId	The capitalisation Fluid record ID. This is only applicable to financial records that are capitalisable.
AmortizationPeriods	The financial record amortisation period.
AmortizationStart	N/A
PercentageAmortized	N/A
AmortizationId	The amortisation Fluid record ID. This is only applicable to financial records that have an amortisation trail.
CapPercentage	The financial record capitalisation percentage. This is only applicable to financial records that are capitalisable.
DirectRate	This 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.
Placeholder	This column is only applicable to Resource financial records and indicates if the resource represents a placeholder resource.
ProjectCategory	The project category.
FundingSource	The project funding source.
ResourceRole	This column is only applicable to Resource financial records and represents the resource profile role
Modified	The date the financial record was last modified.
ModifiedBy	The name of the user who last modified the financial record.
ModifiedById	The Fluid ID of the user who last modified the financial record.
ModifiedByRef	The username of the user who last modified the financial record.
Editors	The project editor.
EditorsId	The project editor's username.
Executive	The project executive.
ExecutiveId	The executive's username.
Portfolio	The project portfolio.
SubPortfolio	The project sub-portfolio.
BZ 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

Financials: Financial Detailed Export

Field description

Column & Title

Description