The reclassification of accounting data is a process through which data is organized differently from its original structure, in order to make it more understandable or to adapt it to a specific purpose of analysis.
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.
The 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.
The reclassification of accounting data is an important process for financial analysis, as it allows to obtain a more accurate representation of the financial situation of the company and to make more meaningful comparisons with other companies or with industry benchmarks.
Manual reclassification is reserved for expert users
To learn more, please click here
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
Download here PDF to deepen the MANAGEMENT OF THE SOURCE DATA
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
Post your feedback on this topic.