It’s a brand new year and just like for many of us at home, there are some things that will need doing in TimeControl to make sure we close off our previous calendar year and are ready for the upcoming year. Here are a few suggestions:
End of the Fiscal year?
If the end of the calendar year is the end of your fiscal year then this is a good time to be looking at your completed year of timesheet data to make sure it’s ready for Finance to get their year-end complete. A good start to this is to check for completeness.
- Are there any timesheets which were not completed during the year for any employee? The Missing Timesheet Report may help locate these.
- Did we close off the missing timesheet report for any employees who left the organization by entering a end-date in the employee table?
- Are there any timesheets which never completed their approval either because someone left or there was a change in the approval path? Using the Change-Ownership may help with those.
- Are there any more Debit/Credit corrections expected for the previous year?
- Are your full-year reports showing everything you need in the data? Running draft reports and checking against expectations will help with that.
- It’s a good time to check for end of year Accrual Rules to ensure they ran as expected. Some Accrual rules will use the end-of-year to automatically reset employee bank balances for things like vacation time.
- While we’re talking banks, this is a good time for a Banked Time review. Did employees use the banked time they were supposed to? Did the appropriate amount of banked time roll over into the new year? Are there any manual adjustments needed? Using Banked Time reports and delving into the Employee Table’s Banked Time Tab should help with that.
Start of year clean-up
Whether this is your fiscal year end or not, this is a great time to be doing some clean up of the TimeControl tables.
- Table clean up. Are there employees in the Employee table which are no longer with the organization? This might be a good time to either delete them or make them inactive. How about the Project and Charge tables? This might be a good time to be either deleting or marking tasks as Closed to filter them from view.
- Timesheet Archive. If you won’t be using the timesheet data from 2 or 3 years ago in your most common reports, you can Archive the Data and then include those timesheet records only by specifically asking to include archive data. This may help with performance of certain drop down fields.
- Rate Review. This is a great time to review your rates table and see if any rate values will change for the new year. Should you make new rates or just update the previous rate values? This depends on what will work best for your implementation.
- Filter Review. Are your charge code, reporting and other filters doing what you need? Some organizations use date-specific filters. If that’s the case for you, reviewing your commonly used filters for reporting, exporting or screen display might be required.
With a good review of your data now behind you, you’re ready to face the year! We hope it’s a good one and we at HMS are very much looking forward to working with you as the year progresses.


Version 7 of TimeControl brought a completely new display type to our viewer. A barchart or Gantt chart can show tasks or assignments in a barchart view similar to most project scheduling systems. Invented by Henry Gantt in the 1910’s, this type of display shows activities horizontally across a range of dates. It is, by far, the most popular display of task data.



TimeRequests™ and can be accessed from either the reporting view or from right inside the TimeRequest Approval screen.
In order to be able to evaluate the content of each timesheet cell and do all the validations that TimeControl is known and selected for, we had to move to a one-line-at-a-time edit. For new users, this was just fine but some users of the Windows-based interface felt that editing each line at a time was slower than they were used to.
Multi-line edit isn’t the only change in the timesheet. The new Options screen allows a number of new selections. For example, users can now decide if they wish to word-wrap header rows. This allows dates and the day of the week to be displayed on two lines but also allows the field to be narrow. Each column can also be defined to be word-wrapped. If you have longer project descriptions or charge descriptions, just click on wrapping that column. You can also define which fields on the left of the screen will be frozen in place in case you scroll to the right. This is particularly important if you have defined longer timesheet periods. If you have monthly periods for example, you’ll certainly want to freeze the project/charge descriptions on the left to be able to fill in columns far to the right!
HMS is in Minneapolis/St-Paul this week where we are the gold sponsors of the Minnesota PMI’s Professional Development Days event. HMS Software’s President, Chris Vandersluis will be speaking on two topics and HMS will have a booth to show off the latest version of TimeControl. The Symposium part of the week is Thursday September 15th and we’ll be auctioning off a big screen TV to one lucky attendee. Stop by the booth and speak to us about TimeControl 7 and how it might help solve your timesheet challenges.
You must be logged in to post a comment.