Exporting Reports and Postings

Getting Started

Global Functions

Lucanet Lume

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 balance

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 available for all report types except Asset register. 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.

You can export the existing postings for one, several, or all reporting entities in a single export.

To export postings, proceed as follows:

Open the Export postings workspace:

Displays the Export postings workspace with the Reporting entities drop-down list, the Export date field, and the File preferences options. — The 'Export postings' workspace

In the Reporting entities drop-down list, select the reporting entity or entities for which you want to export postings. By default, the reporting entity you are signed in to is preselected.

Notes:

To remove a reporting entity from the selection, click the

next to its name.

The

Reporting entities

field is mandatory. If you remove all reporting entities, you cannot start the export.

Select the Export date, i.e. the latest period (YYYY-MM) for which you want to export postings.

Under File preferences, select how you want to generate the posting files:

One file for all reporting entities

: You receive one file containing the postings for all selected reporting entities.

Individual files per each reporting entity

: You receive a separate file for each selected reporting entity.

Click Export postings. The Export Postings dialog is displayed:

Displays the confirmation dialog for exporting postings, showing the number of reporting entities included in the export. — The 'Export Postings' confirmation dialog

Verify your selection, then click Export postings to start the export.

Notes:

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

You cannot assign custom file names. The file names are generated automatically as follows:

One file for all reporting entities

Export date

Export time

MultipleRE

_BookingVoucher_

file ID assigned by the Server

.xlsx

Individual files per each reporting entity

: each file name includes the ID of the corresponding reporting entity instead of

MultipleRE

, so that you can identify the postings of each entity.

If the export fails for one or more reporting entities, the export continues for the remaining reporting entities. You can still download the files that were exported successfully.

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.

For postings, the Reporting entities column shows which reporting entities are included in each file. To narrow down the list, select one or more entities in the Reporting entities drop-down list above the table.

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