Accounting for the movement of goods in excel. Inventory control

Excel can be an excellent tool for inventory control in any manufacturing organization or trading company that keeps records of materials, finished products and raw materials used. Spreadsheets can help with this tricky business.

Where can spreadsheets be used? Large organizations purchase ready-made solutions in electronic format for these purposes. However, such solutions are quite expensive. Some complex programs even require hiring a qualified employee with a fairly high salary to work in the warehouse. Small start-up companies cannot do this. But there is a way out: Excel spreadsheets can be used for inventory control. This electronic tool is second only to the office one in popularity. Word program... Functional Microsoft Excel will be quite enough to solve the main tasks of warehouse accounting.

Important rules

Users who are interested in issues related to warehouse management should seriously approach the issue of creating their own computer program... In this case, it is necessary to adhere to the following important rules. Initially, all reference books should be created as detailed and accurate as possible. In particular, one cannot be limited to a simple indication of the names of goods. It is also necessary to indicate articles, expiration dates, codes, and so on. Typically, opening balances are entered into tables in monetary terms. It is necessary to follow the chronology and enter information about the receipt of certain goods at the warehouse earlier than about their shipment to the buyer. It is imperative that you complete an inventory before filling out Excel spreadsheets. It is necessary to foresee what additional information may be required and enter it so that in the future you do not have to clarify information on each of the goods.

Before you start designing spreadsheets to keep your warehouse running, you need to consider its specifics. In this case, the following general recommendations can be made:

1. It is necessary to compile the directories "Suppliers", "Buyers" and "Points of account of goods". The last point is optional for small companies.
2. When using a relatively constant list of products, it is advisable to create the nomenclature in the form of a database on a separate sheet. Expense, income and reports in the future must be filled out with links to it.
3. In the table Excel sheet with the heading "Nomenclature" should contain the following data: product name, product groups, product codes, units of measurement, and so on.
4. The report is generated using the PivotTable tool.
5. The receipt of goods at the warehouse is recorded on the "Incoming" sheet.
6. To track the current state, you need to create sheets "Balances" and "Expenses".

Creation of reference books

In order to develop a program for inventory control in Excel, you need to create a file with any name. Its name may sound, for example, "Warehouse". Now you need to fill out the reference books. To prevent the headings from "running over", you need to fix them. To do this, on the "View" tab in Excel, click on the "Freeze Areas" button. The table "Buyers" looks approximately the same. Free software may well provide a convenient and partially automated warehouse accounting, if you create in it an auxiliary directory of goods issue points. However, it will only be required if the company has several retail outlets or warehouses. As for organizations that have only one issue point, then it makes no sense for them to create such a directory.

Own program "Warehouse": how to create a sheet "Incoming"

First of all, you will need to create a table for the item. Its headings should look like this: "Product name", "Sort", "Unit of measurement", "Characteristic," Comment. After that, you need to select the range of this table. In the field "Name", which is located directly above the cell with the name "A", you must enter the word "Table 1". The same is done with the corresponding range on the "Suppliers" sheet. In this case, you must indicate "Table 2". Incoming and outgoing transactions are recorded on two separate sheets. They allow you to keep inventory in Excel.

Accounting automation

You can make warehouse accounting in Excel more convenient if the user independently selects a supplier from a ready-made list, as well as selects the point of accounting and the name of the product. In this case, the vendor code and unit of measure should be automatically displayed in the table without operator intervention. Date, cost, invoice number and quantity are entered manually. The Warehouse program will automatically calculate the cost using mathematical formulas. All reference books for this need to be formatted in the form of a table. A drop-down list must be created for the "Name" column. To do this, select the entire column except the header, find the "Data" tab and click on the "Data Check" icon. In the field "Data type" you need to find the word "List". In the “Source” field, you must specify the function “= INDIRECT (“ item! $ A $ 4: $ A $ 8 ”). Opposite the items "Ignore empty cells" and "List of acceptable values" must be checked. If everything is done according to the rule, then when filling in the first column, you can simply select the name of the product from the list. In the “Unit. rev. " the corresponding value will appear. About the same, autocomplete is created for the "Supplier" and "Code" columns, as well as a drop-down list. To fill in the "Cost" column, you must use the multiplication formula. It should look like "= price * quantity". You also need to create a drop-down list called "Accounting points". It will indicate the place where the received goods were sent. This is done in the same way as in the previous cases.

"Turnover list"

Now that you have practically created a convenient tool that allows your company to keep inventory records in Excel for free, all that remains is to teach the program to display the report correctly. To do this, you need to start working with the corresponding table. We set zeros at the beginning of the time period, since we are just going to keep inventory records. If we have already carried it out earlier, then the remainders should be displayed in this column. In this case, the units of measurement and names of goods will have to be taken from the nomenclature. To facilitate inventory control, Excel will have to fill in the Receipt and Shipment columns using the SUMIFS function. Mathematical operators should be used to account for stock balances. Over time, you can independently make adjustments to the "Warehouse" program to make the accounting of your products as convenient as possible.

Warehouse accounting in Excel is suitable for any trade or industrial organization where it is important to take into account the amount of raw materials and materials, finished products. For this purpose, the company maintains warehouse records. Large firms, as a rule, purchase ready-made solutions for keeping records in in electronic format... There are a lot of options today, for various areas of activity.

In small businesses, the movement of goods is controlled on their own. For this purpose, you can use Excel tables. The functionality of this tool is quite enough. Let's get acquainted with some of the possibilities and independently compose our own warehouse accounting program in Excel.

At the end of the article, you can, which is disassembled and described here.

How to keep inventory in Excel?

Any custom-built warehouse management solution, either self-created or purchased, will work well only if the basic rules are followed. If you neglect these principles at the beginning, then later the work will become more difficult.

1. Fill out directories as accurately and in detail as possible. If this is a nomenclature of goods, then it is necessary to enter not only names and quantities. For correct accounting, you will need codes, articles, expiration dates (for individual industries and trade enterprises), etc.
2. Opening balances are entered in quantitative and monetary terms. It makes sense to take an inventory before filling in the appropriate tables.
3. Observe the chronology in registering transactions. Data on the receipt of products at the warehouse should be entered earlier than on the shipment of goods to the buyer.
4. Do not disdain additional information... To draw up a route sheet, the driver needs the date of shipment and the name of the customer. For accounting - payment method. Each organization has its own characteristics. A number of data entered into the warehouse accounting program in Excel will be useful for statistical reports, accrual wages specialists, etc.

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 you can deduce general recommendations:

1. For correct inventory control in Excel, you need to compile reference books. They can take 1-3 sheets. This is the directory "Suppliers", "Buyers", "Points of account of goods". In a small organization, where there are not many contractors, reference books are not needed. It is not necessary to make a list of points of accounting of goods if the company has only one warehouse and / or one store.
2. With a relatively constant list of products, it makes sense to make the nomenclature of goods in the form of a database. Subsequently, the receipt, expense and reports should be filled out with references to the item. The "Nomenclature" sheet may contain the name of the product, product groups, product codes, units of measurement, etc.
3. The receipt of goods at the warehouse is recorded on the "Incoming" sheet. Disposal - "Expense". The current state is "Balances" ("Reserve").
4. Results, the report is generated using the PivotTable tool.

To prevent the headings of each inventory control table from running 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 records, the user will see the column headings.



Excel spreadsheet "Inventory accounting"

Let's look at an example of how a warehouse control program in Excel should work.

Making "Directories".

For supplier data:

* The form may be different.

For customer data:

* Please note: the title bar is docked. Therefore, you can enter as much data as you like. The column names will be visible.

To audit the points of issue of goods:

We repeat once again: it makes sense to create such directories if the enterprise is large or medium-sized.

You can make a product list on a separate sheet:

IN this example in the table for inventory control, we will use drop-down lists. Therefore, we need Directories and Nomenclature: we will make links to them.

Name the range of the "Nomenclature" table: "Table1"... To do this, select the table range and enter the corresponding value in the name field (opposite the formula line). 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 the incoming and outgoing transactions, we fill in two separate sheets.

We make a hat for the "Parish":

Next stage - automation of filling the table! It is necessary to make sure that the user chooses from a ready-made list the name of the product, supplier, accounting point. 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, we will format all directories as tables. This is necessary so that later you can add, change something.

Create a drop-down list for the "Name" column. Select the column (no header). Go to the Data tab - Data Validation tool.

