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

Attached Files (Download Requires Membership)
File Type: zip PAYROLL SOLUTION IN SINGLE SHEET.zip (1.62 MB, 13158 views)

Preparation for the global SHRM certification exams: SHRM CP and SHRM SCP →
Promoted: XLRI Executive Development Program In Human Resource Management
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
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
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
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


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


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
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
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
Hello Everyone,
Mr.Viral seems to be very busy and couldnot reply you back with the password.
Please not down the password.
Sorry Viral i breaked it. Let people enjoy your work. BTW everybody appriciated your work you should feel proud.
Thanks anyway,
vasu_kal {yahoo messenger}

From India, Hyderabad
I’ve already posted the password in the recent post. once again try the below one. Password: AABBAAAAAA{
From India, Hyderabad

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server