How to conduct an inventory in 1s 8.3 accounting. Inventory in the configuration "1C: Retail. Registration of sorting of goods

To start the inventory, you need to create the document "Order for the recount of goods" (Warehouse - Orders for the recount of goods).

The following fields must be filled in the document:

• Store - the store where inventory is to be taken
• Warehouse - the warehouse in which inventory must be carried out
• Inventory period - for what period the inventory is carried out
• Organization
• Selection - sets the rules for selecting goods for which it is necessary to conduct an inventory. This can be a complete inventory or an inventory with a selection, for example, by product group:

After filling in the required fields, it is necessary to post the document and enter the document "Recalculation of goods" on its basis:

The document is filled in automatically. But pay attention to the date of the document. The remaining goods in the document will fall exactly at the end of this date, even if a different period was specified in the order for the recalculation of goods.

Go to the "Products" tab. The bookmark was automatically filled with data about the product and balances:

To fill in prices, select all lines of the document using the key combination Ctrl + A and select the "Fill prices" command. Prices can be entered in three ways:

• At retail prices
• At cost
• By price type

The actual quantity of goods can be filled in manually or by the command Fill in - Fill in the actual quantity according to the accounting. If you select the second option, the program will automatically enter the quantity and, if necessary, you can change it manually:

The "Deviation" column is automatically calculated as the difference between the fact and the account.

Do you have a question, do you need the help of a consultant?

If, as a result of the inventory, a product was found that was not automatically included in the “Recalculation of goods” document, then this product must be manually added to the document by clicking the “Add” button and fill in the actual quantity. In this case, the accounting quantity will not be filled:

For the convenience of conducting an inventory from the document "Recalculation of goods", you can print out the form of inventory of goods with an empty column "Fact":

The convenience of this particular form is that if an article or code is set in the print forms settings (Administration - Print forms, reports and processing - Additional column for print forms), then this field will be displayed in this print form:

After entering the actual data, you need to post the document.

To make adjustments to the balance of goods in the warehouse based on the results of the inventory, it is necessary to enter the documents "Write-off of goods" and "Receipt of goods" on the basis of an order for the recalculation of goods.

A write-off of goods is created if a shortage of goods is detected (i.e. the actual quantity is less than the accounting one):

A posting of goods is created if a surplus of goods is found (that is, the actual quantity is greater than the accounting quantity).

In today's material, we will talk about the algorithm for conducting an inventory in the software product "1C 8.3 Accounting 3.0" and how, based on its results, to write off or credit products. This instruction is well suited for software solutions "1C", "1C" and "1C Trade Management".

The general inventory scheme in the 1C software product is as follows:

1. Formation and completion of the inventory document, which exists to fill in the actual information about the absence or presence of the item in the warehouse. The document does not create any postings.

2. If a shortage of products is found, it must be written off with a document called "Write-off of goods". Less commonly, you can use the "Retail Sales Report".

3. If there is an excess, then it is accounted for with the participation of "Goods posting".

Let's take a closer look at these documents.

Conducting an inventory of products in the warehouse

In the interface of the above software product, the inventory document log can be found in the section called "Composition":

In order to form a new inventory, in the journal that opens, you must click on the "Create" button. Fill in the header of the document with details named "Organization", "Warehouse":

The next step is filling in the accounting quantity of products in the warehouse. To perform this operation, you need to click above the tabular section called "Fill" - "Fill in stock balances":

We emphasize that the accounting quantity is not filled in at the current moment, but on the date of the document!

A list of all available products will appear in the table (according to accounting information in the 1C software product):

We see 2 columns:

Quantity fact - this information must be filled in with real balances in the warehouse. By default, the software product fills in this amount from accounting information;

Quantity accounting - how many products are available according to the software product.

As soon as all the necessary information is entered, write down the document. Now you, by clicking on the "Print" button, can print the necessary primary documents:

Comparative sheet - "".

Please note that the inventory of postings in accounting itself does not produce. Now you need to capitalize or write off the products that need it.

"1C": write-off of products from the warehouse

In order to write off goods based on the inventory, you need to create a new write-off document.

In the "inventory" press the button called "Create on the basis" - "Write-off of goods":

The software product "1C Accounting 8.3" will automatically create write-offs for positions in which there was a shortage:

If everything is done correctly, then just press the key called "Swipe". Now, by writing off, we will check the postings:

Posting products for inventory

Posting of products is carried out similarly to write-off. In the inventory, click the button "Create based on" - "Receipt of goods":

The system will generate the necessary document, where you will need to fill in the details called " Article" in order to reflect it on the account "91.01":

