Need Urgent Help: How Do I Calculate Basic Salary in Excel Using Gross Salary and Attendance?

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

Hi all,

Please find attached the salary sheet. [Link removed]

I hope this information will be helpful to you.

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.

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 🌟

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

Hi all,

Please tell me, can we break up the minimum wages or not under the labor act? If yes, what is the formula for calculation?

Hi,

Please find enclosed herein the salary sheet format as per your requirement. I hope this will be helpful for you to review.

Thank you.

Hi,

Please find enclosed herewith the Salary Sheet format as per your requirement. I hope this will help all of you to know.

Thank you.

Hello everyone, I am Vijay.

Can anybody elaborate on the meaning of the salary of Rs. 9300-34800, Grade pay Rs. 4200, and applicable allowances as per company rules?

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.

To deduct TDS for employees, you will need to follow the guidelines set by the tax authorities. It is essential to calculate the TDS accurately based on the employee's income and applicable tax rates. Additionally, understanding the basis salary is crucial as it forms the foundation for various deductions and benefits.

When it comes to deducting PF (Provident Fund) and ESI (Employee State Insurance) for employees, you must comply with the regulations set by the respective authorities. PF deduction is based on a percentage of the employee's basic salary, while ESI deductions depend on the gross salary. As an industrial automation-based company, it is important to ensure that all deductions are carried out correctly and in accordance with the relevant laws and regulations.