Introduction to Client Implementation and Data Dictionary

Introduction

Thank you for choosing LeaseAccelerator!

We are excited to work with you so that you can achieve the benefits of the LeaseAccelerator application. This includes meeting your accounting and compliance needs as well as gaining the economic and competitive advantages in managing your lease portfolio. This document is a guide to configuring your LeaseAccelerator application and importing your schedule and asset level data. This information is needed to effectively manage your portfolio and accurately account for your transactions. It is used in conjunction with the Client Workbooks provided by your Client Success Manager or Project Implementation Manager. The workbooks are also available in Alex’s menu or the Success Center.

• LeaseAccelerator Client Information Workbook (CIW)

• LeaseAccelerator Portfolio Intake Workbook (PIW)

Download a PDF version of the Client Implementation guide.

While we believe most of the information contained in this document is self-explanatory, if you have ANY questions, please DO NOT HESITATE to ask. We are here to help you!

The table below lists each of the tabs on the Client Workbooks:

• Self-Service Configuration Import: LeaseAccelerator contains Import features (accessible through the UI) so that the client can directly load configuration settings and table data themselves. This capability is accessed from the NavBar Bulk Import option in LeaseAccelerator.

• Support Required: Importing features have not been deployed, therefore these tabs will require support from LeaseAccelerator.  Please coordinate with your Project Manager when you are ready to load this data.

• User Interface Only: This must be entered through the UI only.

• Portfolio Bulk Import: Clients can directly import individual schedule and asset data into LeaseAccelerator using the bulk import feature. This capability is accessed from the NavBar Bulk Import option in LeaseAccelerator.

Note:

Clients should also review the LeaseAccelerator User Guide - Configuration for required data and processes for establishing the critical elements of the accounting sub-system.

The General Ledger Configuration must be performed through the LeaseAccelerator UI to enable your debits and credits, successfully match your Chart of Accounts, and properly interface with your ERP system.

1. The Geo and Reporting Tabs are for gathering information. The data is entered in the Companies Tab, specifying Geo or Reporting Area in the Company Role Type Drop-down for each required item

Note: Not all fields in this document are required for LeaseAccelerator functionality and accounting. However, please remember that use of all fields will drive the full set of features and functions, thereby increasing the TOTAL VALUE of the system.

Data Dictionary Details

The data dictionary defines each field in the Client Workbooks. The dictionary includes the following information:

• Tab Name

• Column – the position on the tab

• Field Name

• Description

• Validation / Valid Values – defines the verifications that LeaseAccelerator performs when attempting to load the data. If the field is governed by a drop-down in the Excel file, the valid values are listed (or a reference to the detailed list of available values is provided).

• LeaseAccelerator does not allow special characters to be used on either the CIW or PIW for any field.

  Note: Do not use a comma, colon, or semi-colon in Schedule Numbers or GL Coding Conventions. Special Characters, as defined by LeaseAccelerator, include the following:

• Format – the field type and length.

• Required for Initial Data Load – indicates a required entry field to enable LeaseAccelerator to function. These fields are in Red Text in the accompanying Client Workbooks (CIW/PIW).

  • Please note that some fields have conditional requirements where either one field or another is required.  These fields are NOT highlighted in red text. You should note these fields as you read through the guide below.

• Required for Accounting – indicates a field that is required to generate complete, accurate journal entries and accounting reports to meet Monthly Close and Financial Statement disclosures as well as compliance requirements. These fields are in Green Text.

• Lease genre (for PIW) Identifies type of lease that data field supports; EQ = Equipment, RE= Real Estate.

• Fields that are specific to Real Estate leases are in italics.

• Note on Date Formats - Date format requirements are aligned to client’s standard presentation for reporting output. For example, in the US dates are presented MM/DD/YYYY, whereas in Europe dates are presented DD/MM/YYYY. Date format requirements for input are still MM/DD/YYYY.

• The Renewal LRF field on EOT Options should be entered as a decimal. When entering the decimal, the value is multiplied by the OEC to determine the Renewal Payment. Example 1: Renewal payment is 25% of OEC, which should be entered as 0.25. Example 2: Renewal payment is 1.5% of OEC, which should be entered as 0.015.

• The following fields may be entered as either a number with decimal places (##.##) or as a percentage (%): Buyout Ceiling, Buyout Floor, Early Penalty (or Return Fee), Limit Fee, Purchase Amount, and Renewal Payment. If entered as a percentage, the value is divided by 100. Example: Entered as 5.67% = .0567, which may be multiplied by OEC to determine the actual value of the field.

• If copying data from an external system or source, please ensure that the formatting does not change. Certain fields are formatted specifically for system import and any changes may cause errors. LeaseAccelerator suggests using the Paste Special Values functionality in Excel to avoid issues.