You can use the Finance Templates section of the Administration module to rename, enable and disable finance categories and change the multiplication factors for each field.
The default finance template is installed when the system is first deployed. You can modify this template using the Finance Templates section. You can also create a new finance template which can then be made available to the Financial Administrators and other users.
To edit the general information:
General Details
Name: The name by which this template will be referred to in the user interface.
E.g. Global Finance Template
Description: Provide greater detail about the template.
Finance Data Entry Fields
Default Finance Edit Mode: The default mode for tracking financial data. You can choose from Monthly, Yearly or Aggregate. If you choose the Yearly mode, and you are tracking finances over 5 years, the user will see five columns (with some potential spill-over based on the specific dates). In the Aggregate mode, users will enter a lump-sum amount.
Allowed Finance Edit Modes: These define the other allowed edit modes. Select from Monthly, Yearly and Aggregate. The default edit mode must be selected. You can also choose to display additional tabs. These additional tabs are displayed only for visual reporting and will be in read-only mode.
Important
If you choose to allow users to enter an aggregate value for the finances, you must specify the Finance Distribution Months (i.e., the entered lump sum value is to be distributed over X months). You can also set a Finance Distribution Repeat Frequency.
The system will allow you to go from the Monthly mode to a Yearly and/or Aggregate modes. You cannot go from a Yearly mode to the Aggregate mode.
Financial Fields
These financial fields are displayed on the Finance Summary page.
Net Present Value (NPV): measures the excess or shortfall of cash flows, in present value (PV) terms, once financing charges are met. By definition, NPV = Present value of net cash flows.
Internal rate of Return (IRR): is the return rate which can be earned on the invested capital, i.e. the yield on the investment. It is defined as any discount rate that results in a net present value of zero of a series of cash flows.
Return on Investment (ROI): is the ratio of money gained or lost on an investment relative to the amount of money invested
Note: Enabling these fields will make them visible to users on the Finance Summary page for each project.
Finance tracking Details
Finance Tracking Months: The number of months for which financial data is to be tracked.
Default Finance Tracking Start Date: The date from which financial tracking should begin. E.g. the Project Start Date or the Planned Project Close Date.
Note: These settings are only defaults and can be changed at the project level.
Enable Finance Tracking Sub-window: Setting this to Yes will allow users to enter financial information within a set time frame within the tracking months. The sub-window can defined only if financial data is being entered in the Monthly mode. A date range and start date for the sub-window must also be defined.
Finance Table - Column Header Labels
Realized Financial Data section: The name of the data field that displays the realized financial details.
UnRealized Financial Data section - Open Projects: The name of the data field that displays the as yet unrealized financial details for projects that are still open. E.g. Forecast
UnRealized Financial Data section - Closed Projects: The name of the data field that displays the unrealized financial details for projects that have been closed E.g. Actual data
Excel Import/Export
Import Finances from MS Excel: Default value for all projects.
View Excel Template ( name_of_file.xls)
Select Excel Template File
Excel template file in sync?: This field refers to the Microsoft Excel file associated with the finance template within EnterpriseTrack. When you change the details of the finance template, you should modify the Excel file, upload it to this page and then set this field to Yes.
Note: If the Excel file is not in sync, users will not be able to import and export financial information from the Finances section within specific projects.
See Also |
Legal Notices
Copyright © 2000, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Monday, March 24, 2014
