Streamline Your Operations with MS Excel Bill Sheet for Operations

Ms excel bill sheet for Operations

hello guys welcome to our channel and today's the topic of our discussion is payroll uh in excel and how can you make a payroll and with the help of this uh example you can understand what the elements are required in the payroll and how can you find out the net pay of any person so we'll start our example and here you can see the employee's name uh we have selected the five employees and its pay and total number of hours overtime and total overtime hours and how much cross he will pay for persons and what income tax we have made 18 percent income tax to that salary and other deductibles if there are and then that table so this is very simple function how can use first in the pay we will just give the value of uh the number of r we pay like to matthew we will pay 250 per r and uh for roger we will pay 300 per hour for uh we will pay 625 500 and then 875. this is the pay number of free per hour and how much hours they have worth he were 160 155 162 140 and 148 this is the number of total hours everybody has worked and now over time pay uh per hour we will give 1500 000 thousand fifteen hundred and twelve hundred this is the overtime for r and the over time uh total number of overtimes he has done this twenty thirty 15 and the last one is party now with the help of this uh 160 and for 250 hours and over time 1500 per number of our tan we have to just calculate the gross pay and how can we calculate the gross pay we have to just sum up the two uh combinations like equals to first we have to make the bracket then we will just calculate the first r multiply the total number of hours and then we just add on the again bracket the paper are multiply the total are you work and drag it close you have to just press the enter now we got the total number of cross play you have to just drag it down it will automatically implement on every other box you have to just write comma so that it will be presentable to everyone now uh the income tax how can we calculate the income tax we have to deduct 18 percent so how can you drink you have to just write equals to and you have to select the first cell then multiply and for 18 you have to just write the 18 and then percentage symbol it will automatically calculate in percentage you have to just track it down so you can find out how much percent the person has to pay the income tax now other deductibles for matthew there's no deductible deduction and for roger uh there are two thousand and fifteen hundred and three thousand and two hundred eighteen this is the deductions which is made by the company and now net net is just very simple you have to just write your cross then subtract text and subtract the deducted deductible amounts then you have to just drag it down this is the net pay now the company wants to know the uh total number of her hours ap or total number of space and you have to just write this some bracket open you have to just select the cell and you have to just press the enter so you will get the total number of hours worked and you have to just drag it down so it will give you the data of all the total number of like over time total number of overtimes in ours and total number of crawl space you have to just write here the inverted comma and you have to just use the same format for everyone so that you can get the better understanding of it how these functions work and this is very uh easy payroll system for every organization you can also make such type of uh x payroll axles without uh any hurdle or without any different complicated formulas if you face any confusion you can write in our comment section thank you so much and please subscribe our channel so that we can make further videos on it thank you