Results 1 to 6 of 6

Thread: Annul leave Accrual spreadsheet

  1. #1
    New Member
    Join Date
    Sep 2015
    Location
    Midrand
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Annul leave Accrual spreadsheet

    I need to develop a tracking spreadshet for (18 employees) that will calculate accruing annual leave based on the following:
    Employees are entittled 1 hour leave for every 16.4 hours worked ( 12 months cycle)


    I need to be able to deduct annual leave used. Need suggestion for layout , formula etc



    Thanks

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    How are you tracking the hours worked?
    The trouble with opportunity is it normally comes dressed up as work.

  3. #3
    Platinum Member sterne.law@gmail.com's Avatar
    Join Date
    Oct 2009
    Location
    Durban
    Posts
    1,328
    Thanks
    38
    Thanked 561 Times in 410 Posts
    Blog Entries
    7
    And how donyou generate payslips?

    In essence a column for each month, where you wil enter hours worked.
    A formula to calculate leave due.
    Columns for leave taken
    Balance
    But seriously, with 18 employees pay the R600 for payroll software.
    Anthony Sterne

    www.acumenholdings.co.za
    DISCLAIMER The above is merely a comment in discussion form and an open public arena. It does not constitute a legal opinion or professional advice in any manner or form.

  4. #4
    Platinum Member sterne.law@gmail.com's Avatar
    Join Date
    Oct 2009
    Location
    Durban
    Posts
    1,328
    Thanks
    38
    Thanked 561 Times in 410 Posts
    Blog Entries
    7
    On another note, how do you derive the 16.4 hours leave per hour worked?
    Anthony Sterne

    www.acumenholdings.co.za
    DISCLAIMER The above is merely a comment in discussion form and an open public arena. It does not constitute a legal opinion or professional advice in any manner or form.

  5. #5
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,978
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Quote Originally Posted by sterne.law@gmail.com View Post
    But seriously, with 18 employees pay the R600 for payroll software.
    Seems you and I are thinking along similar lines...
    The trouble with opportunity is it normally comes dressed up as work.

  6. #6
    Full Member
    Join Date
    Aug 2014
    Location
    Cape Town
    Posts
    69
    Thanks
    0
    Thanked 2 Times in 2 Posts
    I give 1.5 days per month (easier to manage) so got a spreadsheet with a "leave days due" column, minus "leave taken" column, equals "leave remaining" column...so leave remaining = (leave days due - leave taken) + 1.5......and pay someone to do the payroll

Similar Threads

  1. Easyfile CSV format document and example spreadsheet
    By Laurence Lombard in forum Tax Forum
    Replies: 10
    Last Post: 30-Oct-17, 12:06 PM
  2. Excel spreadsheet for VAT reconciliation
    By JaunetteK in forum Accounting Forum
    Replies: 17
    Last Post: 07-Jun-17, 07:03 AM
  3. ACCRUAL OF INCOME & EXPENSES IN PASTEL
    By Cindy79 in forum Accounting Forum
    Replies: 0
    Last Post: 19-Mar-15, 11:13 AM
  4. Year End Accrual after Vat Submitted
    By SSS100 in forum Accounting Forum
    Replies: 0
    Last Post: 22-Apr-13, 01:23 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •