How to make salary sheet || Payroll or Payslip in excel 2016
Вставка
- Опубліковано 11 вер 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
Thank you very much. I highly appreciate you for making this unique video to educate people all over the globe.
Most Welcome
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
Thankyou for making such a great video... This helped me alot in computer class today 😊👍
Most Welcome my dear.
Thanks for this video🎉🎉🎉🎉🎉🎉🎉
My pleasure 😊
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
Tq sooooo much sir u doing great job for us its fully cleared video...
Most Welcome
Thnks I understand how you Teach you simply teach easily brother
Most Welcome dear
Thank you so much sir your video is very helpful 👍🙏
Most welcome
Video was amazinh specially percentage shows help me a lot
Thank you so much for your nice comment.
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.
I want to learn payroll course can you provide the details
It's very useful to me sir thank u so much for giving video us....
Most Welcome
really nice and easy way to learn ! much appreciated
Thank you so much dear
it's wonderfully described sir for any beginner thanks
Thank you so much
Sir excellent and Very good video
Thanks and welcome
The way that you have exhausted is nice.Tq
Appreciate your tutorial sir much respect you. It helped me for my assignment
Glad to hear that
Jazak Allah Khair..learned alot
Most Welcome my dear
Simple and easy to understand. Thnx so much
Glad it helped!
Meree bhai ya bhinn bohot bohooot shuqria❤
Most welcome
Bohut badii madat ki hai bhai apne
JazakALLAH bhai you're a life saver :)
Thank you so much
Easy to understand.... Thank you Sir
Most Welcome
Thank you so much sir.. you made it very easy
Most Welcome dear. Much appreciated your comment.
Simple and understandable demo.
Thank you so much dear.
Thank you sir for explaining me!!
Keep watching
Very simple. Thanks for the video
Glad it was helpful!
Great carry on indeed it's very important information
Thanks for watching
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.
Perfect, simple and very informative 😊
Glad you liked it!
Thank you so much sir
It's helpful!!
Most welcome!, Keep watching
Very nice and informative
Thanks sir. I am continue watching your videos
Most Welcome
Super sir thank you ❤❤❤❤❤❤❤❤❤🎉
So nice of you
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?
Excellent brother tq very much for the video 👍👍💐
Thank you so much dear. i appreciated your comment.
Thank you for create this video. 🙏
Most Welcome my dear.
Many many thanks
Most Welcome
good it is very easy formulation. Good sir
Thanks and welcome
Very nice sir thanks for this explanation
Most Welcome dear.
Very very usefull sir . Tq
Tthank u for the helpful vdo 🙌
Glad it was helpful!
@@YadOnlinetrainingacademy yes
Thanks so much for giving link of sallary Chart
Most Welcome
❤️❤️thnku for this video
My pleasure 😊
I fully understand Thanks
Glad it helped
Thank you sir aapne bhut easy way me btaya 😊
so touching for an excellent video
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
So nice of you
Thunk you
So much
Most Welcome
Thank you so much sir 🙏🏻
Most Welcome
Nice sir,very easy way
I appreciated your comment.
Useful video... Tq so much keep going ♥️❤️
Thank you so much 🙂
Very useful.. thank u
Most Welcome
Thank you so much for making this tedious work easy. The way you have shown is very nice. Short and sweet video.🙏🙏
Most welcome 😊
Thank u sir
So nice of you
Thank you Sir.🙏🙏
So nice of you
Thanks!
Most Welcome
Currently, HRA & PF how much percentage is followed in company...kindly share the details.
Thank you sir. useful vedio
Most Welcome
Thank you so much
You're most welcome
I FULLY UNDERSTYAND, THANK YOU BUDDY
Most welcome dear.
Tq so much
Most Welcome
Love you guruji
Thank you so much my dear
Nice video
Thank you so much
What's your screen recorder name & what's editing software name plz tell me answer
camtasia studio 2021
Are you using paid screen recorder?
Super sir
Thank you so much
Good video bro
Appreciate it
Good sr
V good sir.I really liked it.
Awesome please upload more
Thanks for comment. Much appreciated your comment.
thanks very much
Always welcome
Thank you
You're welcome
Thanks you
Most Welcome
Prefect one , thanks
JazakAllah
Thank you so much
I got my Pay stub easily and I can recommend y'all to 👇👇
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..
Very nice sir
Thank you so much
Nice payrolll 👍👍👍👍
Thank you so much
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
Thanks Cyber Credible
sir ese thoda nxt lvl up ka bnao plss exm mai tough ayega
Please suggest a formula in excel that a perticular date the basic salary will be automatically changed
tqsm for your video
Sir, I am from Bangladesh.
Most Welcome dear.
very nice sir g
Thank you so much dear.
Good how to calculate multiple projects salary n ot for one month
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.
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
Thank you , sir
Most Welcome
I can't believe I am learning this in grade 7, for which grade even is this video for ?
Liv stands for??? or yh pakistan wly b same bana skty?
Thanks for comment. Different for each country but the accounting rule will be same for all
Mine was approved and I got the apartment easily
Sir. Database excelil create ചെയ്തിട്ട് eg. 100 data entry ചെയ്തിട്ട് അത് print എടുക്കുക എങ്ങനെയാണ്.
Tx bhai
Most Welcome dear
Thanks
Most Welcome dear
is it the same way from start to end if he has to do new payroll?
yes sure