Excellent Payroll Solution In Single Sheet - ZIP Download

Hi friends,

Here is an excellent sheet which solves your big problem named "Payroll Solution" from a single worksheet. It includes all the information required for calculating salaries and leaves. Just go through the attached zip folder containing the Payroll sheet.

Hi, I would like to know how many leaves (CL, PL, SL, etc.) an employee can avail according to the Shops and Establishment Act?

Excellent file. Just one query.

In the Master Data Sheet, the ESI wages limit is mentioned as Rs. 10,000/-. However, the current wages limit has been increased from Rs. 10,000/- to Rs. 15,000/-. I have tried to edit it, but I couldn't do so due to protection. Therefore, I kindly request you to update the new wage limit in this file.

Dear Viral Shah,

I was very happy to see your attachment, but when I practically used your sheet, I found the following errors:

1. You have input the ESI limit up to 10,000, whereas now it is 15,000.
2. Some employers have paid PF up to 780 (capped at 6500 basic as per the limit) with high basic.
3. In the salary sheet, the employer's PF share is also deducted along with the employee's ESI and PF. The employer's share should not be deducted from the salary.

We are unable to make any changes or edit formulas as it is protected by a password. So, I humbly request you to please edit the formulas and reattach the sheet.

Thank you very much in advance on behalf of me and all CiteHR members who have already expressed their gratitude.

Email: kumaresic@rediffmail.com

Kind regards,
[Your Name]

CL stands for Casual Leave. It is given based on the company's norms and regulations. In a manufacturing organization, CL is provided as 9 days per year on a pro rata basis depending 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 the company's norms and regulations. In our manufacturing organization, SL is allocated as 8 days per year on a pro-rata basis depending on the number of days worked by an employee in the previous year. SL is carried forward if any days are unused for the next calendar year.

PL stands for Privilege leave. It is also known as EL (Earned Leave) in some companies. It is provided based on the company's norms and regulations. In a manufacturing organization, PL is granted as 30 days per year on a pro-rata basis depending on the number of days worked by an employee in the previous year. PL exceeding 90 days are encashed by the company. Any PL remaining at the end of the current year is carried forward to the next year.

CL and SL are granted to all employees as per the national and festival holiday act.

CL - 7

SL - 7

Most companies establish policies regarding leave, known as the Leave policy, which is outlined in the HR Manual.

In this policy, companies encash the remaining leave after the year-end to prevent an increase in absenteeism and avoid loss of production time for the company.

Some companies lapse both CL and SL after the year-end, while others only lapse the remaining CL but carry forward or encash the remaining SL.

Regarding PL, another name for it is Earned Leave (EL). PL is calculated based on the working days of an employee, where 20 working days equal 1 EL.

The formula for Calculated PL is: Total working days divided by 20 equals total PL or EL.

So, please clarify the policy in your organization regarding the Leave Policy. Thank you.

I have completed the task. Simply navigate to the "Save As" option and save it as a macro-enabled file. Save the file and then reopen it.

Hi,

Thanks for sharing the password. However, I tried several times and still can't get through. I would really appreciate it if you could please share how to do it. Thanks a ton in advance!

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 .

Hello Everyone,

Mr. Viral seems to be very busy and could not reply to you with the password. Please note down the password: "AABBAAAAAA{"

Sorry Viral, I messed it up. Let people enjoy your work. By the way, everybody appreciated your work; you should feel proud.

Thanks anyway,
Jonna
vasu_kal (Yahoo Messenger)

Hi,

The work that is contributed is really good. This will be very helpful in small companies but not in large-scale companies. I can say the strength of 250 and not more than that. Also, the payroll structure, from my experience, does not work for the whole group, but this can work in sub-groups. I would suggest that this Excel sheet can be broken into two parts - one for attendance calculation and the other for payroll. Here, you can set the salary structure into different cadres or levels or designations. This way, it will be more helpful to many.

During my experience as a consultant, I have applied the same concept which was successful. However, nowadays, many companies are using attendance and payroll software. Excel working is followed for auditing purposes.

Thanks,
Krishna Kumar Pandey

Dear All,

We had the same sheet here with many other people sharing it, but no one provided the password for it. The password to open the main sheet is "AAABBAAAAAA," and to open all other sheets, the password is "AAA."