image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Transform your Career with Basic to Advanced concepts, calculations and practical guide with this Ultimate Certification course (Level 1, 2 and 3) in:
Compensation &, Benefits Management
End to End Indian Payroll Management in Excel
Reimbursements Management
Statutory Compliances (Payroll related)
Step by Step Income Tax Calculation on Salaries and Year Ending Process in Payroll, including New Regime and Old Regime
Indian Income Tax (Financial year 2024-25) and Year Ending Activities in Payroll (Employees Investment Declaration, Proofs collection, Tax finalization & TDS, etc.)
for Human Resources, Payroll Accounting, Finance, Statutory Compliances, Accounting,  Management, Company / Firm Owners and other Professionals / Students. Curriculum last updated in November 2024.
Key Benefits of Joining this Ultimate & Comprehensive Course:
Learn from Scratch from Industry Experts and Become an Expert. Covers Beginner to Advanced Level Topics.
Get Ready-To-Use End To End Salary Calculation Template in Excel for Free with this course.
Downloadable PDF materials for most of the topics.
Assignments and Practice sheets, Based on Real-time Industry Practices used by practitioners in companies.
KEY LEARNING OUTCOMES FROM THIS COURSE, TO MAKE A CAREER PROGRESSION IN COMPENSATION & PAYROLL MANAGEMENT:-
1. Compensation and Benefits Management Concepts:
Understand Concepts & Objectives of Compensation Management.
How Compensation Policies are framed & equity theory. How to ensure Equity in Compensation.
Job Evaluation methods & compensation differentials used to fix the pay ranges: Ranking, Classification / Grading, Factor Comparison, Point Method, etc.
2. Compensation / Salary Structuring & Design:
Learn Compensation Structuring:  Design different CTC Structures on Excel : Fixed CTC, Flexi CTC.
Get acquainted with Concepts of Payroll Management, Most Payroll / Salary heads used in Indian Payroll and apply them.
Understand Attendance Cycle & Pay Cycle.
3. End to End Payroll Management / Salary Calculation & Concepts in Excel: 
Calculate Payslip in Excel using different salary ranges.
Prepare End to End Payroll Reports: Salary Register / Salary Statement for bulk employees in an organization using MS-Excel.
4. Statutory Compliances (Payroll Related):
Get hands-on exposure to Statutory Compliance Calculations: PF, ESIC, PT, LWF
Gratuity, Leave Encashment, Statutory Bonus, NPS, etc Calculations
5. End to End Income Tax (Indian) on Salaries:
Calculate Complete Income Tax on Salaries: Total Income, Taxable Income and TDS. Understand Form16 and more.
Understand different Indian Income Tax (2023-24) Sections, Exemptions and Deductions from Salary.
6. Perquisites Concepts & How they are calculated:
Perquisites Calculation: Accommodation, Car, Driver, Meal Voucher, Superannuation, NPS, etc.
7. Payroll Year Ending Activities guide (Current Financial Year 2024-25):
Year Ending in Payroll and Income Tax: Investment / IT Declarations from Employees, Investment Proofs collection at year-end, etc.
Payroll Process Flow & Payroll Outsourcing Process Flow Concepts and more.
Why you must enroll in this course? : -
This course is completely beginner-friendly and most simplified in nature.
Having some Excel knowledge can help, but not mandatory, as we have included Excel Basics tutorials as well.
The curriculum is Industry and Job Oriented, updated as on date (Indian).
Practical in nature, you can straightaway work on our Case Studies in Excel to gain hands-on skills.
Includes Downloadable Excel case studies, practice sheets and PDF Materials.
A comprehensive course covering a variety of Topics.
Course Faculty has hands-on Industry expertise (12+years) and has trained more than 2800 students so far, including Online and Offline training programs.
If you are puzzled on any of the given topics while going through the course, drop in your questions and we'll be happy to answer them for you!
For those Already Enrolled in 'Ultimate Human Resources: HR Generalist with Payroll' course :-
This course intends to provide an end-to-end, comprehensive guide on the topics of 1. Compensation, 2. Benefits, 3. Payroll Management, 4. Indian Income Tax, 5. Year Ending Activities & Investment Proof collection.
How is this course different from the Ultimate HR Generalist course?
The Ultimate HR generalist course features
Level 1
Compensation, Benefits & Payroll Management Topics. Some of the
Level 2 & Level 3
topics covered in this course are as below: 
Determining Salary Ranges using Job Evaluation Methods, Ensuring Equity in Compensation, End to End Payroll Management (Level 2 & 3) in Excel for Bulk Employees using Excel Formulas, Income Tax end to end calculation on Payroll heads & income from salaries, TDS Calculation, Income Tax calculation, Year Ending Process including Investment & IT Proofs, Perquisites Concepts & Calculations.
Enroll now and get started on the learning journey towards becoming a certified expert in the Compensation, Benefits, Payroll, Income Tax and Year-ending process now!
Course Tags: Certification Course in Payroll, Certification in Indian Payroll, Online Course in Indian Payroll, Compensation Benefits Course, Payroll HR Course, Human Resources Payroll Management, Payroll Accounting Certification, Payroll Accounting in Excel, Salary Calculation in Excel, Payroll in Excel, Indian Statutory Compliances, Payroll Accounting for Finance, Accounts Professionals / MBA, M Com, B Com Students, Income Tax Calculation on Salaries, Most Comprehensive Compensation Benefits and Payroll Course, Compensation and Payroll Management for Beginners to Advanced.

