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
this is no doubt the best video of payroll on youtube . thank you very much for explaining each concept in detail.😀
Very easy and excellent explanation. Helped me a lot.
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
It's a complete vedio of payroll👍 Thank you so much Sir
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 .
really a great explanation, I could learn the payroll calculation with explanation for it. Thank you for the session. May God Bless You
I was looking for these kind of template with explanation Thank you very much sir
Sir, you have really explained in detail, 🙏👍👏
If we have Teacher like you nothing is difficult thanks
Amazing Chapter Dear Sir मैं अपनी लाइफ की पहली जॉब एचआर कोऑर्डिनेटर के रूप में कर रहा हूं तथा मेरी यह इच्छा थी कि मैं पैरोल एग्जीक्यूटिव बनू क्योंकि मैं लीगल के फील्ड से आया हुआ हूं इसलिए मुझे नहीं पता कि किस प्रकार से पैरोल का काम किया जाता है आपके द्वारा बनाई गई इस वीडियो को देखने की मुझे काफी हेल्प मिली है मैं बहुत जल्दी ही आपकी टैक्स डिडक्शन वाले भाग का हिस्सा बनना चाहूंगा आपके द्वारा किया गया कार्य अति सराहनीय है धन्यवाद
Kitna ache se smjhte hei sir thanks
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
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
Thanks a ton.. You are saviour for all of us.
Thanks sir for sharing this valuable information and sharing notes
YOUR ALL VIDEOS ARE GREAT KNOWLEDGEBEL FOR US, WE ARE WAITING FOR NEXT VIDEOS FOR COMPLETE PAYROLL PROCESS.
Really very educative in detail payroll very thankful to you Guru ji 🌹
The way you teach is amazing literally...👍
Thank you so much Sir for this very informative training session.
Thanks sir for teaching us... ❤️ Keep growing sir on KZread....lots of love
Amazing way of explaining.. Thanks
What an explanation sir 🙏👏🙌
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.
really an amazing explanation 👍
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
wonderful! You are a really great teacher.Thank you for these videos.God bless you.
@FinTaxPro
2 жыл бұрын
Glad you like it
Kya bat he sir ji thanks aap to mere guru ho sir ji 🙏
Amazing Teaching skill.
Superb Video, I love this video
It was completely informative....
Thank you sir aapka video mujhe bohat useful he
@FinTaxPro
3 жыл бұрын
Glad it help
Very much Useful Vedio sir...Thanks
Thanks you lot sir you have explained well tq so much 🤩
Superb Explanation Vivekji,
Sir....really i like your video clarity..usef execl formula to many more Accountant and practicing CA
@FinTaxPro
3 жыл бұрын
Glad you like it 😊
Sir, it was excellent session...thku
Sir , Just Wow Complete Knowledge of salary preparation I really Enjoy this Topic and revise it , Salute to you Sir .
Thanks for sharing excel sheet
Very very useful video!
Thank you to make this video sir. It’s really very beneficial for me.
@FinTaxPro
2 жыл бұрын
So nice of you
Thanks for this video....
Thank You Sir
You are amazing and the way you teach every small thing is really appreciable.
This channel is gem ❤️
@FinTaxPro
3 жыл бұрын
Glad you like our content
Excellent sir excellent explanation & thank you
@FinTaxPro
2 жыл бұрын
Glad you like it
Nice video sir very helpful 👍
sir kafi mast vedio h please make more vedios like this epfo,tds,pf complaince
Nice explanation 👍.
Really very good explanation ...subscribed channel
Very nice explanation sir
Best Video on KZread
wah good information in salary computation sheet, very very good video Jai Matadi
Very useful video
Excellent 👌
Thank you so much
Thank u so much
Very nice session 👌
Thank you Anna
Thank u So much🙏
Well explained
Very nice sir
Superb Dear
Excellent explanation 👌
@FinTaxPro
2 жыл бұрын
Glad you like it
Thank You
Thanks sir ji
Thankyou ❤
Maja aa gaya sir I m also hr executive Actually this vedio is more important for fresher
@FinTaxPro
2 жыл бұрын
Glad you like it
hello erp software ka vedio bhi send kar dijiye payroll apne bahut accha samjhaya mujhr erp ki urgent require hai
Very well explained sir😅
Good..
great
Sir Please describe TDS content for salary sheet
Right calcullation
Sir EPFO, ESIC Ka full video bnaye registration se lekar return filing tak
@FinTaxPro
3 жыл бұрын
Sure will make soon
@lingarajswain5591
3 жыл бұрын
Yes❤️👍
@sonugoswami9326
2 жыл бұрын
Nice video sir
Sir please salary slip ke format per bhi video banao
Supperb.......
@FinTaxPro
3 жыл бұрын
Glad you like it
Sir, Why there are articles that PF is calculated in BASIC + DA.
please make a video on how to save tax on income
PF and esic main round off bhi bataye
Sir PF, ESI, PT per Ek video banaiye in excel and with registration and return filing
@FinTaxPro
3 жыл бұрын
Bilkul bhait hi jald
🙏 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%?
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
3 жыл бұрын
Sure will definitely make videos on that.
good evning sir plz help me how to download your excel sheet for practice
Sir Pf ECR filling and challan aur ESIC challan and working online pay excal chart video banaya please
PF is not payable on special allowance?
Sir ji pls rules ke ek full video bana lo sir ji
If I learn this or if able to do payroll in Excel will on this basis company will offer me a job ?
sir can you share the excel link for file for practice
Sir basic kaise calculate karenge from ctc
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
Sir ek baat batana, jiski salary 1 lakh hai to wo bonus ke liye egilible nhi hoga kya. Confusion hai
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 .....
Pf calculated on basic plus da?
Dear sir please make video salary on TDs
@FinTaxPro
2 жыл бұрын
Already uploaded you can check on our channel Fintaxpro
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
Yeh vlookup wala formula use karke solve rahe hain sahi hain . Yadi freeze nahi karege toh kya hoga
Bhai ji mera ko company EPF employees k EPF account m kasa daal te h us wara m baat do
Can i download this excel sheet
Bhai par mera to 50k basic hai aur pf 12k kat ta hai .. 6k employee and 6k employer contribution both from my ctc
Dusra session kahan dhundhu jahan TDS aur Professional tax ka bata denge aap