In the "Data type" field, select "List". An additional field "Source" appears immediately. To get the values ​​for the drop-down list 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 “Unit. rev. " the corresponding value should appear. Let's do it using the VLOOKUP and UND function (it will suppress the error as a result of the VLOOKUP function when referencing 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 "Points of account" - where the received 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 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 kept. If it was previously conducted, then this column will contain leftovers. Names and units of measure are taken from the product range.

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).

So the independently compiled program is ready.

The program is designed for material accounting of resources different types... The implementation of accounting in value terms is possible. Supports multiple storage locations, production consumption and scrap. Reporting forms allow you to track the movement of resources and receive operational information for each point of accounting.

Introduction

The program can be used as the simplest system warehouse accounting by places of storage of resources at enterprises using a small range of goods, raw materials and materials. Accounting is carried out in natural units. The cost accounting in the automatic mode is not implemented, but there is a possibility of manual input of indicators in monetary units.

The initial data for generating reports are three types of tables:

• Parameters
• References
• Magazines

Moreover, the reports themselves are also Excel tables.

The openness of the spreadsheet interface provides maximum flexibility in calculations. The user has access to all the functions of a powerful computing device and the Excel interface. Features of the program implementation imply self-configuration logs and reports for specific user tasks.

Changes in version 2.6

• Since version 2.6, the old format is not supported workbook XLS. The program file is saved in the format XLSX / XLSM and works in Excel since 2007 ( 2007-2016 ). Program in format XLS are only available in version 2.0, and can only be purchased on special request.
• Updated appearance workbooks in accordance with the design of the latest Microsoft versions Office.
• Second summary report for storage locations.
• The default view of the first report has been converted to allow copying and pasting of the balances at the beginning of a new period.
• Drop-down list for searching dictionary elements by the first letters of a word. It is activated by double clicking on the cell.
• Red highlighting of journal items not found in directories.

Changes in version 2.0

• Points of account and counterparties are divided according to different directories.
• The limitation on the number of suppliers and buyers has been removed.
• Added resource groups for filtering in reports.
• Initial balances are filled in a separate journal.
• Removed cost indicators in magazines, added an average price indicator in reference books.
• New report on storage locations in the form of an Excel pivot table.

Opportunities and Limitations

Excel spreadsheets have internal restrictions on the amount of information processed. The program is not intended to replace large accounting systems for hundreds of thousands of items. But in most SMBs, the volume and complexity of the data is available for processing in Excel.

The main file does not contain a large number calculations, special algorithms are used for reports, which also do not have formula links with the original data. Therefore, large amounts of data provide normal performance even in Excel automatic calculation mode. Switching to manual calculation mode is recommended only on outdated computers.

IN automatic calculation mode Excel recommend the following parameters when working on high-performance computer:

• Number of resources (nomenclature) - up to 2000
• Number of metering points - up to 200
• The number of operations (lines) in each journal - up to 10,000
• File size (xlsx) - up to 10Mb

IN manual mode Excel calculations the limitations are mainly related only to the capabilities of the computer. For normal operation of reports, we recommend the following restrictions:

• Number of resources (nomenclature) - up to 5000
• Number of metering points - up to 500
• The number of operations (lines) in each journal - up to 30,000
• File size (xlsx) - up to 25Mb

In the case of using additional calculations (full openness of the program allows you to configure any additional calculations), the performance limits may be more stringent.

To reduce data, you can generate new file and transfer there directories and initial balances for all accounting points.

Installation and launch

The composition of the file is described on home page programs - "Home".

As already noted, the program consists of parameter tables, reference books, logs and reports. You can navigate to these objects through hyperlinks on the "Home" page. You can also use standard ways to navigate Excel sheets and cells.

The easiest way to return to the page with content is by clicking special button in the header of any program worksheet

The page navigation options are described on the service sheet. Preset and in the hidden third column of the Home sheet.

Parameters

The program contains several general parameters that control the characteristics of the work:

All parameters can be changed at the discretion of the user.

References

Reference books are used for calculations and facilitate the entry of data into journals (through selection from lists). Data entry into directories is carried out as information becomes available.

Buyers and Suppliers

Lists of accounting counterparties. It is allowed to add lines down without restrictions.

List of storage locations for resources participating in the accounting system. These can be separate storage bins, storage areas, production areas or premises. It is allowed to add lines down without restrictions.

Groups and Resources

