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 | |
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. | ||
Standard NetSuite search that provides a detail listing of leases that were terminated within the date range selected. | ||
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. | ||
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. | ||
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. | ||
Standard NetSuite search that provides a detail listing of lease additions for the selected date range. | ||
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. | ||
| 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. | |
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | |
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. | ||
Standard NetSuite transaction search that provides a detail listing of vendor bill transactions tagged to leases. Filter for the date/period range desired. | ||
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. | ||
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. | ||
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. | ||
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. | ||
Standard NetSuite search that provides a detail listing of leases ending within 90 days. | ||
Standard NetSuite search that provides a detail listing of leases commenced during the selected period range. | ||
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. | ||
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. | ||
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. | ||
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. | |
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
Report to export go-live (transition) journal entries for the defined period. | ||
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. | ||
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. | ||
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 | Standard NetSuite search that shows the short term and long term portion of the lease liability for all operating and financing leases. | |
138 | 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'.