NetLease Data Validation

Overview

After the lease information has been entered into the NetLease system, the next step in the implementation process is to review and validate the lease information. The following are recommended pages in NetLease that can be used to validate the data upload. 

Lease List Validation

Navigation: NetLease > Lease Management > Lease List 

This list shows all leases present in the system and can be exported from this page as a CSV, Excel, or PDF file to assist with validation. If fields are desired that are not present in the Default View, these can be added by selecting the Customize View button and selecting them on the Results tab. This list can be useful to validate the following:

  • Number of leases
  • Lease Types
  • Primary Information 
  • Segmentation Data 

Schedule Line Validation

Navigation: NetLease > Lease Management > Schedule Line List 

This list shows all schedule lines for all leases and can be exported from this page as a CSV, Excel, or PDF file to assist with validation. If fields are desired that are not present in the Default View, these can be added by selecting the Customize View button and selecting them on the Results tab. Once exported, this list can be filtered to show all periods for a specific lease or all lease lines for a specific period. This list can be useful to validate the following:

  • Lease Payment Amounts
  • ROU and Lease Liability Values
  • Lease Expense and Amortization Values

Subledger Validation

Navigation: NetLease > Reports > Subledger Reports > NetLease Subledger Period End Balances > Run

This report shows the subledger month-end balance for the period selected by lease. To view for the desired period, select Filters and enter the end date of the period in the To field. This report pulls the information from the schedule line list and is useful to validate the following:

  • ROU Gross and Net Values 
  • Lease Liability Values
  • Current Portion of Lease Liability Value

G/L Validation

Prerequisites: All applicable journal entries must be run to populate G/L Validation reports

Navigation: NetLease > Reports > G/L & Recon Reports

After transactions have been run, the reports in this section can be used to confirm that the G/L accounts are presented as expected. These reports are useful to validate the following:

  • G/L balances through a selected period by lease
  • Period end balances in a specific account
Was this article helpful?