Salary Calculation in Excel | Payroll in Excel | Tutorial
HTML-код
- Опубликовано: 29 дек 2017
- In This video i have explained the best way to prepare salary in excel, about the Allowances, deduction part, such as PF, ESIC, LWF etc, employer's contributions, Most important formulas to be used to prepare salary.
Please watch the video and Subscribe my channel if you like it.
Post your queries if any in the below comment section.
Lets get it done...
Nice video.......Sir
Very useful information video. Thanks for your valuable support and update sir.
Thank You, it helped a lot to clear concepts (column for PT missed, latest rate for ESIC 0.75% &3.25%, PF 12% & 13%)
Wah bhaai lovely Presentation Thank u
It's really really helpfull thank you so much.
pf ka formula deke & bonus & gratuity insert karke ek master payroll ka video plz laiye
Excellent work
Its very useful for hr beginers.....wonderful job
Thanks Mr. Arun..
Hello sir
Very useful and helpful video.
Thanks a lot..
Kindly teach us about TDS deduction and overtime calculation.
Thanks, its very helpful vedio but pls make a new payroll vedio including the calculation of bonus, professional Tax and TDS
Dear sir
This video very useful and update new video class sir
Thanks regards
Please suggest the topic on which you want me to make the video..
Sir ye video kafi sahi lagi lekin sir aap se pucha na hai ki center government ki wage bhi to hoti hai vo kesse use kare
I believe at 16:08 the formula should be =if(M3
Pls share ur new vedio with the deductions of TDS, gratuity, bonus
Please up one more video with new pf and tds rules
Hi Jacob, you can refer following videos:
For Changes in PF/ESIC - ruclips.net/video/mS0bVzhVmME/видео.html
For TDS - ruclips.net/video/uT8HndCTuiI/видео.html
There are more videos available, please visit the playlists.
Hi Sir. Your video was brilliant. Very helpful. Sir, could you be please help me with the Income Tax deduction part. How the Income Tax slab is implemented during the salary calculation and is deducted from the pay slip. Please provide an elaboration regarding this topic. Thank you.
Gabriela Nayak, sure i will upload my next video on TDS..
Inspired Mate O dats cool...May I know when it's going to be uploaded? It's a kind of urgent for me.
Please clear me one thing is that if we are making salary sheet as you tell that we have to put gross salary then what is the difference in monthly ctc
Gross Salary is the Monthly Earning of an Employee and CTC is the total cost of an employer spent on an employee which included Gross Salary + any other expenses (PF, ESI, Bonus, Gratuity, etc).
Sir, it's a wonderful vedio, but am little confuse as we actually calculate on 30 days. will u plz share me this and other payroll sheets in my mail.
Hai Sir,,,
Actually in my organisation they give 3 paid leaves .if 3 leaves any employee utilize no salary will be deducted.and if 3 leaves not utilize we pay that 3 days extra salary given to employee.my need is exdays salary calculation video.
Sir will you please tell me about the last four columns why we use this in payroll ????
Thanks for the salary calculation details but I have a dot that the ESIC should be calculated from the Gross salary or paid gross salary plz let me know. Bcoz the no of days is calculated for paid gross salary.
Esic shall be calculated on Payable Gross.
I got same doubt,,,,,for example 22000/- employee attendance 25 days present then payable gross would be, exaple 18000/- then shall we deduct esi for this month ....if 31 days present in Jan 2021 here gross payable 22000/- so no need to deduct esi...clarify esi deduction gross r payable gross...
On How much salary is PF deduction Mandatory in 2021
May you share this sheet in the description.
Earning CTC kaise calculate kiya apne?
Very appreciated , but Sir salary can only be done in 30 days whether it's february, 30 or any 31 days of month
Hi Vandana, for salary calculation we do not concider weekoffs.
@@inspiredmate completely Agree with U , sir pls share same for 30 days as u have showed for 31 days , so that some of my doubts can be clear.
Sir will u pls share ur payroll sheet in my mail id
masih.vandana@rediffmail.com
And pls tell us about TDS , bonus , gratuity deduction too on the above sheet.
Thanks in advance.
@@learningsoul8292 will share you the sheet by tomorrow, will come up with a new video explaining, TDS, Gratuity, and Bonus calculations..
@@inspiredmate thanks Sir
Could you provide the excel format for this video
Informative video where do i can get this excel sheet
Drop your email id..
@@inspiredmate biki1bhowmik@gmail.com
krishnar768@gmail.com
make it yourself, you shall learn a lot,,,,,,,why you want all readymade?
sir your not calculate employees Bonus and Life insurence, adv-payment, Taking Loan Calculation , P.tax and Tds deduction please add all this components /colunmn add again update this video in as 2022 Earlier in couple of days.
Bro tell me one thing what is the difference between employee and employer?? I saw ur video and something went wrong so please check it out ur video firstly and may be something error....
nice! but next time is better you consider to do it purely in English. just saying.
One doubt is there with ESI And PF.
》As per guidelines if someone having basic more than 15000 he might not get the benefit of PF
》When Gross Salary is greater than 21000 then he/she will not be benefited of ESI scheme.
My point is that if someone having gross of 40000 and he was present for 7 days then his/her paid gross will be less than 21000 and Basic less than 15000. In this case is it possible to deduct or leave it as it is.
Please suggest!!!
Hi Rudra,
PF Doubt -
1. Anyone whose basic+DA is more than 15000 and was never a member of PF earlier shall be excluded from PF.
2. Anyone who once becomes member of PF remains member of PF irrespective of his salary, whether its more or below 15k, though it can be capped to 1800 for monthly contributions.
ESIC -
1. 21000 is the eligibility limit to be registered under ESIC as an IP (Insured Person)
2. Anyone whose whose salary is more than 21000 shall not be liable for ESIC deduction irrespective of his monthly earned salary depending upon his attendance.
I hope this clarify your doubts.
@@inspiredmate
Thanks for your response!!
But you have taken Paid Gross Salary Attribute for comparing with 21000 benchmark here. I think it should be compared with Gross Salary first ,then we will calculate with 1.75% (Employee Contribution) and 4.75(Employer Contribution) as per Monthly paid gross salary.
And what will be the employer's contribution to PF if basic goes beyond 15K where employees contribution can be capped with 1800.
If I am wrong then please clarify. In this part I have doubt.
Could i get this dummy salary sheet ?
Yes, send me a test mail at inspiredmate@gmail.com, i'll share the sheet.
For ESIC calculation what should we use Gross salary or Paid Gross salary?
Gross salary..
@@inspiredmate Thank you
I have one doubt,,,,,for example Gross 22000/- employee attendance 25 days present then payable gross example 18000/- then shall we deduct esi for this month ....if 31 days present in Jan 2021 here gross payable 22000/- so no need to deduct esi...clarify esi deduction gross r payable gross...sometime employee total present esi not eligible... sometime employee total not present esi get eligible....if it happeneds such like that employee not get all esi facilities , please clear my doubt
Employee's esi eligibility depends on Full gross only, if Full gross is more than 21k employee is not eligible for esi, if the paid gross becomes less than 21k because of absents then also the employee is not eligible for esi.
@@inspiredmate
Sir.....Here u r not calculate esi on full gross .......u r calculate esi on paid gross salary...once check....
Kindly make a video Salary Breakup also...
@@inspiredmate tq for reply.can u please make revised video
You forgot to deduct tds and pt
WHY ARE YOU MENTIONING SALARY RATE AS GROSS SALARY?....That is either Package or CTC break up Or Rate of Salary.