All posts by chris.vandersluis

Upcoming holiday dates

TimeControl Calendar, HMS Office Holidays, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisIt’s a busy time of year at HMS as we juggle holidays of different types.

We have some statutory holidays coming up.  Regardless of which holidays are happening, our 24×7 monitoring of TimeControl Online continues no matter what.  If the office is closed, we will be slower to respond to technical support or sales calls.

Fete Nationale

On Tuesday June 24th HMS will be closed for the Quebec Fete Nationale (previously known as St-Jean Baptiste Day.  Given that our headquarters are in Montreal, this is a statutory holiday for all the HMS staff.  We will be open on Monday the 23rd and back at our desks on Wednesday the 25th.

Canada Day

It’s Canada’s birthday on Tuesday, July 1st.  Canada will celebrate it’s 158th anniversary on that day.  It’s a statutory holiday and all the HMS staff will be off.  We will be working on Monday June 30th and back at our posts on Wednesday, July 2nd to respond to any requests.

Independence Day

On Friday, July 4th our American friends will celebrate Independence Day.  While almost all of the USA will be closed that day, HMS will be open for business and our clients outside of the US will be able to reach us.

The next big statutory holiday after this for us will be Labour Day (That’s Labor Day in the US!) on Monday, September 1st.

We will post updates on our social media each of these days to remind you of the office status that day.

Beyond Approvals: Modernizing Multi‑Purpose Timesheet Workflows

TimeControl Workflow and Approvals, TimeControl Best Practices, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisWhen organizations think of timesheets, they often picture a simple approval process—an employee submits their hours, a manager signs off, and payroll processes the data. But in reality, collecting timesheets has evolved into a powerful multi-functional process. When companies use TimeControl, the timesheet system can simultaneously serve multiple masters: payroll, project management, finance, HR, and government compliance.

This post explores how you can modernize your workflow by leveraging TimeControl’s matrix approval model and multi‑purpose timesheet design. We’ll also provide practical tips to streamline and future‑proof your processes.

From Single Approval to Matrix Approvals

Traditional timesheet systems typically follow a linear approval path—supervisor reviews, then it’s sent onward. TimeControl takes a different approach: matrix approvals, which allow timesheet data to be reviewed and approved by multiple roles for different purposes at the same time.

Why is this a game changer:

  • Project Managers can approve project-specific hours regardless of department.
  • Department Managers can validate work allocation for personnel.
  • Finance can verify cost codes and chargebacks before posting to the ERP.
  • HR/Payroll can finalize time-off, overtime, or special pay categories.

Multi-Purpose by Design: Use Cases in Action

✅ Project Costing & Capitalization

Use rate-based rules to tag internal vs. capitalizable time and route for separate approvals. TimeControl can even export capital hours directly to financial systems like SAP or Oracle for asset tracking.

✅ Government Compliance (DCAA, SOX, etc.)

Enforce audit trails, justification fields, and retroactive change tracking to ensure compliance with federal or industry regulations.

✅ Time-Off Planning

Integrate TimeControl with your HR system to let employees submit vacation requests, which are reviewed and reflected in scheduling—while still feeding into HR and payroll.

✅ Billing Support

Consulting firms can set up client-specific billing codes and rules so billable hours flow directly into invoicing pipelines.

Modern Workflow Best Practices

Here are some best practices we’ve compiled from our experience of working with hundreds of organizations in both the private and public sectors.

🛠 Standardize Where Possible

Start with core timesheet fields and gradually add complexity. Avoid overwhelming users with too many entry types at first.

🛠 Automate Routing Logic

Use rule-based approval paths: if an entry is billable and over X hours, auto-route to finance for a second review. TimeControl supports this logic without the need for coding.

🛠 Keep Auditability Front and Center

Enable real-time audit logs and change tracking. Matrix approvals don’t just distribute accountability—they document it.

🛠 Visualize What Matters

Use dashboards or automated exports to deliver the right data to the right team—no need for everyone to wade through the full timesheet.

Wrapping Up

Multi-purpose timesheets are no longer a “nice to have”—they’re essential for agile organizations that need a single source of truth across departments. With TimeControl’s matrix approval engine and flexible workflow tools, you can move beyond “who signed off” and toward “who got what they need.”

If your organization is still relying on siloed timesheet workflows, now is the time to modernize. Let TimeControl help you turn your timesheets into a strategic asset.

👉 Ready to optimize your workflow?

Find out more about TimeControl’s Workflow and Approvals or Contact the TimeControl Team to learn how TimeControl can be configured to meet your exact business needs—or request a personalized demo today.

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.

The free TimeControl Mobile App revolutionizes field data collection

Project Manager field data collection, TimeControl Industrial, TimeControl Mobile, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisThe free TimeControl Mobile App has now been a part of the TimeControl timesheet system for years.  It connects to both TimeControl and TimeControl Industrial both on-premise and on-line.

For TimeControl Industrial clients, the mobile app creates a field data collection services that completely changes how users at a project site and users at the office gather data.

TimeControl Mobile supports not only the data collection of timesheets in the field using either an individual or a crew timesheet, it also allows non-labor entries. Labor is entered on the crew timesheet but there is also an icon for Material entries in which any non-labor entries can be made. Just as in TimeControl Industrial on the web interface, you can enter here materials consumption, equipment usage and even production values right from the field.

With the combination of these and other features, the TimeControl Mobile App becomes a LEMS (Labor, Equipment, Materials) collection system. The Mobile app can also collect and attach pictures of the site, receipts for material delivery or other attachments which become part of the centralized and permanent record. Multi-track approvals are also handled in the field or back at the office or both.

This makes the TimeControl Mobile App a powerful field data collection tool and it’s all controlled right in the hand of a supervisor, foreman, team leader or clerk. Collecting the data right where the work is taking place leads to a much higher data quality and speeds all parts of the project progress workflow.

Once the data is released for approval, TimeControl’s powerful approval mechanisms ensure it meets the organization’s standards for data.  The Mobile App also includes approval mechanisms so the people who need to approve the work can do so whether that is through the Mobile App or through a web browser. Either way, getting the data ready to update the project management system, the payroll system and the invoicing system happens much, much faster.

The TimeControl Mobile App is free and connects to TimeControl, TimeControl Online, TimeControl Industrial and TimeControl Industrial Online. There is no fee for downloading or using the app. The only requirement is that it be connected to an active TimeControl User License on the main system.

We mean there is no additional cost. None. When you download the app from Google Play or the Apple App store, you don’t pay a thing. All you need to do is connect to your existing TimeControl system.

You can find out more about the TimeControl Mobile App at: Mobile.TimeControl.com.

You can download the TimeControl Mobile App from Google Play or the Apple App store.

Contact HMS for more information on how the TimeControl Mobile App can help your remote workers get connected.

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.