Tips for using the monthly base point chart
Month-end inventory listHow to fill it out?
●Within 3 days after the monthly settlement, submit the payment details to the company and reconcile with the headquarters to ensure that the accounts are consistent and the goods are consistent.
●The inventory is taken on the last day of each month and is organized by the store manager. The inventory is carried out uniformly at the same time.
●After the inventory results are signed and confirmed by the regional supervisor, they are submitted to the cargo dispatcher on the first of every month.
●The original inventory list, original delivery slip, and original special commodity management form will be brought back to the headquarters by the regional supervisor for archiving in the following month.
●Regional supervisors and store managers are responsible for inventory data and results.
●Inventory losses will be compensated by the person responsible at the current selling price. If the responsibility is not clear, all store staff will jointly compensate for it.
●Check the excess goods or amount, and if the reason cannot be found, the excess will belong to the company.
●For model stores that check out on the last day of each month, the payment details must be submitted together with the inventory details on the 1st of each month.
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male", "Female), IF(MOD(MID(C2,17, 1),2)=1,"Male", "Female")) The "C2" in the formula represents the cell where the ID number is entered.
Moon base point tableIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the end-of-month inventory form, download it quickly. In addition,Short-term worker manpower statistics table,Census status record formIt is also a good form template. You are welcome to click to download and experience it.
Useful
Useful
Useful