Sandeep Edgtech

HRMS Portal

Employee ID

Password

Pehla Admin Setup

Yeh screen sirf ek baar dikhti hai

Security: Sirf tab dikhta hai jab Firestore mein koi user nahi hota.

Login ID

Email

Poora Naam *

Role

Payroll Configuration

Provident Fund (PF)

Employee Rate (%)

Employer Rate (%)

Pension Rate (% of Employer)

Admin Charges (%)

EDLI Rate (%)

Wage Cap (₹)

Pension Wage Cap (₹)

Senior Age (years)

ESIC

Employee Rate (%)

Employer Rate (%)

Wage Cap (₹)

Welfare Fund

Employee (₹)

Employer (₹)

Frequency

Professional Tax (PT)

PT Enabled

PT Rate (₹)

Min Salary for PT (₹)

Tax

Basic Exemption (₹)

Rebate Limit (₹)

Cess Rate (%)

OT & Attendance

OT Rate (Multiplier)

OT Rate Basis

Working Days/Month

Weekend Days

Bonus & Gratuity

Bonus Rate (%)

Bonus Max Wage (₹)

Bonus Min Service (days)

Gratuity Formula (N/D)

/

Gratuity Max Amount (₹)

Gratuity Min Service (years)

Leave Encash Basis

Max Leave Balance (days)

Financial Year

Financial Year Start

PF Year Start

Company Details (PDF mein use hoga)

Company Name

Company Address

ESI Registration No

PF Registration No

Dashboard

Total Staff

—

Active

—

Active Loans

—

Quick Operations

Employee

Add/update employee ya directory.

Attendance

Monthly attendance CSV upload.

Loans

New loan ya EMI adjust.

Payroll

Monthly payroll process.

Employee Master

Last: ...

Employee Photo

1. Personal & Work Details

Emp Code (Token No.) *

SE Auto (first 2 digits)

Card No. Auto (after SE)

Company Auto

S / W (Skilled/Unskilled)

Full Name *

Father's / Husband's Name

Date of Birth

Age Auto

Gender

Marital Status

Date of Joining *

Date of Onboarding

Experience (Years) Prior Co.

Designation

Department

Location — Company

Location — Unit

Location Auto

Status

Mobile No

Alternate No

Qualifications

Labour Dept. Online Status

Personal Email ID Required

Official Email ID Optional

Remark

2. Address Details

Permanent Address

State Select → City auto

City Select → PIN auto

PIN Code Auto / Type

Current Address (agar alag ho)

3. Nominee Details

Nominee Name

Relation with Nominee

DOB of Nominee

4. Statutory & Bank Details

PAN No

Aadhar No

UAN No (PF Account)

ESIC No

Bank Name

Account No

IFSC Code

PF Applicable *

ESIC Applicable *

Welfare Applicable *

5. Salary (Rate of Pay)

Basic-Dep

HRA-Dep

Conveyance-Dep

Medical-Dep

LTA-Dep

Spl. Allowance-Dep

Other-Dep

Gross ROP-Dep Auto

Actual Salary (Target)

Tax Amount (₹)

6. Salary History (Last 3 Years — View Only)

Ye sirf reference ke liye hai — editing sirf Salary Increment page se hoti hai.

Year	Date	Salary	Growth %
—

7. Documents (All Optional — Google Drive Upload)

Pehle Save karo employee ko, phir documents upload karein. Settings mein Apps Script URL set hona chahiye.

Photo	Code	Name	Mobile	Dept	Location	Status	Action
Click "Refresh" to load

Enterprise Bulk Upload

Step 1 — Template Download karo

Pehle template download karo — Designation, Department, Location, Bank ke dropdowns Settings se auto-set honge. Row 3 se data fill karo (Row 1 = Headers, Row 2 = Field Keys).

Step 2 — File Select aur Validate karo

Excel / CSV File *

Upload Mode

Attendance Upload

Upload Monthly Attendance (CSV)

Select Month *

Choose CSV File *

Loans

Emp Code	Name & Post	Date	Type	Total Amt	Cur. Balance	EMI	Del

Emp Code	Name	Loan ID	Type	Total Amt	Balance	Std EMI	Issue Date	Status	Action
Refresh click karein

EMI Adjustment

Month:

Emp Code	Name	Loan ID	Balance	Std. EMI	Adjusted EMI
Select month and Fetch...

