Preview A to Z of Payroll Processing

Lectures 3-6

Lecture 3 : Glossary

Lecture 4 : What is Payroll

Lecture 5 : Wages

Lecture 6 : Salary

Lecture 7: Allowances

[EXTRA] HRA Calculation and Income Tax Exemption Rules | House Rent Allowance

[EXTRA] LTA: Leave Travel Allowance |Calculation & income tax exemption

[EXTRA] Children Education Allowance & Hostel Allowance | Income tax exemption | Tax Saving Tips 2019

HomeWork #1 Salary Rule

Lecture 8: Attendance

HomeWork 2 Attendance

Lecture 9: Wage Calculation Formulas

HOMEWORK 3 Wage Calculation

Solution- HOMEWORK 3 Wage Calculation

Lecture 10: Leave ( EL, SL, CL etc )

Leave Basics | Watch this before you watch lecture #10

HomeWork 4 _ Leave

Solution- HomeWork 4 _ Leave

Lecture 11: Arrear

Homework 5 Arrear Excel

Solution- Homework 5 Arrear Excel

Lecture 12: Overtime and Incentive Calculation

[ EXTRA DOSE ] Overtime Pay Calculation & Maximum Working Hours Rules

Lecture 13: Non Statutory Deductions

Code on Wages

Lecture 14: Statutory Components | Introduction

[ EXTRA [ LAW MAKING PROCESS IN INDIA

Lecture 15: ESI Calculation

[ EXTRA DOSE ] Employee State Insurance Act 1948 (ESI Act)

[Notes] ESIC IMPLIMENTED AREAS

[Notes] ESIC WAGES APPLICABALITY

[Notes] ESIC-137-to-176

( OPTIONAL ) Basic Excel Formula - Multiply, Divide,Add, Subtract in Excel

( OPTIONAL ) Excel IF Formula

( OPTIONAL ) Dollar Sign $ in Excel | Cell referencing

Lecture 16: Minimum Wage

[ EXTRA DOSE ] Minimum Wages Act, 1948

Important Note | Impact of Labour Codes

Homework 7 minimum wage home work

Solution - Homework 7 minimum wage

Lecture 17: PF Part 1 (Free Lesson & Resources)

GSR-609E-full-detail

Homewrok 8 pf 1

Solution- Homework 8 pf 1

Lecture 18: PF Part 2

HomeWork 9 : PF 2

Solution- Homework 9 pf 2

Lecture 19 : Bonus

Homework 10 BONUS CALCULATION

Lecture 20: Gratuity

HomeWork 11 Gratuity calculation

Lecture 21: Labour Welfare Fund

LWF Calculation

LWF Slabs and Rules

All Downloads

Lecture 22: Professional Tax

Download Excel File

Lecture 23: Income Tax Introduction

Extra Video 1 | Income Tax

Extra Video 2 | Income Tax

Income Tax Table

Lecture 24: Income Tax Annual Salary

HomeWork 12 Annual Income Calculation

Lecture 25 : Income Tax - Exemptions

Howework #13 | Calculation Sheet | Link

Lecture 26 : Perks and it's tax implications

[Extra Dose] Details about perks

Lecture 27 : Income Tax Deduction

Home Work #14

Example

Lecture 28 : Income Tax Slabs

Calculation Sheet

Lecture 29 : Surcharge , CESS

Calculation Sheet

Lecture 30 : Additional Income Tax

Lecture 31 : TDS

Download File

Lecture 32 : Full And Final Salary

Lecture 33 : Time Sheet

Time Sheet Sample

Lecture 34 : Processing : Introduction

Lecture 35 : Processing : Company data

Lecture 36 : Processing : Employee Data

Lecture 37 : Processing : Rules

Lecture 38: Payroll Processing Example 1

Calculation Sheet | Example

Lecture 39: Payroll Processing | Example April - June (Free Lesson and Resources)

Calculation Sheet | April - June

Lecture 40 : Payroll Processing Example July

Lecture 41 : Payroll Example August - March

HomeWork #15 | Calculation Sheet | Sample Data

Lecture 42 : Payroll Example Annual Bonus

Lecture 43 : Payroll Example Leave, Pt, LWF

Lecture 44 : Reconciliation

Lecture 45 : Reports

Lecture 46 : The Last Lecture

Offer Letter vs Employment Contract

FINAL ASSESSMENT TEST ( For Certification )

Live Q&A Sessions

Live Q&A with RJ : Sep 30, 2023

Live Session : Feb 2, 2024

Live Session : March 8, 2024

Preview - A to Z of Payroll Processing