How to import Leave Entry from Excel File?
1. Prepare an Excel Spreadsheet with the following format. Sample Import File: LeaveEntry.xlsx⇩
Where
[AMPM] -
A for AM
P for PM
W for Whole Day
T for time
[LEAVE_CODE] - the Leave Type defined in Master Setup ⇒ Leave Type
[MANUAL_OVERWRITE] - (Optional) 1 or 0, If 1, the Leave Days imported can be different from the Leave Days calculated by the Leave From/To by the System.
2. Save the Excel File
3. In HRPro, go to Leave ⇒ Leave Entry. Click the Import button and locate the file you save in step 2.
4. The Leave Records are imported.
See also