Attendance, shifts and leave in one register

Why spreadsheets fail at five or fifty staff

A team of five can keep attendance in a notebook. At twenty, with two branches and shift work, the notebook becomes three spreadsheets that disagree. Each supervisor marks attendance in their own format, leave approvals arrive by message, and the person preparing salaries spends the last days of the month reconciling them by phone.

The cost is not only time. Disputes about whether a day was worked, approved leave or unpaid are decided on records, and a record that exists in three versions persuades nobody.

The most frequent disputes are small and repetitive: a day marked absent that the employee says was a half-day, a Sunday worked without compensatory leave, an approved leave that the supervisor forgot to record. Each costs a few minutes, but together they erode trust between staff and management, and they are almost always settled by whoever has the better record.

What the register holds

In 4softhr each employee has a record with joining date, department and position. Attendance is entered per day, shifts are assigned per week or per month, and leave requests carry a type, dates, a status and an approver. Managers see their own team; the owner sees the whole business.

Because the register holds every employee in one list, the questions that used to take an hour, such as who was absent on 14 September or how many days of earned leave remain for each person, take seconds.

Access should follow roles. A store manager enters attendance and approves leave for their own team, the HR owner sees every branch, and the accountant receives the export. Giving each person only the view they need protects privacy, since attendance and leave data are personal data under the Digital Personal Data Protection Act, 2023, and keeps accidental edits down.

Shifts for shops, clinics and factories

Many Indian businesses run shifts: a pharmacy open from 8 am to 10 pm, a clinic with morning and evening sessions, a workshop with two production shifts. A visible roster prevents the two classic failures, a shift with nobody assigned and the same person scheduled on two overlapping shifts.

Publish the roster at least a week ahead. The state Shops and Establishments Act sets limits on working hours, rest and overtime that differ from state to state, so check them for your location and compare the roster against them before you publish.

Overtime needs the same care as ordinary hours. Record the extra hours on the day, with the approver, so that the accountant can apply the overtime rate your state requires. Overtime that exists only in a supervisor's memory is the commonest source of wage complaints.

Keep a short list of who can cover which shift. When a pharmacist falls ill at six in the morning, the manager who can see qualified substitutes in the register fills the gap in minutes instead of ringing the whole team.

Leave: policies, balances and approvals

Leave entitlements come from three sources: statutory rules, your company policy and the employee's agreement. Statutory benefits include maternity leave under the Maternity Benefit Act for establishments of the size it covers, and state laws on paid holidays and earned leave. Policy adds casual and sick leave, which are the employer's decision.

Write the policy down in a page, enter the annual entitlement per employee and approve requests in the register. A balance visible to the employee prevents the monthly argument over how many days are left.

Public holidays also need a rule. Republic Day, Independence Day and Gandhi Jayanti are observed nationally, while festival holidays are notified by each state, and establishments often adopt their own list. Publish your holiday list for the year in December and load it into the register, so rosters and leave balances are not disturbed by surprises.

Compensatory off is another recurring item. If an employee works on a weekly rest day or a public holiday, record the day worked and the day granted in return, or the payment made instead, so that both the register and the payroll agree on what was settled.

Worked example: a 25-person retail chain

A footwear retailer with three stores and twenty-five staff used paper registers at each store. At month-end, the accounts clerk collected photographs, deciphered handwriting and chased managers about absences. The process took three days and still produced corrections.

With a single register, store managers enter attendance daily and approve leave in the system. On the 28th the accountant exports attendance and leave per employee and uses them as input for salary calculation in their own payroll software. The reconciliation shrinks to a check for exceptions instead of a reconstruction.

In numbers, twenty-five employees across thirty days produce about 750 attendance entries a month. Reconciling them by hand across three stores took the clerk three working days; checking only the exceptions, perhaps forty entries, took half a day. The saving repeats twelve times a year.

What stays outside the register

4softhr does not compute salaries, provident fund, ESI, professional tax or income tax deducted at source for Indian employees. Payroll calculation in 4softhr is available for Romania only. Your accountant or payroll provider calculates, files and pays; the register supplies the days worked and leave taken that those calculations depend on.

At the end of every month, export the register for the accountant in a fixed layout: employee, days present, days of each leave type, unpaid days and overtime hours. A layout agreed once removes a round of questions every month and shortens the payroll run.

No. 4softhr keeps employee, attendance, shift and leave records. Payroll calculation, provident fund, ESI, professional tax and TDS on salary stay with your accountant or payroll software, and payroll calculation in 4softhr itself is available for Romania only. The register provides the days-worked data those tools need as input. You also keep the choice of how salary calculation is done, since the register simply supplies the input days.

Define the rule in your leave and attendance policy, for example how many late arrivals equal a half-day, and record every case against the employee on the day it occurs. A rule written before the first dispute is far easier to apply fairly than one invented afterwards to settle an argument. Write the rule into the staff handbook and apply it identically to every employee, whatever their seniority.

If your establishment is covered by a state Shops and Establishments Act, yes: the Act sets limits on daily and weekly hours, rest intervals and overtime, and they differ by state. Check the rules with the labour department or your adviser and set your shift roster inside those limits. Review the roster against the rules once a quarter and whenever the working hours of the business change.

Yes, when employees are given access to the register they can see their requests, approvals and balance. Giving staff that visibility reduces the number of questions to HR and removes the monthly debate about how many days remain. Access is controlled by the account administrator. The account administrator decides who sees which team, which protects personal data in the register.

One staff register

Salary calculation and statutory deductions stay with your accountant or payroll software.