Bulk Lease Accounting Data Import

Lucernex supports bulk updates to your data through the use of import spreadsheets. Import spreadsheets allow you to make necessary data changes quickly and accurately, with prompt feedback from the system if there is an error. In this document, we will discuss the spreadsheets that can be used to update fields that support ASC 840, ASC 842, IFRS 16, and GASB 87 compliance, and how to utilize them.

Download the import spreadsheets for these procedures. These spreadsheets contain tips and sample data to help you with completing them.

Prerequisites and recommendations for importing a spreadsheet

This section contains prerequisites for importing a spreadsheet and recommendations to import spreadsheet data correctly.

Lucernex file import supports XLS, XLSX, and XML format.

Important!

Failure to comply the prerequisites and recommendations in this section, may result in incorrect data in the system.

Prerequisites

System Administrator access to the Import Data page.
Download a new copy of the import spreadsheet to ensure system changes are captured and to avoid carrying over errors from previous data imports.
Give your spreadsheet a unique name so that you can track changes.
Plan large uploads (more than 2,000 rows) after normal business hours.
Test the import in TRAIN before importing to PRODUCTION

Recommendations

Do not change column header names
Do not add new sheets to the spreadsheet
Do not change the name of the spreadsheet tab, unless instructed to do so
Hide columns you do not plan to use, but do not delete them
Ensure the file extension of the import file matches the file type of a supported import file format such as XLS, XLSX, and XML.
To clear a field that currently contains a value in the system, type Null.
To skip entering a value in a field, leave the field in the spreadsheet blank.
Ensure all data exactly matches to avoid the system creating records with incorrect data. For example, contract names must include the same number of spaces.
Entering data on first available row after the header.
Avoid using special characters such as quotes and percentage signs
Enter dates in MM/DD/YYYY format.
To create a record, type FALSE in the Update Only column. To update a record, type TRUE in the Update Only column.
To enter multiple values for column headers with an asterisk * at the end, ensure each value is separated by a comma.

Pre-Import Requirements

Before importing your data, you must meet the following requirements:

The contracts you are configuring for ASC 840, ASC 842, IFRS 16, and GASB 87 must be entered in the system. The required data for your contracts includes:
1. Commencement Dates
2. Expiration Dates
3. Payment Begin Dates
4. Payment End Dates
5. Likely Option Dates
  
  This includes terms, purchase, and cancellation options as well as residual value guarantees.
Your rent schedules must be entered in the system.

Rent schedules should be entered through the Likely End Date.

Look at your rent forecast to make sure your rent is correct and included in all likely periods.
Your Schedule Types must be created and associated with the appropriate Expense Types.

Important!
We recommend that you give your schedule types unique names that distinguish whether the schedule type is an ASC 840, ASC 842, IFRS 16, or GASB 87 schedule.
Your General Ledger Codes must be entered for each Schedule Type.

Enter any other GL coding as required for specific ERPs.
Your Discount Rate must be determined.

The Discount Rate is also known as the Interest Rate or Internal Borrower Rate (IBR).
If you are converting an existing ASC 840 Operating lease to ASC 842, you will need to determine the Cumulative Deferred Balance of the Straight Line schedule as of your Conversion Date.

Your Cumulative Deferred Balance will be included in the adjustment of the Right of Use Asset, and will be entered in the Payments Before Commencement field.
You must know the classification of the leases you want to import.
If they were not included with this document, request the eight spreadsheets described in the Spreadsheets Relevant to Lease Accounting section below.

Spreadsheets Relevant to Lease Accounting

Four import spreadsheets can be used to update data relevant to ASC 840, ASC 842, IFRS 16, and GASB 87.

If you need assistance completing a spreadsheet, contact Accruent Support or your Professional Services representative.

The four data import spreadsheets relevant to lease accounting are:

Accounting Assumptions Spreadsheets

Important!

These spreadsheets must be imported prior to importing the Accounting Schedule spreadsheets.

The contract-level Accounting Assumptions spreadsheet can be used for ASC 842, IFRS 16, and GASB 87 for both the Contract and Equipment Contract modules.

Accounting Assumptions - Contract spreadsheet
Accounting Assumptions - Asset spreadsheet

Accounting Schedule Spreadsheets

Important!

The Accounting Assumptions spreadsheets must be imported prior to importing these spreadsheets.

Do not delete columns in these spreadsheets.

Accounting Schedule - ASC 840 spreadsheet
Accounting Schedule - ASC 842, IFRS 16, GASB 87, Asset spreadsheet

Step 1: Enter and Test Your Accounting Assumptions Data

Once you have met the pre-import requirements, you must enter your contract and asset-level accounting assumptions.

If you are only importing ASC 840 schedules, you can skip this step.

Enter Your Contract Accounting Assumptions

Important!

Remember to always test your data imports in TRAIN. We recommend leaving your accounting assumptions records unlocked when you first upload them. Once you are satisfied with your accounting assumptions records, follow the Lock and Import Your Contract Accounting Assumptions Data procedures below.

To enter your Contract Accounting Assumptions data:

If the Accounting Assumptions - Contract spreadsheet was not given to you along with this guide, request a copy from your account representative.
Save the spreadsheet in a folder on your computer where you will be able to find it if need be in the future.

Important!
We recommend you give your spreadsheet a unique name, so that if you have multiple spreadsheets saved you can differentiate them.
Open the file.

Important!
When you first open the spreadsheet, it will be in Protected View mode. Before you can edit the spreadsheet, you must click Enable Editing in the banner at the top of the spreadsheet.
Enter the data into each column of the Accounting Assumptions - Contract spreadsheet as specified in the Definitions of Data Fields in Accounting Assumptions - Contract Spreadsheet section below.
Make sure you have deleted row 4, which contains tips for populating the spreadsheet.
Save your spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures below.
- If your data import fails, verify the data in your spreadsheet to ensure its accuracy.
- If your data import succeeds, but there are errors in the data, follow the Edit Your Contract Accounting Assumptions Data procedures below.
Once you are satisfied with your import, follow the Lock and Import Your Contract Accounting Assumptions Data procedures below.

Enter Your Asset-Level Accounting Assumptions Data

Important!

Remember to always test your data imports in TRAIN.

If your asset-level accounting assumptions are adjusted in any way, the system will perform two actions prior to generating a new asset accounting schedule:

The system will check to see if you have manually created and locked an ASC 842 Test for the asset and it will check to see if you have entered an accounting method override for the asset.
If neither of these conditions are met, the system will run an ASC 842 Test automatically based upon the new accounting assumptions data when the asset schedule is generated.

To enter your asset-level accounting assumptions data:

If the Accounting Assumptions - Asset spreadsheet was not given to you along with this guide, request a copy from your account representative.
Save the spreadsheet in a folder on your computer where you will be able to find it if need be in the future.

Important!
We recommend you give your spreadsheet a unique name, so that if you have multiple spreadsheets saved you can differentiate them.
Open the spreadsheet.

Important!
When you first open the spreadsheet, it will be in Protected View mode. Before you can edit the spreadsheet, you must click Enable Editing in the banner at the top of the spreadsheet.
Enter the data into each column of the Accounting Assumptions - Asset spreadsheet as specified in the Definitions of Data Fields in the Accounting Assumptions - Asset Spreadsheet section below.
Make sure you have deleted row 4, which contains tips for populating the spreadsheet.
Save your spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures below.
- If your data import fails, verify the data in your spreadsheet to ensure its accuracy.
- If your data import succeeds, but there are errors in the data, follow the Edit Your Asset Accounting Assumptions Data procedures below.

Edit Your Contract Accounting Assumptions Data

Important!

Remember to always test your data imports in TRAIN. We recommend leaving your accounting assumptions records unlocked when you first import them. Once you are satisfied with your accounting assumptions records, follow the Lock and Import Your Contract Accounting Assumptions Data procedures below.

If you find an error in your accounting assumptions data and you want to update your spreadsheet:

Open the spreadsheet that contains the incorrect data.
Save a copy of the spreadsheet with a different name so that you can refer back to the old spreadsheet if necessary.
Delete the rows for the accounting assumptions records you are not going to update.

To delete rows from a Microsoft Excel spreadsheet:
1. Click the row number of the row you want to delete.
  
  You can select multiple rows using this method by clicking and dragging your mouse over multiple row numbers.
  
  Important!
  Do not delete the header rows.
2. Right-click the row.
  
  A menu opens.
3. Select Delete from the field.
  
  The row is deleted.
Change the value in the UpdateOnly column (column A) to TRUE.
Make the necessary corrections.
Save your spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures below.
If your data import fails or has errors, verify the data in your spreadsheet to ensure its accuracy, and repeat steps 1 – 7.
Once you are satisfied with your import, follow the Lock and Import Your Contract Accounting Assumptions Data procedures below.

Edit Your Asset Accounting Assumptions Data

