Easy Payroll System In Excel

#Advance #InventoryManagement #excelforbeginners #geniusworld
Learn How to Create Payroll or Salary Statement in MS Excel. How to Calculate DA, HRA, PF, Gross Salary, EPF, LIC, Total Deductions, and Net Salary in Hindi, also learn how to format or Design Salary Sheet for your employees. Learn Excel basic formulas Sum, Percentage, Subtraction, etc. It is a complete ms excel training tutorial.
Excel Tutorials:
/ @geniusworldteam
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: / genius-world. .

[@ericadenison1019]

Excellent very well done, for small business once they learn to print cheques they don't need to buy payroll software. I use excel for payroll I love it! I think once people truly understand how delightful and easy excel is to use for payroll ie. in small companies there will be far less demand for compensation and payroll software. Our company has less then 20 people, I can just add whatever I need.

[@geniusworldteam]

Thank You so much !!!!

[@dearest-tulip]

I love that with the power of tutorials, one does not need a college course to learn how to construct spreadsheets

[@geniusworldteam]

Thank You So Much !!!

[@highdesertbutterflygrove]

Excellent and straight to the point. I appreciate how simplified your video is.

[@geniusworldteam]

Thank you so much for your kind appreciation

[@jamaicanstyle1111]

Thank you for this … great video am planning on trying a new job with data entry payroll this help me a lot help me to understand the basics

[@geniusworldteam]

Thank you so much !!!

[@merakigemini]

Thank you. Learned a lot. :)

[@samanthafoster1227]

Thank you very much for sharing🙏 I’m starting my small business and this will help me alot

[@geniusworldteam]

Your welcome & Best wishes for your business !!!!

[@okumualfred6663]

​11

[@marjoriemclaren1851]

Great example in an excel spreadsheet! it made it easier to understand.

[@geniusworldteam]

Thank you so much!!!

[@bubacarrnjie4281]

I really appreciated the video because it boost my understanding about salaries

[@geniusworldteam]

Thank you so much

[@grantdotson193]

Very intelligently taught.

[@robyemmanuel710]

Excellent, Thank you for sharing.

[@geniusworldteam]

Thank you !!!

[@dinowmoalimnour71]

Very smart thank you ❤

[@geniusworldteam]

Your Welcome !!!!

[@desiannwilliams1852]

I like this. Will be using it in my payroll journey

[@geniusworldteam]

Thank you for your feedback!!!

[@ericadenison1019]

Yes I use excel for our small company too, works well. Just added a cheque printing template.

[@Bintemujeeb]

Thnk you for sharing such an informative video

[@geniusworldteam]

Your Welcome !!!

[@bbroom78]

Thank you, it was very clear ♥

[@geniusworldteam]

Your welcome

[@hlulanipeseverence5269]

Thank you so much this is very simple and helpful 🙏🙏

[@geniusworldteam]

Your welcome!!!

[@eRIck-130ms-e2v]

This is one of the simplest video ever

[@geniusworldteam]

Thank you so much !!!

[@maearianboter6052]

Thank you and God Bless

[@geniusworldteam]

Thank you too and your welcome !!

[@giftsbeautyvlog144]

Thanks so very much

[@geniusworldteam]

Your Welcome !!!!

[@user-vr8qn3jf7l]

excellent and accurate job

[@geniusworldteam]

Thank you

[@victortedjere8652]

Thanks for sharing. Is there a template for public sector payroll?

[@geniusworldteam]

Thank you for your interest.
We have made it by using the simple technique but we will make the payroll on public sector soon.

[@rahavan8939]

Super sir...thank you so much 🎉🎉🎉🎉

[@geniusworldteam]

Your welcome

[@sundayspecialstsoai7751]

How about the ones that have different hourly for the weekday and weekends? I didn't understand when you got to the overtime

[@geniusworldteam]

Dear Sir,
We have used the usual time for routine hours and then over time. You can find the format as well about how we can set the over time to work on it.
Hopefully it will works

[@NineEyedOracle]

You could make two pay columns: Weekly Pay Rate and Weekend Pay Rate, then calculate the cost per number of hours for each. It would be very similar to how he split the overtime value here. The overtime is just an additional column to calculate hours worked at a different pay rate. The calculation he's running is to figure hours worked at a regular pay rate + hours worked at an overtime rate. So, to make this straightforward: If I work 2 hours at a regular pay rate of $10 per hour, I have made $20, right? If I work 2 more hours at an overtime pay rate (time and a half or 1.5x) of $15.00, I will have made $30 from the overtime that I have worked, right? Add those two together (20+30) and you get $50.00.
That formula looks like this:
(2 x 10) + (2 x 15) = $50. You solve in PEMDAS fashion.
I hope this answers all of the questions you had.
It's 6 months later so you may have already resolved the question for yourself, I'm sure. But just in case. :)

[@egoreruamoses8857]

Great and very helpful

[@geniusworldteam]

Thank You !!!!

[@joelsimonpraiseandworship649]

Simplified very well

[@geniusworldteam]

Thank you for your feed back !!

[@andu3206]

Thanks very much 😊

[@geniusworldteam]

Your welcome !!!

[@Mr.patron28]

great video

[@geniusworldteam]

Thank you

[@miamolydie3417]

Simple and straightforward, 😊 🎉

[@geniusworldteam]

Thank you

[@MegersaAhmed-py9hc]

Yes for every

[@geniusworldteam]

Thank you

[@dorcasgyasi514]

Neat work

[@geniusworldteam]

Thank You !!!

[@erprabhakaran]

I love you 💗 thank you

[@geniusworldteam]

Your welcome!!!

[@OkayIMThatGuy]

where can i get the template?new to excel need to create a payroll for my class

[@isaacmugala1656]

Bravo

[@emmanuelumar8319]

Thanks

[@geniusworldteam]

Your welcome!!!

[@saliyadubela]

well

[@geniusworldteam]

Thank you

[@alex_HRM]

This is very simple

[@geniusworldteam]

Thank you for your feedback

[@alex_HRM]

@@geniusworldteam I will like to talk to u privately

[@SeankirkGammon]

So bless

[@geniusworldteam]

Thank you so much !!!

[@katedivinagracia1145]

Is this the standard computation in all the companies??

[@geniusworldteam]

We have used the basic technique to explain the way. Definitely organizations use this technique to solve multiple criteria

[@TajudinAbdii]

Ok

[@user-ps5ld9mk1v]

please is more helpful

[@geniusworldteam]

Thank you !!!

[@JemalBuli-vx5ef]

Jeml

[@wegarajapaksha9000]

💜️🥹