Тёмный

🔴How to make Payroll in Excel for beginners | Payroll Calculation as per Labour Laws 

Labour Law Advisor
Подписаться 5 млн
Просмотров 802 тыс.
50% 1

Опубликовано:

 

15 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 381   
@LabourLawAdvisor
@LabourLawAdvisor 4 года назад
PAYROLL & EXCEL COURSES: labourlawadvisor.in/link/LPTI DEMAT ACCOUNT: link.labourlawadvisor.in/demat QuickPayroll: quickpayroll.in/
@abd9267
@abd9267 4 года назад
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
@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
@LabourLawAdvisor 4 года назад
Anytime till 1 year
@pritysingh4556
@pritysingh4556 4 года назад
Sir,AAP achha btate ho...PR bhut fast fast bolte ho
@rohitchauhan7591
@rohitchauhan7591 4 года назад
Sir is gratuity available if employee work different company of the same group??????
@gootergoon
@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.👍👍👏👏
@pompadutta15
@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...🍫🎶⚘
@prafulroy9716
@prafulroy9716 2 года назад
Wo sab tp theek hai video bahut accha hai ,Lakin june 30 ka kabse hone lga?
@gurirtx
@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?
@beingraza78692
@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...????
@brijendrarajpoot6971
@brijendrarajpoot6971 Год назад
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
@mahiswa143 Год назад
According to factories act 1948 He did 4 hours OT then he will get twice of actual wage rate
@vishalkumar-jj4qp
@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 ?
@TheMarwariSiblings
@TheMarwariSiblings 4 месяца назад
Sir professional tax, Delhi and Haryana mein nahi applicable hai toh, usse phir deduct kare ya nahi? Ager firm haryana registered hai toh
@rk311089
@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
@saradadei6524
@saradadei6524 3 года назад
Sir thanks for video.. jinka sal jyada hai kya uko jyada faida hoti hai Esic se?
@amanpandey1915
@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.
@anilscorner3960
@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
@tanujajampana899
@tanujajampana899 3 года назад
Sir these are best videos for my carrier please provide with English subtitles unable to understand hindi
@saleshthakur5081
@saleshthakur5081 3 года назад
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 🙏
@struggle_self_believe
@struggle_self_believe Год назад
Sir, Jiske 21000 se jyada ho uske ESI ke replace me kya deduction milegi?
@kalaivanik6950
@kalaivanik6950 2 года назад
Thank you Sir, please suggest about basic salary
@rohitakumari4862
@rohitakumari4862 Год назад
Sare Business MANs ki Balance Sheet govt(Supreme Court) Handle krega abse Appoint working DEPT. Hello Rahul ji kese h ap
@jaishreepareek8247
@jaishreepareek8247 Месяц назад
Is there any certificate provided for payroll course and Excel course?
@chandiprasadmohanty4336
@chandiprasadmohanty4336 2 года назад
Sir what is the salary calculation mode on Februaru...
@anjalikhanna5911
@anjalikhanna5911 2 года назад
I am a beginner in payroll. I have few douts. How I can get in touch with you
@bravehearter9312
@bravehearter9312 6 месяцев назад
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
@mohdasif-zf3xb
@mohdasif-zf3xb 9 месяцев назад
my sikhaunga matlab aap ki team ya phir genuie aap shikhayengey yani explained by you only?
@IshaqAAdam-td3nv
@IshaqAAdam-td3nv 2 года назад
Thank you so much Sir this is very important to me i really appreciate
@Careeradices
@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
@nexttarget961
@nexttarget961 3 года назад
Sir I am so inspired by your channel content, I am watching all videos gradually and great respect for you🙏🙏
@bindesharmukhia7473
@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
@kundansharma7766
@kundansharma7766 Год назад
For gratuity and leave encashment, Is it 26 days or 30 days? Also if the company is denied a 26 day calculation then how can we approach
@imranasiddiqui6904
@imranasiddiqui6904 Год назад
For gratuity 26 days
@punitsharma_11
@punitsharma_11 3 года назад
Kai der me badiya video mili
@aadyaaadhviksharma5365
@aadyaaadhviksharma5365 4 года назад
very good sir, i am doctor but now i can make payroll for my hospital
@ramraut5285
@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
@kirtisingh2593 3 года назад
@@ramraut5285 how can learn properly....
@starwhitesdemo
@starwhitesdemo 4 года назад
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
@udaykumar-on9si
@udaykumar-on9si 11 месяцев назад
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
@manglesh08
@manglesh08 4 года назад
Sir agar kisi company me 20 se km employees he,or company apni marzi se pf registration le, to kya wo 15000 ki ceiling limit pr PF n cut kr actual salary pr PF cut kr skti he, link 9 employee he or sbhi ki salary 10000 avg. He to sbke liye 10000 ka 12% 1200 ke hisab se PF cut krne ka option he ?
@sanjayabehera5625
@sanjayabehera5625 7 месяцев назад
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.
@arunehsolutions4001
@arunehsolutions4001 2 года назад
KYA HRA,SPAICIAL ALLOAWNCE KA RAGISTRATION KARVA PADTA HAI AOR KARVATE HAI TO KAHA JIS TARH SE PF KA RAGISTRATION KARVATE HAI
@Ashvanikashyap-dh3gl
@Ashvanikashyap-dh3gl Месяц назад
PF calculation If basic+da
@Indra_Kumar3102
@Indra_Kumar3102 3 года назад
Sir over time me esi jma hoga ya nhi over time mikaker 21000 se jyada salary ban rhi hai
@anshikarai8406
@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%
@sheshnathkumar1184
@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.
@ferozkhan4094
@ferozkhan4094 3 года назад
Esi over time per dedicated hota hai kay
@imtiaz2043
@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
@virendarji6135
@virendarji6135 3 года назад
Hi sir salary me pf ke Alava Employer Complaince cut ho raha he wo kya he?
@ratandeepmishra1830
@ratandeepmishra1830 4 года назад
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.
@syedtalha8146
@syedtalha8146 3 года назад
Hello sir Ek query , meri basic salary 8000 hai par Hr wala pf 22000 par calculate karte . Sir please is regarding notifications hai kya .please solve my problem
@srigane4719
@srigane4719 3 года назад
Really good video gor4 payroll beginners thanks.PLZ
@rajendraprajapati2482
@rajendraprajapati2482 3 года назад
UAN NUMBER registration karne pe he manthly wages kitna filling krna he
@vinithaprasannan4134
@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
@vinithaprasannan4134 4 года назад
If an employee s took leave along with holidays ,then how to calculate their salaries?. Can you give reply?
@ranvirrkp9592
@ranvirrkp9592 2 года назад
This is a good idea 👌🏻 sir
@durgeshsahu219
@durgeshsahu219 Год назад
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
@saifimohd54
@saifimohd54 3 года назад
sir as per labour law monthly salary calculate in 30 days ya 26 days
@rupamajumder2423
@rupamajumder2423 3 года назад
Sir... H.S pass candidate direct payroll e experience doura ja sakti hai kaya ?? Plz reply
@sunilyadav-nj8oh
@sunilyadav-nj8oh 3 года назад
Sir Kya pf basic + DA par katta hai
@deeptitiwari-h1t
@deeptitiwari-h1t Год назад
Accounts=What comes in and what goes out....And calci also
@PoojaGupta-bo8tw
@PoojaGupta-bo8tw 4 года назад
Thank you! It's very helpful for me sir..🙏
@krishnamoorthy5953
@krishnamoorthy5953 Год назад
Thank you so much sir ❤
@albatross560
@albatross560 3 года назад
This is really helpful. Thank you so much for sharing.
@birjukumarlaheri2966
@birjukumarlaheri2966 3 года назад
Sir excel mei sales purchase kaise karte hain please bataye
@IrshadKhan-ck3eu
@IrshadKhan-ck3eu 3 года назад
Sir kisi employee ki salary 21000/- per month hai or Jan se uska increment 25000/- ho gya ho to Kya uska esic katega. Ya usko code 4 lekar out of coverage dikha denge
@preetiverma4226
@preetiverma4226 2 года назад
ESI ka 6 months limit structure hota h law
@aviksaha2682
@aviksaha2682 2 года назад
Please suggest a formula in excel that a perticular date the basic salary will be automatically changed
@rashmis8253
@rashmis8253 3 года назад
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.
@vinodgajare6735
@vinodgajare6735 Год назад
Is there overtime wages also in course
@DiptoG
@DiptoG Год назад
Hello Sir, Can I Get this file as in Practice Purpose?
@vijaykumar-nt3hd
@vijaykumar-nt3hd 2 года назад
Thank you so much ✔️👍
@devriyo9066
@devriyo9066 2 года назад
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
@parassharma9694
@parassharma9694 3 года назад
Excellent explanation sir
@subhashchaudhary3822
@subhashchaudhary3822 9 месяцев назад
Sir pvt LTD co. Me leave policy kya hoti hai
@mineshmakwana3905
@mineshmakwana3905 2 года назад
Pf ceiling amount is 15000 and maximum pf 1800 rs would be deduct from employees ac..
@OpulentNotions
@OpulentNotions Год назад
how can I get advise from you personally , What is your fees
@bhagyaanant1127
@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
@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
@bluecoreavsk Год назад
My dear PF is not optional...must pay
@bluecoreavsk
@bluecoreavsk Год назад
​@@namrataquick it's mandatory...uan no has no role
@imranasiddiqui6904
@imranasiddiqui6904 Год назад
It's mandatory....he is eligible for pf
@karangoyal7687
@karangoyal7687 3 года назад
You have done mistake while calculating PF @ 12%. PF is deducted only when salary is upto 15000.
@preetiverma4226
@preetiverma4226 2 года назад
Thaty i confused
@vishalshaw9387
@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
@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
@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
@dilipparmar1912 Год назад
Maximum Amount is 1800,
@kishorekishi937
@kishorekishi937 3 года назад
How organisations functioning the payroll On software or Excel sheets? Does it have any specific tools or not? Or Just Excel sheets?
@shilpisahu7852
@shilpisahu7852 4 года назад
I want to learn payroll.. can you provide online payroll course also
@LabourLawAdvisor
@LabourLawAdvisor 4 года назад
Yes complete.course available link in description
@arvindkhade9604
@arvindkhade9604 3 года назад
hi my card is not taking international payment can payment done through GP or paytm
@naseemhussain741
@naseemhussain741 3 года назад
Bbll apne samjhaya wow
@hafeesification
@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.
@tanujakadam2561
@tanujakadam2561 Год назад
Is this course is available? And where is location
@taniyagupta3648
@taniyagupta3648 3 года назад
Jese aapne btaya ki esi m 21000 limited h salary ...sir ese hi pf m bhi toh 15000 limited h
@sreerajsiva5816
@sreerajsiva5816 4 года назад
PF will charge maximum for Rs.15,000 only. Ie. Maximum of Rs.1800.
@legendsathya3041
@legendsathya3041 3 года назад
Not really, if a employee wishes to contribute more, He can
@rabindrasahoo4685
@rabindrasahoo4685 2 года назад
Sir For Daily Wages Salary How many days should calculate for payment in Month of February is it 24 or 26? Due January and April having 31 and 30 days but the wages salary calculation as per the 26 days
@ganeshkarsh7341
@ganeshkarsh7341 2 года назад
24
@narotamsingham4172
@narotamsingham4172 3 года назад
Sir I want learn about pay Roll because curruntly I am working as a Hr executive
@deepacharya2884
@deepacharya2884 2 года назад
Excellent Video 👍🏻
@avinashshukla7630
@avinashshukla7630 2 года назад
How can I get complete payroll course
@laxmankumardave6318
@laxmankumardave6318 3 года назад
मुझे यह बताने का कस्ट करे शॉप और एस्ट्सबलिशमेंट एक्ट के अन्तर्गत एरन लीव कितनी मिलती है और मैक्सिमम कितनी लीव कार्रईएड फॉरवर्ड हो सकती है
@aalim7750
@aalim7750 3 года назад
*Member Add kar raha hu to usme dikha raha hai UAN already generated in other company. Is situation me member ko kaise apni company me add karenge.??*
@sachinlohar15
@sachinlohar15 3 года назад
Salary slip me add craft kya hota he
@azizahmedmakrani9864
@azizahmedmakrani9864 Год назад
Excellent lecture..
@pradeepbarik6484
@pradeepbarik6484 3 года назад
Thanku so much sir
@deviyanikumar
@deviyanikumar 5 месяцев назад
Does this apply now also?
@ajeetsinghrohilla286
@ajeetsinghrohilla286 3 года назад
Rishabhji we want to know the pay Roll mathed how contact you.
@iopeducation9677
@iopeducation9677 3 года назад
Sir apka labour law ka koi course available h Jha pf esi and other law ko practically kse kerna h y bataya ho
@utkarshpagade2385
@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
@LabourLawAdvisor 4 года назад
Contractor
@dipeshchatterjee9016
@dipeshchatterjee9016 Год назад
Hello sir, as you dealing with labour law,can you please help me finding a placement consultancy aggreement copy.
@sakshisunilshindepari2819
@sakshisunilshindepari2819 4 года назад
I want to go for maternity leave but company said i wont avail for paid salary and i have checked with ESIC as well but cant able to avail for that bcoz my salary is more than 21 k so in this case what i have to do i ll be eligible for paid leave for not ???
@farhanansari9813
@farhanansari9813 4 месяца назад
Sir aapka payroll app kya hua?
@abdulazeemhca1156
@abdulazeemhca1156 2 года назад
Do we have courses for US payroll
@manojbora0
@manojbora0 Год назад
pf tho 1800 hi kat tha hai agar salry 15000 sai upar hai ???
@basharatali3903
@basharatali3903 2 года назад
Great work
@Amitpandey0703
@Amitpandey0703 4 года назад
Good job sir ji
@cupidsalman100
@cupidsalman100 4 года назад
Cool
@goodies3340
@goodies3340 3 года назад
Pls make detailed video on salary calculations alongwith comparatio
@shashikalabhat7169
@shashikalabhat7169 2 года назад
Is pf applicable above 35000 salary
@John_V-Shalom
@John_V-Shalom Год назад
Hello Sir! Can I get this prepared excel sheet format.
Далее
From ₹10/day to ₹5 Crores Net Worth?
16:25
Просмотров 1,3 млн
Dark Reality Of Going To US To Make More Money | Ep 25
19:29
Why Companies Prefer Resignation Over Termination
14:16