How to do the inventory in and out of the warehouse?

1. The number of product inventory is obtained by summarizing the quantity of warehousing and the quantity of warehousing, so the inventory table should contain "warehousing" and "warehousing" information, and in order to facilitate inquiry, "date" information is also indispensable.

2. Then enter the relevant records, the number of inventory is obtained by the number of inventory on the day (times) plus the number of warehousing on the day minus the number of warehousing, this data does not need to be calculated manually, you can use the formula to get the result directly from the software, and enter the formula in d3: =sum(d2,b3)-c3.

c3), at this time, it should be noted that the absolute reference $ should be added to the starting line of the summing area, which means that the data from the first line to the current row is always summed.

4. If there is a loss in addition to the normal number of outbound goods, you can also add a column of loss, and when summing, the loss can also be counted: =sum(e2,b3)-sum(c3:d3).

5. If it is several products, you can side by side several columns, respectively, to find their respective inventory, because the formula is used relative reference, and the relative position of the reference area is exactly the same, so you can directly copy the formula from the front to paste, it will be automatically changed to the target cell formula: =sum(g3,e4)-f4.

6. In order to facilitate distinction, the border line can be changed between different products, such as separating with double lines.

7. However, if there are more products, it is not very convenient to arrange them horizontally, you can arrange the products vertically, change the date to horizontally, and enter the warehousing data according to the corresponding products.

8. Then use the formula to calculate the total warehousing quantity: =sumif(E$3:CG$3,"Warehousing", e4:cg4), the 3rd line in this formula is given an absolute reference, so that the column header area of row 3 will always be referenced when padding down.

9. The formula of the total quantity of the outbound quantity is similar to the total quantity of the warehouse, except that the "storage" in the formula is changed to the outbound quantity: =sumif(e$3:cg$3,"Outbound shipments",e4:cg4)。

10. After the total amount of warehousing and the total amount of warehousing, the number of inventories can be obtained by subtracting the two numbers, and if there is a reported loss, you can also add another column, and the formula is similar. The stock formula is: =c4-d4.

11. In order to increase the number of dates, the number of previous summaries is always visible, you can freeze the pane, select column e, click View--Freeze Pane, freeze the split pane, you can freeze the front summary part, and when you drag the scroll bar to the right, only the previous date will be hidden. You can also place "inbound" and "outbound" separately and then hyperlink to the specified location.

Tools to prepare: excel software, computer.

1. Open Excel**, and enter the date, product name, inbound, outbound and other numbers in turn.

2. Enter the balance in column E, and enter =C2-D2 in E2 to get the inventory.

3. Place the mouse under the E2 cell and pull the announcement to the desired position, and you can see that the balance of other items is 0.

4. At this time, enter the corresponding numbers in and out of the warehouse of other items, and the balance can be automatically calculated.

5. After selecting the balance column, click Conditional Formatting in **.

6. Select the Less Than button among the options that appear.

7. If you set a specific warning number, less than 20, select Fill in light red, and click OK.

8. After entering other items such as washbasins, warehousing numbers and warehousing numbers, the warning color will be displayed according to the judgment conditions.

Warehouse inventory report, how to copy and paste the remaining inventory of the previous month into the inventory at the beginning of the next month.

The detailed account of inventory commodities refers to the account books that are set up according to the name, specification and grade of the goods, and the income, issuance and balance of the goods are registered. Generally, the three-column account page of quantity and amount is used to reflect and control the quantity and amount of each commodity.

Since the cost of goods sold of an enterprise is mainly calculated through the detailed account of inventory commodities, it is required that the detailed account of inventory commodities can correctly reflect the purchase, sales and balance of commodities.

Three accounts are separated:

That is, the business department, the accounting department and the warehouse department each set up a set of inventory commodity sub-accounts. The business department sets up a commodity allocation account, registers the quantity of goods, and grasps the "adjustable inventory" of inventory commodities, so as to handle the billing of commodity purchase, sales and allocation.

The accounting department sets up a detailed account of commodities, registers the amount and quantity of the purchase price, and calculates the "accounting inventory", so as to grasp and assess the use and turnover of commodity funds, calculate the cost of commodity sales, and control the commodity accounts of the business and warehouse departments.

The warehouse department sets up a commodity custody account, registers the quantity of goods, and grasps the "custody inventory" of goods, so as to keep the goods, handle the delivery, and arrange the goods.

In addition, at the place where the goods are stacked, a commodity stacking card is set up to keep track of the stock of each pile of commodities. The system of "three accounts separately" is relatively complete, but the registration of commodity ledgers is duplicated, and it is difficult to check the accounts because the vouchers of the increase and decrease of commodities are circulated in the enterprise for different times and different calibers.

The above content refers to Encyclopedia - Inventory Commodity Ledger.

1: Create an Excel outbound schedule. 2：

Create a new outbound order print template based on the outbound order format. 3: Select cell G2, menu bar - Data celebration - validity.

4: Validity - Sequence - Origin Selection Outbound Order Details! $a:

Select the lead trembling and select the C2 cell, enter =if(g2=,,vlookup(g2, outbound list details!) $a$1:

k$149,2,false))。6: Function parsing:

if function - to determine whether g2 is empty, not empty is the value of the number vlookup function, vlookup function - according to the outbound order number to match the value of the outbound details of the Huai difference. 7: Enter the same function in the cell, select the corresponding sequence number to get it automatically.

Tools to prepare: excel software, computer.

1. First of all, create a new worksheet and enter the inventory account content for **.

2. Merge and center the cell where the header inventory is in and out**. The font was changed to Song, 20, and bold.

3. Put "the balance of the previous month, the storage of this month, and the delivery of this month." The cells are merged and centered.

4. Set the text in the center.

5. Then add a border to the whole **.

6. Add the formula "amount = quantity * unit price" to the amount. **Done, save it.

The production method of warehouse inbound and outbound ** is as follows:

Preparation materials: excel2007

1. Make inventory in and out** generally use Excel, because it has a powerful data calculation function. Initially, we need to make a header in and out of **. The header generally includes the following items:

Pin's judgment number, specification rapid nuclear rotten, model, unit, quantity, warehouse name, initial number of leakage per mu in the period, storage volume in the current period, and sales in the current period. Wait. Description:

The specific requirements of each enterprise are different and can be defined by yourself.

2. Establish the basic data of the first class, the basic data is the product number, specification, model, unit, etc. of the inventory materials, which are increased one by one.

3. Enter the "Inventory at the beginning of this period", that is, the inventory quantity on the last day at the end of the previous month. Note: This data can be imported directly from the previous month's report, usually on the first day of the month.

4. In the usual work, enter all kinds of inbound and outbound information. Note: The amount of warehousing in this period:

The quantity of production in the workshop in the current month, or the quantity of purchased in storage; Refund in the current period: the number of sales returns in this month; The amount of returned materials in this period: the number of returned materials after the workshop picks; Shipments in this period:

In addition to the workshop, the number of loans from other departments, etc.

Current Sales Volume: Quantity of Sales Sent to Customer, Current Period Picking: Quantity Picked on the Shop Floor, Closing Inventory: Inventory Quantity on the Last Day, Description: Except for the first and last one, the rest of the quantities are customizable.

5. Use the formula to calculate the "ending inventory": enter the formula "=sum(f2:i2)-sum(j2:l2)" in the m2 cell, that is: the beginning of the inventory of the current period + all incoming quantities - all outbound quantities = ending inventory.

6. Fill the following cells with autofill, that is, the ending inventory of other inventory materials.

7. When the end of one month, the "ending inventory" of the previous month becomes the "opening inventory" of the next month.