Customer Implementation Guide and Data Dictionary
Customer Implementation
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 real estate portfolio management needs. This document is a guide to configuring your LeaseAccelerator Real Estate Manager application and importing your real estate assets and contract information. This information is needed to effectively manage your portfolio and accurately account for your transactions. It is used in conjunction with the Real Estate Portfolio Intake Workbook (REPIW) provided by your Customer Success Manager or Project Implementation Manager.
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!
Data Dictionary Details
The data dictionary defines each field in the REPIW. 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 the REPIW. 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:
Character |
Character Name |
Character |
Character Name |
Character |
Character Name |
|---|---|---|---|---|---|
& |
Ampersand |
“ |
Double quote |
< |
Less than |
* |
Asterisk |
! |
Exclamation point |
} |
Right curly bracket |
@ |
At |
/ |
Forward slash |
] |
Right square bracket |
\ |
Backward slash |
> |
Greater than |
; |
Semi-colon |
^ |
Caret |
# |
Hash or number sign |
‘ |
Single quote |
, |
Comma |
{ |
Left curly bracket |
~ |
Tilde |
$ |
Dollar sign |
[ |
Left square bracket |
_ |
underscore |
- Format – the field type and length
- Required for Initial Data Load – indicates a required entry field to enable LeaseAccelerator function. These fields are in Gold Text in the accompanying REPIW.
- Please note that some fields have conditional requirements where either one field or another is required. These fields are not highlighted in Gold 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 for leases being synchronized with the core LeaseAccelerator accounting compliance platform.
- Note on Date Formats – Date format requirements are aligned to a customer’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.
- 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.
- The accompanying REPIW is used in conjunctions with the Customer Implementation Guide and Data Dictionary.
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.
We will cover the following configuration and import areas: