How to prepare a payroll in Excel

Рет қаралды 26,527

Күн бұрын

In this video I demonstrated how to prepare a payroll using Microsoft Excel.
Kindly please *SUBSCRIBE*, like and comment on my KZbin channel as a way of encouraging me to release more video contents such as this.
God bless you all ☺
You may be interested in other of our videos like:
How to prepare an Invoice using Excel:
• How to prepare an Invo...
How to prepare a simple Budget using Excel
• How to prepare a simpl...
#payroll
#excel
#salarysheet
#pension
#salaryadvance
#salaryslip

Пікірлер: 82

@omoabuganemmanuel3642 2 жыл бұрын

Share your view on this video in the comment section below. Thank you

@iyanuwonder3606 11 күн бұрын

Very understandable... Thank you

@omoabuganemmanuel3642 11 күн бұрын

Thanks for the Feedback

@ClarionttechHRServices Ай бұрын

You have done a great job, is there any regulated percentage for BHT?

@omoabuganemmanuel3642 Ай бұрын

In Nigeria, the regulated percentage for Basic Housing and Transportation (BHT) in payroll computation is: - 30% of basic salary for Housing - 20% of basic salary for Transportation This is in line with the guidelines provided by the National Salaries, Incomes and Wages Commission (NSIWC) and the Federal Inland Revenue Service (FIRS). The total BHT allowance is usually capped at 50% of basic salary, which is: 30% (Housing) + 20% (Transportation) = 50% Please note that these percentages are subject to change, and it's essential to consult the relevant authorities or a tax professional for the most up-to-date information.

@ClarionttechHRServices Ай бұрын

Thanks

@obednancy-ib1li 16 күн бұрын

Thank you sir❤

@omoabuganemmanuel3642 11 күн бұрын

You welcome. Don't forget to like and subscribe. Thanks for the Feedback

@portiachinda7982 Ай бұрын

Wow!!! I've been seeing payroll as rocket science until I stumbled upon your video. Your teaching is the Montessori pattern, very clear and concise 👏👏. Thank you so much. You earned yourself a big fan. 😊

@omoabuganemmanuel3642 Ай бұрын

Thanks for the Feedback really appreciate

@edisonidoko2324 5 ай бұрын

Excellent job..but I need video on store keeping record using excel

@omoabuganemmanuel3642 4 ай бұрын

Check out this video tutorial on that : kzbin.info/www/bejne/nWncn56Xl8l1jtksi=A89DPzhXBhO9qvPQ

@lebeneahiabor6646 6 күн бұрын

I love this ❤ Thank you, Sir.

@omoabuganemmanuel3642 6 күн бұрын

U welcome. Dont forget to like and subscribe

@victorlupai 10 ай бұрын

Thank you so much sir I really appreciate your lecture ❤❤❤❤❤❤❤❤❤❤❤❤ How do you calculate the subtotals from the departments/position

@Chairmoe_analytics 10 ай бұрын

You can use a Subtotal function to achieve that

@SmalltalkswithVee Күн бұрын

God bless you for this😊 but how do I upload as pdf without other cells included?

@constanciamabel8077 3 ай бұрын

This was so helpful, thank you

@Miguelskytwins Ай бұрын

Thank you for the video!

@omoabuganemmanuel3642 Ай бұрын

Thanks for the Feedback really appreciate

@patrickconstant7472 Ай бұрын

Thanks for sharing this.

@omoabuganemmanuel3642 11 күн бұрын

Thanks for the Feedback

@goodview360 Ай бұрын

great video, a lot learnt

@omoabuganemmanuel3642 Ай бұрын

Thanks for the Feedback really appreciate

@awosanyakemisola4046 10 ай бұрын

This awesome ❤ thank you very much 🙏

@omoabuganemmanuel3642 10 ай бұрын

Thanks for the Feedback consider subscribing to my KZbin channel for more updates

@rewacwalker7568 11 ай бұрын