Two interconnected reference books for describing resources of all kinds stored at metering points. Resources include: finished products, semi-finished products, raw materials and materials. Grouping is used by the convenience of filtering reports. It is allowed to add lines down without restrictions.

Table fields (all are available for editing):

Operation logs

All warehouse transactions required for generating reports are entered into special tables, divided by type of operation.

Stock data at the start of accounting. The date is defined in Parameters.

Coming from suppliers

Receipts of resources from suppliers are entered into the table. The sequence by dates or order numbers is not important.

Table fields:

Heading	Description	Input availability	Obligation
date	Date of operation.	Yes	Yes (start typing)
Supplier order code	Arbitrary transaction code.	Yes	Not
Resource	The name of the resource coming from the supplier.	List	Yes
Warehouse		List	Yes
Volume / quantity		Yes	Yes
EI	The unit of measure for the resource.	Not	Calculated
Comment		Yes	Not

date

The table contains information about the consumption of raw materials and materials in the production process. The order in terms of dates or order numbers is not important. This table is not required for the sales organization.

Table fields:

Heading	Description	Input availability	Obligation
date	Date of operation. Be sure to start entering new data from this field.	Yes	Yes (start typing)
Manufacturing order code	Arbitrary transaction code.	Yes	Not
Warehouse for the consumption of raw materials and materials	The accounting point from which the resource is consumed (written off)	List	Yes
Raw materials and supplies	The name of the resource consumed in the production process.	List	Yes
Volume / quantity	The amount of the resource in natural units.	Yes	Yes
EI	The unit of measure for the resource.	Not	Calculated
Amount accrued.	The amount of the transaction in the base currency.	Yes	Calculated
Comment	An arbitrary comment to the operation.	Yes	Not

In addition to the described fields, the table contains several special service columns.

To delete a record, just clear the field date standard Excel tools. It is also possible to delete entire lines.

The table contains information on the production of finished products and semi-finished products. The sequence by dates or order numbers is not important. This table is not required for the sales organization.

Table fields:

Heading	Description	Input availability	Obligation
date	Date of operation. Be sure to start entering new data from this field.	Yes	Yes (start typing)
Manufacturing order code	Arbitrary transaction code.	Yes	Not
Products and services	The name of the resource formed during the production process.	List	Yes
Warehouse	The accounting point to which the resource comes from production.	List	Yes
Volume / quantity	The amount of the resource in natural units.	Yes	Yes
EI	The unit of measure for the resource.	Not	Calculated
Comment	An arbitrary comment to the operation.	Yes	Not

In addition to the described fields, the table contains several special service columns.

To delete a record, just clear the field date standard Excel tools. It is also possible to delete entire lines.

Transactions for transferring resources between internal warehouses are entered into the table. The order in terms of dates or order numbers is not important. The initial balances stored in warehouses as of the start date of accounting are also entered here.

Table fields:

Heading	Description	Input availability	Obligation
date	Date of operation. Be sure to start entering new data from this field.	Yes	Yes (start typing)
Order code	Arbitrary transaction code.	Yes	Not
Source warehouse	The accounting point from which the resource is moved. Is not filled in when entering initial balances.	List	Yes (except for initial balances)
Resource	The name of the resource to be moved.	List	Yes
Receiving warehouse	The accounting point to which the resource is received.	List	Yes
Volume / quantity	The amount of the resource in natural units.	Yes	Yes
EI	The unit of measure for the resource.	Not	Calculated

Accounting for goods requires the use of a reliable and modern software, capable of fully providing all the necessary operations for maintaining statistics of the arrival and departure of goods to the warehouse.

Convenient cloud-based system for automation of trade and warehouse accounting that replaced Excel!
Increase your efficiency and increase your profits!

In particular, MS Excel has a set of functions in order to make the accounting of goods more complete. Learn how to keep track of store items in Excel. Let's consider the main advantages and disadvantages of this program as a tool for accounting for goods.

Features of accounting of goods in Excel

Accounting for goods in Excel is carried out in special tables that allow you to select a number of separate groups of goods depending on their purpose, consumption and some other features. In particular, thanks to this software product, you can perform a number of analytical functions and sequential operations, including using formulas.

At the same time, it is important to be able to work in Excel in order to fully use all the functions necessary for accounting for the sale of goods and services, to structure and analyze data to solve various business problems.

