Hi Guys,
I have to prepare the salary statement. Can anyone help me with how to calculate it in Excel? I need a formula for the basic salary based on the gross salary and the number of days present.
Please help me out; it's very urgent.
Thanks,
Saravanan
From India, Ambala
Acknowledge(0)
Amend(0)
6I have to prepare the salary statement. Can anyone help me with how to calculate it in Excel? I need a formula for the basic salary based on the gross salary and the number of days present.
Please help me out; it's very urgent.
Thanks,
Saravanan
From India, Ambala
Acknowledge(0)Amend(0)
Hi All, Herewith I am attaching a Salary sheet . Hope this information would help you.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
I do not think there is any rule as to the dividing factor, i.e., 31/30 or 26. It depends from organization to organization. Organizations either take 30 or 31 as they give advantage to the employees for LOP deductions. Presently, organizations like to be lenient because of intense competition.
On the contrary, most of the employees do not know what dividing factor is considered while calculating LOP. But 26 days can be considered. For example, if the salary is 30,000, an organization stands to gain Rs. 186 for one day's LOP. So, if there are an average of 100 LOPs in an organization in one month, the organization saves 18,600 each month.
From India, Delhi
Acknowledge(0)Amend(0)
On the contrary, most of the employees do not know what dividing factor is considered while calculating LOP. But 26 days can be considered. For example, if the salary is 30,000, an organization stands to gain Rs. 186 for one day's LOP. So, if there are an average of 100 LOPs in an organization in one month, the organization saves 18,600 each month.
From India, Delhi
Acknowledge(0)Amend(0)
Sir,
My name is Zubair Ansari. Please inform me about all Excel formulas and their results in Excel. I need guidance on all Excel formulas that work in Excel sheets. Provide tips and tricks on how to write these formulas in Excel, and explain which formulas are used for what purposes. Please show me all these formulas on an Excel sheet with their respective functions. I will be forever grateful to you. It is due to these formulas that I am able to perform well in my job. Once, I received a job offer from a company, but they required Excel skills and were offering a salary range of 10,000 to 15,000. However, I am not fully familiar with using formulas. Please guide me on applying formulas on an Excel sheet with complete working examples. I will always be thankful to you.
Your student 🌟
From India, Ghaziabad
Acknowledge(0)Amend(0)
My name is Zubair Ansari. Please inform me about all Excel formulas and their results in Excel. I need guidance on all Excel formulas that work in Excel sheets. Provide tips and tricks on how to write these formulas in Excel, and explain which formulas are used for what purposes. Please show me all these formulas on an Excel sheet with their respective functions. I will be forever grateful to you. It is due to these formulas that I am able to perform well in my job. Once, I received a job offer from a company, but they required Excel skills and were offering a salary range of 10,000 to 15,000. However, I am not fully familiar with using formulas. Please guide me on applying formulas on an Excel sheet with complete working examples. I will always be thankful to you.
Your student 🌟
From India, Ghaziabad
Acknowledge(0)Amend(0)
Hi,
Could you please let me know in detail about the calculation of SALARY, i.e., Basic pay, DA, HRA, etc., in terms of percentages (as against CTC)? For example, 50% of CTC is taken as HRA, etc. Please reply to me soon and email me at this address: samia.1982@gmail.com.
Regards, SAK_82
From India, Hyderabad
Acknowledge(0)Amend(0)
Could you please let me know in detail about the calculation of SALARY, i.e., Basic pay, DA, HRA, etc., in terms of percentages (as against CTC)? For example, 50% of CTC is taken as HRA, etc. Please reply to me soon and email me at this address: samia.1982@gmail.com.
Regards, SAK_82
From India, Hyderabad
Acknowledge(0)Amend(0)
hi all, Pls tell me, can we breakup the minimum wages or not under labour act, if yes what is the formula for calculation.
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi, Plz find enclosed herewith salary sheets format as per your requirement. Hope this will help you to know.
From India, Nasik
Acknowledge(0)Amend(0)
From India, Nasik
Acknowledge(0)Amend(0)
Hi, Plz find enclosed herewith Salary Sheet format as per your requirement. Hope this will help all of you to know.
From India, Nasik
Acknowledge(0)Amend(0)
From India, Nasik
Acknowledge(0)Amend(0)
hello everyone, I m vijay. Can anybody elaborate the meaning of the salary of Rs.9300-34800,Grade pay Rs.4200 & applicable allowances as per companies rules.??????
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Please send me the salary structure for plastic industry including basic, da, gross and deductions like pf pt etc. Regards, Ajit
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
If the salary is 21711, what would be the CTC?
BASIC - 10,001
Special Allowance - 5,031
Conveyance - 800
HRA - 5,001
Medical Allowance - 1,250
LTA - 833
Gross Salary - 22,916
PF - 1,250
Base Salary - 24,116
Based on the above details, what salary hike can be expected?
From India, Mumbai
Acknowledge(0)Amend(0)
BASIC - 10,001
Special Allowance - 5,031
Conveyance - 800
HRA - 5,001
Medical Allowance - 1,250
LTA - 833
Gross Salary - 22,916
PF - 1,250
Base Salary - 24,116
Based on the above details, what salary hike can be expected?
From India, Mumbai
Acknowledge(0)Amend(0)
Hi Arunsinh,
I have a query regarding the calculation of salary for a new employee who started working on September 17th in the organization. There were 2 weekends in between, and the total monthly salary is $49,270. How should we calculate this considering the type of working days to divide?
Could you please guide me on whether my calculation of 28 days, one day's salary, 12 working days, and 2 weekends to determine the correct salary is accurate or not?
Thank you.
From India, Nagpur
Acknowledge(0)Amend(0)
I have a query regarding the calculation of salary for a new employee who started working on September 17th in the organization. There were 2 weekends in between, and the total monthly salary is $49,270. How should we calculate this considering the type of working days to divide?
Could you please guide me on whether my calculation of 28 days, one day's salary, 12 working days, and 2 weekends to determine the correct salary is accurate or not?
Thank you.
From India, Nagpur
Acknowledge(0)Amend(0)
Dear Balram, As you are aware that in a month we will not calculate W\'off as working days. Only for PF and ESI only we will calculate on 31/30 /28 days. We can calculate the salaries on 26 days.
From India, Hyderabad
Acknowledge(0)Amend(0)
From India, Hyderabad
Acknowledge(0)Amend(0)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 SHEET CALCULATION.xls
SALARY EXCEL.zip