Salary in Excel | Salary Calculation in Excel | Payroll Calculation | in Hindi
ฝัง
- เผยแพร่เมื่อ 13 ธ.ค. 2024
- 📍Notification Center-
COMPLETE INDIA PAYROLL MANAGEMENT GUIDE | Part 1 • COMPLETE INDIA PAYROL...
📍Download Excel Salary Template - drive.google.c...
📍A Brief Intro:-
Preparing a payroll/salary of Indian company is not a cup of tea. One must have knowledge of salary structure, labor laws, industrial laws, income tax provision and other statutory compliance related to payroll.In this very first session of "INDIA PAYROLL MANAGMENT"we have explain about the Salary Structure & Statutory Compliances like PF, ESI, PT, Bonus, Gratuity & TDS and how to prepare salary in Excel.
Thanks for Watching
Have a great time
Regards,
Team FinTaxPro
📩Business Query & Collab - teamfintaxpro@gmail.com
#Salary #calculation #payroll #excel
📌Watch this video to learn below topics-
salary calculation in india excel
salary calculation excel sheet
excel for salary calculation
salary calculation sheet excel
salary calculation sheet in excel
salary calculation xls format
salary calculator india excel sheet
salary calculation in excel with formula
payroll calculation formula
payroll calculation example
payroll calculation in excel sheet
payroll calculation in excel sheet india
payroll salary calculation
payroll salary calculation formula
Salary Calculation in Excel
salary in excel in hindi
salary sheet in excel in hindi
salary sheet in excel with formula
salary sheet in excel with pf esi calculation
salary sheet in excel with formula in hindi
salary sheet in excel with overtime
salary calculation formula
salary calculation formula in excel sheet
salary calculation in excel
salary calculation of july 2020
salary ctc calculation excel
da in salary calculation
salary calculation excel
salary calculation excel sheet
salary calculation excel sheet format
epf salary calculation
excel sheet salary calculation formula
salary calculation for july 2020
pf salary calculation
pf salary calculation formula
pf calculation on salary in excel
Salary Calculation in Excel
pf deduction from salary calculation
pf calculation in salary in tamil
salary esi & pf calculation
gross salary calculation
how to salary calculation in excel
leave salary calculation formula
salary calculation method
salary calculation method in india
monthly salary calculation
calculation of salary
salary calculation pf deduction
salary calculation percentage
salary calculation sheet
salary calculation sheet in excel
salary calculation software in excel
salary calculation template
Salary Calculation in Excel
salary tax calculation
salary calculation with pf and esi
salary calculation xls format
tds on salary calculation 2018-19
how to do salary calculation in excel
how to salary calculation in excel
how payroll is calculated
payroll calculation in excel
Salary in Excel
payroll calculation tutorial
payroll calculation 2020
payroll calculation formula
payroll calculations in excel sheet
Salary Calculation in Excel
payroll calculation in excel sheet
payroll calculation excel sheet
payroll calculation excel template
payroll calculation formula in india
payroll calculation in excel sheet india
payroll calculation sheet
payroll salary calculation formula
Salary in Excel
payroll tax calculation spreadsheet
payroll calculation template
payroll calculation worksheet for ppp
payroll calculation worksheet
payroll calculation worksheet for ppp loan
payroll calculation formula
payroll calculations
payroll calculation example
payroll calculator for ppp
payroll calculation for payroll protection plan
payroll cost calculation for ppp
payroll calculation in excel
payroll calculation in excel sheet
payroll calculation in excel sheet india
payroll salary calculation
payroll salary calculation formula
payroll kaise banaye
salary kaise nikale
salary sheet kaise banaye
payroll component
Watch Part 1 of Payroll Series- th-cam.com/video/NJfPOuEkMIA/w-d-xo.html
Fantastic I am also HR in construction company I saw your video it is very informative Good
YOUR ALL VIDEOS ARE GREAT KNOWLEDGEBEL FOR US, WE ARE WAITING FOR NEXT VIDEOS FOR COMPLETE PAYROLL PROCESS.
You are the best teacher
Very well explained thank you so much
Nice video bro good communication skill.
THE SECRET CHANNEL Thanks dear, appreciate your support🙏. Hope you like the video🙂
Bro you best explanation
Very very thkns you for EPF double formula
thank you so much sir. very helpful for me.....
Glad it helps
Explained very well Vivek Sir
. Keep it up👍🏻
Sir salary sheet par video banao na please sir 🙏 aap bahut accha samjhate h sir please sir ek video sir 🥺
explained each and every point in depth , you made this video very informative and easy to understand for everyone even freshers without having any knowledge can start working after looking your video . keep making this kinda content and thanks to you for making it.
Respected Sir. keep doing good
Bhut bdiya bhai
VIKAS DUBEY Thanks. Hope you like it🙂
Your videos are so helpful
Super video sir
Appreciate your support dear. Hope you like the video🙂
Sir plz ek video ye bhi bna dijia jisme esi salary sheet ko computax office per import kiya ho sabhi employee ka fir net pay nikala ho 🙏
Sir 15k per pf days present ke according pf nh katega kya?
Sir any course on pf esi calculation and return ???
Sir, Can you please provide some links, where i can find the further process regarding depositing challans ecr where and how?
You may check this video for procedural part of payroll management. th-cam.com/video/NJfPOuEkMIA/w-d-xo.html
So helpful 😊
I think pf is calculate on earned salary n ESI calculate on gross salary.
Plz clarify this bec u calculate both on earned salary.
Thanks for the explanation..
Bonus is wrongly calculated. Bonus eligibility is based on monthly basic amount. If basic is less than 21000 then eligible or else not eligible.
Nice video sir.👍
Kindly make more informative videos for us.
Please explain how we accounting Gratuity entry in books as per mentioned payroll?
Gratuity is payable only when employee have completed 5 year of service in organisation.
Hence for employees who have completed 5 year gratuity shall be booked as expense & for employees who have not completed 5 years a provision need to create.
@@FinTaxPro Sir , On what basis Gratuity is calculated,when a employee works for 5 yrs.His Basic must be increased in the 5 years gradually,so we have to calculate all the 5 yrs different gratuity % and then add them?
Yes, Gratuity calculation is done on monthly basis & the accumulated balance is transfer to employee (or forfeited if employee left before time limit.
Very nice dear
Thank you so much 😊
good explanation.
Employee PF part will also comes under CTC?
Please explained if we have more 1 state where our employee work than . Is it wages act are different if yes where we get state wise rate for state wise employee. Thanks
Yes dear, Bonus calculation & Prof Tax calculation will be calculated state wise.
1. Bonus will change due to minimum wage requirements
2. Prof Tax rate will change because it is state specific tax & every state have different provisions & slab rates for Prof Tax.
Hope it helps
Team Fintaxpro 🙂
Hi, In my company we are giving sales incentive on monthly basis, amount depends on sale. After adding sales incentive gross salary cross 21k in month but in next month may below 21K. So can person eligible in ESIC ?
Sir apne esic Co kaise calculate kara. I am not talking about formula but the logic behind it
Employee contribution is 0.75 So the figure in ESI EMPLOYEE is 0.75 and company share is 3.25 so by applying the general math we reach on the figure
Sir hum if ka formula laga ke gross salary x 3.25 bhi too kar sakte hai?
@@gauravchandel7077 yes bilkul wo bhi kar sakte hai
Bas yahi confirm karna tha, thank you.
Sir can you please tell me what to write in the column of CTC?
Sir can you please explain TDS on salary for full year with absent, half salary,,nill salry, increment, because every month tds changes accordingly
Sir very nicely explain ... pls send excel format.
What is your mail id dear
@@FinTaxPro mukesh.fbil@gmail.com
Awesome
Glad you like it.
Sir net salary mai bonus bhi to include hoga na
Yes
ESI and PF of employer will be fix or it change as per attendance?
Explained very well Vivek. Keep it up👍🏻
CA Sonal Jindal Thanks Hope you like it.
Can you plz explain bonus again
Super Video, Keep Going on Bro, one small doubt in PF, IF PF
12% on basic pay + Da+ profit based salary
10:25 par figure ko round kaise karen sir?
Esi contribution 148.38. Hai usko round
Very Simple dear just add a formula of Roundup in the beginning, so that complete amount would be round off. But one point you must take care that always ROUND UP the amount because as per ESI Act amount must be round off to the NEXT nearest rupee. Hope it helps 🙂
Thanks Sir , liked the way u explained formation of formulas in video.
I am facing one issue from last one month that is not able to understand how to set basic salary HRA and gross salary...plz yha tk koi smgha de age mai smgh lugi
hra or special allowance how to calculate
Baground music bahut jayada sir
Kindly remove the background music ,it is very disturbing
Sir apne Lwf ka deduction khi nhi dikhaya
Will explain that in next video.
👍
send excel format sir please
pf exp min 500 limit
payble days kam hone pr hra kam kyu nhi hua?
sir plz one request don't put music on video beacause i can't focus on your voice.
Basic formula is not coming
Here is the Basic formula- Basic Salary/Total Number of Days*payable days
Hope it helps :)
Please remove background music it's irritating
Turn the music off!!!
Remove background music & thoda slow chaliye bahat fast ho raha h