Control of the movement of goods in the warehouse

Excel program allows you to control the movement of goods in the warehouse, their arrival and departure, through the use of special tables.

In particular, it is possible to form a table with different columns in the program, depending on the user's needs for the necessary resources and options that the program gives. In the table, it is possible to display data on the operations performed, including indicating the balance in the warehouse, both for a specific group of goods and for the entire warehouse as a whole.

For each group of goods, a supplier is indicated so that, if necessary, you can quickly find out where this or that product or equipment came from in the warehouse. At the same time, all work is carried out sequentially, taking into account possible adjustments. In parallel with the layout of the table, it is also necessary to take into account the introduction and creation of additional documents, footnotes and attachments, for which free space must be allocated.

As a rule, detailed accounting of products available in the warehouse is due to the need to monitor the movement of inventory items during trading and, in particular, the requirement of strict reporting, therefore, a qualified specialist who is fluent in MS Excel should deal with accounting.

Useful "tricks" for inventory control in Excel

The first thing that can be advised to work in the program is to use all the elements of cell formatting in tables. For example, when it is necessary to arrange the head of a table in two lines, it is important to first provide word wrap in the cell itself. This technique will provide clarity and a great look for the table.

The program also allows you to insert special fonts. Their use is appropriate when it is necessary to highlight a number of products or categories depending on certain parameters and values.

In general, the most important groups of goods must be selected by means of appropriate operations on a cell, or a line. Columns can also be formatted, in which various groups of goods can be located, which are supposed to be processed using tables.

A modern solution for simple accounting - the online program Klass365

Unfortunately, Excel also has a number of shortcomings, sometimes drastically affecting the work with goods in the warehouse. These can be safely attributed to: too complex a set of operations, which will require a certain skill and qualifications, as well as too much time spent, sometimes simply unbearable in the face of time pressure.

Moreover, imagine how catastrophic it would be to lose data in the course of an accidental error, which when working with Excel program occur quite often. In this regard, it is necessary to choose a worthy, and most importantly, a free specialized program for maintaining all the necessary accounting.

The online program for accounting of goods in the warehouse Klass365 allows you to automate warehouse and trade accounting, work with online stores, a customer base and at the same time not waste time on implementation and training of personnel. The simple and well-thought-out interface of the program allows you to master it in no more than 15 minutes.

• Warehouse accounting: acceptance, write-off, revaluation, etc.
• Automatic statement of accounting and accompanying documentation
• Work with an unlimited number of warehouses
• Storage time control
• Inventory planning based on sales rates
• Reports for any period and area of ​​work in 1 click

It is not difficult to guess that accounting in Excel spreadsheets is becoming a thing of the past and a more convenient and functional program comes to replace it - automated system business management Class365. The free online solution allows you to work in any convenient place, without being tied to a work computer. Use modern solutions for your business and get stunning results!

However, when filling out incoming or outgoing documents, some values ​​still have to be hammered in by hand.

These include:

• date of the document;
• quantity of goods;
• Document Number;
• other frequently changing parameters.

Using the built-in Excel tools it is possible to achieve automatic filling of several columns based on the data of the directory. However, you will hardly be able to configure this functionality yourself without deep knowledge of the program.

You can add elementary formulas yourself, for example, specify a column with the total cost of a product by multiplying the quantity by the price.

In the above way, the sheets are also "Income" and "Expense". Their separate maintenance is convenient for the subsequent quick search of the desired document.

Formation of the turnover sheet

You can make a turnover sheet yourself, but you have to understand some of the functions of the spreadsheet editor. Programming skills are not required here.

On a separate sheet, you can draw up information on inventory balances in order to understand the need to purchase a particular item of the assortment.

Tracking critical balances

Keeping records of goods in the store in Excel can be configured in such a way that information on the need to purchase a particular assortment item is displayed on the sheet with product balances. Further it will be considered simplest example how to arrange it in a spreadsheet editor.

In the proposed example, there are three locations for storing goods with an indication of the balances in each of them. Using the IF (OR ...) function, you can set automatic check compliance with the stock rate for each warehouse. The final formula will look like this:

IF (OR (C3<3;D3<3;E3<3);«Необходимо пополнение склада»;«Товара достаточно»).

