Category Archives: timecontrol

It’s back to ABC’s – We mean Activity Based Costing!

Activity Based Costing, ABC, Enterprise Project Management, TimeControl, TimeControl White Paper, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisIt’s Activity Based Costing week here at HMS and we’ve got a bunch to talk about.

Activity Based Costing is hardly new.  It has been a part of project management for as long as there has been project management.  If you want to change a part of your new building, you need to know what the change will cost for that particular activity.  You can’t make an informed decision about project changes without knowing what the estimate of that feature cost you in the first place.

TimeControl was designed since its inception as an activity based system and with the powerful rates functionality built into TimeControl, the associated costing features are extensive.

We’ve just produced a new White Paper called Activity Based Costing Using TimeControl which looks at how you can use those extensive costing features to deploy Activity Based Costing from numerous perspectives.

At the same time, there is an article on Chris Vandersluis’s EPM Guidance Blog site on the ABC’s of Activity Based Costing.

TimeControl webinar in french – en francais!

Webinar, TimeControl, Idexia, timesheet, feuilles de temps, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisHMS is a bilingual company and, from time to time we get the opportunity to do a webinar or other public presentation in french.  Working our partners Idexia, we have organized a TimeControl webinar for July 18th in french.  The invitation is below.  We’ve sent invitations to our Quebec-based contacts but if you are a french speaking person or know a french speaking person who would like to attend, please give them this invitation.


Réservez votre place pour le webinaire TimeControl, une solution de Logiciel HMS!

Optimisez la productivité de votre entreprise avec TimeControl, une solution puissante et flexible pour la gestion des feuilles de temps.

Conçue ici même au Québec par Logiciel HMS pour s’adapter aux environnements complexes, TimeControl vous permet de suivre le temps de vos ressources, de gérer les coûts et de renforcer le contrôle de vos projets – le tout en un seul endroit.

Si vous cherchez une alternative aux feuilles de temps de Project Server ou Project Online, ce webinaire est pour vous.

Fonctionnalités clés :

✅ Saisie du temps multi-projets
✅ Intégration avec les principaux ERP, systèmes de paie et logiciels de gestion de projets
✅ Validation automatique des feuilles de temps
✅ Suivi des coûts et des ressources en temps réel
✅ Conformité aux exigences des crédits d’impôt pour la recherche et le développement

Venez assister à notre webinaire gratuit afin de découvrir TimeControl, une solution de feuilles de temps qui s’intègre à une multitude de solutions de gestion de projets, notamment Project Server, Project Online et BrightWork ainsi qu’aux principaux systèmes financiers, incluant SAP et Oracle.

Déjà implantée à travers le monde et au Québec dans différents secteurs d’activités, incluant des organismes gouvernementaux, TimeControl est une solution multilingue hautement configurable afin de s’adapter à vos processus internes.

Lors du webinaire, vous verrez la puissance et la flexibilité de la solution TimeControl.

Ce webinaire est réalisé par Logiciel HMS, éditeur de TimeControl et leur partenaire intégrateur, Idexia.

Au plaisir de vous y voir!

Réservez votre place dès maintenant :

📅 Mercredi 18 juin 2025
🕚 De 11h00 à 12h00
🤩 Gratuit
💻 En ligne

JE M’INSCRIS

Pour en savoir plus : www.idexia.com | 1 877 880-8771 | info@idexia.com

www.timecontrol.com | 514-695-8122 | info@hms.ca

The TimeControl Deployment Process

Deployment meetings and TimeControl QuikStart, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisWith an enterprise product as flexible as TimeControl, how to deploy the system is as important as the functionality it contains.  HMS has been deploying enterprise project management and timesheet systems for over 40 years and TimeControl itself for over 30, so we bring some experience to the process.

There is no need to have HMS help with a TimeControl deployment.  The system will be fully functional on the first day the client gets access whether that is for TimeControl Online or TimeControl on-premise but leveraging our experience can make the implementation go quite a bit faster and avoid the risks of forgetting an important step.

If we are commissioned to assist, one of the first things we’ll do is set up one or more design sessions.  The number of sessions and the length of those sessions is completely dependent on the client.  We usually start with the list of requirements that were given to us during the sales process.  That starts the groundwork of what TimeControl will have to deliver.  Our design sessions start with a product overview given by one of our experienced deployment personnel.  They will go over the major points of functionality then delve deeper into the requirements themselves.  This keeps the focus on what the client is trying to solve but also ensures that we don’t miss talking about what other functionality in TimeControl might be useful either in the first phase of deployment or later.