So with the help of the "Post" button, we fix the data. Then, according to the credited products, we check the correctness of the generated entries in 1C.

Helps many businesses to run their businesses successfully. However, in order to use it effectively, you need to know the basics of management. Next, you will learn how to conduct an inventory in 1C.

Inventory is the main way to check the availability of property. When conducting it, we compare the data that the program contains with the actual number of goods in the warehouse. Like the rest of the 1C functions, inventory is a mandatory component of accounting. Therefore, it is important to be able to carry it out.

Users of "One Es" have the opportunity to verify the actual and documentary presence of the assortment using a special document. Rather, there are several documents that serve to make an inventory of warehouse property. The main one, surprisingly, is called “Inventory of goods”.

• In the menu, select "Documents", then "Stocks" and there we need the inventory.
• Based on the version of the program, the interface may look different, but the main points are always present: warehouse, date, number, organization, full name of the person in charge, nomenclature.
• As a rule, it is convenient to take into account for certain nomenclature items, since the number of goods can be very large. To do this, you need to put a tick on the nomenclature position, and then select the group of goods that you want to inventory. If accounting is required for all groups, it is easier to create several documents.
• We select filling according to the balances in the warehouse for the so far empty table "Products". All products in this group will be displayed.

• One of the columns will show the number of units of property that the program “counted”: “Accounting. Quantity". You will have to count all the items in the warehouse yourself, after which they will need to be entered in the "Quantity" column.
• The Deviation column will show zeros under ideal conditions. This means that the number of goods according to the documents and in fact is the same. If the result is minus, then there is a shortage. The plus sign is an overabundance.
• With the "Save" button, we will save the document to the database. It can also be printed in the INV-3 form.

What if it doesn't match?

Taking inventory is only half the battle. It is very often found that the amount of property according to documents and in reality are two different figures. Any accountant knows not to worry too much. Another question is how to document the difference.

lack of goods

If there is a shortage of property, a write-off must be carried out. Write-off will be easily done on the basis of the inventory.

• Through the menu, again select the item "Documents", "Stocks", and then "Write-off of goods".

Write-off of goods

• The completed form looks almost the same. Here you need to specify on the basis of which inventory the write-off is made.
• You can also add units of goods manually using the "Add" button.
• Click "OK", after which the data on the availability of property will be corrected.

surplus

An overabundance of goods is also easily corrected. But already with the help of another document - the posting of goods.

1. In the same menu item, select the “Goods posting” we need.
2. The program will again do everything automatically if you substitute data from the inventory. Therefore, as a rule, the user does not have to do anything on his own.
3. If necessary, you can edit the table manually by adding any units of property.
4. With the "OK" button, 1C corrects all the entered data and enters them into the database.

It is important to note that in new versions of the program, the operations to eliminate excess and shortage are simplified. However, at the same time, the program may not allow so easy to eliminate the documentary balance that is not in stock. Sometimes it may be necessary to indicate the guilty person to whom material damage will be recorded. Without exceeding the limits of certain norms, the shortage is simply included in the costs.

Adjustment

An adjustment is made when it is required to sort the property according to more flexible criteria. For example, in the warehouse there are several extra white washing machines, but there are not enough black ones of the same model. For such situations, an adjustment document is provided.

1. In the already familiar menu item, select "Corrections of product series and characteristics."
2. Here we have to type it ourselves, since the program does not know what we want to change. Add a new row to the table.
3. Three columns that need to be filled in: “Characteristic of the nomenclature (old)”, “New characteristic of the nomenclature” and “Nomenclature” are simple.
4. In the very first one, we indicate the name without a different criterion, that is, "Washing machine", for example. We also indicate the quantity.
5. In the old and new nomenclatures, we indicate the characteristics that need to be changed.
6. After that, a certain number of black cars will be replaced by white ones in the database. Pressing the "OK" button will force the program to make a replacement.

Now you are familiar with one of the main accounting tools, with inventory in the 1C program. It is recommended to do it at least once a year in any large organizations. It is worth keeping records of property separately for each warehouse or even for each group of goods, so as not to get confused in a large assortment.

Comparison of documentary data on the presence and movement of material assets with their actual state is an important point not only for regulatory authorities, but also for conducting successful activities themselves. This is achieved through inventory. And now, when all accounting is kept in the 1C program, then the inventory is carried out in the same way.

General features of inventory in 1C

The widespread use of 1C in accounting allows you to achieve automation of the inventory process with any volume of accountable materials and regardless of the remoteness of the warehouse or. Advantages of the method:

• The program already contains information on product groups.
• There is no need for special forms, as they can be printed already filled out.
• A simple calculation method is “hardwired” into the program.
• Errors and the influence of the human factor are minimized.
• Decreased time for the procedure.

