Prestima

General provisions

Prestima is the budgeting system and managements of finance of the enterprise focused on increase in effective management of the company.

The Prestima system corresponds to the concept of CPM (Corporate Performance Management) and represents a set of managerial tools for strategic, mid-term and operational financial planning, control and the analysis. The system Zatochennost on the full solution of these tasks provides their optimal solution and real increase in employee performance of economical and financial services, middle managers and top managers of the company. The Prestima system solves problems:

• supports of process of budgeting in the company from design of budget model before drawing up budgets and carrying out the plan-fact analysis;
• effective management of cash flows of the company, including formation of the payment schedule and the actual carrying out payments;
• accounting of agreement settlements and ensuring operating control and analysis of receivables and payables;
• managements of key performance indicators (KPI);
• constructions of forms of the corporate reporting.

Functional modules

The solution of the described tasks is provided by Prestima system modules:

Budgeting. The organization of budget management at the enterprise. Creation of finansovobyudzhetny structure and budget model, formation and approval of planned values of budgets, collection of data on execution of budgets, budget performance monitoring, analysis and forecasting of execution of budgets.

Management of finance. Operational planning and management of financial flows of the enterprise. Planning of expected payments and the expected cash receipts, formation of the payment schedule, status monitoring of checking accounts, management of cash gaps, formation of primary documents on cash flow, control of target use of money.

Agreement settlements. Planning of contract activities, control of accomplishment and payment of obligations, operational accounting of agreement settlements, data analysis under agreements and management of receivables and payables.

Management of performance indicators. Selection, operating control and analysis of key indicators of activity of the enterprise (KPI).

Creation of the reporting. Formation of difficult reports and consolidation of data in the module "Corporate reporting", the analysis of large volume of information in necessary cuts for a long period in the module of development of the OLAP reports.

This functionality of the Prestima system is easily built in an information system of the company, supplementing and expanding possibilities of systems which are already working at the enterprise.

Technical tools

Subject-oriented building tool IS-Builder:

• development and adaptation of the Prestima system. Modification of reference books, documents, forms of planning, reports, calculations using the built-in programming language (ISBL).
• system administrative tools. Utilities of the administrator for adding of users, setup of right of access and a workplace of users, updating of versions, etc.

Integration mechanism. Easy setup periodic or on-line of integration with other systems of the enterprise ("client bank", 1C, etc.).

Means for geographically distributed work. The organization of a single territorialnoraspredelenny system based on secondary servers of replication offline, work of users through terminal and web access.

Optimal system operation will be ensured by observance of technical requirements.  

Description of functioning

Budgeting

Budgeting is the modern management tool directed to creation at the enterprise of a single system of mid-term planning, control and cost analysis, income and financial results.

Budgeting allows to solve the following problems:

• reduction of irrational use of enterprise assets;
• personification of responsibility for observance of planned targets and a deviation from them;
• more exact determination of places of emergence of deviations;
• operational tracking of deviations of the fact from the plan and timely decision making.

The module "Budgeting" of the Prestima system provides the optimal organization of budgeting at the enterprise: a full stroke of mid-term planning from design and structure formation of budgets before carrying out the plan-fact analysis.

Formation of a financial and budget structure

At this stage the financial and budget structure of the company is defined and forms. The centers of the financial responsibility (CFR), i.e. those structural divisions of the enterprise which will directly participate in planning of budgets are selected and to exercise control of their execution. The list of operating and financial budgets (types of budgets) is defined, their structure is set, interrelations between budgets are established.

Budget planning

Collecting of planned data is a basis for formation of budgets. The module "Budgeting" allows to build different planning scenarios of budgets at the enterprise: data collection "from below-up", planning "from top to down", the mixed planning. When planning "from below-up" a basis for drawing up budgets are budget requests of the CFD for planning period. In the module "Budgeting" of the CFD perform input of budget requests in the reference book "Planned Actions" where the planned amounts according to budget items and the expected completion dates of the request are filled.

Consideration and the statement of "Planned actions" is available only to certain specialists of the CFD for whom the corresponding role is defined. Such cast when planning allows to perform already at a validation phase the analysis and control of the requests which arrived from the CFD. The "Planned actions" only approved participate in the subsequent formation of budgets.

Approval and the statement of "Planned actions" can be organized through an electronic document management system, in particular via the DIRECTUM system, using the workflow mechanism.

Essential part of budget items can be planned on the basis of these previous periods (planned or actual) with recalculation on certain coefficients. The module "Budgeting" allows to configure automatic payment of planned values under such articles that substantially accelerates and simplifies process of formation of budgets.

In addition the mechanism of transformation allows to calculate automatically values of articles of one budget on the basis of values of another by the predeterminated rules. So, for example, calculation of values by the budget item of cash flow on the basis of values of budget items of income and expenses is configured.

Further planning and also the analysis and correction of planned values it is performed via the specialized interface – planning forms.

Each form of planning represents several planning levels by which input of planned values is performed (for example, budget items, the CFD, planned actions). The list of the planning levels depends on structure of the budget. Different specialists work at each level according to the appointed access rights. For example, on upper the head of the planning and economic department sees an overall picture. Detailing of data on specific articles by the CFD is the level of the economist in the direction. And for more detailed planning at the level of specialists of the CFD data can be displayed by planned actions.

Forms of planning allow to perform input of values both "from below-up", and "from top to down". When planning "from below-up" input of planned values is performed at the bottom levels of planning and when preserving data are aggregated at top levels. When planning "сверхувниз" planned values are entered at the top level and then consistently distributed on all subordinate planning levels.

From a form of planning of value of budgets can be unloaded in the Excel form and are sent for further approval and signing by the electronic digital signature (EDS) through an electronic document management system.

Execution of budgets

Execution of budgets is a key stage of budgeting. Depending on a source of actual data in the Prestima system the following options of reflection of execution of budgets are possible:

• automatic calculation of the actual values of budgets proceeding from these accounting systems working at the enterprise. The mechanism of integration allows to integrate the Prestima system with any accounting system (for example, "1C:Enterprise 8") that gives the chance to collect data of external systems and to create reports on execution of budgets on their basis;
• operational reflection of execution of budgets in documents of the module "Management of Finance" of the Prestima system;
• manual entry of actual data according to budget items in planning forms (in the absence of the accounting system or impossibility to automatically obtain data from the outside).

Control and analysis of execution of budgets

One of the major budgeting tasks is operating control and the timely analysis of execution of budgets. The Prestima system offers the following instruments of control and the analysis of execution:

• The analytical reports of the module "Budgeting" providing data for the analysis in different cuts. Allow to keep track of dynamics of execution of budgets, to predict execution of budgets, to establish the reasons of deviations of the actual accomplishment of articles from the planned values and to define responsible for the arisen deviations.
• Operating control in reference books and documents of the module "Management of Finance". Allows to reveal and not to allow exceeding of limits of budget items timely.
• Module "Management of Performance Indicators". Allows to calculate automatically control indicators on execution of budgets, to display on "A control panel".

Management of finance

In the conditions of modern instability of one of the key tasks facing the enterprises prevention of cash deficit is. The solution of this task is reached, first of all, by means of competent management of cash flows.

The module "Management of Finance" of the Prestima system allows to organize at the enterprise all cycle of cash management from operational planning of cash flow before registration of all payment types and control of accomplishment of the budget of cash flow (BCF).

Means of the module provide the solution of the following business challenges:

• Support of use in the company of a uniform technique of operational financial planning, including at the enterprises with geographically distributed structure: uniform registration procedure of requests for financing and cash receipts; uniform reconciliation procedures of payments.
• Control of compliance of payments to the approved limit of articles of BDDS: correlation of each payment with the budget item; determination of the admissible amount of exceeding; prevention of superlimit payments.
• Formation of the payment schedule allowing to estimate the expected solvency of the company most effectively to distribute funds of the enterprise, to predict "cash gaps" and to timely make necessary management decisions; control of not registered and overdue payments.
• Registration of all payment types when settlings with the partner organizations: input of primary documents on receipt and leaving of money, the organization of data transmission for cash flow between structural divisions and responsible for processes of operational financial management.
• Organization of collecting of operational data on cash flow: development of mechanisms of data collection upon accomplishment of receipts and payments from different sources (the accounting systems, Client-bank, the tables Excel and Access); determination of algorithms of processing of data retrieveds; formation of uniform forms of the corporate reporting.

Proceeding from what problems need to be solved, as the main business customers of the module top managers, top management of the financial and economic block, specialists of finance division and treasury, heads of the divisions executing a role of the centers of the financial responsibility (CFR) can act.

Operational financial planning

The main objective of operational financial planning - in details to plan cash flows for the short period within BDDS, to accurately define dates of the forthcoming payment for timely receiving raw materials and services, to prevent emergence of penalties, to provide efficiency of activity of the company.

On the basis of a current status of the signed agreements and actual obligations, specialists of the CFD create requests for financing and the expected financial receipts. In these reference books preliminary planning of cash flow is performed, desirable completion dates of requests and the expected terms of receipts are set.

It is provided as manual entry of requests for financing and the expected financial receipts, and their automatic formation proceeding from conditions of the signed agreements. With geographically distributed structure specialists of remote divisions can perform input of requests for financing via the web interface, or by means of terminal access.

Each planned payment or receipt at input can be referred on the relevant article of BDDS. It allows to control quickly compliance of the planned requests for financing and the expected financial receipts to limits of budget items, and in cases of an execution of requests also not to allow extra budget payments. Requests for financing and the expected financial receipts can be connected with electronic documents of the DIRECTUM system which are the bases for the planned payments and receipts (acts, invoices for payment).

In the module the possibility of approval of requests is provided in several stages. For example, according to business processes of the company of the request for financing can undergo intermediate approval / statement before their consideration by the financier. Intermediate approval is available only to specialists (for example, to heads of divisions) for whom the corresponding role is defined. Approval and the approval of requests for financing can be organized through an electronic document management system, in particular via the DIRECTUM system. The request which underwent intermediate approval will be available to further work only to financiers of the enterprise.