We use our QuikStart program to condition the conversations.  There is a brochure for the QuikStart and slides to help during design sessions, but that is really guidance, not a single formula.

We have lots of questions for the client and usually this means after a first session, the client will need a break of a few hours or a few days to do homework.  Some questions might seem obvious but then need thought and discussion before the system can be configured.  “How long should a timesheet be?” is a common one.  “Is that for everyone or will some people have different lengths of timesheets?”  “Who will approve timesheets?”  “Will you track costs and if so is that just for one requirement or multiple?” “Are there auditability requirements for the DCAA or Research Tax Credits?” “What about line-item approvals?” “What reports does the system need to produce and do you have examples already?” “Will you be tracking start/stop times?” “Will you be tracking expenses?” “What external systems will TimeControl be linked to?” “Are the people representing those systems here on the design call?” “Who will be the TimeControl Administrator(s)?”

And so on…

When the answers are all in, we have to work backwards from outputs to inputs just like you learned in Systems Analysis 101.  If, for example, a report will be needed by location, then we have to make sure the location of work is represented in the user defined fields per task.  If there is a need to do a report of costs spent by department, then we know that employees will have to have a department field defined and a list of departments to choose from. We’ll also need to have rates set for costing at either internal cost, external billing rates or both.

When the exercise is complete, we assemble a design document and the client gets a chance for a final read-through before signing off.

Then it’s time for the client to go find some data.  Given the different requests, we assemble a template spreadsheet for Projects, Charge Codes, Rates, Users, and Employees as well as approval paths.  The spreadsheets will have in them the fields that were defined as needed for the different requirements of the system.

Once received, HMS pumps that data into the client’s TimeControl and turns it over for testing to the client prior to going live.  Sometimes there are changes.  It’s possible that something looks different when the client sees it live from how they imagined it in the design meetings. Those changes are usually very quick to make.

Then it’s a wrap.  Usually the client will roll out to a select group of users first and if they already have a timesheet system have that group work with both systems in parallel before making the “go live” decision for all users.

The length of time for the entire process varies greatly depending on the number of users, the number of external systems which will be integrated with TimeControl but most of all by the level of clarity by the client of what they need TimeControl to do.  It can last 2-3 days or several months.  It wouldn’t be surprising for a client with several thousand licenses to engage HMS for 3-4 weeks of work to be delivered for a 12-16 week period.

There can be further phases once the deployment is complete but usually for the existing functionality, there’s nothing more to configure for the foreseeable future.  We keep track of the documentation we create for the system and the client is responsible for creating their own process documentation and maintaining it internally.

If you would like more details on how TimeControl is deployed, you can go to https://www.timecontrol.com/resources/services/consulting or contact HMS at https://www.timecontrol.com/contact.

Graduating your timesheet from Excel to TimeControl

Excel is almost certainly still the most popular timesheet in the world.  There are, after all, free templates to make a timesheet right in Excel.  For smaller companies getting started or for people in Finance who grew up with Excel, it might seem an obvious choice.

But, while it may seem an obvious choice, the drawbacks are numerous and, the larger and more complex an organization becomes, the worse those drawbacks become.

Any need for auditability of a timesheet will be a struggle with an open ended system like Excel.  It’s designed for analysis, not for accountability.  If you need to harmonize your coding or just need to find missing timesheets, Excel becomes a labor intensive nightmare.  Most Excel-based timesheet deployments means sending templates for the timesheet to each employee then gathering those documents, merging the data, dealing with discrepancies and then filing a combined report.  That’s one thing if it’s 10 employees and a very different thing if it’s 500!

For those thinking it might be time to graduate up from an Excel timesheet to a full application designed for the purpose, it’s worth nothing that TimeControl was designed to have Excel Integration from its very first version back in 1994.

We didn’t stop there.

The points at which TimeControl and Excel can intertwine can be multi-faceted.  It is able to import Excel worksheets for lists of projects, charges or employees, rates or almost else. So moving your Excel system into TimeControl is a natural progression and that’s just the start.  Here are a few points of contact between the systems.

Importing and Exporting data between TimeControl and Excel

