The main range of tasks to be solved:
(Taking into consideration that business language is the accounting)
Setting up the accounting and budgeting as a unite system.
(of transactional systems into a state in which all the data is in machine-readable format.
In short terms (up to 14 days).
Daily cash flow statement in plan-fact.
Statement on financial results.
Preliminary every week or day.
At the end of a month but not later than 10 days in plan-fact
Daily! In the very essence of the state of affairs of a company or group of companies
Reports on sales and others
Daily, on a schedule, upon the occurrence of the event
Including the formats accepted by ВЭБ.РФ, РОСАТОМ и тд.
The price of the consulting depends on the rate of work per hour. This indicator is to be. discussed with the customer but approximate cost is given below:
- Delve into the accounting policy
- Understand the structure of normative-reference information
- Coordinate the range of tasks to be solved
t.₽120 / project
- Setting up the budget progress - 2 weeks
- Budget preparation - 2 weeks
- Budget approval - 0,5 week
t.₽60 / project
- Creating an automatic system of
- generation, mailing,
- and/or publication of
- plan-fact reports:
- CF, PL, BS etc.
t.₽20 / month
- System support
- in the first months of work,
- knowledge transfer (training) of
- the customer’s employees
- on working with scripts
t.₽3 / hour
- Standard work time
On work done:
Hours Of Support
The answers on your possible questions:
Python is the most popular language of scripts which is used and learned.
Any self-respecting young specialist, student, school-boy learns or already knows Python.
Will there be any difficulties with the maintaining the functionality of Python scripts?
Python scripts are prepared with documentation and a full description of what exactly this line of code does. Good documentation of the code will allow you to "read" it and be understandable to any specialist familiar with Python. The logical sequence of the written script fundamentally distinguishes it from Low-code systems or any Excel file with a complex structure of sheets and formulas, which is quite difficult to understand and check.
Why not continue using the proven method of generating reports using only Excel
The speed of processing, generating reports and the ability to automatically repeat procedures in scripts has an incomparable advantage over manual data entry into Excel files.
How will you ensure the receipt of data from 1C knowing about the restriction on the part of 1C?
One of the solutions in order not to violate the legal restrictions imposed by 1C on direct access to data will be the use of connectors or the organization of automatic daily unloading of transactions into any database format.
Who are your competitors?
Systems built on open source ideology always overlap with proprietary software.
Don’t BI systems solve the same problems?
Yes, they do. Big corporations implement and use BI systems. But this requires the purchase or subscription to software and the maintenance of highly paid specialists for one of these systems.
It is necessary to emphasize such an important factor as the format in which you can get the result from the BI system and where it can be sent. Using Python scripts, you won't even have to think about these questions: the format can be any, you can transfer the result to any information transmission channel (email, Telegram, WhatsApp).
Don’t low code platforms do the same thing?
Yes, they do. Only in Python you can "speak" for free, and in order to "communicate" in low code accents, you have to pay rent.
What can interfere with the process?
Hired management of companies who are not always interested in premature or permanent disclosure of their performance indicators.
Economists and financiers who are interested in maintaining the status quo of their current state.
And where is it possible to get more data to start using it??
Data can be obtained from any machine-readable format. For the system to work, machine-readable data is needed: both accounting systems and any computer systems for data management and accumulation. Data sources must be up-to-date and correct. Budgets in the form of tables in Excel are easily transformed into a format convenient for obtaining plan-fact reports in which the actual values are pulled up directly from computer systems of information accumulation.
Short information about me
I have experience in managing the financial unit for more than 19 years (production, development, transport, etc.) at such enterprises as:
Financial director of AEON-Avia
Financial Director of the construction of a methanol plant in Volgograd
Financial director of Moscow river shipping company
Financial director of Volgograd river port
Financial director of South river port of Moscow
The well-known methodological simplicity of financial accounting, planning and reporting contradicts the subjective interest of participants in financial processes. The hired management of companies does not seek to work with owners on the principle of "open book". Performers working with economic and financial indicators are interested in increasing their importance in the flow of processing and providing standard routine reports and presentations. "Increasing importance" leads to complication and delay of simple processes, making interpretations and omissions beneficial to the performer, etc. Corporate culture does not contribute to full transparency of relations between business owners. One of the solutions may be to create a system that collects and provides key information according to specified algorithms..
In recent years, I have been studying and applying open source solutions in Python and came to the conclusion that the combination of finance and IT solutions is inevitable for the successful operation of financial services. The “function” of finance can be easily transformed and automated.
I use open and free Python libraries in my work, which are listed below: