Complete Salary Computation in Excel | Payroll calculation in excel

Поділитися
Вставка
  • Опубліковано 11 вер 2024

КОМЕНТАРІ • 174

  • @kuldeep.3012
    @kuldeep.3012 2 роки тому +3

    Sir aap mujhe pehle kyun nhi mile....aaj main kuch ban chuka hota but koi nahi kitne saal kharab ho geye ...lekin ab aap mil geye ho toh apki video se learn karke ek baar job mil jaye fir apke paid course mein se aur sikhunga ,......kyunki mujhe best accountant banna hai...but financial problem ke karan abhi bahut dikkat ho rahi hai aur jo current job hai woh bhi pta nahi kab tak hai......
    you are the best teacher..sir ji

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

    this is no doubt the best video of payroll on youtube . thank you very much for explaining each concept in detail.😀

  • @Sharma-hd4gm
    @Sharma-hd4gm 3 роки тому +2

    Amazing Chapter
    Dear Sir
    मैं अपनी लाइफ की पहली जॉब एचआर कोऑर्डिनेटर के रूप में कर रहा हूं तथा मेरी यह इच्छा थी कि मैं पैरोल एग्जीक्यूटिव बनू क्योंकि मैं लीगल के फील्ड से आया हुआ हूं इसलिए मुझे नहीं पता कि किस प्रकार से पैरोल का काम किया जाता है आपके द्वारा बनाई गई इस वीडियो को देखने की मुझे काफी हेल्प मिली है मैं बहुत जल्दी ही आपकी टैक्स डिडक्शन वाले भाग का हिस्सा बनना चाहूंगा
    आपके द्वारा किया गया कार्य अति सराहनीय है
    धन्यवाद

  • @Al-BAIK720
    @Al-BAIK720 2 роки тому +2

    Omg kitna bhi aapka thnks kare kam hai,you tube pe hmko ye milahi nhi aur hmko ye seekhna tha,i am in HR my frst job

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

    Sir aap etna achha explain karte ho ki hume kuch bhi knowledge nhi hoga to bhi hum hamara knowledge badha sakte hai, aapke video dekhne me bahut interest aata hai, hume practical knowledge milta hai, thank you so much

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

    Maja aa gaya sir
    I m also hr executive
    Actually this vedio is more important for fresher

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

    Kitna ache se smjhte hei sir thanks

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

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

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

    The way you teach is amazing literally...👍

  • @ISHMEETKAURISHMEETKAUR-fn8ct
    @ISHMEETKAURISHMEETKAUR-fn8ct 4 місяці тому +1

    Amazing way of explaining.. Thanks

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

    It's a complete vedio of payroll👍
    Thank you so much Sir

  • @sandipmagar7740
    @sandipmagar7740 9 місяців тому +1

    Thank you so much Sir for this very informative training session.

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

    Kya bat he sir ji thanks aap to mere guru ho sir ji 🙏

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

    It was completely informative....

  • @Anu-rx3ej
    @Anu-rx3ej Рік тому +1

    Thanks a ton.. You are saviour for all of us.

  • @gazalakhan2802
    @gazalakhan2802 3 роки тому +5

    Very easy and excellent explanation. Helped me a lot.

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

    If we have Teacher like you nothing is difficult thanks

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

    Really very educative in detail payroll very thankful to you Guru ji 🌹

  • @sid2638
    @sid2638 3 роки тому +6

    Dear Vievk ji...God Bless you. Distributing knowledge is the greatest service one can do... You are doing a great hob. It has no value... it is value less. Thank you

  • @user-uz9em1uo6o
    @user-uz9em1uo6o 8 місяців тому +1

    Very much Useful Vedio sir...Thanks

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

    wonderful! You are a really great teacher.Thank you for these videos.God bless you.

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

    really an amazing explanation 👍

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

    Thanks sir for sharing this valuable information and sharing notes

  • @patjoshitutorials6317
    @patjoshitutorials6317 3 роки тому +3

    Sir , Just Wow Complete Knowledge of salary preparation I really Enjoy this Topic and revise it , Salute to you Sir .

  • @the.artist7152
    @the.artist7152 2 роки тому +2

    Thanks sir for teaching us... ❤️ Keep growing sir on UA-cam....lots of love

  • @RajeshMD-iz7ks
    @RajeshMD-iz7ks Рік тому

    really a great explanation, I could learn the payroll calculation with explanation for it. Thank you for the session. May God Bless You

  • @furkanchaudhary7894
    @furkanchaudhary7894 3 дні тому

    thank you Dear.. Have a good day!!

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

    Sir....really i like your video clarity..usef execl formula to many more Accountant and practicing CA

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

      Glad you like it 😊

  • @Sharma-hd4gm
    @Sharma-hd4gm 3 роки тому +2

    Superb Video, I love this video

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

    Sir, you have really explained in detail, 🙏👍👏

  • @avishekmondal3353
    @avishekmondal3353 3 роки тому +4

    This channel is gem ❤️

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

      Glad you like our content

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

    Amazing Teaching skill.

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

    Thanks for giving free learning. The way you are explaining is excellent and easy to understand. Keep doing the good thing. May God bless u .

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

    Thanks you lot sir you have explained well tq so much 🤩

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

    I was looking for these kind of template with explanation
    Thank you very much sir

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

    You are amazing undoubtedly and explained this payroll in very detailed and easiest way to understand it, but...but I would like to tell you one thing which I hope you take as a Friends suggestion is that please don't stretch few things and try to cut short them for saving time rest you are cute there. Thanks as it has been so useful for me and would request you to share your link on TDS calculation you have made because I'm unable to search it here on youtube. Thanks once again for being helpful.

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

    Thanks for this video....

  • @PrakashSolanki-yh9uo
    @PrakashSolanki-yh9uo Рік тому

    wah good information in salary computation sheet, very very good video Jai Matadi

  • @sachinsingh-mv8px
    @sachinsingh-mv8px 3 роки тому +8

    Sir EPFO, ESIC Ka full video bnaye registration se lekar return filing tak

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

    sir kafi mast vedio h please make more vedios like this epfo,tds,pf complaince

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

    You are amazing and the way you teach every small thing is really appreciable.

  • @shaiena.shannu7424
    @shaiena.shannu7424 3 роки тому +2

    Thank you sir aapka video mujhe bohat useful he

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

    Thank you to make this video sir. It’s really very beneficial for me.

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

    Nice video sir very helpful 👍

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

    Excellent sir excellent explanation & thank you

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

    What an explanation sir 🙏👏🙌

  • @daredevil2606
    @daredevil2606 3 роки тому +6

    Right now i am doing audit of employee cost and i can relate all this concepts with my audit..Sir i request you to launch a course auditing also, just like you explained salary sheet, make videos for other areas such as Fixed asset register, how finacials are made in companies.

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

      Sure will definitely make videos on that.

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

    Best Video on UA-cam

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

    Very very useful video!

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

    Very nice session 👌

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

    🙏 great 🙏 super sir
    Jo bhi confusion tha sab clear ho gaya. Sir bas ek bat puchni thi ESIC rate 0.75 he rhega ya 1.75.
    Qunki koi 0.75 bolta hai to koi 1.75%?

  • @user-do6cd4kk3w
    @user-do6cd4kk3w Рік тому

    Superb Explanation Vivekji,

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

    Nice explanation 👍.

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

    Very well explained sir😅

  • @hasinabegum-fn3yq
    @hasinabegum-fn3yq 6 місяців тому

    Very nice explanation sir

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

    Sir one question regarding gratuity calculation.
    Is personal pay is included in gratuity caln ya SIRF salary +DA hi consider Karna ha ?
    Or contract terms check Karna hogaa ?? Plz clarify kidr bhi kuch nhii likha issue ke bareme personal pay ko lenge ki nhii .....

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

    Sir please salary slip ke format per bhi video banao

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

    Sir Please describe TDS content for salary sheet

  • @theoblanca1062
    @theoblanca1062 5 місяців тому +1

    Sir, Why there are articles that PF is calculated in BASIC + DA.

  • @knowledgewithhasu4716
    @knowledgewithhasu4716 3 роки тому +3

    Sir PF, ESI, PT per Ek video banaiye in excel and with registration and return filing

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

      Bilkul bhait hi jald

  • @jantapipe1293
    @jantapipe1293 10 днів тому

    sir eski journal entries par bhe video bnaa dejeye

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

    Excellent explanation 👌

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

    Superb Dear

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

    please make a video on how to save tax on income

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

    hello erp software ka vedio bhi send kar dijiye payroll apne bahut accha samjhaya mujhr erp ki urgent require hai

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

    Really very good explanation ...subscribed channel

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

    Sir, it was excellent session...thku

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

    Sir ji pls rules ke ek full video bana lo sir ji

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

    Thankyou ❤

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

    Thanks for sharing excel sheet

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

    Thank u so much

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

    Very nice sir

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

    Supperb.......

  • @Al-BAIK720
    @Al-BAIK720 Рік тому

    Sir i am new HR trainee i want to grow in dis please please mujhe concept clear krdiye ek video bnadiye jisme ye simple btadiye basic kese nikalte ek employee ka aur basic rates me kese ek HR component me adjust krta hai basic ko Hra ,da etc

    • @Al-BAIK720
      @Al-BAIK720 Рік тому

      I am in hotel industry in HR department

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

    Dear sir please make video salary on TDs

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

      Already uploaded you can check on our channel Fintaxpro

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

    Yeh vlookup wala formula use karke solve rahe hain sahi hain .
    Yadi freeze nahi karege toh kya hoga

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

    Sir pleas upload full video payroll and compliance 🙏🙏

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

    PF and esic main round off bhi bataye

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

    Thank You Sir

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

    Sir Pf ECR filling and challan aur ESIC challan and working online pay excal chart video banaya please

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

    Sir....I have one doubt,,,,,for example Gross 22000/- employee attendance 25 days present then payable gross example 18000/- then shall we deduct esi for this month ....if 31 days present in Jan 2021 here gross payable 22000/- so no need to deduct esi...clarify esi deduction gross r payable gross...sometime employee total present esi not eligible... sometime employee total not present esi get eligible....if it happeneds such like that employee not get all esi facilities , please clear my doubt

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

      Same query. As per my knowledge esi is applicable on Gross in salary structure not on payable gross. Same doubt. Plz clarify.

  • @premab.s.1931
    @premab.s.1931 2 роки тому

    Very useful video

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

    Well explained

  • @madhu.8
    @madhu.8 5 місяців тому

    If I learn this or if able to do payroll in Excel will on this basis company will offer me a job ?

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

    Thank u So much🙏

  • @PankajSingh-fj7hw
    @PankajSingh-fj7hw 2 роки тому +1

    great

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

    Sir basic kaise calculate karenge from ctc

  • @saravana903
    @saravana903 9 місяців тому

    Sir your salary ok I understand in organization employees salaries will given two option in bank & cash. Employer pay some in bank and some other employees pay cash how I will in with formula in cash no any deduction happen in cash payment how I will show????

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

    Excellent 👌

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

    PF is not payable on special allowance?

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

    Dusra session kahan dhundhu jahan TDS aur Professional tax ka bata denge aap

  • @Sharma-hd4gm
    @Sharma-hd4gm 3 роки тому +1

    sir
    company की पॉलिसी में किस प्रकार से अमेंडमेंट किया जा सकता है क्या कंपनी की एचआर पॉलिसी को सूचना के अधिकार के द्वारा प्राप्त किया जा सकता है

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

    Thanks sir ji

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

    very nicely explained, but you are not clear regarding pf caping of rupess 15000, this caping in only applicable for pension part not on PF part

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

    simply u r using the vlookup and getting the values, that is not required, how r u determining the components like basic , hra , and etc from CTC. pls make a video on this.

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

    Thank You

  • @SureshG-tu3pj
    @SureshG-tu3pj 2 роки тому

    Right calcullation

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

    In case of gratuity, if company get closed before 5 years.Will employee gratuity be laps? Even employee don't left the company He left because of lay off. Kindly guide

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

    22000 hai gross salary hai but wo absent ki wajh se 20000 thosand hi gross salary ayi tab kya Esi nhi mila ga Sir

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

    Sir ek baat batana, jiski salary 1 lakh hai to wo bonus ke liye egilible nhi hoga kya. Confusion hai