NetLeaseGo Reporting Overview

Overview

NetLease is bundled with an assortment of reports to support monthly reconciliations, financial reporting, disclosures, and lease administration.

These reports provide practically all of the standard reports customers need to support required disclosures under ASC 842 and IFRS 16, as well as additional reports to support lease management and compliance with key lease disclosure requirements.

Report List


Name

Description


Components of Lease Costs & Impairments Report

Netgain scripted report that provides a summary of lease costs by lease types to support your summary of lease costs disclosures required for your lease financial statement footnotes. Click through balances to obtain underlying balance detail. Filter for the the current reporting period.


Early Terminations

Standard NetSuite search that provides a detail listing of leases that were terminated within the date range selected.


Full Amortization Schedule - IFRS

Standard NetSuite search that provides a detail listing of lease amortization schedules for IFRS (finance only) leases and associated key activity details for the selected date range.


Full Amortization Schedule - Multi-Classification

Standard NetSuite search that provides a detail listing of lease amortization schedules for multi-classification companies (details for both operating, financing, & short-term leases) and associated key activity details for the selected date range. This is very helpful for pro forma or top-side adjustment support.


Full Amortization Schedule - US GAAP

Standard NetSuite search that provides a detail listing of lease amortization schedules for US GAAP (operating, financing, & short-term) leases and associated key activity details for the selected date range.


Lease Additions

Standard NetSuite search that provides a detail listing of lease additions for the selected date range.


Lease Amortization Waterfall Report (Financing)

Netgain scripted subledger report that provides a summarized and drill-down detail of finance leases and associated future amortization and interest expense amounts for the selected period. Drill-down to underlying future expense detail. This is expected to be used as a forward-looking report.



 Lease Balance G/L Roll Forward Report

NOT SUPPORTED IN NETLEASEGO - Netgain scripted transaction report that provides a summary of lease balances and rolls forward activities for the selected period range and provides details of additions, deletions, and other activity. Expand lease categories and types to drill down to underlying transaction detail.   Filter for the desired activity range, which is typically a full reporting period.


Lease Expansion Option

Standard NetSuite search that provides a detail listing of lease expansion options, which can be a required footnote disclosure item. Lease expansion options are added to a lease record by creating a NetLease Contract Provision child record with the Contract Provision Type marked as Lease Expansion Option.


Lease Expense Waterfall Report (Operating)

NOT SUPPORTED IN NETLEASEGO FREE VERSION - Netgain scripted subledger report that provides a summarized and drill-down detail of operating leases and associated future single lease expense amounts for the selected period. Drill-down to underlying future expense detail. This is expected to be used as a forward-looking report.


Lease Expense, Depreciation, Payments & Interest

Standard NetSuite search that provides a summary by lease of activity for the selected period, including payments, expense, and balance adjustments to support journal entry amounts across classifications.


Lease Guarantors

Standard NetSuite search that provides a detail listing of lease guarantors, which can be a required footnote disclosure item. Lease expansion options are added to a lease record by creating a NetLease Contract Provision child record with the Contract Provision Sub-Type marked as Guarantor.


Lease Interest Waterfall Report (Financing)

NOT SUPPORTED IN NETLEASEGO FREE VERSION - Netgain scripted subledger report that provides a summarized and drill-down detail of finance leases and associated future amortization and interest expense amounts for the selected period. Drill-down to underlying future expense detail. This is expected to be used as a forward-looking report.


Lease Liability Transaction Summary - Update?

General Ledger transaction search that provides the lease liability G/L balances through the selected period by lease. These balances should be compared against the NetLease subledger at period-end to ensure all expected transactions and balances per the subledger have been properly reflected in the G/L.   Filter from "blank" through the current reporting period.


Lease Modifications

Standard NetSuite search that provides a detail listing of modifications and associated details for the selected periods.


Lease Payable Clearing Account Reconciliation

NOT SUPPORTED IN NETLEASEGO - Reconciliation report to highlight end-of-period balances in the Lease Liability Clearing Account by Lease. Expected lease payments per NetLease should typically directly offset amounts posted and tagged to leases in Native NetSuite Vendor Bills. Typically filtered by reporting month/period.