Inclusion of the expected financial receipts and the approved requests for financing in the operating plan of cash flow is performed by financiers of the company through the payment schedule. The payment schedule is the main instrument of operational financial planning which is the special interface which will allow to distribute most effectively money to estimate the expected solvency of the company, to predict "cash gaps" and to timely make necessary management decisions.

Depending on degree of detail of the planning accepted at the enterprise, the module offers 2 types of the payment schedule:

• General payment schedule. Allows to obtain summary information on cash flows of the enterprise on days without interpretation on the detailing analysts.

• The detailed payment schedule. Gives the chance to analyze and distribute money on days by articles of BDDS.

The payment schedule allows to exercise control of the plan of the forthcoming payments and receipts for every day as on each checking account and branch, and on the enterprise in general.

Carrying out payments

On the basis of the requests for financing distributed in the payment schedule for the corresponding day on each organization payment orders for money transfer from checking accounts of the enterprise automatically form.

By means of the mechanism of integration of the module "Management of Finance" into the program of Client-Bank the created payment orders can automatically in electronic form be transferred to bank of the enterprise, and information on the registered payments is transferred back to the module.

In addition to carrying out bank payments the module "Management of Finance" allows to register documents on all other payment types (cash desk, securities, offsets). For each accounting document of the module automatic selection of requests for financing and the expected receipts is provided that allows to monitor timely execution of payments and receipts and to quickly adjust the financial plan for the forthcoming period.

Control and analysis

One of the most important stages of management of cash flows of the enterprise is operating control of the current payments and the analysis of execution of the financial plan. The module "Management of Finance" offers the following instruments of control and the analysis of execution of BDDS:

• operating control of the request for financing on compliance to limits of BDDS;
• operating control of "cash gaps" in the payment schedule;
• operating control of exceeding of the amounts of issue documents over the approved requests;
• the analytical reports of the module "Management of Finance" providing data for the analysis in different cuts. Allow to monitor the coming and registered payments, to define deviations of the actual accomplishment of articles of BDDS from the planned values, to reveal responsible for the arisen deviations.

For the analysis and control of cash flow also other system modules of Prestima can be used:

• Module "Management of Performance Indicators". Allows to calculate control indicators on management of finance. Control indicators are updated with the set frequency and brought to "A control panel".
• Module of development of the OLAP reports. Allows to develop and configure the multidimensional tables containing the large volume of the planned and actual data necessary for control and the analysis of financial flows of the company for a big time frame.

Agreement settlements

The business activity of any company is inseparably linked with a contracted work within which operational accounting and control of accomplishment and payment of agreement obligations will be organized, the analysis and the assessment of results is carried out.

The module "Agreement settlements" allows to increase efficiency of the business processes connected with a contracted work at the different enterprises (trade, production, construction, project, etc.) due to automation of the following tasks:

1. The structured accounting of agreements:

• detailed accounting in necessary cuts - the organization, the agreement, a stage, the additional agreement, the order, the nomenclature of the material values (MV) or structure of services, etc.;
• reflection of conditions of obligation fulfillment on agreements (need of prepayment, terms of shipment or payment after delivery, etc.).

2. Operational accounting of accomplishment and payment of agreement obligations:

• accounting of accomplishment and payment of purchase orders, implementation of MTs and services, works on stages of agreements and other accomplishment of obligations for all agreement types (for example, according to loan or leasing agreements);
• formation of data on the planned payments and receipts taking into account conditions of agreements and the current accomplishment of obligations.

3. Control and data analysis under agreements, preparation of the reporting with different detailing of data:

• selection of the supplier or contractor (subcontractor), determination of conditions for signing of the contract with the buyer or the customer on the basis of data on the prices, the previous signed agreements, etc.;
• timeliness and volumes of shipment and payment during the purchasing and implementation of MTs and services, execution of works under agreements and other obligations for all agreement types;
• analysis of receivables and payables: lists of debtors and creditors, reconciliation statements of calculations, etc.;
• registers of delivery notes, acts, invoices, payment documents, reports on accomplishment of agreement obligations, etc.

Proceeding from what problems need to be solved, as the main business customers of the module the divisions conducting a contracted work (department of supply, sales office, planovoproizvodstvenny, estimate and contractual department, etc.), finance division, top managers can act.

Maintaining register of agreements

One of key tasks of management of agreement settlements is formation of uniform base of all agreements signed at the enterprise. At the same time for conducting management accounting reflection of the details corresponding to specifics of contract activities is relevant for the subsequent data analysis in necessary cuts. For example, within the agreement the stages which are characterized by the work content, terms and cost can be selected.

When accounting purchase agreements or implementation of MTs and services existence of the additional agreements and specific orders reflecting the specification on shipment of MTs or rendering services in addition can be considered.

Reflection of conditions and terms of shipment and payment under the agreement allows to create automatically further data on the planned payments and receipts, to control and analyze timeliness and completeness of obligation fulfillment.

When using at the enterprise for preparation, approval and storage of contractual documents of an electronic document management system (for example, DIRECTUM) at the expense of the mechanism of integration the organization of information exchange and data access is possible. For example, from the Prestima system the addressing texts and the scan images of agreements in an electronic document management system.

Accomplishment and payment under agreements

In the course of obligation fulfillment under the agreement in a system all primary finance documents (delivery notes, acts of the performed works, invoices, payment documents, etc.) with indication of all necessary details quickly form. For example, at shipment of MTs in addition to the agreement the additional agreement, the order, the nomenclature can be specified, and when working – agreement stages.

In a system conditions of agreement settlements are automatically checked and data on the planned payments or receipts form. For example, when preserving the document on shipment by the supplier of MTs creation of the request for financing in the module "Management of Finance" is offered if in the order it is specified that payment is made after shipment of MTs.

Data on payment under agreements by stages, doposglasheniye, orders can automatically form on the basis of payment documents of the module "Management of Finance" where cash flow on all payment types is reflected (bank, cash desk, securities, offset).

Due to use of the mechanism of integration the documents created in a system can automatically be unloaded in the system of accounting for an exception of duplication of data and reduction of errors.

Control and data analysis under agreements

One of the most important results of automation of contract activities is the possibility of operating control and data analysis under agreements.

The module "Agreement settlements" using analytical reports allows:

• pick up the supplier, define conditions for signing of the contract with the buyer on the basis of information in price lists, earlier signed agreements, the issued orders;
• keep track of timeliness and volumes of shipment and payment under agreements on the basis of the specified conditions of calculations, documents on accomplishment and payment of obligations;
• create reports for the analysis of settlings with the organizations: summary or separately under the agreement, purchases or sales.

Besides, the Prestima system offers the following add-on modules for control and the analysis:

• Module "Management of Performance Indicators". Allows to calculate automatically control indicators on contract activities (sales volume, the largest debtors, creditors, etc.), to display on "A control panel".
• Module of development of the OLAP reports. Allows to develop and configure the multidimensional tables containing the large volume of the data necessary for control and data analysis under agreements for a long time frame (a price performance, structure of purchases and sales, etc.).

Management of performance indicators

Decision making is impossible without the objective, in time provided and clear information. Key performance indicators (KPI) most briefly and precisely reflect a status of the company, success of strategy implementation of development, etc. Due to appointment responsible for each indicator the system of motivation of personnel on achievement of desirable results at the different levels of management is built (from strategic to operational).

The module "Management of Performance Indicators" helping the head to keep constantly a company performance under control is intended for automation of work with KPI and on the basis of operational and reliable data to make timely and exact management decisions.

The module allows to manage performance indicators in a complex: select necessary indicators with the different detailing cuts, develop algorithms of receiving estimates and perform automatic calculation, including on the basis of these different systems used in the company, accumulate statistics and to visually display values in the form of tables, diagrams and charts.

For display of indicators the control panel presenting planned and actual values in the evident form is used: number, chart, diagram, list of the maximum or minimum values, etc. Setup of display (widget) and placement of indicators can be performed by the user according to his current demands. For convenience indicators can be grouped in tabs according to functions and needs of the head.

For obtaining more detailed information each indicator can be detailed, having displayed it in several cuts, to analyze values using analytical reports and even to go down to the specific document due to use in reports of the drill-down mechanism. For example, having detected on the budget of cash flow a rejection of actual data from planned, it is possible to look under what article, to the center of the financial responsibility there was this deviation.

For the realization account of a control panel using the web application information can be available to the head from any place in the world. Besides, for operating control of change of measure values there is a customized system of notifications which is automatically monitoring changes and issuing the corresponding warnings and recommendations (for example, at violation of accomplishment of budgets, unpaid amount according to requests for financing and so forth).

Standard performance indicators for the modules "Budgeting", "Management of Finance" and "Agreement settlements" are composition of Prestima. The companies can both use these indicators without changes, and to finish them or to develop new.

Creation of the reporting

In the Prestima system for information analysis in addition to the module "Management of Performance Indicators" and analytical reports in the modules "Budgeting", "Management of Finance" and "Agreement settlements" the additional tools providing formation of the different corporate reporting and the solution of difficult analytical tasks using the OLAP mechanism are used.

Corporate reporting

The module "Corporate reporting" is intended for setup of difficult reports and the regulated forms which are used for internal needs, go to parent organization, are provided to investors, etc.

Interactive instruments of setup help to prepare professionally issued reports by forces of users without involvement of developers.

Reports are under construction based on the selected activity indicators for which automatic calculation on the basis of data of a system is configured. Besides, at absence in the system of data for calculation, measure values can be entered manually. At the same time calculated for the period or for date of a measure value are stored in a system that provides the invariance of reporting data even after correction of an original informatin.

The report form is configured using Excel in templates of forms of a financial analysis. Due to display of a tree of indicators in Excel, filling of a template with data it is easily performed by users without participation of developers.

Standard means of the module allow with the minimum efforts to consolidate the reporting, collecting data from subordinates of divisions, branches, subsidiary companies in which account is kept in a third-party system. For this purpose the developed templates of forms of a financial analysis are published, i.e. automatically unloaded in the form of files of Excel with certain parameters for each division. Files are sent by e-mail and after filling in divisions are automatically loaded into a system.