Inventory in 1C has its own characteristics, which are as follows:

• You need to install the latest version of the program.
• A barcode reader is required.
• All primary documents on the movement of the MC must be entered into 1C correctly.
• Turnover balance entries to form according to the accounts of the corresponding accounting. The results of the inventory are checked against them. The total should match.
• The inventory is carried out separately by y (or materially responsible).
• Re-grading is not allowed. Adjustment is possible only in one period.

The general rules for inventory through 1C are shown in this video:

Inventory and property management

The inventory procedure is established in the guidelines of the Ministry of Finance and takes into account all the features of various configurations of the 1C program. How to conduct an inventory: for this there is a special window "Inventory of goods", in which you can create a new document to record the actual and documented comparison of the balance of inventoried materials. In this case, a discrepancy between the value of real and recorded balances will be revealed. More details below.

8.3 and 8.2

The principles of conducting an inventory for versions 8.2 and 8.3 are the same. There are only some differences in the interface, which, with sufficient experience in 1C, can be easily overcome. The sequence of actions in 1C 8.3 during inventory and goods in the warehouse is as follows:

• Select the section "Warehouse" in the menu and then from the list of inventory items - "Inventory of goods".
• In the window that appears, click on the "Create" button, and then "Inventory".
• Fill in the new tab that appears, indicating the inventory period, the order number and the reason for the inventory.
• Go to the "Inventory Commission" section and fill it out.
• Form order INV-22 and carry it out.
• The results of the inventory in 1C are documented. To do this, you need to create new tabs "" and "Receipt of goods", fill them in appropriately and carry out.

This program allows you to inventory work in progress. This is done like this:

• In the main menu, select “Production” and then in the “Product output” rubric - “Inventory of NZZHP”.
• In the inventory of work in progress window that opens, enter the necessary data and post them.
• Then select "Operations" and "Closing the month" from the menu.
• Execute this operation.
• Create a cost estimate. WIP will be displayed on a separate line.

In this 1C configuration, you can inventory off-balance accounts with mobile application 134. This can be done using the MTs 0.4 button, which can be added in the following sequence:

• Service.
• Additional reports.
• Additional external processing of the table.

1c accounting

The cash register inventory in 1C accounting is carried out by comparing the balances of money in the accounts, with information on bank statements from 1C and looks like this:

• In the "Bank and cash desk" section, select "Bank statements" from the bank items.
• Select account number by date.
• For analysis, in the "Reports" section, select sequentially: "Standard reports", "Turnover reports".
• Specify the account number and report generation.
• Form a selection based on the output data.
• Check the balance of funds by the days of the selected period.

The results are reflected in the act of inventory 1C. Its form can be filled in 1C only in manual mode.

And for the inventory of calculations, you must perform the following operations:

• Go to the main menu in the "Sale" and then - "Inventory of calculations".
• Then select the counterparty you are interested in.
• In the window that appears, full information about and will be displayed.

1C Retail

In the 1C retail configuration, it is convenient to inventory the balances, as well as their posting and writing off:

• Why you need to sequentially go: “Marketing”, “Stocks and Purchases”, “Analysts of Business Operations”.
• Create a new document “Inventory posting” or “Inventory write-off”, make an entry and close.
• After that, in the menu section "Warehouse" and then "Inventory", create an order for the recalculation of goods and fill it out.
• The next step is to create the "Recalculation of Goods" file, fill it in and go to the "Goods" tab.
• Fill in the nomenclature and prices.

The Law on Accounting prescribes an obligatory inventory for goods and materials. Inventory of goods and materials is carried out according to the plan approved by the head. In addition, the reason for conducting an unscheduled inventory may be a change in the materially responsible person (MOL). Lack of goods and materials, or in some situations - surpluses can be detected during the inventory.

The discrepancies found between the accounting data and the actual quantity of goods and materials should be registered in accounting (hereinafter BU) and tax accounting (hereinafter NU) in the period of discrepancy detection.

The 1C Accounting 8.3 program allows you to draw up documents for conducting an inventory of goods and materials, write off the identified shortage, and capitalize the identified surpluses.

How to take inventory in 1C 8.3

Step 1. Create a document Inventory of goods

The document Inventory of goods in 1C 8.3 is a universal document. It is used when conducting an inventory of the following types of goods and materials:

• Goods (account 41);
• Materials (account 10);
• Finished products (account 43);
• Non-current assets (account 08).

With the Goods inventory document, you can register inventory results for all types of warehouses:

• Wholesale;
• Retail (automated outlet);
• Non-automated outlet.

