Posted on

Closer to the Source

The sooner employees record actual hours worked, the more accurate they will be.  Some companies require team members to record their project hours.  Sometimes this is for client billing, other times for engineering or manufacturing projects.  Whatever the reason, I’ve seen firsthand that recoding hours soon after the actual event ensures accuracy.

Most people cannot remember what they did last week.  So if asked to fill in their timesheet for last week, they will not be able to pick out individual tasks.  Sure, they remember which projects they worked on, unless there are more than two.  But they cannot reliably remember which tasks.  It gets impossible when asked to assign actual hours to those tasks.  That is the primary reason DCAA (Defense Contract Audit Agency) requires timekeeping every day.  Even filling out timesheets at the end of the week is against the rules.  I don’t normally like government agencies, but in this case there is truth to their overbearing policies.

Standard Time® is an example of a professional timesheet with a built-in timer.  The image below illustrates the Quick Task window.  A link to a video is also included.

Prototype

Standard Time® Quick Tasks

In the Standard Time Quick Task window, you simple click project tasks to start and stop the timer.  Time log records are automatically entered into the timesheet.  That solves the problem of entering hours after the work is finished.  Actual work is sent directly to the timesheet; there is no delay.  And since you are clicking the checkbox to start and stop a timer, the actual work is as accurate as it could possibly be.

Most companies do not require minute-by-minute accuracy, unless you are charging them for time worked.  Only consulting companies really need this level of granularity.  For them, it’s much easier to justify invoices when the time accounting accuracy is beyond impeachment.  Simply print out the actual time log report (with records down to the second) and there is no disputing the accuracy.  Of course you can still milk the clock, but consultants are rarely accused of that.  But still most manufacturing companies that track projects for earned value purposes don’t need timer accuracy.

Whether your company needs timer accuracy, daily accuracy, weekly, or monthly, tracking time is almost always a good thing.  There is so much value in knowing how much time projects take.  Consider a few good reasons: comparing estimates to actuals, estimating future projects, assigning cost and estimates to new activities, or even know what employees are up to – all good things!

�

Posted on

YouTube Video: Consulting Software

This YouTube video for consulting software is pretty neat. It covers a lot of ground in five minutes, and is worth taking a look at. Amateur, but neat. The premise starts with a timesheet and closely related time log view where consulting hours are displayed. Of course, the timesheet is a typical Monday thru Friday grid with client projects on the left. Things got cooler with the time log ivew. The time log displays the same records as the time sheet, but in a top-to-bottom view.

Consultants will drool over this. Trust me.

For every time log record (which is also displayed in the timesheet) you get a client field, project, category, start and end times, actual work field, client rate, client cost, billable, and billed columns. There are other columns not shown that can be added to this view. Plus, you can filter that time log view to show only the work you did for a certain client or project, or only the work for a selected consultant. Or only work for a selected date range. That’s slick! You can also filter out the non-billable records and only see what is billable to the client.

But this is only where the app just begins…

The video goes on to show a glimpse of the billing rates window. (Wish it showed more.) It seems that you can set the billing rates for each consultant, and for each project they work on. So every consultant has his own rates for every project. And they only see the project they work on. Nice. But again, the video is brief, so you have to check this out for yourself – it’s just a five minute overview.

If time tracking is not enough, there is a menu item to show project revenue over a 12-month timeframe. This lets you see trends for the coming months and identify bad months that require attention. If only it also showed historical results for the last 12 months… That would be cool, but probably not as useful. Every project has its own win/loss percentage projections so it acts like a sales funnel. But all that’s a side issue that consulting companies get for free. Sure, you’ll use it, but the real stuff is logging billable hours.

The video sticks right to the point: client receivables and consultant utilization rates. That’s is the heart and soul of consulting. Get those wrong and you fail. So those reports let you see where your money is coming from, and what your effective billing rate really is. In other words, how much is your organization is billing for the work it does. Reports like this naturally raise the question, “How to increase your effective billing rate?” Edging out small increases is what consulting is all about. If you spend too much time on non-billable or in-house jobs, you die. If your effective billing rate is too low, you die. If you don’t book gigs, you die. If you don’t invoice billable hours, you die. This program seems to get that.

What is not mentioned in this video is equally valuable: expense tracking, client invoicing and QuickBooks integration. Yes, the product has those things, but the video fails to highlight them. Why? Not enough time, I suppose… I’m not sure. But it’s nice to know that there’s more to this product than the basics that can fit in a 5-minute video. Definitely worth a look.

Check it out: Consulting Software

Posted on

Task Lingering: Employees Avoid the Unfamiliar

Actually, not just employees… Everybody avoids the unfamiliar. But this post is about employees, and specifically project team members that engineer or develop new technologies. It’s about how employees sometimes try to settle into familiar tasks and avoid new and unfamiliar ones. And it’s about how to prevent that.