Important!

Remember to always test your data imports in TRAIN.

If you find an error in your asset accounting assumptions data and you want to update your spreadsheet:

Open the spreadsheet that contains the incorrect data.
Save a copy of the spreadsheet with a different name so that you can refer back to the old spreadsheet if necessary.
Delete the rows for the accounting assumptions records you are not going to update.

To delete rows from a Microsoft Excel spreadsheet:
1. Click the row number of the row you want to delete.
  
  You can select multiple rows using this method by clicking and dragging your mouse over multiple row numbers.
  
  Important!
  Do not delete the header rows.
2. Right-click the row.
  
  A menu opens.
3. Select Delete from the field.
  
  The row is deleted.
Change the value in the UpdateOnly column (column A) to TRUE.
Make the necessary corrections.
Save your spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures below.
If your data import fails, verify the data in your spreadsheet to ensure its accuracy, and repeat steps 5 – 8.

Definitions of Data Fields in Accounting Assumptions - Contract Spreadsheet

Note:

The contract-level Accounting Assumptions spreadsheets are the same for both the Contract and Equipment Contract modules.

Column	Field Name	Applies To	Instructions
A	UpdateOnly	All Accounting Methods	Enter False in this field to create a new record in the system. Enter True in this field to update an existing record in the system.
B	RowType	All Accounting Methods	Enter ContractFinancialTest in this column.
C	ClientID	All Accounting Methods	If you have a client ID for this contract, enter the Client ID in this column. Otherwise, leave this field blank.
D	LxRecID	All Accounting Methods	Leave this column blank. The system will populate it for you.
E	ProjectEntityID	All Accounting Methods	Leave this column blank. The system will populate it for you.
F	ContractName	All Accounting Methods	Enter the contract name. It is important that the contract name is formatted exactly as it appears in the system, including any spaces.
G	ContractFinancialTest.CodeAccountingMethodID	All Accounting Methods	For ASC 842: Enter Operating or Finance. For IFRS 16 or GASB 87: Enter Finance.
H	ContractFinancialTest.IsLocked	All Accounting Methods	Enter No to keep this accounting assumptions record locked, or Yes to lock it. We highly recommend you do not lock your accounting assumptions records until you test them in TRAIN and ensure that they are correct. Important! You will need to lock the accounting assumptions record before you can run your schedules. To do so, see the Lock and Import Your Contract Accounting Assumptions Data procedures below.
I	ContractFinancialTest.DiscountRate	All Accounting Methods	Enter the Discount Rate (also known as the Interest Rate or the Internal Borrower Rate [IBR]).
J	ContractFinancialTest.CodeASC842ScheduleID	ASC 842 Only	Enter the name of the ASC 842 Schedule Type associated with the recurring expense and covenants.
K	ContractFinancialTest.CodeIFRS16ScheduleID	IFRS 16 or GASB 87	Enter the name of the IFRS 16 or GASB 87 Schedule Type associated with the recurring expense and covenants.
L	ContractFinancialTest.Topic842BeginDate	ASC 842 Only	Enter the date your organization is adopting ASC 842, or the Possession Begin Date, whichever is later.
M	ContractFinancialTest.Topic842EndDate	ASC 842 Only	Enter the end date of your ASC 842 financial accounting for the contract, including any likely term periods (options).
N	ContractFinancialTest.PurchaseOptionAmount	All Accounting Methods	Leave this field blank. The system will calculate this value.
O	ContractFinancialTest.PVOfPurchaseOption	All Accounting Methods	Enter the present value of the purchase option.
P	ContractFinancialTest.CancellationOptionAmount	All Accounting Methods	Leave this field blank. The system will calculate this value.
Q	ContractFinancialTest.PVOfCancellationOption	All Accounting Methods	Enter the present value of the cancellation option.
R	ContractFinancialTest.PVOfStructuringCosts	All Accounting Methods	Enter any fees paid to the owners of a special-purpose entity for structuring the transaction.
S	ContractFinancialTest.PVOfStructuringCostsDesc	All Accounting Methods	Enter a description of the structuring costs.
T	ContractFinancialTest.ResidualValueGuarantees	All Accounting Methods	Leave this field blank. The system will calculate this value.
U	ContractFinancialTest.PVOfResidualValueGuarantees	All Accounting Methods	Enter the present value of the residual value guarantee.
V	ContractFinancialTest.PVOfOtherAdjustments	All Accounting Methods	Enter any other miscellaneous costs that should be accounted for in the schedule.
W	ContractFinancialTest.PVOfOtherAdjustmentsDesc	All Accounting Methods	Enter a description of the other adjustments.
X	ContractFinancialTest.PreCommencePayAmount	All Accounting Methods	Enter the amount paid towards rent prior to the commencement date, minus any incentives that have reduced the cost of the lease. You should also include your Cumulative Deferred Balance in this value if you are converting from an ASC 840 Straight Line Schedule.
Y	ContractFinancialTest.PreCommencePayDesc	All Accounting Methods	Enter a description of your pre-commencement payments.
Z	ContractFinancialTest.InitialDirectCostsAmount	All Accounting Methods	Enter the incremental costs of a lease that would not have been incurred if the lease had not been obtained. For example, for contracts—broker’s fees, certain legal fees, and certain payments to tenants to move out.
AA	ContractFinancialTest.InitialDirectCostsDesc	All Accounting Methods	Enter a description of the initial direct costs.
AB	ContractFinancialTest.LeaseIncentivesAmount	All Accounting Methods	Enter any incentives that have reduced the cost of the lease.
AC	ContractFinancialTest.LeaseIncentivesDesc	All Accounting Methods	Enter a description of the lease incentives.
AD	ContractFinancialTest.ImpairmentsAmount	All Accounting Methods	Enter any deductions related to the diminished value of the asset.
AE	ContractFinancialTest.ImpairmentsDesc	All Accounting Methods	Enter a description of any impairments.
AF	ContractFinancialTest.CodeAssetTypeTestID	All Accounting Methods	Enter the asset type of the underlying asset.
AG	ContractFinancialTest.DoesTitleRevertToTenant	All Accounting Methods	Enter TRUE if the ownership of the asset reverts to the tenant at the end of the lease term. Otherwise, enter FALSE.
AH	ContractFinancialTest.ContainsBargainPurchaseOption	All Accounting Methods	Enter TRUE if the lease contains a purchase option that the tenant is likely to exercise. Otherwise, enter FALSE.
AI	ContractFinancialTest.RemainingEconomicLifeThreshold	All Accounting Methods	Enter the fraction of the economic life of the underlying asset that amounts to “a major part” of that remaining economic life. This value is usually set to 75%.
AJ	ContractFinancialTest.YearBuilt	All Accounting Methods	Enter the year that the asset's useful life began, or the year the asset was built.
AK	ContractFinancialTest.RemainingLife	All Accounting Methods	Enter the number value of the remaining economic life in this field.
AL	ContractFinancialTest.CodeRemainingLifeFreqUnitID	All Accounting Methods	Enter the frequency unit used to describe the remaining economic life of the asset. Example frequency units are weeks, months, and years.
AM	ContractFinancialTest.FairValueThreshold	All Accounting Methods	Enter the fraction of the fair value of the underlying asset that amounts to “substantially all” of its fair value. This value is usually set to 90%.
AN	ContractFinancialTest.PortionOfAssetControlled	All Accounting Methods	Enter the percentage based upon the rentable area divided by the total area of the asset.
AO	ContractFinancialTest.FairValueOfAsset	All Accounting Methods	Enter the fair value of the asset. FASB 842.10.20 defines fair value as the price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date.
AP	ContractFinancialTest.FairValueSource	All Accounting Methods	Enter the name of the person who assessed the fair value of the asset.
AQ	ContractFinancialTest.IsAssetTooSpecializedForLessor	All Accounting Methods	Enter TRUE if the asset has a specialized use, such as that the lessor will have no alternative use for it. Otherwise, enter FALSE.

