Tags: payslip format in excel with formula Published by Joyce Adams. July 24, 2017 Free printable and blank company salary slip format ms word doc, effective salary slip format using microsoft excel template, professional monthly employee pay slip template sample for your business, company salary slip and pay stub template sample free download. Recomendation from Editor Published by Joyce Adams.
July 15, 2017 Motor vehicle purchase agreement sample in word or pdf format, buy or sell vehicle sales agreement template sample, sample vehicle purchase agreement and contract with blank rows, agreement contract and bill of sale sample for buying used car. Published by Joyce Adams. July 31, 2017 Nice personal letter of employment recommendation for a family member, downloadable personal letter template for referencing a friend, sample personal letter of recommendation for college student, personal reference or recommendation letter template sample. Published by Joyce Adams. July 13, 2017 Simple award certificate of excellence template sample to give in contest, general award certification template with yellow frame and black font color, award certificate for participation template sample, simple award certificate template for contribution and great work. Published by donna Jonaitis. July 16, 2017 Excellent checklist form template word and use, simple plane travel checklist template free microsoft word templates, fill in blank checklist template for word, perfect word checklist template examples in word and excel office.
Salary Slip Format In Excel With Formula Free Download
Published by donna Jonaitis. July 14, 2017 Best annual expense report free template download from accounting and finance, interesting annual excel expense report template free printable, perfect excel expense report template free printable, excellent fillable and annual expense report free template. Published by Joyce Adams. July 22, 2017 Classic style achievement certificate template with blue frame, simple women certificate of achievement template word sample, simple certificate of achievement template with orange yellow color scheme, awesome certificate of achievement template sample for fresh graduate student.
Published by donna Jonaitis. July 15, 2017 Excellent proper business letter sample word template download printable, basic standard business letter sample word resume free theme, interesting business letter sample word with table and chart, great business letter sample word and vancauver manufacturing. Published by donna Jonaitis. July 26, 2017 Creative microsoft office expense report template form anuvratinfo, exceptional dashboard auto expense report templates dear guest excel pdf, printable dashboard microsoft office expense report print out, excellent microsoft office expense report template and business develpoment. Published by donna Jonaitis. July 24, 2017 Professional my condolence letter to pm lee for cowoker, condolence letter example nice words and excel ideas, effective short and sweet condolence letter example, intersting microsoft word and pdf condolence sample letter of sympathy.
Published by donna Jonaitis. July 20, 2017 Professional down payment receipt with black fonts colors and square shaped paper, microsoft office word and pdf with down payment receipt template, employee direct deposit enrollment form and down payment receipt template, free car down payment deposit receipt template excel.
How to Print Salary Slips Using VLookup Formula in Excel. In large organizations, the office staff and labour are found in huge quantity. In order to keep track of their attendance up to date is not an easy task. If the number of employees touches thousand, then it become the headache of the human resource staff to process the salaries and print the slips. Lets suppose that ABC is a shoe manufacturing concern. It has around 2,000 employees, following is the extract from its Excel Payroll sheet maintained in Sheet 1: S. NO Name Employee ID Basic Salary Over time Total Salary 1 Ahmed 001 30,000 3,000 33,000 2 Salman 002 25,000 2,000 27,000 3 Jagdesh 003 35,000 1,000 36,000 4 Kiran 004 20,000 5,000 25,000 5 Jose 005 28,000 4,000 32,000 6 Allan 006 22,000 6,000 28,000 7 Martin 007 23,000 7,000 30,000 Now, we will prepare payroll slips using the Vlookup fucntion in excel in Sheet 2 using the formula shown below: The result of the above formula will print the result as follows: Here, we just input the S.
No of each row record in C2 cell, then the formuloa will fetch up all the data based on the value of C2 in Sheet 1. We entered 2, 3, 4, 5 & 6 to tell the Ms Excel that from which column, the formula retrieves the result. VLOOKUP is invaluable Micrsoft Excel Formula which speeds up the genjeration of various types of reports.
This is a simple salary slip in Excel with general format you may use for your purposes. If you are small business owners where you are running your business with a small number of employees, you might find this useful since you can modify it to meet your own needs. Or, if you are a Human Resources Manager, you may need this as reference to generate your own format. The main benefit of having this form in Excel over Word is you don’t have to calculate the salary manually. You just need to put correct excel function to calculate the data.
Salary slip is used as payment proof where employees might need it for:. home or car loan application.
credit card application. tax attachment. insurance application That’s why you must put some important information into salary slip form instead of just salary amount to make sure your employee’s application pass the administrative requirement. Also, if you are an employee, you may simulate your salary including its allowance to calculate the amount you need on a new company. Or, to calculate how much raise you want to have in current company after yearly company appraisal.
Salary Slip Template Format In this model, you can add name, employee ID, title, directorate and department below salary slip title. Then you can type salary description as well as their values in the table below it.
Earnings column is at the middle table, between description and deductions columns. Deductions column is at the right side. Net salary will be calculated automatically.
There is an automatic amount to words converter that will convert its nominal value into words. You must fill required information manually, except the amount in words part.
You may create your own employee database table with their salary details if you want to print it regularly as well as keeping your employee’s monthly salary record. Then you can group either employee’s name or ID as reference to pull their data. Use Data Validation function put in name/employee ID to select respective employees. And then, use VLOOKUP formula to pull particular employee into salary slip form based on that selection. You can see one sample of employee database in picture below.
You can modify its layout, add more rows and columns, modify its titles to meet your own requirements. Don’t forget to put your company logo. And depends on your company’s policy, you can add signature box at the bottom in this salary slip form. Or, you can add one line note to inform that the salary slip is valid without signature.
(575.0 KiB, 27,123 hits).
Using formulas in Microsoft Excel is a reliable method to calculate payroll for your business. Microsoft Excel contains over 300 built-in formulas to aid in the production of a functional worksheet. The 'IF' function is a logical test that assess whether a certain condition is met and returns a value according to the conditions. Using the 'IF' function in your worksheet, you can evaluate an employee's hours, determine the number of overtime hours and calculate the employee's gross salary. Open a Microsoft Excel spreadsheet. Click cell 'A1' and type 'Employee.' Press the 'Enter' key.
Click cell 'A2' and type the name of the first employee. Continue entering each employee's name in column A. Click cell 'B1' and type 'Employee ID.'
Press 'Enter.' Click cell 'B2' and type the employee ID of the first employee. Continue entering each employee's ID in column B. Click cell 'C1' and type 'Hourly Rate.' Press the 'Enter' key.
Click cell 'C2' and type the hourly rate of the first employee. Continue entering each employee's hourly rate in column B. Click cell 'D1' and type 'Total Hours.' Press the 'Enter' key. Click cell 'D2' and type the total hours of the first employee. Continue entering each employee's total hours in column C. Click cell 'E1' and type 'Regular Hours.'
Press the 'Enter' key. Click cell 'E2' and type '=IF(D240,40,D2).' Press the 'Enter' key. This formula instructs Excel to display only the employee's regular hours.
Click cell 'E2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'E2' and drag your mouse to copy the formula for each employee. 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. Click cell 'F2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign.
Click the corner of cell 'F2' and drag your mouse to copy the formula for each employee. Click cell 'G1' and type 'Overtime Hours.' Press 'Enter.' Click cell 'G2' and type ' =IF(D240,D2-40,'0')' in the cell. Press the 'Enter' key. This formula evaluates the employee's total hours and displays only hours over 40.
If the employee has less than 40 hours, the cell displays a '0.' Click cell 'G2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign. Click the corner of cell 'G2' and drag your mouse to copy the formula for each employee.
Click cell 'H1' and type 'Overtime Salary.' Press the 'Enter' key. Click cell 'H2' and type '=(C21.5)G2' in the cell. Press 'Enter.' This formula multiplies the employee's overtime hours by the general overtime rate of time and a half. Click cell 'H2' and place your mouse at the lower-right corner of the cell.
Simple Salary Slip Format In Excel With Formula Free Download
Your mouse pointer changes to a '+' sign. Click the corner of cell 'H2' and drag your mouse to copy the formula for each employee. Click cell 'I1' and type 'Gross Salary.' Press 'Enter.' Click cell 'I1' and type ' =H2+F2' in the cell. Press the 'Enter' key.
This formula adds the employee's regular salary and any overtime. Click cell 'I2' and place your mouse at the lower-right corner of the cell. Your mouse pointer changes to a '+' sign.
Click the corner of cell 'I2' and drag your mouse to copy the formula for each employee. Click cell 'C2' and drag your mouse to highlight each employee's hourly rate. Click the 'Home' tab and click the '$' sign in the 'Number' group to format the cells to include a dollar sign and increase the number to two decimal places. Apply this format to the dollar amounts in column 'F,' 'H' and 'I.' Click cell 'A1' and drag your mouse to cell 'I1.' Click the 'Home' tab and click the 'B' sign in the 'Font' group to apply bold formatting to the cells.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |