Software

Track accrued work hours or mileage using Outlook Tasks

Outlook tasks can help you track hours for specific projects and mileage for travel to see clients.

You  might not think to use Outlook to track hours and mileage-but it can. It takes just a bit of discipline, but it's time well spent, and much better than trying to keep all those details in your head or keep up with a stack of sticky notes. (Instructions for Outlook 2003 will be similar, but not always exactly the same as those for 2007.)

To track hours or mileage, you can use task details, as follows:

  1. Open the task you're tracking.
  2. Click the Task tab and then click Details in the Show group. In Outlook 2003, click the Details tab.
  3. Enter the hours worked, actual hours, and mileage.
  4. Enter the company if necessary.
  5. Click Save & Close.

Use the billing field to enter other details, such as a discount, rate increase, or whether you're charging for travel time. Consistency and discipline are the key. You must remember to document all your tasks this way to bill for them properly. When you're ready to invoice clients, you can use a custom view, as follows:

  1. In the Tasks folder, click the Change View in the Current View group on the Home tab. Then, choose Manage Views. In Outlook 2007, choose Arrange By from the View menu and then choose Define Views.
  2. Highlight the Completed view (Completed Tasks in Outlook 2007) and click Copy.
  3. Enter Billing for the name of your new view and click OK. In Outlook 2007, highlight Billing in the list of views (it's probably at the very bottom of the list. Then, Click Modify.
  4. Click Columns. In Outlook 2007, click Fields.
  5. In the resulting dialog, choose All Tasks Fields from the Select Available Columns (Fields) From dropdown.
  6. Next, add the fields you want to see and remove those you don't. In this case, you want to see the actual hours, billing, and mileage fields. Remember, this view has a specific purpose, so you don't need extraneous data. The simpler the view, the better.
  7. Click OK twice, and then Close.

To see the billing view, choose Billing from the Change View list (in the Current View group on the Home tab). In Outlook 2007, choose Current View from the View menu. Then, choose Billing from the list.

Because the billing view is based on the predefined completed task view, it will display details for only completed tasks. This behavior takes a bit of planning. If you want to bill for work done regularly, before you've completed the actual project (task), this particular view won't work for you.

The default view groups by the completion date, not the client, but you can easily regroup it, as follows:

  1. Click Change View in the Current View group and choose Manage Groups. In Outlook 2007, choose Current View from the View menu. Then, select Define Views.
  2. Find Billing in the list of views, click Modify, and then click Group By.
  3. Choose Company from the Group Items By dropdown. Continue to refine the view as necessary using the additional Then By dropdowns.
  4. Click OK twice and then Close.

Now the view will group completed tasks by company, making it easier to add multiple projects for the same client during the current billing period.

If you don't delete the completed tasks, this custom view will continue to display them, even after you've billed them. Perhaps the easiest workaround for this behavior is to move completed tasks to another folder once you bill the company - you can add a new folder to the Tasks window for this purpose. (The predefined completed view, on which your billing view is based, displays only completed tasks in the Tasks folder.) That way, you can keep these tasks for record keeping or historical purposes, without wading through them in the billing view.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

2 comments
vinnie1977
vinnie1977

@calvinweight Pretty good find. Looks like it uses the GeoLocation from google to calculate miles. I like the flexibility. Thanks

Editor's Picks