WhatsApp
Pinterest
Trending
Employee Database & HR Master Sheet (Excel)
A clean employee master for small and mid-size companies: job details, joining and exit dates, probation and gratuity alerts, birthdays and anniversaries this month, and a headcount and attrition dashboard.
₹299₹699Save ₹400 (57%)
Inclusive of all taxes · One-time payment · Instant download
1 offer for you
Instant downloadOn screen + email
Secure paymentUPI · Cards · Net Banking
7-day helpFix or refund if faulty
Perfect for
HR teams in small and mid-size companiesFounders managing HR themselvesPayroll and admin teams
What you get2 × .xlsx (blank + sample)
Works withMicrosoft Excel · Google Sheets · WPS Office
DeliveryInstant download
LicencePersonal & own-business use
Frequently bought together
This item: Employee Database & HR Master Sheet (Excel)₹299
Employee Training Matrix & Skill Gap Tracker (Excel)₹299
Performance Appraisal Forms & Rating Calculator (Excel)₹349All three: ₹852₹947Extra 10% off
Most HR problems start with scattered records: joining dates in emails, UANs in payroll, probation dates in someone's diary. One master sheet makes every other HR task faster.
What it does
- Employees: ID, name, gender, date of birth, joining date, department, designation, grade, manager, location, type, phone, work email, UAN, CTC, status and exit date
- Worked out for you: age, tenure, probation end date, gratuity eligibility (5+ years), birthdays and work anniversaries this month, and alerts like 'Confirm by 18-Nov'
- Dashboard: active headcount, joiners and exits this year, attrition, share of women, average tenure, people on probation, monthly salary bill, and a department table with chart
Privacy built in
The sheet avoids sensitive fields you don't need (full Aadhaar, bank passwords) and reminds you to restrict access, in line with India's data protection law.
What's inside
Everything you get
01
Employees
500 employees with alerts
02
Dashboard
Headcount, attrition and department table
03
Lists
Departments, locations and types you can edit
04
Blank + sample
Sample with 10 employees
Files in your download
- XLSXEmployee_Database_HR_Master.xlsx85 KB
- XLSXEmployee_Database_HR_Master_SAMPLE.xlsx86 KB
How to use
Start in 5 simple steps
A step-by-step guide is also included inside your download.
- 1
Add every employee
From joining forms
- 2
Keep status current
Notice and exits
- 3
Check alerts monthly
Probation and anniversaries
- 4
Share safely
HR and managers only
- 5
Review headcount
Every month
FAQ
Questions about this product
What fields should an employee master have?
Identity, job, dates, statutory numbers like UAN, CTC and status. Avoid storing what you don't need, such as full Aadhaar numbers.
How is attrition worked out?
People who left this financial year ÷ (current headcount + people who left). It's a simple, commonly used version.
Does it calculate gratuity?
It flags who is eligible (5+ years). Our payroll and HR letter products cover the amount.
Can managers see only their team?
In Google Sheets, use filter views. For strict separation, share separate copies.
How many employees can it hold?
500 lines are ready; copy rows down for more.
How do I get the files after payment?
A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.
Can I use it on my phone?
Yes. It works with Microsoft Excel, Google Sheets, WPS Office. Free mobile apps are enough.
What if something does not work?
Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.
Our promiseEvery file is tested before launch. If something doesn't work, we fix it or refund you within 7 days. Refund policy
Complete the set
Goes well with this
Trending
New
New
New
Excel & Sheets
House Help Salary & Attendance Register (Excel): Maid, Cook, Driver, Nanny
₹99₹24960% off
