Inventory in the 1C: Retail configuration. Inventory in the “1C: Retail” configuration. Capitalization of inventory items

To carry out an inventory, there is a special document - “Inventory of goods in the warehouse”. Using this document, you can reflect in the program the fact of an inventory, indicate the current balances of goods and see the discrepancies between actual and accounting balances. This document is widely used in the practice of specialists involved in trade automation when transferring data between different 1C databases.

Menu: Documents - Inventories (warehouse) - Inventory of goods

Let's create a new inventory document. First of all, the document indicates the warehouse where the inventory is carried out and the organization that owns the goods:

Inventory of goods can be carried out immediately for all product items. If the number of goods is very large and it is difficult to take inventory of them at one time, you can create several inventory documents. In this case, each document can be made for a specific group of goods.

Our inventory will only include products from the “Household Appliances” group. To do this, set the comparison type to “In group” for the “Nomenclature” field, and select the group we need in the adjacent field.

Next, you need to list the required product items in the “Products” table and indicate their actual quantity in the warehouse. In order not to fill out the table manually, we will use autofill using the button: “Fill - Fill according to stock balances.”

The program will fill the table with goods that are in stock according to its data:

In the “Accounting” column. quantity" indicates the balance of goods in the warehouse according to the program data, and in the column "Quantity" you must fill in the actual balance of goods in the warehouse. In the “Deviation” column, the program will calculate the deviations of the actual balance from the accounting balance.

A positive deviation indicates a surplus of goods, and a negative deviation indicates a shortage.

A fully completed document must be saved in the database using the “Save” button. The document has several printed forms, including an inventory list (INV-3). You can print the document by clicking the “Print” button and selecting the required form:

The document “Inventory of Goods” records in the database information about the actual balances of goods, but it does not adjust the balances of goods. In order for the accounting and actual balances of goods to coincide, it is necessary, based on the inventory, to write off the missing goods and capitalize the surplus.  

Write-off of goods based on inventory data

Write-off of goods is done using a document of the same name.

Menu: Documents - Inventories (warehouse) - Write-off of goods

It is more convenient to draw up a document based on the inventory of goods, then the program will immediately fill it with the missing goods:

It is necessary to post the document using the “OK” button; all missing goods will be written off from the warehouse at the time of posting.  

Capitalization of goods based on inventory data

The posting of goods is also carried out on the basis of the inventory using the document “Posting of Goods”. The program transfers to the document all goods for which surpluses were detected:

The price of the product (cost of capitalization) was also filled in automatically - the program substituted the average cost of this product in the warehouse. If there is no data on the cost of goods in the database, then the “Price” column will need to be filled in manually.

The completed document must be submitted by clicking the “OK” button; at the time of posting, excess goods are credited to the warehouse.  

Registration of re-grading of goods

If you keep records in the database of additional characteristics of goods (colors, sizes, etc.) and find mis-grading, then you can register it without conducting an inventory. To do this, use the document “Adjustment of series and characteristics of goods”.

Menu: Documents - Inventories (warehouse) - Adjustments of series and characteristics of goods

Suppose we find a shortage of one white T-shirt in size M, while there is one extra black T-shirt of the same size.

Let's create a new adjustment document, fill in the warehouse and organization in it:

Let's add a new row to the table, indicate the item in it - T-shirt, quantity - 1 piece. In the “Item Characteristics (old)” field, select the “M, White” characteristic, and in the “New Product Characteristics” field, select “M, Black”.

At the time of posting the document, clicking the “OK” button, the program will write off one white T-shirt from the warehouse and credit the black one.

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

General features of inventory in 1C

The widespread use of 1C in accounting makes it possible to automate the inventory process for any volume of accountable materials and regardless of the remoteness of warehouse premises 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 out already filled out.
• A simple calculation method is built into the program.
• Errors and the influence of the human factor are minimized.
• The time required for the procedure has been reduced.

Inventory in 1C has its own characteristics, which look like this:

