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
From India, Hyderabad
Acknowledge(0)
Amend(0)
1I 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
From India, Hyderabad
Acknowledge(0)Amend(0)
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.
From India, Gurugram
Acknowledge(0)Amend(0)
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.
From India, Gurugram
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.