HoS Template for Excel

Keeping track of the Hours of Service data for local drivers can be a hassle.

When your drivers meet the requirements to use timesheets rather than log books, you are still responsible to maintain appropriate records of time. Filling out paper forms is time consuming and prone to mistakes.

That’s why we developed the HoS Timesheet template for Excel. It works with Excel 2007 and higher, allowing you to enter the timesheet information electronically. It is easier to enter, correct errors and to store. It also meets the requirements for timesheets under the various provincial regulations.

Note: It does not meet the requirements for a log book, so drivers that do not qualify for the 160 km rule must still keep log books. This can be a useful tool for monitoring the compliance of the drivers with the HoS rules.

If you are interested purchasing in this template, contact us for more details.

Video Tutorials

We’ve created a series of video tutorials that will show you how the template is used.

Installation and Customization

The template comes in a zip file with some extra documentation and license file. All you need to do is extract the template file and put it where you need it. Then you can customize the settings as needed.

Creating a Driver Workbook

You will need to create a workbook for each driver.

 Adding Months

The workbooks are organized into months. Every month you’ll need to add the current month (you can do this ahead of time if you like).

Entering Time Values

Entering time values is easy. Just start with a default and modify it accordingly.

Note: The latest version will automatically set the status of multiple cells that are selected within a duty status. There is no longer any need to right click and select Set Status as shown in the video.

Also, the problem with dragging cells has been dealt with and you should not see that in the newer versions.

Removing Months

Since you are only required to keep 6 months of data, you can delete older months from the workbook.

Just make sure you don’t delete a month too early. You can’t undo this.

4 thoughts on “HoS Template for Excel

  1. I would like to use the template as an audit tool for auditing drivers logs. Would this template work for US HOS? Also, does it provide notification of when there is a violation after inserting drivers HOS?

    • Hi Leon

      Currently, the template is only checking cycle hours for Canadian drivers. I haven’t implemented any further checks, or US rulesets since the ELDs are pretty much taking over. I still need to determine if there is enough of a market for me to spend the time developing the ruleset checking aspects. I’ve been very busy delivering training and mock audits for the past 6 months and haven’t had time to look at the template in a while.

      The template can be useful for calculation of cycle hours (even though it won’t flag a US violation properly) and to verify that drivers are properly entering their totals.
      Bill recently posted…CVSA International Roadcheck – 2018 – and Why I Hate Statistic Spinning!My Profile

  2. Thank you Bill for your response.

    I agree ELD’s are taking over but about a half of our fleet is older trucks and still using paper logs. I for one would love to see a ruleset checking aspect but I can understand the cost aspect of developing it if the market is not there.

    Please keep me in mind if you do go that route.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge
This blog uses premium CommentLuv which allows you to put your keywords with your name if you have had 3 approved comments. Use your real name and then @ your keywords (maximum of 3)