Module of development of the OLAP reports

Acceptance by the head of management decisions gets to discharge of the areas which are difficult giving most in to automation. The module of development of the OLAP reports gives an opportunity to considerably simplify and accelerate process of the analysis of large volumes of information necessary for decision making.

The idea of a multidimensional data model is the cornerstone of OLAP technology. A human thought mnogomerno by determination. When the person asks questions, he imposes restrictions, thereby formulating questions in many measurements therefore process of the analysis in multidimensional model is approximate to reality of a human thought.

The module of development of the OLAP reports provides the solution of analytical tasks: the analysis of key indicators of activity, the financial and economic analysis, scenario analysis, modeling, forecasting, etc., especially when it is necessary to carry out the analysis of these data in dynamics for several periods (quarters, years). It allows to look at the same data under different points of view. For example, having received in a current period a rejection of actual data from the planned values according to the budget item, to go deep into contemporary records and to look whether there were similar deviations last quarter, half a year ago, last year, on what centers of the financial responsibility, etc. The versatile analysis allows to assess quickly a situation and to obtain a maximum of information on a problem that on the basis of it to plan ways e ѐ solutions.

Work with the module of development of the OLAP reports does not require special knowledge and skills. Design and programming are required only by a stage of extraction and data preparation for otcht from an information system by creation of cubes of data.

Viewing the OLAP reports reflecting contents of cubes of data is performed through pivot tables of Excel. In comparison with normal analytical reports in the form of pivot tables which take data directly from a system, use of the OLAP reports dat to the user two main advantages:

• high speed of work with large volumes of the cubes of data given due to use;
• simplicity of setup of the new otcht on the basis of the created cube of data.

The place in an enterprise information system

The Prestima system is focused on optimal addition of the existing enterprise information system and optimization of solving of tasks in adjacent areas due to close interaction with the software products which are already working at the enterprise.

In the field of budgeting and management of finance the following tasks and systems are adjacent:

• remote banking - the system of Client-Bank;
• accounting – the system of accounting (for example, "1C: Accounting 8");
• creation and approval of electronic documents – an electronic document management system (for example, DIRECTUM).

In traditional option data exchange between systems can be built as follows:

• from the Prestima system in the system of Client-Bank the payment orders which are automatically created later approvals of the register of payments are delivered;
• from the system of Client-Bank to the Prestima system data on the fact of carrying out payment orders by bank and about cash receipts are transferred to checking accounts;
• for budget performance monitoring from the Prestima system planned values of budgets are transmitted to the system of accounting;
• from the system of accounting actual data about execution of budgets are transferred to the Prestima system;
• from the Prestima system finance and budget documents (requests, budgets, etc.) remain in an electronic document management system, data for processes are transferred

approvals of documents (workflow);

• from an electronic document management system data on results of approval of documents are transferred to the Prestima system.

In addition data exchange can be organized with the other systems used at the enterprise:

• for formation of planned data of budgets information on the current and future projects from a project management system can be transferred to the Prestima system (for example,

MS Project);

• the approved planned values of budgets from the Prestima system for acquaintance can be published on a corporate portal;
• etc.

At Prestima system implementation the organization of interaction with other software products is performed using the integration mechanism.  

Technical capabilities

Adaptation of a system

Ready system modules of Prestima cover all range of budgeting tasks and management of finance. Standard delivery of the Prestima system includes the standard models for the different enterprises (for example, for trade enterprise with geographically distributed structure or for the project organization) covering 80% of specifics of the companies. Thanks to it adaptation of a system under individual requirements of the company on the basis of one of standard models can be executed in short terms and with the minimum costs.

At the same time adaptation of a system under specifics of the enterprise can be performed due to user preference and modification of a system using the high-level predmetnooriyentirovanny building tool IS-Builder.

User preference of the Prestima system - an obligatory stage of adaptation of a system. It is executed by the leading users and includes:

• filling of key reference books - the centers of the financial responsibility, the budget item, performance indicators, etc.;
• setup of rules of transformation for automatic formation of data of one budget on the basis of another - for example, on the basis of value of the budget item of income and expenses to calculate value of the budget item of cash flow taking into account any coefficient or temporary shift;
• setup of automatic calculation of values - calculation of the actual values of budget items, performance indicators, etc.;
• creation in need of additional reports using templates of forms of a financial analysis or options of setup of pivot tables.

Modification of the Prestima system usually is required for accounting of specifics or specific features of the company and allows:

• set any quantity of cuts in planning forms and define rules of navigation to the detailing cuts - for example, when planning the income and expenditure budget under the articles to detail revenue by the nomenclature of MTs and services or by agreements;
• define detailing of data in the payment schedule and structure of display by qualifiers of planning - for example, to display data on receipt and a funds expenditure by budget items of cash flow or activities of the company;
• for data exchange with other systems to configure scenarios of integration of reference books, documents, registers, loading of accounting entries from the system of accounting;
• carry out planning or the accounting of data in special cuts - for example, to detail expenses in places of emergence of costs;
• create difficult analytical reports, including using the OLAP mechanism, for the fast analysis of large volumes of information in numerous cuts for the long period;
• set automatic execution of any transactions with the help of calculations for an exception of the same or labor-consuming actions of users - for example, to create planned data of the budget on the basis of actual data for a previous period taking into account coefficients.

