π
Column Mapping Reference
Source β Summary Format
A: Employee Number B: Known Name C: Date of Join D: Entitled Annual E: Entitled Casual F: Entitled Medical G: Annual Taken I: Casual Taken K: Medical Takenβ
Output β miHCM Import Format
Employee Number Leave Year Leave Type Allocation (Days) Used (Days)3 rows per employee (Annual Β· Casual Β· Medical)
1
Source File
Your Leave Allocation summary Excel (Employee_Number, Entitled columns, Taken columns)
Drop file here or click to browse
.xlsx or .xls accepted
2
miHCM Leave Details Template
MiHCM_HR_Leave_Details_Template.xlsx β the official import template
Drop file here or click to browse
.xlsx accepted
3
Settings & Convert
Set the leave year then run the conversion
Applied to every output row
4
Result β Ready to Download
0
Employees
0
Output Rows
3
Leave Types
| Employee Number | Leave Year | Leave Type | Allocation (Days) | Used (Days) |
|---|