But wait… why prevent it? Isn’t efficiency gained by perfecting the familiar? By polishing your craft so you can perform it virtually without thought?

Yes, but this isn’t really about that. It’s about the propensity of employees to spend too much time on project tasks they have become familiar and comfortable with, to the exclusion of those upcoming tasks they dread the thought of.

I’ve heard reports of engineers racking up 200 – 500% extra time on tasks that could have been completed at the estimated time. Here’s the reason: people become comfortable with tasks they’ve spent significant time on and don’t want to leave them. The next task on their list may be unfamiliar and scary, so they stay on the one that doesn’t give off those vibes. The justification is that the current task could use some more polish.
Problem is, you’ve got to keep marching on. Your projects must be completed and delivered. You can’t afford to dally on project tasks you’ve already completed.

Here’s a technique you can use to discourage task lingerers. Set your timesheet “percent warning” to 75%. At that time, the task will begin reminding the employee that it’s time to move on. Of course, they may resist, but it’s a good reminder. Then set the “percent error” to go off at 125%. That stops team members from entering any more time. You can extend it with an administrator override, but at least you have some controls to monitor and manage task lingering.

Here’s a YouTube video that describes task lingering.

Posted on

Timesheet Administrators: Lock Your Timesheets Quick!

Have you ever locked your company timesheet when the week or pay period is over? If not, you’re probably wondering what for? Why lock an employee timesheet? Or you might be wondering how to do it at all.
Locking employee timesheets is done for two primary reasons: payroll and client billing.

First, payroll: If you use your timesheet hours to pay employees, those hours must be verified and deemed correct before entering them into payroll. Nobody wants to be shorted just because they missed a few daily entries, but it happens. You also don’t want to pay crafty employees twice what they should get, just because they entered 80 hours in for the week. Again, you’ve got to verify and certify before timesheet hours go to payroll.

But what happens if an employee makes a change after the hours have gone to payroll? For instance, they realize later that they actually worked a few hours overtime. Understandably, they want to be paid for those hours. But they may not know you have already cut the check. So they innocently enter the extra overtime hours, and nobody notices! The check was already cut before they entered them. Yikes!

Locking all the employee timesheets before you cut checks is the only safe solution.

In the example above, the employee would not be able to enter his overtime hours for the previous pay period because it was already being processed. Lock it down and they can’t enter any additional hours. Of course, they’ll come back screaming, but at least you won’t miss the hours. Just tell them to enter the hours for next week and they’ll get paid for them in the next check.

Second, client billing: It’s the same issue as payroll above. Employees who enter time for the purposes of billing clients may not know the exact time you cut an invoice. The scenario is the same: The Accounts Receivables department cuts an invoice for the previous month’s work… and then a day later one of the employees working on that project enters some additional hours – AFTER the invoice was already cut!

That’s a bad situation!

The Accounts Receivables department doesn’t realize that more time was added to this invoice date range, and, the employee doesn’t realize that the invoice has already been cut. So the billable hours he entered are effectively lost. Sure, they are in the system, but nobody knows they should be included on an invoice.

Oops!

Again, the safest solution is to lock the invoice date range before cutting an invoice. This prevents any new hours from being entered. Employees will get an error and realize they should put the hours into the next pay period instead.

Try locking your timesheets, if you deal with payroll or client billing!

Posted on

Hook a Timesheet to MS Project

PMO’s and project managers, have you ever considered hooking a timesheet to your MS Project MPP file? You spend a good deal of time pouring over your MS Project files, scheduling tasks, and assigning hours, but are you ignoring the ‘Actual Work’ field?

Do you have an automated way to input actual work?

Hooking a timesheet to the Actual Work field turns your static project schedule into a living, breathing document. You’re now releasing the beast into the wild, and you might be surprised at what it turns into! What, exactly, does that mean to release the schedule into the wild? It means letting employees enter their own actual work against their own tasks. It means hooking a timesheet to your project schedule. See this timesheet program for an example.

 

Getting actual working hours from employees might completely surprise you. Many project managers are uncertain how long tasks take. They have a good intellectual guess, or even some estimates from the actual engineers on the ground, but actual hours from employees can be a huge eye-opener. They are almost never what you expect. Project tasks often double or triple from their initial baseline estimate. No kidding! And when that begins to happen on a regular basis, panic sets in! You now have to either rein back your initial proposal or force employees to be more efficient.

See what I mean by setting the beast lose in the wild?

