How to fill out the expense reimbursement approval form?
1. In principle, the person in charge of the expense should go to the Finance Department to handle the reimbursement procedures within 5 working days after the expense is incurred. Special circumstances may be handled separately.
2. Cut the corners of the original document, face up (in the same direction as the reimbursement document) and paste it on the left side of the reverse side of the reimbursement form.
3. Use a blue or black pen or signature pen to truthfully fill in the various contents of the reimbursement form, such as reimbursement time, reimbursement person, expense summary, number of documents, etc.
4. For purchasing operating expenses, you must go to the warehouse with a valid "Purchase Requisition" (or Procurement Plan) and invoice to go through the procedures for item inspection and storage, and attach the warehouse receipt and direct withdrawal form to the back of the reimbursement document.
5. For non-purchase administrative, office or other expenses, fill in the reimbursement form directly.
6. Outbound training fees should be reimbursed according to the "Training Agreement".
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF (condition area, specified summation condition, summation area)
In layman’s terms, it is described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, then sum the area corresponding to the C2:C5 cell.
Recommended by the editor of Huajun Software Park
expense reimbursement form templateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download an expense reimbursement form template, download it quickly. also,List of approved projects,Project approval status tableIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works