Free download · No signup

Free Timesheet Template India 2027 — Excel and Google Sheets Download

India-specific timesheet templates for IT teams: CL, EL, SL and LOP leave columns, overtime calculation, 2027 holidays and client-billable hours in INR. Ready for Excel and Google Sheets.

Choose a template Automate it with TrackPM

By TrackPM Team · Last updated: October 2026

Choose your format

4 free timesheet templates

Every template has working formulas, dropdowns for leave types and a "How to use" tab. Shaded cells are the ones you fill in.

.xlsx · Excel & Google Sheets

Daily Timesheet Template

Best for: Developers logging hours per task, every day

Date, project, task ID / description
Start and end time — total hours calculate automatically
Client-billable (Y/N) and billable-hours total
Leave type dropdown (CL / EL / SL / LOP / Comp Off)
Overtime flagged above your daily limit (default 9 hours)

Download Daily Timesheet (Excel)

.xlsx · Excel & Google Sheets

Weekly Timesheet Template

Best for: Weekly project reporting and client billing

Monday–Saturday hour grid by project and task
Billable vs non-billable hours, split automatically
Leave type per day and leave-days total
Overtime against daily (9) and weekly (48) limits
Manager approval status, date and signature

Download Weekly Timesheet (Excel)

.xlsx · Excel & Google Sheets

Monthly Timesheet Template

Best for: Payroll processing, FnF settlement and monthly billing

Pick any month — dates, weekends and 2027 holidays fill in
Clock-in / clock-out, working hours, leave type per day
Working days, paid leave, LOP days, comp off earned / availed
LOP deduction and overtime wage in INR
Holidays 2027 tab: 17 central holidays + state holidays

Download Monthly Timesheet (Excel)

.xlsx · Excel & Google Sheets

Project Timesheet Template

Best for: Client billing, project costing and sprint hour logs

Task ID, sprint / phase, developer, date, hours
Billable rate in INR per row, or a default rate
Billable amount and cumulative hours per entry
Budget vs actual hours and budget used (%)
Status / remarks column for client notes

Download Project Timesheet (Excel)

Using Google Sheets? Download any template, upload it to Google Drive, then choose Open with → Google Sheets. The formulas, dropdowns and holiday list carry over, and you can share the sheet with your team for real-time access.

Built for India

What makes these templates India-specific

Most timesheet templates online are built for US or European teams — USD rates, no Indian leave types and no Indian overtime rules. These are built around how Indian IT companies run payroll.

Indian leave columns

Code	Leave type	What it means
CL	Casual Leave	Short, unplanned absences. Typically 7–12 days a year — the number varies by state and company policy.
EL	Earned Leave	Accrues with days worked (1 day per 20 days worked under the OSH Code); can carry forward and be encashed.
SL	Sick Leave	Paid leave for illness. Entitlement varies by state Shops and Establishments Act.
LOP	Loss of Pay	Unpaid absence — reduces that month's salary.
CO	Comp Off	Compensatory off earned for working on a holiday or weekly off.
ML	Maternity Leave	26 weeks for eligible employees under the Code on Social Security, 2020.
PL	Privilege Leave	Another name some companies and states use for Earned Leave.
WFH	Work from Home	A working day, not leave — tracked separately for office planning.

Overtime, the Indian way

Hours above your daily limit (default 9) or weekly limit (default 48) are flagged as overtime. Under the Code on Wages, 2019, overtime is paid at twice the ordinary wage rate — the monthly template calculates it. Change the limits to match your state's Shops and Establishments Act.

2027 holidays pre-loaded

The monthly template's Holidays tab lists all 17 central gazetted holidays for 2027 from the DoPT memorandum, plus common state holidays for Karnataka, Maharashtra, Tamil Nadu and Telangana. Turn off any you don't observe and add company days. See our India public holidays 2027 list.

INR project billing

The project timesheet uses INR rates, not USD. Enter an hourly rate in rupees and the billable amount, budget used and hours remaining calculate automatically — ready for your Indian client invoice.

Step by step

How to use the monthly timesheet for Indian payroll

Enter the employee's name, ID, designation, department and manager at the top.
Set the Month cell to any date in the month and pick the office state — dates, weekdays, weekends and that state's holidays fill in automatically.
Enter the monthly gross salary (not CTC) and choose whether LOP is divided by calendar days or working days, as your payroll policy says.
For each working day, enter clock-in and clock-out — working hours and overtime calculate automatically.
For leave days, pick the leave type from the dropdown (CL, EL, SL, CO, ML, PL, WFH or LOP).
At month-end, the Payroll Summary shows working days, paid leave, LOP days, comp off earned and availed, overtime hours, LOP deduction and overtime wage.
Copy those figures into your payroll run, and get the manager and HR sign-off cells filled before salaries are processed.

