Request Demo

After filling in the L2 form as described:

Log in to Leanus and go in AREA CONFIDENTIAL if required by your profile
Go to *Process Analysis / +Upload financial statements and accounting situations in any format
Click on Select a File to select the L2 model (or drag the file to the orange area)
Click on Import
Wait for the completion of the operation
Manage the reclassification by Source and Reclassification menu or recall a previous reclassification model via the reclassification box

Use this procedure to upload any accounting situation to Leanus through the L2 and L2.1 Models

The difference between the L2 model and the L2.1 model. XNUMX

Use the L2 model if you want to create a new analysis not yet present on Leanus. The L2 model in fact, it allows you to enter personal data (Name, Tax Code, etc) .

If, on the other hand, the registry is already present on Leanus and you want "Update it" by entering new budget annuities you can use both model L2 and model L2.1. The Model L2.1 follows the same logic but NOT REQUIRES the insertion of personal data.

The L2.1 model It can be used only in SECURITY UPDATE TRAINING analysis (not to create a new analysis) . It can be used for any personal data. The non-expert user could use it for a different personal data than the one he intends to update.

Download Model L2 or L2.1

To download Model L2, Go to Process Analysis >> + New Budget Analysis >> format: XBR extension, XML, XLS, XLSX, CSV
To download Model L2.1, Go to + Upload Financial Statements >> format: XBR extension, XML, XLS, XLSX, CSV
Download the Template you wish to use

Fill in form L2 or form L2.1

Download and fill in the L2 or L2.1 form following the instructions (the compilation instructions are shown in both models) .

Enter the Name (for the L2.1 Model which can only be used in “Analysis Update” it is not necessary)
Enter the Tax code (you can enter a fictitious alphanumeric CF. If you enter an existing CF, Leanus will also retrieve the personal data information from the Official Registers)
Enter the date field following the correct syntax indicated in the file and shown in the figure
Copy the list of accounts to import (avoid special characters)
Copy the list of values in text format
Enter a Progressive Item Code corresponding to each account
Check for any error messages
Use the lines 14-27 to enter other details (if known) useful for completing the analysis model through asterisked items

Mistakes to avoid

In Model L2, do not enter the name or the tax code
Do not enter i Voice Codes
Do not enter the accounting period in the format indicated
Do not use twice the same item code

for New Analysis Creation - then for L2 Model Analysis Processing procedure

After filling in the L2 form as described:

Log in to Leanus and go in AREA CONFIDENTIAL if required by your profile
Go to Process Analysis / New Budget Analysis / from XBR extension, XML, XLS
Click on Select a File to select the L2 model (or drag the file to the orange area)
Click on Import
Wait for the completion of the operation
Manage the reclassification by Source and Reclassification menu or recall a previous reclassification model via the reclassification box

The Model L2 is particularly useful in cases where you have a balance sheet or chart of accounts in any format or language, on paper or other format and we intend to process it through Leanus.
It can be used both to Process a new Analysis not present in your List, and to "update an analysis" or to upload new annuities / monthly payments and add them to the existing ones.

_________________________________________________________________________________________

Analysis update already present in your DB - then procedure Analysis Elaboration from Model L2 or L2.1

Log in to Leanus and go in AREA CONFIDENTIAL if required by your profile;
Research the company you intend to upgrade with the accounting situations loaded in the L2 or L2.1 form;
Go to + Upload Financial Statements / from XBR extension, XML, XLS o upload directly from the home page of the company (box at the bottom right);
Click on Select a File to select the L2 / L2.1 model (or drag the file to the orange area);
Click on Import;
Wait for the completion of the operation;
Manage the reclassification by Source and Reclassification menu or recall a previous reclassification model via the reclassification box.

NOTES: A null Credit balance or exceeding the maximum number of analyzes allowed can make it impossible to complete the operation.

STEP 3 Manual Reclassification

Go to Source and Reclassification>> Reclassification Source on Management Schemes (landing page after loading)
Associate with each item that you intend to reclassify corresponding entries of the >Management Income Statement and Sources-Uses Balance Sheet schemes
Click on Update (use the quadrature checkbox to check for errors)
Use the asterisked items to complete the analysis model (lines 10001 – 10011)

First reclassify the Income Statement and check the correspondence between Calculated Profit and Imported Profit. Then the Net Equity, then the Liabilities and finally the Assets
Pay attention to the Management of Signs
Il item code can be a progressive number; we recommend inserting the progression 10, 20, 30… in order to possibly insert additional lines (e.g. 15) ensuring the desired sorting. Do not use the same voice code twice or more.
The description it must not contain special characters (e.g. @ / '# + -); to delete them, replace the indicated characters with a blank space (command find and replace with Excel) .
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 months other than 12.
If possible avoid decimals as they are truncated on import; in this case add lines of "Rounding" basically with values ​​1, 1, 2 etc.
In case you want to view the chart of accounts structure, add it to the description. Example “00001-12 stationery purchase” or use the encoding as a voice code as long as there are no repeated voice codes. (the item code is displayed on Leanus in the reclassification management page) .
To avoid replace the L2 downloaded from Leanus with a similar model in size XLSX.

Insights

Beyond the official balance sheet – how to reclassify provisional data

How to classify 5 financial statements starting from 5 different accounting situations

_________________________________________________________________________

Feedback

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