Programs for conducting commodity accounting. Free programs for small and medium businesses
We chose a ten-point scale and gave each of the considered programs an average score based on its evaluation according to five main criteria: cost, ease of development, functionality, stability, technical support. The TOP is compiled on the basis of an analysis of the capabilities of a particular program or service, as well as user feedback on working in it.
TOP 10 Best Software and Services for Warehouse Management
Place | Program/service | Price | Ease of learning | Functional possibilities | Stability | Technical
support |
Overall score |
1 | My warehouse | 7 | 10 | 9 | 10 | 10 | 9,2 |
2 | cloud shop | 10 | 9 | 7 | 9 | 8 | 8,6 |
3 | AccountingCloud | 9 | 9 | 7 | 9 | 8 | 8,4 |
4 | 1C: Trade management | 6 | 3 | 10 | 9 | 10 | 7,6 |
5-6 | Super Warehouse | 8 | 8 | 7 | 7 | 7 | 7,4 |
5-6 | big bird | 8 | 7 | 7 | 8 | 7 | 7,4 |
7 | IP: Trading warehouse | 4 | 8 | 9 | 9 | 8 | 7,6 |
8 | subtotal | 7 | 7 | 6 | 7 | 8 | 7 |
9-10 | Microinvest Warehouse Pro | 2 | 8 | 6 | 7 | 8 | 6,2 |
9-10 | Commodity-Money-Commodity | 3 | 7 | 7 | 7 | 7 | 6,2 |
The dry numbers in the table are not very weighty arguments in the dispute about which program is the best in its segment. Therefore, we present to your attention short review all of the above programs and services.
Commodity-Money-Commodity
This program is a strong middle peasant in the world of warehouse accounting software. It is difficult to single out pronounced pluses and critical minuses in it. Its universal functionality is “sharpened” for maintaining warehouse accounting in small retail and wholesale businesses.
pros
- The presence of a demo version, which can be used for three months.
- Support for an unlimited number of warehouses or retail outlets, as well as the ability to create any own enterprise structure.
- Support for the work of "TDT" on remote computers, outside local networks.
- The possibility of using this software in assembly production, when the finished product is made from pre-purchased components.
Minuses
- Sometimes in the TDT program code there are "holes" that open up the possibility for accounting fraud.
- The program is updated for free only for six months, and after this period you have to pay a subscription fee for each update.
What is the price?
The price for the electronic version of the program for one working computer is 3894 rubles. However, if you need to install this software on the second, third and subsequent computers, the cost will decrease. The minimum threshold is 2950 rubles (fifth or more working computer). Accordingly, the total cost of "Goods-Money-Goods" for five jobs will be: 3894 + 3658 + 3422 + 3186 + 2950 = 17,110 rubles.
IP: Trading warehouse
This warehouse and trade accounting program is a kind of old-timer of the market, its first version was released at the beginning of the “zero”. Together with the IP: Accounting software, it is included in the Info-Enterprise software package. It is not difficult to guess that in symbiosis these programs work twice as efficiently.
pros
- Stable and uninterrupted work on computer configurations, both old and modern assembly.
- The best ratio of price and functional capabilities, in comparison with analogues.
- Timely technical support and updates.
- The presence of a free version, which is perfect for full-fledged inventory management in small businesses.
- Ability to manually tune some aspects of the program without calling the programmer.
Minuses
- Somewhat archaic interface and general structure of the program.
- An insufficient amount automatic settings typical operations.
What is the price?
Version "Standard" can be purchased for 6900 rubles, "Prof" costs 11900 rubles. Additional network places for these versions cost 1950 and 2900 rubles, respectively. It is possible to purchase each of the versions in installments, divided into four equal quarterly payments.
Microinvest Warehouse Pro
A guest from Bulgaria, the Microinvest Warehouse Pro program, is designed to automate the inventory control of materials in enterprises, mainly network retail. Its uniqueness lies in the possibility of building controlled logical chains from elementary operations with subsequent total control of each business process.
pros
- The functionality of the program is ideal for restaurants and self-service stores.
- It does not require fine tuning and making changes to the system after installation.
- There is an option to synchronize the program with electronic trading equipment for issuing checks.
- Enough flexible system program settings for specific needs.
Minuses
- Far from an intuitive interface.
- Problems with internal search for documents and reporting.
- Relatively high cost of the program.
What is the price?
Price full version program is 199 euros or a little more than 12,000 rubles at the exchange rate for February 2017. The purpose of this online service, developed in the cultural capital of Russia, is the maximum automation of retail processes. A powerful set of inventory management tools allows Subtotal to compete with more specialized programs and services. pros Minuses What is the price? The first month of work in Subtotal does not cost a penny. But for each subsequent month, a monthly fee of 1,400 rubles is paid when connecting one outlet. The monthly subscription fee for each additional outlet is 900 rubles. The first version of the SuperSklad program was released back in 1993. Since then, this software has been constantly improved, keeping up with the times and with the legislation, and in 2016, the cloud version of SuperSklad was launched. The secret of such a long life of the program is simple - the maximum ease of development, coupled with the presence of all the necessary functions for warehouse accounting in a small enterprise. pros Minuses What is the price? The installed version of the SuperSklad program will cost 985 rubles, the "cloud" version - 345 rubles. The Big Bird online warehouse accounting service has a reputation as one of the best programs in its segment. Despite its relatively young age, this product from domestic programmers from Eteron has received recognition from many small business owners due to its reliability, high speed and good functionality. pros Minuses What is the price? The service has two tariff plans - "Hummingbird" and "Albatross". The first is completely free, but with limited features. For using the second one, you will have to pay from 790 to 990 rubles per month, depending on the total subscription period (the longer it is, the lower the cost of one month). The date of birth of this cloud warehouse accounting service is 2008. Five years later, My Warehouse received the Cloud-2013 award and was recognized as the best cloud service in Russia. Despite everything, this service continues to hold its own and has earned the trust of more than 700,000 small and medium-sized businesses today. pros Minuses What is the price? The subscription fee for the "Basic" tariff, designed for two workplaces, is 1000 rubles per month. "Professional" (5 jobs) costs 2,900 rubles, and for the most advanced tariff - "Corporate" (up to 10 employees), you will have to pay 6,900 rubles a month. The "Free" tariff for one workplace corresponds to its name, but has a number of significant limitations. In this online service, functions related to the movement of material assets and accounting for stock balances are at the forefront. A simple interface and a focus on small businesses make UchetOblako an excellent choice for small wholesale and retail businesses. pros Minuses What is the price? The "Beginner" tariff is absolutely free and available only for one user. As for the “Entrepreneur” tariff (3 users), the monthly subscription fee for it is a ridiculous amount - from 80 to 100 rubles, depending on the duration of the subscription. The fee for each additional workplace is 80 rubles per month. A young, practical and convenient online service for accounting for inventory, material assets and customers. Users from 28 countries of the world have already appreciated its capabilities. Its freeness and balance of all components attract more and more owners of small and medium-sized businesses. pros Minuses What is the price? You do not need to pay a penny to work in CloudShop, but only if there are no more than 5 users. The subscription fee for connecting each subsequent user is 299 rubles. Powerful and functional warehouse management software from the mastodon of the market - 1C company. The main and most serious competitor of all programs and services described in this TOP. pros Minuses I would like to note that for different organizations that use such programs, not all criteria can be equally important. For example, a small individual entrepreneur with a meager turnover will prioritize ease of development and low cost of the warehouse accounting service. The owner of a large enterprise, most likely, will not look at the price of the program - he needs flexible and powerful functionality with additional options. Therefore, the place of the program in our TOP only reflects the level of its balance and versatility for different categories of users. Everyone will choose the best warehouse accounting program for himself, based on the specific tasks that will be set for it within a single organization. One of the effective ways to reduce the costs of the enterprise is to increase the effectiveness of the implementation of warehouse tasks. This goal is achieved through process automation. It gives the company a significant advantage in the market. Let's consider further what warehouse programs exist. This application solution is perfect for any trade or production association that keeps track of the quantity of materials, raw materials, finished products. The program has certain specifics. Before compiling tables, you need to create reference books: If an organization produces a relatively constant list of products, it is possible to form its nomenclature in the form of an information base on a separate sheet in a table. Subsequently, income, expenses, as well as reports will need to be filled out with links to this page. In the "Nomenclature" sheet, you should indicate the name of the products, product groups, codes, units of measurement and other characteristics. Warehouse program allows you to generate a report using the "Pivot Table" option. The receipt of objects is taken into account in the "Incoming". To track the state of material assets, it is recommended to form a "Balance" sheet. Users say that accounting can be made more efficient if the user can choose from a list of product names and vendors. The unit of measurement and the manufacturer's code are displayed automatically, without the participation of an employee, and the cost, date, invoice number, and the quantity of goods must be entered manually. This application solution is considered by users to be the most versatile. Warehouse program "1C" suitable for any enterprise, regardless of areas of work, size, volume of manufactured / sold products and other factors. The application allows you to automate operations as much as possible. In this case, the user enters data once. This one with treasure program has a user-friendly interface. Each responsible employee will have access to the database he needs. There is such a program as "Super Warehouse". It is quite popular among entrepreneurs. Users refer to its advantages as a simple interface, ease of development. This is the simplest one. It allows you to summarize information about funds and products from a kiosk to a large base. For those users for whom mobility is very important, a version with a portable application has been developed. It can be installed on both hard disk and removable media. This warehouse program is used, as a rule, by trading enterprises. It is perfect for small and medium businesses. The program is simple, but at the same time it has all the necessary functionality to summarize the information. Users say that they can generate reports on sales, cash transactions, analysis of financial indicators, revision of balances and so on without any difficulty. The program can be used for free. But there is also a paid version with a wider range of options. This is a fairly reliable and flexible application solution. It allows you to automate production, trade and warehouse. Introduction to the enterprise is not accompanied by any difficulties and requires minimal labor costs. The program has a free trial and a paid version. This program is designed for comprehensive control of the activities of retail, wholesale, mixed and other trade enterprises - from a kiosk to a large supermarket. The application allows you to summarize and reflect information about all types of transactions, cash flow. The application solution provides control of mutual settlements with clients, maintenance of all necessary documentation. Judging by the reviews, with the help of the program, the user can generate analytical reports on the work of the entire organization. The application solution "IP: Trading warehouse" has extensive functionality. It makes it easy to automate operations. The application is used by wholesale and retail stores, bases, supermarkets. In general, the program is focused on trading activities. However, the developers have foreseen the possibility of using the application in other enterprises. The program is suitable for all organizations conducting warehouse accounting. This program is used to automate the cycle of operations in the warehouse. In the application, you can summarize information on all stages of work. The application solution has a wide range of options. It allows you to take into account operations on the receipt and consumption of objects, prepare analytical reports. This application solution is an automation system for networked retail facilities. These include, for example, self-service stores or counter trade. The program is also used in restaurants, large warehouse facilities. According to the opinions of users, the application meets all the requirements for operations to summarize information about the movement of commodity resources within the enterprise itself or between its divisions. Some businesses use a program such as Warehouse and Sales. It is designed not only to summarize the information obtained from the usual storage areas of the company. The application solution can be used to account for information coming from external warehouses that have the structure of an online store. The application allows you to serve orders by phone and email. The "Warehouse +" program, as the reviews say, is quite simple and convenient. It contains all the necessary set of options. With the help of the application, receipt and expenditure documents are easily created, invoices, invoices and other papers are printed. In addition, the application solution calculates sales prices with specified coefficients. The "Warehouse 2005" program is designed to summarize information for small businesses that conduct trading activities. It can generate reports on stored products, the movement of products and money. The application is built according to the multicurrency accounting model. It can create tables of exchange rates. The program "Warehouse accounting of goods" is used for prompt reflection of information. Using the application, the user monitors the balance of materials and products, receives reports for any date of interest. Generalization of information is carried out on the basis of cards. The OK-Sklad program is a fairly powerful application. The application solution is suitable for manufacturing and commercial enterprises. The program has a complete set of necessary functions. One of the advantages of the application is its interface. It is clear and user friendly. As you can see, there are a lot of warehouse programs. The choice will depend on various factors. The main criteria are the volume of products in warehouses, the speed of turnover of goods, the number of counterparties, the need to draw up additional documents, and so on. If we talk about universal applications, then, undoubtedly, the 1C program will be the best solution. MySklad is a convenient and easy-to-use Excel-based program, especially in comparison with WMS. Programming skills are not required to operate the application - its interface is intuitive for almost every user. The free warehouse application provides truly unlimited possibilities for optimizing any business processes: with the help of this program they become simpler and faster. With the help of the warehouse accounting program, you can perform various actions. For example: Such functionality greatly simplifies warehouse management and saves time and labor costs of personnel working in the organization. The free program for the warehouse "MySklad" gives maximum opportunities to users, without limiting them in working with the usual additional services and tools. You will definitely appreciate how functional the Warehouse program is: in Excel, many of the functions and features that we offer are simply not available. You can get the most out of an automated accounting system by integrating it with electronic and sms mailing services, as well as with 1C. In addition, any warehouse equipment can be connected to the system. The free program "My Warehouse", which you can download on our website, has a lot of advantages. Among them: Download the free warehouse program MySklad for warehouse management in Excel right now and test it in practice. Familiarization with the application during the test period (14 days) is free of charge. Using the demo version, you will learn the basic principles and mechanisms of the program and evaluate how convenient and functional the free warehouse program is. You can also choose a tariff that is best suited for your business. Warehouse accounting in Excel is suitable for any trade or manufacturing organization where it is important to take into account the amount of raw materials and finished products. To this end, the company maintains inventory records. Large firms, as a rule, purchase ready-made solutions for keeping records in electronic form. Today, there are a lot of options for various activities. Small businesses control the movement of goods on their own. For this purpose, you can use Excel spreadsheets. The functionality of this tool is quite enough. Let's get acquainted with some of the possibilities and independently create our own warehouse accounting program in Excel. At the end of the article, you can, which is analyzed and described here. Any custom warehouse management solution, whether built on your own or purchased, will only work well if you follow the basic rules. If you neglect these principles at the beginning, then later the work will become more complicated. It is impossible to unequivocally answer the question of how to keep inventory records in Excel. It is necessary to take into account the specifics of a particular enterprise, warehouse, goods. But we can draw general recommendations: So that the headings of each warehouse accounting table do not run away, it makes sense to fix them. This is done on the "View" tab using the "Freeze Areas" button. Now, regardless of the number of entries, the user will see the column headings. Let's look at an example of how the warehouse accounting program in Excel should work. We make Handbooks. For supplier data: * Shape may vary. For customer data: * Please note: the title bar is pinned. Therefore, you can enter as much data as you like. The column names will be visible. For auditing points of issue of goods: Once again, it makes sense to create such directories if the enterprise is large or medium. You can make a product range on a separate sheet: In this example, we will use drop-down lists in the table for warehouse accounting. Therefore, Directories and Nomenclature are needed: we will make references to them. Name the range of the "Nomenclature" table: "Table1". To do this, select the range of the table and enter the appropriate value in the name field (opposite the formula bar). You also need to assign a name: "Table2" to the range of the "Suppliers" table. This will allow you to conveniently refer to their values. To fix income and expenditure transactions, we fill out two separate sheets. We make a hat for the "Arrival": Next stage - table automation! It is necessary to make it so that the user selects the name of the product, supplier, accounting point from the ready list. The vendor code and unit of measure should be displayed automatically. Date, invoice number, quantity and price are entered manually. Excel calculates the cost. Let's start solving the problem. First, let's format all directories as tables. This is necessary so that later you can add something, change it. Create a dropdown list for the Name column. Select a column (without a header). Go to the "Data" tab - the "Data Validation" tool. In the "Data type" field, select "List". An additional field "Source" immediately appears. To make the values for the drop-down list taken from another sheet, use the function: =INDIRECT("item!$A$4:$A$8"). Now, when filling in the first column of the table, you can select the name of the product from the list. Automatically in the column "Unit. rev.» the corresponding value should appear. We will do it using the VLOOKUP and UND functions (it will suppress the error as a result of the VLOOKUP function when referring to an empty cell in the first column). Formula: . By the same principle, we make a drop-down list and autocomplete for the "Supplier" and "Code" columns. We also form a drop-down list for the "Accounting point" - where the incoming goods were sent. To fill in the "Cost" column, we use the multiplication formula (= price * quantity). We form the table "Consumption of goods". Drop-down lists are used in the columns "Name", "Point of accounting for shipment, delivery", "Buyer". Units of measurement and cost are filled in automatically using formulas. We make a "turnover sheet" ("Results"). We set zeros at the beginning of the period, because warehouse accounting is just beginning to be conducted. If previously conducted, then in this column there will be balances. Names and units of measurement are taken from the nomenclature of goods. The columns "Receipt" and "Shipments" are filled using the SUMIFS function. The remainders are calculated using mathematical operators. Download the warehouse accounting program (a ready-made example compiled according to the above described scheme). Here is the completed program. Online system for managing small businesses in the field of trade and services. Modules: trade and warehouse, CRM, mail, SMS, tasks and calendar, employees. Allows you to maintain full-fledged trade and warehouse accounting, work with customers and suppliers, carry out joint work of employees, control costs, calculate profit and cost. A large number of printed editable templates of forms and documents. All necessary reports. Internet service for trade management, designed to automate small and medium-sized businesses. Allows you to manage sales and purchases, control mutual settlements, work with the client base, keep inventory records, and print all the documents necessary for doing business. Online system for recording sales, goods and customers. Allows you to quickly carry out basic trading operations - sale, purchase, return, load goods and balances from Excel spreadsheets, enter new goods using the built-in barcode scanner, create incoming and outgoing orders, control the amount at the store's cash desk, organize work with discounts, view sales statistics and analytics. Solution for markets, stalls, mobile cafes, small grocery stores with an assortment of alcoholic products, and non-grocery stores. Full checkout. Acceptance of payments. Personnel control. Compatible with EGAIS. Works on tablets. Online accounting system for entrepreneurs and small businesses in the field of wholesale trade and the provision of services. Designed to maintain a database of counterparties, balances of goods in the warehouse, money in accounts and at the cash desk, accounting for income and expenses, analyzing the state of health of the company. Allows you to generate the necessary primary documents without the help of an accountant. A simple and convenient retail and warehouse accounting system that saves time and increases business profitability. Cashier's workplace on any laptop or tablet (barcode scanner, document printing). Warehouse accounting (remains, purchases, label printing). Tools for monitoring and developing business: sales for each store, optimization of stock balances, the amount of money in the cash register, the average check amount, marginality and net profit. The system works with EGAIS A modern program for warehouse and trade accounting, a cash register on Android, POS-terminals for accepting cards and cash equipment for online and offline sales SaaS service for store and warehouse management. Management of purchases and suppliers, stock balances, prices, sales and customers, marketing promotions, employees. There are reports, document printing, a POS application for a tablet. You can manage both one small store and a chain of stores. Cloud service for automating a cafe, restaurant or small shop on a tablet. Allows you to create a virtual map of the hall, accept and control orders (tables with open orders are highlighted on the map), keep a cash register, print receipts, keep inventory records, a customer database and a list of employees. Smart cash terminal + a set of cloud services for automating retail outlets. Allows you to keep inventory records, manage a small network, give discounts and bonuses, as well as retail alcohol through EGAIS. A simple and inexpensive service for maintaining a warehouse and trading online. Allows you to control stock balances and plan for the future state of your warehouse based on expected orders and sales data Cloud system for retail store automation. Provides everything you need to work: income, expenses, sales, returns and write-offs. It also allows you to carry out warehouse accounting, conducting payments and mutual settlements, analyzing sales, drawing up applications. The cash desk supports work with fiscal registrars for 54-FZ. Service for accounting and business automation. Used by food delivery services, cafes and restaurants with delivery, retail, online stores, flower shops, and many other small and medium-sized businesses. Checkout on a tablet and a cloud service that includes analytics, CRM, warehouse and personnel. The business lines are food, retail and beauty salons. The service supports work with EGAIS and FZ-54. Cloud service for managing multiple outlets online. Working with online cash registers, simple inventory accounting, maintaining a warehouse and balances, useful reports on the work of outlets. The service supports 54-FZ and EGAIS 3.0. The "Retail" configuration is designed to automate the business processes of stores that can be part of a distributed retail network of a trading enterprise. It can be used to automate stores with a large number of jobs, including as a cash register program. Available as an online service from 1C partners. Service for warehouse, trade and management accounting. The algorithms and interfaces of the program are understandable on an intuitive level. Habitual patterns (templates) of interaction are intentionally used. A cash register program for chain stores of any format, which combines a set of business applications to automate the cashier's place, the trading floor and the central office. It allows you to increase sales through advanced marketing tools, a promo server, a loyalty point system, mobile applications and omnichannel trading solutions. Free POS system and loyalty program. Accounting program for coffee houses, small shops and beauty salons Online trade automation and management system. Sales/purchase management, accounting of income/expenses, warehouse accounting, execution of all necessary documents. Integration with client-bank and 1C. A program for automating a delivery service, retail, cafe or bar. Convenient interface for creating orders and maintaining warehouse records. System for automatic distribution of orders by delivery zones and couriers. A turnkey solution for managing and accounting for small businesses. The program implements everything you need for non-fiscal operational accounting, control, analysis and planning. The program allows you to prepare and submit reports for individual entrepreneurs using the simplified tax system and / or UTII, as well as reporting to the PFR and the FSS. There is a mobile application. Available as an online service on the 1C-Fresh platform. Cloud service for retail. Includes checkout, marketing, loyalty, CRM, inventory management, as well as an online store and mobile application for customers SaaS service for retail and delivery automation. Allows you to maintain a customer database, record sales, orders and stock, plus provides a mobile application for the courier and reports for the manager. A simple online accounting program for retail and cafes. Free for 1 outlet. Cashier interface, warehouse accounting, analytics, customer accounting, deferred checks, a map of the hall with tables, production, a module for optics salons. Corresponds to FZ-54. Simple software for retail. Allows you to replace the Batch Deliveries and Item Sales logs: you no longer have to keep everything manually or in Excel, and all sales will be immediately reflected in the warehouse and at the checkout in a storage protected from prying eyes, accessible to you from anywhere. A free service for automating retail sales at a trading facility by controlling a cash register. Focused on individual entrepreneurs and small businesses in general. Allows you to connect to a cash register via various communication channels and print fiscal documents (receipts), transfer data to a fiscal data operator and fully comply with the requirements of the new version of federal law No. 54-FZ.
Super Warehouse
big bird
My warehouse
AccountingCloud
cloud shop
1C: Trade management
Eventually
excel
Automation
Program "1C: Warehouse accounting"
Optimal solution
"Antonex"
"VVS Office"
"Commodity-Money-Commodity"
"Info-Enterprise"
"Openwork"
Microinvest
Other Solutions
Conclusion
Warehouse accounting program MySklad and its advantages
How to keep inventory records in Excel?
Excel table "Warehouse accounting"