Skip to main content
Early accessBeta, invite only since 1 Nov 2026. A person reads every application.Apply for an invite
Demystify OS

How do I track leave and attendance for 30 employees?

Use one tracker, one request route and one monthly cut-off. Employees raise every leave or missed-punch request in the same place, one named approver answers within a day, and the payroll owner gets a list of exceptions at month end. The routine matters more than the tool.

Who asks this: An owner or admin manager of an Indian business with 20 to 50 employees, tracking leave across WhatsApp messages, a paper register and a spreadsheet, and tired of month-end disputes.

The steps

  1. 1. Write the leave types and the rules once

    List the types you give, such as casual, sick, earned and unpaid, how they accrue, whether they carry forward and how much notice is expected. One page, signed off by the owner. For entitlements that depend on your state or sector, check the labour department's own pages.

  2. 2. Choose one place to raise a request

    Pick a shared form, one chat group for requests only or a single mailbox. Everyone raises leave, half-days, comp-offs and missed punches there, never by a private message to the manager. This one rule removes most disputes.

  3. 3. Name an approver and a response time

    Each person has one approver and a backup. The approver replies within one working day. A request with no reply after a day goes to the backup, and the admin manager sees the list of pending requests every morning.

  4. 4. Keep the tracker current the same day

    The admin manager enters approved leave in the tracker on the day it is approved: person, dates, type, balance after. The balance is a formula, not a memory. People can ask for their balance at any time and get an answer from the sheet.

  5. 5. Handle the edge cases in writing

    Decide how a half-day counts, how a comp-off is earned and used (subject to the applicable law and employment terms), what happens to a holiday inside a leave, and how long a missed-punch correction can be raised. Write each answer as a single sentence in the same one-page policy.

  6. 6. Close the month with an exceptions list

    On a fixed day, for example the 25th, the admin manager lists absences without a request, late marks above the allowed number, and unapproved requests. Managers confirm or correct each line, and the cleaned list goes to the payroll owner.

  7. 7. Review balances every quarter

    Check balances against the policy, look for people with unused or negative balances, and follow up. Share the summary with managers so planned leave is spread across the year rather than bunched at festivals.

A worked example

illustrative

A 32-person engineering workshop in Rajkot keeps one sheet tab per month. In October it shows eleven leave requests, two missed punches and three absences with no request. On the 25th the admin manager sends the three names to the supervisors; two were uninformed sick days and one is a genuine unpaid absence. For someone with a salary of thirty thousand rupees over twenty-six working days, that unpaid day is about eleven hundred and fifty rupees. By the 27th the payroll owner has a clean list, and nobody argues about the count on the 1st.

What goes wrong

  • Requests arrive by call, chat and in person, and nobody can say later what was approved.
  • The approver is travelling, and requests wait for a week.
  • Balances are kept in people's memories, and the same disagreement returns every March.
  • A missed punch is raised three weeks later, with no rule on whether to accept it.
  • Half days and comp-offs are handled differently by each supervisor.
  • The exceptions list is built on the last evening, so errors flow straight into payroll.

How Demystify OS helps

  • Mysty WorkersEarly access

    Mysty Workers can be set up with you to log the leave and missed-punch requests you pass to it in the tracker you already use, draft the reminder to the approver, list pending approvals and answer balance questions from that tracker. Connecting a particular HR tool or tracker is confirmed with the team first.

  • WhatsAppProvisioned on request

    Employees already use WhatsApp, so the request route can live there. It is a channel on request; today the catalogue shows click-to-chat and share links, not automatic sending.

  • Owner brief, morningEarly access

    The morning brief can carry the list of pending approvals and who is out today, so the owner sees both at a glance.

What it does not do. Demystify OS does not decide who gets leave, interpret the law on entitlements or calculate pay for an absence; the payroll owner does that from the exceptions list it prepares.

Questions people ask

Is a spreadsheet enough for 30 people?

Yes, if it has one row per request, a formula for balances and one person who updates it daily. Beyond about 50 people, or with many sites, a dedicated tool saves time. The routine around the sheet matters more than the tool.

How should I handle a half-day leave?

Decide once and write it down: a half-day counts as 0.5 of a day, and the person must say which half. Apply the same rule to everyone. Inconsistent handling between supervisors is the most common source of complaints.

What is a missed punch and how do I correct it?

A missed punch is a day where someone worked but the attendance record shows an entry or exit missing. Set a short window, say three working days, in which they can raise a correction, and have the approver confirm it.

What is comp-off and how is it tracked?

A comp-off is a day off given for working on a holiday or weekly off. Record the date worked and the approver, and log the day it is used. Any use-by period depends on the applicable law and your employment terms, so check them before you set one; without a clear rule, comp-offs pile up.

How do I keep staff from disputing balances?

Let people see their balance whenever they ask, show the working in the tracker, and send a monthly summary to everyone. A balance that is visible and applied consistently rarely gets disputed.

Sources

This is general information, not legal or tax advice. Check with your CA or lawyer.

Apply for the beta.

Demystify OS is invite only, and a person reads every application.

Apply for the beta