Need Help Organizing Payroll and Attendance Sheets for FY 2019-20 in Excel Format

Hi, I need help in preparing Excel files. I found a payroll sheet on your site and request changes to be made as follows:

1. "Attendance file FY 19-20" to be organized month-wise in a separate file, and "Salary sheet FY 19-20" to be structured month-wise in a separate file as well, both in xls format as specified.
2. I have attached a single xls file with additional requirements.
3. Ensure CTC components align with the company policy, P.Tax is as per Hyderabad slots, and include all statutory columns.
4. Overtime should be displayed on a daily basis.
5. PF cutoff rate should be set at 15000.
6. Week offs should be based on Sundays (e.g., 5 Sundays = 5 WOs or 4 Sundays = 4 WOs in a month) in the attendance sheet.
7. Approved leaves should be accounted for as 1 per month and 2 per month, update accordingly.

Kindly include all necessary details for attendance, payroll, statutory (EE & ER), and expenses per month and year.

Please provide a contact number for any clarifications on the attendance/salary file or call me at [Phone Number Removed For Privacy-Reasons] (Naveen) when available.

Location: Hyderabad, India

Tags: pms system, pms tool, company policy, salary sheet, attendance sheet, payroll sheet, Excel files, Country-India, City-India-Hyderabad

Dear Naveen,

To meet your requirements for the Payroll Sheet FY 2019-20 and Attendance Sheet FY 2019-20, follow these steps:

Payroll Sheet FY 2019-20
1. Organize the Salary sheet month-wise in a separate Excel file.
2. Ensure CTC components align with the Company policy.
3. Include P.Tax based on Hyderabad slots and all necessary statutory columns.
4. Display overtime details on a daily basis.
5. Set the PF cutoff rate at 15000.
6. Calculate week offs based on Sundays in the attendance sheet.
7. Account for approved Leaves as 1 per month and 2 per month accordingly.

Attendance Sheet FY 2019-20
1. Structure the Attendance file month-wise in a separate Excel file.
2. Include the required details for attendance, such as week offs based on Sundays.
3. Update approved Leaves as per your specifications.

For any assistance or queries, feel free to contact me at 9030787684.

Additional Resources:
For statutory information and guidelines related to payroll and attendance in India, refer to the Indian Labour Laws and Employee Provident Fund websites.

Ensure all data is accurately updated and follow the guidelines provided to create comprehensive and organized payroll and attendance sheets for the fiscal year 2019-20.

📊💡🤍