Dashboard Overview
Welcome back, Administrator
0
Employees
0
Draft Letters
0
Final Letters
₹0
Total Gross
₹0
Total CTC
Employee CTC Distribution
Monthly employer cost
Draft vs Final Letters
Letter status breakdown
Recent Employees
| Emp Code | Name | Department | Designation | Gross | Take-Home | Status |
|---|
Employee Records
Salary master with all statutory components
Salary Configuration
Full salary master · all components · export
Total Gross
₹0
Total Deductions
₹0
Total Take-Home
₹0
Total CTC
₹0
Salary Configuration
Formula % · default components
Salary Formula Config
⚠️ PF ceiling ₹15,000 → Employee PF max ₹1,800 · Employer EPF max ₹1,950 · ESIC applies only if Gross ≤ ₹21,000
Add New Employee
Fill details — salary auto-calculates from gross
Employee Information
Auto-generates QHRM series · type to override
Salary Structure
⚡ Enter Monthly Gross → Basic = Gross × Basic% → HRA = Basic × HRA%. Adjust percentages freely. ESIC applies only if Gross ≤ ₹21,000.
% Config
⚠️ PF wage ceiling = ₹15,000. Employee PF capped at ₹1,800 (12% × ₹15,000) · Employer EPF capped at ₹1,950 (13% × ₹15,000). If Basic > ₹15,000, ceiling applies automatically.
Computed
📨 Offer Letter Release
Click any employee card → letter appears instantly → release as Draft or Final PDF
🔍
All employees
☝️
Select an employee card above
Their offer letter will appear here instantly for review and one-click release
💰 Run Payroll
Upload attendance · run payroll · manual adjustments
✅ Present — Paid
❌ Absent — LOP 1 day
📅 Week Off — Paid
🎉 Holiday — Paid
½ Half Day — LOP 0.5 day
LOP Deduction = (Absent + Half×0.5) ÷ Working Days × Gross
Select month and upload attendance to begin
No attendance data loaded
📑 Payslips
Download PDF · Email employees · Bulk ZIP
📑
No finalized payroll yet
Run and finalize payroll to generate payslips
Configuration
Letter settings & system preferences
Letter Settings
Emp Code Series Config
Preview: QHRM1932
Letters before serial (e.g. QHRM)
Letters after serial (optional)
Next code continues from max+1
☁ Google Sheets Backup
Auto-sync to Google Sheets via Apps Script webhook
Setup: 1. Open Google Sheets → Extensions → Apps Script → paste the script below → Deploy as Web App → copy URL here.
2. Set auto-backup: on every employee save, or manual only.
2. Set auto-backup: on every employee save, or manual only.
📁 OneDrive / Local Backup
Download complete JSON backup — import it back anytime to restore all data.