Easy Payroll System In Excel

Поделиться
HTML-код
  • Опубликовано: 4 ноя 2024

Комментарии • 92

  • @dearest-tulip
    @dearest-tulip 5 месяцев назад +16

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

  • @ed1019-h8o
    @ed1019-h8o 5 месяцев назад +4

    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.

  • @highdesertbutterflygrove
    @highdesertbutterflygrove Год назад +10

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

  • @desiannwilliams1852
    @desiannwilliams1852 7 месяцев назад +1

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

    • @geniusworldteam
      @geniusworldteam  7 месяцев назад

      Thank you for your feedback!!!

    • @ed1019-h8o
      @ed1019-h8o 5 месяцев назад

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

  • @ElevateMindFocus
    @ElevateMindFocus Год назад +3

    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

  • @ekoi1995
    @ekoi1995 Месяц назад +1

    Gross Pay = (pay per hour)(total hours worked) + (overtime pay per hour)(total overtime hours)
    Income Tax = Gross Pay * income tax rate (%)
    Net Pay = Gross Pay - (Gross Pay * income tax rate %) - other deductibles
    Pay: Hourly wage or salary rate.
    Total Hours Worked: Total regular hours worked in a given period.
    Overtime: Additional pay rate for hours worked beyond regular hours, typically higher than regular pay.
    Total Overtime Hours: The number of hours worked beyond the regular work hours.
    Gross Pay: Total earnings before deductions (includes regular and overtime pay).
    Income Tax: Percentage of Gross Pay deducted for taxes.
    Other Deductibles: Additional deductions like insurance, retirement contributions, etc.
    Net Pay: Final earnings after all deductions (Income Tax and Other Deductibles).

  • @marjoriemclaren1851
    @marjoriemclaren1851 Год назад +3

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

  • @eRIck-130ms-e2v
    @eRIck-130ms-e2v 7 месяцев назад

    This is one of the simplest video ever

  • @justinaikwen8481
    @justinaikwen8481 Месяц назад +2

    Very simple to understand

  • @samanthafoster1227
    @samanthafoster1227 Год назад +5

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

  • @bubacarrnjie4281
    @bubacarrnjie4281 Год назад +1

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

  • @grantdotson193
    @grantdotson193 2 года назад +7

    Very intelligently taught.

  • @rahavan8939
    @rahavan8939 7 месяцев назад

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

  • @miamolydie3417
    @miamolydie3417 Год назад +3

    Simple and straightforward, 😊 🎉

  • @robyemmanuel710
    @robyemmanuel710 Год назад +2

    Excellent, Thank you for sharing.

  • @hlulanipeseverence5269
    @hlulanipeseverence5269 6 месяцев назад

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

  • @maearianboter6052
    @maearianboter6052 Год назад +1

    Thank you and God Bless

  • @bbroom78
    @bbroom78 11 месяцев назад

    Thank you, it was very clear ♥

  • @Bintemujeeb
    @Bintemujeeb 2 года назад +1

    Thnk you for sharing such an informative video

  • @merakicedarwoods
    @merakicedarwoods Год назад +1

    Thank you. Learned a lot. :)

  • @albertaappiah-v9p
    @albertaappiah-v9p 11 месяцев назад

    excellent and accurate job

  • @justinaikwen8481
    @justinaikwen8481 Месяц назад

    Please can you do a video of excel for beginners

    • @geniusworldteam
      @geniusworldteam  Месяц назад

      Thank You So much for your feedback.
      We are working on the course in two sections Ms Excel for Beginners and Advanced Ms excel.
      Hopefully we will start both simultaneously soon !!!

  • @egoreruamoses8857
    @egoreruamoses8857 7 месяцев назад

    Great and very helpful

  • @joelsimonpraiseandworship649
    @joelsimonpraiseandworship649 6 месяцев назад

    Simplified very well

  • @dinowmoalimnour71
    @dinowmoalimnour71 4 месяца назад

    Very smart thank you ❤

  • @katedivinagracia1145
    @katedivinagracia1145 11 месяцев назад

    Is this the standard computation in all the companies??

    • @geniusworldteam
      @geniusworldteam  11 месяцев назад

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

  • @andu3206
    @andu3206 7 месяцев назад

    Thanks very much 😊

  • @victortedjere8652
    @victortedjere8652 2 года назад +1

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

    • @geniusworldteam
      @geniusworldteam  2 года назад

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

  • @giftsbeautyvlog144
    @giftsbeautyvlog144 4 месяца назад

    Thanks so very much

  • @erprabhakaran
    @erprabhakaran 11 месяцев назад

    I love you 💗 thank you

  • @Mr.patron28
    @Mr.patron28 Год назад

    great video

  • @sundayspecialstsoai7751
    @sundayspecialstsoai7751 Год назад +1

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

    • @geniusworldteam
      @geniusworldteam  Год назад +1

      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
      @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. :)

  • @alex_HRM
    @alex_HRM Год назад

    This is very simple

    • @geniusworldteam
      @geniusworldteam  Год назад +1

      Thank you for your feedback

    • @alex_HRM
      @alex_HRM Год назад

      @@geniusworldteam I will like to talk to u privately

  • @NaomiGarcia-x9e
    @NaomiGarcia-x9e Месяц назад

    How did you get the other deductibles?

    • @geniusworldteam
      @geniusworldteam  Месяц назад +1

      We have used the main elements that usually found in any organisation !!!!

  • @OkayIMThatGuy
    @OkayIMThatGuy Год назад +1

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

  • @isaacmugala1656
    @isaacmugala1656 8 месяцев назад

    Bravo

  • @lillianrightmasika1546
    @lillianrightmasika1546 Месяц назад

    what money is represented by column pay, i thought it is gross but it is not,

    • @geniusworldteam
      @geniusworldteam  Месяц назад

      Thank You for your comment.
      We have used the general formula in order to make it simple. We can add mutiple columns like medical expense or allowances to make it more realistic.
      Thank You.

  • @dorcasgyasi514
    @dorcasgyasi514 6 месяцев назад

    Neat work

  • @tibebumdechasa7808
    @tibebumdechasa7808 2 месяца назад +1

    🎉

  • @MegersaAhmed-py9hc
    @MegersaAhmed-py9hc Год назад +1

    Yes for every

  • @emmanuelumar8319
    @emmanuelumar8319 11 месяцев назад

    Thanks

  • @SeankirkGammon
    @SeankirkGammon Год назад

    So bless

  • @saliyadubela
    @saliyadubela Год назад +1

    well

  • @SylvesterADIT-p6n
    @SylvesterADIT-p6n 8 месяцев назад

    please is more helpful

  • @JemalBuli-vx5ef
    @JemalBuli-vx5ef 10 месяцев назад

    Jeml

  • @TajudinAbdii
    @TajudinAbdii 5 месяцев назад

    Ok

  • @wegarajapaksha9000
    @wegarajapaksha9000 11 месяцев назад

    💜️🥹