How to import Leave Entry from Excel File?

1. Prepare an Excel Spreadsheet with the following format. Sample Import File: LeaveEntry.xlsx⇩


[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