TimeControl includes complete support for transferring data to and from Excel files.  If you maintain some data now in Excel, then moving that into TimeControl is a matter of moments.  If you use Excel for analysis of data, then sending TimeControl’s centralized and auditable data back to Excel is very simple.  You can even schedule exports to Excel or imports from Excel to happen automatically on a schedule you define.

Importing legacy timesheets from Excel to TimeControl is already included

TimeControl includes import functionality for timesheets themselves so if you have an existing timesheet system in Excel you can transfer that data into TimeControl.  Our Excel Solutions Portal even has a template for you to download and use so you don’t have to create it yourself.

Integrating Excel Services dashboards into TimeControl

Some people like using Excel’s server-based charting capabilities to create analysis of timesheet or project management data.  TimeControl supports displaying Excel views in the dashboard.  Need an Excel pivot report in your TimeControl dashboard?  No problem. Need an Excel traffic light on the TimeControl dashboard?  No problem.

Displaying TimeControl Reports in Excel

Every TimeControl report including those created in our TimeControl Report Designer or with the TimeControl Drill Down Analyzer can be saved as Excel files so you can do more extensive analysis and reporting in the tools you are familiar with.

Migrating from Excel to TimeControl or TimeControl Online is so simple

TimeControl and TimeControl Online are almost always configured from Excel files.  Our technical staff give templates to new clients so they can configure the data they want into TimeControl with the features they want to enable.  If you’re using Excel already you’re all set to go.  And, if you’re subscribing to TimeControlOnline, there’s nothing to install, no servers or databases to configure.  Once your subscription is activated, you are ready to start moving your data into the system and activating your users.  Most small to medium sized organizations are able to enter timesheets a few days after subscribing.  You could be looking at your own TimeControl system only a few hours from now.

You can find out more about how TimeControl and Excel can work together to help your organization become more efficient on our TimeControl/Excel Use-Case portal at: Timecontrol.com/use-cases/excel-to-timecontrol.  On the portal you’ll find webcasts, factsheets and slide presentations explaining some of your options and potential benefits.

Oracle has confirmed that HMS Software will be part of the Oracle Partner Network for a 28th year

Oracle and HMS Software have confirmed that they have extended their technical alliance for a 28th consecutive year. Oracle Partner Network, Chris Vandersluis, Christopher Vandersluis, Christopher Peter Vandersluis

This is one of the longest lasting technical alliances in the IT industry.  The two companies started working together in 1997.

HMS sought out two technical alliances in 1997, one with Oracle to support TimeControl’s new ability to store data in an SQL database such as Oracle’s and another with Primavera to support the integration between the TimeControl timesheet system and Primavera’s extensive project management system. The intent of the alliance was to provide superior support to Oracle and HMS Software’s mutual clients.

The relationship and alliance has extended and deepened over the years.  That started with Oracle purchasing Primavera in 2008 and those two lines of integration and support were extended.    TimeControl now supports multiple Oracle products including NetSuite, JD Edwards and MySQL.

The intent of the alliance has not changed.  The beneficiaries are the same as they were back in 1997,  a superior level of support and integration for our mutual customers.

Some of the many TimeControl’s value-added benefits when linking with Oracle-Primavera include:

  • The multi-functionality and auditability of TimeControl that allows it be used for project management, HR, payroll, invoicing, job costing and government compliance all at the same time
  • Support for multiple rates per employee
  • Automated business rule validations
  • Automated workflow
  • Vacation management
  • Missing timesheet notification
  • Simultaneous support for multiple versions of Primavera
  • The free TimeControl Mobile App for smartphones and tablets supporting both iOS and Android
  • Matrix timesheet approvals with HMS’s unique Matrix Approval Process for Labor Actuals™
  • With TimeControl Industrial, the Crew Timesheet and Materials and Equipment field data collection

To read the recent press release on this relationship, visit TimeControl.com/resources/newsroom/press-releases/2024-05-15. For more information on how Oracle and HMS Technologies work together, visit the Oracle/TimeControl Portal at: Oracle.TimeControl.com or contact HMS at info@hms.ca.

 

TimeControl integration comes through many paths

