Labour Code Salary Sheet in Excel | Basic DA 50 Percent Rule Explained

Sheet (Code on Wages 2019)
Salary Structure & Excel Calculation Format
महत्वपूर्ण नियम (New Labour Code)
Basic Pay + Dearness Allowance (DA) = कम से कम Total CTC का 50% होना चाहिए।

यदि Basic कम होगा तो PF, Gratuity आदि की calculation में adjustment करना पड़ेगा।

Wage में शामिल:

Basic Pay

Dearness Allowance (DA)

Retaining Allowance

1. Salary Structure Example
Components Monthly Amount (₹)
Basic Salary 15,000
Dearness Allowance (DA) 5,000
House Rent Allowance (HRA) 8,000
Conveyance Allowance 2,000
Medical Allowance 2,000
Special Allowance 8,000
Gross Salary 40,000
Check as per New Labour Code
Basic + DA = 15,000 + 5,000 = 20,000

50% of Gross Salary = 40,000 × 50% = 20,000

✔ Rule Satisfied
shivvithika adhyan is live New LABOUR CODES SALARY CALCULATION SHEET Excel फॉर्मेट के साथ PF Calculation Sheet
Employee PF
PF = Basic + DA × 12%

= 20,000 × 12%

= ₹2,400

Employer PF
= ₹2,400

3. ESI Calculation
यदि salary ₹21,000 तक है तभी ESI लागू होगा।

Employee ESI = Gross × 0.75%

Employer ESI = Gross × 3.25%

Example: Gross Salary = ₹20,000

Employee ESI = 20,000 × 0.75% = ₹150

Employer ESI = 20,000 × 3.25% = ₹650

4. Gratuity Calculation
Formula:

Gratuity = (Basic + DA × 15 × Years of Service) ÷ 26

Example:

Basic + DA = ₹20,000 Years of Service = 5

Gratuity = (20,000 × 15 × 5) ÷ 26

= ₹57,692

5. In-Hand Salary Calculation
Components Amount (₹)
Gross Salary 40,000
Employee PF (-) 2,400
Professional Tax (-) 200
Net Salary/In-Hand 37,400
6. Excel Formula Sheet
Purpose Excel Formula
50% Wage Check =(Basic+DA)/Gross*100
PF Employee =(Basic+DA)*12%
PF Employer =(Basic+DA)*12%
ESI Employee =Gross*0.75%
ESI Employer =Gross*3.25%
Gratuity =((Basic+DA)15Years)/26
Net Salary =Gross-PF-PT
7. HR Interview Important Point
New Labour Code Impact
Basic Salary बढ़ेगी

PF Contribution बढ़ेगा

Gratuity Amount बढ़ेगा

In-Hand Salary थोड़ी कम हो सकती है

Retirement Benefits बढ़ेंगेNew Labour Code Salary Calculation Sheet in Excel | Code on Wages 2019 Explained Hindi

Salary Structure Excel Sheet as per Code on Wages 2019 | New Labour Code Hindi

New Labour Code 2020 Salary Calculation Formula in Excel | HR Payroll Hindi

Code on Wages 2019 Salary Breakup Explained | Excel Salary Structure Sheet

Basic Pay 50% Rule Explained | New Labour Code Salary Calculation Hindi

HR Payroll Excel Sheet Under New Labour Code | Salary Structure Format

New Wage Code Salary Structure Explained in Hindi | CTC Calculation Sheet

Labour Code Salary Sheet in Excel | Basic DA 50 Percent Rule Explainedक्या New Labour Code के अनुसार Basic Pay + DA कुल CTC का 50% होना जरूरी है?
इस वीडियो में हम Code on Wages 2019 के अनुसार Salary Structure, Salary Breakup और Excel Calculation Sheet को आसान भाषा में समझेंगे।

📌 इस वीडियो में शामिल Topics:
✔ Basic Salary Calculation
✔ DA Calculation
✔ HRA Formula
✔ PF & ESI Calculation
✔ Gross Salary vs CTC
✔ New Labour Code Rules
✔ Excel Salary Structure Format
✔ HR Payroll Calculation
✔ 50% Basic Wage Rule Explained

यह वीडियो HR Professionals, Students, Payroll Executives, Labour Law Learners और Competitive Exams की तैयारी करने वालों के लिए बहुत उपयोगी है।

📚 सीखिए Practical Salary Calculation with Excel Examples.

👍 Like | Share | Subscribe
🎓 Subscribe: Shivvithika Adhyan
Topic: New Labour Code Salary Structure & Excel Calculation Sheet | Code on Wages 2019
“अगर आपकी Salary 25,000 है… लेकिन PF बहुत कम कटता है… और भविष्य में Pension भी कम मिलने वाली है…
तो समझ लीजिए आपकी Salary Structure में बड़ा खेल चल रहा है!”
किस टॉपिक / वीडियो के लिए SEO Title, Description, Tags और Keywords चाहिए?
आप चाहें तो Thumbnail या Script भी साथ में भेज दीजिए ताकि उसी हिसाब से optimized SEO तैयार कर दूँ।
Sheet (Code on Wages 2019)
Salary Structure & Excel
Thank You for Watching ❤️
See You in Next Informative Session.

new labour code, code on wages 2019, salary calculation sheet, salary structure excel, payroll calculation, hr payroll, salary breakup, basic salary rule, 50 percent basic rule, code on wages hindi, labour law hindi, salary structure format, hr lecture hindi, new labour code india, ctc calculation, salary calculation in excel, pf calculation, esi calculation, payroll management, wage code explained, basic pay da rule, hr professional, labour codes 2020, excel salary sheet, salary formula excel, payroll sheet hindi, minimum wages code, new labour law india, hr practical training, payroll excel tutorial, salary structure under labour code, new wage code salary structure, salary calculation format, basic pay and da rule, labour law lecture, hr classes hindi, employee salary structure, pf and gratuity calculation, hr payroll training, ctc breakup explained, salary structure practical example, code on wages act 2019, labour code update, salary sheet excel format, hr learning hindi, payroll processing, labour laws for hr, salary calculation practical, hr professional lecture, payroll management system, shivvithika adhyan

Видео Labour Code Salary Sheet in Excel | Basic DA 50 Percent Rule Explained канала shivvithika adhyan