ASK FOR AN EXCEL WAREHOUSE MANAGEMENT FILE, WAREHOUSING, INVOICING, INVOICING.

As for the problem of barcode scanning, it's not a big deal. It's just that your need is not universal, so you can't find the corresponding tool. However, we can provide customization.

Search: Beijing Futongville Technology ******, the first article of the company's dynamics, there are many versions in it**,**Later, please spend 5 to 10 minutes carefully reading the operation help, which will be helpful to you. Including [Warehouse Enterprise Edition] [Invoicing Enterprise Edition] [Standard Free Edition].

The warehouse company version focuses on warehouse management, such as location management, first-in, first-out, etc.; The Invoicing Company Edition focuses on the cost of purchases and the profit from sales. Both editions come with reporting and query capabilities. If you just want to understand the principle, you can ** free version.

The invoicing and inventory management tool of small warehouse warehouse adopts Excel database engine technology, is designed and developed in accordance with software engineering ideas, and is stable in operation, simple and practical. No additional files are required, and there is no need to do any installation and setup on the system. It has complete warehouse and invoicing management functions, such as inbound and outbound management functions, inventory management functions, and location management functions.

It can realize first-in-first-out according to the production date, can calculate inventory costs, sales profits, statistics, weekly reports, monthly reports, and query the history of entry and exit. It is widely used in the warehouse management of small and medium-sized logistics enterprises, the inventory management of various production enterprises, and the purchase, sale and inventory management of various commercial enterprises.

excel can't meet your needs, you have to use software to work, now there are many free invoicing software on the Internet, I use the "wisdom note", support the scanner, convenient and practical, you said that the function it has it.

You can try raw treasure, these features are available, and it is convenient to use and free. There is also customer service guidance, just search it on it. I'm not an advertisement. Hehe, I've been using it

It can be customized according to the needs of your business personality and functions**. If you are interested in knowing, please hi or q me, click on my username to see my information.

The specific operation steps of using excel** to do simple inbound and outbound inventory management are as follows:

1. First of all, we open excel**, establish the basic data of accessories, the basic data includes product number, model, specifications, etc., enter them one by one, empty table as follows, accessories are placed in the row, and the date is placed in the column.

2. Then we enter the "opening number" of the accessories, and the "opening number" refers to the final inventory on the last day of the last day of the previous month, for example, the beginning of January is the final inventory on December 31.

2. Enter the number of warehousing and warehousing of the day every day, and add a "-" sign in front of the number of warehousing in order to distinguish them.

3. When you have the basic data, you can calculate the actual inventory number, and enter the formula "=B4+SUM(C4:L4)" in M4. Here sum is the summation function, and the expression is: sum(number1,number2,..

4. After pressing enter, the current actual inventory number is obtained.

5. Use the method of automatic filling, fill downward, that is, get the actual inventory number of other accessories.

6. When this month passes, in the next month, put the "actual inventory" on the last day of the previous month in the "beginning number" of the month, and you can do inventory management again. In this way, one report per month, constantly circulating, can be a good inventory management of accessories.

First of all, the first table is the inventory table: the item has - name, warehousing, outbound, and inventory.

The second table is the warehousing table: the project has - date, name, quantity, total.

The third table is the outbound table: the project has - date, name, quantity, total.

After that, enter all of your product names in the Name column in the inventory table;

Then, enter the formula =sumif (name area, name, quantity area) in the total column in the inbound and outbound tables, respectively

Then, enter the formula =vlookup (name, name in the inventory table to the total area, the number of columns where the total column is located) in the inbound column of the inventory table

Finally, enter the formula =vlookup (name, name in the outbound table to the total area, and the number of columns in the total column) in the outbound column of the inventory table

The last step, of course, is to enter the formula = Inbound - Outbound in the inventory table for the inventory amount.

If you don't have a lot of data and don't have a lot of products, you can do this. But you have to pay attention to the virus, and if you get it, it's garbled. The work is all wasted.

If the amount of data is large, it is not recommended to use excel formulas to do it, because the processing speed is very slow.

Divided into three columns, inbound, out of the warehouse, inventory, set =a2-b2 enter in the inventory, and then copy it downward.

Summary. Hello, excel** to make the inventory and warehousing details, you can click on the **, click to select the blue, and then the warehousing, outbound, inventory three items are included in the **, in the fourth item included in the inventory balance. In the future records, the relevant data will be recorded separately, and when calculating, you can click the sigma symbol in the upper part of Excel**, which can be automatically calculated.

As a warehouse keeper, how does excel make, enter, and inventory (inventory: the computer will automatically calculate?) And there is a detailed list of inbound and outbound warehousing?

Hello, excel** to make the inventory and warehousing details, you can click on the **, click to select the blue, and then the warehousing, outbound, inventory three items are included in the **, in the fourth item included in the inventory balance. In the future records, the relevant data will be recorded separately, and when calculating, you can click the sigma symbol in the upper part of Excel**, which can be automatically calculated. FYI.

Enter the management software, daily inventory of inventory in and out of the shipment, how to actually copy a process? I don't understand.

Hello, if you enter the management software, first of all, the software, and then according to the prompts of the software to operate, this is not a problem for excel to operate, a total of reference.

Simple excel inventory management table.

Make a simple inventory management table by yourself, first create an excel table named inventory management table, open it, and establish four workbooks in the table: warehousing table, outbound table, commodity table, inventory table, and design the inventory table at this time.

The sum should be all right, so I won't talk about it. Write down all the products, and insert a line when it's time to add them.

In the design product table, enter the name of the product in the first column, column A.

Then select column A, that is, click on A with the mouse and enter it in the name box above column A"commodity"If there are new products in the future, you can add them in turn, but the products in the inventory table should be the same as the names in the product list.

Then do the warehousing table.

Now to make a drop-down menu of the product name, click on cell b2 in the warehousing table, data--validity--settings, in"Allowed"to choose"Sequence", in"Null values are allowed"with"Provide a drop-down arrow"Before all are ticked, in"**""commodity",OK,So that the warehousing table is linked to the commodity table,B2 cell drop-down menu will appear in the commodity table,What goods can be selected here,This method also supports dragging down。 The same is true for outbound tables.

Then it's the important part, go back to Figure 01 in the inventory table and enter it in cell E3.

sum(if(Inbound Table!) b2:b8=a3,inbound table!

C2:C8,0)), and then press Ctrl+Shift+Enter, this formula means: if the content in cells B2 to B8 in the warehousing table is the same as the content in cell A3, then add up the quantity, otherwise it is 0, and the name in the product table here must be exactly the same as the product name in the inventory table.

Enter in cell h3.

sum(if(Outbound Table!) b2:b8=a3,outbound table! c2:c8,0)), the method is the same, but changed to the outbound table.

Enter =b3+e3-h3 in k3, which means inventory = beginning + inbound - outbound.

These all support dragging down.

Well, a simple inventory management table is done, some details can be optimized, such as choosing a product ** will be automatically added, this can be added yourself, you can also add one more drop-down menu item, defined as a supplier, what goods a supplier supplies, and so on, here is just a brief introduction.