Meta Pixel
LIMITED OFFERSave upto 65% today on SuperBiller Pro EditionExplore Now
Back to All Articles
Payroll & HR Compliance 20 November 2026• 16 min read

What is a Timesheet? Complete Guide, Excel Templates & Salary Computation (2026)

Understand what a timesheet is, explore free Excel templates, and learn how to compute salary, overtime, and wage deductions under Indian labor laws.

S
SuperBiller Payroll & Tax Compliance Team
Verified GST & SaaS Guide
What is a timesheet guide, employee timesheet Excel template and salary computation formulas for Indian businesses
What is a timesheet guide, employee timesheet Excel template and salary computation formulas for Indian businesses
Quick Takeaway (BLUF)

Understand what a timesheet is, explore free Excel templates, and learn how to compute salary, overtime, and wage deductions under Indian labor laws.

Tracking employee working hours accurately is one of the foundational requirements for running a profitable, legally compliant business in India. Whether you manage a high-footfall retail supermarket, a manufacturing unit, a logistics warehouse, or a growing digital agency, workforce productivity directly impacts your bottom line. Yet, thousands of small and medium enterprises (MSMEs) struggle with manual muster rolls, missing punch cards, buddy punching, and inaccurate overtime disputes at the end of the month.

This comprehensive guide breaks down what a timesheet is, how it differs from a simple timecard, the statutory labor frameworks governing working hours and overtime in India, mathematical formulas to compute salaries accurately, and free downloadable Excel templates designed for immediate implementation.


What is a Timesheet? (BLUF Answer Box)

Bottom Line Up Front (BLUF):
A timesheet is a formal data record—maintained either as a physical register, a structured spreadsheet (Excel/Google Sheets), or automated digital software—used by employers and workers to record exact start times, end times, break durations, overtime, and project allocations over a designated pay cycle (daily, weekly, bi-weekly, or monthly). It serves as the primary evidentiary document for computing gross salaries, statutory overtime payments, client billing invoices, and tax compliance audits under Indian labor legislation.

In modern business operations, a timesheet does far more than record presence. It bridges operational floor activity with payroll accounting. By capturing both the quantity of time worked (attendance hours) and the allocation of time (tasks, cost centers, or client deliverables), timesheets provide transparency for workers and business owners alike.


Timesheet vs. Timecard: Key Differences Explained

Many business owners and HR managers use the terms timesheet and timecard interchangeably. While both tools track workforce hours, their scope, complexity, and operational purpose differ significantly.

Comparison FeatureTraditional TimecardComprehensive Timesheet
Primary FunctionCaptures raw attendance (Clock-in and clock-out timestamps).Logs total hours, task allocations, billable vs non-billable time, and project codes.
Typical FormatPaper punch card, biometric fingerprint log, or RFID card swipe.Tabular Excel template, cloud timesheet software, or mobile attendance log.
GranularityBinary: Did the employee show up, and at what time did they enter/exit?Detailed: How many hours were spent on Inventory Audit, POS Billing Counter, or Dispatch?
Client Invoicing UseNot suitable for client billing or job-costing.Essential for client billing, contractor progress claims, and professional services.
Overtime DifferentiationShows raw excess hours without task context.Differentiates regular overtime, holiday overtime, and task-specific incentives.
Ideal ForAssembly line factory workers, hourly security staff, and retail floor workers.Project managers, engineers, accountants, field contractors, and multi-role staff.

While a timecard answers "When was the employee physically present?", a timesheet answers "What productive work was delivered during those hours, and how should it be billed or compensated?"


Types of Timesheets Used in Business Operations

Depending on your payroll cycle, industry norms, and workforce structure, organizations typically adopt one of the following five timesheet structures:

1. Daily Timesheet

A daily timesheet captures day-to-day granular activity. It is widely used by service technicians, construction contractors, field sales executives, and freelance consultants.

  • Key Columns: Date, Task Description, Client Name, Start Time, End Time, Lunch Break Duration, Billable Hours, Non-Billable Hours, and Supervisor Sign-off.
  • Best Suited For: High-value billing environments where clients are charged per hour or per day.

2. Weekly Timesheet

