Menu: Source and Reclassification - User Manual

Request Demo

Description

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.

Procedure

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

Video pills

(updating)

Dedicated Webinars

Beyond the Official Balance Sheet How to reclassify provisional data - Practical examples

Practical advice

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

Insights

To learn more, please click here

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

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

Learn More

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

The reclassification of a chart of accounts for the analysis of creditworthiness with Leanus