Definitions of Data Fields in Accounting Assumptions - Asset Spreadsheet

Most of the fields in this spreadsheet are only applicable to ASC 842; however, the discount rate, accounting begin and end dates, and initial balance adjustment fields are relevant to IFRS 16 and GASB 87.

Column	Field Name	Instructions
A	UpdateOnly	Enter False in this field to create a new record in the system. Enter True in this field to update an existing record in the system.
B	RowType	Leave this column blank. The system will populate it for you.
C	ClientID	If you have a client ID for this asset, enter the Client ID in this column. Otherwise, leave this field blank.
D	LxRecID	Leave this column blank. The system will populate it for you.
E	EntityType	Enter the entity type that this asset is attached to. Assets can belong to the Contract, Facility, or Location tables. If you do not know the entity type, you can leave this field blank. The system will populate this field for you.
F	EntityName	Enter the name of the entity that this asset is attached to. Assets can belong to the Contract, Facility, or Location tables. If you do not know the name of the entity, you can leave this field blank. The system will populate this field for you.
G	Asset.AssetID	Enter the RecID of the asset you want to generate an accounting assumptions record for. You can retrieve this value using a report.
H	Asset.AssetName	Enter the name of the asset in this column. It is important that the asset name is formatted exactly as it appears in the system, including any spaces.
I	Asset.FinancialContractID	Enter the name of the Equipment Contract this asset is associated with in this column. It is important that the equipment contract name is formatted exactly as it appears in the system, including any spaces.
J	Asset.AccountingBeginDate	If applicable, enter the accounting begin date override for the asset in this column. The purpose of this field is to change the accounting begin date that the test and rent schedules will use. If you do not enter override dates, the test and schedules will run based on the dates of the expense schedules for the asset.
K	Asset.AccountingEndDate	If applicable, enter the accounting end date override for the asset in this column. The purpose of this field is to change the accounting end date that the test and rent schedules will use. If you do not enter override dates, the test and schedules will run based on the dates of the expense schedules for the asset.
L	Asset.DiscountRateOverride	If you want to override the discount rate for this asset, enter the discount rate in this column.
M	Asset.CodeAccountingMethodOverrideID	If you want to override the ASC 842 accounting method for the asset, enter either Operating or Finance in this column.
N	Asset.InitialLiabilityBalanceAdjust	Enter any initial liability balance adjustments in this column.
O	Asset.InitialAssetBalanceAdjust	Enter any initial asset balance adjustments in this column.
P	Asset.DoesTitleRevertToTenant	Enter TRUE if the ownership of the asset reverts to the tenant at the end of the lease term, or enter FALSE if it does not.
Q	Asset.IsAssetTooSpecializedForLessor	Enter TRUE in this column if the asset has a specialized use, such that the lessor will have no alternative use for it. If the asset does not have a specialized use, enter FALSE in this column.
R	Asset.FairValueOfAsset	Enter the fair value of the asset into this column.
S	Asset.FairValueSource	Enter the name of the person who assessed the fair value of the asset in this column.
T	Asset.PortionOfAssetControlled	Enter the portion of the asset you control in this column.
U	Asset.RemainingLife	Enter the remaining economic life in this column. You will enter the unit type in column T. For example, if the remaining economic life is 30 years, you would type 30 in this column.
V	Asset.CodeRemainingLifeFreqUnitID	Enter the unit type used to describe the remaining life of the asset. The valid options for this column are: Days Months Quarters Weeks Years

