A-CPS (Aster Certified Payroll Specialist)

Overview

Payroll processing is an essential function that involves arriving the ‘net pay’ of the employees after making the necessary deductions. This program provides profound insight on various earnings and deductions components and its eligibility and applicability with complete calculation. They receive extensive training and gain an in-depth knowledge in this field which will make you to do zero error payroll. This training course gives the participant the boost to widen their professional skills and expertise.

Payroll is one of the subjects which requires 100% accuracy, means ZERO ERROR, so knowing payroll partially or without enough practice or without practical exposure, will no way give any additional benefits to your career.

Benefits

• Growth, expansion and modernization
• Can maintain zero error payroll
• Productivity and profitability, reduces cost and finally enhances skill and knowledge
• Prevents obsolescence
• Helps in developing a problem-solving attitude
• Gives people awareness of rules and procedures

Who can Join?

• Fresh Graduates/Diploma with any specialization
• Working professionals who want to switch profession
• Anyone who wants to start their career in HR
• And anyone who is interested in Human Resource Management

Eligibility:

• Any Graduation / Post Graduation

Mode of Learning

• Online
• Off-line
• On the Job Training (OJT)

Course Details

• • Min 15 Days (Online or Offline)

• Classes will be there till you do payroll on your own

• Flexible Timing
• Weekdays / Weekend Classes
• Free Job Assistance
• Projects to practice
• Life time support after course completion
• OR 6 Months (OJT)

Course Content

Module 1:

Over View of Payroll Management

• Role of Payroll Department
• Compensation Structure
• Benefits, Claim & Reimbursement
• Attendance Management
• Different Pay Components
• Definition Earnings & Deductions
• Basic Impacts

Module 2:

Earnings & Deductions

• Eligibility & Calculation
• Depths insight of different earning components
• Depths insight of different deduction components
• Tax Exemptions and Sheet Maintenance
• Deeper understating about Income Tax and TDS
• Workouts

Module 3:

Payroll Processing and Reports

• Gathering Payroll Inputs
• Depth insight of Deductions (EPF, ESI, IT/ TDS, PT, LWF & Others)
• Depth insight on Tax Exemptions
• Depth insight on Benefits (Gratuity, Encashment, OT, Holiday Wages, Bonus Etc)
• F&F Preparation
• Salary Register & Payslip Preparation
• Other Reports Preparation
• Payroll Workout Session
• How to validate payroll sheet to ensure zero error

Module 4:

Statutory Compliance

• EPF & ESI Filing
• Profession Tax Filing
• Income Tax & TDS Filing
• Preparing FORM 24Q, FORM26Q, FORM16
• LWF Return Filing
• Complete walk through on PF & ESI Portal
• Complete walk-through TRACES
• Corresponding Sheet Preparation & Maintenance
• Different FORMs

Module 5:

ACTs

• Payment of Wages Act
• Payment of Bonus Act
• Payment of Maternity Act
• Payment of Gratuity Act
• EPF & ESI Act
• International Workers
• Workmen Compensation Act
• CLRA Act

Module 6:

Advance Excel

• Application/ Scenario based training for followings
  • Mail Merge with TOGGLE Fields
  • Pivot Table
  • VLOOKUP
  • Data Validation
  • Charts
  • FORMULAS (How to use multiple functions in same formula to achieve particular task)
• Providing deeper knowledge on FORMULAS
• How to write complex FORMULAS like multiple nested IF ELSE, combining multiple function in single formula
• Professional Sheet management using Buttons, Hyper Link & Objects
• Error Validation & Data Validation through formulas
• Taking complete control over excel sheet in order to avoid the manual error
• Detailed walk through on Main Menus with lot of examples
• Reverse engineering methods to work on certain existing files (From Non Excel Files)
• 50+ Formulas will be covered with detailed example