Warning: Illegal string offset 'enable_post_type_post' in /home/computer/public_html/wp-content/plugins/enhanced-header-footer-injections/ehfi-functions.php on line 170

How to Make a Salary Sheet in Excel

salary sheet

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.

You can leave a response, or trackback from your own site.

29 Responses to “How to Make a Salary Sheet in Excel”

  1. Rifftype says:


    I saw this really better post today….

  2. louis vuitton outlet luggage…

    Hello, your articles here How to Make a Salary Sheet in Excel | Tutorial Blog to write well, thanks for sharing!…

  3. Will you be capable of guidebook me for your web marketer or the dude whom looks after your website, I have to determine it might be possible to be considered a guests poster.

  4. cheap louis vuitton bags uk…

    Hello, your articles here How to Make a Salary Sheet in Excel | Tutorial Blog to write well, thanks for sharing!…

  5. I would like to show some appreciation to this writer for rescuing me from this particular issue. Just after researching throughout the internet and obtaining advice that were not productive, I thought my entire life was done. Existing minus the approaches to the issues you’ve resolved as a result of your entire article is a serious case, and ones that could have in a wrong way damaged my entire career if I had not come across your blog. Your own competence and kindness in handling a lot of things was crucial. I’m not sure what I would’ve done if I had not encountered such a point like this. It’s possible to at this time look ahead to my future. Thank you very much for your reliable and result oriented help. I will not hesitate to propose your blog post to any person who desires guide on this issue.

  6. Spot on with this write-up, I truly suppose this web site wants much more consideration. I’ll most likely be once more to read way more, thanks for that info.

  7. I wanted to create you the bit of word just to give thanks as before about the breathtaking tricks you have featured above. This is wonderfully generous of you to provide unhampered what a few people could have offered for sale for an ebook to make some money for themselves, mostly now that you could possibly have tried it if you wanted. The ideas also worked to provide a fantastic way to know that most people have a similar zeal the same as my very own to grasp a great deal more regarding this condition. I’m sure there are a lot more pleasurable instances up front for folks who look into your blog post.

  8. Whats up! I just would like to give a huge thumbs up for the nice data you’ve got here on this post. I might be coming back to your blog for more soon.

  9. Aw, this was a really nice post. In concept I want to put in writing like this additionally

  10. I and also my friends were taking note of the great pointers from the blog and so at once developed a horrible suspicion I had not thanked the blog owner for those secrets. All of the ladies were so passionate to learn them and already have undoubtedly been enjoying those things. We appreciate you truly being so kind and for picking out certain high-quality areas millions of individuals are really eager to be aware of. My personal sincere apologies for not expressing gratitude to earlier.

  11. Muchos Gracias for your blog post.Really thank you! Really Great.

  12. An interesting discussion is worth comment. I believe that you must write more on this matter, it might not be a taboo subject however usually individuals are not sufficient to talk on such topics. To the next. Cheers.

  13. WONDERFUL Post.thanks for share..more wait .. …

  14. micro jobs says:

    Heya i am for the primary time here. I discovered this board and I to find It truly helpful & it helped me out a great deal. I’m hoping to present one thing back and help others such as you aided me.

  15. opal jewelry says:

    A powerful share, I just given this onto a colleague who was doing somewhat analysis on this. And he in truth bought me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love studying more on this topic. If possible, as you develop into experience, would you mind updating your weblog with more details? It’s extremely helpful for me. Big thumb up for this blog put up!

  16. Alisha says:

    Thanks for sharing this blog. It will be highly appreciated if someone can share the salary sheet with PF, ESI and its challans. or any link to get practical exposure of filling the challans.

  17. food list says:

    I simply wanted to appreciate you yet again. I’m not certain the things that I would’ve handled in the absence of these ideas shared by you directly on such a industry. It was actually an absolute challenging case in my circumstances, nevertheless observing your specialised manner you dealt with the issue made me to leap with happiness. I am thankful for this support and even believe you comprehend what a great job you are always doing educating men and women through your blog post. Probably you haven’t met all of us.

  18. here says:

    Whispering Misty…

    So sorry you are going to pass up the workshop!…

  19. I am really thankful to the holder of this site who has shared this impressive post at here.

  20. My brother recommended I might like this website.
    He was entirely right. This post actually made my day. You can not imagine
    just how much time I had spent for this information!

  21. Hello to all, because I am genuinely eager of reading this website’s post to be updated on a regular basis. It carries good information.

  22. This is my first time go to see at here and i am
    in fact impressed to read everthing at alone place.

  23. Google says:


    The information and facts talked about within the report are some of the most effective offered…

  24. Nicole says:

    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

  25. ok blog says:

    ok blog…

    What’s up i am kavin, its my first time to commenting anywhere, when i read this post i thought i could also create comment due to this good paragraph….

  26. Google says:


    just beneath, are several absolutely not related web-sites to ours, having said that, they’re surely really worth going over…

  27. 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

You must be logged in to post a comment.

Warning: Illegal string offset 'enable_post_type_post' in /home/computer/public_html/wp-content/plugins/enhanced-header-footer-injections/ehfi-functions.php on line 211
Copy Protected by Chetans WP-Copyprotect.