Who this course is for:
Beginners, Aspirants and Professionals in HR, Compensation & Benefits, Payroll, Taxation / Accounts, Finance, Recruitment, Talent Acquisition, Managers, Administrators, etc who are looking forward to grow in this field or to start their career in this field
Anybody who has curiosity and keen interest in learning these topics to broaden their perspective and understanding of given subjects

What you'll learn

Get Insights into different methods of Compensation Strategy, Compensation Planning, Objectives, Equity and Steps involved in designing Compensation Design

Payroll Management : Most Comprehensive cases : End to End Payroll Accounting using Excel

Structuring different types of Compensation Structures : Fixed CTC and Flexible (FBP) CTC Structures

Understand different methods of Job Evaluation in Compensation Planning and in determining Pay Levels

Get a deeper understanding of all important Payroll Concepts in India for HRM, Payroll, Finance, Accounting professionals. With Practical, Hands-on Case Studies

Certification course in End to End Payroll Accounting & Payroll Management in Excel. Most Comprehensive Excel tutorials covering Concepts & Calculations.

Understand all Payroll Components from Basic to Allowances, Be able to structure salary and calculate salary for any amount / job level / location in India

Statutory Compliances : Understand concepts & calculations of PF (Provident Fund), ESIC, PT, LWF, Income Tax, Leave Encashment, Statutory Bonus, Gratuity, etc.

Indian Income Tax (as on date), all sections payroll components exemptions concepts & calculations, Total Income calculation, Tax calculation (TDS) and In

Comprehensive Indian Income Tax calculation on Salaries: Exemptions & Deductions on Salary. Perquisites Calculation: Car, Accommodation, Meal Voucher, Driver

