What's New in Lucanet Lease Accounting

In Lucanet Lease Accounting, the Create reports workspace offers two new report types: Budget plan and Disclosures by component.

The Budget plan report summarizes the right-of-use assets and lease liabilities of the selected reporting entities period by period, from the selected Start of reporting period up to the last calculated month. Under Period length, you can select Month, Quarter, Half-year, or Year. Lease Accounting converts all amounts into the selected Reporting currency. The report contains one row per period, with columns for the development of the right-of-use assets and the lease liabilities.

The Disclosures by component report contains the same values as the Disclosures report and lists the amounts of the individual contract components directly below each total. The cells of the XLSX file contain numeric values, so you can reconcile each total with the sum of the component amounts. The workbook splits the disclosures into separate sheets by section. You can create the report for one reporting entity at a time, while the Disclosures report remains available for several reporting entities.

For details, see Exporting Reports and Postings.

In the Component reversal workspace of Lucanet Lease Accounting, you can now restrict the reversal of all components to a selection of components. When the Reverse all components option is activated, the Contract number, Cost center, and Asset class drop-down lists are available. In each drop-down list, you can select several values by activating their check boxes. Each drop-down list offers only the values that are assigned to the reversible components of the reporting entity. If none of these components is assigned to a cost center, the Cost center drop-down list is disabled.

If you do not select any value, the reversal applies to all reversible components of the reporting entity, as before. Before the reversal starts, a confirmation dialog lists the matching components and indicates which components will be reversed and which will be skipped, together with the reason.

For details, see Reversing Components.

If you use Lucanet Lease Accounting integrated with Consolidation & Financial Planning, the Export postings workspace now offers the latest version of the ETL script that you need to import the Lease Accounting postings into Consolidation & Financial Planning. The Download ETL script button is available to all users who are permitted to export postings. You start the import itself in Consolidation & Financial Planning.

For details, see Exporting Reports and Postings and Importing Lease Accounting Postings into Consolidation & Financial Planning.

In the Automatic data import workspace of Lucanet Lease Accounting, the import of contract components now recognizes the columns of an Excel or CSV file by their technical headers instead of by their position. Both file formats follow the same rules. The order of the columns no longer matters, and you can leave out optional columns that you do not need. Lease Accounting ignores columns with headers that it does not recognize, so your file can also contain additional information. For you, this means that you no longer need to rebuild a spreadsheet to match the full import template before you upload it, for example when the lease data comes from another source in a different column order. The columns that are required for a valid contract component must still be included.

Lease Accounting only recognizes a column if its header matches a technical header of the import template exactly. The technical headers must therefore not be replaced with descriptive text. With the technical headers, the import also accepts columns for fields that could not be imported before. These include the master data dimensions Profit center, Accounting area, and Business unit as well as the fields of the Car fleet and Real estate tabs.

Import files based on the previous templates can still be used. In these files, Lease Accounting continues to read the columns by their position, so the column order must stay unchanged.

A new import template for contract components is available on the Importing Data Automatically page. The template contains all technical headers and a column guide that describes each header and its allowed values.

In Lucanet Lease Accounting, the General configurations workspace in the Settings menu is now called Posting configurations. The workspace still contains the General configuration, View transaction plan, and Upload transaction plan tabs, and its settings are unchanged. The new name describes the purpose of the workspace more clearly, because its settings, such as the transition date and the transaction plan, determine how Lease Accounting creates postings.

For details, see Posting Configurations in Lease Accounting.

In Lucanet Lease Accounting, the Create reports workspace offers a new report of the type Payments overview. The report lists every payment of each contract component in a separate row: every single payment as well as every fixed and variable regular payment, including payments resulting from extension options. Each row contains the contract and component master data and the payment configuration as of the latest financially relevant state on or before the selected Reference date. You can create the report for one or several reporting entities. The amount columns of the XLSX file contain numeric values that you can filter and sum.

For details, see Exporting Reports and Postings.

In the Preview and save postings workspace of Lucanet Lease Accounting, you can now also select the current month or a future month under Preview or save postings up to and preview the postings for this period. For a period that has not ended yet, Lease Accounting translates amounts into the functional currency with the exchange rates of the last completed month.

You can save postings for the current month if none of the selected components requires currency translation. Postings for future months, and current-month postings that require currency translation, are available for preview only: the Save postings button stays disabled until the month is completed.

For details, see Saving Postings.

In the Reverse postings workspace of Lucanet Lease Accounting, you can now reverse the postings of several contract components of a contract at once. The Contract components drop-down list allows multiple selection and offers the All option, which selects all components of the selected contract. If the postings of a component cannot be reversed, Lease Accounting still reverses the postings of the other selected components and reports the failed component with the reason.

Activating the new Reverse in original posting period option makes each reversal posting use the posting period of the original posting. You then do not enter a Reversal posting date.

For details, see Reversing Postings.

The Account balance report of Lucanet Lease Accounting offers the new Aggregate by reporting entity option. When you activate the option, the report contains an additional Reporting entity column and displays the account balances separately for each selected reporting entity. The sum row at the end of the table contains the total across all selected reporting entities. You can combine the option with all other aggregation options and with the report currency.

For details, see Exporting Reports and Postings.

In the Contract components workspace of Lucanet Lease Accounting, the Contract number drop-down list now allows multiple selection and offers the All option. The table then displays the components of all selected contracts of the current reporting entity.

For details, see Creating and Configuring Contract Components.

The new Upload transaction plan tab in the General configurations workspace of Lucanet Lease Accounting lets you upload your own transaction plan as an XLSX or XLS file. The transaction plan applies to all postings saved from then on. Reversal postings follow the transaction plan of the original posting. The Upload history lists all previously active transaction plans for download, including the Lucanet default plan.

Lease Accounting displays a warning if the transaction plan does not cover an asset class type: when you upload the transaction plan, when you create or edit an asset class, and when you preview postings in the Preview & save postings workspace.

The new View transaction plan tab in the General configurations workspace of Lucanet Lease Accounting displays the posting rules of the transaction plan currently in use. For each transaction, the table displays the debit account and the credit account with account number, account name, transaction type, and account type, as well as the posting type and the asset class type. You can filter every column to find specific accounts or transaction types.