User Guide‎ > ‎

How to import Leave Adjustment from Excel File?

1. Prepare an Excel Spreadsheet with the following format with exact column order. (Download sample from attachment)
 
 
WHERE
[EE_NO] - Employee No.
[ADJ_DATE] - Adjustment Date
[DAYS] - positive for leave increment, negative for leave deduction
[NATURE] -     L for Additional Annual Leave Adjustment 
                        J for Annual Leave Adjustment
                        BA for Birthday Leave Adjustment                     
                        EA for Casual Leave Adjustment
                        K for Compensation Leave Adjustment
                        for Full Pay Sick Leave Adjustment
                        MA for Maternity/Paternity Leave Adjustment
                        OA for Others (Full Pay) Adjustment
                        Y for Rest Day (Full Pay) Adjustment
                        Q for Sick Leave (Statutory) Adjustment
                        X for Statutory Holiday Adjustment
                        WA for Working Day Leave (Full Pay) Adjustment

[REMARKS] - maximum number of characters is 4000
 
2. Save the worksheet as Excel File
 
3. In HRPro, go to Leave -> Leave Adjustment, click the Import Button and locate the file you save in step 2.
 
 
4. The Leave Adjustment Records are imported.
 
 
See also