Lease Payment Waterfall Report

NOT SUPPORTED IN NETLEASEGO FREE VERSION - Netgain scripted subledger report that provides a summarized and drill-down detail of operating and finance leases and associated future payment amounts for the selected period. Drill-down to underlying future expense detail. This is expected to be used as a forward-looking report.


Lease Payments

Standard NetSuite transaction search that provides a detail listing of vendor bill transactions tagged to leases. Filter for the date/period range desired.


Lease Purchase Options

Standard NetSuite search that provides a detail listing of lease purchase options, which can be a required footnote disclosure item. Lease purchase options are added to a lease record by creating a NetLease Contract Provision child record with the Contract Provision Type marked as Lease Purchase Option.


Lease Renewal Option

Standard NetSuite search that provides a detail listing of lease renewal options, which can be a required footnote disclosure item. Lease renewal options are added to a lease record by creating a NetLease Contract Provision child record with the Contract Provision Type marked as Lease Renewal Option.


Lease Residual Guarantees

Standard NetSuite search that provides a detail listing of lease residual value guarantees and residual value estimates, which can be a required footnote disclosure item. Lease residual value details are added to a lease record within the accounting subtab under the Disclosure Information field group.


Lease Termination Options

Standard NetSuite search that provides a detail listing of lease termination options, which can be a required footnote disclosure item. Lease termination options are added to a lease record by creating a NetLease Contract Provision child record with the Contract Provision Type marked as Lease Termination Option.


Leases Ending Within 90 Days

Standard NetSuite search that provides a detail listing of leases ending within 90 days.


New Leases Commenced

Standard NetSuite search that provides a detail listing of leases commenced during the selected period range.


NetLease Lease Liability Maturity Analysis (Undiscounted)

 Standard NetSuite search that provides a detail listing of future undiscounted lease payments, grouped by lease type and payment year/quarter, which is your primary input to the required lease maturity disclosure. 

Other Lease Contract Provisions

Standard NetSuite search that provides a detail listing of other contract provisions, which are added to a lease record by creating a NetLease Contract Provision child record with the Contract Provision Type marked as Other Contract Provisions.


Renewals Due in 90 Days

Standard NetSuite search that provides a detail listing of lease renewal options due within 90 days. Lease renewal options are set by creating a NetLease Contract Provision child record on a lease with the Contract Provision Sub-Type marked as Lease Renewal Option.


Provisions Due in 90 Days

 

Standard NetSuite search that provides a detail listing of lease provisions with a latest to notify date within 90 days. Lease renewal options are set by creating a NetLease Contract Provision child record on a lease with the Contract Provision Sub-Type marked as Lease Renewal Option.

 

ROU Clearing Account Reconciliation

NOT SUPPORTED IN NETLEASEGO - Reconciliation report to highlight end-of-period balances in the Lease Liability Clearing Account by Lease. Expected lease payments per NetLease should typically directly offset amounts posted and tagged to leases in Native NetSuite Vendor Bills. Typically filtered by reporting month/period.


ROU Ledger Transaction Summary

NOT SUPPORTED IN NETLEASEGO - General Ledger transaction search that provides the ROU G/L balances through the selected period by lease. These balances should be compared against the NetLease subledger at period-end to ensure all expected transactions and balances per the subledger have been properly reflected in the G/L.   Filter from "blank" through the current reporting period.


Short Term Lease Census

Standard NetSuite search that provides a detail listing of leases marked as short-term or low value, which can be a required footnote disclosure item. Leases are marked as short term or low value within the lease record on lease creation within the accounting subtab under the Accounting Overrides field group.





Supplemental Balance Sheet Information

Netgain scripted report that provides a summary of lease balances by lease types to support your supplemental balance sheet disclosures required for your lease financial statement footnotes. Click through balances to obtain underlying balance detail. Filter for the the current reporting period.


Supplemental Cash Flow Information

