Course Details
TDS
- Preparing Salary sheet of employees taking into account different allowances and perquisites
- Tax Benefit in case of Deductions under Chapter VIA and Section 16 Deductions
- Making Salary Structure and CTC for maximum tax benefit
- Important forms/records to be maintained for handling Payroll
- E Filing TDS Return 24Q and Filing Challan 281
- Procedure for TDS Certificate Form 16 Part A and Part B
- Calculation of Tax in case of Leaves,New Joining and Leaving
PF/ESI
- Preparing PF and ESI Computation Sheet in Excel
- Preparing ECR Notepad for upload at PF Portal
- Preparing Monthly Contribution Sheet for ESI
- Relevant Formatilites on New Joining and Leaving in PF/ESI Act
ITR
- Preparing ITR Computation from Form 16
- Treatment of Different Other Incomes of Employee
- Preparation of ITR For Efiling for Employees in Different Cases
- E-Deposit of Challan 280 for tax payment
Advanced Excel
- Practical Assignments in Application of Advanced Excel formulas in different situations
- Basic Excel and Excel Shortcuts
- V-lookup and H-lookup
- Pivot tables, Goal Seek and Simple Macros
- If Command, Nested if Count if, Sum if etc