The Source and reclassification menu allows you to view the source data, the balance sheet or the chart of accounts used as input for the analysis, to manage the reclassification of the source in the management schemes and in the statutory scheme, and to view the detailed management schemes .
To understand the importance of the Menu it is necessary to take into account that Leanus allows you to analyze not only the official financial statements but also the analytical or provisional accounting situations.
Each balance sheet or accounting situation (the Source) is automatically (or through user intervention) reclassified on different schedules. The main ones are listed below
Source Reclassification on Management Schemes
Management Schemes mean the Value Added Income Statement and Contribution Margin and the Sources and Uses Balance Sheet
Most of the analyzes are based on management schemes (financial ratios, Leanus score, cash flow statement)
Management reclassification is therefore the most important as it allows for a better interpretation of accounting data, to benchmark with other analyzes even if based on different sources and to develop the business plan.
In the Leanus Balance Sheet Analysis module, it is possible to reclassify the accounting data both automatically and manually. Official sources are automatically reclassified based on a standard reclassification template, while any other source can be manually uploaded and reclassified regardless of language, accounting structure or format.
Source reclassification on Civil Law Scheme
The reclassification on the statutory scheme is useful in cases where a non-standard source is used and it is desired to obtain analyzes that require a statutory scheme as a source (e.g. Crisis Indicators, Range MCC, Statement OIC etc.
The Leanus statutory scheme has the advantage of having a complete structure of all the lines.
Source Reclassification on Other Schemes
Leanus envisages numerous further reclassifications of the source on Other Schemes in use in the banking system or customized according to specific user needs.
To understand the meaning of quadrature checks CLICK HERE
To understand the meaning of “Keep Sign / Invert Sign” CLICK HERE
To view the reclassified data in each balance CLICK HERE
To change the reclassification from the Income Statement or Balance Sheet CLICK HERE
To upload an accounting situation from the Official Registers CLICK HERE
To upload a proprietary account statement to PDF or other formats CLICK HERE
To understand the meaning of asterisked items CLICK HERE
If the financial statements are not complete with debit and credit details (eg Abbreviated Financial Statements) the Source of Employment Balance Sheet cannot be completed without user intervention and will be marked with a "Red" symbol.
Leanus handles most accounting structures developed by major systems, even in PDF. Always try to upload the accounting situation in your possession to check if Leanus is able to process it automatically. Otherwise use the alternative procedures.
Manual reclassification using Model L2 and L2.1 (functions for loading accounting situations not managed automatically by Leanus) is reserved for expert users. If necessary, ask the Service Center for assistance
What are the possible sources?
Any balance sheet or accounting situation in any format (eg XBR extension, XML, XLX, CSV, and others). These types of accounts, just to cite a few examples, include the financial statements downloaded from the Infocamere Business Register (XBR extension), the financial statements downloaded from the main official suppliers (XML), the accounting situations downloaded from the main accounting systems (Ex. XML Zucchetti needle), etc.
What reclassifications can be managed?
- from the Source to the Management Schemes
- from the Source to the Civil Scheme
- from the Source to the diagram AQR extension 1
- from Source to Custom Schemes
Is it always necessary to reclassify manually?
NO. For all sources already "known" to Leanus or for those "saved" by the user, the reclassification of the source on the management schemes and on the statutory scheme takes place automatically upon loading. The user can change the default reclassification at any time.
The reclassification of the Source on the Management Schemes allows to obtain the complete analysis model (CE, SP, RF, Indices, Score, etc)
What are the sources for which it is not necessary to intervene on the reclassification?
- XBR extension
- XML Zucchetti AGO
- CSV Zucchetti OMNIA
- XML Various Italian Suppliers
- XML Various Spanish Suppliers
- XML Hungarian suppliers
- Leanus L1 model
- Patterns AQR extension 1 (excel)
- PDF extracts from main management or applications (PDF Teamsystem, Zucchetti, Galileo, and others)
For all these sources, following the uploading of the prospectus (Analysis Creation / Update Procedures), both the reclassification of the Management schemes and the Statutory scheme are obtained.
When is it necessary to reclassify the source on the management scheme (primary reclassification)?
As indicated in the diagram, the Leanus analysis model (which includes Income Statement, Balance Sheet, Cash Flow Statement, Indices, KPI and much more, both for historical data and for the business plan, the benchmark and the groups) is based on management reclassification.
Therefore, in order to use the Leanus analysis model, the data source must be reclassified on the "management schemes". The control triangle on the left of the Company Name allows you to verify that the analysis model is complete (green). If the data source does not contain all the necessary information (e.g. Abbreviations), it will not be possible to obtain the balancing of the management schemes (red triangle), or the total Sources of the Balance Sheet will not be equal to the total Employment.
When is it necessary to reclassify the source on the statutory scheme?
If an analysis is carried out with a data source "not known to Leanus" it is useful to carry out the reclassification in the statutory scheme for:
- obtain the indicators of the crisis code
- obtain the Cash Flow Statement in OIC
- obtain the calculation of the Band MCC
Once the reclassification of the statutory scheme has been obtained, from the same menu, it is possible to download the XML of each period and reload them. In this way, the automatic reclassification of the management schemes will also be obtained.
What is the quadrature control box for?
The quadrature check boxes guide the user during the manual reclassification of the source or allow to identify some anomalies concerning the source.
The main control concerns the balancing of the Sources-Employment Balance Sheet. If it is not possible to obtain the quadrature, the entire line is highlighted in red; the control triangle is red.
To deepen the logic of operation of the quadrature control box click here
Some useful tips to correctly perform the manual reclassification from the Source to the Management Schemes
Analyzes the management schemes to be used for the reclassification (-> Management Income Statement and -> Source-Employee Balance Sheet)
Remember that the items in the reclassification drop-down menu correspond to the items in the management schedules (-> Management Income Statement and -> Source-Employee Balance Sheet)
Use the asterisked items at the bottom of the drop-down menu to select Net Profit, Net Equity, Total Assets and Total Liabilities.
Remember to click on "Update" after linking the items of the sources to those of reclassification
Remember that the items already reclassified are highlighted in orange; the asterisked items have no effect on the reclassification but are useful for checks and to complete some accessory schedules (eg. Cost of Personnel - Use of Third Party Goods - Costs for Services allow you to complete the Classic Income Statement scheme)
Remember that reclassification affects the entire line
First reclassify the Income Statement; when the net profit present in the source corresponds to the one calculated, proceed with the Balance Sheet
If the source was loaded with an L2 or L3 model, use the asterisked reclassification items to identify the Source data that do not affect the Primary reclassification but are useful for ancillary checks and analyzes (e.g. Net Income, Production Value, Cost of the staff, …)
For the management of signs, remember the conventions of the destination schemes (Purchases, Costs, Taxes, Payables, Other Payables, Funds and Liquidity are all represented with a minus sign)
Use the box above to check for any squaring. The checks indicate that some fields of the reclassification schemes do not contain any values and therefore it is preferable to reclassify them.
Once the complete reclassification has been obtained (green triangle), save the reclassification model. You can reuse it later also for other personal data.
The menu Source and Reclassification forms the heart of Leanus. This is the menu that allows you to link the items of the Source to the Reclassification Schemes
To view the menu, you need to access any company analysis.
Remember that (unless otherwise specified) all Leanus analyzes, indices, automatic evaluations and the entire graphic library are based on the reclassification schemes of the Management Income Statement and the Balance Sheet (Sources - Employment). Therefore, the changes to the reclassification of the Leanus schemes have an impact on all the analyzes present in Leanus, with the exception of those dependent on other models; consequently, the changes to the reclassifications of the other formats (Statutory, AQR extension 1, etc.) they have no impact on the analyzes dependent on the Leanus schemes.
An example of attribution of the reclassification items to a statutory prospectus
Useful tips to learn how to reclassify any source in the correct way
- It's about the Webinars dedicated to the Reclassification on https://www.leanus.it/webinar/
- View the next sections of the manual 5.2.1 - 5.2.10
Reclassification of Management Schemes: The most frequent errors
- Reclassify the Balance Sheet first and then the Income Statement
- Handle the sign the wrong way (See previous section)
- Reclassify in a way false Financial Expenses (go to financial management), Personnel Costs (go to fixed costs)
- Reclassify the Cash with the "+" sign. Liquidity is reclassified under Sources together with Financial Debts. In the Sources-Lending Scheme, Liquidity is shown with a minus sign
Why is it preferable to use the management scheme?
- It can be used for any source regardless of the structure
- It is easier to reclassify than the statutory scheme
- It allows a better reading of the data
- It allows to elaborate benchmarks and business plans
- How to load data without typing any number
- How to reclassify the source in the Income Statement with Value Added and Contribution Margin
- How to reclassify the source in the Balance Sheet to Sources and Use
- How to use the quadrature check box
- How to save / recall saved reclassification templates
- How to complete the Leanus Schemes
- How to handle asterisk entries
- How to view and align the reclassification to your analysis needs