Basic salary is a part of the total salary which doesn’t include any other allowances . All the other allowances along with basic salary will be known as gross salary. So the basic salary is a base part of the total salary. The basic salary percentage varies from one company to another company.
Read moreWhat is the formula to calculate monthly salary?
Your total yearly take-home salary = gross salary – total deductions = ₹9.50 lakhs – ₹48,700 = ₹9,01,300. Now, your monthly take-home salary = annual salary/12 = ₹9,01,300/12 = ₹75,108. To do away with the tedious calculations, most people prefer the take-home salary calculator in India.
Read moreHow is basic salary calculation Excel?
Here the basic salary will be calculated as per follows Basic Salary + Dearness Allowance + HRA Allowance + conveyance allowance + entertainment allowance + medical insurance here the gross salary 660,000. The deduction will be Income tax and provident fund under which the net salary comes around 552,400 .
Read moreHow do I calculate a salary sheet in Excel?
Examples of Salary Formula (With Excel Template)
Read moreHow do you calculate basic salary in Excel?
Click cell “F1” and type “Regular Salary.” Press “Enter.” Click cell “F2” and type “=E2*C2” in the cell. Press the “Enter” key. This formula multiplies the employee’s regular hours by his hourly rate.
Read moreHow do I create a salary sheet in Excel Step by step PDF?
It’s done in the format you want it to be.
Read moreHow do I create a salary sheet in Excel?
The salary slip sheet uses the VLOOKUP Function to program the sheet. On the extreme right, select the name of the employee from the drop-down list. The template displays the salary data of the respective employee. Click on the print button to print the Salary Slip.
Read more