close

Privacy guaranteed - Your email is not shared with anyone.

How to keep track of accured/used employee personal time?

Discussion in 'Business Forum' started by ToyotaMan, Jun 29, 2005.


  1. ToyotaMan

    ToyotaMan
    Expand Collapse

    Joined:
    Jun 6, 2000
    390
    0
    Location:
    USA
    Does anyone have a good system for keeping track of a group of employees accrued and used personal time? Days off? Absenteeism?

    I've got 20 employees and honestly, I do a pretty poor job of keeping track of these things.

    Do you have a spreadsheet that you use or have you found a computer program that does a good job of it?
     

    Wanna kill these ads? We can help!
  2. DBradD

    DBradD
    Expand Collapse

    Joined:
    Apr 24, 2005
    2,848
    0
    Location:
    Kentucky
    At the last job I had before retiring from working for others, we filled out excel timesheets on the computer. Vacation, sick time, etc had their own activity codes. The total for each week had to add up to 40 (or more for salary types) and the timesheets were submitted, either electronically or hard copy every pay period. The accountant extracted the numbers and they all appeared on the paycheck stubs. This worked fine for the company, which had about 45 employees and one accountant. It was fairly elaborate because the company did about 300-400 projects per year, some lump sum, some hourly, etc, so the project time had to be accounted for in fair detail, along with personal time.

    I've thought this over a little and think I probably would have everybody fill out excel timesheets and submit them electronically. It would not be difficult to have another excel spreadsheet for my use only that processed the information, adding accumulated sick/vacation time, subtracting used sick/vacation time, sorting the hours spent on the different project numbers, and preparing invoices. Being an engineer, I might do this in Mathcad instead because it has more powerful programming and document preparation features.

    I hope this helps.

    DBD
     

  3. widmn

    widmn
    Expand Collapse

    Joined:
    Jun 7, 2000
    226
    0
    Location:
    PA usa
    For greater numbers of employees and/or project type tracking, there are several programs out there such as Kronos, ADP has a Kronos light version, and others.
     
  4. kestrou

    kestrou
    Expand Collapse
    Pin Member #4

    Joined:
    Jul 3, 2000
    1,593
    0
    Location:
    In The Pocket
    TM-

    What accounting software do you use for your business? It should have a good payroll module that handles accrued and taken benefit time (vacation, sick, personal, etc.)

    kestrou
     
  5. bunkerbuster

    bunkerbuster
    Expand Collapse

    Joined:
    Mar 22, 2005
    129
    0
    Location:
    CO/CA
    Intuit Quickbook Pro is good software.

    If you are talking about tracking time during their work hour, there is a time clock card that goes electronic. It will track employees' time.
     
  6. ClydeG19

    ClydeG19
    Expand Collapse

    Joined:
    Oct 5, 2001
    5,197
    909
    Location:
    Arizona
    I've just used Excel to keep track of my own.