Conducting inventories

If there are several thousand items in the assortment of the store, inventory becomes a long and costly process. Selective inventories conducted on schedule provide a more accurate accounting of inventory balances and calculation of the need for an order. At the same time, careful control over the quality of goods on the shelves is carried out.

The possibility of planning partial inventories with indication of the rules for selecting goods is provided. The program includes schemes for selecting goods for selective inventories, for example, by product group, zero or negative balances, written-off goods. The list of selections can be expanded.

Simultaneous recalculation of goods by several groups of accountants with control over the process of completing tasks is supported. The recalculation results can be entered into the program according to the order scheme. In that case, the accountant makes a change in commodity balances with a warehouse order, and another employee of the enterprise can perform the summary of the inventory results later.

When summing up the results of the inventory, it is possible to perform a sorting offset in a semi-automatic mode. According to the preliminary settings, the program will help you choose the most suitable commodity items for offsetting.

It also supports registration of unrecorded surpluses and write-off of goods with an indication of the reason, for example, shortage, fight, overdue. The user can create his own list of reasons for writing off goods.

Entering the results of recalculation of goods can be done manually or using data collection terminals.

It supports the formation of regulatory forms established for registration of inventory results, and simplified forms of management accounting documents.

By the way, in the old versions of 1C 8.2, the inventory takes place according to the same principles, only the appearance of the interface differs.

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

1. Creating and filling out an inventory document. It serves to fill in the actual data on the presence or absence of the item in the warehouse. The document does not make any postings.
2. If a shortage of goods is found, it must be written off using the document "Write-off of goods" (less often "").
3. If there is an overabundance, it is accounted for with the help of "".

Let's take a closer look at these documents.

In the interface of 1C Accounting 8.3, the journal of inventory documents can be found in the "Warehouse" section:

To create a new inventory in the log that opens, click the "Create" button. Fill in the header of the document with the details "Organization", "Warehouse":

The next step is to fill in the accounting quantity of goods in the warehouse. To do this, click above the tabular part "Fill" - "Fill according to the balance in the warehouse":

Please note: The accounting quantity is filled on the date of the document, not the current moment!

A list of all available goods will appear in the table (according to the credentials in the 1C program):

We see two columns:

Get 267 1C video lessons for free:

• Quantity fact - this data must be filled in according to the actual balances in the warehouse. By default, 1C fills in these quantities from the credentials.
• Quantity accounting - how many goods are in stock according to the program.

Now the most interesting thing is that we count how many goods are actually in stock and enter them in the “Quantity fact” column:

Once all the data is entered, write down the document. Now you can print the necessary primary documentation by clicking on the "Print" button:

• Inventory list of goods - INV-3
• Inventory Order - INV-22
• Comparison sheet INV-19

If you have noticed, the inventory itself does not make any entries in accounting. Now you need to write off or capitalize the goods that need it.

Our video on filling inventory in 1C 8.3:

Write-off of goods in 1C from the warehouse

In order to write off an item based on inventory, you must create a new write-off document.

Click in the "Inventory" button "Create on the basis" - "Write-off of goods":

The 1C Accounting 8.3 program will automatically generate a write-off for positions that had a shortage:

If everything is correct, just click the "Submit" button. Let's check the postings for the write-off of goods:

Posting goods for inventory

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.

Organizations periodically conduct inventories. They are needed in order to get the actual balances of a particular product. Inventory also allows you to verify the actual data with the accounting data in the program.

There are cases when such a reconciliation of balances reveals theft among financially responsible persons.

After an inventory in 1C 8.3, the shortage can be written off, and the surplus. For this whole sequence of actions and its reflection in accounting, there are special documents, the filling of which we will consider further.

Let's start with the inventory itself. To do this, use the document of the same name in the "Warehouse" section of the program.

The document is quite easy to complete. First of all, we will specify all the necessary details of the header.

Suppose that on March 31, 2016, an inventory was carried out at the trading warehouse of store No. 23. The responsible person can be omitted, as we did, but fill it out if necessary.

For the convenience of filling in the list of goods, you can use the "Fill according to stock balances" item from the "Fill in" menu, as shown in the image below. In any case, you can also fill in the tabular part manually if, for example, during the inventory, a product is found in the warehouse, which is not on the balance at all.