At the end of this practical course, you should be well-versed in All aspects of Compensation & Benefits, Payroll, Income Tax and Statutory Compliances.

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
1
1.1-Introduction
2-Compensation and Benefits Management: Concepts & Equity Theory
14
2.1-Intro to Compensation, Benefits and Payroll Concepts
2.2-Compensation, Benefits & Payroll Intro Quiz
2.3-Assignment 1 Article
2.4-Compensation & Benefits Intro Assignment
2.5-How Compensation Level is Determined
2.6-Compensation Level Fixing Assignment
2.7-How Compensation Level is determined?
2.8-Welcome! Introduce yourself & Download the PDF E-Book on Comp & Payroll guide
2.9-3 Functions of Payroll and Step by step Payroll Management Guide
2.10-Functions of Payroll and Steps in Payroll Quiz
2.11-What is Payroll Cycle and Attendance Cycle?
2.12-4 Post Salary Disbursement Functions in Payroll Management
2.13-Post Salary Disbursement Functions quiz
2.14-Join our HR & Payroll professionals community for Job updates, Discussions
3-International Compensation Management
10
3.1-Introduction to International Compensation Management
3.2-Global Compensation Strategies
3.3-Key Challenges and Considerations in Global Compensation Management
3.4-Developing a Global Compensation Philosophy
3.5-Creating Global Compensation Structures to Ensure Equity and Competetiveness
3.6-Types of International Compensation Structures
3.7-Global Salary Structure Examples
3.8-Components of Salary in the USA
3.9-Components of Salary in the UK
3.10-Salary and Benefits: Key Differences
4-Top Trends in Global Payroll Management in 2024
1
4.1-Top Trends in Payroll Management in 2024
5-Salary Structuring : CTC Structuring Guide : Selecting Salary heads for CTC's
4
5.1-Types of Compensation Structures & Example of CTC's With Downloadable Excel
5.2-Types of Compensation Structure Quiz
5.3-Understanding CTC, Gross Salary and Net Pay
5.4-Difference between CTC, Gross & Net Salary
6-MS-Excel for HR & Payroll : Basics for Beginners
7
6.1-PART1 : MS-Excel Basic Formulas & Functions for Beginners
6.2-MS-Excel quiz
6.3-Part2 : MS-Excel Basic Formulas & Functions for HR & Payroll Professionals
6.4-Excel Quiz 2
6.5-Part3 : MS-Excel Basic Formulas & Functions for HR & Payroll Professionals
6.6-Part 4 : MS -Excel Basic Formulas & Functions -
6.7-Excel - Part 4
7-Indian Payroll Management: Payroll Components and Allowances guide
6
7.1-Various Salary Allowances in India explained. Downloadable list of Allowances.
7.2-Salary Allowances in India - Quiz
7.3-LTA Reimbursement Component Explained
7.4-LTA Reimbursement quiz
7.5-Types of Pay in Payroll : Base, Variables & Extended Benefits
7.6-Types of Pay in Payroll
8-Payroll Management: Practical Payroll in Excel Case Study 1 : Concepts
6
8.1-1. How to structure CTC : Salary Structuring - Part 1. With Downloadable Excel
8.2-Assignment #1 Create the CTC Structure
8.3-Professional Tax Slab as on July 2024
8.4-2. CTC to Gross & Net Salary Calculation in Excel - Part 2. Downloadable Excel.
8.5-3. CTC to Gross & Net Salary Calculation in Excel - Part 3. Downloadable Excel.
8.6-New Wage Code in India 2019 Highlights - Article
9-Practical Payroll in Excel : Case Study 2 : Concepts & Salary Calc
6
9.1-1. Practical Payroll : CTC Structuring & Salary Calculation in Excel - Part 1.
9.2-2. Practical Payroll: CTC Structuring & Salary Calculation in Excel - Case Study
9.3-3. Practical Payroll: CTC Structuring & Salary Calculation in Excel - Case Study
9.4-4.Practical Payroll : CTC Structuring & Salary Calculation in Excel - Case Study
9.5-5.Practical Payroll : CTC Structuring & Salary Calculation in Excel - Case Study
9.6-6.Practical Payroll : CTC Structuring & Salary Calculation in Excel - Case Study
10-Practical Payroll in Excel with ESIC : Case Study 3 & PF Explained
5
10.1-PaySlip Calculation with ESIC & PF - Part 1
10.2-ESIC Concepts Introduction
10.3-CTC Structuring for Salary with ESIC
10.4-PaySlip Calculation with ESIC & PF - Part 2
10.5-Provident Fund PF - Detailed Calculation
11-Leave Encashment, Gratuity & Statutory Bonus : Concepts & Calculations
7
11.1-Let's Learn Leave Encashment - Concepts & Its calculations
11.2-Leave Encashment Quiz
11.3-Understanding Statutory Bonus in India - Concept & Its Calculation!
11.4-Statutory Bonus Quiz
11.5-Understanding Gratuity - Concepts & Hands-on Calculations
11.6-Gratuity quiz
11.7-Assignment - Let's calculate the Leave Encashment, Statutory Bonus & Gratuity
12-Income Tax in India: 2023-24 Financial Year New Regime
6
12.1-New Income Tax Slab in India: 2024-25
12.2-Tax Calculation (New Regime) Sample for the F.Y. 2024-25
12.3-Tax Calculation (Old Regime) Sample for the F.Y. 2024-25
12.4-Income Tax Slab Quiz: 2024
12.5-Income Tax: New Regime 2023-24, Old Regime Concepts, Year Ending & IT Proofs
12.6-Income Tax: New Regime 2023-24, Old Regime & Year Ending Concepts - Part 2
13-Indian Income Tax Calc, Year Ending Activities, Investment Declaration & Proofs
4
13.1-Income Tax : Step by Step: Deductions, Exemptions, Taxable Income, TDS Calc - 1
13.2-Income Tax Calculation in Excel : Step by Step : Part 2
13.3-Income Tax Calculation Step By Step in Excel: Part 3
13.4-Income Tax Calc New Regime 2023 - 24 Step By Step in Excel : Part 4
14-NEW End to End Payroll Calculation for Bulk Employees on Excel: Salary Statement
8
14.1-Important Guidelines for Success in Practical Payroll & Income Tax
14.2-Part 1 Introduction to End to End Payroll Calculation in Excel
14.3-Part 1 - End To End Payroll : CTC Report & Salary Statement. Downloadable Excel.
14.4-Part 2 - End To End Payroll in Excel : CTC Report & Salary Statement on Excel
14.5-Part 3 - End To End Payroll in Excel : CTC Report Preparation for Bulk Employees
14.6-Part 4 - End To End Payroll in Excel : CTC Report Preparation for Bulk Employees
14.7-Part 5 - End To End Payroll in Excel : CTC Report Preparation for Bulk Employees
14.8-Part 6 - End To End Payroll in Excel : CTC Report Preparation for Bulk Employees
15-NEW End To End Payroll Calculation: Pay Days, Attendance, Gross & Net Salary
4
15.1-Part 7 - End to End Payroll in Excel: Pay Days, Attendance & Earned Salary Calc
15.2-Part 8 - End to End Payroll in Excel: Gross Salary Calculation
15.3-Part 9 - End to End Payroll in Excel: Employee Deductions / Gross Deductions
15.4-Part 10 - End to End Payroll in Excel: ESIC, Meal Voucher & Net Salary
16-NEW Comprehensive IncomeTax & TDS Calculation for End To End Payroll Calculation
11
16.1-1. Steps Involved in End to End Income Tax Calculation: Intro
16.2-2. End to End Income Tax Calculate Template in Excel : Parts of Template
16.3-3. End to End Income Tax Calculation of YTD - Year Till Date Total Earnings
16.4-4. End to End Income Tax Calculation of YTD - Year Till Date Total Earnings
16.5-5. End to End Income : Perquisites Income
16.6-6. End to End Income Tax Calc in Excel : HRA Exemption Calculation
16.7-7. End to End Income Tax Calc in Excel : Sec.10 Exemptions
16.8-8. End to End Income Tax : Section 16 Deductions & Income From Salaries
16.9-9. End to End Income Tax : Income From Salaries & Section 24 Deductions
16.10-10. End to End Income Tax : Chapter VI-A 80C to 80U Deductions from Total Income
16.11-11. End to End Income Tax: Final Income Tax Rebate, Cess & Monthly TDS Calc
17-Full and Final Settlement for Exit Employees
1
17.1-Full and Final Settlement Process Guide
18-NEW Compensation Management : Objectives, Pay Equity & Methods of Job Evaluation
13
18.1-Compensation Management: Objectives & Ensuring Equity in Compensation
18.2-Compensation Management Objectives
18.3-Compensation Planning: Equity Theory, Compensation Differentials in fixing pay
18.4-Equity Theory
18.5-Steps in Job Evaluation & Job Evaluation Method 1: Job Ranking
18.6-Job Evaluation Method in your organization & commonly used
18.7-Methods of Job Evaluation
18.8-Job Evaluation Method 2 : Job Classification / Grading Method
18.9-Job Classification or Grading
18.10-Job Evaluation Method 3 : Factor Comparison Method
18.11-Factor Comparison Method
18.12-Job Evaluation Method 4 : Point Method
18.13-Point Method
19-NEW Perquisites : Accomodation, Car. Driver, Meal Voucher, NPS contributions
4
19.1-1. Car Reimbursement & Car Maintenance, Driver Perquisite
19.2-2. Perquisite Calculation on Company Contributions and Meal Voucher
19.3-3. Accommodation Perquisite Calculation
19.4-Bonus Lecture