How to make salary sheet || Payroll or Payslip in excel 2016
Vložit
- čas přidán 29. 08. 2024
- In this Tutorial you will learn how to make salary slip or salary sheet in excel 2016, also you will be able how to make payroll system in excel for employees.
thanks for watching, subscribe my channel for more videos...
/ yadonlinetrainingacademy
=====================================================================
IF YOU ARE NEW TO THIS CHANNEL, Please 😊 Like ❤️ Subscribe & turn 🔔 notifications on! Thank you for watching!
=====================================================================
Website
yadonline.blog...
Facebook
/ kpcomuterskills
=====================================================================
Complete Ms-Excel Course Tutorials
• Five Common Excel Erro...
========================================================================
Download Excel File from the link given bellow
drive.google.c...
========================================================================
Pay Head in Payroll are given bellow
DA
The Dearness Allowance (DA) is a cost of living adjustment allowance paid to Government employees, Public sector employees (PSU)and pensioners. Dearness Allowance is calculated as a percentage of basic salary to mitigate the impact of inflation on people.
EPF/PF
The Employee Provident Fund, or provident fund as it is normally referred to, is a retirement benefit scheme that is available to salaried employees. Under this scheme, a stipulated amount (currently 12%) is deducted from the employee's salary and contributed towards the fund.
=====================================================================
Use the following formulas in Payslip or Payroll
DA formula = basic salary * 10/100
House Rent = Basic Salary * 8/100
PF = Basic Salary * 12/100
Gross Salary =Basic salary + DA + House Rent + PF
EPF = PF / 2
LIC = EPF/2
Deduction = EPF + LIC
Net salary = Gross Salary - Deduction
=====================================================================
Resume Templates Microsoft word
• Professional Resume Wr...
=====================================================================
How to create Question paper in Microsoft word
• How to create question...
====================================================================
Advance Excel formulas and Functions
• Five Common Excel Erro...
====================================================================
Complete Course of Accounting through tally erp 9
• How to Install Tally e...
======================================================================
#payslip, #payrollexcel, #salaryslipexcel,#salaryslipinexcel, #salaryslipbanansikhe
Starting my new position as a Production Clerk next week....I need this today.
I saved my self using this video on an online exam 😅
U such a teacher THANK U VERY MUCH
and keep my secret
Glad it was helpful and thanks appreciation my dear.
Thank you
Thank you very much. I highly appreciate you for making this unique video to educate people all over the globe.
Most Welcome
Thankyou for making such a great video... This helped me alot in computer class today 😊👍
Most Welcome my dear.
Wow, superb video. The way you taught is magnificent 😍😍 Thank you
Most Welcome
Sssssss
This is very interesting video i have real benefited a lot, but i could suggest you add it an audio
thanks for your valuable support. and Most Welcome
Thnks I understand how you Teach you simply teach easily brother
Most Welcome dear
Superb. Very easy and clear explaining.
Very very easy method
Thank you so much for your nice comment dear.
Please continue the every chapter teaching.
Very helpful everyone.
@@viewway7182 Thanks for comment dear. sure dear.
Video was amazinh specially percentage shows help me a lot
Thank you so much for your nice comment.
The way that you have exhausted is nice.Tq
Meree bhai ya bhinn bohot bohooot shuqria❤
Most welcome
Thank you so much sir your video is very helpful 👍🙏
Most welcome
JazakALLAH bhai you're a life saver :)
Thank you so much
thank you for this video ... I would try to show this to my husband and I will try to do it myself too ...my husband really need this
Most Welcome dear.
really nice and easy way to learn ! much appreciated
Thank you so much dear
Tq sooooo much sir u doing great job for us its fully cleared video...
Most Welcome
Sir excellent and Very good video
Thanks and welcome
it's wonderfully described sir for any beginner thanks
Thank you so much
Bohut badii madat ki hai bhai apne
Appreciate your tutorial sir much respect you. It helped me for my assignment
Glad to hear that
Thanks for this video🎉🎉🎉🎉🎉🎉🎉
My pleasure 😊
It's very useful to me sir thank u so much for giving video us....
Most Welcome
Thank you sir aapne bhut easy way me btaya 😊
Simple and easy to understand. Thnx so much
Glad it helped!
Jazak Allah Khair..learned alot
Most Welcome my dear
Simple and understandable demo.
Thank you so much dear.
Great carry on indeed it's very important information
Thanks for watching
Perfect, simple and very informative 😊
Glad you liked it!
Easy to understand.... Thank you Sir
Most Welcome
Thanks sir. I am continue watching your videos
Most Welcome
Sir jiii your video is very good but add a speaker / valume in it for it better explaination . keep on making such kind of video and upload it plus add in each video valume . 😊😊 .
Ok. Thanks
Thank you sir for explaining me!!
Keep watching
Very simple. Thanks for the video
Glad it was helpful!
Thank you so much sir.. you made it very easy
Most Welcome dear. Much appreciated your comment.
Thank you so much sir
It's helpful!!
Most welcome!, Keep watching
I want to learn payroll course can you provide the details
Thank you so much for making this tedious work easy. The way you have shown is very nice. Short and sweet video.🙏🙏
Most welcome 😊
Excellent brother tq very much for the video 👍👍💐
Thank you so much dear. i appreciated your comment.
good it is very easy formulation. Good sir
Thanks and welcome
Thank you for create this video. 🙏
Most Welcome my dear.
Very nice and informative
I purchased a car from a car dealership and I needed to bring in paystubs and bank statements last week and that got my stressed out asf till I came across some great comments about deelscafe💯💯
Thanks so much for giving link of sallary Chart
Most Welcome
Super sir thank you ❤❤❤❤❤❤❤❤❤🎉
So nice of you
Very nice sir thanks for this explanation
Most Welcome dear.
❤️❤️thnku for this video
My pleasure 😊
Very very usefull sir . Tq
Useful video... Tq so much keep going ♥️❤️
Thank you so much 🙂
I FULLY UNDERSTYAND, THANK YOU BUDDY
Most welcome dear.
Thank you so much sir🔸👌 i need to your help😍
How can I help you?
How can I help you?
@@YadOnlinetrainingacademy excel me post ko forumala laga ke kse nikala jata hai plese replay sir 💞
@@YadOnlinetrainingacademy sir itana to bata do step by step post ka name likha kar dal do 🙏 sir mai apka sucriber hu egnore mat kro🙏🙏
@@JBoy972 Post Means Designation?
so touching for an excellent video
I fully understand Thanks
Glad it helped
Tthank u for the helpful vdo 🙌
Glad it was helpful!
@@YadOnlinetrainingacademy yes
Sir nivu kelagade formula dali PF = Basic Salary ×12/100 antha hakidira adre excel alli nivu PF na Basic salary ×14/100 antha madidra edrali yavd correct sir..
Nice sir,very easy way
I appreciated your comment.
Currently, HRA & PF how much percentage is followed in company...kindly share the details.
V good sir.I really liked it.
Many many thanks
Most Welcome
Thank you so much sir 🙏🏻
Most Welcome
Prefect one , thanks
Thunk you
So much
Most Welcome
Very useful.. thank u
Most Welcome
Nice video
Thank you so much
Supper
explanation and very helpful
Thank you sir. useful vedio
Most Welcome
Thank You So Much Sir.
Most welcome
I got my Pay stub easily and I can recommend y'all to 👇👇
sir ese thoda nxt lvl up ka bnao plss exm mai tough ayega
Awesome please upload more
Thanks for comment. Much appreciated your comment.
Thank you Sir.🙏🙏
So nice of you
Love you guruji
Thank you so much my dear
Good video bro
Appreciate it
What's your screen recorder name & what's editing software name plz tell me answer
camtasia studio 2021
Are you using paid screen recorder?
Thank you so much
You're most welcome
Thank you sir
So nice of you
Sir. Database excelil create ചെയ്തിട്ട് eg. 100 data entry ചെയ്തിട്ട് അത് print എടുക്കുക എങ്ങനെയാണ്.
thanks very much
Always welcome
Super sir
Thank you so much
Thanku so much
Most Welcome
This is wonderful. Thanks a lot.
Most Welcome
Very nice sir
Thank you so much
Thank u sir
So nice of you
Sir, I am from Bangladesh.
Most Welcome dear.
Thank you
You're welcome
Thanks!
Most Welcome
Good sr
Thanks you
Most Welcome
Or agar koi 3 din absent ho to uska salary cut kar denge to cut wali salary DA me Add karenge ya basic salary hi btaye 🥺
Basic Salary
tqsm for your video
JazakAllah
Thank you so much
Tq so much
Most Welcome
very nice sir g
Thank you so much dear.
God bless u. May I know what ever the percentage you given for da,hra is it fixed for every organization
Thanks for your comment. Sure DA, Hra is fixed and different for different scale
Nice payrolll 👍👍👍👍
Thank you so much
Could u pls make videod about MYOB. Thanks.
Thank u so much ❤️
You're welcome 😊
thankyou so much
Most Welcome
Basic + conveynce m basic + gross salary leni h ya sirf basic ?
Only basic, b/c Basic +all allownces become gross pay.
@@YadOnlinetrainingacademy thnku
Most Welcome@@NishaSharma-qy7jn
I just want to ask if payroll is part of Human Resource or Finance Department? Thanks.
Payroll functions are covered by either the finance department or human resources department in most organizations. Essentially, payroll is number-driven and calls for knowledge of tax laws and accounting. At the same time, payroll is also considered a function of HR because it pays and deals with people.
Depends on the nature of the company. Both HR and Finance covers payroll. If you work on a school, the HR department covers the payroll for all employees and the finance department covers the payment of the students.
Thank you , sir
Most Welcome