We did not complicate the example and used only automatic completion. The program "found" only 127 units of Chocolate 95% in stock. Suppose that this number does not match reality, and we missed seven tiles.

In the “Fact” column, we will enter that in fact there are only 120 units of 95% chocolate in the warehouse. Now some recalculation was automatically performed in the tabular part.

In the column "Deviation" the amount "-7" was displayed, which is highlighted in red. This color indicates a shortage of goods. Also, depending on the quantity that is taken into account in the program and the actual quantity, the corresponding amounts of goods were calculated, taking into account the price.

When posting, this document does not create any accounting movements. From it you can print all the necessary reports, for example, according to the INV-3, 22, 19 forms. Reflection in the accounting of the fact of deviation can be done using and posting goods, depending on whether it is a shortage or a surplus. These documents are created both independently and on the basis of the inventory.

Video on filling out the inventory card:

Write-off of goods

Let's continue with the previous example. In the course of the inventory, it was found that in the trading floor of store No. 23 there was a shortage of 7 chocolate bars 95%. This quantity must be written off from the warehouse, because it simply does not exist.

For this we will use . We created it based on the previously entered inventory.

note that the document is completely filled out automatically. Despite the fact that the program gives us the opportunity to edit it, we will not do this.

After the document was passed, two movements were created: to write off seven 95% chocolate bars and to write off the trade margin. The second posting was created due to the fact that the warehouse with the detected shortage is a trading floor and the prices are accordingly different.

Goods posting

Now let's look at the second example. During the inventory, it was found that instead of the 110 kilograms of “Assorted (commission)” sweets reflected in the program, there are actually 150 of them in the warehouse. In this case, the deviation in the inventory will be 40 kilograms.

Since the deviation occurred in a positive direction, in order to take it into account, it is necessary to capitalize the surplus. Posting as well as write-offs can be created from the goods inventory document itself.

The program filled in all the necessary fields automatically, and we only had to post the document. After it is held, the number of "Assorted (commission)" sweets in the program will match the actual quantity in stock.

Video on posting and writing off goods in 1C 8.3 based on inventory:

Each organization that has inventories in its warehouses regularly conducts an inventory. In this case, deviations in the quantity of one or another nomenclature, both up and down, may be revealed. The inventory document will allow you to bring the actual values ​​in line with those indicated in the infobase, on the basis of which the data on the number of goods are subsequently adjusted.

The inventory logic is the same for all versions of 1C:

surplus goods must be capitalized;

missing goods must be written off.

The first step in reflecting the results of the inventory in 1C is the creation and filling out of the document of the same name, in which information about the existing deviations in the warehouse is entered. Next, the goods are written off or credited on the basis of the deviations found.

Filling out an inventory document in 1C: Accounting

For this operation, the program interface provides a separate item in the "Warehouse" section:

When you go to the section, a list of previous inventories opens, but we need to create a new document. This is done as standard by clicking the "Create" button:

Pay attention to filling in the fields in the header of the document:

a date needs to be set. The rest will be filled on that date;

You can generate a document by warehouse or by responsible person. If you choose the first method, the balances for the specified warehouse will be filled. In the second option, the balances will be formed for all warehouses that are assigned to this responsible person.

Let's take stock of the warehouse. The document needs to be filled out, this is done automatically when choosing a filling method from the drop-down menu of the "Fill" button:

A table will be formed with all the goods that are listed in the specified warehouse in 1C:

The table shows the nomenclature, its actual and accounting quantity. The document can be recorded and printed to be transferred to the warehouse for direct inventory. There is a printable for this:

The form is filled out by warehouse employees, after which the actual data is entered in the corresponding column of the table:

The program itself calculates the deviation: shortages are indicated in red with a “-” sign, surpluses are indicated in black. After filling the column, the document is recorded and posted. Based on it, you can print the necessary paper forms:

Inventory in 1C: Accounting itself does not produce write-offs or postings; separate documents are provided for these operations.

Write-off of goods based on inventory in 1C: Accounting

There are two ways to write off goods based on the results of the inventory: create a new document in the Warehouse-Inventory section, or use the "Create based on" function. The second way is easier and faster.