Initial Data

The initial data import allows users to create and modify application entities within Nakisa Portfolio Management, such as locations, premises, and contracts. Users can also upload their historical data as legacy terms using this template.

Users can choose to have their entities automatically activated by setting the "Status" column in the Excel to "Active". Note that when updating a pre-existing object, you cannot update the status through the initial data import.

Note: When importing a contract when the accounting setting is set to "On" or "Streamlined", users must first create an active master agreement, Nakisa Lease Accounting Suite contract, lease component, and activation group in Nakisa Lease Accounting Suite. Use the generated object IDs in the initial data template in the NfsLink sheet, and they will be linked to the created contract. If the NfsLink and the Terms sheets are uploaded at the same time, the NfsLink sheet takes precedence. Refer to the Nakisa Lease Accounting Suite User Guide for more information on creating and activating Nakisa Lease Accounting Suite objects.

The ID can be found at the top of the screen in Nakisa Lease Accounting Suite:

To import initial data:

Select Initial Data as the Import Type Category.
In the Import Sheets section, select the sheets you would like included in the import template. All sheets are selected by default. Note that some sheets are included by default if they are dependent on another selected sheet and cannot be removed. For example, if the LocationArea sheet is selected, LocationAreaHistory is also selected by default.
Note: If the template is uploaded with sheets that were not selected in the Import Sheets section, the extra sheets are ignored during the import.
Download the template.
Fill out the downloaded Excel file with your information. Red fields are mandatory.
- If you are importing legacy terms:
  - When the accounting setting is set to "On", enter your legacy terms in the "Terms", TermAmounts", and "TermVendor" sheets. These sheets are used for legacy terms only.
  - When the accounting setting is set to "Off", set the "Legacy" field in the "TermAmounts" sheet to "True".
Upload the Excel file and begin the import process.

Note: Entering a non-valid ID will result in an error code stating that the external ID does not exist.