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?
@surajsahu4585
4 жыл бұрын
Sir you make video SRPK card related and What is SRPK card How to use SRPK card What is benefit Please I request you
@LabourLawAdvisor
4 жыл бұрын
Anytime till 1 year
@pritysingh4556
4 жыл бұрын
Sir,AAP achha btate ho...PR bhut fast fast bolte ho
@rohitchauhan7591
4 жыл бұрын
Sir is gratuity available if employee work different company of the same group??????
@gootergoon
4 жыл бұрын
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.👍👍👏👏
@rk311089
4 жыл бұрын
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
@pompadutta15
2 жыл бұрын
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...🍫🎶⚘
@karangoyal7687
3 жыл бұрын
You have done mistake while calculating PF @ 12%. PF is deducted only when salary is upto 15000.
@preetiverma4226
2 жыл бұрын
Thaty i confused
@vishalshaw9387
2 жыл бұрын
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 🙏
@madhu.8
Жыл бұрын
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
@aedpehtkshashidhar6944
Жыл бұрын
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?
@dilipparmar1912
Жыл бұрын
Maximum Amount is 1800,
@nexttarget961
3 жыл бұрын
Sir I am so inspired by your channel content, I am watching all videos gradually and great respect for you🙏🙏
@albatross560
3 жыл бұрын
This is really helpful. Thank you so much for sharing.
@IshaqAAdam-td3nv
2 жыл бұрын
Thank you so much Sir this is very important to me i really appreciate
@sreerajsiva5816
4 жыл бұрын
PF will charge maximum for Rs.15,000 only. Ie. Maximum of Rs.1800.
@legendsathya3041
3 жыл бұрын
Not really, if a employee wishes to contribute more, He can
@tanujajampana899
3 жыл бұрын
Sir these are best videos for my carrier please provide with English subtitles unable to understand hindi
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.
@lipaghosh135
Күн бұрын
Thank you 🙏🏻
@sheshnathkumar1184
3 жыл бұрын
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.
@user-yt6wf4fs7c
10 ай бұрын
Accounts=What comes in and what goes out....And calci also
@punitsharma_11
3 жыл бұрын
Kai der me badiya video mili
@jitendrachauhan661
3 жыл бұрын
Thank you so much Sir, Tha Best Explanations.👍👍👍
@ratandeepmishra1830
3 жыл бұрын
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.
@aadyaaadhviksharma5365
4 жыл бұрын
very good sir, i am doctor but now i can make payroll for my hospital
@ramraut5285
3 жыл бұрын
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.
@kirtisingh2593
3 жыл бұрын
@@ramraut5285 how can learn properly....
@divyatharani5476
3 жыл бұрын
I learned a lot today....
@parassharma9694
3 жыл бұрын
Excellent explanation sir
@azizahmedmakrani9864
Жыл бұрын
Excellent lecture..
@beingraza78692
2 жыл бұрын
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...????
@mineshmakwana3905
2 жыл бұрын
Pf ceiling amount is 15000 and maximum pf 1800 rs would be deduct from employees ac..
@srigane4719
3 жыл бұрын
Really good video gor4 payroll beginners thanks.PLZ
@pradeepbarik6484
3 жыл бұрын
Thanku so much sir
@kalaivanik6950
Жыл бұрын
Thank you Sir, please suggest about basic salary
@krishnamoorthy5953
Жыл бұрын
Thank you so much sir ❤
@soumyaranjanpradhan6465
4 жыл бұрын
Best video.
@aslamkhan-xk9pf
3 жыл бұрын
Can you send me your contact number
@aslamkhan-xk9pf
3 жыл бұрын
Hello
@aslamkhan-xk9pf
3 жыл бұрын
Can you send me your contact number
@ranvirrkp9592
2 жыл бұрын
This is a good idea 👌🏻 sir
@deepacharya2884
2 жыл бұрын
Excellent Video 👍🏻
@vijaykumar-nt3hd
2 жыл бұрын
Thank you so much ✔️👍
@imtiaz2043
3 жыл бұрын
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
@halfdinner8044
3 жыл бұрын
Thank you Sir, please being more on Hr software
@sanjayabehera5625
5 ай бұрын
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.
@ranvirrkp9592
2 жыл бұрын
I am also Computer Operator sir
@Amitpandey0703
4 жыл бұрын
Good job sir ji
@cupidsalman100
4 жыл бұрын
Cool
@udaykumar-on9si
9 ай бұрын
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
@purnimasahoo9789
4 жыл бұрын
Awesome vdo....sir tnx a lot for this vdo...
@brijendrarajpoot6971
10 ай бұрын
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
@mahiswa143
10 ай бұрын
According to factories act 1948 He did 4 hours OT then he will get twice of actual wage rate
@surajsahu4585
4 жыл бұрын
Sir you make video SRPK card related and What is SRPK card How to use SRPK card What is benefit Please I request you
@prafulroy9716
2 жыл бұрын
Wo sab tp theek hai video bahut accha hai ,Lakin june 30 ka kabse hone lga?
@laxmisharma2134
3 жыл бұрын
Great work 👍..
@bantikhan8380
4 жыл бұрын
Thanku sir
@anshikarai8406
2 жыл бұрын
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%
@gayathrir4198
2 жыл бұрын
Esi formula can be much better... first is round of the amount. Hiding unhiding may create mistakes in esi..use less than formula
@RailOnTheWay
4 жыл бұрын
Thanks sir
@shaikaslam9327
4 жыл бұрын
Excellent.
@gurirtx
Жыл бұрын
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?
@pranjalitiwari14may
3 жыл бұрын
Thanks for sharing sir
@utkarshpagade2385
4 жыл бұрын
Sir, Please make video on Whether gratuity is payable to contract labour? If yes, Who is responsible for payment? Contractor or Principal employer?
@LabourLawAdvisor
4 жыл бұрын
Contractor
@naseemhussain741
3 жыл бұрын
Bbll apne samjhaya wow
@karthikeyanj725
3 жыл бұрын
very clear thanks
@thtunesthewaves2122
4 ай бұрын
Govt. Compliance ke according pf 1800 se jyada nahi katna chayie.. min wage 15000 ki honi chaiye
@tulajaramram976
3 жыл бұрын
Excellent Boss
@basharatali3903
2 жыл бұрын
Great work
@sakthikannan6816
3 жыл бұрын
Thank you
@anveshsaxena4602
3 жыл бұрын
RAM RAM ❤️
@bhagyaanant1127
3 жыл бұрын
Sir our new employee's salary is 18000/- pm. His Basic is 12000, HRA is 4000/- and other allowance 2000/-. Now I want to know if it is mandatory to give him PF facility ir it is optional because his total salary is above 15,000/-
@namrataquick
2 жыл бұрын
Hi PF can only be optional if the employee never had UAN no ever . If in past employment he had a UAN number then it is compulsory to have a PF account number.PF can be basic 1800*12 or 12% on basic 15000/-
@bluecoreavsk
Жыл бұрын
My dear PF is not optional...must pay
@bluecoreavsk
Жыл бұрын
@@namrataquick it's mandatory...uan no has no role
@imranasiddiqui6904
Жыл бұрын
It's mandatory....he is eligible for pf
@bravehearter9312
4 ай бұрын
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
@vinithaprasannan4134
4 жыл бұрын
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?
@vinithaprasannan4134
4 жыл бұрын
If an employee s took leave along with holidays ,then how to calculate their salaries?. Can you give reply?
@goodies3340
3 жыл бұрын
Pls make detailed video on salary calculations alongwith comparatio
@shashikalabhat7169
2 жыл бұрын
Is pf applicable above 35000 salary
@mr.dnmaurya_gkp
4 жыл бұрын
Great..,🙏🙏
@mohdasif-zf3xb
8 ай бұрын
my sikhaunga matlab aap ki team ya phir genuie aap shikhayengey yani explained by you only?
@dagbahadurmagardagbahadur2044
2 жыл бұрын
Good information
@SKJ5EDITZ
4 ай бұрын
TQ sir
@rajeshmourya3891
Жыл бұрын
Sir maximum pf deduction is 1800/- only
@amanpandey1915
3 жыл бұрын
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.
@rkgnews9521
3 жыл бұрын
Very nice video
@saradadei6524
3 жыл бұрын
Sir thanks for video.. jinka sal jyada hai kya uko jyada faida hoti hai Esic se?
@aRVINDKumar-pg8qv
3 жыл бұрын
what is exact formula calculating of LWF please Elaborate in the above sheet
@kishorekishi937
3 жыл бұрын
How organisations functioning the payroll On software or Excel sheets? Does it have any specific tools or not? Or Just Excel sheets?
@kash9309
19 күн бұрын
Sir pls is video la updateed version dalo sir pls ye video 4 saal purani hain❤❤❤
@qualityhubemaghuman2364
4 жыл бұрын
Great sir🙏
@hafeesification
Жыл бұрын
Hello Sir, After new wage introduction the entire definition of wage( pf,esi) changed. I have doubt is HRA is exception in ESI or not.
@vijaypatel785
Жыл бұрын
Awesome 👍
@vishalkumar-jj4qp
2 жыл бұрын
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 ?
@aviksaha2682
2 жыл бұрын
Please suggest a formula in excel that a perticular date the basic salary will be automatically changed
@rohitakumari4862
Жыл бұрын
Sare Business MANs ki Balance Sheet govt(Supreme Court) Handle krega abse Appoint working DEPT. Hello Rahul ji kese h ap
@vedanayagam5944
4 жыл бұрын
pay slip Basic and EPF basic should we maintain in same value ah sir??
@anamikasamanta2210
3 жыл бұрын
Which allowances are includes in EPF contribution and which not?
@Brahmo_
2 ай бұрын
Sir professional tax, Delhi and Haryana mein nahi applicable hai toh, usse phir deduct kare ya nahi? Ager firm haryana registered hai toh
@rajeshbadhei2489
3 жыл бұрын
Thank u sir
@ramnarayansindhu9949
4 жыл бұрын
Good luck
@RASMIMISHRA786
3 жыл бұрын
Nice useful video.👍 But PF 1800 se jyada nahi hona chahiye🤔
@anilscorner3960
Жыл бұрын
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
@NavinKumar-ie5ye
2 жыл бұрын
Company people blue dress 😁😁😁😁
@Careeradices
2 жыл бұрын
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
@DeepakSharma-lw6jk
2 жыл бұрын
Best Yaar
@ramizmalek3048
4 жыл бұрын
Pf is fixed on 15000 and above is 1800?? But you deduct more than 1800 ? Is it possible??
@LabourLawAdvisor
4 жыл бұрын
Yes it is 100% possible :)
@rajgautam5282
3 жыл бұрын
Is there any eligibility criteria for Payroll course. Please advice. I am from BA background.
@vikkysran6192
2 жыл бұрын
Sir ABCD format par video bna do
@vivekchoubey3197
4 жыл бұрын
Sir payroll k complete video banao sir jisme pf esi sabka complete ho but ye b achi video h
@LabourLawAdvisor
4 жыл бұрын
Please checkout course in link, in 45 lectures I have taught everything
@lonelyMan_1312
4 жыл бұрын
ye file discription me bhi de dete
@taniyagupta3648
3 жыл бұрын
Jese aapne btaya ki esi m 21000 limited h salary ...sir ese hi pf m bhi toh 15000 limited h
@hotelsresortsingilgitbalti1101
2 жыл бұрын
Great
@arunehsolutions4001
2 жыл бұрын
KYA HRA,SPAICIAL ALLOAWNCE KA RAGISTRATION KARVA PADTA HAI AOR KARVATE HAI TO KAHA JIS TARH SE PF KA RAGISTRATION KARVATE HAI
@bindesharmukhia7473
2 жыл бұрын
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
@abhishekpandey2624
4 жыл бұрын
Sir maine apna final Pf settlement kiya mujhe amount credit ho gaya hai lekin vo kam hai Pf- 140657+43021 = 183678 Pension- 7753+66340 = 74093 Mujhe mila - 183678+55182 Baki pension ka remaining paisa kidhar gaya sir maine form 15g bhi bhara tha Sir main ek link attach kar raha hun( passbook) for better understanding ise dekhe aur please bataye drive.google.com/folderview?id=1qrqJGpGUp-nTsJ7CJUkyN4fS5o39y69p
Пікірлер: 374