Financials: Financial Detailed Export

Modified on Fri, 13 May 2022 at 08: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
LineTypeIndicates whether the financial record is a Resource or Non Resource record.
LineSubTypeIndicates whether the financial record represents a Forecast, Actuals or Approved amount.
YearThe financial year the financial record is posted to.
FullYearForecastIndicates if the financial record is included in the project full year forecast.
MonthThe month the financial record is posted to.
DateThe date the financial record is posted to.
ProjectThe project name.
ProjectIdFluid project unique ID.
ProjectRefProject external reference.
PhaseN/A
ProjectTypeThe project type.
PrimaryPMThe primary manager responsible for the project.
PrimaryPMIdFluid unique identifier for the project primary manager.
PrimaryPMRefThe primary manager's username.
OwnerThe owner of the project.
OwnerIdFluid unique identifier for the project owner.
OwnerRefThe project owner's username.
BusinessOwnerThe project business owner.
BusinessOwnerIdFluid unique identifier for the project business owner.
BusinessOwnerRefThe project business owner's username.
ProjectStatusThe project status.
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. 
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. 
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. 
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. 
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. 
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. 
ParentThe Top Parent project of the project in the Project Hierarchy.
ParentIdThe unique ID of the Top Parent project.
ParentRefThe Top Parent project external reference.
EngagementThe resource engagement type.
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.
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.
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.
ValueThe amount value of the financial record in the default currency.
HourlyRateThis column is only applicable to Resource financial records and represents the resource hourly rate.
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.
ExpenseCategoryThe expense category of the financial record.
ExpenseTypeThe expense type of the financial record.
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.
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.
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
ResourceRegionThis column is only applicable to Resource financial records and represents the region of the resource.
ResourceUnitThis column is only applicable to Resource financial records and represents the resource business unit.
TimesheetStatusThis column is only applicable to Resource Actuals records (i.e timesheet records) and represents the timesheet status (Submitted/Approved/Amended/Amend).
ClassificationThis column is only applicable to Resource financial records and represents the resource rate card.
RecordIdThis column is only applicable to Resource Actuals records (i.e timesheet records) and represents the timesheet Fluid ID.
EntryIdThis column is only applicable to Resource Actuals records (i.e timesheet records) and represents the time entry (sub-activity) Fluid ID.
MonthlyRateThis column is only applicable to Resource financial records and represents the resource monthly rate.
MonthlyHoursThis column is only applicable to Resource financial records and represents the resource hourly rate.
LocalCurrencyThe currency the financial record was entered in.
LocalValueThe amount value in the currency the financial record was entered in.
LocalHourlyRateThis represents the resource hourly rate.
RestatedValueThe amount value in the restated currency.
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.
CappedHoursThis 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.
CapitalizationIdThe capitalisation Fluid record ID. This is only applicable to financial records that are capitalisable.
AmortizationPeriodsThe financial record amortisation period.
AmortizationStartN/A
PercentageAmortizedN/A
AmortizationIdThe amortisation Fluid record ID. This is only applicable to financial records that have an amortisation trail.
CapPercentageThe financial record capitalisation percentage. This is only applicable to financial records that are capitalisable.
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.
PlaceholderThis column is only applicable to Resource financial records and indicates if the resource represents a placeholder resource.
ProjectCategoryThe project category. 
FundingSourceThe project funding source.
ResourceRoleThis column is only applicable to Resource financial records and represents the resource profile role
ModifiedThe date the financial record was last modified.
ModifiedByThe name of the user who last modified the financial record.
ModifiedByIdThe Fluid ID of the user who last modified the financial record.
ModifiedByRefThe username of the user who last modified the financial record.
EditorsThe project editor.
EditorsIdThe project editor's username.
ExecutiveThe project executive.
ExecutiveIdThe executive's username.
PortfolioThe project portfolio.
SubPortfolioThe 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




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 atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article