Step 2: Lock and Import Your Contract Accounting Assumptions Data

Once you have verified that your contract accounting assumptions data are correct, you will need to lock and import your contract accounting assumptions records. You will not need to lock your asset accounting assumptions data.

Important!

You can only have one unlocked accounting assumptions record per contract.

Note:

Follow the Import Spreadsheets from the Import Data Page procedures below to import your asset accounting assumptions data.

To lock your accounting assumptions records:

Open your spreadsheet with your accounting assumptions data.

Make sure all the contracts you want to lock are listed in the spreadsheet.
Change the value in the UpdateOnly column to TRUE.
Change the value in the ContractFinancialTest.IsLocked column (column H) to Yes.
Save your spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures below.

Step 3: Enter Your Schedule Data in the Accounting Schedule Spreadsheets

Once you import and lock your accounting assumptions data, you are ready to complete your Accounting Schedule spreadsheets. Much of the data you entered in the Accounting Assumptions spreadsheets will be used in the Accounting Schedule spreadsheets.

Important!

There are two ways to generate an IFRS Operating schedule in Lucernex:

Create a Straight Line schedule.
Create an IFRS schedule with a 0% Discount Rate.

You will need to filter all schedules with the 0% discount rate out of your integrations to your ERP.

To complete the Accounting Schedule spreadsheets:

Request one or both of the following spreadsheets from your Accruent representative:
- Accounting Schedule - ASC 840 spreadsheet
- Accounting Schedule - ASC 842, IFRS 16, GASB 87, Asset spreadsheet
Save your spreadsheet in a folder on your computer where you will be able to find it if need be in the future.
Open the file.

Important!
When you first open the spreadsheet, it will be in Protected View mode. Before you can edit the spreadsheet, you must click Enable Editing in the banner at the top of the spreadsheet.
Enter the data into each column of the spreadsheet as specified in the tables below:
- Definitions of Data Fields in Accounting Schedule - ASC 840 Spreadsheet
- Definitions of Data Fields in Accounting Schedule - ASC 842, IFRS 16, GASB 87, Asset Spreadsheet
Make sure you have deleted row 4, which contains tips for populating the spreadsheet.
Save the spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures below.

