Contract portfolio overview report
As a GASB user, you can generate the Contract portfolio overview report to get a comprehensive overview of the Disclosure overview and Lease overview reports combined together. You can generate this report for all contract lines that are Active.
Generating the Contract portfolio overview report
Procedure
1. In the Contracts TSI, go to Contracts.
2. On the action panel, click Report.
The Reporting window opens.
3. Click the System reports tab.
4. Select the Contract portfolio overview report.
| The field Maturity - Include remaining periods in selected year allows you to select the desired options (Yes / No). |
◦ If you select No (to exclude), the maturity analysis will exclude the selected financial year.
- Example: 2023 is the selected financial year, setting is No', whatever period start and period end are, maturity analysis starts from 2024.
◦ If you select Yes (to include), the maturity analysis shows the amounts for the remaining periods of the selected financial year (maturity is always about forecasted data).
- Example 1: 2023 is the selected financial year, setting is Yes, period start is 1, period end is 6; maturity analysis displays the amounts for the remaining 6 periods (7 to 12) in 2023 and continue further with 2024.
- Example 2: 2023 is the selected financial year, setting is Yes, period start is 1, period end is 12; maturity will start from 2024 as there are no remaining periods for 2023.
6. Click OK.
7. Select relevant output options. You can Preview & print or Save as your report.
Data in the Contract portfolio overview report
The Contract portfolio overview report contains the following sections and information:
• The first section shows general data such as the financial year, the start and end of the reporting period.
◦ Financial year: the financial year for reporting as selected in the Financial year reporting setting.
◦ Reporting period start: start date of the reporting period, based on the financial year and the Financial period start reporting setting.
◦ Reporting period end: end date of the reporting period, based on the financial year and the Financial period end reporting setting.
Example: Financial year is 2020, from 04/01/2020 to 03/31/2021
Monthly accounting with the following report settings:
Financial start period = 1, Financial end period = 12,
Reporting period start: 4/1/2020, Reporting period end: 3/31/2021.
• Quantitative overview
This section is grouped into four categories: Statement of net position, Statement of changes in net position, Statement of cash flows and Non-lease payments. The overview is split for lessee and lessor.
◦ Statement of net position
The Additions to right-of-use and Reductions of right-of-use fields show the leases that start or end during the reporting period. Additions: the right-of-use of leases not taken into account at the start date of the reporting period. Reductions: the right-of-use of early terminated leases before the end date of the reporting period.
Changing data retrospectively in a closed period results in multiple accounting commitments in the first open accounting period. The amounts of the financial position show the values from either the latest or earliest commitment and not the accumulated values.
◦ Statement of changes in net position and Statement of cash flows
These sections display the sum of all the amounts of regular commitments whose actual start date falls between the accounting period start date and accounting period end date. The Interest expense and Depreciation are based on the actual dates.
◦ Non-lease payments
Guaranteed residual value: displays sum of all guaranteed residual value amounts at the end date of the lease, where the end date matches the reporting period.
Impairment loss: displays the sum of all impairment loss amounts with an impairment date that matches the reporting period.
Termination penalties: displays the sum of all 'reasonably certain' termination option penalty amounts at the end date of the lease, where the end date matches the reporting period.
• Contract disclosure records and Contract disclosure records before start date
For all selected contracts, the disclosure information is available in the section Contract disclosure records before start date (section 5, 6).
The disclosure information is also available in the section Contract disclosure records (section 3, 4) in case the contract start date is later than or equal to the start date of the selected financial year in the report.
The overview is split for lessee and lessor.
• Lease maturity schedule
This section shows an overview in time of the amounts to be paid (lessees) or to be received (lessors) for all active leases. The overview is split for lessee and lessor. It shows the data from the Financial year set in the report settings. Displays the sum of the amounts of the regular commitments whose actual start date falls between the reporting start date and end date. Data is grouped based on the financial year.
• Details
This overview shows data from the start of the reporting period until the end of the lease. Data in the details section of Lease maturity schedule is grouped based on the financial year.
| If you are using multiple currencies, the complete report is displayed for each currency, grouped by currency. |