When Time Tracking by Spreadsheet is No Longer Good Enough All Articles  
Palantir
Posted: 06 January, 2009
current rating
print Print Email Vote
If you have a small to medium sized organization and you need to track your employee time, you probably started simply enough. Using a spreadsheet method to list each employee, every project or client and the associated hours worked. At some point you will find it is time to move to a more formal approach to time tracking. For most organizations, this happens sooner than one might think. While the cost of a timesheet software program or license can be a consideration, the cost to you, your clients and your employees can be greater if your manual tracking process is inaccurate.

No matter how careful you are in reporting time, and no matter how dependable the staff assigned to check and track time, you are bound to suffer from human error. The more employees you have, the greater the number of hours to track and the greater the possibility for error. Whether it is an error in vacation pay, available staff hours, or client billing, these errors will cost you money and can be very frustrating for your staff and your customers.

Over and above the possibility of human error, there is the difficulty of tracking and reporting time, schedules, budgets and associated billing over a period of time. Sure, you can create a more elaborate master spreadsheet to roll up all the hours and employees and you can develop a formula to run totals and create simple reports. But, as your business grows and you add staff and skills, you will find yourself managing salaried and hourly employees, and trying to approve and track overtime, vacation days and paid holidays and sick days. You will also have to ensure that your managers are able to easily review and approve the time for their team members and in the midst of all of this, youll need to ensure each employee's privacy by giving access to pay and hours and personal information only to those who need to see the information to approve time. If you need labor information to justify a termination or report on a trend to justify additional head-count, you will find it difficult to pull all of that information out of a spreadsheet system.

When you are ready to graduate to a software system, you will find deep functionality in web timesheet solutions as well as software packages you install in your own network environment. Don't be put off by the price! There are plenty of options today and even a small business can afford a basic system. It will save you time, improve accuracy of information and allow your administrative staff to dedicate hours to activities that generate revenue instead of spending hours creating spreadsheets and manual reports.
 
Industry: Professional Services; Management Consulting; IT Services; Creative and Design Services; Engineering Consulting; Law; Accounting; *Any Industry*; *Any Sub Industry*
Share This Article
Software: Timesheet; Timesheet; Timesheet; Timesheet; Timesheet; Timesheet; Timesheet; Timesheet Directory
Palantir, author alias for Susan Obijiski, is a technology professional, consultant, business coach and writer. Her experience includes management consulting, and she has published research for Gartner Group. Susan is a frequent speaker and presenter on a variety of topics including software and technology, business strategy, process improvement and organizational culture change.

mailto: susanobijiski@aol.com
 
StreamSend review - online email marketing solution
Independent review of online email service provider StreamSend (Feb 2010)
GetResponse review - online email marketing solution
Independent review of online email service provider GetResponse (Feb 2010)
Benchmark review - online email marketing solution
Independent review of online email service provider Benchmark (Feb 2010)
Campaign Monitor review - online email marketing solution
Independent review of online email service provider Campaign Monitor (Feb 2010)
Online CRM Software Reviews coming soon...
Software Shortlist is expanding our review packs to cover online CRM software. As such, we are currently kicking off online CRM software reviews.
8 Tips for Great eCards
Two thirds of people prefer to receive eCards to paper greeting cards from business,16% for environmental reasons. 45% will forward emailed greeting cards. (Great Look eCard Survey 2009)
Software Review Policy | How Software Shortlist Creates Its Independent Reviews
Software Shortlist aims to produce high quality, independent reviews that you can trust and rely upon in your software selection process. Read on to find out how we achieve this high standard.
AWeber review - online email marketing & autoresponder solution
Independent review of online email service provider AWeber (Feb 2010)
The 5 goals of a project manager
As a Project Manager, you need to manage people, money, suppliers, equipment—the list is never ending. The trick is to be focused. Set yourself 5 personal goals to achieve. If you can meet these simpl
Encourage and Enforce Time Reporting System Use
Need advice on how to ensure your time reporting software is embraced by all employees? Here we explain what drives the appropriate use of this software and include a range of practical tips.
Add your own Article
About SoftwareShortlist
SoftwareShortlist is an innovative online platform that helps small to medium businesses compare, select and buy the right software for their specific needs.

read more...