This article explains how to configure the application and the projects in order to generate capitalisation on non resource forecast and actuals.
Metadata configuration
The following upload feeds are available on the financial administration page.
Methodologies, Phases & Tasks
This upload feed is used for:
- Tab 1 - the configuration of the phases for the different project methodologies
- Tab 2 - the capitalisable configuration of timesheet tasks within a project phase.
Only the first tab is relevant to non-resource forecast and actuals capitalisation.
Tab 1 – MethodologyPhaseOrder
This tab should list each methodology with its list of project phases. The order of the phases is specified in the Order column.
When creating a project, you can specify which methodology the project is using. You will then be able to give a start and end date for each of the phases corresponding to the selected methodology as defined in this file.
Field | Notes | Type |
Methodology | Name of project methodology | Text |
Phase | Name of project phase | Text |
Order | Order of project phase within methodology | Number 1-* |
Methodology | Phase | Order |
Waterfall | Planning | 1 |
Waterfall | Initiation | 2 |
Waterfall | Execution | 3 |
Waterfall | Closure | 4 |
Rapid | Intake | 1 |
Rapid | Envisioning | 2 |
Rapid | Elaborating | 3 |
Rapid | Executing | 4 |
Rapid | Closure | 5 |
Expense Types
Capitalisation will only occur if the expense type for the non-resource forecast or actual is set to capitalisable. The amortization trigger and the amortization period need to be set too.
Field | Notes | Type |
CapitalizationPercent | Sets the percentage of the expense value to be used for capitalisation n.b. normally 100% | Number (0 – 100) |
AmortizationTrigger | Options: Immediate / Implementation | Option |
AmortizationPeriod | Number of Months to Amortize n.b if 0 it defaults to project amortisation period for any expenses on that project | Number |
Setting a project for non-resource forecast and timesheet capitalisation
For a project to be capitalisable, the following properties must be set in the Project Details :
- The project must be Cap Eligible
- The project must have an amortization period greater than 0
- A methodology must have been set for the project
- Project phases must have a start and an end date
- The project must have an Implementation date in the future
Capitalisation on non-resource forecast
Capitalisation on resource forecast is calculated nightly.
Non-resource forecast will incur capitalisation if the following conditions are met:
- The project has been set up as described in the previous section
- The forecast expense type has a Capitalisation Percentage greater than 0.
- The month the forecast is posted to falls in the open month period, i.e. is the month has not been locked.
If all above conditions are met, the capitalisation and amortisation amount are calculated as follows:
- if the forecast record was manually entered, the amount is calculated using the capitalisation percentage and amortisation trigger set in the expense type but the project amortisation period.
- if the forecast record was uploaded using the Non Resource Actuals and Forecasts upload functionality, then the amount is calculated using the capitalisation percentage and amortisation period values set in the upload file (the uploaded values override the expense type values).
Capitalisation on non-resource actuals
Capitalisation on non-resource actuals is calculated nightly.
Non-resource actuals will incur capitalisation if the following conditions are met:
- The project has been set up as described in the previous section
- The actuals’ expense type has a Capitalisation Percentage greater than 0
- If Show Actuals with Capex Split feature is turned off, the month in which the actuals are posted to must be in the locked period.
- If Show Actuals with Capex Split feature is turned on, the month in which the actuals are posted to must fall in the locked period plus 1 month (i.e. if the locked period end date is August 2018, the timesheet actuals month must be before October 2018).
- the actual record was uploaded using the Non Resource Actuals and Forecasts upload functionality.
If all above conditions are met, the capitalisation and amortisation amount is calculated using the capitalisation percentage and amortisation period values set in the Non Resource Actuals and Forecasts upload file.
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