as shown:
Warehouse inventory can be created using the form of excel tables, if the class can be unified to use a table, if the class can use more than two tables. About the template is as follows:
The use of excel to make the form more convenient, pay attention to the first column as a serial number, do not use the default excel form, or print is not printed.
Warehouse inventory refers to inventory and other inventory, commonly used methods of inventory method and spot inventory method, often using the inventory machine as a tool. Its role is the integration of the warehouse, generalization and inventory of inventory. Inventory inventory form is generally the inventory of existing goods in the warehouse to organize and statistics.
There are mainly so many items: the number of books, inventory, profit and loss +-, the back of the inventory indicated by the inventory, the date of inventory, the person responsible for the inventory was signed. The front labeled inventory warehouse.
Extended information
In order to strengthen the inventory asset management, to ensure that the account is consistent with the real, to protect the safety of inventory assets, integrity, accuracy, timely and truthfully reflect the balance of inventory assets and the utilization of the situation, so that the inventory of inventory assets is more standardized, systematized for the next stage of sales,
production plans
and financial costing to provide the basis for
This is why inventory counting is necessary.
Inventory inventory form format is what kind of for
Accounting Academy
Organization, such a form are very clear, according to fill in on the line, naturally you will find that the form of use, if you want to further understand, or even set up one of their own, the function of almost on the line.
How to make the inventory table? Urgent ~~~~1, the use of excel table software, drawing a basic framework of the inventory table.
2, each batch of goods into the inventory table before, will generate a batch number of goods into storage.
3, the goods of the batch number column editing is complete, set the inventory information column.
4, after the completion of the inbound information column, set the goods out of the information column.
5, out of storage information column set up after the completion of the equipment inventory column.
6, inventory column set up after the completion of the equipment notes column. Remarks are generally responsible for explaining the current inventory or the difference between inbound and outbound.
7, next, in the inventory column set up in the inventory of goods, inventory time, the number of inventory.
8, after the information set up under the inbound column, set up under the outbound column of the outbound commodity, out of time, out of the number.
9, next, we set up the completion of the inventory table, in and out of the inventory records. First fill in the inventory of the batch number, the batch number can be set according to the time and date.
10, if the length of the batch number is too long, you can set the batch number to text mode.
11, the entry is completed after the entry and exit information, in the inventory column using the formula to calculate the number of inventory.
12, the formula is set up after the completion of an inventory table is completed.
How to use WPS form to create an incoming and outgoing inventory form?1. First of all, to set up a form template for their needs, the left side of the picture above is to enter the name of the object statistics, the right side of the corresponding object name
Ledger
. (Note: the form of object name statistics fill color and object name ledger fill color corresponds to facilitate the filling of the content) can choose their favorite color fill.
2. With the form template, we will step by step to improve the above chart from H to BS column ***33 columns, the intention is to assume that H as the first day of the month, I as the second day, J as the third day ... ... And so on until the end of BQ as the last day of the month, and BR for the "inventory surplus" BS for the "deficit", columns of such a long form is very inconvenient to operate, then you have to use the WPS form of the "Window Freeze! "function to achieve convenient operation.
3. Through the "Window Freeze" function, we can see the object statistics area and the corresponding ledger is very clear, including
Table header
Name is also very beautiful, you can use the form of the "scroll key! "It is very convenient to operate.
4. In the good templates have to be used to know the good and bad, then feel free to add some content and data to test, respectively, in the object statistics area and the corresponding ledger data area to add effective content and values,
5. With the object content and effective data, the next step is to do is how to use the "function of the formula "to realize the automatic generation of statistics a lot of values. First of all, we set up in E3, the number of objects in the warehouse statistics! Detailed diagram:
1) input formula: = SUMPRODUCT ((MOD (H3: BS3), 2) = 0) * H3: BS3)
2) function SUMPRODUCT () meaning:. In the given sets of arrays, multiply the corresponding elements between the arrays, and return the sum of the product. _zone_SUMPRODUCT(array1,array2,array3,...) _rray1,array2,array3,... __2__30_metals, whose corresponding elements need to be multiplied and summed.
Description_Array parameters must have the same dimension, otherwise, the function _UMPRODUCT_Prayer_Goble_Halt_Fruit_#VALUE!
_Function_UMPRODUCT_Sheath enemy steal neon woodcutting Kari-Spirits_0__ dislike
3. Function MOD () meaning: to return to the
remainder of the division of the two numbers
. The
plus or minus sign of the result
is the same as the divisor.
Syntax_OD(number,divisor)_umber_
Divisor
. _ivisor_
Description_If_ivisor_,function_OD_prayer_goblet_#Div/0!
_Function_OD_梢越栌煤_INT_幢硎:_OD(n,d)=n-d*INT(n/d)。
6. The same is also in the F3 out of the object set formula: = SUMPRODUCT ((MOD (H3: BS3), 2) = 1) * H3: BS3) with the same intention.
7. Want to calculate the "current balance of the number of" in the G3 to enter a simple "plus, minus" on the good, such as the above chart "D3 + E3-F3", the previous period The number of balances + this period into the number of - this period out of the number of results is "the number of balances".
8. The operation of all the formula set up after the selection of "E3, F3, G3" click on the "+" sign down to fill in the formula, pull the location of your own needs.
9. Pull down the fill formula to get a complete "automatic generation of monthly inventory statistics table".