7.4.13. +Upload Financial Statements from other proprietary sources in statutory format (Model L1, L3)
After completing the form L1, L3
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
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 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 (NO 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 NO 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
_________________________________________________________________________________________
NOTES:
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
Insights
Beyond the official balance sheet – how to reclassify provisional data
Post your feedback on this topic.