HR Dashboard KPIs India: Monthly MIS Report Guide for SMBs

If you run a small or mid-sized business in India, you have probably lived this scene. It is the first week of the month, the founder asks "how did we do on people this month?", and someone spends two days stitching together attendance exports, a payroll sheet, an offer tracker and a WhatsApp thread. The answer arrives late, and nobody fully trusts it. A well-designed set of HR dashboard KPIs India founders can rely on fixes exactly this problem.

This guide walks through how to build a monthly HR dashboard and MIS report for an SMB: which KPIs to track, the exact formulas, where the data comes from, how often to refresh each number, how to lay the page out, the pitfalls that quietly wreck credibility, and how to present the whole thing to a founder in ten minutes. You can build it in a spreadsheet this week, or let an HRMS do the assembly for you.

A note on numbers: every figure in the worked examples below is illustrative. We use made-up data to show the arithmetic. We do not quote industry benchmarks, because the right target for your business depends on your sector, city, and stage.

What an HR dashboard and an MIS report actually are

The two terms get used interchangeably, but they do different jobs.

• HR dashboard: a one-page visual summary. It answers "are we okay, and where should I look?" in under two minutes.
• HR MIS report: the fuller monthly pack behind the dashboard. It holds the detailed tables, employee-level or department-level breakdowns, reconciliations, and notes. It answers "why?" and "what do we do about it?"

Think of the dashboard as the cover page and the MIS as the chapters. Founders read the cover; the HR head, finance lead and department managers read the chapters.

Why SMBs need this more than large companies

Large enterprises have analytics teams. SMBs have one or two HR people who also run onboarding, payroll inputs and compliance filings. Without a fixed monthly format:

• Numbers are recomputed from scratch every month, so definitions drift.
• Founders ask ad hoc questions and get ad hoc answers.
• Problems such as rising overtime or a growing leave balance surface only when they become expensive.
• Compliance gaps are found during an audit rather than during a routine review.

A fixed format turns HR reporting from a scramble into a habit, and habits are cheap to maintain.

Principles before KPIs: design rules that keep the report useful

Before choosing metrics, agree on a few rules. They save more arguments than any formula.

1. Fewer, sharper KPIs. Ten to fourteen headline numbers is plenty for an SMB. If everything is tracked, nothing is noticed.
2. One definition per metric, written down. "Headcount" must mean the same thing in January and in December.
3. Every number has an owner and a source. If nobody owns a KPI, nobody explains a spike.
4. Trends beat snapshots. A single month tells you little. Show the last six to twelve months.
5. Every red number gets an action. A dashboard that only reports is a poster. One that assigns a next step is a management tool.
6. Separate leading from lagging indicators. Payroll cost is lagging (it already happened). Rising overtime and absenteeism are leading (they warn you).

A simple way to pick KPIs: the "so what" test

For each candidate metric, ask three questions:

• What decision would change if this number moved?
• Who would act on it?
• Can we compute it reliably every month from data we already hold?

If you cannot answer all three, park the metric for later.

The eight KPI families every SMB dashboard should cover

Here is the core set. We group them into eight families, then cover formulas and sources in detail.

We deliberately keep hiring funnels, regretted attrition and engagement scoring light here. Those deserve their own deep treatment: conceptually, you would pair this dashboard with a dedicated recruitment metrics view, a regretted-attrition analysis that separates the exits you wanted to keep from the ones you did not, and an engagement pulse such as eNPS. This guide focuses on how they slot into the monthly pack, not on how to run them.

Family 1: Headcount and workforce movement

Headcount is the anchor number. Every per-employee ratio (cost per head, absenteeism rate, attrition) depends on it, so get it right first.

Definitions to fix on day one

• Opening headcount: active employees on the first day of the month.
• Joiners: employees whose date of joining falls within the month.
• Leavers: employees whose last working day falls within the month.
• Closing headcount: opening + joiners - leavers.
• Average headcount: (opening + closing) / 2. Use this in rate calculations.

Decide upfront how you treat interns, trainees, consultants, contract staff and part-timers. A common approach is to report employees on payroll as the main number and show contract and consultant headcount separately, so the founder sees total workforce without mixing employment types.

Headcount KPIs and formulas

Worked example (illustrative)

A 60-person company starts September with 58 employees. Four join, two leave.

• Closing headcount = 58 + 4 - 2 = 60
• Net change = +2, or 2 / 58 x 100 = 3.4%
• If the approved plan is 66, headcount vs plan = 60 / 66 x 100 = 90.9%, with 6 open positions.

The founder now sees, in one glance, that the company grew slightly and is still six roles short of plan.

Data source

Your HRMS employee master (date of joining, last working day, status, department, employment type). The check: closing headcount must equal the number of people paid in that month's payroll, plus or minus documented exceptions such as someone on unpaid leave or in a notice period with a settled final payment.

Family 2: Attrition

Attrition tells you how quickly people leave. Keep the headline calculation simple and consistent.

Formulas

Worked example (illustrative)

Using the same company: opening 58, closing 60, so average headcount = (58 + 60) / 2 = 59. Two people left, one resigned and one was terminated.

• Monthly attrition = 2 / 59 x 100 = 3.4%
• Voluntary = 1 / 59 x 100 = 1.7%
• Involuntary = 1 / 59 x 100 = 1.7%

A caution about small numbers

In a team of 60, a single exit moves monthly attrition by nearly two percentage points. That makes the monthly figure jumpy. Always show the rolling 12-month rate next to it, and annotate any month with a spike ("one senior engineer resigned"). Never present a single month's rate as a trend.

Keep the reasons, not just the counts

Add a small table of exit reasons captured in exit interviews or separation forms: better compensation, career growth, relocation, manager relationship, personal, and so on. Reasons make the number actionable. Deeper analysis, such as whether the people leaving were the ones you most wanted to keep, belongs in a dedicated regretted-attrition review, which this dashboard should simply point to.

Family 3: Absenteeism and attendance

Absenteeism is one of the best leading indicators because it moves before resignations do, and before productivity complaints reach the founder.

Definitions

• Scheduled working days: working days in the month for an employee, excluding weekly offs and declared holidays.
• Unplanned absence: absence not approved in advance, such as sudden sick leave, unauthorised absence or loss of pay days.
• Planned leave: approved earned, casual or other leave taken with notice.

Separating planned from unplanned absence is essential. High planned leave in a festive month is normal. High unplanned absence in a specific team is a signal.

Formulas

Worked example (illustrative)

Average headcount 59, scheduled working days 26. Total absence days recorded: 92, of which 31 were unplanned.

• Available days = 59 x 26 = 1,534
• Absenteeism rate = 92 / 1,534 x 100 = 6.0%
• Unplanned absence rate = 31 / 1,534 x 100 = 2.0%

If the 31 unplanned days are concentrated in one team of eight, that team's unplanned rate is far higher than the company figure, and that is the conversation to have.

Data source

Biometric, mobile or web attendance logs, and the leave module. Their integrity depends on regularisation discipline. If attendance corrections are approved late, close-of-month numbers will keep changing, which we cover under pitfalls.

Family 4: Payroll cost

Founders care about this section most, and finance will check it. Build it from the payroll register, not from bank statements or memory.

Cost components to show

• Gross salary paid: fixed pay, variable pay, allowances, arrears.
• Employer statutory contributions: employer share of provident fund, ESI where applicable, and any other statutory employer-side costs relevant to you.
• Other people costs: bonus provisions, gratuity provisions, insurance premiums, reimbursements, recruitment fees, training spend.
• Full people cost: the sum of the above. Some businesses report CTC-based cost instead. Choose one basis and label it.

Formulas

Worked example (illustrative)

Suppose payroll cost last month was 41,00,000 rupees and this month is 43,50,000 rupees. Budget was 42,00,000.

• Month-on-month change = (43,50,000 - 41,00,000) / 41,00,000 x 100 = 6.1%
• Variance vs budget = (43,50,000 - 42,00,000) / 42,00,000 x 100 = 3.6% over
• Cost per employee = 43,50,000 / 59 = about 73,729 rupees

A raw increase means little without an explanation, so add a cost bridge: last month's cost, plus new joiners, plus increments, plus overtime, plus arrears, minus leavers, equals this month's cost. Founders remember a bridge; they forget a percentage.

The payroll cost bridge template

1. Start with last month's total payroll cost.
2. Add full-month cost of joiners who were partial last month.
3. Add part-month cost of new joiners this month.
4. Subtract leavers' salaries and add their full-and-final settlements separately.
5. Add increments or promotions effective this month.
6. Add variable pay, incentives and one-time arrears.
7. Arrive at this month's total and reconcile to the register.

Data source

The finalised payroll register and the payroll journal shared with finance. Agree on a cut-off: the dashboard uses frozen payroll. Do not report before payroll is locked.

Family 5: Overtime

Overtime is both a cost line and a burnout signal. It is also an area where Indian employers should be careful, because overtime rules and wage-rate treatment vary by state and by applicable law. Confirm your treatment with your labour-law adviser and record the policy you follow; the dashboard simply reports what your policy produced.

Formulas

Worked example (illustrative)

Overtime paid this month is 1,10,000 rupees on a gross of 39,00,000 rupees.

• Overtime as % of gross = 1,10,000 / 39,00,000 x 100 = 2.8%
• If 60% of the overtime hours sit with one shift of six people, the issue is a staffing gap in that shift, not a company-wide problem.

How to read it

• Rising overtime with rising headcount vacancies: you are covering open roles with extra hours. Hiring is cheaper than sustained overtime for most roles, and safer for the team.
• Overtime concentrated in a few people: fatigue and attrition risk for exactly those people.
• High unapproved overtime: a controls issue. Fix the approval workflow.

Data source

Attendance logs with an approval step, and payroll earnings heads. Overtime that is calculated in attendance but never reaches payroll is a red flag; reconcile hours to payment every month.

Family 6: Time-to-hire and hiring speed (summary level only)

This dashboard needs only a compact hiring panel. Detailed funnel metrics, source quality and offer-acceptance analysis live in a separate recruitment view. Here we keep four numbers.

Worked example (illustrative)

Four roles were closed in the month, with time-to-fill of 28, 35, 41 and 52 days.

• Average = (28 + 35 + 41 + 52) / 4 = 39 days
• Median = (35 + 41) / 2 = 38 days

If one role took far longer than the rest, the median gives a fairer picture than the average, so show both when you have few data points.

Definition traps

• Start the clock at requisition approval, not when the job was posted. Otherwise internal approval delays disappear from the number.
• Decide once whether the clock stops at offer acceptance or joining. Time-to-join includes notice periods that recruiters cannot control.
• Do not count backfills and new roles as if they behave the same. Split them if volumes allow.

Data source

Your applicant tracking sheet or the recruitment module, with requisition approval dates recorded. Without approval dates you cannot compute a meaningful hiring clock.

Family 7: Leave liability

Leave liability is the most overlooked number in SMB reporting, and finance teams appreciate it when HR volunteers it. Accrued, unused leave that can be carried forward or encashed is a future obligation. How and when it is recognised in the accounts is a matter for your finance team and auditor, and rules on encashment and carry-forward depend on your leave policy and applicable law. The HR job is to supply a clean, policy-aligned balance.

What to include

• Employees' encashable leave balances as of month-end, based on your leave policy.
• The daily salary rate used for valuation, stated clearly (many companies use basic-plus-DA, or a defined salary component, divided by a standard number of days; use whatever your policy and finance team specify).
• Separately, leave that lapses at year end, so the founder knows what is a real obligation and what is not.

Formulas

Worked example (illustrative)

Three employees have encashable balances of 20, 35 and 12 days, with daily rates of 2,000, 3,000 and 1,500 rupees.

• Liability = (20 x 2,000) + (35 x 3,000) + (12 x 1,500) = 40,000 + 1,05,000 + 18,000 = 1,63,000 rupees
• Average balance = (20 + 35 + 12) / 3 = 22.3 days

Scale that across a full workforce and the number becomes worth watching. Notice also that liability is driven by salary level, so a few senior employees with large balances can dominate the total.

What the founder should take from it

A growing liability with low utilisation suggests people are not taking leave, which is both a financial and a wellbeing issue. A gentle nudge policy, or a rule requiring managers to plan leave, often works better than a year-end scramble.

Data source

The leave ledger in your HRMS, joined with salary data from the payroll master. Because it joins two datasets, this is the KPI most likely to be wrong when data lives in separate spreadsheets.

Family 8: Compliance status

For an Indian SMB, a compliance panel is not optional. Founders may not track due dates, but they do care about penalties, notices and reputational risk. This panel does not compute anything; it is a status board.

What to list

Build a table of every recurring obligation that applies to your business, with due date, owner, status and evidence. Typical categories include:

• Provident fund contributions and returns, where applicable.
• ESI contributions and returns, where applicable.
• Professional tax, where your state levies it.
• Tax deducted at source on salaries and the related returns.
• Labour welfare fund, where your state has one.
• Shops and establishment or factory registrations and renewals, where relevant.
• Contract labour and principal employer obligations, if you use contractors.
• Statutory registers and annual filings under whichever laws apply to you.
• Internal committee and policy requirements that apply to your organisation size.

We are deliberately not quoting rates, thresholds or due dates here. They change, they differ by state and by business type, and you should take them from official notifications or your compliance adviser. Your dashboard should hold your calendar, verified by your adviser.

A simple compliance status table

Compliance KPIs

Use a simple traffic light: green for done with evidence, amber for due within the next window, red for overdue. The rule is that red items must have an owner and a date.

Data sources: where every number should come from

A dashboard is only as good as its sources. Map each KPI to a single system of record, and write it down.

The "single source of truth" rule

If two people can give two different headcount numbers, you do not have a dashboard problem; you have a data-ownership problem. Assign one owner per dataset and one monthly data freeze date, after which no back-dated changes are accepted without a documented exception.

Cadence: what to refresh when

Not every KPI needs the same rhythm. Match the refresh frequency to how fast the number can change and how fast you can act.

A monthly calendar that works

1. Working days 1 to 2 after payroll lock: freeze data, run reconciliations.
2. Working day 3: compute KPIs, draft commentary.
3. Working day 4: review with finance for payroll and liability figures.
4. Working day 5: circulate the dashboard and MIS pack.
5. By working day 8: hold the founder review meeting and log actions.

Adjust the days to your payroll cycle, but keep the sequence. The single most valuable habit is a fixed date, so that stakeholders expect the report.

Visual layout: designing the one-page dashboard

A good layout guides the eye from "how are we doing" to "where do I look" to "what do I do".

The four-band layout

Band 1: Headline tiles (top). Six to eight tiles, one per headline KPI: closing headcount, monthly attrition, absenteeism rate, total payroll cost, overtime %, average time-to-fill, leave liability, on-time compliance. Each tile shows the current value, the change vs last month, and a tiny trend line.

Band 2: Trend charts (middle left). Two or three line charts over twelve months: headcount and attrition, payroll cost vs budget, absenteeism and overtime together.

Band 3: Breakdowns (middle right). Department-level bars or tables: headcount, absenteeism and payroll share by team. Use horizontal bars for easy label reading.

Band 4: Alerts and actions (bottom). A short table with red and amber items and the next step, owner and date.

Chart choices that work

• Line charts for trends over time.
• Horizontal bars for department comparisons.
• A waterfall for the payroll cost bridge.
• A simple table with conditional colour for the compliance board.
• Avoid pie charts with more than three or four slices, and avoid decorative 3D effects.

Colour and readability

• Use a consistent green, amber and red only for status, not decoration.
• Do not rely on colour alone; add an arrow or a label, since some readers are colour-blind and many will print in black and white.
• Put the definition of each KPI in a small footnote or an appendix tab.
• Label units clearly: rupees, days, percent.

A text mock-up

Here is a plain-text sketch you can copy into a slide or spreadsheet:

• Top row: Headcount 60 (+2) | Attrition 3.4% | Absenteeism 6.0% | Payroll 43.5 lakh | Overtime 2.8% | Time-to-fill 39 days | Leave liability | Compliance on time
• Middle: 12-month trends and department bars
• Bottom: Top three risks, top three wins, decisions needed from the founder

All numbers in that mock-up are illustrative, taken from the worked examples above.

Step-by-step: building your first monthly HR dashboard

If you are starting from zero, follow this sequence.

Step 1: Agree the scope with the founder

Ask what decisions the founder wants to make with people data: hire more, control cost, retain a team, prepare for fundraising or an audit. Choose KPIs that feed those decisions.

Step 2: Write a KPI dictionary

One row per KPI: name, definition, formula, source, owner, cadence, and a note on exclusions. This is the document that ends definition debates.

Step 3: Clean the employee master

Fix duplicates, missing joining dates, wrong departments and stale statuses. Most reporting errors start here.

Step 4: Build a data extract routine

Decide which exports feed the report each month, in what format, and who runs them. If your HRMS supports reports, save the report definitions so they are repeatable.

Step 5: Build the calculation layer

In a spreadsheet, keep raw data on one tab, calculations on another, and the dashboard on a third. Never type numbers directly onto the dashboard tab.

Step 6: Add reconciliations

Build three checks that must pass before release: headcount equals payroll count, payroll cost equals the finance ledger figure within an agreed tolerance, and leave balances equal the ledger.

Step 7: Add commentary

For every headline KPI, write one line: what moved, why, and what we are doing. Numbers without commentary invite wrong interpretations.

Step 8: Publish, meet, and log actions

Send the pack on a fixed date, hold a short review, and record the decisions. Next month, open the review by checking last month's actions.

Step 9: Review the dashboard itself every quarter

Retire KPIs nobody reads, and add one when a new decision needs it.

Common pitfalls that quietly undermine HR reports

1. Definition drift

Attrition calculated on opening headcount one month and average headcount the next produces a fake trend. Lock the formula in the KPI dictionary.

2. Reporting before payroll is locked

Early numbers get revised, and each revision damages trust. Wait for the lock, or label the report "provisional".

3. Mixing employee types

Blending interns, contractors and permanent staff in headcount distorts cost per head and attrition. Report them separately.

4. Ignoring small-number volatility

With small teams, one person moves the percentages. Use rolling averages and show absolute counts beside percentages.

5. Vanity metrics

Counting training hours or engagement-event attendance without a link to a decision fills space. Ask the "so what" question again.

6. No denominator discipline

Absenteeism divided by total headcount instead of scheduled days, or payroll per head divided by closing rather than average headcount, produces inconsistent ratios. Always document the denominator.

7. Data that cannot be reproduced

If the number lives in someone's personal spreadsheet with hidden formulas, it dies when they leave. Keep formulas visible and documented.

8. Privacy and confidentiality

MIS reports can expose salaries and individual exits. Share aggregated views with wider audiences and restrict employee-level tabs to those who need them. Follow your organisation's data-protection practices and take advice on your obligations under Indian data-protection law.

9. Too many KPIs, too little action

If the meeting ends with "interesting", the dashboard has failed. End every review with named actions.

10. Missing context

A 6% jump in payroll cost is alarming until you learn that annual increments took effect. Always annotate the events that explain a movement.

How to present the HR dashboard to founders

Founders are time-poor and decision-focused. Structure the conversation around decisions, not data.

The ten-minute founder review

1. Minute 0 to 2: the headline. Three sentences: what changed, what worries you, what you need. For example, "We grew by two, payroll ran a little over budget because of increments, and unplanned absence is concentrated in one team."
2. Minute 2 to 5: the tiles. Walk the eight headline numbers left to right, only pausing on those that moved meaningfully or crossed a threshold.
3. Minute 5 to 8: the risks. Cover the top three red or amber items with cause and proposed action.
4. Minute 8 to 10: the asks. State the decisions you need, such as approving two hires, changing an overtime policy or funding a compliance fix.

Language that lands

• Lead with the business effect: "overtime is covering three open roles" beats "overtime is 2.8%".
• Translate percentages into rupees or people wherever you can.
• Compare to plan and to last period, not to unnamed "industry norms".
• Be candid about uncertainty. "This is provisional until final settlements close" builds more trust than false precision.

What founders usually want to know

• Are we within our people budget, and if not, why?
• Which team is at risk?
• Are we exposed on compliance?
• What do we need to decide this month?

If your one-pager answers those four questions, you have done the job.

Doing it in a spreadsheet versus an HRMS

Both work. The trade-off is effort and reliability.

A sensible path is to start in a spreadsheet to learn which KPIs your founders actually use, then move to a system when the monthly assembly starts eating days. Because attendance, leave and payroll sit in one system in an HRMS, the cross-dataset numbers (leave liability, overtime reconciliation, headcount vs payroll) tend to be far easier to keep consistent.

A starter KPI dictionary you can copy

Use this table as the first tab of your workbook.

Frequently asked questions

1. How many KPIs should a small business include in its monthly HR dashboard?

Aim for eight to fourteen headline KPIs. The eight families in this guide give you a complete core view, and you can add a few department-specific numbers. If nobody acts on a metric for three months, retire it.

2. What is the difference between an HR dashboard and an HR MIS report?

The dashboard is a one-page visual summary for quick decisions. The MIS report is the detailed monthly pack with breakdowns, reconciliations and commentary. Most teams publish both: the dashboard as the cover and the MIS as the supporting detail.

3. Should attrition use opening headcount or average headcount?

Either can be valid if used consistently, but average headcount is generally fairer when the team is growing or shrinking during the month. Whichever you choose, write it in your KPI dictionary and do not switch.

4. How do I handle contractors and interns in headcount?

Report employees on payroll as your primary headcount and show contractors, consultants and interns as separate lines. This keeps cost per employee and attrition meaningful, while still giving the founder a view of total workforce.

5. Who should own the monthly report?

Usually the HR head owns the report, with named data owners for attendance, payroll, hiring and compliance inputs. Finance should review the payroll and liability figures before release.

6. Can I build this in Excel or Google Sheets?

Yes. Keep raw data, calculations and the dashboard on separate tabs, add reconciliation checks, and document your formulas. The main risk is manual effort and formula errors as headcount grows, which is when an HRMS becomes worth considering.

7. How often should the dashboard be updated?

Refresh fast-moving signals such as absenteeism, overtime and open requisitions weekly, and publish the full pack monthly after payroll is locked. Review trends and compliance in more depth each quarter.

8. Are there benchmark targets I should aim for?

Be cautious. Benchmarks vary widely by industry, city, role mix and company size, and we do not quote them here. Start by tracking your own trend and your own budget, then set targets that reflect your business plan.

Conclusion: start small, stay consistent

A useful monthly HR dashboard is not about fancy charts. It is about a short list of well-defined numbers, drawn from reliable sources, refreshed on a predictable schedule, and presented in a way that leads to decisions. Start with the eight KPI families, write your dictionary, add reconciliations, and commit to a fixed date every month.

Do that for three months and you will have something most SMBs lack: a trusted, comparable record of how your workforce is changing, and a founder who asks better questions.

If assembling this pack by hand is taking too many hours, CozyHR brings attendance, leave and payroll data together so that headcount, absenteeism, overtime and payroll numbers come from one place. You can explore how CozyHR fits your workflow and try it for your own team whenever you are ready.