Indian Payroll Video 5
Enter 5 dummy employees with CTC, allowances, and perks.Calculate gross salary, taxable income, TDS, and net pay.Generate a sample payroll register.
Task
Design a salary breakup for a ₹10 LPA CTC, including allowances: HRA, DA, LTA, Medical, Conveyance.
Task
For an employee earning ₹30,000 Basic, paying ₹15,000 rent in Bangalore, calculate HRA exemption.
Task
Calculate the basic salary for a CTC of ₹6,00,000 per annum
Task
Prepare a Factories Act compliance checklist with 10 key requirements (health, safety, welfare, registers). Task 2 – Audit Simulation Choose one HR law (e.g., Payment of Wages, PF, or Maternity Benefit). Conduct a mini-audit: check compliance points, identify gaps, and propose corrections.
Task
Import a dataset of 30 employees (dummy HR data – Name, Department, DOJ, Salary, Attrition status).Create a Power BI dashboard with visuals showing:Attrition by department,Gender diversity,Average salary by role.Add at least two slicers (e.g., by Department, by Gender)
Task
Build an Excel dashboard for 20 employees, showing:Recruitment source mix,Offer-to-join ratio,Attrition rate,Average training hours.Use at least one formula (COUNTIF/AVERAGEIF) and one chart
Task
Task 1 – Audit Checklist Creation
Task
Task 1: Create a table comparing 401(k), HSA, FSA, HRA – eligibility, contribution limits, tax benefits. Task 2: Research reciprocity rules between New Jersey and Pennsylvania – explain how payroll is handled if an employee lives in NJ but works in PA. Task 3: In 150 words, explain why fringe benefits are important for both […]
Task
Task 1: Calculate federal withholding tax for an employee earning $2,500 biweekly using the IRS wage bracket system. Task 2: Prepare a mock W-2 form with sample data (name, SSN, wages, tax withheld). Task 3: Write 150 words explaining the difference between FICA vs FUTA.