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
📩 [e-mail]
📞9718097735
📍For Digital Content and collaboration
📩 [e-mail]
📞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,

[@vachasikka3602]

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

[@Al-BAIK720]

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]

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

[@shiwaniagrawal6610]

If we have Teacher like you nothing is difficult thanks

[@kuldeep.3012]

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

[@gazalakhan2802]

Very easy and excellent explanation. Helped me a lot.

[@vibhakumari2261]

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

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

[@pasalauday8111]

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

[@rajatagrawal3730]

Kitna ache se smjhte hei sir thanks

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

[@memoryhighlights3001]

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

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

[@Anu-rx3ej]

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

[@Amitrajputchannel]

Thanks sir for sharing this valuable information and sharing notes

[@sistabond9600]

Thanks for this video....

[@the.artist7152]

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

[@ganeshkollan683]

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

[@joshiramesh50]

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

[@roopashreeuv8413]

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

[@FinTaxPro]

Glad you like it

[@sidrachaudhry1378]

The way you teach is amazing literally...👍

[@tanushreemajumder7872]

What an explanation sir 🙏👏🙌

[@sandipmagar7740]

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

[@junction3603]

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

[@FinTaxPro]

Glad you like it

[@ISHMEETKAURISHMEETKAUR-fn8ct]

Amazing way of explaining.. Thanks

[@shaiena.shannu7424]

Thank you sir aapka video mujhe bohat useful he

[@FinTaxPro]

Glad it help

[@jamilqureshi4216]

really an amazing explanation 👍

[@sid2638]

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

[@Sharma-hd4gm]

Superb Video, I love this video

[@shwetavashishth1988]

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

[@FinTaxPro]

So nice of you

[@vishalbhosale1453]

It was completely informative....

[@girishraju18]

Amazing Teaching skill.

[@practicalknowledgeofaccoun5404]

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

[@FinTaxPro]

Glad you like it 😊

[@avishekmondal3353]

This channel is gem ❤️

[@FinTaxPro]

Glad you like our content

[@user-uz9em1uo6o]

Very much Useful Vedio sir...Thanks

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

[@patjoshitutorials6317]

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

[@kamnayadav2111]

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

[@user-do6cd4kk3w]

Superb Explanation Vivekji,

[@sudhiac7065]

Sir, it was excellent session...thku

[@pratyushmohanty4918]

Best Video on KZbin

[@mazakiyakuldeep]

Excellent sir excellent explanation & thank you

[@FinTaxPro]

Glad you like it

[@cipviz4418]

Nice video sir very helpful 👍

[@shrikantpise8436]

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

[@hemabenjadav8809]

Very very useful video!

[@shakuntladas1046]

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

[@PrakashSolanki-yh9uo]

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

[@sikandarsah1891]

Thanks for sharing excel sheet

[@tejas21love]

Thank You Sir

[@rameshg6386]

Really very good explanation ...subscribed channel

[@sumanmaheshsharma4615]

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

[@calculationmakessimple8165]

Nice explanation 👍.

[@shrikantpise8436]

Thanks sir ji

[@Beliver_Lfc]

Thank you Anna

[@premab.s.1931]

Very useful video

[@vijaykumar-nt3hd]

Thank you so much

[@hasinabegum-fn3yq]

Very nice explanation sir

[@vickypatel6845]

Excellent 👌

[@lathikakamani9700]

Thank u so much

[@saurabhvardam1463]

Thank u So much🙏

[@abhijeetpatil0199]

Thank You

[@Ranjeets839]

Very nice session 👌

[@nishavyas6146]

Excellent explanation 👌

[@FinTaxPro]

Glad you like it

[@sampurnatripathi5725]

Superb Dear

[@shivanivarma5528]

Very nice sir

[@financeaccount7695]

Well explained

[@crazygeamerff.3083]

great

[@saiyedshafaq4392]

Very well explained sir😅

[@mohammadazhar364]

Good..

[@SureshG-tu3pj]

Right calcullation

[@sachinsingh-mv8px]

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

[@FinTaxPro]

Sure will make soon

[@lingarajswain5591]

Yes❤️👍

[@sonugoswami9326]

Nice video sir

[@SupriyaDeepti]

Supperb.......

[@FinTaxPro]

Glad you like it

[@nishapradhan494]

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

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

[@rohitverma4771]

Sir Please describe TDS content for salary sheet

[@knowledgewithhasu4716]

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

[@FinTaxPro]

Bilkul bhait hi jald

[@reallifeexperience4072]

Sir please salary slip ke format per bhi video banao

[@knowledgeblogs2193]

please make a video on how to save tax on income

[@daredevil2606]

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]

Sure will definitely make videos on that.

[@vijaykumar-nt3hd]

👍

[@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]

I am in hotel industry in HR department

[@theoblanca1062]

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

[@bharatbhalawat4345]

⭐⭐⭐⭐⭐

[@pankajpal957]

Dear sir please make video salary on TDs

[@FinTaxPro]

Already uploaded you can check on our channel Fintaxpro

[@keshavshakya6212]

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

[@arjunrajguru4348]

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

[@ajeetyadav8919]

Sir pleas upload full video payroll and compliance 🙏🙏

[@FinTaxPro]

Will upload soon

[@ajeetyadav8919]

@@FinTaxPro ok thanks Sir

[@nikunj5656]

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

[@bahadursinghbisht276]

PF and esic main round off bhi bataye

[@itsjoymassey]

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

[@maheshjain6707]

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

[@shivkumar-bj3ps]

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

[@ashwinirai9467]

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

[@govindKumar-ip6sk]

Not only basic

[@mohammadazhar364]

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]

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

[@padmajapatra66]

Sir basic kaise calculate karenge from ctc

[@luckybisht272]

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

[@tushartyagi1747]

PF is not payable on special allowance?

[@madhu.8]

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

[@suniljain7366]

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