Transparency of the analytical process

[sadiksojib35]

When analyzing financial statements, it is important to understand how a particular final indicator was obtained. To do this, you need to see what formulas the parameter was calculated by and what afghanistan telegram number database elements it includes. For example, when calculating work in progress at enterprises in the agro-industrial complex, it is necessary to know the growing periods for each type of agricultural product. Based on this, the required amount of fertilizers, energy and water resources of different composition and cost is calculated. As a result of the calculations, production receives the planned number of kilograms of products. Companies find such transparency in Excel.

Specialized systems for financial planning and analytics often do not allow users to view the calculation methodology. Only the IT department has access to it. This increases the number of participants in the process and slows down the speed of employees' work

There are examples when, to check calculations in such closed systems, financial departments had to do double work: fill out reports and plans in the program, and also duplicate everything in Excel. This helped to check whether the formulas were entered into the system correctly, and therefore whether the indicators were calculated correctly. Yes, this way you can detect and correct the error, but it takes too much time.

Related: Top 5 Tips for Modeling Your Business