Exporting Reports and Postings

Last updated on 2024-12-13

Overview

In the Export workspace, you can:

  • Export postings that have already been created so they can be imported into Lucanet.Financial OLAP Server or other systems.
  • Generate reports for the data recorded in Lease Accounting. The following reports are available:
    • Balance values for reference date — in reporting currency:
      This report provides an overview of the values calculated in Lease Accounting as of the end of the (last) month. Overviews for component events are generated on the effective date (first of the month). This report can be used to compare the figures with the balance sheet, for example.
    • Contract overview:
      The report provides an overview of all the contracts and components that had been entered in Lease Accounting by a set date.

 

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

Creating a Report

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:

  1. Open the Create reports workspace:

    The ‘Create reports’ workspace (example for ‘Contract overview’)
  2. Under Report type, specify the data for which you want to create the report:
    • Select Balance values for reference date — in reporting currency for the subsequent overviews, then specify the Reporting period start date and the required Reference date:
      • 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)
    • If you want an overview of all the existing contracts, select Contract overview and then enter the required Reference date.
  3. Click Generate report.
  • 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 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
Exporting Postings

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

  1. Open the Export postings workspace:

    The ‘Export postings’ workspace
  2. Select the Export date, i.e. the latest date for which you want to export postings. 
  3. 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)__Booking­Voucher_file ID assigned by the Server.xlsx

Viewing and Downloading Created Files

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:

  1. Open the Created files workspace:

    The ‘Created files’ workspace
  2. Select whether you want to view the XLSX files for the reports or for the postings .
  3. On the row for the file you want to download, click the Download icon .

    The file will be saved in your Downloads folder.
Importing Exported Postings into Lucanet.Financial OLAP Server

The structure of an XLSX file with exported postings is designed so that the postings can easily be imported into Lucanet.Financial OLAP Server or other systems, where necessary.

The following columns in the XLSX file are important for allocation when performing an import into Lucanet.Financial OLAP Server:

  • Company Name
  • Contract Number
  • Account Description
  • Movement Type
  • Sum of Amount
  • Posting Group Posting Date 

 

When importing into Lucanet.Financial OLAP Server, we recommend selecting the Excel file type Freely definable layout of the Excel file in the data source. For information on how to import data using this file type, see Importing Data into Reporting Entities.