How to print an inventory in 1s. Accounting info
Menu: Documents - Stocks (warehouse) - Inventory of goods
Create a new inventory document. First of all, the document indicates the warehouse on which the inventory is carried out, and the organization to which the goods belong:
Inventory of goods can be carried out immediately on all nomenclature items. If the quantity of goods is very large and it is problematic to inventory them at a time, you can create several inventory documents. In this case, each document can be made for a specific group of goods.
Only goods from the Household Appliances group will participate in our inventory. To do this, we will set the comparison type “In group” for the “Nomenclature” field, and in the next field we will select the group we need.
Next, you need to list the necessary items in the table “Products” and indicate their actual quantity in stock. In order not to fill in the table manually, we will use auto-completion by clicking on the button: “Fill - Fill by the balances in the warehouse”.
The program will fill in the table with goods that are present in the warehouse according to its data:
In the column “Accounting. quantity ”indicates the balance of the goods in the warehouse according to the program, and in the column“ Quantity ”you must fill in the actual balance of the goods in the warehouse. In the “Deviation” column, the program will calculate the deviations of the actual balance from the accounting.
A positive deviation indicates a surplus of goods, and a negative deviation indicates a deficiency.
A fully filled-in document must be saved in the database using the “Save” button. The document has several printed forms, including an inventory inventory (INV-3). You can print the document by clicking the "Print" button and selecting the required form:
The document “Inventory of goods” records information on the actual balances of goods in the database, while 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 the document of the same name.Menu: Documents - Stocks (warehouse) - Write-off of goods
It is more convenient to issue a document on the basis of an inventory of goods, then the program will immediately fill it with the missing goods:
It is necessary to post a document using the “OK” button, all missing goods will be deducted from the warehouse at the time of the transaction.
Posting goods based on inventory data
The posting of goods is also carried out on the basis of an inventory by the document “Posting of goods”. The program transfers to the document all the goods for which surpluses were found:The price of the goods (cost of capitalization) was also filled 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 carried out by clicking on the "OK" button, at the time of the surplus the goods are credited to the warehouse.
Clearance of goods
If you keep records in the database on additional characteristics of goods (colors, sizes, etc.) and you find a graft, then you can draw it up without taking an inventory. To do this, use the document "Adjustment of the series and characteristics of the goods."Menu: Documents - Stocks (warehouse) - Adjustment of series and characteristics of goods
Suppose we found in stock a shortage of one T-shirt of size M in white, while there is one extra T-shirt in black of the same size.
Let's create a new adjustment document, fill in the warehouse and organization in it:
Add a new row to the table, indicate in it the nomenclature - T-shirt, quantity - 1 pc. In the field “Description of the item (old)” we select the characteristic “M, White”, and in the field “New description of the item” indicate “M, Black”.
At the time of holding the document by the “OK” button, the program will write off one white T-shirt from the warehouse and capitalize the black one.
In today's article, we will talk about the algorithm for conducting an inventory in the software product “1C 8.3 Accounting 3.0” and how to write off or capitalize products based on its results. 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 filling out an inventory document that exists to fill out factual information about the absence or availability of items in the warehouse. The document does not create any postings.
2. If a shortage of products is discovered, 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 comes with the participation of “Posting of goods”.
Consider these documents in more detail.
Inventory of products in a warehouse
In the interface of the aforementioned software product, the inventory document journal can be found in the section called “Composition”:
In order to create a new inventory, in the journal that opens, click on the "Create" button. Fill the document header with the details with the name "Organization", "Warehouse":
The next step is to fill in the accounting quantity of products in the warehouse. To perform this operation, you need to click on the tabular section under the name “Fill” - “Fill by the balances in the warehouse”:
We emphasize that the accounting amount is filled not at the current moment, but on the date of the document!
A list of all available products will appear in the table (according to the accounting information in the 1C software product):
We see 2 columns:
Quantity fact - this information needs to be filled with real balances in the warehouse. By default, a software product fills this amount with accounting information;
Quantity accounting - how many products are available according to the software product.
Once all the necessary information has been entered, write down the document. Now, by clicking on the “Print” button, you can print the necessary primary documents:
The comparative statement is “”.
We draw your attention to the fact that the inventory of transactions in accounting itself does not produce. Now you need to capitalize or write off products that need it.
"1C": write-off of products from the warehouse
In order to write off goods on the basis of inventory, you need to create a new write-off document.
In the "inventory", press the button called "Create based on" - "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 "Post." Now, let's write off the postings:
Posting inventory products
Posting of products is carried out similarly to write-offs. In the inventory, click the button “Create on the basis of” - “Posting of goods”:
The system will generate the necessary document, where it will be necessary to fill in the requisite under the name “Article” in order to reflect it on the account “91.01”:
So using the "Post" button, we fix the data. Then, according to the capitalized products, we check the correctness of the generated transactions in “1C”.
Each organization, in the warehouses of which there are inventory items, regularly conducts an inventory. In this case, deviations in the number of one or another nomenclature can be revealed, both up and down. To bring the actual values \u200b\u200bin line with those indicated in the information base will allow the inventory document in, on the basis of which data on the quantity of goods are subsequently adjusted.
The logic of the inventory is the same for all versions of 1C:
surplus goods must be capitalized;
missing items must be discarded.
The first step in reflecting the results of the inventory in 1C is to create and fill out the document of the same name, which contains information about the deviations in stock. Further, goods are debited or capitalized on the basis of the deviations found.
Filling out an inventory document in 1C: Accounting
For this operation, the program interface has a separate item in the "Warehouse" section:
When you go to the section, a list of previous inventories is opened, but we need to create a new document. This is done as standard by pressing the "Create" button:
Pay attention to filling in the fields in the document header:
it is necessary to set the date. The balances will be filled on that date;
you can create a document by the warehouse or by the person in charge. When choosing the first method, the balances in the specified warehouse will be filled. In the second option, balances will be formed in all warehouses that are assigned to this responsible person.
Let's analyze the inventory for the warehouse. The document needs to be filled out, this is done automatically when you select the 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 written and printed to be transferred to the warehouse for direct inventory. For this, a printing form is provided:
The form is filled in by the warehouse staff, after which the actual data is entered in the corresponding column of the table:
The program itself calculates the deviation: red with a “-” sign indicates shortages, black - surpluses. After filling in 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 write off or capitalization, for these operations separate documents are provided.
Write-off of goods on the basis of an inventory in 1C: Accounting
There are two ways to write off the goods according to the results of the inventory: create a new document in the Warehouse-Inventory section, or use the "Create Based On" function. The second method is simpler and faster.
Organizations periodically take inventory. They are needed in order to get the actual remnants of a particular product. Also, an inventory allows you to verify the actual data with the accounting data in the program.
There are cases when such a reconciliation of the residuals reveals theft among financially responsible persons.
After taking the inventory in 1C 8.3, the shortage can be written off, but the excess. For all this sequence of actions and its reflection in the account, there are special documents, the filling of which we will consider later.
Let's start with the inventory itself. To do this, use the document of the same name in the section of the Warehouse program.
The document is quite simple to fill out. First of all, we indicate all the necessary details of the header.
Suppose that an inventory was taken at the warehouse of store No. 23 on March 31, 2016. The responsible person can not indicate, as we did, but fill it out if necessary.
For the convenience of filling out the list of goods, you can use the item “Fill by stock balances” from the “Fill” menu, as shown in the image below. In any case, you can fill in the tabular part manually, if, for example, during inventory, a product was found in the warehouse that does not exist at all on the balance.
We did not complicate the example and used only automatic filling. The program “found” in the warehouse only 127 units of Chocolate 95%. Suppose that this number does not coincide with reality, and we did not count seven tiles.
In the “Fact” column, we will add that in fact only 120 units of chocolate 95% are in stock. Now, in the tabular section, some recalculation was automatically performed.
In the column “Deviation” the number “-7” is displayed, which is highlighted in red. This color means a shortage of goods. Also, depending on the quantity that is included in the program and the actual quantity, the corresponding amounts of the goods are calculated taking into account the price.
When conducting this document does not create any accounting movements. All necessary reports can be printed out of it, for example, according to INV-3, 22, 19. Forms. Reflection in accounting for the fact of a deviation can be made with the help of capitalization of goods, depending on whether it is shortage or surplus. These documents are created both independently and on the basis of an inventory.
Video on filling out an inventory card:
Write-off of goods
We continue the consideration of the previous example. During the inventory, it was found that in the trading floor of store No. 23 there was a shortage of 7 chocolate bars of 95%. This quantity must be written off from the warehouse, because it simply does not exist.
We will use this. We created it based on a previously introduced inventory.
notethat the document is completely filled in automatically. Despite the fact that the program gives us the opportunity to edit it, we will not do this.
After the document was held, two movements were created: to write off seven bars of chocolate 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 trading floor and prices, respectively, are already different.
Posting goods
Now consider the second example. During the inventory, it was found that instead of 110 kilograms of “Assorted (commissioned)” sweets reflected in the program, there are 150 in fact in the warehouse. In this case, the deviation in the inventory will be 40 kilograms.
Since the deviation occurred in a positive direction, to account for it, it is necessary to capitalize the excess. Posting as well as cancellation can be created from the inventory document itself.
The program filled in all the necessary fields automatically, and we only had to post a document. After it is held, the number of “Assorted (commission)” sweets in the program will coincide with the actual quantity in the warehouse.
Video on posting and write-off of goods in 1C 8.3 based on inventory:
How is the inventory in the program 1C 8.3 Accounting 3.0 and how, based on its results, write off or capitalize the goods.
The instruction is suitable for 1C Retail, 1C Trade Management, 1C ERP programs. By the way, and in older 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:
- Create and fill out an inventory document. It serves to fill in the actual data on the presence or absence of stock items. The document does not make any entries.
- If a shortage of goods is discovered, it must be written off using the “Write-off of goods” document (less commonly, “Retail Sales Report”).
- If there is an oversupply, it is accounted for using the “Posting of goods”.
Consider these documents in detail.
Inventory of goods in stock
In the interface 1C Accounting 8.3 the journal of inventory documents can be found in the "Warehouse" section:
To create a new inventory, in the opened log you need to click the "Create" button. Fill the heading 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 on the tabular part "Fill" - "Fill on the balances in the warehouse":
Please note: The accounting amount is filled on the date of the document, and not at the current moment!
A list of all available goods will appear in the table (according to the credentials in 1C program):
We see two columns:
- Quantity fact - these data must be filled in on the actual stock in the warehouse. By default, 1C fills these quantities from the credentials
- Quantity accounting - how much product is available according to the program
Now the most interesting thing is that we consider how much goods are actually in stock and add them to the column “Number of Facts”:
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 inventory of goods - INV-3
- Inventory Order - INV-22
- Collation sheet INV-19
If you noticed, the inventory itself does not make any entries in accounting. Now you need to write off or capitalize the goods that need it.
Write-off of goods in 1C from a warehouse
In order to write off the goods on the basis of the inventory, you need to create a new write-off document.
In the “Inventory” we press the button “Create based on” - “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 “Post” button. Check the write-off postings:
Posting inventory items
Let's consider how to capitalize goods in 1s 8.3 (8.2). This procedure is completely identical to cancellation. In the inventory, click “Create based on” - “Posting of goods”:
The system will create the document we need, where it is enough to fill in the requisite “Article of income” to reflect it on account 91.01:
We also fix the data with the “Post” button. We check the postings in 1C for capitalized goods:
Based on materials: programmist1s.ru