Definitions of Data Fields in Accounting Schedule - ASC 840 Spreadsheet

Note:

Asset schedules cannot be straight lined.

Column	Field Name	Instructions
A	UpdateOnly	Enter False in this field to create a new record in the system.
B	RowType	Enter SLSummary in this column.
C	ContractName	Enter the contract name. It is important that the contract name is formatted exactly as it appears in the system, including any spaces.
D	SLSummary.BeginDate	Enter the schedule begin date.
E	SLSummary.EndDate	Enter the schedule end date.
F	SLSummary.CodeSLScheduleID	Enter the appropriate straight line schedule type.
G	SLSummary.BalanceForward	Enter the balance forward.
H	SLSummary.AmortizeAsLumpSum	Enter FALSE in this field.
I	SLSummary.CodeScheduleCreationReasonID	Enter the reason you are creating your schedule. This field is a drop-down field with pre-defined values. Review the available options and select the appropriate one.

Definitions of Data Fields in Accounting Schedule - ASC 842, IFRS 16, GASB 87, Asset Spreadsheet

The following columns appear in the Accounting Schedule - ASC 842, IFRS 16, GASB 87, Asset spreadsheet.

Column	Field Name	Instructions
A	UpdateOnly	Enter False in this field to create a new record in the system.
B	RowType	Enter SLSummary in this column.
C	ClientID	If you have a client ID for this contract, enter the Client ID in this column. Otherwise, leave this field blank.
D	LxRecID	Leave this column blank. The system will populate it for you.
E	ProjectEntityID	Leave this column blank. The system will populate it for you.
F	ContractName	Enter the contract name. It is important that the contract name is formatted exactly as it appears in the system, including any spaces.
G	SLSummary.AssetID	If you are generating equipment schedules, enter the asset ID of the equipment.
H	SLSummary.BeginDate	Enter the begin date of this accounting schedule.
I	SLSummary.EndDate	Enter the end date of this accounting schedule.
J	SLSummary.CodeASC842ScheduleID	Enter the ASC 842 Schedule Type associated with your recurring expense schedule and covenants.
K	SLSummary.CodeIFRS16ScheduleID	Enter the IFRS 16 or GASB 87 Schedule Type associated with your recurring expense schedule and covenants.
L	SLSummary.CodeAccountingMethodID	For ASC 842: Enter Operating or Finance. For IFRS 16 or GASB 87: Enter Finance.
M	SLSummary.CodeScheduleCreationReasonID	Enter the reason you are creating your schedule. This field is a drop-down field with pre-defined values. Review the available options and select the appropriate one.
N	SLSummary.DiscountRate	Enter the Discount Rate (also known as the Interest Rate or the Internal Borrower Rate [IBR]).
O	SLSummary.PVOfOtherAdjustments	Enter any other miscellaneous costs that should be accounted for in the schedule.
P	SLSummary.PVOfStructuringCosts	Enter any fees paid to the owners of a special-purpose entity for structuring the transaction.
Q	SLSummary.PurchaseOptionAmount	Enter the gross value of the purchase option in this column.
R	SLSummary.PVOfPurchaseOption	Enter the present value of the purchase option in this column.
S	SLSummary.CancellationOptionAmount	Enter the gross value of the cancellation option in this column.
T	SLSummary.PVOfCancellationOption	Enter the present value of the cancellation option in this column.
U	SLSummary.ResidualValueGuarantees	Enter the gross value of the residual value guarantee in this column.
V	SLSummary.PVOfResidualValueGuarantees	Enter the present value of the residual value guarantee in this column.
W	SLSummary.PreCommencePayAmount	Enter the amount paid towards rent prior to the commencement date, minus any incentives that have reduced the cost of the lease. You should also include your Cumulative Deferred Balance in this value if you are converting from an ASC 840 Straight Line Schedule.
X	SLSummary.InitialDirectCostAmount	Enter the incremental costs of a lease that would not have been incurred if the lease had not been obtained. For example, for contracts—broker’s fees, certain legal fees, and certain payments to tenants to move out.
Y	SLSummary.LeaseIncentiveAmount	Enter any incentives that have reduced the cost of the lease.
Z	SLSummary.ImpairmentAmount	Enter any deductions related to the diminished value of the asset.
AA	SLSummary.RemeasurementBalanceForward	Leave this field blank. The system will calculate this value.
AB	SLSummary.ProfitAndLossImpact	Leave this field blank. The system will calculate this value.