When engineers blow past your estimates, or even their own, they have no particular malice in mind. They are just doing their jobs. They may have no idea how those bloated task hours fit into a larger picture, or how they may affect a static project schedule. Again, they are just doing their jobs to the best of their abilities. And if that means a little extra work, then so be it. Problem is, stakeholders and project managers are freaking out as the schedule blows up. I once heard a manager say, “At this rate, we can only do a quarter of what we hoped.” That’s project management panic!

So back to hooking a timesheet to your MPP file… Sure, panic may set in for a while. You may need to rethink your plan. But you’ll be much more educated than if you had left the schedule in an “open loop” system without actual hours from employees. Ignorance is bliss!

A timesheet is the best thing ever invented for a project plan. They are so closely related, they should be in the same package! Fortunately, with this timesheet app, they are. In fact, you don’t even need MS Project. You can create your own project schedules with full hierarchy and project tasks, and then track time to them. You’ll instantly compare estimates with actuals, and avert most of the panic associated with a blown schedule.

Getting “Actual Work” feedback early is the best answer to project management panic!

Posted on

Three Reasons to Track Project Time

Time tracking, for the purposes of project management, is an overhead some companies are not willing to undertake.  (Read this as an exploitable mistake!)  We all know that some level of administrative overhead is necessary to maintain a healthy organization.  And some level of process or methodology is also necessary.  In this article, I’m suggesting that time tracking should be part of that process.

There are three primary reasons to track project time that apply to all organizations.  It matters nothing whether your company is a consultancy, manufacturer, government agency, non-profit, or otherwise.  Time tracking is valuable to all.  Here are the top three reasons to track project time.   1) Reduce budget overruns, 2) Prioritize projects, and 3) Learn your own business.

I’ll discuss these three project tracking benefits in detail.  Feel free to skip to the ones that interest you most.

1) Reduce Budget Overruns
Human beings are curiously bad with two things: time and money.  A huge number of cottage industries are built around helping people manage time and money.  Why?  Because almost every one of us does it badly.  Admit it… your bank account scrapes bottom almost every month.  And you’re late for at least one event per month.  That’s so easy to predict, I don’t even have to know you to feel confident in its reach.  Everyone suffers from the same poor time and financial accounting.

Unfortunately, we carry those same poor principles into our work life.  I’ll venture to guess that your boss, and his boss above him, is also a poor manager of his personal time and money.  Just because he’s a boss, doesn’t mean he’s any better at time management, or money management, than you are.  We’re all crap.

But if you’ll just subject yourself to a little time tracking discipline, you can avert the most common budget overruns.  It’s the low-hanging fruit you’ve heard so much about.  Just track the time you spend.  That time translates into salaries.  Now you know the project cost.  Don’t spend more than you take in.  Simple.

I know a great time tracking product for this.  It’s named Standard Time.  Click here for Timesheet and Time Tracking Software.  You can install this on everyone’s workstations, and start tracking project time.
You’ll see why it’s important in the next two reasons to track time.

2) Prioritize Projects
Instinctively, you know which projects are strategically important to your company.  You know which ones represent a strategic investment that will pay off big-time in the future.  Even the lowest employee knows that.  (Although it’s the company executives that should enforce the participation in such projects.)  So, are they doing that?  Are you doing that?  (Hint: if you’re a low or mid-level manager, here’s your chance to advance:  Talk “strategic projects” at every meeting.)

“Secondary projects” are nice to do when you’ve got time and money to burn.  Have you got time and money to burn?  If not, you must focus on the strategic projects.  They’re the only ones that make money and keep people employed.  And how, exactly, do you do that?  You track time to them!

Collect all your hours for every project you work on, and then run a report that shows you which projects are getting the most time.  You might be surprised!  Even better, categorized your projects as “strategic” and “non-strategic” and run the report again.  Which category is getting the most time?  Are you surprised yet?

If you’ve already downloaded Standard Time (see link above), you can get all these reports for free.

3) Learn Your Own Business
Last thing: learn your own business (LYOB).  It takes 2 -3 years to really learn a business.  You may have a good guess within your first six months of employment, but you won’t truly know it for another two years!  Tracking your project time chops a year off that.  Here’s why:

When you track time to company projects, you learn what makes them efficient, and what makes them inefficient.  You learn the gritty details because you see everything that goes into the work you do.  My advice: pour over the descriptions in every time log entered by every employee.  Submit yourself to the excruciating pain of studying these details.  You’ll perfectly hate it!

But even as you hate it, you’ll love it.  You’ll become an expert on your business and will soon have the information you need to make improvements.  Time tracking provides the information you need.

Best Time Tracking Program

Posted on

Project Tasks and Issues Tracking

You identify the scope and nature of a project. Design the project plan and assign resources and begin the process of real work and plan executions. Many tasks follow a predicted path and glide down the slope toward completion. Others hit speed bumps and issues arise. If you only encounter a few issues along the way, they are fairly easy to manage with emails and spreadsheets. The issues still require special attention and follow up costing time and energy, but manageable. What happens if you 130 issues arise in a short period of time (as is often the case in software development and bug fixes)? Spreadsheets and emails won’t cut it. In no time you lose track of events, issues and milestones. I am pointing out the obvious. But I have counseled hundreds of project managers using outdated tools and methods to track issues. Maybe project management and issue tracking software/tools cost a little money (others cost a lot of money), but believe me, they will pay for themselves many times over in saved projects, efficiency and ultimately the bottom line.

Posted on

Predictive Analytics

Predictive analysis uses historical records to predict future trends or outcomes.  That got me thinking; could that be applied to timesheet records?  The most common field for predictive analysis is credit reporting, where lenders hope to predict a buyer’s ability to pay.

Do you have a 900 credit score?  Me neither…

So, back to timesheet data…  What could we possibly learn from predictive analysis of timesheet records?  Here are some possibilities:

  1. Cost and duration of certain projects in your portfolio
  2. Employee contributions to strategic projects
  3. Typical project contribution histogram overlaid on today’s projects

–newshirt

Posted on

Timesheets are boring

Why get passionate about a boring timesheet tool?  They are little more than cells and dropdown choices that collect your time and expenses.  An endless bucket.  Pointless.  Employees reluctantly fill in those monotonous little cells every Friday afternoon or Monday morning for the week prior.  Time tracking is a chore with little value.

Okay, that’s one perspective…

But have you ever viewed them as an investment?  Like pouring value into your organization that you can mine later?  Consider that for a moment.

What if you could magically predict how long your next project would take?  Or cost?  What if you could walk into the next meeting with hard evidence that your company talents are unfocused and distracted?  That you are fighting too on many fronts?  And in too many battles without clear endpoints?  Wouldn’t that be worth documenting your time for.

That’s what time tracking gives you, among other things.  Still see it as a boring chore?

Posted on

Interview: Warren Peacock from Scoutwest, Inc.

The following text is an interview with Warren Peacock of Scoutwest, Inc.  They are the developers of Standard Time® and Standard Issue® – two leading project management products.  Project Team Blog wanted to hear from an authority regarding the status quo of enterprise project tracking and management, and learn what consulting and manufacturing companies face when attempting detailed time tracking.  We’re talking full-blown project schedules, timesheets to track task status, resource allocation, employee status, detailed reporting services – the whole enchilada.  Are most companies using these tools?  Or, do they attempt to roll their own with little in-house apps and spreadsheets?  Does the economy have a bearing on these choices?  One thing is certain; Warren Peacock has heard it all.  Let’s see what he has to say.

 

Q: Warren, would you say most organizations are doing an excellent, poor, or fair job of tracking project status?
A: Based on my experience I would say they are doing a poor-to-fair job, though well intended.

 

Q: What tools are they using now?
A: Some are using actual time tracking tools like Standard Time.  However, most companies are using Excel, shareware, or shabby little in-house programs.

 

Q: Where do you see room for improvement?
A: One word…Efficiency.   Time is our most valuable commodity and success starts with improving our use of it, regardless of the industry.

 

Q: Aside from acquiring better tools for project  tracking, what are the other ongoing costs of tracking projects and employee status?
A: Lost billable hours, unfortunately this is very common.  Also, which employees are most productive?  Standard Time has one simple report that gives you that type of data.  If you need to streamline costs where do you start, what do you cut?  Again, the right tools can give you that detail.  They will show you where you spend time as an organization.  What areas are over, or under allocated.  All of this is just a glimpse of improving efficiencies with project management and associated costs.

 

Q: And the return on investment for these tools?  How do you get there?
A: That sounds complicated, yet is very simple.  Most consultants and business owners I speak with estimate they are losing anywhere from 3%-10% of their billable hours.  Without question a conservative estimate is 1-3 hours per week, per employee.  Multiply that times their billing rate and you quickly realize how fast a time tracking tool like Standard Time pays for itself.  Not to mention the loads of reports and other information available to help guide any number of key decisions, regarding customers, projects and employees.  We don’t think twice about spending money on an employee’s phone, computer and any number of other items.  Time tracking is just as important.

 

Q: Let’s talk low-hanging fruit…  What can a company do to get started cheaply?  Spreadsheets?  Paper time cards?  Smoke signals?
A: Spreadsheets work to a certain point, but again the time spent managing, compiling and crafting reports will eat an employee’s productivity and provide very basic information at best.  Standard Time is less than $150 per user and easy to use.  You can place it on your own computers or we can host it for you.  No installation necessary.  Employees can be shown the basics in 5 minutes, no down time, no compiling spreadsheets and less user error!  Instantly you have more accurate information that will help propel and streamline any organization.