Leave Entitlement Converter

Transform the summary leave report into the miHCM row-per-leave-type import format. Runs entirely in your browser β€” no data is uploaded anywhere.

1
Source file
2
Template
3
Convert
4
Download
πŸ“‹
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

Showing first 12 rows

Employee NumberLeave Year Leave TypeAllocation (Days)Used (Days)