There are certain procedures for the work of financial personnel. For example, the work to be done at the beginning of the month, the work to be done in the middle of the month, and the work to be handled at the end of the month, etc., all need to be handled by corresponding financial personnel. Like carrying forward costs at the end of the month, accruing wages and social security...
In addition, some companies will conduct inventory counts at the end of the month. The work of inventory counts can be said to be very time-consuming, but now they use the EXCEL financial system to handle the inventory of purchase, sale and inventory expenses. Today I would like to share with you a21 version fully automatic Excel monthly purchase, sales and inventory expense inventory counting system,< /span>Entering data can automatically generate statistical reports and data visualization analysis tables. If you are interested, you can take a look! (An electronic version is also available at the end of the article)
21 version fully automatic Excel monthly inventory counting system
Characteristics of monthly inventory analysis system for purchase, sales and inventory expenses
Instructions for using the monthly inventory analysis system for purchase, sales and inventory expenses
Detailed operation steps of the monthly inventory analysis system for purchase, sales and inventory expenses
1. Detailed entry of basic product inventory data at the beginning of the period
1. Fill in the basic data in the "Product Beginning Inventory and Basic Data Detailed Table", and then the drop-down menu name standard will be automatically generated in the table;
2. Just enter data in each detailed table on a daily basis as needed, and some items are automatically calculated;
3. Fill in the query or analysis objects according to the drop-down menus in each query and analysis table, and all data and charts will be automatically generated.
2. Enter purchasing data in detail
Notice:
It should be noted that the purchase quantity in this table is the order quantity, including the number of products that may have quality problems. Please see the supplier's return and exchange record table for specific return and exchange data. (Please use the drop-down menu directly for product category, name, specification, model, and unit, which is convenient and practical. The total purchase amount is automatically calculated) as shown in the figure below:
3. Detailed records of supplier returns and exchanges
Note: This table is a detailed record of returns and exchanges to suppliers, including data on returns and exchanges due to product quality problems during the pre-warehousing inspection process, and data on returns and exchanges made to suppliers due to product quality problems during the sales process (after customer returns and exchanges). Data for returns and exchanges. (Please use the drop-down menu directly for product category, name, specification, model, and unit, which is convenient and practical. The number of direct returns processed and the refundable amount are automatically calculated)
4. Product Sales Details
Monthly inventory summary of the purchase, sale and inventory quantities of various products (including weighted calculation, fully automatic)
Warm reminder:
The data in this form is fully automatically generated, please do not enter data. If you add product varieties, please insert rows between rows 7-18, then select the cells with functions and drag them down to copy until all the data is displayed completely. This ensures that the ranking data range is valid. At the same time, it should be noted that all data after the inserted row must be displayed normally (including the last row). If there is no data in the following rows of the table after adding it, just delete it. (If you don’t need ranking data, you can add data directly behind the table, that is, select the cell with the function at the end of the table and drag it down directly to copy.)
Note: This form is used to count and analyze the inventory quantity, sales revenue, sales cost, sales gross profit, sales gross profit margin, unit product gross profit, and inventory amount of all products as of the end of this month. Professional weighted calculation methods are used to ensure accurate data and scientific conclusions. This form does not require entering any data and is fully automatically generated. If you need to add data, please see the instructions on the right.
Comparative analysis of purchase, sale and inventory data of various specifications of products (including weighted calculation method)
Automatically generate reports
Statistics and analysis of product data by name (including weighted calculation method)
Automatically generate reports
Statistics and analysis of various product categories and overall data
Sales cost, gross profit and inventory data of each product Random query
…
The article is too long, so I won’t show them one by one. If you need reference, you can share it for free~~
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ao-le-san-ye-zuo-de-21-ban-jin-xiao-cun-yue-du-pan-dian-fen-xi-xi-tong-zi-dong-sheng-cheng-fen-xi-biao-shi-yong.html
支付宝扫一扫 
评论列表（196条）
测试