Step 4: Import Spreadsheets from the Import Data Page

To import your completed spreadsheets:

Click Admin in the toolbar in the upper-right corner of the window.

The System Administrator Dashboard page opens.
Click Import Data link in the Company Administration column.

The Import Data page opens.
Select the On first error option if you want the import to stop when the system encounters the first error, or the Continue till the end option if you want the system to continue the import and give you a list of errors at the end of the import.
Click Browse.

A File Upload dialog box opens.
Select the spreadsheet you want to upload.
Click Open.

The File Upload dialog box closes. The file name populates in the File field.
Click Import.

The spreadsheet begins to upload. Once the upload is complete, the Status bar will read Finished.
If your import fails:
1. Correct the data in your spreadsheet.
2. Save your spreadsheet.
3. Click Reset on the Import Data page where you received the error.
  
  The page refreshes, and the failed import is cleared from the page.
4. Repeat steps 4 – 8 above to import the corrected spreadsheet.

Step 5: View Your Import Results

Once your import is complete, you can view your calculated schedules at the contract level. However, you can also view the results of the import using the Job Log. The Job Log can be accessed from the Job Log tab of the Import Data page, or by clicking the Job Log link on the System Administrator Dashboard.

To view details about an import job:

Click Admin in the toolbar in the upper-right corner of the window.

The System Administrator Dashboard page opens.
Click Job Log link in the Company Administration column.

The Job Log page opens.
To search for a job conducted within a specific date range:
1. Enter the date range you want to the view using the Start Time between fields.
  
  You can also click Calendar to open the Date Picker and select the appropriate date.
2. Click Show Entries.
  
  The page refreshes. The jobs within the specified date range appear on the page.
Click the job you want to view.

The line item expands. High-level details about the job display, including any errors that may have occurred during the import.
Click View link in the Actions column to view more information about the import job.

The View Job Log window opens with more details about the import job.

Step 6: Re-Measure Your Contract-Level Lease Accounting Schedules Using the FASB / IASB Re-Measurement Report

The FASB / IASB Re-Measurement Report template will produce an excel file that can be imported to regenerate schedules that are out of date in bulk. This report template fetches FASB / IASB schedules that have the Recalc?flag set to Yes. This feature will be of high value for clients with a high volume of leases to manage.

Important!

This process for recalculating schedules in bulk requires that all re-measurement values are entered in the spreadsheet. The spreadsheet import will NOT pick up values entered on the Accounting Assumptions page. This means you have a choice for how you want to handle re-measurements:

Either you make changes on the Accounting Assumptions page and then manually recalculate schedules, or
You can use the accounting assumption import spreadsheets above to enter accounting assumptions in bulk, and then recalculate your schedules.

Important!

This report should be used for re-calculation only.

Run the FASB / IASB Re-Measurement Report

The out-of-the-box functionality should be sufficient for most users. Please exercise caution when making changes to this report—particularly to runtime filters—as changes may result in unexpected outputs.

To run the FASB / IASB Re-Measurement report:

Click Reports in the toolbar in the upper-right corner of the window.

The Reports page opens.
Click Create Report.

The Report Builder window opens.
Select the FASB / IASB Re-Measurement Report from the Start from a global report field.
Click Next.

The Step 2 - Geographic restrictions page of the Report Builder opens.
Click Finish.

The Step 9: Modify and Save Report page of the Report Builder opens.
Click Save and Run Report.

The system asks you to select your runtime filters.
Choose between three options:
- Select is any value from the SLSummary.IsASC842Schedule if you want the report to return records for contracts regardless of whether the contract has an associated ASC 842 schedule.
- Select selected from the SLSummary.IsASC842Schedule if you want the report to return records for contracts that have an ASC 842 schedule.
- Select is not selected from the SLSummary.IsASC842Schedule if you want the report to exclude records for contracts that have an ASC 842 schedule.
Choose between three options:
- Select is any value from the SLSummary.IsIFRS16Schedule if you want the report to return records for contracts regardless of whether the contract has an associated IFRS 16 schedule.
- Select selected from the SLSummary.IsIFRS16Schedule if you want the report to return records for contracts that have an IFRS 16 schedule.
- Select is not selected from the SLSummary. IsIFRS16Schedule if you want the report to exclude records for contracts that have an IFRS 16 schedule.
Click Next.

