Tutorial Blog

www.computertutorialbd.com is the builder and source for your increasing IT knowledge.

How to Make a Salary Sheet in Excel

A salary sheet is the most essential need for any economic company or organization. Suppose, you are a data entry operator or you have been given the duty of making a salary sheet for your company. At that situation, you must have extra knowledge about making a salary sheet. If you learn this lesson, I hope that it must increase your ability to make a salary sheet.

Make a salary sheet for your staffs:

You will have been given some conditions and according to these conditions, you will have to make a salary sheet.

Think the following conditions are given to you:

  1. Rate of house rent – 10% of basic salary
  2. Rate of medical allowance – 5% of basic salary
  3. Rate of vehicle allowance – 5% of basic salary
  4. Rat of other allowance – 2% of basic salary
  5. Normal working hours per day- 8
  6. Rate of overtime by per hour – double of normal working per hour
  7. Rate of life insurance – 2% of basic salary

Note: These conditions may change from one company to another.

The following picture is a model of a salary sheet which is made according to above conditions or information. Download this excel salary sheet from the following link

salary sheet 

Download now an excel salary sheet

After download, open it and come to this web page again and follow the steps attentively and analyze the rules and formulas how to make them. If you understand it, you can make another salary sheet with your own information.

  1. Create an Excel spreadsheet according to above model or as the  downloaded Excel file
  2. Delete all the data from row 5 to 14
  3. ID in cell A5 – type here staff’s ID no or serial number or grade number
  4. Name in cell B5 – type here staff’s name
  5. Post in cell C5 – type here staff’s Post
  6. Type basic salary in cell D5
  7. House Rent in cell E5 –10% of  basic salary or basic salary*10/100 and excel formula in cell E5 –  =D5*10/100
  8. Medical Allowance in cell F5 –  5% of  basic salary or basic salary*5/100 and excel formula in cell F5 – =D5*5/100
  9. Vehicle Allowance in cell  G5 –  5% of  basic salary or basic salary*5/100 and excel formula in cell  G5 – =D5*5/100
  10. Other Allowance in cell H5–  2% of  basic salary or basic salary*2/100 and excel formula in cell H5 – =D5*2/100
  11. Gross Salary in cell I5 – total of (House Rent+ Medical Allowance+ Vehicle Allowance+ Other Allowance) or E5+F5+G5+H5 and excel formula in cell I5 –  =SUM(D5:H5)
  12. Working day in cell J5 – How many days has the current month for which you will have to make a salary
  13. Attendance in cell K5 –  How many days was a staff present in current month
  14. Holiday in cell L5 – How many days did the company or office remain close
  15. Overtime Hours in cell M5 – total Overtime Hours that a staff did or was present
  16. Gross Payable in cell N5- Gross Salary÷ Working day*( Attendance+ Holiday)+ Overtime or I5/J5*(K5+L5)+M5 {Note of Overtime :  Gross Salary÷( Working day *normal working hours by per day)*Rate of Overtime* total Overtime Hours} and Excel formula in cell N5 – =I5/J5*(K5+L5)+I5/(30*8)*2*M5
  17. Life Insurance in cell O5–  2% of  basic salary or basic salary*2/100 and excel formula in cell O5 – =D5*2/100
  18. Advance in cell P5 – amount of money what a staff took previously according to a returning system
  19. Other Deduction in cell Q5 – amount of money what a staff took previously according to a returning system or other
  20. Net Payable in cell R5 – Gross Payable-( Life Insurance+ Advance+ Other Deduction) or N5-(O5+P5+Q5) and Excel formula in cell R5 – =N5-(O5+P5+Q5)
  21. Signature of Receiver in cell S5 – an option where a staff can sign a signature of getting salary

Note: We have to write the above formulas in the first cell of row 5 and drag every cell from row 5 to row 14.

Dear visitor, if you face any problem till, please inform me by commenting here.

Share

Facebook Like

22 Comments

Add a Comment
  1. Pingback: here
  2. Pingback: Google
  3. We have made the decision to open our POWERFUL and PRIVATE website traffic system to the public for just a few days! You can sign up for our UP SCALE network with a free trial as we get started with the public’s orders. Imagine how your bank account will look when your website gets the traffic it deserves. Visit us today: http://nsru.net/317p

  4. Pingback: ok blog
  5. Pingback: Google
  6. Thank you for any other informative blog. The place else
    may I get that type of information written in such
    an ideal way? I have a mission that I am simply
    now running on, and I’ve been on the look out for such information.

Leave a Reply

Tutorial Blog © 2014
Copy Protected by Chetans WP-Copyprotect.
%d bloggers like this: