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.
From India, Hyderabad
1I 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.
From India, Hyderabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Attendance sheet.xls