Lease Management (LM) Add-In Upload Templates

kiara-sonza

We just have installed the Lease Management (LM) at Children;'s and need to load and test in our Development Environment

Does anyone have  excel add ins for:
LM30 Payment Upload File
LM21 Lease Addition and Adjustments

Thank you in advance,
Stacie

unknown

Hello Stacie,

These are all the fields you will need to map in a Excel file to upload to LM21.



Company LSE-COMPANY

Lease LSE-LEASE

Description LSE-DESCRIPTION

Current Lessor LSE-LESSOR

Payments Per Year LSE-PMTS-PER-YEAR

Invoice Prefix LSE-INV-PREFIX

Payment Timing LSE-PMT-TIMING

First Payment Date LSE-FIRST-PMT-DATE

Lessee Interest Rate LSE-INTEREST-RATE

Implicit Interest Rate LSE-IMPLICIT-RATE

Debt or Expense Account Company LSE-DEBT-COMPANY

Acct Unit LSE-DEBT-ACCT-UNIT

Account LSE-DEBT-ACCOUNT

Sub Acct LSE-DEBT-SUB-ACCT

Debt or Expense Activity Activity LSE-DEBT-ACTIVITY

Acct Category LSE-DEBT-ACCT-CAT

Debt or Expense Allocation Code LSE-DEBT-ALLOC-CD

Interest Account Company LSE-INT-COMPANY

Acct Unit LSE-INT-ACCT-UNIT

Account LSE-INT-ACCOUNT

Sub Acct LSE-INT-SUB-ACCT

Interest Activity Activity LSE-INT-ACTIVITY

Acct Category LSE-INT-ACCT-CAT

Interest Allocation Code LSE-INT-ALLOC-CD

Deferred Rent Account Company LSE-RNT-COMPANY

Acct Unit LSE-RNT-ACCT-UNIT

Account LSE-RNT-ACCOUNT

Sub Acct LSE-RNT-SUB-ACCT

Accrued Rent Account Company LSE-ACC-COMPANY

Acct Unit LSE-ACC-ACCT-UNIT

Account LSE-ACC-ACCOUNT

Sub Acct LSE-ACC-SUB-ACCT



I hope this helps.

Thanks,

Sonia