Payroll Engine

Payroll Status: Select Month

Payroll Controls — Single Month

Select Month *

Location

Date Range Export — Multiple Months (Excel + PDF + Bank Sheet)

Apko fixed time period ka data chahiye? From Month → To Month select karo — sab months ka data ek saath export hoga.

From Month *

To Month *

Location

Group By

Preview DataFetch karein

Select All

✓	Code	Name	Paid Days	Gross Earned	Total Deduction	Net Payable	Detail
No data yet

Staff Overview

Year

Month

Location

Search

Total Employees

—

Total Salary Paid

—

Total Present Days

—

Total Absent Days

—

Total PF

—

Total ESIC

—

Data load karein

Emp Code	Name	Designation	Location	Present	Absent	OT Hrs	Basic	Gross	Net Payable	PF	ESIC	Status	Months
Filter select karke Load Data click karein

System Settings — Dropdown Manager

Ek ek ya bulk mein add karo. Comma se alag karo — jaise SBI, ICICI, HDFC, PNB — Add dabao, sab alag alag add ho jayenge. | Save = sirf wo section | Save All = sab ek saath.

Departments

Comma se alag karo — SBI, ICICI, HDFC

Designations

Comma se alag karo — Operator, Supervisor, Manager

Location Structure

Company Prefix (Mum/Snp) ke under Units aur Output Types define karein. Employee form mein 3 dropdowns se auto-generate hoga: Mum-Unit 1

New Company Prefix

Banks

Comma se alag karo — SBI, HDFC, ICICI, PNB

Employee Status

Comma se alag karo — Active, Left, Probation

S/W Category

Comma se alag karo — S-Skilled, SS-Semi Skilled, W-Worker

Marital Status

Comma se alag karo — Single, Married, Divorced

Labour Dept. Online Status

Comma se alag karo — Registered, Pending, Not Applicable

Qualifications

Comma se alag karo — 8th, 10th, 12th, ITI, Diploma

Tax Type

Employee form mein Tax Type dropdown mein yahi options aayenge (e.g. Professional Tax, TDS, etc.)

Comma se alag karo — Professional Tax, TDS

Leaving Types

Jab employee ka Status "Left" hoga tab "Type of Leaving" dropdown mein yahi options aayenge.

Comma se alag karo — Resign, Terminate, Amendment

Company Code Mapping

Emp Code ke pehle 2 digits se Company auto-identify hogi. E.g. SE → Snp Edgetech, CO → Contract.

Code (2 chars)

Company Name

Document Upload (Google Drive)

Google Apps Script deploy karke Web App URL yahan paste karein. Documents Google Drive mein save honge. Setup Guide

Apps Script Web App URL

Google Drive Main Folder ID

Google Drive pe folder open karo → URL mein last part copy karo

User Management

User ID	Name	Role	Emp Code	Status	Last Login	Actions
Click Refresh to load users

Location Master — State / City / PIN Code

Employee form mein PIN Code type karo → State + City auto-fill. Ya State select karo → City dropdown active ho jayega → PIN auto-fill. Load India Data se 100+ major cities | Import Excel se koi bhi Excel/CSV upload karo (State, City, Pincode columns chahiye).

Search

Filter by State

Total: 0 entries

#	State	City	PIN Code	Action
Click Refresh to load data

Audit Trail

Module

Action

Search (Record ID / User)

Limit

Timestamp	Action	Module	Record ID	Description	By	IP	Details
Click Refresh to load audit logs

Timestamp	User	Role	Action	Status	IP Address	Reason
Click Refresh to load login logs

Data Cleanup — Test Data Remove karo

⚠ Permanent Action — Undo nahi hogi!

Yahan se delete hua data Django database se permanently remove ho jaata hai. Sirf test/sample data clear karne ke liye use karo. Production data par use mat karo.

Django Tables

employees

Employee master records

—

loans

Advance & loan records

—

loan_adjustments

EMI adjustment history

—

loan_payment_logs

Payment transaction logs

—

attendance_monthly

Monthly attendance records

—

processed_attendance_logs

Attendance processing logs

—

payroll_archive

Processed payroll archive

—

payroll_run_logs

Payroll run history

—

employee_leave_balances

Leave balance records

—

app_settings

App configuration (caution!)

—

Payroll Engine

Payroll Status: Select Month

Controls

Select Month *

Location