The Goods inventory document is created through the section Warehouse - Inventory - Inventory of goods:

We press the button Create:

Fill in the title of the document:

• In field Number
• In field From
• In field Organization- name of company;
• In field Stock- the warehouse for which the inventory is carried out. Installed from the directory Warehouses. If the field is left empty, then the document will display material assets for all warehouses;
• In field Responsible person- responsible person, indicated from the directory Individuals. If this field is left blank, then the document will display material assets for all responsible persons:

Step 2. Filling in the table of the document Inventory of goods

The table of the Goods inventory document contains three tabs: Goods, Inventory, Inventory Commission.

Fill in the Inventory Commission tab

Bookmark inventory commission, using button Add, we select members of the commission from the directory Individuals. The flag marks the employee who will be appointed as the chairman of the inventory commission:

Fill in the Inventory tab

• field Period- timing of the inventory;
• field Document- details of the document-base for the inventory;
• field Cause- the reason for the inventory:

After completing bookmarks Inventory and Inventory Commission, using button Seal, you can create a printed version of the Order on the inventory (form No. INV-22):

Fill in the Goods tab

Bookmark Goods filled in 1C 8.3 automatically when you click Fill in – Fill in according to stock balances:

• 1С 8.3 analyzes inventory balances at the time of the inventory at the specified Warehouse and MOT and displays the name of the inventory item (Nomenclature column), accounting quantity and accounting amount (according to accounting data) in the tabular part;
• In the columns Actual Quantity and Actual Amount. duplicate account information. This information is subject to change during inventory. The difference between the actual and the accounting quantity of goods and materials will be indicated in the Variance column;
• If an object is found that is not reflected in the accounting, then it is entered in the tabular section by clicking the button Add:

The Goods inventory document does not create ledger transactions. The document can be recorded and held by the button of the same name:

Step 3. Viewing printed forms of the document Inventory list of goods and Collation sheet

The results of the inventory in 1C 8.3 are reflected in the document Inventory list of goods. From the document Inventory of goods, a standard form Inventory inventory of goods (form No. INV-3) is printed. Press the button to open the required printable. Seal and select Inventory list of goods (INV-3):

An example of filling out page 2 of the report Inventory list of goods (INV-3):

If, as a result of the inventory, discrepancies were found between the accounting and actual data, then in 1C 8.3 you can make a collation statement in the INV-19 form.

We press the button Seal, choose the Collation Sheet (INV-19):

Sample collation sheet No. INV-19 of the results of the inventory of goods and materials:

Excess goods and materials during inventory in 1C 8.3

Posting of surplus goods and materials found as a result of the inventory:

• In accounting records, surplus inventory and materials are accounted for at current market value. Posting Dt of the accounting account - Kt of account 91.1 as other income;
• In NU, surplus goods and materials found during the inventory are taken into account as non-operating income by virtue of clause 20 of article 250 of the Tax Code of the Russian Federation.

Step 1. Creating a document Posting Goods and filling it out

To capitalize the surplus goods and materials found as a result of the inventory, use the button Create based on - Further Goods posting:

Filling in the header of the document Posting goods:

• In field Number- document number automatically generated by 1C 8.3;
• In field From– date, month, year of the document;
• In field Organization– filled in automatically from the Goods inventory document;
• In field Stock- a warehouse where the discovered goods and materials will be taken into account;
• In field Item of income- an item of other income and expenses, it will include income in BU and NU:

The tabular form of the Goods receipt document is filled in automatically from the Goods inventory document. All commodities and materials for which surpluses are identified are transferred to the tabular form:

Step 2. Posting the Goods posting document

By button Conduct

Step 3. Printing the Goods receipt document

Print the invoice by clicking on the button Invoice for posting goods:

Lack of goods and materials during inventory in 1C 8.3

During the inventory, a shortage of goods and materials may be established. In this case, in 1C 8.3 Accounting 3.0, it is necessary to enter an operation to write off goods and materials.

Step 1. Creating the Goods write-off document and filling it out

To draw up a shortage during inventory in 1C 8.3, a document is created . This document is generated from the Goods inventory document by clicking the button Create based on:

Completing the document Write-off of goods:

• In field Number- document number automatically generated in the 1C 8.3 database;
• In field From– date, month, year of the document;
• In field Organization– filled in automatically from the document Inventory of goods;
• In field Stock- a warehouse where goods and materials were taken into account.

The tabular form of the document is filled in automatically from the Inventory of goods document. All commodities and materials for which a shortage has been identified are transferred to the tabular form:

Step 2. Posting the Goods write-off document

By button Conduct the following entries will be created: