Complete Salary Computation in Excel | Payroll calculation in excel

📍In this session we have discuss about the complete payroll preparation in India. We have also discuss the statutory compliance include in payroll preparation. You will be able to learn below topics after watching this session
👉Salary Structure of a company
👉Cost to Company CTC and in Hand Salary
👉Complete Salary Computation in Excel
👉EPF calculation and compliance
👉ESI calculation and compliance
👉Bonus calculation and compliance
👉Gratuity calculation and compliance
👉TDS calculation and compliance
🗓Below are the due dates for industrial compliance-
👉PF payment due date - 15th of following month
👉ESI payment due date - 15th of following month
👉TDS due date - 7th of following month
👉Gratuity payment (to employee) - at retirement
👉Bonus payment(to employee) - 30th Sept of following year
🔗Download Salary sheet - bit.ly/3vQfABL
👨🏻‍🎓Enroll to our practical course in TDS, ITR & GST Filing
👉Enrollment Link - bit.ly/3uENoRn
👉Create your account
👉Proceed for payment
👉After payment you can access your complete course
👉Get Certificate after course completion
🔗Download FREE payroll app: bit.ly/3h29KZT
⏰Time Stamp
0:00 Excel and Payroll preparation
2:34 Salary Sheet Template
5:01 What is Salary Structure?
12:42 Calculation of Basic Salary
16:53 Calculation of HRA
18:03 Calculation of special allowance
20:00 Calculation of Gross Salary
20:20 Calculation Employee PF
27:16 Calculation of Employee ESI
33:36 Calculation of TDS on salary
37:44 Calculation of professional tax
38:41 Calculation of Net Salary
40:04 Calculation of Employer PF
40:52 Calculation of PF Admin expenses
43:26 Calculation of Employer ESI expenses
45:13 Calculation of Gratuity
47:33 Calculation of Bonus
48:55 Bonus Act and Daily Wage Act
58:55 CTC calculation
1:02:42 Outro
📍For tax consultancy, payroll management and query please contact below
📩 info@fintaxpro.in
📞9718097735
📍For Digital Content and collaboration
📩 vivek@fintaxpro.in
📞8368741773
Cheers Folks
Thanks for Watching :)
-Team Fintaxpro
www.fintaxpro.in
Disclaimer- Although all provisions, notifications, updates and live demo are analyzed in-depth by our team before presenting to public. We hereby provide our point of view only and tax matter are always subject to frequent changes hence advisory is only for the benefit of general public. Hence neither Fintaxpro Advisory LLP nor its designated partner are liable for any consequence arises on the basis of You Tube videos.
#payroll #payroll #ESI #PF #provident #fund #bonus #salary #computation #compliance #gratuity #tds #perquisites #overtime #OT #arrearsalary #advancesalary #increment #incentive #costtocompany #ctc #inhandsalary #inhand #bank #statutory #bonus #HRA #DA #basic #inter #bcom #india
📍This video will also guide on below topics
Complete Salary Computation in Excel
Payroll calculation excel
In hand Salary
Basic Salary
salary calculation formula,
salary calculation in income tax,
salary calculation in excel,
salary calculation formula in excel sheet,
salary calculation app,
salary calculation after 11th bps,
basic salary calculation,
salary bonus
salary components and calculation,
salary ctc calculation excel,
due drawn salary calculation in excel,
da salary calculation,
per day salary calculation formula,
salary calculation excel,
salary calculation excel sheet,
tds salary calculation excel format,
salary arrear calculation in excel,
excel salary calculation formula,
epf salary calculation,
hourly salary calculation in excel,
e salary,
salary calculation formula in excel,
pf salary calculation,
pf salary calculation formula,
pf calculation on salary in excel,
pf deduction from salary calculation,
salary calculation with pf and esi,
gross salary calculation,
govt salary calculation,
grade pay salary calculation in hindi,
salary gratuity calculation india,
calculation of grade salary,
gross salary calculation in excel,
hr salary calculation,
how to salary calculation in excel,
hra salary calculation,
half pay salary calculation,
hpl salary calculation,
salary calculation in tally,
salary calculation in excel with formula,
salary calculation in ms access,
salary calculation july 2020,
employee salary calculation in java,
july salary calculation,
salary calculation kaise kare,
hpl leave salary calculation,
esi leave salary calculation,
monthly salary calculation,
esi maternity salary calculation,
net salary calculation formula,
salary calculation on excel sheet,
salary calculation percentage,
salary pf calculation,
payroll salary calculation formula,
salary calculation rules,
railway salary calculation,
salary calculation sheet in excel,
salary calculation salary formula,
pay scale salary calculation,
salary scale calculation,
excel sheet salary calculation formula,
salary tax calculation,
salary calculator un,
salary calculation 11th,
tds on salary calculation 2018-19,
july 2020 salary calculation,
salary income tax calculation 2019-20,

Пікірлер: 170

  • @vachasikka3602
    @vachasikka36022 жыл бұрын

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

  • @gazalakhan2802
    @gazalakhan28023 жыл бұрын

    Very easy and excellent explanation. Helped me a lot.

  • @Al-BAIK720
    @Al-BAIK7202 жыл бұрын

    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

  • @vibhakumari2261
    @vibhakumari22612 жыл бұрын

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

  • @ballabhachandra3500
    @ballabhachandra3500 Жыл бұрын

    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 .

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

  • @pasalauday8111
    @pasalauday81113 жыл бұрын

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

  • @memoryhighlights3001
    @memoryhighlights30013 жыл бұрын

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

  • @shiwaniagrawal6610
    @shiwaniagrawal66102 жыл бұрын

    If we have Teacher like you nothing is difficult thanks

  • @Sharma-hd4gm
    @Sharma-hd4gm3 жыл бұрын

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

  • @rajatagrawal3730
    @rajatagrawal37302 жыл бұрын

    Kitna ache se smjhte hei sir thanks

  • @kuldeep.3012
    @kuldeep.30122 жыл бұрын

    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

  • @pushpashinde1644
    @pushpashinde1644 Жыл бұрын

    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

  • @Anu-rx3ej
    @Anu-rx3ej Жыл бұрын

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

  • @Amitrajputchannel
    @Amitrajputchannel2 жыл бұрын

    Thanks sir for sharing this valuable information and sharing notes

  • @joshiramesh50
    @joshiramesh50 Жыл бұрын

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

  • @ganeshkollan683
    @ganeshkollan683 Жыл бұрын

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

  • @sidrachaudhry1378
    @sidrachaudhry137811 ай бұрын

    The way you teach is amazing literally...👍

  • @sandipmagar7740
    @sandipmagar77407 ай бұрын

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

  • @the.artist7152
    @the.artist71522 жыл бұрын

    Thanks sir for teaching us... ❤️ Keep growing sir on KZread....lots of love

  • @ISHMEETKAURISHMEETKAUR-fn8ct
    @ISHMEETKAURISHMEETKAUR-fn8ct2 ай бұрын

    Amazing way of explaining.. Thanks

  • @tanushreemajumder7872
    @tanushreemajumder78722 жыл бұрын

    What an explanation sir 🙏👏🙌

  • @nidhijhunjhunwala4887
    @nidhijhunjhunwala4887 Жыл бұрын

    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.

  • @jamilqureshi4216
    @jamilqureshi4216 Жыл бұрын

    really an amazing explanation 👍

  • @sid2638
    @sid26382 жыл бұрын

    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

  • @roopashreeuv8413
    @roopashreeuv84132 жыл бұрын

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

  • @FinTaxPro

    @FinTaxPro

    2 жыл бұрын

    Glad you like it

  • @shrikantpise8436
    @shrikantpise84362 жыл бұрын

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

  • @girishraju18
    @girishraju182 жыл бұрын

    Amazing Teaching skill.

  • @Sharma-hd4gm
    @Sharma-hd4gm3 жыл бұрын

    Superb Video, I love this video

  • @vishalbhosale1453
    @vishalbhosale14539 ай бұрын

    It was completely informative....

  • @shaiena.shannu7424
    @shaiena.shannu74243 жыл бұрын

    Thank you sir aapka video mujhe bohat useful he

  • @FinTaxPro

    @FinTaxPro

    3 жыл бұрын

    Glad it help

  • @user-uz9em1uo6o
    @user-uz9em1uo6o6 ай бұрын

    Very much Useful Vedio sir...Thanks

  • @kamnayadav2111
    @kamnayadav21112 жыл бұрын

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

  • @user-do6cd4kk3w
    @user-do6cd4kk3w Жыл бұрын

    Superb Explanation Vivekji,

  • @practicalknowledgeofaccoun5404
    @practicalknowledgeofaccoun54043 жыл бұрын

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

  • @FinTaxPro

    @FinTaxPro

    3 жыл бұрын

    Glad you like it 😊

  • @sudhiac7065
    @sudhiac70652 жыл бұрын

    Sir, it was excellent session...thku

  • @patjoshitutorials6317
    @patjoshitutorials63173 жыл бұрын

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

  • @sikandarsah1891
    @sikandarsah18912 жыл бұрын

    Thanks for sharing excel sheet

  • @hemabenjadav8809
    @hemabenjadav88092 жыл бұрын

    Very very useful video!

  • @shwetavashishth1988
    @shwetavashishth19882 жыл бұрын

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

  • @FinTaxPro

    @FinTaxPro

    2 жыл бұрын

    So nice of you

  • @sistabond9600
    @sistabond9600 Жыл бұрын

    Thanks for this video....

  • @tejas21love
    @tejas21love3 жыл бұрын

    Thank You Sir

  • @shakuntladas1046
    @shakuntladas10463 жыл бұрын

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

  • @avishekmondal3353
    @avishekmondal33533 жыл бұрын

    This channel is gem ❤️

  • @FinTaxPro

    @FinTaxPro

    3 жыл бұрын

    Glad you like our content

  • @mazakiyakuldeep
    @mazakiyakuldeep2 жыл бұрын

    Excellent sir excellent explanation & thank you

  • @FinTaxPro

    @FinTaxPro

    2 жыл бұрын

    Glad you like it

  • @cipviz4418
    @cipviz441825 күн бұрын

    Nice video sir very helpful 👍

  • @sumanmaheshsharma4615
    @sumanmaheshsharma46153 жыл бұрын

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

  • @calculationmakessimple8165
    @calculationmakessimple81652 жыл бұрын

    Nice explanation 👍.

  • @rameshg6386
    @rameshg63862 жыл бұрын

    Really very good explanation ...subscribed channel

  • @hasinabegum-fn3yq
    @hasinabegum-fn3yq5 ай бұрын

    Very nice explanation sir

  • @pratyushmohanty4918
    @pratyushmohanty49182 жыл бұрын

    Best Video on KZread

  • @PrakashSolanki-yh9uo
    @PrakashSolanki-yh9uo Жыл бұрын

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

  • @premab.s.1931
    @premab.s.19312 жыл бұрын

    Very useful video

  • @vickypatel6845
    @vickypatel68452 жыл бұрын

    Excellent 👌

  • @vijaykumar-nt3hd
    @vijaykumar-nt3hd2 жыл бұрын

    Thank you so much

  • @lathikakamani9700
    @lathikakamani97002 жыл бұрын

    Thank u so much

  • @Ranjeets839
    @Ranjeets8393 ай бұрын

    Very nice session 👌

  • @Beliver_Lfc
    @Beliver_Lfc2 жыл бұрын

    Thank you Anna

  • @saurabhvardam1463
    @saurabhvardam1463 Жыл бұрын

    Thank u So much🙏

  • @financeaccount7695
    @financeaccount7695 Жыл бұрын

    Well explained

  • @shivanivarma5528
    @shivanivarma55283 жыл бұрын

    Very nice sir

  • @sampurnatripathi5725
    @sampurnatripathi57252 жыл бұрын

    Superb Dear

  • @nishavyas6146
    @nishavyas61462 жыл бұрын

    Excellent explanation 👌

  • @FinTaxPro

    @FinTaxPro

    2 жыл бұрын

    Glad you like it

  • @abhijeetpatil0199
    @abhijeetpatil01992 жыл бұрын

    Thank You

  • @shrikantpise8436
    @shrikantpise84362 жыл бұрын

    Thanks sir ji

  • @pramodmeena4242
    @pramodmeena4242Сағат бұрын

    Thankyou ❤

  • @junction3603
    @junction36032 жыл бұрын

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

  • @FinTaxPro

    @FinTaxPro

    2 жыл бұрын

    Glad you like it

  • @nishapradhan494
    @nishapradhan494 Жыл бұрын

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

  • @saiyedshafaq4392
    @saiyedshafaq43922 ай бұрын

    Very well explained sir😅

  • @mohammadazhar364
    @mohammadazhar3643 жыл бұрын

    Good..

  • @PankajSingh-fj7hw
    @PankajSingh-fj7hw2 жыл бұрын

    great

  • @rohitverma4771
    @rohitverma47712 жыл бұрын

    Sir Please describe TDS content for salary sheet

  • @SureshG-tu3pj
    @SureshG-tu3pj2 жыл бұрын

    Right calcullation

  • @sachinsingh-mv8px
    @sachinsingh-mv8px3 жыл бұрын

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

  • @FinTaxPro

    @FinTaxPro

    3 жыл бұрын

    Sure will make soon

  • @lingarajswain5591

    @lingarajswain5591

    3 жыл бұрын

    Yes❤️👍

  • @sonugoswami9326

    @sonugoswami9326

    2 жыл бұрын

    Nice video sir

  • @reallifeexperience4072
    @reallifeexperience40723 жыл бұрын

    Sir please salary slip ke format per bhi video banao

  • @SupriyaDeepti
    @SupriyaDeepti3 жыл бұрын

    Supperb.......

  • @FinTaxPro

    @FinTaxPro

    3 жыл бұрын

    Glad you like it

  • @theoblanca1062
    @theoblanca10624 ай бұрын

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

  • @knowledgeblogs2193
    @knowledgeblogs21932 жыл бұрын

    please make a video on how to save tax on income

  • @bahadursinghbisht276
    @bahadursinghbisht2762 жыл бұрын

    PF and esic main round off bhi bataye

  • @knowledgewithhasu4716
    @knowledgewithhasu47163 жыл бұрын

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

  • @FinTaxPro

    @FinTaxPro

    3 жыл бұрын

    Bilkul bhait hi jald

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

  • @daredevil2606
    @daredevil26063 жыл бұрын

    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 жыл бұрын

    Sure will definitely make videos on that.

  • @suniljain7366
    @suniljain73662 жыл бұрын

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

  • @arjunrajguru4348
    @arjunrajguru43482 жыл бұрын

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

  • @tushartyagi1747
    @tushartyagi17472 жыл бұрын

    PF is not payable on special allowance?

  • @keshavshakya6212
    @keshavshakya62122 жыл бұрын

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

  • @madhu.8
    @madhu.84 ай бұрын

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

  • @suniljain7366
    @suniljain73662 жыл бұрын

    sir can you share the excel link for file for practice

  • @padmajapatra66
    @padmajapatra663 жыл бұрын

    Sir basic kaise calculate karenge from ctc

  • @shiwaniagrawal6610
    @shiwaniagrawal66102 жыл бұрын

    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

  • @rathorerathore8120
    @rathorerathore81202 жыл бұрын

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

  • @maheshjain6707
    @maheshjain67072 жыл бұрын

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

  • @Politics741
    @Politics7412 жыл бұрын

    Pf calculated on basic plus da?

  • @pankajpal957
    @pankajpal9572 жыл бұрын

    Dear sir please make video salary on TDs

  • @FinTaxPro

    @FinTaxPro

    2 жыл бұрын

    Already uploaded you can check on our channel Fintaxpro

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

  • @ashwinirai9467
    @ashwinirai9467 Жыл бұрын

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

  • @shivkumar-bj3ps
    @shivkumar-bj3ps2 жыл бұрын

    Bhai ji mera ko company EPF employees k EPF account m kasa daal te h us wara m baat do

  • @ajayr.parikh2708
    @ajayr.parikh2708 Жыл бұрын

    Can i download this excel sheet

  • @Heisennburg
    @Heisennburg2 күн бұрын

    Bhai par mera to 50k basic hai aur pf 12k kat ta hai .. 6k employee and 6k employer contribution both from my ctc

  • @itsjoymassey
    @itsjoymasseyАй бұрын

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