Netgain scripted report that provides a summary of cash flow information by lease type to support your supplemental cash flow information disclosures required for your lease financial statement footnotes. Click through balances to obtain underlying balance detail. Filter for the current reporting period.


Undiscounted Lease Maturity Waterfall

NOT SUPPORTED IN NETLEASEGO FREE VERSION - Standard NetSuite search that provides a detail listing of future undiscounted lease payments, grouped by lease type and payment year/quarter, which is your primary input to the required lease maturity disclosure.   Filter by periods beginning from the first period after the reporting period.


Variable Lease Term

Standard NetSuite search that provides a detail listing of lease variable lease term details, which include variable rates and non-lease payments, which can be a required footnote disclosure item. Lease variable rate details are added to a lease record within the accounting subtab under the Disclosure Information field group.


Weighted Average Rate Detail Input

Standard NetSuite search that provides a detail listing of leases and rate details from which you can export and recalculate weighted average rate, which are a required footnote disclosure item. Filter by the last full period being reported on.


Weighted Average Rate Summary

Standard NetSuite search that provides a summary calculation of weighted average rate, which are a required footnote disclosure item (valid for single currencies only). Filter by the last full period being reported on.


Weighted Average Term Detail Input

Standard NetSuite search that provides a detail listing of leases, liability balances, and term details from which you can export and recalculate weighted average term, which are a required footnote disclosure item. Filter by the last full period being reported on.


Weighted Average Term Summary

Standard NetSuite search that provides a summary calculation of weighted average term, which are a required footnote disclosure item (valid for single currencies only). Filter by the last full period being reported on.


Journal Entry Report: Go-Live

Report to export go-live (transition) journal entries for the defined period.





NetLease Subledger Period End Balances

 Subledger month-end balance report that highlights subledger balances for the period selected by lease. These amounts should be compared against Lease Liability and the ROU Transaction Summary Reports to validate that the expected balances per the NetLease subledger agree to the G/L. 

Journal Entry Report: Lease Activity

 Periodic report to export lease journal entries for the defined period, including new leases, lease modifications, lease terminations, and amortization entries. For periods longer than 1 month, amounts are summed and presented as a single journal entry. 

Journal Entry Report: LT/ST Reclass

 Scripted report providing the current portion of lease liabilities. Netgain recommends posting as a reversing entry to reclass the current portion of the term lease liability account. 

136

Lease Liability Short Term/Long Term Split

 Standard NetSuite search that shows the short term and long term portion of the lease liability for all operating and financing leases. 

138

Lease Balance Subledger Roll Forward Report

 NOT SUPPORTED IN NETLEASEGO FREE VERSION  - Netgain scripted schedule line report that provides a summary of lease balances and rolls forward activities for the selected period range and provides details of additions, terminations, and other activity. Expand lease types to drill down to underlying schedule line detail. 

 

Favorite Reports

You can check a box on any report record to make this a favorite and have it appear on your favorites list. Please keep in mind that this favorites list is the same for the company and not unique to each individual. 

You can mark a report favorite by editing the record and checking the Favorite box.


You can also edit your favorites by using the edit button on the report list as follows. (Make sure to unselect the edit button on this page as it makes it so the links on this page do not function.)

Report Customization

Each report has an associated report record that provides information about that report and allows it to show in the report list. The reports that come with the bundle are 'standard reports' and will be overwritten upon bundle update. If you would like to customize a report, please take the following steps. 

Process Steps

Step 1:

  • Open the report you would like to customize by selecting the run button on the right side of the report listing.
  • Edit the report by selecting the 'Edit this Search' button at the top of the form. This will be available for all saved search reports. 
  • For scripted reports where this button does not appear, please contact support@netgain.tech for help customizing these reports.

Step 2:

  • After customizing your report, rename the saved search and select 'Save As'. 

Step 3:

  • Go back to the report page and click 'Edit' next to the report you wish to edit. 

Step 4:

  • Save and copy this report record.

Step 5:

  • Choose a name for the new report and update the saved search field and select the updated search that you just created a new version of.

Step 6:

  • Hover over the down arrow and Select 'Save'.




Was this article helpful?