Weekly timesheets record 7 consecutive days (typically Monday through Sunday). They provide an optimal operational balance for retail outlets, Kirana stores, supermarkets, and restaurants that review labor hours on a weekly basis.

  • Key Columns: Employee Name/ID, Monday to Sunday hour columns, Total Regular Hours (capped at 48 standard statutory hours), Overtime Hours, Gross Hours, and Employee Signature.
  • Best Suited For: Hourly staff, retail cashiers, kitchen staff, and warehouse loaders.

3. Bi-Weekly Timesheet

A bi-weekly timesheet covers a two-week period (14 consecutive days), resulting in 26 payroll cycles per calendar year.

  • Key Advantage: Reduces administrative payroll processing overhead by 50% compared to weekly payroll while providing regular cash flow to workers.
  • Best Suited For: Logistics drivers, contracted packaging teams, and multi-branch retail distribution hubs.

4. Monthly Timesheet (Muster Roll Format)

In India, the vast majority of formal MSME payroll is executed on a monthly calendar cycle (from the 1st to the 30th/31st of each month).

  • Structure: Mimics the statutory Form T Attendance Register under the Factories Act and State Shops and Commercial Establishments Acts.
  • Key Columns: Days 1 through 31, Present (P), Absent (A), Paid Leave (PL), Casual Leave (CL), Half-Day (HD), Weekly Off (WO), Total Days Worked, and Payable Days.
  • Best Suited For: Salaried staff, store managers, back-office accountants, and permanent showroom staff.

5. Project-Based & Job Costing Timesheet

Project timesheets allocate work hours across specific projects, contracts, or cost centers rather than calendar days.

  • Structure: Project Code, Task Milestone, Resource Name, Hourly Cost Rate, Logged Hours, and Total Labor Cost.
  • Best Suited For: Civil construction contractors, interior designers, software developers, and legal/tax advisory firms.

Indian Statutory Framework for Working Hours & Overtime

In India, employee working hours, rest intervals, and overtime compensation are strictly governed by state and central statutory acts. Failing to maintain verifiable timesheets or miscalculating overtime can invite severe legal penalties from state labor commissioners.

flowchart TD
    A["Indian Labor Legislation"] --> B["The Factories Act, 1948"]
    A --> C["Shops & Establishments Acts"]
    A --> D["The Code on Wages, 2026"]
    
    B --> B1["Max 9 Hours/Day & 48 Hours/Week"]
    B --> B2["Section 59: Double Overtime (2x Hourly Wage)"]
    
    C --> C1["State-Specific Commercial Rules"]
    C --> C2["Mandatory Weekly Off & Spread-Over Limits"]
    
    D --> D1["Uniform National Minimum Wage Floor"]
    D --> D2["Harmonized Overtime Computation"]

1. The Factories Act, 1948

For manufacturing units, workshops, processing mills, and packaging centers:

  • Daily Working Limit (Section 51 & 54): An adult worker cannot be required or allowed to work more than 9 hours in any day and 48 hours in any week.
  • Rest Intervals (Section 55): No worker can work continuously for more than 5 hours without a rest interval of at least 30 minutes. Total spread-over (work plus rest intervals) must not exceed 10.5 hours per day.
  • Overtime Wages (Section 59): Where a worker works in a factory for more than 9 hours in any day or more than 48 hours in any week, they are statutorily entitled to overtime wages at twice their ordinary rate of pay (200% wage rate).

2. State Shops and Commercial Establishments Acts

For retail shops, supermarkets, distribution godowns, restaurants, and IT/corporate offices, individual state acts apply (e.g., Maharashtra Shops and Establishments Act, Delhi Shops and Establishments Act, Karnataka Shops and Commercial Establishments Act):

  • Standard Working Hours: Typically capped at 8 to 9 hours per day and 48 hours per calendar week.
  • Mandatory Weekly Off: Every employee is statutorily entitled to at least one full day off per week (usually Sunday or a rotational roster off).
  • Overtime Limits: Overtime hours are generally capped at a maximum of 50 to 125 hours per quarter, with overtime paid at double the ordinary wage rate.

3. The Code on Wages (2026 Framework)

Under the harmonized Code on Wages:

  • The definition of Wages includes Basic Pay, Dearness Allowance (DA), and Retaining Allowance. Allowances (such as HRA, conveyance, and bonus) cannot exceed 50% of the total CTC. If allowances exceed 50%, the surplus is added back to Basic Pay for calculating overtime, gratuity, and EPF.
  • Overtime wages must be calculated at not less than twice the standard hourly wage rate.

How to Compute Salary from Timesheet Logs: Step-by-Step Mathematical Formulas

To prevent salary calculation errors and disputes between staff and management, establish a transparent mathematical workflow. Here is the step-by-step formula system used by leading Indian payroll accountants.

Step 1: Determine the Standard Working Days & Daily Wage Rate

In India, the Ministry of Labour and Employment and judicial precedents establish that a monthly salaried worker's daily wage rate is derived using a 26-day divisor (accounting for 4 paid weekly offs in a 30-day month):

$$\text{Daily Wage Rate} = \frac{\text{Monthly Basic Pay} + \text{Dearness Allowance (DA)}}{26}$$

Note: For hourly or retail workers whose contract specifies total calendar days, use 30 or 31 days as defined in their appointment letter.

Step 2: Determine the Ordinary Hourly Wage Rate

Standard daily operational shifts in India are 8 working hours (excluding the 1-hour lunch and tea break):

$$\text{Ordinary Hourly Wage} = \frac{\text{Daily Wage Rate}}{8}$$

Step 3: Compute the Statutory Overtime Rate

Under Section 59 of the Factories Act and respective Shops and Establishments rules, the overtime rate is double the ordinary rate:

$$\text{Overtime Hourly Rate} = \text{Ordinary Hourly Wage} \times 2$$

Step 4: Calculate Gross Earned Salary

Using the timesheet data, aggregate regular days worked, approved paid leaves, and overtime hours:

$$\text{Regular Earned Pay} = \text{Payable Days (Present + Paid Leaves)} \times \text{Daily Wage Rate}$$

$$\text{Total Overtime Pay} = \text{Total Verified Overtime Hours} \times \text{Overtime Hourly Rate}$$

$$\text{Gross Payable Salary} = \text{Regular Earned Pay} + \text{Total Overtime Pay} + \text{Fixed Allowances}$$

Step 5: Deduct Statutory Contributions & Advances

To arrive at the final take-home pay, subtract:

  • Employee Provident Fund (EPF): 12% of (Basic + DA), subject to statutory ceiling rules.
  • Employee State Insurance (ESI): 0.75% of Gross Wages (applicable if gross salary is up to ₹21,000 per month).
  • Professional Tax (PT): State-specific slab (typically ₹200 per month).
  • Salary Advances / Khata Udhar: Direct deductions for store advances given to the worker during the month.

$$\text{Net Take-Home Salary} = \text{Gross Payable Salary} - (\text{EPF} + \text{ESI} + \text{PT} + \text{Store Advances})$$


Real-World Case Study: Retail Showroom Supervisor in Ahmedabad

Let us examine a concrete, realistic Indian business scenario.

Employee Profile:

  • Name: Rajesh Sharma
  • Designation: Senior Floor Supervisor at an Electronics & Appliance Retail Store
  • Monthly Basic Pay + DA: ₹26,000
  • Monthly HRA & Fixed Allowance: ₹4,000
  • Total Monthly CTC: ₹30,000
  • Month: March 2026 (31 Calendar Days, 4 Sundays)
  • Shift Duration: 8 hours per day

Timesheet Logs for March 2026:

  • Present Days: 25 Days
  • Paid Festival / National Holiday: 1 Day (Holi)
  • Paid Weekly Offs (Sundays): 4 Days
  • Total Payable Days: 30 Days (1 Day Unpaid Absenteeism)
  • Logged Overtime Hours (Evening festive sales rushes): 16 Hours

