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 with 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