What is an MIS report?
An MIS report is a recurring internal report that summarises a function's operational data for management, on a fixed cycle and in a settled format. In HR that usually means one monthly file covering headcount, attendance, payroll cost and attrition.
The name comes from Management Information System, which is strictly a system: the software and processes that collect operational data and present it to managers. The report is the output of such a system.
In most Indian offices the phrase has detached from that origin. An MIS report is now understood to mean any recurring internal report circulated to management, and it is very often an Excel file that no management information system produced. Someone exported three reports, pasted them into a workbook, added a summary tab and mailed it.
This matters when you are asked for one. The request "send me the MIS" almost never means "give me access to the management information system." It means "send the monthly file, in the format we used last month."
What goes into an HR MIS report
An HR MIS is conventionally built from four blocks. They are worth naming separately because they usually come from separate systems and are owned by separate people.
| Block | Typical contents | Usual source |
|---|---|---|
| Headcount | Opening and closing strength, joiners, exits, by department, location and grade | HRMS or an employee master sheet |
| Attendance | Present days, absent days, late marks, overtime hours, leave availed and balance | Biometric or attendance system |
| Payroll cost | Gross, deductions, net, employer contributions, cost by cost centre | Payroll software |
| Attrition | Separations, attrition rate, reason codes, tenure at exit | Exit records, often manual |
Recruitment MIS is a common fifth block where hiring is active: open positions, offers made, offers accepted, time to fill, cost per hire.
The blocks are conventional rather than prescribed. There is no standard for an HR MIS, which is why every organisation's looks slightly different and why a new HR manager's first month is usually spent rebuilding the previous one's workbook.
What formats and cycles are MIS reports produced in?
Monthly is the dominant cycle, timed to the payroll run, because the payroll close is when the numbers stop moving. Weekly attendance MIS is common in manufacturing and in field-force operations where the roster changes faster than a month. Daily MIS exists in high-volume operations and is almost always attendance-only.
Excel remains the default format, for a reason worth acknowledging: the recipient wants to filter it. A PDF looks better and gets used less. Where an MIS has moved to a dashboard, the monthly Excel usually continues in parallel, because someone senior still forwards it.
A caution on the format question. The energy spent making an MIS look better is very rarely the constraint. The constraint is almost always that two systems disagree about the same month.
Why most MIS reports get read once
An MIS that reports levels rather than movement gives the reader nothing to do. Headcount 412, attendance 94%, attrition 1.8% is a set of facts with no implied action, and a reader who cannot act on the report stops opening it.
The reports that survive share a few properties.
- They show change against the previous period and against the same period last year, not a single current figure.
- They break the number down by the cut that would explain it, whether team, manager, location, shift or tenure band, rather than reporting the organisation total.
- They carry a short written note on anything that moved, written by the person who knows why.
- They stay the same shape month to month, so the reader learns where to look.
The fourth is underrated. An MIS whose columns move around each month is re-read from scratch every month, and it will be abandoned faster than one that is merely mediocre but stable.
Why do the numbers in an MIS not reconcile?
Because attendance, leave, payroll and the employee master sit in separate systems that record the same month differently. The genuine cost of an HR MIS is not the report. It is the days spent before it, deciding which system to believe.
The classic conflict is attendance against payroll. The biometric system records an employee as absent on four days; payroll paid for two of them because a leave application was approved after the cut-off; the leave system shows the balance debited in the following month. Three systems, three answers, one employee. Someone reconciles this by hand, for every exception, every month.
The second conflict is the employee master. Headcount from the HRMS and headcount from payroll disagree because a joiner was added to one before the other, or a resignation was processed in payroll while the HRMS still shows the person active. The gap is usually small and always has to be explained.
Where an MIS takes a week to produce, the reconciliation is almost always the week. Reports assembled from one record that already holds attendance, leave and pay together do not have this problem, because there is no second system to disagree with.
Building one that lasts
If you are setting up an HR MIS from nothing, a workable sequence is to fix the definitions first, the cycle second and the format last.
- Write down what each number means before you produce it. "Attrition rate" has at least four common formulas, and two people using different ones will disagree forever without discovering why.
- Decide the cut-off date and hold it. An MIS produced on a different day each month cannot be compared with itself.
- Agree who owns each block, by name. Blocks without an owner are the ones that arrive late.
- Keep the first version short. An MIS that starts at four pages and is read is better than one that starts at twenty and is not.
- Add a written commentary from the outset. It is the part that makes the report useful and the part that gets dropped first when the deadline is tight.
Resist adding a metric because it is available. Every column added to an MIS is a column that must be produced, reconciled and explained every month thereafter, and the marginal ones are what turn a two-hour report into a five-day one.
Distribution and who actually reads it
An MIS with thirty recipients typically has three readers. The rest received it once, never unsubscribed, and now filter it.
Two habits improve this more than any change to the content.
- Send different cuts to different audiences. A functional head wants their function; the leadership team wants the organisation with exceptions called out. Sending everyone the full pack means each reader hunts for their part.
- Put the exceptions at the top. The first thing in the file should be what moved and why, not the headcount table. Readers who find the answer in the first screen return; readers who have to search do not.
Review the distribution list annually and ask recipients directly whether they use it. The reply is informative either way, and removing a name is cheaper than continuing to produce a section that exists because somebody asked for it two years ago and has since changed roles.
Frequently asked questions
Is an MIS report the same as an MIS?
No. The MIS is the system that holds and presents the data; the MIS report is the recurring summary that comes out of it. In common Indian usage the distinction has largely collapsed, and a file assembled by hand in Excel is still called an MIS report.
What is an MIS report in HR?
A recurring summary of HR operational data for management, usually monthly and usually built from four blocks: headcount, attendance, payroll cost and attrition. Recruitment metrics are commonly added where hiring is active.
How do I make an MIS report in Excel?
Export headcount, attendance and payroll for the same cut-off date, reconcile the employee lists against each other first, then summarise each block on its own tab with a front summary sheet showing movement against the previous month. Fix the definitions and the cut-off date before you build the file, because changing either later invalidates every prior month.
How often should an MIS report be produced?
Monthly, timed to the payroll close, is the common cycle because that is when the figures stop moving. Weekly attendance reporting is normal in manufacturing and field operations where the roster changes faster than a month.
What is the difference between an MIS report and a dashboard?
An MIS report is produced on a cycle and sent; a dashboard is live and visited. Most organisations that build a dashboard keep producing the monthly file as well, because it gets forwarded and the dashboard does not.
Why does the MIS take so long to produce?
Almost always reconciliation rather than reporting. Where attendance, leave and payroll sit in separate systems, the exceptions between them are resolved by hand every month, and that work is the bulk of the elapsed time.
Where the MIS comes from in Engage
Engage holds attendance, leave, payroll and the employee master in one record, so the monthly report is a cut rather than a reconciliation. Headcount, attendance, cost and attrition are reported against the same set of employees on the same cut-off date, which removes the exception list that usually consumes the first week of the month.
See reporting in Engage