DEVELOPMENT AND IMPLEMENTATION OF A SOFTWARE PRODUCT “AUTOMATED ACCOUNTING SYSTEM “AXIM” FOR SMALL BUSINESSES IN THE SYSTEM OF FORMATION OF ANALYTICAL SUPPORT

Topicality. The desire to electronize daily routine processes comes into all spheres of human life: education, entertainment, business, everyday life, etc. It is known that automation of any process not only simplifies human work, but also reduces the time for its execution and improves the quality and effectiveness of this operation.Today, more and more mechanical, monotonous work of people is performed by an automatic or automated system. This is justified by the fact that computer software products perform operations much faster and better than humans.Aim and tasks. Study of the features of development and implementation of the automated accounting system “AXIM” with wide functionality for a small enterprise.Conducted content analysis of literary sources of the economic direction and the programming sphere – to select indicators that affect the functioning of the store, study their relationships to develop a software product for increasing the efficiency of trading company business processes; comparative analysis – to reveal the essence and features of software products implementation to improve the efficiency of trading company business processes; analysis and synthesis techniques – to form a system of indicators for the effectiveness of the software product implementation.Research results. An “AXIM” automated system for selling retail goods has been created, which has great functionality and successfully fulfills its tasks. The software product was introduced and tested at the small trading company “Bonus” of individual entrepreneur Yakovlieva L.I., which is located in the township Smolino of the Kirovohrad region Malovyskivskyi district.Conclusion. The introduction of the created software product at the investigated small trading company “Bonus” of individual entrepreneur Yakovlieva L.I. showed effective usage indicators and made it possible to streamline the accounting, simplify the search for product information, automate the scheme of goods sale and control the goods balance in the store.

Problem statement and its connection with important scientific and practical tasks. Automation of any process simplifies the work of a person, reduces the time for its execution and improves the quality and efficiency of the operation.
Automation of business processes from planning to reporting on trading activities sets new requirements for information and allows better accounting of all aspects of the small business (shop) functioning, choose a software product that would meet the store peculiarities.
Based on the analysis of publications, we found that software development was largely carried out for large firms and enterprises, underestimating the importance of small and medium-sized businesses. The need to design and implement software for small businesses is emphasized by scientists: Noble M., Clarke T., Crane F., Upson J., Green K., Wright Ph., Geroy G., Segal B. [5 -7]. They note that even through its small size, resources and customer relationships, small businesses can compete, but differently than large firms.
Allocation of previously unsolved parts of the general problem. Modern retail trade requires the use of modern information technologies, among which cloud computing and web technologies occupy a special place, which significantly increases the efficiency of small business. The relevance of software development is a consequence of scientific and technological progress, especially in the sales market and in financial institutions.
Therefore, given the relevance of the development and implementation of software for small businesses, we examined in detail modern software products for store accounting:  product "1C: Retail 8 for Ukraine" which is designed for trading activities automation of stores and other retail outlets;  program "ULTRA Shop" (ULTRA Business version), feature of which we have determined the maximum simplicity for the user;  "Accounting Online" is a service for maintaining operational, management, accounting, tax accounting and reporting in the State Fiscal Service using cloud technologies; ready solution for automation of management and accounting at enterprises via the Internet;  "BAS Retail" is a highly functional front office for retail chains and individual stores [8 -11]. Software research has shown that the creation of a new, better, high-quality system, without unnecessary memory costs, without the possibility of data loss and which is best adapted to the requirements of a small business, is becoming increasingly relevant [12 -13].
Formulation of research objectives (problem statement). Study of the features of development and implementation of the automated accounting system "AXIM" with wide functionality for a small enterprise.
An outline of the main results and their justification. To achieve this goal, we used the following research methods: content analysis of literary sources of the economic direction and the programming sphere to select indicators that affect the functioning of the store, study their relationships to develop a software product for increasing the efficiency of trading company business processes; comparative analysisto reveal the essence and features of software products implementation to improve the efficiency of trading company business processes; analysis and synthesis techniquesto form a system of indicators for the effectiveness of the software product implementation.
To simplify the organization of retail goods accounting and sale, reduce time for document management, improve the quality and efficiency of small businesses, we have created a software product "Automated Accounting System "AXIM" [14].
Software product "Automated accounting system "AXIM" is a multifunctional tool for increasing the efficiency of enterprise business processes. The program allows to automate the tasks of operational and management accounting, analysis and planning of trading operations.
Functionality of the "AXIM" software product can be divided into three hierarchy levels: 1. Login page. The main data storage location is the AXIM database created using the MySQL relational database management system.
Consider the principle of the program using on the example of the function "Adding goods from invoices to the database", namely, the function of the data management model AddProductsToInvoice (), the algorithm of which is shown in Fig. 2.
Let's do a step-by-step analysis, using the listing of the corresponding function AddProductsToInvoice () of the db_adapter.php file. In the WHILE loop (while there is data to process), the following steps are performed: Step . ', '.$price_sel. ') '; , having previously calculated $price_sel. The last query to the database inserts a new product with the following data: barcode, father's barcode, product name, quantity, purchase and sale price.
If a product with this barcode already exists, update the data. System users can interact with it: output some data, add new or edit old data, etc., using some functions.
Consider a sales operation -Selling. Suppose that the goods and their quantities have already been selected, it is only necessary to confirm the operation, so make some changes to the database. When selling a product, form an array of bar codes and quantities (count) of goods.
Therefore, by pressing the button "Print check" (id -print_check), form a two-dimensional array: ; $this->view->SuccesAddCountProd($res); break; That is, having an array of data about the goods, their quantity, price, current date, and seller's data, pass them to class to work with DB DBAdapter in the function Selling (). The result of the execution is passed to the function SuccesAddCountProd () of the View class.
In the process of developing an "Automated accounting system "AXIM": the MySQL database management system is investigated; designed a conceptual, logical and physical database model for the "AXIM" software product (using the MySQL database management system); module for working with the database is developed; software product "Automated accounting system "AXIM" is created.
The software product "AXIM" has great functionality and successfully performs the tasks assigned to it. The software product "AXIM" was introduced and tested at the small trading company "Bonus" of individual entrepreneur Yakovlieva L.I., which is located in the township Smolino of the Kirovohrad region Malovyskivskyi district.
Conclusions and perspectives of further research. As a result of testing the proposed software product at the investigated small trading company "Bonus" of individual entrepreneur Yakovlieva L.I., its effectiveness is determined, which is expressed in simplified organization of accounting and sale of retail goods, reducing the time for document management, analysis and planning of trade operations.
Therefore, the created software product "Automated Accounting System "AXIM" is a multifunctional tool for accounting, finding information on goods, automating schemes for selling goods and controlling the balance of goods in the store and can be recommended for practical application by small business entrepreneurs.
Prospects for further research are the design and development of a software product for organizing the accounting and sale of pharmaceutical products for a laboratory workshop of specialty 226 "Pharmacy" of Donetsk National Medical University and for the pharmaceutical industry as a whole.