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

Поділитися
Вставка
  • Опубліковано 24 січ 2025

КОМЕНТАРІ • 87

  • @FinTaxPro
    @FinTaxPro  4 роки тому +2

    Watch Part 1 of Payroll Series- ua-cam.com/video/NJfPOuEkMIA/v-deo.html

  • @HINDISERIES007
    @HINDISERIES007 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.

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

    Very well explained thank you so much

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

    You are the best teacher

  • @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🙂

  • @digiaad2693
    @digiaad2693 4 роки тому

    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.

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

    Bro you best explanation

  • @indrajeetsharma5688
    @indrajeetsharma5688 3 роки тому

    Explained very well Vivek Sir
    . Keep it up👍🏻

  • @parthpandya6557
    @parthpandya6557 4 роки тому +1

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

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

    Very very thkns you for EPF double formula

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

    Respected Sir. keep doing good

  • @kiaradas5064
    @kiaradas5064 3 роки тому

    Your videos are so helpful

  • @RakeshKumar-cj2mt
    @RakeshKumar-cj2mt 4 роки тому

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

  • @pateldhaval9998
    @pateldhaval9998 4 роки тому +1

    Super video sir

    • @FinTaxPro
      @FinTaxPro  4 роки тому

      Appreciate your support dear. Hope you like the video🙂

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

    So helpful 😊

  • @dubeyjispecial7107
    @dubeyjispecial7107 4 роки тому +1

    Bhut bdiya bhai

    • @FinTaxPro
      @FinTaxPro  4 роки тому

      VIKAS DUBEY Thanks. Hope you like it🙂

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

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

  • @sujitdipta
    @sujitdipta 4 роки тому

    good explanation.

  • @capremtiwari7409
    @capremtiwari7409 4 роки тому +1

    Very nice dear

    • @FinTaxPro
      @FinTaxPro  4 роки тому

      Thank you so much 😊

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

    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.

  • @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 🙏

  • @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.

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

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

  • @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. ua-cam.com/video/NJfPOuEkMIA/v-deo.html

  • @casonaljindal3655
    @casonaljindal3655 4 роки тому +1

    Explained very well Vivek. Keep it up👍🏻

    • @FinTaxPro
      @FinTaxPro  4 роки тому

      CA Sonal Jindal 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.

  • @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 🙂

  • @mukeshprajapati9673
    @mukeshprajapati9673 4 роки тому

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

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

    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 ?

  • @caaman93
    @caaman93 4 роки тому +1

    Awesome

  • @swatikirar4848
    @swatikirar4848 5 місяців тому

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

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

    Employee PF part will also comes under CTC?

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

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

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

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

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

  • @jayasingh1297
    @jayasingh1297 4 роки тому

    Can you plz explain bonus again

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

    I am facing one issue from last one month that is not able to understand how to set basic salary HRA and gross salary...plz yha tk koi smgha de age mai smgh lugi

  • @vashnavibhardwaj9626
    @vashnavibhardwaj9626 4 дні тому

    Why are you using + instead of=?
    Any Difference
    ?

  • @VinayKumar-yl7mf
    @VinayKumar-yl7mf 4 роки тому +1

    Sir net salary mai bonus bhi to include hoga na

  • @уманг
    @уманг 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.

  • @NaliniTiwari123
    @NaliniTiwari123 3 роки тому

    hra or special allowance how to calculate

  • @Shyam_7
    @Shyam_7 3 місяці тому

    👍

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

    pf exp min 500 limit

  • @RKOFFICIAL1992
    @RKOFFICIAL1992 3 роки тому +1

    Baground music bahut jayada sir

  • @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.

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

  • @MukeshKumar-rn3wf
    @MukeshKumar-rn3wf Рік тому

    payble days kam hone pr hra kam kyu nhi hua?

  • @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 Рік тому +1

    Please remove background music it's irritating

  • @lakechocolate9785
    @lakechocolate9785 4 роки тому

    Turn the music off!!!

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

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