Modification of the Prestima system is performed using the building tool IS-Builder created especially for automation of financial and accounting tasks and problems of support of business processes. IS-Builder allows to abstract from technical details of implementation, to focus on applied aspects of a system, operating with concepts of data domain. Use of IS-Builder allows to increase the speed of adaptation of a system, to reduce quantity of errors as a system is created within the predeterminated technology and ideology of development.

Integration mechanism

Now implementation of any information system in the company consists not only in automation of certain sections, but also in integration of this system into already existing software products. In particular at system implementation of budgeting and management of finance its integration with the systems of Client-Bank, the system of accounting, an ECM system is relevant.

In the Prestima system this problem is solved with the help of the mechanism of integration, two-piece: the universal mechanism for setup of integration and a set of connectors to the specific systems.

The universal mechanism of setup of integration is a set of reference books, calculations and the IS-Builder functions. They are intended for inline tuning of integration with a third-party system, descriptions of an algorithm of synchronization of the integrated systems given for each object, settings of the schedule of periodic synchronization.

The connector to a third-party system contains feature set using which data exchange with a specific system, for example, "1C:Enterprise 8" is implemented.

Thus, the mechanism of integration IS-Builder allows to configure easily periodic or on-line synchronization of documents, reference books and registers and in the shortest possible time to integrate the Prestima system into already existing information environment of the enterprise.

Geographically distributed work

For the organization of budgeting and management of finance at the enterprises with a territorialnoraspredelenny management structure the Prestima system offers several different options: terminal access, replicaiton engine or web access.

Terminal access provides information exchange online, but requires stable communication channels and use of a terminal server. It is recommended to be applied in need of instant data transmission, for example, at input and adjustment of planned data by the remote centers of the financial responsibility in the course of formation and approval of budgets. At the same time use of terminal access does not require additional administration of a system in remote divisions.

The replicaiton engine implemented in IS-Builder is intended for full data exchange with remote divisions offline. Replication is understood as transfer of changes of subjects of the initial database in the databases working on different servers of distributed system. Replication ensures functioning of remote parts of an information system with the minimum requirements to quality and types of communication.

In a replicaiton engine of IS-Builder two categories of servers - main and secondary are selected. The structure of servers can be hierarchical: each server, except for central, can have a set of secondary servers and one master server. Between communication sessions each server works independently, and the frequency of sessions is defined by requirements of the specific enterprise for updating of data (from 1 time a day up to 1 time per hour). Need of transfer of these or those data is configured by the administrator. The unity of distributed system is provided with the built-in control of logical integrity and coordination of operational data and the normative reference information.

One more option of the organization of the distributed work – web access. The web client is optimal for the organization of access to a system for the purpose of accomplishment of specific actions. For example, for input by specialists of branch of requests for financing by preparation of the payment schedule in management personnel. In comparison with terminal access or use of replication, web access does not require installation, service of a terminal server or a secondary server of replication, but it can be applied only to input of reference books.

Administration of a system

The Prestima system is constructed based on the technology the client-server which is the standard for creation of information systems. As the database server the Microsoft SQL Server is used. The information security is ensured due to flexible regulation of access rights to data, the automated control of integrity of data and also recording of work of all users. All this is provided with means of the database server and the IS-Builder tool based on which the Prestima system is developed.

Utilities of the administrator which allow to add users are composition, to configure access rights and jobs of users, to update versions of a system, etc. When adding for users Windows authentication can be set thanks to what safety of access to a system is ensured at the level of a domain policy of security.

Setup of access rights for a user group or the specific user is conducted at the logic level by the indication of the list available a component with the corresponding access type (adding, change, viewing, etc.). At the same time in everyone a component for work several elements (fields, buttons) can be used to which different access rights for different users can be also set. Besides, the rights can limit a set of available records components inside, for example, to the user only requests for financing on a certain center of the financial responsibility can be editable.

Workplace of the user is the system conductor, by the form similar to Windows conductor. In the conductor the structure of a system is presented in the tree form. As folders modules, and as labels - components are selected. A set of the modules seen in the conductor and a component in a workplace of the user is automatically determined according to the appointed access rights. For convenience of work of the user often used components can be taken out in the Favorites folder.

Updating of versions of a system consists in updating of a client and server part of a system using special utilities and updating of information part of a system using utilities of import and export of development.

The complete description of an inner pattern of data of a system and the detailed administrator guide is included in the package of a system. Thanks to existence of documentation and convenient means of the IS-Builder tool administration of the Prestima system is easily performed by specialists of customer company after training on courses of administrators in the uchebnokonsultatsionny center NPO Kompyyuter.

Technical requirements

For optimal system operation of Prestima it is recommended to observe requirements to hardware and to the software. In this section general requirements are provided to servers, networks and client computers.

Requirements to servers

Requirements to the computer with a server part, depend on the number of at the same time working users of a system. For systems more 100th requirement to the server decide on the number of the working users individually depending on amounts of data and kind of work of users.