Mathematical Calculation:

  1. Daily Wage Rate:
    $$\text{Daily Wage Rate} = \frac{₹26,000}{26} = ₹1,000 \text{ per day}$$
  2. Ordinary Hourly Wage:
    $$\text{Hourly Wage} = \frac{₹1,000}{8} = ₹125 \text{ per hour}$$
  3. Overtime Hourly Rate (Double Rate):
    $$\text{Overtime Rate} = ₹125 \times 2 = ₹250 \text{ per hour}$$
  4. Regular Earned Salary:
    $$\text{Regular Pay} = 30 \text{ Days} \times ₹1,000 = ₹30,000$$
  5. Overtime Earnings:
    $$\text{Overtime Pay} = 16 \text{ Hours} \times ₹250 = ₹4,000$$
  6. Total Gross Salary for March:
    $$\text{Gross Salary} = ₹30,000 + ₹4,000 = ₹34,000$$
  7. Statutory Deductions (EPF @ 12% on Basic ₹26,000):
    $$\text{EPF} = ₹3,120$$
    $$\text{Professional Tax (Gujarat)} = ₹200$$
  8. Final Net Bank Transfer / Take-Home Pay:
    $$\text{Net Take-Home} = ₹34,000 - (₹3,120 + ₹200) = ₹30,680$$

By maintaining an indisputable timesheet, both Rajesh and the retail store owner have 100% clarity on how the ₹30,680 figure was calculated, completely eliminating end-of-month wage grievances.

You can instantly generate, format, and print compliant salary slips using the Free Salary Slip Generator.


Free Excel Timesheet Template: Column Architecture & Structure

If your business is currently using unorganized paper diaries or blank notebooks, you can immediately build a professional Excel or Google Sheets timesheet using the following standardized column architecture.

Weekly Timesheet Format (Ready for Excel / Google Sheets)

==================================================================================================================
                                    SUPERBILLER WEEKLY EMPLOYEE TIMESHEET
==================================================================================================================
Employee Name: _______________________    Employee ID: SB-_____         Department: Retail / Warehouse
Designation:   _______________________    Supervisor:  _________         Pay Period: Monday To Sunday
Hourly Rate:   ₹ ________                 Overtime Rate (2x): ₹ _____    Week Starting Date: __/__/2026
------------------------------------------------------------------------------------------------------------------
Day       Date       In Time   Out Time   Lunch (Mins)   Regular Hrs   Overtime Hrs   Total Hrs   Task / Project Code
------------------------------------------------------------------------------------------------------------------
Monday    10/03/26   09:30 AM  06:30 PM   60 Mins        8.00          0.00           8.00        POS Billing Counter
Tuesday   11/03/26   09:30 AM  08:30 PM   60 Mins        8.00          2.00          10.00        Stock Inward / Unloading
Wednesday 12/03/26   09:30 AM  06:30 PM   60 Mins        8.00          0.00           8.00        Shelf Merchandising
Thursday  13/03/26   09:30 AM  09:00 PM   60 Mins        8.00          2.50          10.50        Festival Footfall Rush
Friday    14/03/26   09:30 AM  06:30 PM   60 Mins        8.00          0.00           8.00        Customer Order Dispatch
Saturday  15/03/26   09:30 AM  07:30 PM   60 Mins        8.00          1.00           9.00        Weekend Sales Floor
Sunday    16/03/26   --        --         --             0.00 (WO)     0.00           0.00        Weekly Off (Paid)
------------------------------------------------------------------------------------------------------------------
WEEKLY TOTALS:                                           48.00 Hrs     5.50 Hrs      53.50 Hrs
------------------------------------------------------------------------------------------------------------------
REGULAR PAY:      48.00 Hrs  × ₹ 125.00/hr = ₹ 6,000.00
OVERTIME PAY:      5.50 Hrs  × ₹ 250.00/hr = ₹ 1,375.00
GROSS WEEKLY EARNINGS:                     = ₹ 7,375.00
------------------------------------------------------------------------------------------------------------------
Employee Signature: ______________________             Supervisor Approval: ______________________

Essential Excel Formulas to Automate Your Timesheet

If you are designing this in Microsoft Excel or Google Sheets, use these formulas to calculate hours automatically:

  1. Calculate Daily Working Hours (Excluding Lunch):
    If In-Time is in Cell C6, Out-Time is in Cell D6, and Lunch Break in minutes is in Cell E6:
    =ROUND(((D6 - C6) * 24) - (E6 / 60), 2)
    
  2. Segregate Regular Hours (Capped at 8 Hours):
    =MIN(8, Total_Hours_Cell)
    
  3. Calculate Overtime Hours (Hours Exceeding 8 Hours):
    =MAX(0, Total_Hours_Cell - 8)
    
  4. Compute Total Earnings:
    =(Regular_Hours * Standard_Hourly_Rate) + (Overtime_Hours * Standard_Hourly_Rate * 2)
    

5 Common Timesheet Mistakes Indian MSMEs Make (And How to Fix Them)

1. Treating Overtime as Flat Single Rate

Many business owners pay overtime at the flat regular hourly wage rate (e.g., ₹100 per regular hour and ₹100 for overtime). This is a direct violation of Section 59 of the Factories Act and State Shops and Establishments Acts, which mandate payment at twice the ordinary rate. During a labor inspection, back-wage claims with heavy interest and penalties can be enforced.

  • Fix: Ensure your timesheet spreadsheet automatically multiplies overtime hours by 2x the base hourly rate.

2. Failing to Track Rest Breaks

Recording only raw clock-in (09:00 AM) and clock-out (09:00 PM) without accounting for mandatory meal intervals (45–60 minutes) artificially inflates logged hours and leads to incorrect overtime payouts.

  • Fix: Include dedicated columns for lunch and tea breaks, or set an automated 60-minute break deduction rule for any shift exceeding 6 hours.

3. Relying on Unverifiable Physical Paper Registers

Paper registers kept on the cash counter are prone to buddy punching (one employee signing attendance on behalf of an absent colleague), backdated signature forging, and physical destruction from spills or misplacement.

  • Fix: Implement digital attendance tracking, biometric fingerprint authentication, or modern POS staff logins where each cashier or floor manager clocks in with a secure PIN.

4. Delayed Timesheet Approvals

Reviewing timesheets only at the end of the month makes it impossible to verify whether an employee actually worked 3 hours of overtime on the 5th of that month.

  • Fix: Enforce a weekly review cadence. Floor managers must approve the preceding week's timesheet logs every Monday morning before data is synced to payroll.

5. Disconnecting Timesheets from Payroll and Statutory Deductions

Maintaining timesheets in Excel while computing salaries manually in a separate ledger causes clerical transposition errors, mismatched EPF/ESI contributions, and employee frustration.


Moving from Paper Timesheets to Modern Cloud POS & Staff Tracking

While spreadsheet timesheets represent a significant improvement over rough paper diaries, fast-growing retail businesses with multiple counters, godowns, and shift rotations quickly outgrow manual spreadsheets.

flowchart LR
    A["Traditional Paper Register"] -->|High Friction & Errors| B["Excel / Google Sheets"]
    B -->|Manual Data Entry & Formula Bugs| C["SuperBiller Digital POS & Staff Management"]
    C --> D1["1-Click Cashier PIN Clock-in"]
    C --> D2["Real-Time Shift Cash Balancing"]
    C --> D3["Automated Monthly Payslip Export"]

How SuperBiller Simplifies Workforce Management for Retailers

  1. Cashier-Specific POS Logins: Cashiers and billing staff sign in directly on the Retail POS Billing Counter with their unique employee credentials. Every sale, invoice generated, and cash drawer collection is tied to that specific staff member.
  2. Preventing Cash Register Shortages: At the end of every shift, SuperBiller matches logged staff hours with cash counter balancing, preventing discrepancies between bill collections and physical drawer cash.
  3. Multi-Godown Inventory & Labor Cost Tracking: If staff members work across multiple branches or warehouses, track labor costs against specific godown movements using Cloud Inventory Software.
  4. Instant Client Quotations & Job Costing: For contractors and service providers, billable hours recorded on timesheets can be directly transferred into formal commercial estimates using the Quotation & Estimate Maker.

Frequently Asked Questions (FAQs)

Q1. What is the legal definition of a timesheet in India?

Under Indian labor legislation (including the Factories Act 1948 and state Shops and Commercial Establishments Acts), a timesheet or attendance register (commonly referred to as a Muster Roll or Form T) is a mandatory legal record that documents an employee's presence, daily hours worked, rest intervals, and overtime hours. It acts as primary legal evidence during wage disputes, labor officer inspections, and statutory compliance audits.

Q2. Is overtime calculation at 2x rate mandatory for all employees?

Under Section 59 of the Factories Act 1948 and most state Shops and Establishments Acts, overtime must be paid at not less than twice the ordinary rate of wages (200%) for all hours worked beyond 9 hours in a day or 48 hours in a week. This applies strictly to workmen, operational staff, and non-managerial employees. For managerial or administrative staff drawing higher salaries, overtime terms are typically governed by individual employment contracts.

