Request Demo

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


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

the numerical values ​​relating to the totals of the accounts (outlined in bold) will be automatically reclassified in the item of the Leanus Schemes indicated in column "H" of the model XLS L1 (Only the lines bordered in black will be automatically reclassified (27, 30, 40, 48, ...))
the numerical values ​​relating to the sub-accounts (NOT edged) will be loaded, displayed in the Data Source but not automatically reclassified; the user can decide how to manage and reclassify them after uploading.
The item code and descriptions NOT need to 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 model in XLSX

Analysis Processing Procedure from Model L1

As indicated above, the L1 Model is particularly useful in cases where you have a statutory financial statement on paper or other format and intend to process it through leanus. In this case (or request the assistance of the Leanus Service Center through the Process from procedure PDF o it is necessary to copy the data on the excel L1 model as described above.

After filling in the L1

Log in to Leanus
Go to Process Analysis / +upload financial statements/from XBR extension, 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



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 Financial Statement Analysis/ from XBR extension, 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


If the original balance sheet is not in statutory format, what should be done?

In that case it is sufficient to use the L2 model. For further information click here


Beyond the official balance sheet – how to reclassify provisional data

Download here the complete index of the Leanus manual



Was it helpful?

Si No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thanks you!
Thank you for your feedback.

Post your feedback on this topic.

Please do not use for support inquiries.
For customer support, contact us here.

Pubblica commento