1. Processor of Intel/AMD compatible x64
2. the Log size of transactions depends on recovery model. For example, in case of use of model of recovery of Simple Recovery Mode not less than 5 GB of free disk space, and in case of use of Full Recovery Mode – not less than 50 GB are required (depends on the DB size and activity of work in the Prestima system)
3. If it is going to use model of recovery Full Recovery mode, then it is recommended to use RAID-10 from 4 disks
4. Amount of data depends on activity of work and amount of information in the Prestima system therefore in each case is defined individually. Average values by which it is necessary to be guided are given in the table

Requirements to networks

Computers on which client and server components of the Prestima system are installed should be united in a local network.

The local network should be organized in the form of the domains Active Directory or in the form of the working groups Windows. It is more preferable to organize network in the form of the domains Active Directory.

The main protocol of work is the TCP/IP protocol.

Minimum capacity of a local network of 100 Mbps.

Requirements to client computers

1. In addition it is necessary to consider the resources required OS
2. Minimum of Microsoft Word and Microsoft Excel
3. Is established in a workplace of the developer in case of need of development of reports in Crystal Reports

For client working places the computer with the configuration corresponding or exceeding the minimum requirements is necessary personal .

Advantages of the Prestima system

Convenient tools

Prestima provides the best solving of tasks due to use of special tools which are not in universal ERP systems:

• planning forms - the organization of planning of budgets with participation of the CFD;
• the payment schedule - optimum allocation of financial resources;
• control panel - operating control and the analysis of key performance indicators (KPI).

Optimal addition of the existing systems

Prestima is easily built in an information system of the company and expands its opportunities, closely interacting with already used software products in adjacent areas

• the system of accounting - transfer of planned values for control and data acquisition about budget implementation;
• the system of Client-bank - information exchange about cash flow on checking accounts;
• electronic document management system - storage and approval of documents, mailing of notifications.

Ease of adaptation

Prestima locates ample opportunities of adaptation and allows to arrange quickly a system under specifics of the enterprise and change of processes:

• existence of the standard budget models covering 80% of budgeting tasks;
• use of the subject-oriented building tool IS-Builder.

High scalability

Prestima provides scalability of an information system:

• the high high-speed performance independent of the number of users and amount of data in a system;
• possibility of the organization of geographically distributed work.

Simplicity of mastering

Prestima is easiest in mastering and is convenient in use for the account:

• intuitive user interface;
• convenient administrative tools;
• author's training courses for users, administrators and developers.

Advantageous offer

Prestima guarantees optimal price relation and qualities:

• real effect at the acceptable cost of ownership;
• orientation to rapid implementation taking into account specifics of the enterprise.

Effect of Prestima system implementation

The Prestima system using modern information technologies solves problems of management, relevant for most the enterprises. Thereby increases efficiency of middle managers and top managers of the company, the staff of economical and financial services.

Heads

• Timely acceptance of management decisions on the basis of operational and reliable information.
• Increase in justification of solutions due to multiple planning, ease of forecasting and the detailed analysis.
• Achievement of the planned results of activity of the company thanks to personification of responsibility of employees and creation of a system of motivation.
• Increase in degree of reliability of the company for creditors, investors, etc.

Economists

• Reduction of terms of preparation and processing of budget requests, operating budgets.
• Decrease in labor input and minimization of errors by drawing up and adjustment of final budgets.
• Reduction of rejections of actual data from planned.
• Simplification of collection of data on execution of budgets
• Increase in speed of preparation of puffiness.

Financiers

• Increase in level of solvency of the company thanks to exact planning and operating control of cash flow.
• Reduction of volumes of extra budget payments without additional labor costs.
• Decrease in receivables and payables.
• Reduction of use of borrowed funds due to optimal use of own

financial resources.

2014: Prestima 4.0

The NPO Kompyyuter company announced in November, 2014 release of the next generation of the Prestima 4.0 system. Each user will find for himself visual and functional improvements, and new owners will estimate the volume of solvable tasks and convenience of work with a system.

To the credit specialist: effective management of the credits

Many companies regularly resort to attraction of borrowed funds. At the same time often work with a large number of loan agreements and diagrams on them takes place in the Excel format that requires a lot of time and increases risk of emergence of errors.

It is effective the new module Prestima "Management of the Credits" will help to plan cash flows within credit obligations. Its functionality allows:

• register loan agreements;
• calculate payment schedules for all types of the credits (differentiated, overdrafts, renewable and non-revolving lines of credit) and various conditions on them;
• predict a situation at early repayment of the credit or the interest rate realignment;
• plan the amounts of an income and expense budget and BDDS in the mode "that if" at the expense of the analysis of different options of structure of the credits and payment schedules;
• to quickly obtain information on repayment of the amounts of the credits and percent on them;
• prepare the reporting for banks and the top management.

The new module expands borders of planning and increases quality of management of cash flows. To credit specialists more simply and quicker to make and support the optimal loan portfolio, and up-to-date information on credit activity of the enterprise is always available to top managers of the company.

To the economist: collecting of the fact of the budget in the minimum terms

Special attention in Prestima 4.0 is paid to development of the module "Budgeting".

The new mechanism of the module just allows easily and to configure automatic collecting of the fact of execution of budgets from accounting systems of the enterprise. The mechanism does not depend on the number of bases and supports the most popular system configurations of 1C. Now economists can receive the final reporting in the minimum terms. In the holding companies this functionality will also allow to carry out elimination (exception) of intra group turnovers that will provide assessment of execution of budgets both the separate legal entity or business divisions, and holding in general. All described actions can be performed by users without participation of programmers.

For comfortable input and the analysis of budgets the interface of forms of planning was updated. Along with it, the high-speed performance of the application directed to work of users with large volumes of data considerably increased.

Also the mechanism of transformation of budgets is improved. Sales opportunities of interrelation and data transmission between operating and consolidated budgets are as a result increased.

To the head: up-to-date information for the right decisions

For acceptance of effective management decisions the head needs timely and reliable information. Changes in the module "Management of Performance Indicators" fully solve this problem:

• there was an opportunity for work with a control panel of the head in the web access mode on tablets running iOS, Android and Windows that provides mobility in any part of the world;
• the number of tools for work with performance indicators increased: detailing, formation of detailed reports;
• the convenience of work with KPI at the expense of new and the intuitive interface of a control panel increased.

To the IT specialist: convenient support of a system

For creation in the company of a common information space in the Prestima system the integration mechanism was updated. In particular, improvements concerned interaction with the system of financial accounting 1C and an electronic document management system of DIRECTUM. To provide integration between systems with an identical configuration, it is enough to configure one scenario which will integrate in itself(himself) all systems. The new mechanism considerably simplifies the procedure of setup and reduces time expenditure by integration support.

The mechanism of loading of large volumes of data is also optimized that allows to obtain in the Prestima system necessary information, for example, for the analysis of the actual accomplishment of budgets in a few minutes. Besides, programmers can complement a system with convenient functions using the updated building tools.

2015: Prestima 4.1 is simplification of planning of budgets

On August 3, 2015 the NPO Kompyyuter company announced release of the version of the Prestima 4.1 system^[1].

Irina Gordiyenko, the project manager of development of Prestima 4.1, considers a version keynote - simplification of planning of budgets: "The main emphasis when updating a system is put on improvement and transparency of specific transactions most of which often meet in routine work of economists and the CFD. Besides, in Prestima 4.1 we considered requirements of the companies in the conditions of crisis: prepared tools for work with unreliable partners and mechanisms for forecasting of percent from an investment of money. The project team is glad to provide the new version, and we hope that you estimate the received result".

In this version of a system the set of methods of connection of the CFD to planning of budgets is created. The company can pick up the option which is most suitable for itself taking into account an organization structure:

• By the CFD it is not connected to the Prestima system. The consolidated budget of the enterprise can be created on the basis of budgets of the divisions prepared in the Excel templates and loaded by the economist into Prestima planning forms. At data loading the file with interpretation in Excel automatically becomes attached to values of budgets. The economist at any time can address the attached files for interpretation of information specified in the budget. Interpretations of budgets in the form of electronic documents in Prestima storage, electronic documents and tasks of DIRECTUM, the link to the websites can act as the attached objects;

• By the CFD it is connected to the Prestima system. The new mechanism of budget requests and interpretations to them allows to receive the planned amounts of an income and expense budget and BDDS from divisions with detailing to partners, the organizations, agreements and other cuts. For this purpose the user enters data into a budget request and interpretation to her and sends for approval. After approval the specified amount join in the general budget. Also budgets from agreements and projects can plan the CFD.

For work with unreliable partners in Prestima 4.1 the new tool — the stop-list appeared. Partners can be included in the stop-list in the presence of overdue receivables / debt over a certain limit or because of other causes (for example, legal procedures with the company, findings of the partner at a liquidation stage and so on).

Entering of the company into the stop-list limits work with it regarding the conclusion of new agreements, shipments of goods, works, services to the buyer, payments to the supplier. Interested persons can be notified on an inclusion/exception of the organization of the stop-list using e-mails and systems capabilities of DIRECTUM.

Addition of a product — setup of the moment of reservation of limits in requests for financing. In each company the rules by determination of the moment when the request for payment reduces the planned budget limits are set. For example, at approval of the head of the CFD or only after approval of the financier. The new Prestima mechanism allows to consider feature of reservation of limits of budgets in requests for financing - the transparency of operational financial planning increases: approving always have near at hand up-to-date and timely information.

In version 4.1 the possibility of planning of receipts of percent from investments of capital in deposits appeared. In the module "Management of the Credits and Deposits" formation of payment schedules and collecting of actual data according to them for different types and analogs of deposits is implemented: deposits, bills of exchange, deposit certificates, "not reduced remaining balance". The additional functionality allows to analyze as investments in deposits and change of their conditions — partial or complete early withdrawal of funds from a deposit or its replenishment, prolongation of the agreement will affect the budget of the company.

Holdings will estimate probably a possibility of formation of payment schedules on intra group loans when one enterprise of holding issues a loan for other enterprise.

Notes