EPF | Employee Provident Fund Act 1952 | PF Calculation in Excel Sheet

Поділитися
Вставка
  • Опубліковано 2 жов 2024
  • #pfact #providentfundact1952 #theemployeesprovidentfundsandmiscellaneousprovisionsact1952 #howtocalculatectc #howtocalculatecosttocompany #payrollprocessinginhr #payrollprocessinginindia #payrollprocessinginexcelsheet #hrexecutiveinterviewquestionandanswers #hrinteriewquestionandanswers #interviewquestionandanswers #skillstobecomehrexecutive #5skillstobecomehrexecutive #hrskills #hrexecutive #HRExecutive #HRExecutiverolesandresponsibilities #screening #coldcalling #hrrecruitercallingacandidate #howtocallacandidate #howtocallacandidateforthefirsttime #howtoscreencandidates #callingscript #coldcallingscript #sourcing #sourcinginrecruitment #sourcingpassivejobseekers #sourcingactivejobseekers #sourcesofrecruitment #sourcingprocessinrecruitment #internalsourcesofrecruitment #externalsourcesofrecruitment #hrrecruiterinterviewquestionandanswers #HRvocabulary #employeeattrition #attrition #bulkhiring #5waystodobulkhiring #masshiring #5waystodomasshiring #5skillstobecomeatalentacquisitionspecialist #skillstobecometalentacquisitionspecialist #talentacquisitionprocess #talentacquisitionsteps #HRgeneralist #15corefunctionsofHRgeneralist #functionsofHRgeneralist #rolesandresponsibiltiesofHRgeneralist #communicationskills #vocabulary #technicalround #HRround #5skillstobecomeHRrecruiter #skillstobecomeanHRrecuiter #recruiter #hrrecruiter #headhunting​​​​​​ #headhuntingprocess​​​​​ #processofheadhuntinginrecruitment​​​​​ #headhuntinginrecruitment​​​​​​ #headhuntingvsrecruitment​​​​​​ #humanresource​​​​​​​​​​​​​ #hr​​​​​​​​​​​​​ #hrexecutive​​​​​​​​​​​​​ #hrmanager​​​​​​​​​​​​​ #hrgeneralist​​​​​​​​​​​​​ #recruitment​​​​​​​​​​​​​ #recruit​​​​​​​​​​​​​ #qualifiedprofessionals​​​​​​​​​​​​​ #talentacquisition​​​​​​​​​​​​ #talentmanagement​​​​​​​​​​​​ #recuitmentandtalentacquisition​​​​​​​​​​​​ #onboarding​​​​​​​​​​​ #orientation​​​​​​​​​​​ #readytogetupdate​​​​​​​​​​​​​
    Humanresource​​​ | HR​​​ | The Employees Provident Funds and Provisions Act 1952 | Provident Fund Act | PF Act 1952 | The PF Act 1952 | HR Executive​​​ | Payroll Processing in Excel Sheet | How to calculate Cost to Company | Cost to Company | Payroll Processing in India | Payroll Processing in HR | HR Executive Interview Questions & Answers | Skills to Become HR Executive | HR Executive Roles & Responsibilities | HR Manager​​​ | HR Generalist | Screening Candidates | How to call a Candidate for the first time | Calling Script | Cold Calling Sourcing In Recruitment | Sourcing Passive Job Seekers | External Sources of Recruitment | Internal Sources of Recruitment | HR Recruiter Interview Questions & Answers | Employee Attrition | Attrition | Bulk Hiring | Mass Hiring | Talent Acquisition Process | Talent Acquisition Steps | 15 Core Functions | Roles & Responsibilities of HR Generalist​​​ | HR Recruiter | Skills to become HR Recruiter | 5 Skills to become Talent Acqusition Specialist | Recruiter | Recruitment​​​ | Recruit​​​ | onboarding​ | orientation​ | Job description | IT Recruiter | Recruiter | HR Recruiter #readytogetupdate​​​​​​​​​​
    Watch till end
    Previous video links👇
    Cost to Company | CTC | Payroll in Excel | Payroll Processing - Part 2 👇
    • Cost to Company | CTC ...
    How to make Payroll in Excel for beginners | Payroll Processing in India 👇
    • How to make Payroll in...
    HR Executive Interview Questions & Answers | HR Operations & Generalist 👇
    • HR Executive Interview...
    HR Executive | 5 Skills to Become An HR Executive 👇
    • HR Executive | 5 Skill...
    HR Executive | Roles & Responsibilities | 10 Functions of HR Exec 👇 • HR Executive | Roles &...
    HR Recruiter Calling Script |Call A Candidate for the First Time 👇
    • HR Recruiter Calling S...
    HR Recruiter | Screening | Recruiter Calling Script | 10 Tips for Cold Calling 👇
    • HR Recruiter | Screeni...
    HR Entry level Profile
    ua-cam.com/users/pl....
    IT Recruiter
    ua-cam.com/users/pl....
    HR Generalist
    ua-cam.com/users/pl....
    HR Terms
    ua-cam.com/users/pl....
    HR Jobs 👇
    ua-cam.com/users/pl....
    Job Application 👇
    ua-cam.com/users/pl....
    HR Recruiter 👇
    ua-cam.com/users/pl....
    Talent Acquisition 👇
    ua-cam.com/users/pl....
    Where do you see yourself in 5 years | Interview Question | Freshers & Experienced 👇
    • Where do you see yours...
    Interview Question : What are your Weaknesses | Freshers & Experienced 👇
    • Interview Question : W...
    HR Recruiter | Sourcing in Recruitment |Active Job seeker 👇
    • HR Recruiter | Sourcin...
    HR Recruiter | HR Recruiter Interview Question & Answers 👇
    • HR Recruiter | HR Recr...
    Interview Question : Tell me something about yourself | Freshers & Experienced 👇
    • Self Introduction : Te...
    Please do like, share and subscribe 🙏
    Thanks for visiting my channel🤗

КОМЕНТАРІ • 102

  • @raj_214
    @raj_214 2 роки тому +3

    Really you are amazing. Very basics and informative points you are clearing. I personally request you to please make a video on every act individual. We can earn deep knowledge. Thanks a lot for your effort.

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Thank you so much for your warm words 😊. Glad you found it informative.
      Keep watching daily sessions.
      Hope it will be helpful for you 👍.

  • @daisytesra8166
    @daisytesra8166 Рік тому +1

    Thanks for such a informative video...please make a video on attrition and how to calculate

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Glad you found it informative 😊.
      Thanks for writing.
      Please check session on Attrition from the playlists below 👇
      HR Terms/Vocabulary: ua-cam.com/play/PLleDoS2WOwnjl2IHvtuVICaEEiyOiL5VO.html
      Hope it will be helpful for you 👍.

  • @subhashishpanda4686
    @subhashishpanda4686 11 місяців тому

    Impressive teaching.

    • @readytogetupdate
      @readytogetupdate  11 місяців тому

      Many thanks 😊.
      Please check Statutory Compliances playlist for more useful sessions.
      Hope it will be helpful for you 👍.

  • @kaminiladdha4752
    @kaminiladdha4752 4 місяці тому +1

    Aap pf ke account bhi bataiye please

  • @xclusiveraj
    @xclusiveraj Рік тому +1

    Madam pls tell how to calculate pension and insurance payable to employees

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Thanks for writing 😊.
      Please check sessions from the playlists below 👇
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @Rp88569
    @Rp88569 2 роки тому +1

    Mam please conduct a sessions on
    PF forms and its procedure that will be helpful.please reply

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Sure. Sessions on PF are coming soon which will include above topics😊.
      Keep watching 👍

  • @vandanabansal9429
    @vandanabansal9429 2 місяці тому +1

    Calculation of EDLI is not correct in sheet where salary is less than 15000

    • @readytogetupdate
      @readytogetupdate  2 місяці тому

      Thanks for writing 😊
      Please check sessions from the playlist below 👇🏼
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍🏼.

  • @nareshsarvaiya7434
    @nareshsarvaiya7434 2 роки тому +5

    Very nice & easily explained,sister! 👍👏 Thank you very much for helping

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Thanks for your warm words 😊. Keep watching & sharing 👍.

    • @Rp88569
      @Rp88569 2 роки тому +1

      Nice explaination sister👌👌👌Thank you very much.Mam its request please also tell what are the types of forms is used in pf.
      Please reply

    • @readytogetupdate
      @readytogetupdate  2 роки тому +1

      One more session would be coming on PF Act which will include forms, online procedures, registration etc.
      Hope it will be helpful for you 👍.
      Thanks for your warm words 😊.
      Stay safe.

  • @renukashinde5237
    @renukashinde5237 Рік тому +2

    Ma'am aapne EDLI formula mai 1% ki jagah 12% se calculate kiya hai ..

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Thanks for writing 😊.
      Yes, please check payroll processing query session from the playlists below 👇
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @krittikasneha7359
    @krittikasneha7359 2 роки тому +3

    I have just started watching your videos, it's been 2,3 days and surprisingly I got these videos of yours...Amazing. Thanks

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Thanks for writing dear 😊. Keep watching & sharing. Best wishes 👍.

  • @namratatolani3123
    @namratatolani3123 6 місяців тому +1

    Columm T ka calculation samaj nai aaya
    Agar salary 15000 se up jai to 15000*1% aur agar salary 15000 se cum hai to 12%😮😮😮😮
    Aur column T kiski calculation hai?

    • @readytogetupdate
      @readytogetupdate  6 місяців тому

      Thanks for writing 😊.
      Please check these sessions 👇
      Payroll processing
      ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @defenceadda3507
    @defenceadda3507 Місяць тому

    Pls update all detail about it from starting For HR , like a statotary complinces , pf, esi, gradituty Etc payroll or book pls confirm?

  • @NamratAman
    @NamratAman Рік тому +1

    How to calculate payable days salary ? Please reply

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Thanks for writing 😊.
      Please check sessions from the playlist below 👇
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @Neesh25
    @Neesh25 Рік тому +1

    Hey, Can you give link to these Excel File so we can Download and Practice on our own! Thank You!

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Thanks for writing 😊.
      Sorry it's not available.
      Please check sessions from the playlist below 👇
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @iamking1095
    @iamking1095 Рік тому +1

    Ma'am pf challan kase banaya jata h please btayea please ma'am btayea

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Thanks for writing 😊. Would be doing session on this.
      Keep watching daily sessions.
      Hope it will be helpful for you 👍.

  • @anirbanghosh2510
    @anirbanghosh2510 Рік тому +1

    Thanks for the detailed explanation & example through Excel. Would like to point out a wrong formula in Column T (EPF + EDLI @ 1%) of excell.
    The formula in Column T should be 1% of Basic+DA or Rs 150, { That is -- =IF(SUM(G12:H12)

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Thanks for writing 😊.
      I agree that there are few rectifications required.
      I have done a payroll processing query session for this particular thing.
      Please check sessions from the playlist below 👇
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @trust932
    @trust932 Рік тому +2

    Mam EDLI KE. COLUMN ME APNE. Pf =1800+EDLI =150 RS. show kiya hai ye to samaj aa gaya but next row me apne 1310.40 +0 EDLI show kiya hai aisa kyo? Isme EDLI charges kyo nahi liye hai?

    • @bhavyasharma4275
      @bhavyasharma4275 8 місяців тому +1

      Employer section me EDLI jo calculate kia h..vaha 150 hai...ya sidha pf ka amount. Even i am confused.

    • @readytogetupdate
      @readytogetupdate  6 місяців тому

      Thanks for writing 😊.
      Please check these sessions 👇
      Payroll processing
      ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @0008nitish
    @0008nitish 10 місяців тому +1

    Hello , I am working for 3 years and now when I asked my HR team for introducing pf they say it is not possible in between,please help.

    • @readytogetupdate
      @readytogetupdate  6 місяців тому

      Hello, thanks for writing 😊.
      You can start from April onwards.

  • @kinjalpatel7472
    @kinjalpatel7472 9 місяців тому +2

    Thank you di... Keep updating us ❤

  • @raj_214
    @raj_214 2 роки тому +1

    Even I want the knowledge of forms which and when required. Please🙏

  • @heena0909
    @heena0909 Рік тому +1

    Hi
    It's very effective session but edls calculation is wrong from third row.

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Hello 😊 thanks for writing.
      Yes dear.
      Please check payroll processing query session from the playlists below to check corrections
      Payroll processing: ua-cam.com/play/PLleDoS2WOwnhIRsjSWn8X0IvSv4EjzsBQ.html
      Hope it will be helpful for you 👍.

  • @Sushy295
    @Sushy295 2 роки тому +1

    Very much useful information ur giving but can u do it in English dat could be really helpful for me

  • @amitsharma5308
    @amitsharma5308 Рік тому +1

    Hello ma'am
    As per epfo rules if employee get basic salary which is above 15000 then monthly pf deduction is 1800/- rupee a month but in our company it's not like that they deduct 12% rather it's less than 15000 or get more basic pay...
    So plz clear it.

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Hello 😊 thanks for writing.
      Yes as per rules it's Rs. 1800 for salary higher than Rs. 15000

    • @abvdakhilkumar952
      @abvdakhilkumar952 11 місяців тому +1

      Which company you are?

  • @Tarainchi
    @Tarainchi 2 роки тому +2

    Madam,
    Please discuss PF challan.

  • @shwetadornal2593
    @shwetadornal2593 2 роки тому +1

    Ma'am jiska bhi pf kata ho..toh 8.33 % compulsory katta h kya pension me.. ?

  • @monugarveet_k_0018
    @monugarveet_k_0018 Рік тому +1

    Mam make one video for how to fill bonus return.

  • @kishanregar6878
    @kishanregar6878 Рік тому +1

    Very nice I like it's very nice & your cute voice

  • @Sushy295
    @Sushy295 2 роки тому +1

    Could u plz do more video in pure English plz

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Yes 😊 Please check out my new English channel.
      Hope it will be helpful for you 👍.

  • @ankitapawar7970
    @ankitapawar7970 2 роки тому +1

    Not completed a mba so suggest it is required or any courses to do

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Many companies are hiring just graduates so please check eligibility criteria before applying for any job.
      Thanks for writing 😊.
      Keep watching 👍.

  • @iamking1095
    @iamking1095 Рік тому +1

    Ma'am please ESI act v btayea please

  • @ritapal7393
    @ritapal7393 6 місяців тому

    Very well described 👍

  • @akshaytyagi9558
    @akshaytyagi9558 2 роки тому +1

    Ma'am joom thoda jayada kar ke batYo to thik rahega kyoki proper nahi dekh raha hai

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Please check your connection it will be visible 😊. Thanks for writing.
      Keep learning 👍.

  • @hareeshyadav2769
    @hareeshyadav2769 2 роки тому +1

    Medam please explain in English

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Thanks for writing 😊. Please subscribe to my new English channel.
      Hope it will be helpful for you 👍.

  • @abhishekvyas1592
    @abhishekvyas1592 Рік тому +1

    Maam , can u pls share the file with us

  • @mychanel7978
    @mychanel7978 2 роки тому +1

    Mam mene MA HRM complete kiya hai Jamia Millia Islamia university se correspondence .
    Mai abhi already army me service kr rha hun
    Isse aage mai HRM ki field me koi correspondence course karna chahun ya certificate lena chahun to kon sa sahi rahegaa

    • @readytogetupdate
      @readytogetupdate  2 роки тому +1

      Lot of HR certifications & short term courses are running.
      While enrolling, please keep in mind following things :
      1) Curriculum of course
      2) Practical knowledge
      3) Certification body
      4) Placement opportunity
      Hope this will be helpful for you.
      Thanks for writing.
      Stay safe 👍

    • @mychanel7978
      @mychanel7978 2 роки тому +1

      So Mam please suggest me any one course which help me in my future

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      One session would be coming on HR courses in future. Keep learning 👍

  • @marinshekh5111
    @marinshekh5111 4 місяці тому +1

    nice cutipy

  • @shilpadhumal8647
    @shilpadhumal8647 2 роки тому +1

    Mam please pms module per ek vedio kijiye

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Thanks for writing 😊. Please check from channel playlists it's been already uploaded.
      Keep learning 👍.

  • @Fisha.writes
    @Fisha.writes 2 роки тому +1

    Hello ma'am . I am doing MBA in HR..
    So please guide me.. How can I get a job after MBA ☺☺

    • @readytogetupdate
      @readytogetupdate  2 роки тому +1

      Hi dear 😊 That's great.
      Please watch HR sessions from playlists on channel. I have made several sessions on how to get HR jobs which can be helpful for you.
      Keep learning & sharing 👍.

    • @karthiga9713
      @karthiga9713 2 роки тому +1

      Iam also have this quesin can u explain in English the viedo in hindi

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Please subscribe to my new English channel.
      Hope it will be helpful for you 👍.

    • @karthiga9713
      @karthiga9713 2 роки тому +1

      @@readytogetupdate thank u for ur replay mam, link send panuga for english chennal

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Hey guys,
      Check out this English session.
      Please subscribe
      ua-cam.com/video/KkotfL7bFTQ/v-deo.html

  • @tushartrk08
    @tushartrk08 Рік тому +1

    Thank you

  • @iamking1095
    @iamking1095 Рік тому +1

    Bhut bhut sukriya ma'am

    • @readytogetupdate
      @readytogetupdate  Рік тому

      Happy to help 😊. Thanks for writing.
      Keep watching daily sessions.
      Hope it will be helpful for you 👍.

  • @dikshagupta707
    @dikshagupta707 2 роки тому +1

    Please make video on epf and esic challan.

    • @readytogetupdate
      @readytogetupdate  2 роки тому +1

      Noted 😊. Coming soon. Keep watching 👍.

    • @dikshagupta707
      @dikshagupta707 2 роки тому +1

      @@readytogetupdate thanks for your response...I watched your video and find it really informative.. thanks for this....
      I have one doubt is any specific %ages for DA also...?

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      @@dikshagupta707 thank you so much 😊. No specific percentage as per Act.

    • @dikshagupta707
      @dikshagupta707 2 роки тому +1

      Remainder😅... I eagerly waiting for that series. Please manage some time from your busy schedule for this.

    • @readytogetupdate
      @readytogetupdate  2 роки тому

      Sure 😊. Thanks 👍

  • @vijaykumar-nt3hd
    @vijaykumar-nt3hd 2 роки тому +1

    👍

  • @catomet4936
    @catomet4936 8 місяців тому +1

    Haad bakwas bhar rakha hai video mein or content 4-5 min ka

    • @readytogetupdate
      @readytogetupdate  7 місяців тому

      Thanks for writing 😊.
      "I'm sorry to hear that you didn't like the video or content. Sometimes, the content may not meet our expectations. However, it's important to remember that everyone has different preferences. If you're looking for more detailed or concise content on a specific topic, you can search online or explore on a specific platform to find more suitable content. Everyone has different preferences, and it may take some time to find content that you enjoy."

    • @catomet4936
      @catomet4936 7 місяців тому

      @@readytogetupdate I'm not talking about your contact, your topic is good conteh have information but overspeaking on nonsense things is wasting our time.