EXCEL WAREHOUSE ACCOUNTING TEMPLATE

Warehouse management, automatic inventory calculation, first-in-first-out, location management, and monthly inventory reporting.

The tool uses excel database engine technology, designed and developed according to software engineering ideas, and runs stably, 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 management functions, such as inbound and outbound management functions, inventory management functions, and location management functions.

It can be achieved according to the production date first-in, first-out. 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. The public version may be used at will, but may not be transferred for commercial use or **.

1. Warehousing management, including warehousing materials**, name, quantity, production date, warehousing date, and location.

a. After entering the warehousing quantity, the system will automatically update the inventory quantity of the inventory module.

b. Support modification function, if the inbound quantity is wrong, you can modify it, and the inventory will be automatically updated after modification.

c. The first-in-first-out function is managed by the warehousing date and location.

d. The picking information column is used to show when the warehousing record is out of the warehouse.

2. Outbound management, including outbound materials**, name, quantity, outbound date and other information.

a. After entering the outbound quantity, the system will directly follow the first-in-first-out principle of the production date to find the goods suitable for the location.

b. After finding the corresponding location, subtract the number of outbound goods from the location, and subtract the number of inventory tables at the same time; If the quantity is not enough, then move on to find another location.

c. Mark the picking information (from which location, how much quantity).

d. If the final inventory is not enough to ship, the corresponding record of the outbound table will show the number of out-of-stock.

e. The public version does not support the function of modifying the outbound quantity.

3. The following functions are the official version functions and are provided according to specific needs.

a. Warehousing and warehousing ledger.

b. Nissin report.

c. Single query (query the inbound and outbound information of the specified commodity).

d. Printing of inbound and outbound library instruction sheets.

e. Expense management: automatic calculation of inbound and outbound fees, storage fees, venue fees and other expenses.

f. Expansion of basic information of goods: specifications, weight, volume, shelf life, and safety stock.

g. Shelf life alarm, **alarm automatic** function.

Also sent one to you for your reference.

I sent it to you, pay attention to it.

I have an email address, you can contact me if you have any questions.

Take excel2016 as an example:

1. First of all, in excel**, the cavity skin is opened into the header, and the serial number, date, name of the goods in the warehouse, quantity, recipient, quantity and inventory balance are listed.

2. Then enter the calculation formula under the column of balance: =d2-f2.

3. Click Enter and drop down the formula to see that a set of data with the quantity of "0" is generated.

4. At this time, enter the numbers under the column of the quantity of storage and the column of the quantity of receiving, and the balance can be automatically calculated.

5. If there are other recipients, you can add a new column in **.

6. Then update the balance calculation grip tremor formula: =d2-f2-h2, drop down to fill in the new formula.

1. Create a new worksheet and enter the inventory account 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. Merge and center the cells where "last month's balance, this month's storage, this month's delivery, and this month's balance" are located.

4. Set the text in the center.

5. Add a border to the whole **.

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

1. 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. Merge and center the cells where "last month's balance, this month's storage, this month's delivery, and this month's balance" are located.

4. Set the text in the center.

5. Add a border to the whole **.

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

Take excel2016 as an example:

1. First of all, enter the header in excel**, list the serial number, date, name of the goods in the warehouse, quantity, recipient, quantity and inventory balance.

2. Then enter the calculation formula under the column of balance: =d2-f2.

3. Click Enter and drop down the formula to see that a set of data with the quantity of "0" is generated.

4. At this time, enter the numbers under the column of the quantity of storage and the column of the quantity of receiving, and the balance can be automatically calculated.

5. If there are other recipients, you can add a new column in **.

6. Then update the balance calculation formula: =d2-f2-h2, drop down and fill in the new formula.

1. First of all, take a look at the interface of the home page, make a catalog, and if you want to see which month, you can click to turn it over, which is very clear;

2. This is the core, it is the place for basic data maintenance, you can input the relevant information of the goods, and replace it with your own, which is very simple;

