In the Export workspace of Lucanet Lease Accounting, you can:

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

    • Balance values for reference date
    • Contract overview
    • Disclosures
    • Asset register
    • Account balance
    • Payments overview
  • Export postings that have already been saved so they can be imported into other systems.

All the reports and posting exports can be downloaded separately in the form of an Excel file.

If you use Lucanet Lease Accounting integrated with Consolidation & Financial Planning (CFP), you can import the postings saved in Lease Accounting directly into Consolidation & Financial Planning using a script. In addition, you can export the postings in the Export postings workspace. The export and the import are independent of each other, i.e., exporting the postings does not import the postings into Consolidation & Financial Planning. To transfer the postings, execute the import script in Consolidation & Financial Planning.

In Lucanet Lease Accounting, reports provide an overview of lease contracts, payments, and calculated values. You can also use reports to compare calculated values with the data on your balance sheet.

To generate a report in Lucanet Lease Accounting:

1

Navigate to Export | Create reports:

Shows the 'Create reports' workspace in Lucanet Lease Accounting with the 'Report type' drop-down list set to 'Disclosures', the 'Disclosures' info box, the 'Report parameters' section with the 'Reporting entities' field containing 'Accounting_Area_demo_RE - Accounting Area demo RE', the 'Begin reporting period' and 'End of report period' fields, the 'Select report currency' toggle with the help text 'If this toggle is not activated, the contract currency will be applied.', and the 'Generate report' button. Highlighted in red are the 'Create reports' item in the 'Export' navigation, the 'Report type' field, the 'Select report currency' toggle, and the 'Generate report' button.
Create a report
2

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

For more information about the report types and their parameters, see Report Types.

3

In the Reporting entities drop-down list, select the reporting entity or entities for which you want to create the report. Complete the report-specific parameters described under Report Types, such as the Reference date or the reporting period.

The selection of multiple reporting entities is available for all report types. If you select more than one reporting entity, the data is compiled into one file.

4

(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 and Payments 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).
5

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

Shows the 'Report Generation' confirmation dialog in Lucanet Lease Accounting with the question 'Are you sure you want to generate the report Contract overview for Test_Gmbh - Test_Gmbh?' and the 'Cancel' and 'Generate report' buttons.
The 'Report Generation' confirmation dialog
6

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

The following report types are available in Lucanet Lease Accounting:

Report typeDescriptionReport parameters
Balance values for reference dateGenerates 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)
• The start of reporting period
• Reference date
• Report currency
Contract overviewGenerates an overview of all the existing contracts• Reference date
DisclosuresGenerates a detailed breakdown of lease liabilities and assets for the selected reporting entity• The start of the reporting period
• The end of the reporting period
• Report currency
Asset registerGenerates an overview of all assets and asset-related information• The end of the reporting period
• Report currency
Account balanceGenerates an overview of the balances for each account. You can use the report to reconcile the balances in Lucanet Lease Accounting with your balance sheet and check that postings are complete.

If you activate Aggregate by reporting entity, the report contains a Reporting entity column, separate account rows for each selected reporting entity, and a grand total across the selected reporting entities.
• Posting date from
• Posting date to
• Optional aggregation by transaction type, cost center, profit center, accounting area, business unit, asset class, or reporting entity
• Optional report currency
Payments overviewLists the payment configurations of the contract components in their latest financially relevant state on or before the reference date. Each single payment, each fixed or variable regular payment, and each payment from a reasonably certain extension option occupies a separate row. The report uses the component currencies.• Reference date

Notes on creating reports in Lease Accounting:

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

  • The following examples illustrate the file names of reports in Lucanet Lease Accounting:

    • Contract overview: Contract-Overview_ ID of the lessee (reporting entity)_ creation date_ creation time.xlsx
    • Balance values for reference 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

In Lucanet Lease Accounting, you can export the existing postings for one, several, or all reporting entities in a single export. The export is available with a standalone license for Lucanet Lease Accounting as well as when you use Lucanet Lease Accounting integrated with Consolidation & Financial Planning.

To export postings in Lease Accounting, proceed as follows:

1

Open the Export postings workspace:

Shows the 'Export postings' workspace in Lucanet Lease Accounting with the 'Reporting entities' field containing 'CLONE - Report Account Balanc…' and '+1', the 'Export date' field with the placeholder 'YYYY-MM', the 'File preferences' section with the selected option 'One file for all reporting entities', the option 'Individual files per each reporting entity', and the 'Export postings' button. The navigation displays the 'Components to be posted', 'Create postings', and 'Reverse postings' items under 'Postings' and the 'Create reports', 'Export postings', and 'Created files' items under 'Export'.
The 'Export postings' workspace
2

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 X next to its name.
  • The Reporting entities field is mandatory. If you remove all reporting entities, you cannot start the export.
3

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

4

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.

If you use Lucanet Lease Accounting integrated with Consolidation & Financial Planning, the File preferences options are not available. Lucanet Lease Accounting creates one file per selected reporting entity.

5

Click Export postings. The Export Postings dialog is displayed:

Shows the 'Export Postings' confirmation dialog in Lucanet Lease Accounting with the question 'Are you sure you want to export postings for 2 reporting entities?' and the 'Cancel' and 'Export postings' buttons.
The 'Export Postings' confirmation dialog
6

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 in Lucanet Lease Accounting contains download links for all generated reports and posting exports in XLSX format. The workspace lists the files for every reporting entity, regardless of the reporting entity selected in the function bar.

To download a created file in Lease Accounting, proceed as follows:

1

Open the Created files workspace:

Shows the 'Created files' workspace in Lucanet Lease Accounting with the 'Reports' and 'Postings' tabs and a table with the 'Excel file name' and 'Creation date' columns, listing files such as 'Disclosures---in-reporting-currency_2399309_2025-11-20_11-12.xlsx', 'Contract-Overview_2407060_2025-10-06_12-28.xlsx', and 'Asset-register_2399309_2025-09-08_15-21.xlsx' with a download icon in each row. Highlighted in red are the 'Created files' navigation item, the 'Reports' and 'Postings' tabs, and the download icons.
The ‘Created files’ workspace
2

Select whether you want to view the XLSX files for the Reports or for the Postings.

For postings, the Reporting entities column displays 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.

3

In the row of the file you want to download, click the Download icon Download icon.

The file will be saved in your Downloads folder.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.