Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Forum at

Why should YOU join our forums?

  • Connect with other Glock Enthusiasts
  • Read up on the latest product reviews
  • Make new friends to go shooting with!
  • Becoming a member is FREE and EASY

Glock Talk is the #1 site to discuss the world’s most popular pistol, chat about firearms, accessories and more.

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

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

  1. ToyotaMan


    Jun 6, 2000
    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?
  2. DBradD


    Apr 24, 2005
    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.


  3. widmn


    Jun 7, 2000
    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 Pin Member #4

    Jul 3, 2000
    In The Pocket

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

  5. bunkerbuster


    Mar 22, 2005
    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


    Oct 5, 2001
    I've just used Excel to keep track of my own.