3. This is the warehousing detail page, part of which needs to be entered manually, note that the gray part does not need to be changed, it is a set formula, only the product number, quantity, and unit price can be changed manually;

4. This is the outbound detail page, part of which needs to be entered manually, note that the gray part does not need to be changed, it is a set formula, only the product number, quantity, and unit price can be changed manually;

5. Here is the summary table, the formula functions are set, you don't have to move anything, take a look, is it all automatically generated!

Warehouses generally use purchase, sale and inventory for accounting.

I sent you a full set of warehouse management, a total of two emails, and dozens of documents.

Send you a free version of the warehouse material management software, enter the name of the worker in the customer, and directly send it to the worker. You can check inventory, documents, and details in the report. It is suitable for inbound and outbound management.

Hello, if you don't get a suitable answer here, I suggest you click on my name to consult the online school forum, where there are more professional people, to see if I can give you a suitable answer.

Send a set of templates for your reference. Please check.

1. 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. Merge and center the cells where "last month's balance, this month's storage, this month's delivery, and this month's balance" are located.

4. Set the text in the center.

5. Add a border to the whole **.

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

Answer: Take Excel 2007 as an example, the method of entering and exiting the account ** is as follows: 1. First open Excel 2007 and enter the relevant header as required. (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, where the inventory is there, increase 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.

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; 5. Use the formula to calculate the "ending inventory": enter the formula "=sum(f2:i2)-sum(j2:" in the m2 cell

l2)" means that the beginning of the current period inventory + all incoming quantities - all outbound quantities = ending inventories; 6. Fill the following cells with autofill, that is, to get 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.

Taking Excel 2007 as an example, the method of entering and exiting the account** is as follows:

1. First open Excel 2007 and enter the relevant header as required. (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, where the inventory is there, increase 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. 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;

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 current inventory + all incoming quantities - all outbound quantities = ending inventories.

6. Fill the following cells with autofill, that is, to get 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.

How to do warehouse entry and exit bookkeeping**? I have designed a "warehouse purchase, sale and inventory excel formula system" to meet your warehouse in and out of the bookkeeping** use. If you want, please leave your QQ number, and I will send the system to your QQ mailbox.

This system uses four sets of tables.

1. Table of materials (enter basic information such as material name and specification).

2. Income table (input receipt data) table.

3. Income summary table (no input required, automatic summary) table.

Fourth, there are 1-20 tables respectively (Table 1, Table 2, Table 3...). Used for different departments, (enter the number of shipments, not picking units) table.

5. Monthly report (no input is required, automatic statistics, and current purchase, sale and inventory data can be queried at any time).

1. 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. Merge and center the cells where "last month's balance, this month's storage, this month's delivery, and this month's balance" are located.

4. Set the text in the center.

5. Add a border to the whole **.

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

It depends on whether you use a manual ledger or an electronic ledger.

Generally speaking, ledgers have their own format structure.

In the warehouse, you also need to determine what kind of ledger you need depending on the number of items you manage.

Generally speaking, when the species is less than 50, you can make a ledger, and when it is more than 50, it is better to use an electronic ledger and not do classification.

The main records in the warehouse:

1.The ledger book is a practice of keeping accounts for each item separately by its model.

Date, Incoming Quantity, Outgoing Quantity, Shipping Voucher Number (Production Lot**), Balance Inventory.

In the opening column of the ledger, you should record the quantity you accept at the time of handover.

2.Electronic ledger.

For this example, you need to use an excel sheet.

Primary Records. Receipt date, quantity received, name of goods, production of goods**, purchase order**, shipping date, shipping quantity, shipping name, production batch**, balance quantity, and other factors, of course, different manufacturers will have different requirements for the format.

For the warehouse, there is no need to record the amount, and the record of the amount is recorded and customized by the purchasing side.

According to what you said above, your shipment volume is greater than today's purchase volume.

Of course, it uses your old inventory.

You'll need some documents.

It is the receipt of the documents, the documents issued by the warehouse, just record this as your account book, on the line, if there is no inventory, of course, it will not be shipped.

I hope what I said will help you.