Preview Data Fetch karein

Code	Name	Present	Gross Earned	Deduction	Net Payable	Detail
No data yet

Leave Configuration

Leave Year Settings

Leave Year Start Month

Leave Year Start Day

Annual Leave Allocation

CL Annual (days)

SL Annual (days)

EL Annual (days) Note: EL monthly accrual se milti hai

EL Accrual Rules

EL Accrual Rate (working days per 1 EL) Present Days ÷ this value = EL earned this month

EL Max Carry Forward (days)

EL Near-Limit Alert (days) Is limit pe HR ko warning dikhega

EL Year-End Cap Policy

Jab EL Balance > Max Carry Forward ho jaye toh:

Option A — Auto Lapse (Extra leaves lapse ho jayengi, balance = 30) Option B — Auto Encash (Extra leaves payroll mein encash hongi)

LWP Calculation

LWP Priority Order Excess leaves kis order mein adjust hongi

Leave Balances

Near EL Limit

—

Zero CL Balance

—

Total Employees

—

Location

Status

Code	Name	Location	CL Available	CL Used	SL Available	SL Used	EL Available	EL Used	LWP (MTD)	EL Status	Last Updated
Click Refresh to load

Salary Increment

✓	Code	Name	Location	Old Gross	New Gross ₹	New Actual ₹	Hike %/₹	Eff. Date	Arrears
Employees load karein

Code	Name	Department	Designation
"Refresh" dabao data load karne ke liye

Step 1 — Employee Select karo

Step 2 — Increment Details

Hike Type

Hike Percentage (%)

Effective Date *

Step 3 — New Salary

New Gross ROP (On-Paper) *

New Actual Salary (Take-Home) *

Edit Components Manually

Check karoge toh Basic/HRA/Conv manually enter kar sakte ho. Uncheck = auto 50/20/30 formula.

Salary Components

Basic (50%)

HRA (20%)

Conveyance (30%)

Medical

LTA

Other (Special Allowance)

Salary History

Year	Date	Salary	Growth %
Employee select karein

Increment History

Increment ID	Effective Date	Old Gross	New Gross	Old Actual	New Actual	Arrears	Status	By	Edit
Employee select karein

Leave Module Control

Current Status

Loading...

Leave Module kya karta hai:
✅ Attendance upload ke baad automatically CL/SL/EL balance deduct karta hai
✅ Excess leaves → LWP mein convert karta hai
✅ EL monthly accrual calculate karta hai
✅ Salary slip mein CL/SL/EL columns fill karta hai
⚠ OFF hone par: Leave balances update nahi honge, slips mein CL/SL/EL blank rahenge

Module Activate / Deactivate

Effective From Date * Is date se sabki leave balance prorated calculate hogi

Leave Year Start Month

Attendance Register

Month

Location

Total Employees

—

Avg Present

—

Avg Absent

—

Total OT Hrs

—

Total Fine

—

Code	Name	Location	Dept	Present	Absent	OT Hrs	CL	SL	EL	LWP	Paid Days	Fine	Incentive	Month
Month select karke Refresh karein

EMI Adjustment History

Filter by Month

Filter by Employee

Total Adjustments

—

Increased EMI

—

Decreased EMI

—

Month	Emp Code	Name	Loan ID	Std EMI	Adj EMI	Difference	Change	Saved At
Refresh karein

Industrial Calculator

Thickness/Dia (T) mm

Width (W) mm (blank=Round)

Length (L) mm

Quantity (Pcs)

Calculated Weight0.000 KG

Sandeep Edgtech

Pehla Admin Setup

Payroll Configuration

Dashboard

—

—

—

Employee

Attendance

Loans

Payroll

Employee Master

Enterprise Bulk Upload

Attendance Upload

Loans

Edit Loan

EMI Adjustment

Payroll Engine

Staff Overview

—

—

—

—

—

—

System Settings — Dropdown Manager

User Management

Add New User

Change Password

Location Master — State / City / PIN Code

Add Location Entry

Audit Trail

Audit Detail

Data Cleanup — Test Data Remove karo

Increment Edit karo

Payroll Engine

Leave Configuration

Leave Balances

—

—

—

Salary Increment

Past Salary History Edit karo

Leave Module Control

Attendance Register

—

—

—

—

—

EMI Adjustment History

—

—

—

Industrial Calculator

Take Photo

Salary Breakdown