Sir I joined your excel course on 31st may 2020,but due to some personal reason I didn't even join the course but now I wanted to start it from now onwards. So Do I able to access it now?
I am a beginner nd learning computer from Aptech Admerit..some of the portion I am not able to complete so have taken help from your chanel...Thank you so much for your guidance..God bless you...🍫🎶⚘
Rishabh Sir, your oratory skills are exceptionally superb n impressive. And to top, the high standards of content quality make me never miss your and Mandeep Ji's videos ever since I subscribed to your channel. Keep it rocking guys...👌👌👌 I'm big fan of yours.👍👍👏👏
What about Roundup for ESI calculation, it will newer match until you use roundup formula. And also you haven't use round for your other fields, it will provide values in fraction, that will lead problems with actual figures
Gross me se esi pf less karne ke baad ush employee ki total working days calcutate karke total days jo ush month ki hai usse divide kiya jata hai tab nett salary nikalti hai.
Sir... Ek question hai.... Per month 50000 hai Annual salary 600000 hai... But employees ki salary per months 25000 ya 30000 banta hai to... Kiya tds fir kaise cut kare...????
Sir you calculated esic wrong. List of the wrongs 1, Not use round-up formula for accurate calculation 2, We've to deduct gross except Incentives, if the incentives are not fixed for every month
Sir shote business jaise coaching centre wo Kaya yeh rule follow kar skte like HRA EPF Bonuses etc ?? Yeh sab components salary slip mein add kar skte hain?
Rishav Sir, kya ap please employees k salary advance per month wali koi koi policy bna skte hai ,for staff k alag se and worker k alag s wo kitna advance lene ke liye eligible hai per month how to salary advance policy of staff ?
Dear Sir, Kya aap hamaare liye ek aisha video bana skte hai. Jaise ki ham excel me ek company ka payroll banaye(wages register) aur dusri sheet pe salary slip ban jaaye. Please sir.
Hello Sir, Your content is superb and your explanation skills are just fabulous. I need one advice regarding career, how to shift from HR Generalist role into only as an Payroll Department. Please guide. Awaiting for your response. Thank you.
Resubh sir, good morning, Please clear a doubt, If a worker work in his weekoff day His gross salary is 600 per day Than over time would be Rs. 1200. ? Whether to provide him compensatory holiday against the work in a week off day. And also what if same in national holiday.. ? Please sir guide me
Good ji but agar humko monthly salary project wise nikalni ho to like workers are working at different projects then how v calculate salary including ot
I prepared payroll of security companies, I want to know that guards shuffle regularly from location and every location had different salary rate and also guards work in month on different location how to get not over 30 days or 31 days kindly help me
How told you 🙄 when basic is upto 15000 then pf will be deducted and if employer want to give the benefit of pf to employee then they can provide irrespective of salary Thanks hope you got 🙏
Sir hamre school m ek madam ki death 17/04/2021 ko morning m 8am p huwa to uski salary or epf challan monthly wala kaisa baanega pls reply kar k bata dijiye 🙏
Sir, 30 days and some months and 31 days in some month.Then how to calculate salary .For IT companies which is choose 30 or 31 days ?. If Saturdays and Sundays are off then it will take for salary calculation?
PAYROLL & EXCEL COURSES: labourlawadvisor.in/link/LPTI
DEMAT ACCOUNT: link.labourlawadvisor.in/demat
QuickPayroll: quickpayroll.in/
Sir I joined your excel course on 31st may 2020,but due to some personal reason I didn't even join the course but now I wanted to start it from now onwards. So Do I able to access it now?
Sir you make video SRPK card related and
What is SRPK card
How to use SRPK card
What is benefit
Please I request you
Anytime till 1 year
Sir,AAP achha btate ho...PR bhut fast fast bolte ho
Sir is gratuity available if employee work different company of the same group??????
I am a beginner nd learning computer from Aptech Admerit..some of the portion I am not able to complete so have taken help from your chanel...Thank you so much for your guidance..God bless you...🍫🎶⚘
Rishabh Sir, your oratory skills are exceptionally superb n impressive. And to top, the high standards of content quality make me never miss your and Mandeep Ji's videos ever since I subscribed to your channel. Keep it rocking guys...👌👌👌
I'm big fan of yours.👍👍👏👏
Perfect Tutorial !!!!!
Kai der me badiya video mili
What about Roundup for ESI calculation, it will newer match until you use roundup formula.
And also you haven't use round for your other fields, it will provide values in fraction, that will lead problems with actual figures
Sir these are best videos for my carrier please provide with English subtitles unable to understand hindi
very good sir, i am doctor but now i can make payroll for my hospital
Please do not use this excel. they have not mentioned the PF and esic part of the employer. This is totally wrong information they have shared.
@@ramraut5285 how can learn properly....
Thank you so much Sir this is very important to me i really appreciate
Thank you Sir, please suggest about basic salary
Sir, plz aap labor law k jitne v Act hai. Please aap os sub par vedio banake share kijiye, please. Vo bahut hi important hai ek HR k liye.
This is really helpful. Thank you so much for sharing.
Sir I am so inspired by your channel content, I am watching all videos gradually and great respect for you🙏🙏
Gross me se esi pf less karne ke baad ush employee ki total working days calcutate karke total days jo ush month ki hai usse divide kiya jata hai tab nett salary nikalti hai.
This is a good idea 👌🏻 sir
Really good video gor4 payroll beginners thanks.PLZ
Excellent explanation sir
PF calculation
If basic+da
Thank you! It's very helpful for me sir..🙏
Accounts=What comes in and what goes out....And calci also
Sir... Ek question hai.... Per month 50000 hai Annual salary 600000 hai... But employees ki salary per months 25000 ya 30000 banta hai to... Kiya tds fir kaise cut kare...????
Thank you so much sir ❤
Sir you calculated esic wrong.
List of the wrongs
1, Not use round-up formula for accurate calculation
2, We've to deduct gross except Incentives, if the incentives are not fixed for every month
Excellent Video 👍🏻
Sir, As ref to the above video , please confirm those employees basic and Da above 15000 due to in this video pf calcutated above 15000.
Sir thanks for video.. jinka sal jyada hai kya uko jyada faida hoti hai Esic se?
Excellent lecture..
Sir Google pr ye concept h ki HRA attendance se affect nhi hota tiil the time ki leave bhot jyada time ki ho. Is it Right?
Sir shote business jaise coaching centre wo Kaya yeh rule follow kar skte like HRA EPF Bonuses etc ?? Yeh sab components salary slip mein add kar skte hain?
Thank you so much ✔️👍
Thanku so much sir
Rishav Sir, kya ap please employees k salary advance per month wali koi koi policy bna skte hai ,for staff k alag se and worker k alag s wo kitna advance lene ke liye eligible hai per month how to salary advance policy of staff ?
I am also Computer Operator sir
Integrated HR Solutions for START UP'S & MSME’S - Ample Leap
I learned a lot today....
Dear Sir,
Kya aap hamaare liye ek aisha video bana skte hai. Jaise ki ham excel me ek company ka payroll banaye(wages register) aur dusri sheet pe salary slip ban jaaye.
Please sir.
Pf ceiling amount is 15000 and maximum pf 1800 rs would be deduct from employees ac..
Thank you so much Sir, Tha Best Explanations.👍👍👍
Good job sir ji
Cool
Bbll apne samjhaya wow
PF will charge maximum for Rs.15,000 only. Ie. Maximum of Rs.1800.
Not really, if a employee wishes to contribute more, He can
Great work 👍..
Great work
Sir labour ka kya salary hota hai L. and T me
Aur contractor kya deta hai
Kitna sahi hota hai
Skill
Unskilled
Calculation samjha dijiye
Awesome vdo....sir tnx a lot for this vdo...
Excellent Boss
my sikhaunga matlab aap ki team ya phir genuie aap shikhayengey yani explained by you only?
Hello Sir,
Your content is superb and your explanation skills are just fabulous. I need one advice regarding career, how to shift from HR Generalist role into only as an Payroll Department. Please guide.
Awaiting for your response.
Thank you.
Sir professional tax, Delhi and Haryana mein nahi applicable hai toh, usse phir deduct kare ya nahi? Ager firm haryana registered hai toh
Wo sab tp theek hai video bahut accha hai ,Lakin june 30 ka kabse hone lga?
June 30 ka hi hota guru
Resubh sir, good morning,
Please clear a doubt,
If a worker work in his weekoff day
His gross salary is 600 per day
Than over time would be Rs. 1200. ?
Whether to provide him compensatory holiday against the work in a week off day.
And also what if same in national holiday.. ?
Please sir guide me
According to factories act 1948
He did 4 hours OT then he will get twice of actual wage rate
Thanks for sharing sir
Sir DA ka rule hi 12% katata h basic pr...
Example k liye hi shi 10% shi nhi tha.
Hra metro cities m 50% non-metro m 40%
Good information
Very nice video
Please suggest a formula in excel that a perticular date the basic salary will be automatically changed
Pls make detailed video on salary calculations alongwith comparatio
Is pf applicable above 35000 salary
Good ji but agar humko monthly salary project wise nikalni ho to like workers are working at different projects then how v calculate salary including ot
Sir what is the salary calculation mode on Februaru...
Best video.
Can you send me your contact number
Hello
Can you send me your contact number
very clear thanks
Thank you 🙏🏻
Awesome 👍
Esi formula can be much better... first is round of the amount. Hiding unhiding may create mistakes in esi..use less than formula
KYA HRA,SPAICIAL ALLOAWNCE KA RAGISTRATION KARVA PADTA HAI AOR KARVATE HAI TO KAHA JIS TARH SE PF KA RAGISTRATION KARVATE HAI
I prepared payroll of security companies, I want to know that guards shuffle regularly from location and every location had different salary rate and also guards work in month on different location how to get not over 30 days or 31 days kindly help me
You have done mistake while calculating PF @ 12%. PF is deducted only when salary is upto 15000.
Thaty i confused
How told you 🙄 when basic is upto 15000 then pf will be deducted and if employer want to give the benefit of pf to employee then they can provide irrespective of salary
Thanks hope you got 🙏
12% is applicable when your basic salary+DA is 15000 and which 15000*12%= 1800 and if even your basic+DA is exceed 15000 then also ₹1800 is applicable
You mean employer contribution not more than 1800 for any amount of salary exceeding 15000( pay+DA).
For this which clause of act is justified?
Maximum Amount is 1800,
Thank you Sir, please being more on Hr software
Sir you make video SRPK card related and
What is SRPK card
How to use SRPK card
What is benefit
Please I request you
PF is 1800 compulsory when salary is more than 15000
Thanks sir
Is there any certificate provided for payroll course and Excel course?
what to do when contractor not having EPF n ESI Registration , what to do skilled and unskilled labor are freelancers?How to pay epf and esi then
Esi over time per dedicated hota hai kay
Sir agr koi employee over time ya double duty krta h Or uski working days 31 se jyada ho jae to uski entry kaise krni h
Jese aapne btaya ki esi m 21000 limited h salary ...sir ese hi pf m bhi toh 15000 limited h
Sir excel mei sales purchase kaise karte hain please bataye
Thank you
Sare Business MANs ki Balance Sheet govt(Supreme Court)
Handle krega abse
Appoint working DEPT.
Hello Rahul ji kese h ap
RAM RAM ❤️
Sir maximum pf deduction is 1800/- only
Sir, Please make video on Whether gratuity is payable to contract labour? If yes, Who is responsible for payment? Contractor or Principal employer?
Contractor
Sir hamre school m ek madam ki death 17/04/2021 ko morning m 8am p huwa to uski salary or epf challan monthly wala kaisa baanega pls reply kar k bata dijiye 🙏
Thanku sir
Sir, Jiske 21000 se jyada ho uske ESI ke replace me kya deduction milegi?
I am a beginner in payroll. I have few douts. How I can get in touch with you
Sir payroll k complete video banao sir jisme pf esi sabka complete ho but ye b achi video h
Please checkout course in link, in 45 lectures I have taught everything
Excellent.
sir mere ko to ye sheet banana hain lekin yo deta ka jo sheet hay ye jayse ekh blank sheet hota haiin ye kaha se mile ga
Hi sir salary me pf ke Alava Employer Complaince cut ho raha he wo kya he?
Not the video I was looking for...
Sir Kya pf basic + DA par katta hai
How organisations functioning the payroll
On software or Excel sheets?
Does it have any specific tools or not?
Or Just Excel sheets?
Sir over time me esi jma hoga ya nhi over time mikaker 21000 se jyada salary ban rhi hai
Hi sir is it complusory to give 4 sunday week off and 2 paid leave like cl and ml to a person who is present only for 10 days . Kindly suggest us
Best Yaar
UAN NUMBER registration karne pe he manthly wages kitna filling krna he
Sir, 30 days and some months and 31 days in some month.Then how to calculate salary .For IT companies which is choose 30 or 31 days ?. If Saturdays and Sundays are off then it will take for salary calculation?
If an employee s took leave along with holidays ,then how to calculate their salaries?. Can you give reply?
Mujhe auto attendance sheet me kuch problem ho raha hai, month ko change karte hi jo A,P,H, hai wo next month me bhi apply ho ja Raha hai . Pls help
How to create pf and esic challan and calculat duty wise please