Thus, if the balance falls in any storage location less than three units, the user will see a message about the need to purchase or internal movement of goods. In the same way, you can monitor the reverse process - packaging with a certain nomenclature item. The formula used is very simple and can always be added to the prepared table.

This method of monitoring values ​​is applicable not only to warehouse balances. Similarly, you can analyze the following indicators:

• the volume of work performed or sales by employees;
• increase in gross turnover or profit;
• identification of trade downturns for certain groups of goods and other indicators.

Excel can provide entrepreneurs with a variety of analytical tools when accounting for retail sales. One of its difficulties is the small amount of professional training material and the need to independently compile all the formulas.

Pros of accounting for goods in the store in Excel

Try all the features of the EKAM platform for free

Read also

Privacy agreement

and processing of personal data

1. General Provisions

1.1. This agreement on confidentiality and processing of personal data (hereinafter referred to as the Agreement) is freely accepted and of its own free will, applies to all information that LLC "Inseils Rus" and / or its affiliates, including all persons belonging to the same group with LLC "Inseils Rus" (including LLC "EKAM service") may receive information about the User while using any of the sites, services, services, computer programs, products or services of LLC "Inseils Rus" (hereinafter referred to as the Services) and the course of execution of any agreements and contracts with the User by Insales Rus LLC. The User's consent to the Agreement, expressed by him within the framework of relations with one of the listed persons, applies to all other listed persons.

1.2 Use of the Services means the User agrees with this Agreement and the terms and conditions specified therein; in case of disagreement with these conditions, the User must refrain from using the Services.

"Insales"- Limited Liability Company "Inseils Rus", OGRN 1117746506514, INN 7714843760, KPP 771401001, registered at the address: 125319, Moscow, Akademika Ilyushin st., 4, building 1, office 11 (hereinafter - "Insales" ), on the one hand, and

"User" -

or an individual who has legal capacity and is recognized as a participant in civil legal relations in accordance with the legislation of the Russian Federation;

or a legal entity registered in accordance with the legislation of the state of which such a person is a resident;

or an individual entrepreneur registered in accordance with the legislation of the state of which such a person is a resident;

which has accepted the terms of this Agreement.

1.4 For the purposes of this Agreement, the Parties have determined that confidential information is information of any nature (production, technical, economic, organizational and others), including the results of intellectual activity, as well as information about the methods of carrying out professional activities (including, but not limited to: information about products, works and services; information about technologies and research projects; information about technical systems and equipment, including software elements; business forecasts and information about prospective purchases; requirements and specifications of specific partners and potential partners; information, related to intellectual property, as well as plans and technologies related to all of the above) communicated by one party to the other in writing and / or electronic form, clearly designated by the Party as its confidential information.

1.5. The purpose of this Agreement is to protect confidential information that the Parties will exchange during negotiations, concluding contracts and fulfilling obligations, as well as any other interaction (including, but not limited to, consulting, requesting and providing information, and performing other instructions).

2. Obligations of the Parties

2.1. The Parties agree to keep secret all confidential information received by one Party from the other Party during the interaction of the Parties, not to disclose, disclose, disclose or otherwise provide such information to any third party without the prior written permission of the other Party, with the exception of cases specified in the current legislation, when the provision of such information is the responsibility of the Parties.

2.2. Each of the Parties will take all necessary measures to protect confidential information at least using the same measures that the Party applies to protect its own confidential information. Access to confidential information is provided only to those employees of each of the Parties who reasonably need it to perform their official duties for the implementation of this Agreement.

2.3. The obligation to keep confidential information in secret is valid within the term of this Agreement, the license agreement for computer programs dated 01.12.2016, the agreement of accession to the license agreement for computer programs, agency and other agreements and for five years after termination their actions, unless the Parties separately agree otherwise.

(a) if the information provided has become publicly available without violating the obligations of one of the Parties;

(b) if the information provided has become known to the Party as a result of its own research, systematic observations or other activities carried out without the use of confidential information received from the other Party;

(c) if the information provided has been lawfully obtained from a third party without the obligation to keep it secret until it is provided by one of the Parties;

(d) if the information is provided at the written request of a state authority, other state authority, or local self-government body in order to perform their functions and its disclosure to these authorities is mandatory for the Party. In this case, the Party must immediately notify the other Party about the received request;

(e) if the information is provided to a third party with the consent of the Party, the information about which is being transferred.

2.5. Insales does not verify the accuracy of the information provided by the User and does not have the ability to assess his legal capacity.

2.6 The information that the User provides to Inseils when registering in the Services is not personal data, as they are defined in the Federal Law of the Russian Federation No. 152-FZ of 07/27/2006. "About personal data".

2.7 Insales reserves the right to amend this Agreement. When making changes in the current edition, the date of the last update is indicated. The new version of the Agreement comes into force from the moment it is posted, unless otherwise provided by the new version of the Agreement.

2.8. By accepting this Agreement, the User realizes and agrees that Inseils can send the User personalized messages and information (including but not limited to) to improve the quality of the Services, to develop new products, to create and send personal offers to the User, to inform the User about changes in Tariff plans and updates, to send the User marketing materials on the topic of the Services, to protect the Services and Users and for other purposes.

The user has the right to refuse to receive the above information by notifying this in writing to the email address of Inseils -.

2.9. By accepting this Agreement, the User understands and agrees that the Inseils Services may use cookies, counters, other technologies to ensure the performance of the Services in general or their individual functions in particular, and the User has no claims against Inseils in this regard.

2.10. The user is aware that the equipment and software used by him to visit sites on the Internet may have the function of prohibiting operations with cookies (for any sites or for certain sites), as well as deleting previously received cookies.

Insails has the right to establish that the provision of a certain Service is possible only provided that the acceptance and receipt of cookies is permitted by the User.

2.11. The user is solely responsible for the security of the means chosen by him to access the account, and also independently ensures their confidentiality. The User is solely responsible for all actions (as well as their consequences) within or using the Services under the User's account, including cases of voluntary transfer of data by the User to access the User's account to third parties on any terms (including under contracts or agreements) ... At the same time, all actions within or using the Services under the User's account are considered to have been performed by the User himself, except for cases when the User has notified Inseils about unauthorized access to the Services using the User's account and / or about any violation (suspicions of violation) of the confidentiality of his account access means.

2.12 The User is obliged to immediately notify Insails about any case of unauthorized (not authorized by the User) access to the Services using the User's account and / or about any violation (suspicion of violation) of the confidentiality of his account access means. For security purposes, the User is obliged to independently carry out a safe shutdown under his account at the end of each session of work with the Services. Insales is not responsible for possible loss or damage to data, as well as other consequences of any nature that may occur due to violation by the User of the provisions of this part of the Agreement.

3.Responsibility of the Parties

3.1. A Party that has violated the obligations stipulated by the Agreement regarding the protection of confidential information transferred under the Agreement is obliged to compensate, at the request of the affected Party, for real damage caused by such a violation of the terms of the Agreement in accordance with the current legislation of the Russian Federation.

3.2. Compensation for damage does not terminate the obligations of the offending Party to properly fulfill its obligations under the Agreement.

4.Other provisions

4.1. All notifications, inquiries, requirements and other correspondence under this Agreement, including those that include confidential information, must be made in writing and delivered in person or by courier, or sent by e-mail to the addresses specified in the license agreement for computer programs dated 01.12.2016, the agreement of accession to the license agreement for computer programs and in this Agreement or other addresses that may be further indicated by the Party in writing.

4.2 If one or more provisions (conditions) of this Agreement are or become invalid, then this cannot serve as a reason for the termination of other provisions (conditions).

4.3 The law of the Russian Federation shall apply to this Agreement and the relationship between the User and Insales arising in connection with the application of the Agreement.

4.3. All suggestions or questions regarding this Agreement, the User has the right to send to the Inseils User Support Service or to the postal address: 107078, Moscow, st. Novoryazanskaya, 18, p. 11-12 Business Center "Stendhal" LLC "Inseils Rus".

Date of publication: 01.12.2016

Full name in Russian:

Limited Liability Company "Insales Rus"

Abbreviated name in Russian:

LLC "Insales Rus"

Name in English:

InSales Rus Limited Liability Company (InSales Rus LLC)

Legal address:

125319, Moscow, st. Academician Ilyushin, 4, building 1, office 11

Mailing address:

107078, Moscow, st. Novoryazanskaya, 18, p. 11-12, BC "Stendhal"

INN: 7714843760 Checkpoint: 771401001

Bank details: