Hi All, I have formulated Salary Structure Calculator for the use of our members in HR and Finance. Appreciate your comments/suggestions to make more effective and useful. Best Regards, Dada
From India, Bangalore
Acknowledge(0)
Amend(0)
20From India, Bangalore
Acknowledge(0)Amend(0)
Dear Dada,
In your Excel sheet, with example figures, the PF contribution amount of the employer seems incorrect. The basic pay is Rs 20,667, and the PF contribution, which should be 12% (Rs 2480), is showing as Rs 780. Please advise.
Thanks,
Raghuvir
From India, Madras
Acknowledge(0)Amend(0)
In your Excel sheet, with example figures, the PF contribution amount of the employer seems incorrect. The basic pay is Rs 20,667, and the PF contribution, which should be 12% (Rs 2480), is showing as Rs 780. Please advise.
Thanks,
Raghuvir
From India, Madras
Acknowledge(0)Amend(0)
Raghuvir,
As per the rule, the employer needs to pay only up to 12% of Rs 6,500 if the basic pay is above Rs 6,500. Additionally, the employee has two options:
1. Pay 12% of the basic pay or just 12% of Rs 6,500 if their basic pay falls above Rs 6,500.
2. Make voluntary contributions too. However, the employer only needs to adhere up to the ceiling specified as per the PF Act, i.e., Rs 6,500.
Let me know if this is not correct. Thank you.
Thanks,
Bindu
From India, Bangalore
Acknowledge(0)Amend(0)
As per the rule, the employer needs to pay only up to 12% of Rs 6,500 if the basic pay is above Rs 6,500. Additionally, the employee has two options:
1. Pay 12% of the basic pay or just 12% of Rs 6,500 if their basic pay falls above Rs 6,500.
2. Make voluntary contributions too. However, the employer only needs to adhere up to the ceiling specified as per the PF Act, i.e., Rs 6,500.
Let me know if this is not correct. Thank you.
Thanks,
Bindu
From India, Bangalore
Acknowledge(0)Amend(0)
Good work! Although you can improve it further by adding more allowances, the name of the employee, other details along with the company name to make it more presentable and professional.
To Bindu:
PF deduction issue: The rule is that whatever the Basic + DA of the existing employee (for PF contribution purposes), the employer has to pay 12% along with the employee's share of 12% with other admin expenses.
The second point is that the employer will contribute 8.33% to the pension fund up to Rs. 541/-, and the rest of the money will be diverted to the employees' provident fund.
Hence, whether the employee earned basic + DA up to Rs. 6,500 or Rs. 10,000/-, the employer has to pay 12% plus admin charges (0.5% and 1.1%).
I hope I made it all clear.
Manish Gupta
From India, Mumbai
Acknowledge(0)Amend(0)
To Bindu:
PF deduction issue: The rule is that whatever the Basic + DA of the existing employee (for PF contribution purposes), the employer has to pay 12% along with the employee's share of 12% with other admin expenses.
The second point is that the employer will contribute 8.33% to the pension fund up to Rs. 541/-, and the rest of the money will be diverted to the employees' provident fund.
Hence, whether the employee earned basic + DA up to Rs. 6,500 or Rs. 10,000/-, the employer has to pay 12% plus admin charges (0.5% and 1.1%).
I hope I made it all clear.
Manish Gupta
From India, Mumbai
Acknowledge(0)Amend(0)
Thanks, Manish,
Since the very purpose of this tool is to arrive at CTC breakup, the total contribution of 12% by the employer is considered irrespective of the fact that the said proportion will be apportioned among EPF, Pension Fund + Administrative Charges (additional).
Best,
Dada
From India, Bangalore
Acknowledge(0)Amend(0)
Since the very purpose of this tool is to arrive at CTC breakup, the total contribution of 12% by the employer is considered irrespective of the fact that the said proportion will be apportioned among EPF, Pension Fund + Administrative Charges (additional).
Best,
Dada
From India, Bangalore
Acknowledge(0)Amend(0)
Good Morning Dada,
It's a good calculator. However, I need to make the following comments:
1) LTA is part of CTC.
2) HRA can be 40% or 50% of Basic due to the tax-free facility.
3) Car Lease option is not common to all employees, except for senior-level recruitment.
The rest seems to be okay.
Thank you,
CVH
From India, Mumbai
Acknowledge(0)Amend(0)
It's a good calculator. However, I need to make the following comments:
1) LTA is part of CTC.
2) HRA can be 40% or 50% of Basic due to the tax-free facility.
3) Car Lease option is not common to all employees, except for senior-level recruitment.
The rest seems to be okay.
Thank you,
CVH
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Dada,
Good morning. This is really excellent work that you have done. Keep it up. I request you to please send the password to me. My email address is k_sureshsv@yahoo.com and my phone number is +91 9880768898.
Thank you,
Suresh K.
Bangalore
+91 9880768898
From India, Bangalore
Acknowledge(0)Amend(0)
Good morning. This is really excellent work that you have done. Keep it up. I request you to please send the password to me. My email address is k_sureshsv@yahoo.com and my phone number is +91 9880768898.
Thank you,
Suresh K.
Bangalore
+91 9880768898
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Raghu,
As far as PF is concerned, you have the option to contribute on actual basic pay or on the maximum ceiling of Rs 6500. It depends on the company which one to choose because there are costs involved as the employer has to bear admin, inspection, and PF charges.
Sanjeev
From India
Acknowledge(0)Amend(0)
As far as PF is concerned, you have the option to contribute on actual basic pay or on the maximum ceiling of Rs 6500. It depends on the company which one to choose because there are costs involved as the employer has to bear admin, inspection, and PF charges.
Sanjeev
From India
Acknowledge(0)Amend(0)
Dear Mr. Parmar,
Thank you so much for sharing very valuable information with all of us. You did a fabulous job in preparing data on Excel. If you could share the advanced level Excel formulas with me, please email me at ashwinik009@gmail.com.
With Regards,
Ashwini Kadam
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you so much for sharing very valuable information with all of us. You did a fabulous job in preparing data on Excel. If you could share the advanced level Excel formulas with me, please email me at ashwinik009@gmail.com.
With Regards,
Ashwini Kadam
From India, Mumbai
Acknowledge(0)Amend(0)
Thanks to share this format, its really very useful to me. can you please tell us the protected sheet password so that I can change it accordingly. Thanks & Regards Amit Shekhar Jha
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Hi all,
Everyone says that it is very nice steps. May I know how it is good and useful to all? If you calculate the amount on 14500 pm - Employee Contribution 1.75% = Rs. 254 and Employers @ 4.75% = Rs. 689, the total amount will be Rs. 943. Every month it means 943 * 12 = Rs. 11316 per annum.
If you see from the point of view of facility, ESIC does not provide good service for the same. For example, if you go for any treatment, you will wait for 1 to 2 hours, and then they will forward you to another doctor or department. After that, you will go to the dispensary to take your medicine, which will take 1 to 2 hours in the queue.
One question to all of you: How many employees take benefits from ESIC?
In my view, only 25%. I was covered by ESIC for around 2 years but did not go for any treatment during that period.
If you invest such an amount in Mediclaim, you can get more and better facilities compared to ESIC. You will only invest around Rs. 3000 per annum.
I am not a client of any Mediclaim company but an employee of a private limited company as an HR Executive.
In my view, it is not good for us. What are your views? Please reply to us.
From India, New Delhi
Acknowledge(0)Amend(0)
Everyone says that it is very nice steps. May I know how it is good and useful to all? If you calculate the amount on 14500 pm - Employee Contribution 1.75% = Rs. 254 and Employers @ 4.75% = Rs. 689, the total amount will be Rs. 943. Every month it means 943 * 12 = Rs. 11316 per annum.
If you see from the point of view of facility, ESIC does not provide good service for the same. For example, if you go for any treatment, you will wait for 1 to 2 hours, and then they will forward you to another doctor or department. After that, you will go to the dispensary to take your medicine, which will take 1 to 2 hours in the queue.
One question to all of you: How many employees take benefits from ESIC?
In my view, only 25%. I was covered by ESIC for around 2 years but did not go for any treatment during that period.
If you invest such an amount in Mediclaim, you can get more and better facilities compared to ESIC. You will only invest around Rs. 3000 per annum.
I am not a client of any Mediclaim company but an employee of a private limited company as an HR Executive.
In my view, it is not good for us. What are your views? Please reply to us.
From India, New Delhi
Acknowledge(0)Amend(0)
Mr. Jagnesh,
Thank you for sharing the salary sheet. It is really helpful for us. However, I am unable to work on it because the sheet is protected and requires a password to be unprotected. Could you please advise the password?
Thanks,
Ravi
From India, Delhi
Acknowledge(0)Amend(0)
Thank you for sharing the salary sheet. It is really helpful for us. However, I am unable to work on it because the sheet is protected and requires a password to be unprotected. Could you please advise the password?
Thanks,
Ravi
From India, Delhi
Acknowledge(0)Amend(0)
Dear all,
Thank you for your compliments.
First of all, let me clarify one thing: I am not a professional Advanced Excel programmer. I am an amateur creator of Advanced Excel. Basically, I am a B.E. (Electrical Engineering) graduate working with R.P.G. Groups. I created all the Excel sheets in my leisure time to streamline our routine job work.
All my programs are user-friendly. You can put your company name/logo on any sheet, and there is no indication of its creator on any sheet (except the Main sheet), and all sheets are free. Upon closer inspection, you will find that I have not provided any password for formulas. You can view all logic in the taskbar. Additionally, all data entry cells have no password.
I have protected the sheets with a password for two reasons:
1. To optimize the performance of Excel, there are logic formulas that should remain hidden; otherwise, unauthorized entries in columns will disrupt the logic of the programs and may lead to incorrect results.
2. There are links from cells to other cells or sheets. To safeguard these links, we should not add or delete rows or columns in any sheet. If someone adds a new row or column, there is a risk of damaging the logic formulas (as the user might not know where I have placed logical formulas), which is why I have protected the sheets to prevent unauthorized additions or deletions.
3. For instance, if I have declared the file name "XYZ" for cells A1:A200, and someone adds a new row or copies and pastes the previous row, the logic may not function as expected because I have only declared cells 1 to 200 in my logic. Therefore, the program may not work correctly or may give incorrect values.
4. You cannot copy, paste, add, or delete new rows/columns due to the presence of formulas.
If a sheet is not password-protected and someone accidentally enters data in a logic cell or deletes a formula, it can be challenging to identify the error. Hence, I have implemented password protection to prevent unwanted entries in formula cells.
Unlike most professional creators who use passwords and offer demo versions to users, my programs are all full versions. The sole reason for the password protection is to avoid the issues mentioned above, not to charge or monopolize.
I have received some emails regarding the need for round figures in the programs. Some users require data in rounded figures, so I have made the necessary corrections and re-uploaded them on my website. If anyone needs such adjustments, please download them from the site.
I hope this provides a clearer explanation regarding the password. Additionally, for those looking to enhance their Excel skills, I have uploaded 200 books/materials for Excel programming, macros, and VBA on the aforementioned site, all available for free.
Thank you.
From India, New Delhi
Acknowledge(0)Amend(0)
Thank you for your compliments.
First of all, let me clarify one thing: I am not a professional Advanced Excel programmer. I am an amateur creator of Advanced Excel. Basically, I am a B.E. (Electrical Engineering) graduate working with R.P.G. Groups. I created all the Excel sheets in my leisure time to streamline our routine job work.
All my programs are user-friendly. You can put your company name/logo on any sheet, and there is no indication of its creator on any sheet (except the Main sheet), and all sheets are free. Upon closer inspection, you will find that I have not provided any password for formulas. You can view all logic in the taskbar. Additionally, all data entry cells have no password.
I have protected the sheets with a password for two reasons:
1. To optimize the performance of Excel, there are logic formulas that should remain hidden; otherwise, unauthorized entries in columns will disrupt the logic of the programs and may lead to incorrect results.
2. There are links from cells to other cells or sheets. To safeguard these links, we should not add or delete rows or columns in any sheet. If someone adds a new row or column, there is a risk of damaging the logic formulas (as the user might not know where I have placed logical formulas), which is why I have protected the sheets to prevent unauthorized additions or deletions.
3. For instance, if I have declared the file name "XYZ" for cells A1:A200, and someone adds a new row or copies and pastes the previous row, the logic may not function as expected because I have only declared cells 1 to 200 in my logic. Therefore, the program may not work correctly or may give incorrect values.
4. You cannot copy, paste, add, or delete new rows/columns due to the presence of formulas.
If a sheet is not password-protected and someone accidentally enters data in a logic cell or deletes a formula, it can be challenging to identify the error. Hence, I have implemented password protection to prevent unwanted entries in formula cells.
Unlike most professional creators who use passwords and offer demo versions to users, my programs are all full versions. The sole reason for the password protection is to avoid the issues mentioned above, not to charge or monopolize.
I have received some emails regarding the need for round figures in the programs. Some users require data in rounded figures, so I have made the necessary corrections and re-uploaded them on my website. If anyone needs such adjustments, please download them from the site.
I hope this provides a clearer explanation regarding the password. Additionally, for those looking to enhance their Excel skills, I have uploaded 200 books/materials for Excel programming, macros, and VBA on the aforementioned site, all available for free.
Thank you.
From India, New Delhi
Acknowledge(0)Amend(0)
Hi,
Thank you; that is really useful. Could you also please provide details on the taxable and non-taxable parts of the salary structure? I need to create a salary breakup for a senior position level and would like to present it in a way that maximizes tax benefits.
Please advise.
Ruby
From India, Delhi
Acknowledge(0)Amend(0)
Thank you; that is really useful. Could you also please provide details on the taxable and non-taxable parts of the salary structure? I need to create a salary breakup for a senior position level and would like to present it in a way that maximizes tax benefits.
Please advise.
Ruby
From India, Delhi
Acknowledge(0)Amend(0)
Mr.jigu u have protected your sheet,if i have to use this then how i ll unprotect it,i dont know the password,,,,,,,pls reply
From India, Nagpur
Acknowledge(0)Amend(0)
From India, Nagpur
Acknowledge(0)Amend(0)
Please find the revised program. In this, you will change or delete categories of the Salary Structure as per your requirements. You can also hide or format data as per your requirements. This program is more user-friendly compared to the previous one.
@premierindia
Request to read all instructions/directions given in the program - "May I Help You Sheet". This will guide you on how to enter data in the program.
From India, New Delhi
Acknowledge(0)Amend(0)
@premierindia
Request to read all instructions/directions given in the program - "May I Help You Sheet". This will guide you on how to enter data in the program.
From India, New Delhi
Acknowledge(0)Amend(0)
Hello Sanjeev,
Can you please advise if the employer's contribution towards PF is 12% of basic + DA or 12% of basic only? In other words, if the basic pay is Rs 4000 and DA is Rs 3000, does the employer need to contribute 12% of Rs 4000 or 12% of the Rs 6500 ceiling considering basic + DA?
Thanks,
Raghuvir
From India, Madras
Acknowledge(0)Amend(0)
Can you please advise if the employer's contribution towards PF is 12% of basic + DA or 12% of basic only? In other words, if the basic pay is Rs 4000 and DA is Rs 3000, does the employer need to contribute 12% of Rs 4000 or 12% of the Rs 6500 ceiling considering basic + DA?
Thanks,
Raghuvir
From India, Madras
Acknowledge(0)Amend(0)
hello CVH, Can you pls confirm again that HRA is tax free and does not fall under income tax, is there a ceiling in Rs or % of basic for HRA . thanks raghuvir
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Request to ignore my previous program posted on today and find attached new one..
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
New sheet with necessary amendment (Search Salary slip either by employee name or employee code)
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
I hav a question for seniors I work in a BPO in a UK payroll process will that knowledge help me in any way in the Indian payroll system ????
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hello Sir, The salary structure calculator is excellent.............. This one is extremely useful for the fresher like me. Swapnaja.
From India, Aurangabad
Acknowledge(0)Amend(0)
From India, Aurangabad
Acknowledge(0)Amend(0)
Hi Parmar! Thanx fo nice posting but the attachment is protected . So that how we can make use of this Salary Mater if it is read only... Regards, Pushpendra
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
For editing of the data, there is no need for any password as the editing area is not protected. Please read the instructions given with the program.
Path:
Main Program - "May I help you sheet" - Read all instructions.
Make necessary changes in the white background cells.
From India, New Delhi
Acknowledge(0)Amend(0)
Path:
Main Program - "May I help you sheet" - Read all instructions.
Make necessary changes in the white background cells.
From India, New Delhi
Acknowledge(0)Amend(0)
Dear DADA really it is a amazing one, but i cannot edit it shows protected, need your help here please provide PW
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Please Let me Know ,In which sheet You can’r enter your data(Please give me sheet no and cell no). Please follow instruction given in program.
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Mention your custom requirements and get an Excel file developed for free at [Opex Solution - Excel Solutioning for Free](http://www.opexsolution.com).
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hi,
Please unlock the area to enter the company name and address in Sheet 5.
Regards,
From India, Vijayawada
Acknowledge(0)Amend(0)
Please unlock the area to enter the company name and address in Sheet 5.
Regards,
From India, Vijayawada
Acknowledge(0)Amend(0)
Hi,
Moreover, when Jignesh is providing us with the best service, let us request him for our requirements. He will help us out.
Regards,
Chakri
From India, Vijayawada
Acknowledge(0)Amend(0)
Moreover, when Jignesh is providing us with the best service, let us request him for our requirements. He will help us out.
Regards,
Chakri
From India, Vijayawada
Acknowledge(0)Amend(0)
Dear Dschakri,
Thank you for pointing out such types of bugs. Please find the rectified program herewith. Don't hesitate to point out such types of bugs in the program if you find any in the future.
Thanks again...
From India, New Delhi
Acknowledge(0)Amend(0)
Thank you for pointing out such types of bugs. Please find the rectified program herewith. Don't hesitate to point out such types of bugs in the program if you find any in the future.
Thanks again...
From India, New Delhi
Acknowledge(0)Amend(0)
Dear Jignesh N. Parmer,
Can you please clear my doubt about the basic minimum wages? Some factories are fixing the basic wages lower than the government-fixed minimum wage, but the total salary of the worker is more than what the government fixed. In garment industries in C zone, the helper's salary is Rs. 1825/- plus DA 741, totaling Rs. 2566. However, the factories fixed the basic as 1200 + DA 741 + HRA 700, totaling Rs. 2641. Why are they doing this practice to reduce their PF contribution? Is this correct, or should they take the government minimum as Basic, i.e., 1825 + DA for PF contribution?
Please clarify.
Thanks,
Best Regards,
Subiah G.
From India, Madras
Acknowledge(0)Amend(0)
Can you please clear my doubt about the basic minimum wages? Some factories are fixing the basic wages lower than the government-fixed minimum wage, but the total salary of the worker is more than what the government fixed. In garment industries in C zone, the helper's salary is Rs. 1825/- plus DA 741, totaling Rs. 2566. However, the factories fixed the basic as 1200 + DA 741 + HRA 700, totaling Rs. 2641. Why are they doing this practice to reduce their PF contribution? Is this correct, or should they take the government minimum as Basic, i.e., 1825 + DA for PF contribution?
Please clarify.
Thanks,
Best Regards,
Subiah G.
From India, Madras
Acknowledge(0)Amend(0)
Dear Ashok, Upinder 79, and Mrs. Rani Chakravarty,
Please let me know why you need a password! You can easily enter, modify, and delete your data. Each and every cell for entering data for the user end is unprotected. You can easily remove the default details I provided and just enter your own details.
I have also provided directions on how to use this program, so please read the instructions carefully before coming to any conclusions. If you encounter any difficulties, please let me know.
From India, New Delhi
Acknowledge(0)Amend(0)
Please let me know why you need a password! You can easily enter, modify, and delete your data. Each and every cell for entering data for the user end is unprotected. You can easily remove the default details I provided and just enter your own details.
I have also provided directions on how to use this program, so please read the instructions carefully before coming to any conclusions. If you encounter any difficulties, please let me know.
From India, New Delhi
Acknowledge(0)Amend(0)
Dear sir,
Please let me know in which sheet you find such type of difficulty. Please note that in the summary sheet, I intentionally gave a white background color.
1. In the summary sheet, we don't need an entry because it is a summary sheet.
2. If I gave a background color and if you need to print out that summary sheet (normally possible), the printout will look very odd due to the dark background, and it will also highly consume your printer cartridge.
So, if you find any difficulties entering data without the summary sheet/salary sheet/annual sheet, please let me know the sheet number.
From India, New Delhi
Acknowledge(0)Amend(0)
Please let me know in which sheet you find such type of difficulty. Please note that in the summary sheet, I intentionally gave a white background color.
1. In the summary sheet, we don't need an entry because it is a summary sheet.
2. If I gave a background color and if you need to print out that summary sheet (normally possible), the printout will look very odd due to the dark background, and it will also highly consume your printer cartridge.
So, if you find any difficulties entering data without the summary sheet/salary sheet/annual sheet, please let me know the sheet number.
From India, New Delhi
Acknowledge(0)Amend(0)
Dear all,
Please find the following steps to run the program. Please follow the steps in the given sequence.
First, open "Company Detail Sheet"
1. Open "Company Detail Sheet"
2. Change the Company name and Address.
3. Change Salary descriptions: By default, I have provided some categories for Fixed earning/Reimbursement/Other deductions. Change the names of these categories as per your requirements.
4. As you enter details mentioned in step 3, the names of the categories will appear in the auto-generated salary section just below the Salary description. Enter the percentage as per your company requirements to generate the salary of all employees. (By default, I set Basic = 25% of gross. You can change the percentage as needed.)
5. Enter the % of ESI from Employee and Employer, and for P.F., choose your options.
6. For the Professional tax slab, enter your criteria.
7. Enter the Names of Departments/Designations of Employees in your Organizations.
8. Enter the Tax Slab for men and women.
Second, open "Master Data Sheet"
1. Enter Employee name-gender-employee code.
2. Select his/her designation-department.
3. Enter Pan no-Bank A/C No-Bank name-P.F no-ESI No-DOB-DOJ-Location.
4. Enter Employees Gross salary/Month.
5. If you choose Auto mode, the Salary slip will be generated automatically as per the data provided in the "Company detail sheet" (normally for Regular Employees, use Auto mode). If you prefer manual mode, enter his/her Basic-HRA and all other salary details manually.
6. Enter the Amount of OT/Hr if Employee does OT.
7. Enter leave details, Previous Year Leave-This Year Leaves.
8. Enter Rent paid by Employee for exemption under section 10 & 17.
9. Enter Amount for section 80c and 80D for U/S VIA deduction.
Third, open "Attendance sheet according to a particular Month"
1. Enter Attendance/Leave/Holiday of Employee.
2. Enter Overtime of The Employee.
Fourth, open "Payroll sheet according to a particular Month"
1. All salary details and attendance will automatically carry forward. You only need to enter reimbursement details and other deduction details.
2. Salary will be generated based on your data.
3. Enter the Salary Amount that you have Paid.
4. Select the Type of Payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(0)Amend(0)
Please find the following steps to run the program. Please follow the steps in the given sequence.
First, open "Company Detail Sheet"
1. Open "Company Detail Sheet"
2. Change the Company name and Address.
3. Change Salary descriptions: By default, I have provided some categories for Fixed earning/Reimbursement/Other deductions. Change the names of these categories as per your requirements.
4. As you enter details mentioned in step 3, the names of the categories will appear in the auto-generated salary section just below the Salary description. Enter the percentage as per your company requirements to generate the salary of all employees. (By default, I set Basic = 25% of gross. You can change the percentage as needed.)
5. Enter the % of ESI from Employee and Employer, and for P.F., choose your options.
6. For the Professional tax slab, enter your criteria.
7. Enter the Names of Departments/Designations of Employees in your Organizations.
8. Enter the Tax Slab for men and women.
Second, open "Master Data Sheet"
1. Enter Employee name-gender-employee code.
2. Select his/her designation-department.
3. Enter Pan no-Bank A/C No-Bank name-P.F no-ESI No-DOB-DOJ-Location.
4. Enter Employees Gross salary/Month.
5. If you choose Auto mode, the Salary slip will be generated automatically as per the data provided in the "Company detail sheet" (normally for Regular Employees, use Auto mode). If you prefer manual mode, enter his/her Basic-HRA and all other salary details manually.
6. Enter the Amount of OT/Hr if Employee does OT.
7. Enter leave details, Previous Year Leave-This Year Leaves.
8. Enter Rent paid by Employee for exemption under section 10 & 17.
9. Enter Amount for section 80c and 80D for U/S VIA deduction.
Third, open "Attendance sheet according to a particular Month"
1. Enter Attendance/Leave/Holiday of Employee.
2. Enter Overtime of The Employee.
Fourth, open "Payroll sheet according to a particular Month"
1. All salary details and attendance will automatically carry forward. You only need to enter reimbursement details and other deduction details.
2. Salary will be generated based on your data.
3. Enter the Salary Amount that you have Paid.
4. Select the Type of Payment.
Most of the remaining sheets are monitoring or summary sheets.
From India, New Delhi
Acknowledge(0)Amend(0)
In which sheet Have You find difficulty? Have you follow above instructions? Please let me know Sheet number..
From India, New Delhi
Acknowledge(0)Amend(0)
From India, New Delhi
Acknowledge(0)Amend(0)
Hi Dada,
I tried to enter as you advised, but there are certain fields which we don't use for all employees. For example, in our company, the salary structure does not include providing the basic salary as a clear percentage of the gross. Because of that, when I enter the data in the master sheet, the basic column is password-protected. Please tell me the password to update the changes.
Thanks,
Shemy
shemylaila@gmail.com
From United Arab Emirates, Al Ain
Acknowledge(0)Amend(0)
I tried to enter as you advised, but there are certain fields which we don't use for all employees. For example, in our company, the salary structure does not include providing the basic salary as a clear percentage of the gross. Because of that, when I enter the data in the master sheet, the basic column is password-protected. Please tell me the password to update the changes.
Thanks,
Shemy
shemylaila@gmail.com
From United Arab Emirates, Al Ain
Acknowledge(0)Amend(0)
Dear Shemy,
In the "Master Data Sheet," put such type of employee on "Manual mode" and enter your data in (just besides the "Manual" column) Manual Fixed salary and Manual Fixed deduction cells (here salary details don't concern with basic or other things).
Please note that if you put such type of employee on Auto mode, then the program will not allow you to enter data in Manual Fixed salary and Manual Fixed deduction cells.
From India, New Delhi
Acknowledge(0)Amend(0)
In the "Master Data Sheet," put such type of employee on "Manual mode" and enter your data in (just besides the "Manual" column) Manual Fixed salary and Manual Fixed deduction cells (here salary details don't concern with basic or other things).
Please note that if you put such type of employee on Auto mode, then the program will not allow you to enter data in Manual Fixed salary and Manual Fixed deduction cells.
From India, New Delhi
Acknowledge(0)Amend(0)
is it necessary to deduct pf for allowances like hra,conveyance,overtime etc.,please confirm awaiting eagarly for reply
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Dear Jiguparmar,
I have a few doubts about your Salary Structure Calculator. Assume we have 200 employees in our company as of January's opening balance, and 10 employees resigned or absconded in the same month. Therefore, the total count is 190 for the closing balance. In your method, the salary for February, March, and so on, will be calculated for 200 employees instead of 190. The names of resigned employees will also appear for all months because the employees' names and other related details for salary and attendance are derived from the "DATA" sheet formula. Please try to solve this issue.
Regards,
Senthil
HR
From India, Madras
Acknowledge(0)Amend(0)
I have a few doubts about your Salary Structure Calculator. Assume we have 200 employees in our company as of January's opening balance, and 10 employees resigned or absconded in the same month. Therefore, the total count is 190 for the closing balance. In your method, the salary for February, March, and so on, will be calculated for 200 employees instead of 190. The names of resigned employees will also appear for all months because the employees' names and other related details for salary and attendance are derived from the "DATA" sheet formula. Please try to solve this issue.
Regards,
Senthil
HR
From India, Madras
Acknowledge(0)Amend(0)
Dear Mansi,
Have you read the instructions given with the program? First, carefully read the instructions provided both within the program ("May I help You" Sheet) and in the text file. Read the conversation on pages 9, 10, and 11 of the same thread. After that, try entering your data and let me know if you encounter any difficulties.
From India, New Delhi
Acknowledge(0)Amend(0)
Have you read the instructions given with the program? First, carefully read the instructions provided both within the program ("May I help You" Sheet) and in the text file. Read the conversation on pages 9, 10, and 11 of the same thread. After that, try entering your data and let me know if you encounter any difficulties.
From India, New Delhi
Acknowledge(0)Amend(0)
Dear Jiguparmar,
Could you please change the formula in all salary sheets AH and AI columns to 15000 instead of 10000 for ESI limits? This adjustment is necessary as the ESI limits have been raised from 10000 to 15000.
Regards, Senthil Kumar.A.S
From India, Madras
Acknowledge(0)Amend(0)
Could you please change the formula in all salary sheets AH and AI columns to 15000 instead of 10000 for ESI limits? This adjustment is necessary as the ESI limits have been raised from 10000 to 15000.
Regards, Senthil Kumar.A.S
From India, Madras
Acknowledge(0)Amend(0)
Dear,
You did very well; I appreciate you. But I want to know, what formula should we use if we are calculating PF on basic which has no limit of Rs 6500? Also, how can we change the percentage if it does not depend on gross? For example, Basic is 25% of Gross, but HRA is 15% of Basic.
Regards,
Dilip
From India, Pune
Acknowledge(0)Amend(0)
You did very well; I appreciate you. But I want to know, what formula should we use if we are calculating PF on basic which has no limit of Rs 6500? Also, how can we change the percentage if it does not depend on gross? For example, Basic is 25% of Gross, but HRA is 15% of Basic.
Regards,
Dilip
From India, Pune
Acknowledge(0)Amend(0)
Hi here is some problem regarding esic amount if we put gross 15000 then esic amount not been calculate kindly provide solution and how to calculate half day salary in this formate
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
For PF, if PF is not deducted by any employee, then what if employer contributions of ESIC and PF are made by the employer, then what to do, and the same should appear in Form 3 and 6 of PF. Please explain.
Thanks,
Anand
From India, Bhopal
Acknowledge(0)Amend(0)
Thanks,
Anand
From India, Bhopal
Acknowledge(0)Amend(0)
Good morning, sir,
I have reviewed your Excel data file, and it is wonderful. Could you please share the protected password so that I can update my company profile?
Kindly reply to my email at
.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
I have reviewed your Excel data file, and it is wonderful. Could you please share the protected password so that I can update my company profile?
Kindly reply to my email at
From India, Visakhapatnam
Acknowledge(0)Amend(0)
[QUOTE=kr.karunakar;1190470]Good morning, sir,
I have seen your Excel data file, and it is wonderful. Could you please share the protection password so that I can change my company profile? Kindly reply to my email:
.
You can modify the program as per your company profile. You don't need any password to use this program. Please read the instructions provided with the program and use it accordingly.
Thank you.
From India, New Delhi
Acknowledge(0)Amend(0)
I have seen your Excel data file, and it is wonderful. Could you please share the protection password so that I can change my company profile? Kindly reply to my email:
You can modify the program as per your company profile. You don't need any password to use this program. Please read the instructions provided with the program and use it accordingly.
Thank you.
From India, New Delhi
Acknowledge(0)Amend(0)
Thanks for the POST MR. JIGUPARMAR, but the file is not getting open so please provide a new link for the PF & ESI calculation / Salary Master.. Regards, Abhishek
From India, Calcutta
Acknowledge(0)Amend(0)
From India, Calcutta
Acknowledge(0)Amend(0)
This is a very useful website for buddies like me. I downloaded a salary calculator software a few days ago, but the problem with this software is that our company doesn't have a constant basic percentage or HRA percentage, so I can't use this one. The coding has been made so that we can't edit it. Kindly help me in my case.
Regards, Suresh Babu
From India, Madras
Acknowledge(0)Amend(0)
Regards, Suresh Babu
From India, Madras
Acknowledge(0)Amend(0)
sir, i just want to confirm in your sheet pf from employer is 12% bt it should be 13.6 %. plz tell . sorry if i m incorrect thanks with regards priya tyagi
From India
Acknowledge(0)Amend(0)
From India
Acknowledge(0)Amend(0)
hi, it’s ok not bad, atlist few of them very helpfull. especially freshers........... regards prabhakar
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
HI I want salary break up calculator,in which only i have to put annual CTC, pls refer below format,and any body please make accordingly. Suman Sr HR
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
hi, it can be posiable, some managements PF employee and employeer share12% contribution mentioned on ctc. based on basic slab deductions of PF.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Senior,
I just want to add P.Tax Slab, but only 5 rows are allotted in the software. Could you please send me the password to unprotect the sheet? My email ID is sanjeevkumar@kolonytea.com.
Once again, thank you for the nice collection.
Sanjeev Kumar
From India, Calcutta
Acknowledge(0)Amend(0)
I just want to add P.Tax Slab, but only 5 rows are allotted in the software. Could you please send me the password to unprotect the sheet? My email ID is sanjeevkumar@kolonytea.com.
Once again, thank you for the nice collection.
Sanjeev Kumar
From India, Calcutta
Acknowledge(0)Amend(0)
Since PF ceiling limit has been changed, So can anyone help me out and can give example of salary calculation with all components.
From India, Allahabad
Acknowledge(0)Amend(0)
From India, Allahabad
Acknowledge(0)Amend(0)
Dear Sir,
I am really suffering. Please help me. I have one data list in Excel, and I want to move my row values to another sheet when I delete the actual row values. It should be automatically moved to another sheet.
Note: When I delete the actual row values, they should be moved to another sheet row.
Thank you.
Forwarded/Replied By,
Mohd Mahfooz Alam
From Saudi%20Arabia, Jeddah
Acknowledge(0)Amend(0)
I am really suffering. Please help me. I have one data list in Excel, and I want to move my row values to another sheet when I delete the actual row values. It should be automatically moved to another sheet.
Note: When I delete the actual row values, they should be moved to another sheet row.
Thank you.
Forwarded/Replied By,
Mohd Mahfooz Alam
From Saudi%20Arabia, Jeddah
Acknowledge(0)Amend(0)
thanks.. I need to know one fact if the employee basic salary is 15000 /- and for pf salary deduction is 12%of 15000 =1800 or is it 12%of 6500 = 780. please let me know..
From India, Gurgaon
Acknowledge(0)Amend(0)
From India, Gurgaon
Acknowledge(0)Amend(0)
Hi all,
Can anyone help me with calculating the salary breakdown in Excel to prepare an offer for a candidate? I am looking for a feature where inputting the gross CTC will automatically generate the breakup. Please assist.
Anumitha
From India
Acknowledge(0)Amend(0)
Can anyone help me with calculating the salary breakdown in Excel to prepare an offer for a candidate? I am looking for a feature where inputting the gross CTC will automatically generate the breakup. Please assist.
Anumitha
From India
Acknowledge(0)Amend(0)
Hi i want to see latest topics....please help me how can i see that regards deepti bhardwaj
From India, Sultanpur
Acknowledge(0)Amend(0)
From India, Sultanpur
Acknowledge(0)Amend(0)
Hi,
Is this sheet prepared according to the minimum wages of every state in India? For example, in Punjab, Haryana, and Chandigarh, do we need to ensure that the basic salary aligns with the minimum wage for all categories of workers - Skilled, Highly Skilled, Semi-Skilled, and Un-Skilled? Please confirm.
Additionally, how can we determine if Professional Tax (PT) is being calculated in states where it is applicable?
Thank you.
From India, Begampur
Acknowledge(0)Amend(0)
Is this sheet prepared according to the minimum wages of every state in India? For example, in Punjab, Haryana, and Chandigarh, do we need to ensure that the basic salary aligns with the minimum wage for all categories of workers - Skilled, Highly Skilled, Semi-Skilled, and Un-Skilled? Please confirm.
Additionally, how can we determine if Professional Tax (PT) is being calculated in states where it is applicable?
Thank you.
From India, Begampur
Acknowledge(0)Amend(0)
Hi team, Can someone guide me about income tax calculation based on income & share me the formulated excel and also current year payroll calculation
From India, Bengaluru
Acknowledge(0)Amend(0)
From India, Bengaluru
Acknowledge(0)Amend(0)
Dear Sir,
Your salary calculator is excellent for use. Today, I started using it. However, I have a doubt about it. In the attendance for this month (March 2019), the date is not correct. It starts with the 1st date as Monday. How can I change it? I even changed it in the first sheet to the year 2019.
Please guide me.
Thank you.
From India, Chennai
Acknowledge(0)Amend(0)
Your salary calculator is excellent for use. Today, I started using it. However, I have a doubt about it. In the attendance for this month (March 2019), the date is not correct. It starts with the 1st date as Monday. How can I change it? I even changed it in the first sheet to the year 2019.
Please guide me.
Thank you.
From India, Chennai
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Salary Structure Calculator.xls