Need Help Creating Attendance and Payroll Sheets for FY 2019-20 with CTC and Statutory Details for Hyderabad

Hi, I need help in preparing the Attendance and Payroll sheets for the fiscal year 2019-20. I require separate XLS files for the "Attendance file FY 19-20" and "Salary sheet FY 19-20" with specific keys for the attendance sheet as mentioned.

I will update the CTC components based on the company policy, including Basic, HRA, Conveyance, and other allowances. Additionally, I need P.Tax slots for Hyderabad (up to 15000=0, 15001 to 20000=150, above 20000), along with all statutory calculations and PF ceiling amount set at 15000.

Please provide the CTC structure and monthly/yearly Payroll sheets.

Location: Hyderabad, India

Due to the complexity of your request involving CTC structure, payroll sheets, attendance tracking, and statutory calculations, it's essential to follow a systematic approach to ensure accuracy and compliance.

CTC Structure and Payroll Sheet Preparation Guide

1. CTC Components Setup:
- Define the CTC components as per the company policy: Basic, HRA, Conveyance, and other allowances.
- Determine the P.Tax slots for Hyderabad: up to 15000=0, 15001 to 20000=150, above 20000.
- Set the PF ceiling amount at 15000 for accurate calculations.

2. Attendance Sheet Creation:
- Use the specified keys for tracking attendance: P (Present), WO (Week Off), HDP (Half-day Present), LC (Late Coming), H (Holiday), HW (Holiday Work), A (Absent), CO (Comp Off), AL (Approved Leave), NJ (New Join), OJT (On Job Training), TRN (Transfer), LEFT (Left/Abscond), RSN (Resign).
- Update the attendance sheet monthly with the respective codes based on employee records.

3. Payroll Sheet Setup:
- Segregate the payroll sheet month-wise and year-wise for easy tracking and calculations.
- Include columns for Basic, HRA, Conveyance, other allowances, P.Tax deductions, PF contributions, and net pay.
- Calculate statutory deductions accurately based on the provided P.Tax slots and PF ceiling amount.

4. Statutory Calculations:
- Ensure compliance with labor laws and tax regulations applicable in Hyderabad, India.
- Cross-verify all calculations for accuracy, including P.Tax, PF contributions, and other statutory deductions.

5. Monthly and Yearly Review:
- Review the monthly payroll sheets for discrepancies and ensure all components align with the CTC structure.
- Consolidate the yearly payroll data for reporting and auditing purposes.

By following this guide meticulously, you can efficiently prepare the Attendance and Payroll sheets for FY 2019-20, incorporating the CTC structure and statutory calculations as per your requirements.