![\"\"](\"https:\/\/i0.wp.com\/davidbailey.consulting\/wp-content\/uploads\/2017\/03\/Weekly-timesheet-2.jpg?resize=300%2C120\")
<\/p>\n<\/p>\n
Most services businesses, from law firms through consultancies to outsourcers, rely on people entering time into timesheets. \u00a0At the most basic level, timesheets provide some form of audit trail that work has been done and, not least in Time & Materials projects, they provide data to support a fortnightly or monthly bill to the client. \u00a0Most firms have now moved beyond paper or spreadsheet-based timesheets and have either built or bought a simple timesheet system. \u00a0So far so good.<\/p>\n
Unfortunately, complexity and human nature then enter the fray! Consultants and associates dial into the timesheet system at the end of the week (if you\u2019re lucky!) and input a mixture of reality, the way they remember things and\/or the answer that the project manager tells them to enter \u2013 filling in the timesheet is a mechanical exercise, a chore! \u00a0Project managers use a timesheet approval process to manipulate reality to reflect the time estimates given in the project plan. \u00a0Also, there may or may not be a company policy in place about the \u201cprofessional day\u201d and how timesheet data is used to create client invoices \u2013 for example, if the (very!) simple figure below showed an individual\u2019s timesheet for a single week, how many days would you charge the client for Project A?<\/p>\n
| Hours worked<\/td>\n | Mon<\/td>\n | Tues<\/td>\n | Wed<\/td>\n | Thurs<\/td>\n | Fri<\/td>\n | Sat<\/td>\n | Sun<\/td>\n<\/tr>\n |
| Project A<\/td>\n | 8<\/td>\n | 10<\/td>\n | 6<\/td>\n | 11<\/td>\n | 2<\/td>\n | 0<\/td>\n | 2<\/td>\n<\/tr>\n |
| Business Development<\/td>\n | 0<\/td>\n | 0<\/td>\n | 3<\/td>\n | 0<\/td>\n | 2<\/td>\n | 0<\/td>\n | 0<\/td>\n<\/tr>\n |
| Internal\/Other<\/td>\n | 1<\/td>\n | 0<\/td>\n | 1<\/td>\n | 0<\/td>\n | 5<\/td>\n | 0<\/td>\n | 1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Depending on firm policies and client contracts in place, any one of the following (and more!) could well be correct:<\/p>\n – \u00a05 days<\/p>\n – \u00a04.875 days<\/p>\n – \u00a05.2 days<\/p>\n – \u00a04 days.<\/p>\n In passing, we used to have a timesheet code for \u201cInternal\/Other\u201d \u2013 it took some time before we realised that it was being used as a bucket to enter time into when it wouldn\u2019t fit anywhere else!<\/p>\n What we need is an internal culture whereby people enter their actual hours worked honestly into a timesheet system that is easy to use and clever enough to apply different sets of rules by project depending on company policy and client agreements (e.g. “a day’s a day” or “”a day is a period of eight hours with part days charged pro rata”)…..but that’s just the billing bit!<\/p>\n If the system can also\u00a0compare actual time entered with what was expected when an assignment was set up, it can then report out variances to client Partners, project managers etc. to allow them to\u00a0address project issues, identify potential training needs and learn about over\/under estimates applied during the sales process. \u00a0I’d like it to go further, however, and hold data about resource costs too so that we can understand, without resorting to endless spreadsheet analysis, real gross margin figures and compare them with plan, and highlight the right assignments to be discussed at Partner level…..now it becomes a more powerful and useful business management tool!<\/p>\n When used properly, timesheets contain a wealth of information that can be used to help the Partner team to optimise their business and keep their consultants fresh and ready for the next challenge.<\/p>\n","protected":false},"excerpt":{"rendered":" Most services businesses, from law firms through consultancies to outsourcers, rely on people entering time into timesheets. \u00a0At the most basic level, timesheets provide some form of audit trail that work has been done and, not least in Time & Materials projects, they provide data to support a fortnightly or monthly bill to the client. … <\/p>\n |