Financials: Financial Cap Amort Export

Modified on Thu, 12 May 2022 at 06:16 PM

User roles:  ✔ Project Access   ✔ Financial Access   ✔ Financial Administrator

The Financial Cap Amort Export file contains the complete list of financial capitalization and amortization forecast and actuals 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 Cap Amort Export file rolls up financial data from all sub projects too. It therefore lists the capitalization and amortization records of the projects and its sub projects.

The Financial Cap Amort Export file aggregates capitalization and amortization records that apply to the same project and have the same expense category/type, capitalization percentage, capitalization month and amortization period.

The Financial Cap Amort Export file share the same format as the other financial reports in order to ensure consistency across the different reports. However, as this report aggregates financial records in order to reduce the size of the file, quite a few columns are not applicable.

Field description

Column & Title	Description
LineType	Indicates whether the financial record is a Amortized or Capitalized record.
LineSubType	Indicates whether the financial record represents a Forecast or Actuals 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.
Alternate Reference	The alternate unique identifier of the project (different to the 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	N/A
ResourceId	N/A
ResourceRef	N/A
Approver	N/A
ApproverId	N/A
ApproverRef	N/A
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	N/A
Task	N/A
Hours	N/A
Allocation	N/A
Value	The amount value of the financial record in the default currency.
Rate	N/A
Detail	This value indicates whether the capitalized amount is derived from a Forecast or Actuals record.
ExpenseCategory	The expense category of the financial record.
ExpenseType	The expense type of the financial record.
Note	N/A
ProviderCostCentre	N/A
ReceiverCostCentre	The project cost centre.
ResourceRegion	N/A
ResourceUnit	N/A
TimesheetStatus	N/A
Classification	The value indicates whether the amount value was calculated from forecast and actuals records.
RecordId	The Capitalization Fluid record ID.
EntryId	The Capitalization Fluid record ID.
MonthlyRate	N/A
MonthlyHours	N/A
Currency	The currency the financial record was entered in.
LocalValue	The amount value in the currency the financial record was entered in.
RestatedValue	The amount value in the restated currency.
CappedProportion	N/A
CapitalizationId	The capitalisation Fluid record ID. This is only applicable to Capitalized records.
AmortizationPeriods	The financial record amortisation period. The value is set to 0 for Amortized financial records.
AmortizationStart	This value indicates the month the amortization for the associated capitalization record started / will start.
PercentageAmortized	N/A
AmortizationId	The amortisation Fluid record ID.
CapPercentage	The capitalisation percentage that was used to derive the amount of the capitalised record. This is only applicable to Capitalized records.
DirectRate	N/A
Placeholder	The value is always set to False.
ProjectCategory	The project category.
FundingSource	The project funding source.
ResourceRole	N/A
Modified	The date the financial record was last modified.
ModifiedBy	N/A
ModifiedById	N/A
ModifiedByRef	N/A
Editors	The project editors.
EditorsId	The editor's username.
Executive	The project executive.
ExecutiveId	The executive's username.
Portfolio	The project portfolio.
SubPortfolio	The project sub-portfolio.
BX 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