+Upload Financial Statements from other proprietary sources in statutory format (Model L1, L3) - User Manual

Main sections of the Manual: Content index | First Access? Basics | Time-saving functions |

In the event that the automatic processing of the accounting situation has not been successful, it is possible to copy the data into specific Excel formats and proceed with the upload.

The L1 Model allows you to copy the balance sheet or accounting situation onto a civil scheme
The L3 Model allows you to copy the financial statements or the accounting situation of a consolidated financial statement onto a statutory scheme relating to consolidated financial statements

Procedure

After completing the form L1, L3 paying attention to the instructions below:

Log in to Leanus
Go to *Process Analysis / +load balance sheets and accounting situations in any format
Click on Select a File (or drag the file to the orange area)
Select the Model L1 file that you have just compiled from your PC and wait for the upload
Click on Import
wait the completion of the operation

What is the L1(and L3) model for?

The L1 model is nothing more than an Excel sheet in which it is possible to copy the balance sheet data in statutory format that you have. The L1 (and L3) model is structured in such a way that, if you respect the compilation notes:

- It is automatically recognized by Leanus
- Automatic reclassification is obtained on loading

In summary, if you have a balance sheet in statutory format that you intend to analyze with Leanus, simply copy it on the L1 model and load it.

To manage a consolidated financial statement, which format should be used?

In the case of consolidated financial statements it is advisable to use the model L3. The operating logics are similar to those relating to the L1 model. The L3 model contains the additional fields that characterize the consolidated financial statements.

How to compile the Model L1 (and L3)

The procedure allows you to prepare a financial statement in statutory format or to carry out the loading and immediate reclassification without any intervention by the user

To fill in the L1 (and L3) form, proceed as follows:

Download the L1 (or L3) Model from Leanus from the Menu + Process Analysis / + Upload Balances

Indicate the name of the firm or firm and the relative tax code; the other fields can be added later

It is advisable to use the correct Tax Code as it could be used for calls to official registers.

Indicate the dates in the format indicated in correspondence with the accounting periods to be processed

Complete the scheme by entering the accounting data

IMPORTANT
the numerical values relating to the account totals (bordered in bold) will be automatically reclassified in the Leanus Schemes item indicated in column “H” of the XLS L1 model (Only the black-bordered lines (27, 30, 40, 48,…) will be automatically reclassified)
the numerical values relating to the sub-accounts (NOT bordered) will be loaded, displayed in the Data Source but not automatically reclassified; the user will be able to decide how to manage and reclassify them after loading.
The voice code and descriptions must NOT be changed
It is possible to insert up to five accounting periods following the syntax 31/12/2016 for the annual periods and 30/06/2019 / (6), 31/12/2019 / (14) for the periods of a number of different months from 12
If possible, avoid decimals as they are truncated during the import phase; in this case add "Rounding" lines at the bottom with values 1, 1, 2 etc.
Avoid replacing the L1 file downloaded from Leanus with a similar template in XLSX format

Analysis Processing Procedure from Model L1

As previously indicated, the L1 Model is particularly useful in cases where you have a civil balance sheet on paper or another format and you intend to process it via leanus. In this case (or you request the assistance of the Leanus Service Center through the Process from PDF procedure or you need to copy the data onto the L1 Excel model as described above.

After filling in the L1

Log in to Leanus
Go to Process Analysis / +load balance sheets / from XBRL, XML, XLS
Click on Select a File (or drag the file to the orange area)
Select the Model L1 file that you have just compiled from your PC and wait for the upload
Click on Import
wait the completion of the operation

_________________________________________________________________________________________

NOTE:

In the case of periods lasting less than one year, insert the number of months in brackets after the year-end date. Ex. 30/06/2017 (6)
If the company is already present, a message will appear indicating the tax code of the person present in the archive. Click on the tax code and repeat the operation through the menu Update Balance Sheet Analysis/ from XBRL, XML, XLS.
A null Credit balance or exceeding the maximum number of analyzes allowed can make it impossible to complete the operation.
Use the procedure L2 to upload free-format accounting data

_________________________________________________________________________________________