What is a salary sheet?
A salary slip/pay slip is a document issued by an employer to an employee. It contains a detailed description of the employees salary components like HRA (House Rent Allowance), LTA (Leave Travel Allowance), Bonus paid etc and deductions for a specified time period, usually a month.
How do I create a salary slip in Excel?
0:01 5:41 Automatic Salary Pay Slip in 5 Minutes - YouTube YouTube Start of suggested clip End of suggested clip So first of all go to view tab and select page layout select column a and f and set the column widthMoreSo first of all go to view tab and select page layout select column a and f and set the column width 0.45. This time you will select the column b c d e. And set the column width 1.5.
How can I make 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.
How do I make a salary slip?
Salary Slip Format Company name, address, logo, salary slip month and year. Employee name, code, designation and department. Employee PAN/Aadhaar number and bank account number. EPF account number and UAN (Universal Account Number) Total work days and number of leaves. List of earnings (income) and deductions.
How do you format a salary?
Salary Structure Sample For an employee with a CTC of ₹15,00,000 per year, a typical salary structure may be as follows: CTC = gross salary + EPF + health insurance = ₹12,11,200 + ₹1,11,451.2 + ₹177348.8 = ₹15,00,000 per year. Basic = 40% of CTC amount = ₹5,99,200 per year. DA = 55% of basis salary = ₹3,29,560 per year.
How do I create an employee salary sheet in excel?
Step 1: Open a new blank excel spreadsheet. Go to Search Box. Type Excel and double click on the match found under the search box to open a blank excel file. Step 2: Save the file on the location you want your payroll to be saved so that it does not get lost, and you will always have it with you.
How can I make a salary slip online for free?
Rs. 0 Fill in the basic details about your company i.e. the name, logo, address, etc., Enter your employees details i.e. the name, ID number, designation, PAN, bank account number, etc., Add the income details i.e. Employees UAN, pay period, earnings, deductions, etc.,
How do I create a simple salary slip in Excel?
Here are the steps you should take: Create a new row in the YTD worksheet. Enter all the information for a pay date, pay period, hours, and payment amounts. Select the pay date from the drop-down at the top of the free payslip template. Double-check, print and send the payslip to the employees.
How do you make a salary sheet?
6 Easy Steps to Create a Monthly Salary Sheet Format in Excel Step 1: Calculate Allowances of Each Employee from Dataset. Step 2: Use SUM Function to Find Gross Salary. Step 3: Calculate Provident Fund for Each Employee. Step 4: Apply IFS Function to Determine Tax Amount. Step 5: Calculate Total Deduction from Gross Salary.
How do you format a salary?
Salary Structure Sample For an employee with a CTC of ₹15,00,000 per year, a typical salary structure may be as follows: CTC = gross salary + EPF + health insurance = ₹12,11,200 + ₹1,11,451.2 + ₹177348.8 = ₹15,00,000 per year. Basic = 40% of CTC amount = ₹5,99,200 per year. DA = 55% of basis salary = ₹3,29,560 per year.