Know the limits

Why manual timesheets stop working

These templates work well for teams of up to about 10 people. They start to break down when:

The team grows past 15 people. Collecting, chasing and compiling 15+ timesheets every month becomes a real chunk of HR or project manager time.
Projects span several clients. When developers split time across 3–5 client projects, nobody can accurately rebuild on Friday which client got Tuesday's hours.
Payroll and timesheets live in separate systems. Copying LOP days from a spreadsheet into payroll by hand is a common source of salary errors.
Clients want audit-ready logs. Enterprise clients increasingly ask for task-level time logs with evidence — not a summary spreadsheet.

Time to switch to software?

If more than three of these apply to your team, it's time to move from a template to automated time tracking:

Your team is 15 or more people
You bill clients by the hour and hours are sometimes disputed
Moving timesheet data into payroll takes more than a few hours a month
Your team works across several cities or fully remotely
You run Agile sprints and need hours per story or task
Managers spend time every week chasing timesheet submissions
A payroll error in the last six months traced back to wrong leave or hours data

When you outgrow the spreadsheet

How TrackPM replaces the manual timesheet

TrackPM's time tracking does automatically what these templates do by hand — and connects it to leave, attendance and payroll.

Time logged against tasks

Developers track time on the tasks in their Kanban or Scrum board with the TrackPM desktop tracker — no separate timesheet to fill in.

Learn more

Screenshot evidence

Periodic screenshots and idle detection back every logged hour, so billing questions are answered with evidence, not memory.

Learn more

Manager time approval

Managers review and approve time logs inside TrackPM — no paper signatures or email chains.

Learn more

Leave and payroll connected

Attendance, leave and LOP flow into TrackPM payroll, which works out PF, ESIC, PT and TDS — no copying numbers between sheets.

Learn more

Still on Excel? Start with the template, settle your process, and move to TrackPM when the manual work outgrows the spreadsheet.

FAQ

Frequently asked questions

Are these timesheet templates free to download?

Yes. All four templates — daily, weekly, monthly and project — are free to download with no signup. They are .xlsx files that open in Microsoft Excel, and in Google Sheets by uploading them to Google Drive. Each one includes Indian leave types (CL, EL, SL, LOP, comp off), overtime calculation, INR billing, and the monthly template has 2027 India holidays pre-loaded.

What is the difference between LOP and leave in an Indian timesheet?

Leave (CL, EL, SL or comp off) is paid — the employee gets full salary for leave days within their entitlement. LOP (Loss of Pay) is unpaid — salary is reduced for each LOP day. The usual formula is: monthly gross salary ÷ days in the month × LOP days. Some companies divide by working days instead of calendar days; the monthly template lets you choose. Use gross salary, not CTC — CTC includes employer contributions that are not cut for LOP.

How do I calculate overtime for Indian IT employees on a timesheet?

Overtime is the time worked beyond the normal daily or weekly hours set by your state's Shops and Establishments Act — commonly 9 hours a day and 48 hours a week. Under the Code on Wages, 2019, overtime is paid at twice the ordinary rate of wages. The templates flag hours above the daily and weekly limits you set, and the monthly template works out the overtime wage. Managerial and supervisory roles are often outside the overtime rules, so check eligibility before paying.

Can I use this timesheet template for client billing in India?

Yes. The project timesheet records hours by task and developer with an INR rate per row, and totals the billable amount, cumulative hours and budget used. For most clients a signed timesheet is enough. Enterprise and government clients increasingly ask for task-level digital logs with evidence, which is where time tracking software with screenshots helps.

How do I manage timesheets for remote employees in different Indian cities?

For small remote teams, give each employee the monthly template with their office state selected, so their state's holidays are marked. As the team grows past 10–15 people, collecting and reconciling spreadsheets from several cities becomes a monthly chore — time tracking software like TrackPM, with task-level time logs, manager approval and payroll in one place, is more practical at that point.

Start with the free template. When your team outgrows it, TrackPM is ready.

Automated time tracking, leave and payroll for Indian IT teams — free 30-day trial, no credit card needed.

Try TrackPM free Download templates