Advanced Payroll Training

Payroll Training

Whether you are new to Payroll or a seasoned practitioner, a professional certification is your professional advantage.

EMPOWERING PEOPLE KNOWLEDGE offers payroll certifications across all the professionals to enhance their knowledge in accounting & payroll process. We give extensive training with our real time experience professionals. In today’s competitive business environment, the payroll professional’s role is becoming increasingly more complex.

Increasingly those working in HR and Payroll are playing strategic roles in taking the country’s leading companies and organizations forward within India’s buoyant economy and so in these exciting developmental times it is the perfect opportunity to take advantage of EMPOWERING PEOPLE KNOWLEDGE training and qualification opportunities.

It is vital that there is accuracy and timeliness in payroll production, ensuring not only the correct net pay to employees but computing accurate overheads to ensure accounting accuracy.

Payroll management has also direct linkage to the strict compliance of stringent provisions of large number of complex labor laws prevailing in India. Any non-compliance attracts severe penal consequences. To ensure accurate salary and rewards are paid on time, efficient payroll management is necessary. This will help lead to a satisfied workforce and avoidance of penalties for non-compliance

Course Module

  • 1. ESI ACT-1948 & PF ACT-1952
    a) ESI-Act, PF Bifurcation
    b) Eligibility
    c) Contributions From Both Employee & Employer
    d) ESI Filing (Monthly & Half Yearly), PF Filing ( Monthly & Yearly )
    e) ESI & PF Calculations
    f) Filling The Forms
    g) Benefits


    2. GRATUITY ACT-1972 & BONUS ACT-1965
    a) Coverage & Eligibility
    b) Calculations
    c) Tax Exemptions Limit

  • a) The pay structure
    b) Leave management (CL, EL, SL, PL )
    c) Basic, HRA, DA, Conveyance, Medical Allowance, etc
    d) ESI, PF , PT Calculations
    e) Calculation of Gross , Net salary & CTC
    f) Preparation of Break-up salary, Designing CTC and salary break up and discussion on Compensation and benefits.

  • a) PT- Slab Process
    b) INCOME TAX & TDS (Salaried People)
    c) Slab Process of IT & TDS
    d) Calculation of IT & TDS for Men, Women,Senior Citizens
    e) Education Cess
    f) Routine Tax Planning
    g) Tax Exemptions Under different Sections

    h) HRA Exemption Calculations

    i) Tax Calculation Report with Investments to save Income Tax

    J) Form 16 & ITR 1

  • a) PF report in Excel sheet
    b) ESI report in Excel sheet
    c) IF Condition
    d) MIS Reports in Excel sheet.
    e) Pivot Table
    f) Auto & Custom & Text filters
    g) V-Lookup, H-lookup
    h) Freeze panes
    i) And lots more to prepare MIS Reports.

EMPOWERING PEOPLE KNOWLEDGE LLP

    1. Payroll Process Theory
    2. Payroll Process Payslip Calculation
    3. LOP Calculations in Payslip
    4. Components in Payroll Process
    5. CTC Computation
    6. INCOME TAX Slabs
    7. INCOME TAX Calculations
    8. Investment Plans
    9. HRA Exemption Calculations
    10. Tax Calculation Report without Investments
    11. Tax Calculation Report with Investments to save Income Tax
    12. Form 16
    13. ITR Form 1
    • PF Bifurcation
    • PF Forms Filling
    1. PF Challan
    2. Form 2
    3. Form 5
    4. Form 10
    5. Form 19
    6. Form 10 C
    7. Form 13
    8. Form 20
    9. Form 10 D
    10. Form 5 IF
    11. Form 3A
    12. Form 6A
    13. Form 31
    • PT Forms Slabs & Form Filling
    1. Form 5A
    2. Form 5
    • ESI Slabs & Form Filling
      • Form 1
      • ESI Pehchan Card
      • Family ID Card
      • ESI Challan
      • Form 5
    • Payroll & MIS Practicals
    • Salary Register Format in Excel with the Formulas
    1. LOWER
    2. PROPER
    3. UPPER
    4. LEN
    5. AUTOFILTER
    6. CUSTOM AUTOFILTER
    7. TEXT FILTER
    8. CONDITIONAL FORMATTING
    9. TO REMOVE DUPLICATES
    10. CONCATENATE
    11. TRIM
    12. VLOOKUP
    13. HLOOKUP
    • Payroll & MIS Practicals
    • Salary Register Format in Excel with the Formula
    1. PIVOT TABLE
    2. FREEZE PANES
    3. PIVOT CHART
    4. MIS REPORTS
    5. PF STATEMENT
    6. IF CONDITION
    7. ROUND
    8. ALT SHORT CUT KEYS
    • Add on Benefits
    1. TDS Slabs and Calculations
    2. Labour Laws & Types of Leave
    3. Gratuity Calculation
    4. PF ONLINE
    5. ESI ONLINE
    6. Final Assesment on Payroll

 

Add on Benefits

 

Choose Your Direction

Advanced Payroll Training

Master Yourself into Payroll Department and Take your Career to new heights

Phone: +91 - 7975642525
email: info@empoweringpeople.in, salesenquiry@empoweringpeople.in
Empower, Bangalore, Karnataka, India