HR & Payroll Kit – Every Pro Excel Template for Indian Payroll
All the Pro HR and payroll templates in one ZIP: salary sheet and payroll register, attendance and leave, CTC structure, salary TDS, gratuity, full and final settlement, employee master and onboarding, statutory bonus, and leave encashment and overtime – built for the labour codes.
For: HR and payroll teams, office managers, founders and payroll consultants in Indian businesses.
9 Pro templates · 21 extra Pro sheets · one ZIP download · ₹171 if bought one by one
Get the kitWhy get the kit
- Run payroll end to end – employee master, attendance, salary sheet with PF, ESI, PT and TDS.
- Stay on the right side of the labour codes – bonus, overtime at twice wages, leave encashment and gratuity.
- Handle joiners and leavers – onboarding checklist, CTC offers and full and final settlement.
What's included (9 Pro templates)
Salary Sheet & Payroll Register
Keep each employee's monthly pay once, enter loss-of-pay days and one-off amounts, and the payroll register works out earned pay, employee PF, ESI, professional tax, TDS and net pay – plus employer PF, EPS, EDLI, admin charges and ESI, and the amounts and due dates for each statutory payment.
Pro adds: Payslip, Bank Transfer, PF ECR & ESI
Employee Master & Onboarding Checklist
One master record for every employee – joining date, department, manager, PAN, UAN, ESIC, bank and contact details – with a 16-point onboarding and KYC checklist. Probation and confirmation dates are worked out from the date of joining, and an action list shows overdue confirmations and pending documents.
Pro adds: Dashboard, Employee Profile, Assets & Access
Attendance & Leave Tracker
Pick a month and the register lays out the dates, greys out weekly offs and your holidays, and gives a grid to mark each employee present, absent, on half day, on leave or on duty. It counts every code, highlights days not yet marked and works out loss-of-pay and paid days for payroll.
Pro adds: 12 monthly sheets (Apr–Mar), Leave Balance, Year Summary
Leave Encashment & Overtime Calculator
Record overtime day by day – hours beyond 8 a day, or every hour on a weekly off – and get overtime pay at twice the ordinary rate of wages, monthly hours by employee and a check on the quarterly limit. The leave sheet works out annual leave earned (1 day per 20 days worked), what carries forward up to 30 days, and the days and amount to encash at year end or on exit.
Pro adds: Overtime Slip, Encashment Tax
Statutory Bonus Calculator
Works out statutory bonus for every employee under the Code on Wages, 2019: eligibility (wages up to ₹21,000 a month and 30 days worked), the calculation ceiling of ₹7,000 or the minimum wage if higher, bonus at the rate you declare between 8.33% and 20%, interim or festival bonus already paid, and the payment deadline.
Pro adds: Allocable Surplus, Bonus Slip
CTC to Salary Structure Builder
Enter an annual CTC and the city. The builder sets Basic + DA as a share of CTC, adds HRA, works out employer PF, ESI and gratuity, and fills the rest with a special allowance so the structure adds up exactly to the CTC – then estimates monthly deductions and take-home pay and checks the 50% wage rule.
Pro adds: Employees, Offer Annexure
Salary TDS Calculator 2026-27
Enter annual salary, HRA and rent, deductions and what you have already deducted. The calculator computes income tax for tax year 2026-27 under the new and old regimes side by side, shows which is lower, and works out the TDS to deduct in each remaining month.
Pro adds: Monthly TDS Plan, Declaration & Proofs
Gratuity Calculator & Register
Work out gratuity for one employee – eligibility, years counted, the 15/26 formula, the ₹20 lakh ceiling and the tax-exempt part – and keep a register of the gratuity liability for all your staff as on any date.
Pro adds: Provision Estimate, Gratuity Statement
Full & Final Settlement Calculator
Enter the exit details, monthly pay, notice terms, leave balance and recoveries. The calculator works out the last month's salary, notice pay or recovery, leave encashment, bonus, gratuity, PF, ESI, PT and TDS, and the net amount – with the two-working-day payment deadline under the Code on Wages.
Pro adds: F&F Statement, Exit Checklist
Template kit
Get the HR & Payroll Kit
- All 9 Pro templates in one ZIP
- ₹171 if bought one by one – you pay ₹134
- One-time payment, instant download, free updates
- Use for your business and your clients
We use your details only to deliver the files and support your purchase. See our privacy policy and terms.
Questions
What is in the HR & Payroll Kit?
The Pro edition of all 9 hr & payroll templates: Salary Sheet & Payroll Register, Employee Master & Onboarding Checklist, Attendance & Leave Tracker, Leave Encashment & Overtime Calculator, Statutory Bonus Calculator, CTC to Salary Structure Builder, Salary TDS Calculator 2026-27, Gratuity Calculator & Register, Full & Final Settlement Calculator. You get one ZIP file with an .xlsx file for each.
How much does it cost?
₹134 one-time, paid through Razorpay by UPI, card, netbanking or wallet. Bought one by one, the same Pro templates cost ₹171 at the offer price (regular ₹891).
Do I get new templates added to this category?
The ZIP is put together when you download it, so if you download again from your bookmarked download page after we add a template to this category, the new one is included.
Can I use the templates for clients?
Yes – for your own business or practice, including client work. Please don't resell, share or upload the files.
Which software do I need?
Microsoft Excel 2010 or later, Google Sheets or LibreOffice Calc. There are no macros. Each file opens on a Guide sheet with sample data filled in.
Other kits
Last updated 2026-10-14. Templates are tools, not professional advice.