Basic Salary Sheet

[kmital]

Hi,

My first post and I would request the esteemed members to provide me with a basic Salary Sheet in Excel for my salary calculation purposes. I run a Take-away, online ordering and delivery ******* and my basic requirements for salary calculations are:-

1) CTC
2) Number of days absent. (To be subtracted from the net payable).
3) Advance Taken by employee. (To be subtracted from the net payable).
4) Food taken by employee (value to be deducted from the salary).
5) Over time done by the employee. (Value to be added to the net payable).
6) Net Payable.

Thanks in advance.

 

[Joe4]

Welcome to the Board!

Since you are new here, you may not be quite familiar with how this board works. The intent is to help you solve your Excel problems, but not really do all the work for you. That is something that typically a Consultant would do. If that is what you are looking for (someone to do all the work for you), then take a look at the consulting services (see: https://www.mrexcel.com/consulting-services/).

It is possible that there may be some similar templates available on the internet that someone may point you to. Or you could try looking for some yourself using a Google search, and see if there is anything already out there that might work for you.

 

[AlanY]

isn't it just

Net Payable = salary - 2) -3) -4) +5)