Hi,
I need a help in preparing excel files, I found a payroll sheet in your site. in that please make changes as I needed
1. "Attendance file FY 19-20" as month wise in file and "Salary sheet FY 19-20" as month wise file (both separate xls & subject line as specified in " ").
2. here I'm attaching whole one xls. with adding as i needed.
3. I have mentioned in CTC components as of Company policy, P.Tax as mentioned slots (Hyderabad), along with all statutory columns.
4. Over time should be shown per day wise also.
5. PF cutoff rate for 15000.
6. week off's are followed by Sundays (i.e; 5 sunday=5 WO or 4 sunday=4 WOin a month) in attendance sheet.
7. Approved Leaves are applicable 1 month and for 2 in a month (update separately according).
Kindly set it up every details as required for attendance, payroll,statutory(EE & ER) and expenses per month and year.
Please provide any contact number so i can contact as if I have doubt in attendance/salary file or call me on 9030787684 (Naveen) when available.
I need a help in preparing excel files, I found a payroll sheet in your site. in that please make changes as I needed
1. "Attendance file FY 19-20" as month wise in file and "Salary sheet FY 19-20" as month wise file (both separate xls & subject line as specified in " ").
2. here I'm attaching whole one xls. with adding as i needed.
3. I have mentioned in CTC components as of Company policy, P.Tax as mentioned slots (Hyderabad), along with all statutory columns.
4. Over time should be shown per day wise also.
5. PF cutoff rate for 15000.
6. week off's are followed by Sundays (i.e; 5 sunday=5 WO or 4 sunday=4 WOin a month) in attendance sheet.
7. Approved Leaves are applicable 1 month and for 2 in a month (update separately according).
Kindly set it up every details as required for attendance, payroll,statutory(EE & ER) and expenses per month and year.
Please provide any contact number so i can contact as if I have doubt in attendance/salary file or call me on 9030787684 (Naveen) when available.