TimeControl Integration, Integrate or Interface, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisTimeControl is an enterprise system and, like all enterprise systems, it rarely exists alone.  Since its very first version, one of TimeControl’s most important features is its ability to integrate with other tools.  Over its long history, those integration abilities have evolved with many different features.  In some organizations, it will be desirable to see a seamless integration driven by the particular needs of certain tools.  Linking with Project Management tools is often like that.  The movement of data between TimeControl and Project Management tools means a certain back-and-forth with each transaction because so much of the transaction affects to many other things.  This is why TimeControl includes pre-built integrations with so many project management packages.  For Finance, however, it is extremely common for a CFO to tell us that they have no desire for any external system to push data into their ERP system.  They far prefer a transaction file to be created to their specifications and that they will consume that file with their own controls.

TimeControl has many ways to serve up or consume data.  Let’s take a look at a few:

Imports and Exports

One of the easiest and most popular ways to move data between TimeControl and other corporate systems is to use the TimeControl import and export links.  This functionality has been enhanced numerous times over the years and it works just as well in TimeControl Online as is does in TimeControl on premise.

TimeControl can consume a file for import (such as updated employees from new hires) on demand at any time.  The file can be in Excel or CSV format and you can use a pre-existing template to move the data in from your PC or wherever you access it at any time.

TimeControl Imports and Exports can be automated to happen behind the scenes on a pre-defined schedule.  You can use encrypted secure FTP transfer protocols to locate a file for import or to transmit a file as an export and then automatically send an email announcing if the file was transferred successfully or if intervention is needed.  This can be a great way to update TimeControl from HR records.  The HR system can create an onboarding file for TimeControl in a specific location and TimeControl can check for it and consume it overnight.  There will be a log of the file import so the Administrator can make sure it was imported successfully.

We tend to talk about Import/Export as an interface rather than an integration but that’s semantics.  The data is being integrated between different systems in a controlled and monitored fashion.

Links to Project Management

TimeControl comes with numerous pre-built and configurable integrations with Project Management Systems.  This has always been a part of TimeControl. Given TimeControl’s multi-decade longevity, some vendors are no longer supported because their products are no longer supported.

Project Management Links are almost all bi-directional based on the capabilities of the pm system in question.  These include links to Microsoft Project, Project Online, Project Server, Project for the Web, InEight, Hard Dollar, BrightWork, Contruent, Open Plan, Oracle’s Primavera and Primavera EPPM.

Authentication for these tools is managed within TimeControl depending on the requirements of the system.

Links via API

TimeControl’s ultimate integration is its bi-directional full service RESTful API (Application Programming Interface).  This interface allows the client to create code to access TimeControl directly to push data or to pull data out for almost every aspect of the system.  The API makes sure that requests through it won’t violate TimeControl’s referential integrity or any of the other database-based or configuration based rules.The API’s power is extensive.

This is one method clients can use to pull TimeControl data and then data updates for external data management systems like Microsoft Power BI or other reporting or analysis tools.

Talk to a TimeControl specialist about your particular needs of integrating TimeControl with other corporate systems.

Localization is more than just language

TimeControl Localization, Multi-language, bilingual, TimeControl, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisTimeControl was available in both English and French on its first day on the market. The term localization hadn’t even been coined at the time, but it would have been quite appropriate. HMS Software, the publishers of TimeControl is, after all, headquartered in Montreal, Canada where both English and French are common. So, TimeControl itself as well as our website has always had elements of both French and English.

It should be no surprise then, that the system was used all over the province of Quebec, in France and other predominantly francophone locations. By the time we got to TimeControl version 3, we had realized that the product would have to do more than support just two languages. Localization refers to more than just the screen interface. Date formatting, for example, differs between the US (MM/DD/YY) and Canada (DD/MM/YY) so we realized early on that meeting local user needs would be a more extensive effort.

The result appears in several places in TimeControl. The language used to present the interface is selected by the end-user in their MyAccount area. It is defined in the TimeControl languages module where admins can not only define which languages are available but also modify the existing language definition. So, if a particular term such as Projects would be better to be called Mandates, that is changeable by the Administrators. More than that, while

TimeControl now ships with a number of different languages, if needed, Administrators can add their own definition.

Localization doesn’t stop there. Date formatting is defined by the administrator as a configuration setting as is the display of currency symbols and even the number of digits. This is defined at the User Profile level so some users might see TimeControl looking one way and other users could see it looking quite different. The language can be defaulted for an individual but they can select a different language just for themselves should they wish. For documentation, aside from the English or French user guides provided by HMS, clients can add their own internal user guide in whatever language they wish using the Menu editor.

The result is having the end-user comfortable to quickly enter TimeControl, do the work they have to do in the system and then get out as effectively as possible.

Keeping up with the Technology Stack

TimeControl, Technology Stack, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisTimeControl started quite a long time ago.  By the time 1994 arrived and we had decided to publish TimeControl as a commercial off the shelf (COTS) timesheet system, we knew already that we would have to continue to work hard to update the product for technology that was changing dramatically even as we launched.

The first version of TimeControl was as a DOS product, a character-based interface.  That would be supplanted within the year with TimeControl version 2, with a Windows interface.  We were working on version 3 even as we launched that version.  TimeControl 3 featured support for client-server databases such as Microsoft’s SQL Server and the Oracle database.  Version 4 launched with one of the first ever browser-based interfaces for an enterprise product.  It was 1999.

Over the years, we have committed a portion of our development efforts to what we refer to internally as ‘infrastructure’.  It is, in our opinion, unavoidable.  The current term for this is ‘keeping a current technology stack’.  This is part of the cost of doing business.  There is a lot of technology to keep up with.

An enterprise product like TimeControl needs to support multiple databases and database versions.  These days we work with SQL Server, Oracle and MySQL.  Over the years there have been others.  Each of those products are also keeping up their technology stack.  They change all the time.  TimeControl also has to support different versions of Microsoft Server and different browsers including Chrome, Safari, Mozilla, Edge and Firefox.  Those too change all the time.  There are regular changes in malware protection, safety protocols and support for our product being used in our Software as a Service Online edition.  There is support for our free TimeControl Mobile App as well used by both Android and Apple iOS devices.   There are transportation protocols for data moving across the Internet that have to keep up with current standards to be more effective and safer.

TimeControl is well known for its links to Project Management tools like Oracle’s Primavera and Microsoft Project and Project Online.  These tools also change on a regular basis.

The very programming languages we use also change as do the interface controls we subscribe to in order to present different elements of our product.

TimeControl also including an Application Programming Interface (API) which allows other external systems to integrate to it without our intervention.  That too has to keep up with current language and protocol standards.

We’ve seen other products in our industry where, for whatever reason, the technology stack effort stalled.  Perhaps it was a short term plan to reduce costs and sell the company.  Perhaps the effort to update the technology stack was simply too challenging.  Those products quickly fell behind others in their category and, while not irrelevant, became harder and harder to sell, deploy and integrate.

That was never going to be us.

For TimeControl that means updating our underlying architecture all the time.  But, we don’t want to update in a way to make TimeControl unstable so we have to update that technology carefully as we do each major version.

I was noticing our most recent job posting for a developer which listed some of the technology we hope they will have experience in: C#, ASP.NET, Web API, RESTful services, Angular 4+, DevExtreme, OAuth/OpenID and, Bootstrap.  It’s quite a list and that’s not exhaustive.  Nor, do we expect we will find all of that in one person every time.

We haven’t even talked about changes that come about with modern desires like the integration of Artificial Intelligence (AI).

We’re working on updating infrastructure in TimeControl now and I expect we’ll be doing it tomorrow and every tomorrow for as long as we can see forward.  Keeping up with the technology stack is one important way that TimeControl stays relevant.

 

TimeControl 8.6 Online has been upgraded for all clients

TimeControl, TimeControl Project, TimeControl Project Resource Capacity Planning, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisWe’re excited to let you know that we have upgraded all TimeControl Online, TimeControl Industrial Online and TimeControl Project clients to version 8.6.  This version of TimeControl includes all the features we recently described for TimeControl 8.6 and TimeControl Industrial 8.6 here.  The 8.6 Online updates add additional features for TimeControl Project including new capabilities in Resource Capacity Planning and an ability to enter timesheet information directly from a TimeControl Project task dialog.

For a complete list of TimeControl 8.6 enhancements, new features and more, visit TimeControl.com/features/latest.

What about resource leveling?

Resource Capacity Planning, EPM Guidance, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisChris Vandersluis, the president of HMS Software has just posted an article on his EPM Guidance site about resource leveling.  It’s particularly timely as we get ready for the upgrade of TimeControl Project 8.6 in our TimeControl Online environment this weekend.

Resource Leveling was once all the rage in the project management industry but the software industry refocused on getting tools into the hands of individuals with the associated licensing and the ability of the resource leveling algorithms to deliver a meaningful picture was sidelined.

Take a look at the article on EPM Guidance at: www.epmguidance.com/2025/02/27/what-ever-happened-to-resource-leveling/.