120 likes | 372 Views
SLA Consultants India provides Payroll Processing Software Training Course, compensation & benefits, Advanced payroll training, HR and Payroll Training Courses, human resource training courses, hr training noida, salary calculator india excel, HR Payroll Certification Courses, salary slip format,PF , ESIC , Online filing form returns, hr workshop, professional tax slab calculation, provident fund registration, hr and payroll training courses in delhi NCR
E N D
Payroll Certification Courses Contact us: SLA Consultants India 9873140018 , 9069663742 www.slaconsultantsindia.com https://www.facebook.com/SLAConsultantsindiaindia/
HR Payroll Training • Module 1 - Statutory & Legal Compliance • EPF & MP Act, 1952 • Objectives • Applicability • Eligibility • Rate of Contribution / Share • Registration / Coverage • Registers & Records • Various Returns • Various Forms • Pension Eligibility & Calculation • EDLI Calculation & Limit • Online Activities http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
ESI Act, -1948 • Objectives • Applicability • Eligibility • Rate of Contribution / Share • Registration / Coverage • Registers & Records • Various Returns • Various Forms • ESI Benefits • Contribution Period & Benefit Period • Online Activities www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
Payment of Bonus Act, 1965 • Objectives • Applicability • Eligibility • Calculation of Minimum Bonus • Calculation of Maximum Bonus • Registers & Records • Return • Displays www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
Payment of Gratuity Act, 1972 • Objectives • Applicability • Eligibility • Calculation of Gratuity • Maximum Gratuity & Taxability • Group Gratuity Policy • Various Forms • Display www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
Compensation And Benefits • Payroll Processing • The Pay Structure • Basic, HRA, DA, Conveyance, Medical allowance, LTA, Lunch Allowance etc. • Salary Break up and Designing CTC. • Calculation of Gross , Net Salary & CTC • Calculation of Overtime & Leave Encashment. • Discussion on Compensation and Benefits. • Attendance & Leave Management (CL, EL, SL, and ML) • Preparation of Salary Sheet, Pay Slip, Full n Final Settlement. • Live Payroll Software Training (New Topic Added) www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
TAX PLANNING FOR SALARIED EMP • LWF Slab Rate • PT Slab Rate • Income Tax Slab Rate • Tax Exemptions of various allowances. • Tax Deduction under chapter VI-A • (80C, 80D, 80E, 80G, etc.) • Rebate U/S 87A • Education Cess • Routine Tax Planning (Investment Declaration Form) • TDS Certificate (Form 16) www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
MS Excel- Lab Session • Objective: • Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
Topics Covered • Introduction, Basic Understanding , Sum, Count, Count, Count blank, Average, Max, Large Min, Abs, Sumif, Count if, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal, And, Or, Day, Year, EOmonth, Edate, Net workdays, Today, Weekday, Week number, Workday, Find, Search. • V-lookup, H-lookup, Day and Time Calculation, Numeric Calculation, If Logical Condition, Dynamic Pivot, Dynamic Chart, Conditional Formatting, Dated if, What If Analysis, Match Index, Offset Function, User form Function in Excel, Data Validation, Advance Filter, Sorting, Group & Ungroup, Data split, Text Function (Data Separation), Substitute • PF Report in Excel sheet • ESI Report in Excel sheet • Professional Report Tax www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx
Thank You www.slaconsultantsindia.com http://www.slaconsultantsindia.com/HR-Salary-Payroll-Processing-Training.aspx