365 Admin Support and Services TSS Towers, Plot No. 179, Kavuri Hills,
Madhapur, Hyderabad – 500081
www.365adminsupport.com · info@365adminsupport.com

Employee Details Form

Fill this form to prepare Offer Letter, Relieving Letter, Experience Letter and up to 6 months’ Payslips. Data is saved to MySQL.

1. Documents Required

Offer Letter Relieving Letter Experience Letter Payslips

2. Personal Details

Full Name *
Father’s / Mother’s Name
Gender	Male Female Other
Date of Birth
Mobile Number
Email ID
Full Address
City / District / State / PIN

3. Identity & Bank Details

PAN Number
Aadhaar Number (stored, not printed on letters)
Bank Name
Bank Account Number
IFSC Code

4. Employment Details

Employee Code
Designation / Role
Department
Work Location
Date of Joining
Offer Letter Date
Last Working Day
Relieving / Experience Date
Reporting Manager
Job Responsibilities
Final Settlement Cleared?	Yes No

365 Admin Support and Services Salary & Payslip Details
www.365adminsupport.com

Salary & Payslips (up to 6 months)

5. Salary Structure (auto from Excel formula)

Monthly Salary / Gross *
Yearly CTC (Monthly × 12)
Basic (Monthly × 50%)
HRA (Basic × 40%)
Medical (fixed 800)
Conveyance (fixed 1250)
Other Allowance (Monthly − Basic − HRA − Medical − Conveyance)
Gross check (sum of components)
Professional Tax
Other Fixed Deductions
Usual Net Pay (Gross − PT − Other ded.)

Formula from Salary Break-Up Excel: Basic = 50% of monthly · HRA = 40% of Basic · Medical = 800 · Conveyance = 1250 · Other = balance.

6. Last 6 Months Payslips — select Month & Year

#	Month	Year	STD Days	Worked	LOP	Gross	Deductions	Net Pay
1
2
3
4
5
6

Select Month and Year for each row. Gross, Deductions and Net auto-fill from salary above. For exit month, set Worked days.

7. Remarks

8. Declaration

I confirm that the details filled above are correct and may be used to prepare company employment documents.

Employee Signature

Name:
Date:

HR / Authorized Signatory

Name:
Date: