Hi Friends,
Here is an excellent sheet which solves your big problem named "Payroll Solution" from a single work sheet.
It includes all the stuff required for calculating salary and leaves.
Just go through the attached zip folder containing Payroll sheet.
From India, Pune
74Here is an excellent sheet which solves your big problem named "Payroll Solution" from a single work sheet.
It includes all the stuff required for calculating salary and leaves.
Just go through the attached zip folder containing Payroll sheet.
From India, Pune
Hi, i would like to know how many leaves(cl,pl,sl etc...) an employee can avail according to shops and establishment act?
From India, Delhi
From India, Delhi
Excellent File..
Just One query. In Master Data Sheet ESI wages limit mention as Rs. 10,000/-.
but current wages limit increase from 10,000/- to Rs. 15,000/-
I have try to edit it but it doesn't due to protection.
so request you to kindly update new wage limit in this file.
From India, Mumbai
Just One query. In Master Data Sheet ESI wages limit mention as Rs. 10,000/-.
but current wages limit increase from 10,000/- to Rs. 15,000/-
I have try to edit it but it doesn't due to protection.
so request you to kindly update new wage limit in this file.
From India, Mumbai
dear viral shah,
very happy to see your attachment,but when practcally i use your sheet i found their following error:-
1- you feed ESI limit up to 10,000 now it is 15,000
2- Some employer PF paid up to 780 (bound at 6500basic as per limit) having
basic high.
3- In salary sheet PF employer share also deduct with employee's esi and PF.
employer's share not deduct from salary.
we can not any changes or edit formulas because it is protect by password.
so humbly requested pls edit in formulas and re ATTCH.
thank you very much in advance behalf me or all citeHR members who already said you thanks.
From India, Calcutta
very happy to see your attachment,but when practcally i use your sheet i found their following error:-
1- you feed ESI limit up to 10,000 now it is 15,000
2- Some employer PF paid up to 780 (bound at 6500basic as per limit) having
basic high.
3- In salary sheet PF employer share also deduct with employee's esi and PF.
employer's share not deduct from salary.
we can not any changes or edit formulas because it is protect by password.
so humbly requested pls edit in formulas and re ATTCH.
thank you very much in advance behalf me or all citeHR members who already said you thanks.
From India, Calcutta
CL stands for Casual Leave. It is given based on company's norms and regulations....In manufacturing organization, CL is given as 9 for a year on pro Data basis based on the number of days worked by an employee in the previous year...CL lapses at the end of every calendar year.
SL stands for Sick Leave. It is given based on company's norms and regulations....In our manufacturing organization, SL is given as 8 for a year on pro data basis based on the number of days worked by an employee in the previous year...SL is carried forward in case there are any left for the next calendar year...
PL stands for Privilege leave. It is also called as EL (Earned Leave) in some companies. It is given based on company's norms and regulations....In manufacturing organization, PL is given as 30 for a year on pro data basis based on the number of days worked by an employee in the previous year...PL more than 90 days are encased in company. PL if left in the current year are carried forward to the next next year....
CL and SL are given to all employee as per national and festival holiday act.
CL - 7
SL-7.
Most of the companies make policy regarding Leave .....Dats called Leave policy and mentioned in HR Manual.
in dis policy, companies encase the balance leave after the year end ,so that number of absenteeism never increase and company never bear the Loss of production time.
Some companies Lapses both the CL and SL after the year end.....and some companies Lapses only Balance CL but they carry forwarded SL or encase that SL.
and about pl.......PL another name is Earned Leave (EL)
this PL calculated on the working days of employee,,,,,20 working days = 1 EL.
The formula for Calculated PL :- Total working days/20=total PL or EL....
so please firstly clear,,,,,,,whats d policy in ur organization regarding Leave Policy
thanks
From India, Delhi
SL stands for Sick Leave. It is given based on company's norms and regulations....In our manufacturing organization, SL is given as 8 for a year on pro data basis based on the number of days worked by an employee in the previous year...SL is carried forward in case there are any left for the next calendar year...
PL stands for Privilege leave. It is also called as EL (Earned Leave) in some companies. It is given based on company's norms and regulations....In manufacturing organization, PL is given as 30 for a year on pro data basis based on the number of days worked by an employee in the previous year...PL more than 90 days are encased in company. PL if left in the current year are carried forward to the next next year....
CL and SL are given to all employee as per national and festival holiday act.
CL - 7
SL-7.
Most of the companies make policy regarding Leave .....Dats called Leave policy and mentioned in HR Manual.
in dis policy, companies encase the balance leave after the year end ,so that number of absenteeism never increase and company never bear the Loss of production time.
Some companies Lapses both the CL and SL after the year end.....and some companies Lapses only Balance CL but they carry forwarded SL or encase that SL.
and about pl.......PL another name is Earned Leave (EL)
this PL calculated on the working days of employee,,,,,20 working days = 1 EL.
The formula for Calculated PL :- Total working days/20=total PL or EL....
so please firstly clear,,,,,,,whats d policy in ur organization regarding Leave Policy
thanks
From India, Delhi
i done it, just go to in save as option and save it as macro enable option ,save it and then reopen it.
From India, Chandigarh
From India, Chandigarh
Hi, Thanks for sharing the password, however i tried several times, still cant get through. I really appreciate if you could please share how to do it....Thanks a ton in advance!
From Philippines
From Philippines
Hello sir ,
I am Smruti working in a company ,currently I am using your single pay roll solution . And I have some doubt .
1-I want to change holiday list because our company have one day work from home(WFH) in a month . So, How could I change ?
2-Currently in our company 8 people are working so we can’t take PF ,ESIC and other .? what should I write in the given box ?
3- And another thing if we take printout of salary slip in interview ,is it acceptable ?
4- If I show this work in my c.v is it acceptable ?.
Kindly guide me .
From India
I am Smruti working in a company ,currently I am using your single pay roll solution . And I have some doubt .
1-I want to change holiday list because our company have one day work from home(WFH) in a month . So, How could I change ?
2-Currently in our company 8 people are working so we can’t take PF ,ESIC and other .? what should I write in the given box ?
3- And another thing if we take printout of salary slip in interview ,is it acceptable ?
4- If I show this work in my c.v is it acceptable ?.
Kindly guide me .
From India
Hello Everyone,
Mr.Viral seems to be very busy and couldnot reply you back with the password.
Please not down the password.
It is "AABBAAAAAA{"
Sorry Viral i breaked it. Let people enjoy your work. BTW everybody appriciated your work you should feel proud.
Thanks anyway,
Jonna
vasu_kal {yahoo messenger}
From India, Hyderabad
Mr.Viral seems to be very busy and couldnot reply you back with the password.
Please not down the password.
It is "AABBAAAAAA{"
Sorry Viral i breaked it. Let people enjoy your work. BTW everybody appriciated your work you should feel proud.
Thanks anyway,
Jonna
vasu_kal {yahoo messenger}
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.
Payroll Solution in single Sheet.xls
Excellent Solution to Problem.jpg