The system generates a Microsoft Excel file.
Save the file to your computer.
Follow the Complete the FASB / IASB Re-Measurement Report Spreadsheet procedures below.

Complete the FASB / IASB Re-Measurement Report Spreadsheet

To complete the FASB / IASB Re-Measurement Report spreadsheet:

Open the spreadsheet file.

Your contract data appears pre-populated in the spreadsheet.

Important!
When you first open the spreadsheet, it will be in Protected View mode. Before you can edit the spreadsheet, you must click Enable Editing in the banner at the top of the spreadsheet.

Note:
Several columns will be pre-populated with data from your existing schedules.

Note:
The Accounting Begin Date is not from the current schedule. Its value is the day after the last posted period end date of the current schedule. If there are no posted periods, this column is empty. The Remeasurement Balance Forward populates when there is a computed value from the last posted record.
If your accounting method has changed, enter either Operating or Finance in Column F, the SLSummary.CodeAccountingMethodID column.
If there is a change in value in the underlying asset, enter either a percentage value or a fixed dollar amount in Column I, the SLSummary.ProfitAndLossImpact column.
If the discount rate has changed, enter the new discount rate in Column K, the SLSummary.DiscountRate column.
Repeat steps 2 – 4 for all records in the spreadsheet.
Save the spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures above.

Step 7: Re-Measure Your Asset-Level Lease Accounting Schedules Using the FASB / IASB Equipment Re-Measurement Report

The FASB / IASB Equipment Re-Measurement Report template will produce an excel file that can be imported to regenerate schedules that are out of date in bulk. This report template fetches FASB / IASB asset schedules that have the Recalc?flag set to Yes. This feature will be of high value for clients with a high volume of leases to manage.

Important!

This report should be used for re-calculation only.

This process for recalculating schedules in bulk requires that all re-measurement values are entered in the spreadsheet. The spreadsheet import will NOT pick up values entered on the Equipment Accounting Assumptions page. This means you have a choice for how you want to handle re-measurements:

Either you make changes on the Equipment Accounting Assumptions page and then manually recalculate schedules, or
You can use the accounting assumption import spreadsheets above to enter accounting assumptions in bulk, and then recalculate your schedules.

Run the FASB / IASB Equipment Re-Measurement Report

Note:

The out-of-the-box functionality should be sufficient for most users. Please exercise caution when making changes to this report as changes may result in unexpected outputs.

To run the FASB / IASB Equipment Re-Measurement report:

Click Reports in the toolbar in the upper-right corner of the window.

The Reports page opens.
Click Create Report.

The Report Builder window opens.
Select the FASB / IASB Equipment Re-Measurement Report from the Start from a global report field.
Click Next.

The Step 2 - Geographic restrictions page of the Report Builder opens.
Click Finish.

The Step 9: Modify and Save Report page of the Report Builder opens.
Click Save and Run Report.

The system runs the report and generates a Microsoft Excel file.
Save the file to your computer.
Follow the Complete the FASB / IASB Equipment Re-Measurement Report Spreadsheet procedures below.

Complete the FASB / IASB Equipment Re-Measurement Report Spreadsheet

To complete the FASB / IASB Equipment Re-Measurement Report spreadsheet:

Open the spreadsheet file.

Your equipment contract asset data appears pre-populated in the spreadsheet.

Important!
When you first open the spreadsheet, it will be in Protected View mode. Before you can edit the spreadsheet, you must click Enable Editing in the banner at the top of the spreadsheet.

Note:
Several columns will be pre-populated with data from your existing schedules.

Note:
The Accounting Begin Date is not from the current schedule. Its value is the day after the last posted period end date of the current schedule. If there are no posted periods, this column is empty. The Remeasurement Balance Forward populates when there is a computed value from the last posted record.
If your accounting method has changed, enter either Operating or Finance in Column F, the SLSummary.CodeAccountingMethodID column.
If there is a change in value in the underlying asset, enter either a percentage value or a fixed dollar amount in Column I, the SLSummary.ProfitAndLossImpact column.
If the discount rate has changed, enter the new discount rate in Column K, the SLSummary.DiscountRate column.
Repeat steps 2 – 4 for all records in the spreadsheet.
Save the spreadsheet.
Follow the Import Spreadsheets from the Import Data Page procedures above.

Bulk Lease Accounting Data Import

Prerequisites and recommendations for importing a spreadsheet

Accounting Assumptions Spreadsheets

Accounting Schedule Spreadsheets

Rate this topic: