How to prepare a payroll in Excel

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

[@omoabuganemmanuel3642]

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

[@tedchuks2562]

Please can i view the video on the SHEET 2 pension

[@omoabuganemmanuel3642]

@tedchuks2562 Here is the video on the Pension. kzbin.info/www/bejne/oJnUZJpul76BqdUsi=5ARQ4TdPVZt29ZpX

[@tedchuks2562]

do you have a video on odoo for the H.R

[@omoabuganemmanuel3642]

@@tedchuks2562 No I don't have a video on it at the moment.

[@tedchuks2562]

@@omoabuganemmanuel3642 Share with me when you have it. Thanks

[@nkurunzizasumayire]

May God bless you for taking your time just to help people.

[@omoabuganemmanuel3642]

Thanks for the Feedback. Amen

[@beautifultiana6578]

I love your video, they are so simplified anyone can understand. Thank u

[@omoabuganemmanuel3642]

U welcome. Thanks for the compliment.

[@ibisojack3653]

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

[@omoabuganemmanuel3642]

Thanks so much for the Feedback

[@OluwadamilolaOni-y6p]

God bless you for this Very very understandable

[@omoabuganemmanuel3642]

Amen thanks for stopping by and for the review

[@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

[@davisonphiri5554]

This is helpful for me a new beginner. I will appreciate any further help sir.

[@patrickconstant7472]

Thanks for sharing this.

[@omoabuganemmanuel3642]

Thanks for the Feedback

[@daryza7990]

Nice Sharing!

[@omoabuganemmanuel3642]

Thanks for the feedback

[@rewacwalker7568]

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

[@omoabuganemmanuel3642]

Thanks for the Feedback

[@sefraeric]

I understood every part of it thank you 🙏🏻

[@omoabuganemmanuel3642]

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

[@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

[@bentaokoo6680]

I totally love this.🇰🇪

[@omoabuganemmanuel3642]

Thanks so much for this feedback. Really appreciate

[@iyanuwonder3606]

Very understandable... Thank you

[@omoabuganemmanuel3642]

Thanks for the Feedback

[@queenbee_afo]

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

[@omoabuganemmanuel3642]

Thanks for the feedback

[@lebeneahiabor6646]

I love this ❤ Thank you, Sir.

[@omoabuganemmanuel3642]

U welcome. Dont forget to like and subscribe

[@ChinenyeAkuonu]

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

[@omoabuganemmanuel3642]

U welcome thanks for the Feedback. I really appreciate

[@Miguelskytwins]

Thank you for the video!

[@omoabuganemmanuel3642]

Thanks for the Feedback really appreciate

[@goodview360]

great video, a lot learnt

[@omoabuganemmanuel3642]

Thanks for the Feedback really appreciate

[@awosanyakemisola4046]

This awesome ❤ thank you very much 🙏

[@omoabuganemmanuel3642]

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

[@NAOMIWANJIKUKINUTHIA]

goodwork

[@omoabuganemmanuel3642]

Thanks for the Feedback really appreciate

[@euchariaonyemachi2241]

Great! kudos 👍

[@omoabuganemmanuel3642]

Thanks for the Feedback

[@emmanueluka2766]

Your lecture was much detailed

[@Chairmoe_analytics]

Thank you so much for the feedback ❤

[@omoabuganemmanuel3642]

Thanks for the Feedback

[@joshuagayina6913]

Thanks you for this video

[@omoabuganemmanuel3642]

You welcome sir

[@constanciamabel8077]

This was so helpful, thank you

[@agbedeisaiah940]

Excellent

[@omoabuganemmanuel3642]

Thanks bro

[@obednancy-ib1li]

Thank you sir❤

[@omoabuganemmanuel3642]

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

[@euchariaonyemachi2241]

Great

[@omoabuganemmanuel3642]

Thanks for the feedback kindly please subscribe to my KZbin channel for more updates

[@egbagbetoyosi7476]

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

[@omoabuganemmanuel3642]

Thanks so much I really appreciate

[@Dkingsprodtv]

God bless you so much

[@omoabuganemmanuel3642]

Thanks for the feedback

[@omoabuganemmanuel3642]

Amen

[@OnyesRozy]

U are good

[@omoabuganemmanuel3642]

Thanks for the Feedback really appreciate

[@dramaniabubakari3200]

Good job 👍 Please how do you save it when you’re done?

[@omoabuganemmanuel3642]

Go to file and click on save or Ctrl+s

[@IrwinOdee]

Helpful. Thank you

[@omoabuganemmanuel3642]

You welcome dear

[@edisonidoko2324]

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

[@omoabuganemmanuel3642]

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

[@SmalltalkswithVee]

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

[@victorlupai]

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

[@Chairmoe_analytics]

You can use a Subtotal function to achieve that

[@adebiyiademolataiwo507]

Bravo

[@omoabuganemmanuel3642]

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

[@thankgodgabriel8295]

Nice

[@omoabuganemmanuel3642]

Thanks for the feedback

[@suchithavishwa939]

super

[@omoabuganemmanuel3642]

Thank you

[@drnjayy]

So good, thank you.

[@omoabuganemmanuel3642]

Thanks for the Feedback. I really appreciate

[@Tiffany_Lindy]

Please, do you have a video on salary slip

[@Chairmoe_analytics]

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.

[@Tiffany_Lindy]

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]

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.

[@omowumiblessing8515]

So higher bro brainny

[@omoabuganemmanuel3642]

Thanks dear I appreciate

[@safiuridwan7378]

Excellent

[@omoabuganemmanuel3642]

Many thanks for the feedback sir I appreciate

[@basitolamide5297]

Excellent

[@omoabuganemmanuel3642]

Thanks for the feedback