• It is necessary to install the current version of the program.
• A barcode reading terminal is required.
• All primary documents on the movement of the MC must be entered into 1C correctly.
• Turnover balance records are generated according to the relevant accounting accounts. The inventory results are checked against them. The total should match.
• Inventory is carried out separately for the person (or financially 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:

Carrying out inventory and property management

The procedure for conducting inventory 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 balances of inventory materials. This will reveal a discrepancy between the value of real and accounted balances. More details below.

8.3 and 8.2

The principles for conducting inventory in 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 when taking inventory and goods in a warehouse is as follows:

• Select the “Warehouse” section 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 “Carrying out inventory”.
• Fill out the new tab that appears indicating the inventory period, order number and reason for the inventory.
• Go to the “Inventory Commission” section and fill it out.
• Generate order INV-22 and carry it out.
• Inventory results in 1C are documented. To do this, you need to create new tabs “ ” and “Receipt of goods”, fill them out accordingly and post them.

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

• In the main menu, you need to select “Production” and then in the “Product Output” section – “Inventory of NZZHP”.
• In the work-in-process inventory window that opens, enter the necessary data and post it.
• Then select “Operations” and “Month Closing” from the menu.
• Perform this operation.
• Create a cost estimate. The WIP will be displayed as a separate line.

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

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

1c accounting

Cash inventory in 1C accounting is carried out by comparing the balances of money in 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”, “Turning reports”.
• Specify the account number and report construction.
• Create a selection based on the output data.
• Check your balances by day of the selected period.

The results are reflected in the 1C inventory report. Its form can be filled out in 1C only manually.

And to inventory calculations, you need to perform the following operations:

• Go to the main menu in “Sale” and then – “Inventory of settlements”.
• Then select the counterparty you are interested in.
• In the window that appears, complete information about and will be displayed.

1C Retail

In the 1C retail configuration, it is convenient to make an inventory of balances, as well as their capitalization and write-off:

• To do this, you need to go sequentially: “Marketing”, “Inventory and Purchasing”, “Business Operations Analysts”.
• 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 stage: creating the “Recalculation of goods” file, filling it out and going to the “Products” tab.
• Fill in the nomenclature and prices.

Learning to carry out an inventory of goods and materials (1C: Accounting 8.3, edition 3.0)

2017-07-05T11:22:39+00:00

Today we will look at how to reflect the completed inventory of inventory items (TMV) in the 1C: Accounting 8.3, edition 3.0 program. Let's figure out how to register identified shortages and surpluses.

Situation. In our organization, by order of the manager, an inventory of inventory items has been assigned.

Based on the results of the inventory in the warehouse, it was revealed shortage of 100 kg of flour, surplus 50 kg sugar and 1 coffee maker.

The shortage of 100 kg of flour, revealed during the inventory, was taken into account in account 94 “Shortages and losses from damage to valuables”:

Then 20 kg of missing flour was written off as natural loss (shrinkage, shaking):

Another 50 kg of missing flour was written off to the financially responsible person (account 73.02 “Calculations for compensation for material damage”):

The remaining 30 kg were written off for other expenses:

The unaccounted for coffee maker was capitalized to account 41:

Dt 41 Kt 91.01 1 piece [unaccounted for coffee maker was capitalized]

Now we will reflect all these operations in 1C: Accounting 8.3, edition 3.0.

Let me remind you that this is a lesson and you can safely repeat my steps in your database (preferably a copy or a training one).

Go to the “Warehouse” section, “Goods Inventory” item:

We create a new document, indicating the main warehouse and the materially responsible person at this warehouse.

Let's move on to the "Products" tabular section. To fill it out, click the button “Fill” -> “Fill according to stock balances”:

The tabular part is filled with all balances in the selected warehouse for accounts 10 and 41:

By default, the "Actual Quantity" column is equal to the "Accounting Quantity" column. Their equality means the absence of deviations, but in our case, actual shortages of flour (100 kg) and excess sugar (50 kg) and coffee makers (1 pc.) were identified.

Let's reflect this fact by adjusting the "Quantity of fact" column:

We go to the “Inventory taking” tab and indicate here the period of conduct, the reason and the document approving the inventory:

Go to the “Inventory Commission” tab:

We indicate its participants by checking the chairman of the commission.

We navigate through the document and see printed forms that can be printed:

Here is part of the matching sheet from the printed form INV-19:

Now our task is to write off the identified shortage in accounting and capitalize the surplus.

The easiest way to do this is by entering documents for posting and writing off goods based on the inventory document:

We receive surplus goods and materials

We create the document “Positioning of goods” based on the completed inventory:

Our warehouse and tabular part of unaccounted for valuables immediately filled up. All we have to do is create and fill out an income item from the “Other income and expenses” directory.

Here's her card:

We carry out the document:

All postings correspond to the calculations at the beginning of the lesson.

We write off the shortage of goods and materials

In the same way (based on the inventory document) we enter the document “Write-off of goods”:

The tabular part was filled in automatically again.

We carry out the document:

The shortage was reflected in invoice 94 in the amount of 1501.59 rubles.

We will write it off according to the terms of the problem, partly to loss, partly to the financially responsible person and partly to other expenses. This is done by manual operation.

Go to the "Operations" section and select "Operations entered manually":

Create a new manual operation:

We draw up its postings according to the task (here we indicate only in total terms, so quantitative accounting is not kept for account 94):

Separately, I would like to note that the shortfall of 450.47 rubles does not relate to natural loss, and also has no culprits, and therefore should not be accepted by us as expenses when calculating income tax.

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

There are cases when such a reconciliation of balances makes it possible to identify thefts among financially responsible persons.

After conducting an inventory in 1C 8.3, the shortage can be written off, and the surplus. For this entire sequence of actions and its reflection in accounting, there are special documents, the completion 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 simple to fill out. First of all, we will indicate all the necessary header details.

Let's assume that an inventory was carried out at the retail warehouse of store No. 23 on March 31, 2016. You don’t have to indicate the responsible person, as we did, but fill it out if necessary.

For the convenience of filling out the list of goods, you can use the “Fill in by warehouse balances” item from the “Fill” menu, as shown in the image below. In any case, you can fill out the tabular part manually if, for example, during an inventory check in a warehouse, a product is found that is not on stock at all.

We did not complicate the example and used only automatic completion. The program “found” only 127 units of 95% Chocolate in the warehouse. Let's assume that this number does not coincide with reality, and we are missing seven tiles.

In the “Fact” column we will add that in fact there are only 120 units of 95% chocolate in the warehouse. Now some recalculation has been automatically carried out in the tabular part.

The “Deviation” column displays the quantity “-7”, which is highlighted in red. This color means there is a shortage of goods. Also, depending on the quantity taken into account in the program and the actual quantity, the corresponding amounts of goods were calculated taking into account the price.

When carried out, this document does not create any accounting movements. From it you can print out all the necessary reports, for example, on forms INV-3, 22, 19. The fact of deviation can be reflected in the accounting records using the receipt of 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 an inventory card:

Write-off of goods

Let's continue with the previous example. During the inventory, it was found that in the sales area 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 completed, two movements were created: to write off seven chocolate bars 95% 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 sales area and the prices are accordingly different.

Posting of goods

Now let's look at the second example. During the inventory, it was found that instead of the 110 kilograms of “Assorted (commission)” candies 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, to take it into account it is necessary to capitalize the surplus. Capitalization, just like write-off, can be created from the goods inventory document itself.

The program filled out all the necessary fields automatically, and all we had to do was post the document. After it is carried out, the number of “Assorted (commission)” candies in the program will coincide with the actual quantity in the warehouse.

Video on capitalization and write-off of goods in 1C 8.3 based on inventory:

In this article I want to talk about how to complete an inventory of fixed assets in the 1C program “Accounting for a public institution 8” edition 1.0. We will also talk about how to more conveniently and quickly write off deficiencies or capitalize surpluses.

But first of all, I would like to remind you that an inventory is a check of the availability of an institution’s property. To reflect this operation, the program has a special document “Inventory of fixed assets (intangible assets, legal acts) on balance sheet accounts.”

Create a new document

In the “MOL/Division” field, you can select from the directory “Centers of Material Responsibility” or from the directory “Employees”. This is very convenient, because there are times when you need to make an inventory for an employee who has many financial responsibility centers.

To fill out the table part, use the “Fill” button. We fill in the accounting data (BU). It is also possible to carry out inventory using a data collection terminal (DCT), but this is a topic for a separate article.

Then we fill in the actual accounting data (FU) according to the accounting data (BU).

And after that we make corrections to the actual data, if there is any deviation, we review the document.

Let's consider the first situation, when there is a shortage of fixed assets.

It is important to understand that the document “Inventory of fixed assets (intangible assets, legal acts) on balance sheet accounts” does not generate transactions. It is created only for the printed form of the inventory list.

After we have indicated the shortage in the actual accounting, we go to the “Results” tab

Click the button “Distribute deviations among accounting accounts”

And after that we enter on the basis of the document “Write-off of inventory item”

This document is filled in automatically with data from the document “Inventory of fixed assets (intangible assets, legal acts) on balance sheet accounts”

We select an account for writing off the residual value and post the document. This document generates transactions for write-off of fixed assets.

Now let's look at the case when you need to capitalize the surplus. In actual accounting we indicate the actual quantity.

Go to the “Results” tab and click the “Distribute deviations among accounting accounts” button, and also indicate the values ​​of the details for capitalizing surpluses.

Based on the current document, we enter the document “Capitalization of fixed assets (intangible assets) to account 101 (102)”

It is also filled in automatically.

Go to the “Fixed Assets” tab and fill in the missing data, carry out

This document generates transactions for capitalization of fixed assets

We return to the document “Inventory of fixed assets (intangible assets, legal acts) on balance sheet accounts”, from which you can print out inventory lists, as well as an inventory order.

I would also like to dwell on such a point as filling out a permanent commission. You can fill out the directory once and then select in those documents where it is necessary.

Go to the “Commission Members” tab and click “Fill in the composition of the commission”

The directory “Permanent commissions” opens. We add a position in it.

We indicate the name of the commission, date and order number. At the bottom of the directory, add the composition of the commission, select an employee and the type of his participation (chairman, member of the commission)

You can create multiple commissions in this directory. Then we simply select the one we need and it is transferred to the document.

If you need more information about working in 1C: BGU 8, then you can get our collection of articles on.

Consultant Maple Company according to 1C programs for government agencies