HOW TO USE EXCEL TO MAKE A COMMODITY PURCHASE, SALE AND INVENTORY REPORT

A lot of people want to try to do it with formulas, but this proves to be very difficult to do. Otherwise, there wouldn't be so many people looking for it.

Generally speaking, the purchase, sale and inventory tool contains the following basic functions, procurement warehousing, sales outbound, inventory (automatically calculated according to inbound and outbound warehousing), cost (moving average method accounting), profit (sales amount minus cost price), statistics (** monthly report), query (inbound and outbound) resume. Other extensions such as product name, specification, weight, volume, unit, etc. are also available. The main difficulty is in the automatic inventory counting.

The general practice is to use pivot tables, but if the amount of data is large, the speed will be severely affected. It is better to use VBA, and the speed is not affected. Depending on the industry, the specific items may vary slightly.

It's really good to use electronic **, you can formula, the simplest kind, the content of ** is approximately: commodity name, unit price, previous balance, warehousing date, warehousing subtotal, warehousing date, outbound subtotal, balance, balance amount.

Use the previous balance + warehousing subtotal - outbound subtotal = balance.

Inbound subtotal = Sum of inbound dates.

Outbound subtotal = sum of outbound dates.

Balance amount = balance * unit price.

A table can reflect a month's purchase, sale and inventory, I have done this before, I hope it will help you!

I also want a report, can you send it to me?

My email address is.

E-mail, sentGo under an excel.

1. First of all, create a new worksheet, name it "January", and set the header information according to the following **.

2. Second, create a new **, named "Limb Selling Data Table", which is used to store [material number] and [name].

3. In the next step, the [material number] and [name] fixed cover with limbs are meaningfully named to facilitate the data entry of the total table of purchase, sale and inventory. Steps: Select the A1:B11 area of the [Data Table], and click [Formula] - [Name of Definition] - [Create from Selection].

4. In the pop-up interface, select [First Row] and click the [OK] button.

5. Go back to the "January" table, select the blank area in column B, and click [Data] - [Data Validity] - select the [Data Validity] button in the drop-down menu.

BAI needs to do purchase, sale and inventory management, and there is a more convenient and trouble-saving way than Excel.

By modernization zhi

The mobile purchase, sale and inventory management software special tool, just scan the code to fill in the item number.

Now there are so many free invoicing financial software on the market, why do you still use Excel invoicing table to manage your business?

You can learn about AIO5. It's free!

I made one for you, you just fill in the inventory and sales quantity, and the inventory amount is automatically calculated.

1.Open BaiOffice Excel Jobs.

Book, which defaults to 3 worksheets, just like the following type of dao.

2.To say is to print multiple worksheets at the same time, right.

Then you need to have enough worksheets first, although you can add multiple ** by inserting it, like the one below.

3.However, if you need a large number of worksheets, I don't think anyone will want to do this, so here is a way to set it up all at once. Specifically, open the "Options" submenu under the "Tools" menu, find the "General" tab in it, and there is an item "Number of Worksheets in the New Workbook", and modify its value to what you need.

4.After closing, you can open a new workbook again, as shown in the following figure.

5.According to the later needs, we need to make 12 of the tables into the style of "warehousing", 12 into the style of "outbound", and the other two are the general table of "purchase, sale and inventory" and the combined table of "material code" and "warehousing type". For example, these 12 "warehousing" tables can be done as follows:

First, hold down the "Ctrl" key on your keyboard and click on each of the 12 inbound tables to select them all.

6.Then intersect the contents in the "January Warehousing" table. When finished, right-click the selected worksheet name and select Ungroup Worksheet from the pop-up menu.

At this time, take a look at whether the other 11 warehousing tables are all good, and in the same way, the 12 outbound tables can also be operated in this way.

I use the software that makes the treasure a lot more free than excel, and it's a lot better than excel, and other software is free, and you can use it to try it, and you can export their data to excel

Warehouse Material Receipt and Receipt Deposit Table.

Warehouse management excel formula system, according to four sets of tables: tower 1, material return table (answer manual input 1 data).

2. The daily income of items is entered into the accounting table (the name of the item is automatically displayed, only the amount of income needs to be entered);

3. Daily outbound delivery accounting table of items (automatically display the name of the item, only need to enter the shipment quantity);

4. "Monthly report" for automatic statistics

You might as well go find a piece of software and get a dollar a day.

A ready-made one, just give it to you.

Search: Beijing Futongville Technology ******, there are many special editions that can be used, including [Warehouse Enterprise Edition] [Invoicing Enterprise Edition] [Standard Free Edition], there will definitely be a suitable one for you.

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.

Let's make one! Find your friends in this area to help you, according to your needs! There won't be a free service for you here!

It is recommended not to do it, or to use a software directly, financial steward software", it is worth using.

It's not that I doubt your ability, it's just that it's very troublesome to do, and I don't know if I can use it after working so hard to make it.

Waste of time, waste of energy.

It has been sent to you, accept it, and contact me if you have any questions! (Xiamen Runxun Software****).

Invoicing, mainly the inventory of the previous period, warehousing, export, and then the inventory of the current period.

As shown in the figure below, the invoicing is based on the date, as shown in the figure below, the balance of the current period on August 1 = the balance of the previous period + warehousing - warehousing, that is, the inventory of the day is equal to the previous inventory balance + the quantity of the day's warehousing - the number of exports on the same day:

As of August 2, the balance of the previous period = the balance of the current period on August 1:

After all the dates are added, you can drop down the formula E2 and B3 cells, and it will automatically help you calculate the balance of the previous period and the balance of the current period, but you need to manually enter it when entering and leaving the warehouse.

Check this out and hope it helps.

Vicky** assistant network, help you customize VBA macro programs.