Salary in Excel | Salary Calculation in Excel | Payroll Calculation | in Hindi

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 พ.ย. 2024

ความคิดเห็น • 85

  • @FinTaxPro
    @FinTaxPro  4 ปีที่แล้ว +1

    Watch Part 1 of Payroll Series- th-cam.com/video/NJfPOuEkMIA/w-d-xo.html

  • @M10Bhojpuri
    @M10Bhojpuri 3 ปีที่แล้ว

    Fantastic I am also HR in construction company I saw your video it is very informative Good

  • @joshiramesh50
    @joshiramesh50 2 ปีที่แล้ว

    YOUR ALL VIDEOS ARE GREAT KNOWLEDGEBEL FOR US, WE ARE WAITING FOR NEXT VIDEOS FOR COMPLETE PAYROLL PROCESS.

  • @AshaNavinaRathi
    @AshaNavinaRathi 3 หลายเดือนก่อน

    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 ?

  • @digiaad2693
    @digiaad2693 3 ปีที่แล้ว

    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.

  • @shubhamsahu5684
    @shubhamsahu5684 2 ปีที่แล้ว

    You are the best teacher

  • @swatikirar4848
    @swatikirar4848 2 หลายเดือนก่อน

    Sir 15k per pf days present ke according pf nh katega kya?

  • @syedyounuspsychologist4391
    @syedyounuspsychologist4391 2 ปีที่แล้ว

    ESI and PF of employer will be fix or it change as per attendance?

  • @shivanshuupadhayay
    @shivanshuupadhayay ปีที่แล้ว

    Employee PF part will also comes under CTC?

  • @skheena3140
    @skheena3140 10 หลายเดือนก่อน

    Very well explained thank you so much

  • @shrlkhm5159
    @shrlkhm5159 2 ปีที่แล้ว

    Sir any course on pf esi calculation and return ???

  • @sahusonukumar
    @sahusonukumar ปีที่แล้ว

    Bro you best explanation

  • @thesecretchannel701
    @thesecretchannel701 4 ปีที่แล้ว +2

    Nice video bro good communication skill.

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      THE SECRET CHANNEL Thanks dear, appreciate your support🙏. Hope you like the video🙂

  • @indrajeetsharma5688
    @indrajeetsharma5688 2 ปีที่แล้ว

    Explained very well Vivek Sir
    . Keep it up👍🏻

  • @kirkhammet6456
    @kirkhammet6456 2 ปีที่แล้ว

    Very very thkns you for EPF double formula

  • @Rich_blessings
    @Rich_blessings 4 ปีที่แล้ว +2

    Sir, Can you please provide some links, where i can find the further process regarding depositing challans ecr where and how?

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      You may check this video for procedural part of payroll management. th-cam.com/video/NJfPOuEkMIA/w-d-xo.html

  • @kiaradas5064
    @kiaradas5064 3 ปีที่แล้ว

    Your videos are so helpful

  • @intazaraalam9846
    @intazaraalam9846 4 ปีที่แล้ว +1

    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

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      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 🙂

  • @asifchouhan1423
    @asifchouhan1423 2 ปีที่แล้ว

    Respected Sir. keep doing good

  • @harishsingh8489
    @harishsingh8489 3 ปีที่แล้ว

    I think pf is calculate on earned salary n ESI calculate on gross salary.
    Plz clarify this bec u calculate both on earned salary.

  • @missneha1805
    @missneha1805 2 ปีที่แล้ว

    Sir salary sheet par video banao na please sir 🙏 aap bahut accha samjhate h sir please sir ek video sir 🥺

  • @parthpandya6557
    @parthpandya6557 3 ปีที่แล้ว +1

    thank you so much sir. very helpful for me.....

    • @FinTaxPro
      @FinTaxPro  3 ปีที่แล้ว

      Glad it helps

  • @santoshadal1999
    @santoshadal1999 11 หลายเดือนก่อน

    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.

  • @VinayKumar-yl7mf
    @VinayKumar-yl7mf 3 ปีที่แล้ว +1

    Sir net salary mai bonus bhi to include hoga na

  • @rahulgautam519
    @rahulgautam519 2 ปีที่แล้ว

    So helpful 😊

  • @pateldhaval9998
    @pateldhaval9998 4 ปีที่แล้ว +1

    Super video sir

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      Appreciate your support dear. Hope you like the video🙂

  • @RajaKumar-u3h7u
    @RajaKumar-u3h7u ปีที่แล้ว

    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 🙏

  • @anantharakesh2303
    @anantharakesh2303 3 ปีที่แล้ว

    Super Video, Keep Going on Bro, one small doubt in PF, IF PF

    • @FinTaxPro
      @FinTaxPro  3 ปีที่แล้ว

      12% on basic pay + Da+ profit based salary

  • @RakeshKumar-cj2mt
    @RakeshKumar-cj2mt 3 ปีที่แล้ว

    Nice video sir.👍
    Kindly make more informative videos for us.

  • @gauravchandel7077
    @gauravchandel7077 3 ปีที่แล้ว +1

    Sir apne esic Co kaise calculate kara. I am not talking about formula but the logic behind it

    • @FinTaxPro
      @FinTaxPro  3 ปีที่แล้ว

      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

    • @gauravchandel7077
      @gauravchandel7077 3 ปีที่แล้ว +1

      Sir hum if ka formula laga ke gross salary x 3.25 bhi too kar sakte hai?

    • @FinTaxPro
      @FinTaxPro  3 ปีที่แล้ว

      @@gauravchandel7077 yes bilkul wo bhi kar sakte hai

    • @gauravchandel7077
      @gauravchandel7077 3 ปีที่แล้ว

      Bas yahi confirm karna tha, thank you.

    • @gauravchandel7077
      @gauravchandel7077 3 ปีที่แล้ว

      Sir can you please tell me what to write in the column of CTC?

  • @dubeyjispecial7107
    @dubeyjispecial7107 4 ปีที่แล้ว +1

    Bhut bdiya bhai

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      VIKAS DUBEY Thanks. Hope you like it🙂

  • @intazaraalam9846
    @intazaraalam9846 4 ปีที่แล้ว +1

    Please explain how we accounting Gratuity entry in books as per mentioned payroll?

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      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.

    • @Rich_blessings
      @Rich_blessings 4 ปีที่แล้ว

      @@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?

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว +1

      Yes, Gratuity calculation is done on monthly basis & the accumulated balance is transfer to employee (or forfeited if employee left before time limit.

  • @capremtiwari7409
    @capremtiwari7409 4 ปีที่แล้ว +1

    Very nice dear

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      Thank you so much 😊

  • @mukeshprajapati9673
    @mukeshprajapati9673 4 ปีที่แล้ว

    Sir very nicely explain ... pls send excel format.

  • @naveen5344
    @naveen5344 3 ปีที่แล้ว

    Sir can you please explain TDS on salary for full year with absent, half salary,,nill salry, increment, because every month tds changes accordingly

  • @sujitdipta
    @sujitdipta 4 ปีที่แล้ว

    good explanation.

  • @caaman93
    @caaman93 4 ปีที่แล้ว +1

    Awesome

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      Glad you like it.

  • @jayasingh1297
    @jayasingh1297 3 ปีที่แล้ว

    Can you plz explain bonus again

  • @NaliniTiwari123
    @NaliniTiwari123 3 ปีที่แล้ว

    hra or special allowance how to calculate

  • @Shyam_7
    @Shyam_7 หลายเดือนก่อน

    👍

  • @casonaljindal3655
    @casonaljindal3655 4 ปีที่แล้ว +1

    Explained very well Vivek. Keep it up👍🏻

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      CA Sonal Jindal Thanks Hope you like it.

  • @nayanbadkar8680
    @nayanbadkar8680 2 ปีที่แล้ว

    pf exp min 500 limit

  • @NaliniTiwari123
    @NaliniTiwari123 3 ปีที่แล้ว

    send excel format sir please

  • @shrabantimajumder9687
    @shrabantimajumder9687 2 ปีที่แล้ว

    sir plz one request don't put music on video beacause i can't focus on your voice.

  • @MukeshKumar-rn3wf
    @MukeshKumar-rn3wf ปีที่แล้ว

    payble days kam hone pr hra kam kyu nhi hua?

  • @уманг
    @уманг 4 ปีที่แล้ว +1

    10:25 par figure ko round kaise karen sir?

    • @уманг
      @уманг 4 ปีที่แล้ว +1

      Esi contribution 148.38. Hai usko round

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      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 🙂

    • @уманг
      @уманг 4 ปีที่แล้ว +1

      Thanks Sir , liked the way u explained formation of formulas in video.

  • @RKOFFICIAL1992
    @RKOFFICIAL1992 3 ปีที่แล้ว +1

    Baground music bahut jayada sir

  • @bhartisehgal6991
    @bhartisehgal6991 3 ปีที่แล้ว +1

    Sir apne Lwf ka deduction khi nhi dikhaya

    • @FinTaxPro
      @FinTaxPro  3 ปีที่แล้ว

      Will explain that in next video.

  • @gamepark2930
    @gamepark2930 ปีที่แล้ว +1

    Kindly remove the background music ,it is very disturbing

  • @anirudhbijjur4271
    @anirudhbijjur4271 4 ปีที่แล้ว +1

    Basic formula is not coming

    • @FinTaxPro
      @FinTaxPro  4 ปีที่แล้ว

      Here is the Basic formula- Basic Salary/Total Number of Days*payable days
      Hope it helps :)

  • @Punk_wandy
    @Punk_wandy 10 หลายเดือนก่อน +1

    Please remove background music it's irritating

  • @lakechocolate9785
    @lakechocolate9785 3 ปีที่แล้ว

    Turn the music off!!!

  • @ExploreTheWorld_10
    @ExploreTheWorld_10 10 หลายเดือนก่อน

    Remove background music & thoda slow chaliye bahat fast ho raha h