I enjoyed this lesson so much, I watched the entire video then I watched it again and worked along side it. 🙂

@omoabuganemmanuel3642 11 ай бұрын

Thanks for the Feedback

@ChinenyeAkuonu 7 ай бұрын

Thank you very much. This was apt, precise and detailed, i can say i know how to fo payrolling

@omoabuganemmanuel3642 7 ай бұрын

U welcome thanks for the Feedback. I really appreciate

@davoupamtoma7922 Жыл бұрын

Wow I really enjoyed this lesson, thank u sir. Will need more videos

@omoabuganemmanuel3642 Жыл бұрын

Thanks for sharing your feedback sir I appreciate.. Kindly please hit the subscribe button below the video for more video content like this. Thank you sir

@OnyesRozy 2 ай бұрын

U are good

@omoabuganemmanuel3642 Ай бұрын

Thanks for the Feedback really appreciate

@IrwinOdee 5 ай бұрын

Helpful. Thank you

@omoabuganemmanuel3642 5 ай бұрын

You welcome dear

@Tiffany_Lindy 9 ай бұрын

Please, do you have a video on salary slip

@Chairmoe_analytics 9 ай бұрын

Unfortunately I don't have a video on Salary slip. I think it is available to only those of my students in the Advanced Excel Training class. Cos there I teach a lot ranging from Payslip, Computation of bank statements, Sensitivity analysis etc.

@sefraeric 6 ай бұрын

I understood every part of it thank you 🙏🏻

@omoabuganemmanuel3642 6 ай бұрын

U welcome. Thanks for the Feedback consider subscribing to my KZbin channel for more updates

@joshuagayina6913 8 ай бұрын

Thanks you for this video

@omoabuganemmanuel3642 8 ай бұрын

You welcome sir

@ibisojack3653 6 ай бұрын

Guy you dey teach…. I understood every part of it.

@omoabuganemmanuel3642 6 ай бұрын

Thanks so much for the Feedback

@egbagbetoyosi7476 Жыл бұрын

Very detailed 👍👍👍 You are the best... And this is your first video i watched 👍👍👍 kudos

@omoabuganemmanuel3642 Жыл бұрын

Thanks so much I really appreciate

@suchithavishwa939 5 ай бұрын

super

@omoabuganemmanuel3642 4 ай бұрын

Thank you

@basitolamide5297 Жыл бұрын

Excellent

@omoabuganemmanuel3642 Жыл бұрын

Thanks for the feedback

@NAOMIWANJIKUKINUTHIA 3 ай бұрын

goodwork

@omoabuganemmanuel3642 Ай бұрын

Thanks for the Feedback really appreciate

@drnjayy Жыл бұрын

So good, thank you.

@omoabuganemmanuel3642 Жыл бұрын

Thanks for the Feedback. I really appreciate

@euchariaonyemachi2241 Жыл бұрын

Great! kudos 👍

@omoabuganemmanuel3642 Жыл бұрын

Thanks for the Feedback

@queenbee_afo 9 ай бұрын

This is really detailed and well explanatory. Thank you, sir.

@omoabuganemmanuel3642 9 ай бұрын

Thanks for the feedback

@omowumiblessing8515 Жыл бұрын

So higher bro brainny

@omoabuganemmanuel3642 Жыл бұрын

Thanks dear I appreciate

@adebiyiademolataiwo507 11 ай бұрын

Bravo

@omoabuganemmanuel3642 11 ай бұрын

Thanks for the Feedback

@Tiffany_Lindy 9 ай бұрын

Excellent, for the first time, I have learnt how to do a salary payroll. But please, can I use this format for a small business of just 3 employees?

@Chairmoe_analytics 9 ай бұрын

Sure you can. Very suitable just some modifications. You know in small business u may not bother about all the allowances. So the basic salary and just bonus if it exist will be added to be the Gross Salary. In some cases self the basic salary will just be the Gross salary. For a small business you get.