Complete Salary Computation in Excel | Payroll calculation in excel

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

КОМЕНТАРІ •

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

    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

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

    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

  • @Al-BAIK720
    @Al-BAIK720 3 роки тому +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

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

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

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

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

  • @AzkaNaeem-q9k
    @AzkaNaeem-q9k 23 дні тому

    Excellent learning, Vlookup explained very well and all other stuff too. i have worked on it as per my country labour laws value, this is my first project being upload on my business profile. many many thanks from Pkistan.

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

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

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

    Kitna ache se smjhte hei sir thanks

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

    If we have Teacher like you nothing is difficult thanks

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

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

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

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

  • @RajeshMD-iz7ks
    @RajeshMD-iz7ks 2 роки тому

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

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

  • @PrakashSolanki-yh9uo
    @PrakashSolanki-yh9uo 2 роки тому

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

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

    The way you teach is amazing literally...👍

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

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

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

    It was completely informative....

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

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

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

    Amazing way of explaining.. Thanks

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

    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

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

    Very easy and excellent explanation. Helped me a lot.

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

    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

  • @SameerKumarPandey-r3s
    @SameerKumarPandey-r3s Рік тому +1

    Very much Useful Vedio sir...Thanks

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

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

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

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

    Amazing Teaching skill.

  • @pradeepmotivational-g1l
    @pradeepmotivational-g1l 3 роки тому +1

    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 😊

  • @Shiva-f2e3l
    @Shiva-f2e3l 3 роки тому +1

    Thanks sir for sharing this valuable information and sharing notes

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

    Superb Video, I love this video

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

  • @krishnam-z7x
    @krishnam-z7x Рік тому

    Superb Explanation Vivekji,

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

    Best Video on UA-cam

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

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

  • @furkanchaudhary7894
    @furkanchaudhary7894 4 місяці тому

    thank you Dear.. Have a good day!!

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

    Thank you sir aapka video mujhe bohat useful he

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

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

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

    This channel is gem ❤️

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

      Glad you like our content

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

    Very very useful video!

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

    Thanks for this video....

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

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

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

    Sir, it was excellent session...thku

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

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

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

    Really very good explanation ...subscribed channel

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

    Excellent sir excellent explanation & thank you

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

    Very nice session 👌

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

    Nice video sir very helpful 👍

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

    Very well explained sir😅

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

    Great session..

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

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

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

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

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

    Very nice explanation sir

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

    What an explanation sir 🙏👏🙌

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

    Thanks for sharing excel sheet

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

    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.

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

    Excellent explanation 👌

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

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

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

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

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

    Thank u So much🙏

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

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

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

    Very useful video

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

    Excellent 👌

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

    Thankyou ❤

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

    Superb Dear

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

    Well explained

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

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

    Right calcullation

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

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

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

      Bilkul bhait hi jald

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

    please make a video on how to save tax on income

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

    Very nice sir

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

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

    Sir Please describe TDS content for salary sheet

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

    Thanks sir ji

  • @jantapipe1293
    @jantapipe1293 4 місяці тому

    sir eski journal entries par bhe video bnaa dejeye

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

    Supperb.......

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

    Thank u so much

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

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

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

    Sir please salary slip ke format per bhi video banao

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

    Sir pleas upload full video payroll and compliance 🙏🙏

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

    Thank You Sir

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

    Dear sir please make video salary on TDs

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

      Already uploaded you can check on our channel Fintaxpro

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

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

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

    Good..

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

    Thank You

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

    Thank you Anna

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

    Sir i am a bit confused but is bonus calculated on basic+DA OR ON GROSS SALARY??

  • @crazygeamerff.3083
    @crazygeamerff.3083 3 роки тому

    great

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

    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.

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

    Confused mat hona
    PF - basic per
    ESI - gross salary per calculate hota hai

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

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

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

    epf 8.33 +3.67 employers & edlis 0.5% + admin. charges 0.5%

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

    PF and esic main round off bhi bataye

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

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

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

    ACCOUNTING TREATMENT IN BOOKS SHOULD ALSO BE DISCUSSED IN A SEPERATE VIDEO

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

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

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

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

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

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

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

    good evning sir
    plz help me how to download your excel sheet for practice

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

    PF is not payable on special allowance?