Q3. How do you calculate hourly wage from a monthly salary in India?

To compute the ordinary hourly wage rate of a monthly salaried employee, divide their monthly Basic Pay + Dearness Allowance (DA) by 26 days (standard working days excluding 4 weekly offs), and then divide the resulting daily wage by the shift duration (usually 8 working hours).
Formula: Hourly Rate = (Monthly Basic + DA) / 26 / 8.

Q4. Can an employer deduct pay for late coming using timesheet logs?

Yes. Under the Payment of Wages Act 1936, an employer can deduct wages for unauthorized absence on a proportionate basis. For example, if an employee arrives 2 hours late without prior approval or compensatory work, the employer may deduct pro-rata wages for those 2 hours. However, arbitrary fines or punitive deductions exceeding the statutory limits of the Payment of Wages Act are strictly unlawful.

Q5. What is the difference between billable hours and non-billable hours on a timesheet?

  • Billable Hours: Time spent directly delivering work, products, or services for a specific client that will be charged on an invoice (e.g., custom tailoring, client consultation, on-site machinery repair).
  • Non-Billable Hours: Time spent on essential internal company activities that cannot be billed directly to a client (e.g., internal staff meetings, store inventory stocktakes, hardware maintenance, mandatory training).

Q6. How long must an employer preserve timesheets and attendance registers?

Under most state Shops and Establishments Acts and the Factories Act, employers are legally required to preserve attendance registers, muster rolls, wage registers, and timesheet logs for a minimum period of 3 years. During PF, ESI, or labor court proceedings, records may need to be produced up to 5 years from the date of the wage cycle.

Q7. How does a timesheet integrate with EPF and ESI contributions?

Timesheet records determine the number of payable days in a month. This determines the gross earned Basic Pay and DA, which forms the basis for calculating the 12% Employee Provident Fund (EPF) contribution. Similarly, gross monthly earnings derived from timesheet attendance determine whether an employee falls within the ₹21,000 monthly threshold for Employee State Insurance (ESI) coverage.

Q8. What is the best free way to generate employee salary slips after completing timesheets?

Once your weekly or monthly timesheets are tallied and approved, you can generate compliant, professionally formatted PDF salary slips instantly using SuperBiller's Free Salary Slip Generator. It automatically calculates Basic Pay, HRA, DA, EPF, ESI, and Professional Tax deductions with zero subscription fees.


Statutory References & Official Government Sources

To maintain complete regulatory compliance and adhere to highest E-E-A-T standards, refer to the following official government statutes and portals:

  • Ministry of Labour and Employment (MoLE): Official statutory portal for central labor codes, working hours guidelines, and national wage directives (labour.gov.in).
  • The Factories Act, 1948: Complete statutory text covering Section 51 (Weekly Hours), Section 54 (Daily Hours), Section 55 (Intervals for Rest), and Section 59 (Extra Wages for Overtime) (labour.gov.in/factories-act-1948).
  • Employees' Provident Fund Organisation (EPFO): Guidelines on wage ceilings, eligible basic pay definitions, and PF contribution rules (epfindia.gov.in).
  • Employees' State Insurance Corporation (ESIC): Statutory notifications regarding the ₹21,000 gross wage ceiling and contribution calculations based on days worked (esic.gov.in).
  • Chief Labour Commissioner (Central): Inspection protocols, muster roll preservation requirements, and overtime dispute resolution procedures (clc.gov.in).
Tags:#Timesheet#Salary Computation#Excel Template#Payroll Management#Staff Attendance#Indian Labor Laws#Overtime Calculation#Factories Act 1948
Editorial Integrity & Statutory ComplianceCBIC & GST Council Validated

This guide is authored by the SuperBiller Tax & Retail Operations Desk and fact-checked against official Central Board of Indirect Taxes and Customs (CBIC) circulars, the CGST Act 2017 (Rule 46 & Section 31), and latest GST Council threshold updates. SuperBiller provides MSMEs with compliant billing technology, 80mm thermal printing, and automated tax workflows.

Related Free Indian MSME Tools100% Free
SuperBiller ERP Software

Ready to automate your GST Billing & 80mm POS?

Generate your first tax invoice in under 30 seconds. 100% offline-ready.

Get Started Free