Exporting Reports and Postings

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

General Functions in Lease Accounting

User Roles in Lease Accounting

All Steps at a Glance

Basic Configuration for Lease Accounting

Selecting a Lessee

Collecting Data

Categorizing Components

Calculating Data

Creating Postings

Reversing Postings

Exporting Reports and Postings

Importing Postings into Consolidation & Financial Planning

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

In the Export workspace, you can:

Generate reports for the data recorded in Lease Accounting. The following reports are available:

Balance values for reference date

Contract overview

Disclosures

Asset register

Account balances

Export postings that have already been created so they can be imported into other systems.

All the reports and postings created can be downloaded separately in the form of an Excel file.

The option to export postings is only available to users with a standalone license for Lucanet Lease Accounting.

If you have a Consolidation & Financial Planning license, you can import the postings created in Lease Accounting directly to Consolidation & Financial Planning using a script.

Reports have several uses; for example, they can provide an overview of the contracts in Lease Accounting or be used to compare the figures calculated by the software solution against the data on the balance sheet.

To generate a report, proceed as follows:

Navigate to Export | Create reports:

Displays the Create reports workspace. The report 'Contract overview' is selected as an example. — Create a report

In the Report type field, select the report type you want to generate from the drop-down list.

The available report types and report-specific additional information are described in the following section.

In the Reporting entities drop-down list, select the reporting entity or entities for which you want to create the report.

The selection of multiple reporting entities is only available for the report types Contract overview, Disclosures, and Balance values for reference date. If you select more than one reporting entity, the data is compiled into one file.

(Optional) Activate the Select report currency option if you want to generate the report in a specific currency, then select the desired currency from the Select currency drop-down list. By default, the currency of the contract component is applied.

Notes:

The

Select report currency

option is available for all report types except

Contract overview

If the

Select report currency

option is not activated, the contract currencies will be applied (i.e., each contract's values appear in its original currency).

Click Generate report. The Report Generation confirmation dialog is displayed:

The 'Report Generation' confirmation dialog is displayed. The Contract overview report is shown as an example. — The 'Report Generation' confirmation dialog

Verify your selection, then click Generate report to start generating the report.

The following report types are available in Lease Accounting:

Report type	Description	Required information
Balance values for reference date	Generates subsequent overviews: • Overview of the Balance values for reference date (end of last month) • Overview of the Component events for the reference date (first of a month)	• Reporting entities • The start of reporting period • Reference date • Report currency
Contract overview	Generates an overview of all the existing contracts	• Reference date
Disclosures	Generates a detailed breakdown of lease liabilities and assets for the selected reporting entity	• Reporting entities • The start of the reporting period • The end of the reporting period • Report currency
Asset register	Generates an overview of all assets and asset-related information	• The end of the reporting period • Report currency
Account balance	Generates an overview of the balances for each account, aggregated by: • Transaction type • Cost center and/or, • Asset class This report allows a reconciliation of the balance in the Lease Accounting database with the balance of the accounts in the balance sheet to make sure that both are in line and postings are complete.	• Posting date from • Posting date to • Aggregate by transaction type/cost center/asset class • Report currency

Notes on creating reports:

The report will be created in XLSX format, and a download link will be added to the Reports section of Created files.

The file name of each report type is structured as follows:

Contract overview

: Contract-Overview_

ID of the lessee (reporting entity)

creation date

creation time

.xlsx

Balance values for reporting date

: Balance-values-for-reference-date_

ID of the lessee (reporting entity)

creation date

creation time

.xlsx

Disclosures:

Disclosures---in-reporting-currency_

name of the lessee (reporting entity)_creation date

creation time

.xlsx

Asset register:

Asset-Register_

ID of the lessee (reporting entity)_creation date_creation time

.xlsx

Account balance:

Aggregated-posting-entries-YTD---account-level_

ID of the lessee (reporting entity)

creation date

creation time

.xlsx

The option to export postings is only available to users with a standalone license for Lucanet Lease Accounting.

To create an Export of the existing postings, proceed as follows:

Open the Export postings workspace:

Select the Export date, i.e. the latest date for which you want to export postings.

Click Export postings.

The export will be created in XLSX format, and a download link will be added to the Postings section of Created files.

The file name is structured as follows: Export date_ Export time_ _ID of the lessee (reporting entity)___BookingVoucher _file ID assigned by the Server. xlsx

The Created files workspace contains download links for all the XLSX files that have been created as described above. It makes no difference which reporting entity you have selected in the function bar, as this area shows the files created for every reporting entity.

To download a file, proceed as follows:

Open the Created files workspace:

Select whether you want to view the XLSX files for the reports or for the postings.

Overview

Creating Reports

Report Types

Exporting Postings

Viewing and Downloading Created Files

Table of Contents

Company

Legal Notice

Exporting Reports and Postings

Overview

Creating Reports

Report Types

Exporting Postings

Viewing and Downloading Created Files

Table of Contents

Related Articles

Company

Legal Notice