Tag Archives: TimeControl

Starting off your TimeControl year

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.

A Letter from our client Entegrus

entegrus_300x120Sometimes we just can’t say it better than our clients do.  We received a letter recently from our client Entegrus.  Entegrus is a utility company based in Ontario Canada which brings electricity, renewable energy and water to over 40,000 customers.

They’ve been using TimeControl since 2014 and as a result have become more efficient in reporting on where their time is being spent.

We’d like to thank Chris Towne, the Director of Finance for Entegrus and the entire Entegrus team for their support.

You can read Chris’s letter in its entirety at www.timecontrol.com/why-timecontrol/testimonials/entegrus.

Get attached to things? Like receipts?

One feature that was added to TimeControl some time ago was enhanced in TimeControl 7.  The ability to attached documents within the timesheet relates to a couple of very important features.

Attachments to the timesheet
Some people have scanned documents or pictures or other files that are relevant to their entire timesheet.  Just above the timesheet grid on the right-hand side of the screen is a button called “Timesheet Attachments”.  Clicking on it will allow you to add an unlimited number of files from your device to attach to your timesheet.

expenseattachment

Attachments to Expense Items
A more popular area of the timesheet where attachments are made is within Expense Entries.  If you add an expense item to any timesheet line, you are able to add an unlimited number of attachment files to each expense item and an unlimited number of expense items to each timesheet line.  Whether you take a photograph of your receipt or scan it into a PDF file, the file is easily uploaded into the TimeControl database and associated to that item.

In TimeControl 7, this ability to add files was improved in both the Expense dialog and the timesheet header area, making it easier to browse and post files in both sections.

 

TimeControl on-premise security architecture white paper rewrite

tc7secure_cover_300x389.jpgWith the launch of TimeControl 7, we are gradually working through updating the vast array of TimeControl resource that are available online.  This week saw a rewrite of the TimeControl On-Premise Security Architecture white paper which is now available on the TimeControl.com website.  Rewriting such material gets everyone thinking about the subject matter so security turns out to be one of our most popular internal conversations this week.

To be fair, security has been a topic of conversation for the TimeControl developers since long before the first version of TimeControl was released.  The first ever timesheet that HMS created was 10 years before TimeControl.  Our client, Philips Information Systems in Canada needed a timesheet that would integrate with both the Payroll system and the Project Scheduling system.  Security was a huge element of the design as the data for Payroll was, of course, very sensitive and the costing information in the project system was information that would have been terribly damaging to the company if it fell into the hands of competitors.

That original HMS timesheet was very secure for its time and there are elements of that design that live in TimeControl still.  But times have changed and the threat of data and systems compromise has become ever more sophisticated each year since that first timesheet system.

While the TimeControl On-Premise Security Architecture reveals many of the elements of the TimeControl deign that lend themselves to a safe and secure system, it is primarily a document that lets prospective clients review TimeControl against their own security standards.   Yes, we use the latest in many technology designers in TimeControl and we test against the OWASP standards (owasp.org) looking for potential threats and ensuring we protect against them but there are risks that you can implement at that are beyond the security architecture we designed for TimeControl.  Here are a couple of basic tips you can think about regardless of your size:

  1. Have a security plan for your key systems and data and choose someone to be accountable for it.
  2. Authentication is key.  How do people authenticate to your network, to your applications and even to your building.
  3. Outward facing or inward?  Does TimeControl need to be accessible to the Internet or will it serve your purposes just as well being available only within the corporate firewall?  Inward implementations aren’t as easily accessible and that can mean they’re safer.
  4. Don’t forget physical security.  If someone can get physical access to the servers, they can get access to your systems.
  5. Monitor.  Make sure you take advantage of the many technologies available to monitor unauthorized access or out of pattern use of your applications, your data and your network.
  6. Functional and Data restrictions.  In TimeControl, User Profiles determine what users can see which data and which users can use or perform which functions.  Think about who needs access and don’t be scared to start with less access and later ease up on your restrictions.
  7. Disaster Recovery.  Make a plan for your data and systems being compromised and how you’ll recover from it.  Then do an actual practice to make sure your plan works.  Iterative and redundant backups and a plan for restoring them is something that makes security officers sleep better.

This is not a comprehensive list of course.  There are many aspects to a complete security plan that are better explained by specialists in that field.  We’ve been talking about TimeControl for an On-Premise implementation.  Next month as we upgrade TimeControl Online to version 7 we’ll be updating our Security Architecture white paper for TC Online and we’ll be sure to talk about that here in the blog.

You can find the TimeControl 7 On-Premise Security White paper at: TimeControl.com/resources/whitepapers

The new Calendar View in TimeControl 7

TimeControl 7 sports a fancy new interactive feature called the Calendar View.  It is one of the features that is generating the most excitement for certain TimeControl users. Calendar_view.jpg

When we first designed the Calendar View we expected that it would be popular among users who wanted a graphical representation of their upcoming vacations and holidays as well as any assigned tasks.  We thought of it primarily as a personal view.

But, once we’d created the new view and started using it, the advantages of the view for Supervisors and Administrators overshadowed our original expectations.

Supervisors who have to approve future vacation have been able to do so for some time with TimeControl’s TimeRequest™ functionality. Users can request time off, the supervisors can accept or reject the request and administrators can even push holiday time for banked holidays to any selection or to all users.  So far that all sounds fine and TimeControl supervisor users have reported how happy they are with the function since it was first released years ago.

Now with the introduction of the Calendar View we are seeing a missing link in the approval process that we didn’t think about in the past.

The Calendar View allows a supervisor to visualize all the TimeRequests from their team simultaneously.  They can color code the view to show approved vacations, pending requests and even rejected requests on the same page.  Now, at a glance, a supervisor can determine if the new request for time off will conflict with other requests.  They can see the impact on how many team members might be absent at the same time and making the right decision about whether to accept or cancel the new request for time off is so much easier.

In some organizations it is key to also see if accepting time-off requests will conflict with tasks that are scheduled so the supervisor can also display tasks assigned to each of their team members at the same time.calendar_config_444x572

The View is flexible with numerous options for the display as you can see here.  The Calendar View is accessed from the reporting menu or directly from inside the TimeRequest screen.

The availability of the new Calendar View will make the process of time-off approvals much more effective and gives all users a new way to visualize their own personal TimeControl data.

For more information about what else is new with TimeControl, visit www.timecontrol.com/features/latest.

TimeControl 7 now available!

We are so excited to announce that we have released an exciting new version of TimeControl. TimeControl version 7 is a major upgrade to the product we launched the first version of over 20 years ago and we are sure it will be welcomed by both existing and new customers.  There are over 40 major new features or enhanced features that you’ll be seeing as the new version is released.  Here are only a few:

Multi-line edit timesheettimesheet.jpg

The TimeControl 7 timesheet has been completely rewritten to allow all cells in the timesheet to be edited simultaneously.  In previous versions, a single line had to be edited at a time due to the many customizable validations that are tracked on each cell and each line.  We have determined methods to accomplish the same thing while allowing all the lines to be changed at once.  For those with timesheets that have a large numer of pre-loaded tasks, this will be a welcome change.

Gantt Views

TimeControl 7 now allows you to view projects, tasks or assignments in graphical Gantt charge views.  MyAccount_Gantt2.jpgThis gives users an easier perspective into data they have access to and to highlight potential assignment challenges in the coming days.  The view is highly configurable and is accessed from either the Reporting tab or the MyAssignments tab of each user’s Options page.

Calendar Views

TimeControl 7 introduces a brand new view into assignments with a calendar view.  The view can include assignments and/or TimeRequests™ and can be access from either the reporting view or from right inside the TimeRequest Approval screen. Now a supervisor with multiple requests for vacations in a given period can quickly pop up a calendar to see them graphically displayed and can distinguish between draft, released for approval, approved and rejected requests by using different colors for each type.

There are more than 40 more exciting new and improved features in TimeControl 7 that we haven’t even listed here.  For a more complete list, see the Latest TimeControl page on the website.

TimeControl 7 is available for download right now for clients who have an active support agreement at TimeControl.com/support/updates.  If you are an existing TimeControl client and need to renew your support agreement, please email info@hms.ca.

 

Timesheets by exception

autofill1.pngNot every organization expects all their staff to fill in a timesheet every single week.  Instead, theses salaried staff are instructed to fill in a timesheet only “by exception” meaning only if they were not at their intended post for the entire pay period.  If the employee has an exception such as a sick day, vacation, a day when they left early, etc.  they must then enter only the exception.

TimeControl can be used like this of course because if that is what your payroll system expects, then TimeControl export to the payroll system will have only the expected exceptions.

Ah, but if life were only that easy.

Here’s a much more difficult scenario:  Imagine an organization where some of the staff who are project oriented must fill out timesheets to account for their entire week and other non-project personnel will be asked to only fill in timesheets by exception.  Must there then be two separate timesheet systems?

Not at all.

TimeControl’s AutoFill functionality is designed to fill in where the exception timesheet leaves off.  Here’s how it works.

First, define who will be entering timesheets by exception.

Next, create a process that allows people who have exceptions to enter them by a certain time in the timesheet period.  For example on a weekly timesheet perhaps exceptions must be entered by noon on Monday.

Now run the AutoFill functionality and have it “fill-up” the timesheets for the people defined to the total number of hours per day that you define.

In this manner TimeControl will create blank timesheets and automaticall fill them in or add to the exceptions that are already there to fill in a complete timesheet.  Now the project staff who enter a complete task-based timesheet every week and the non-project staff who enter a timesheet only by exception will end up with a completed timesheet that can be reported on together, exported or analyzed together and, if you still need to send only the exceptions to the payroll system, that too can be filtered to send only the appropriate data.

TimeControl’s AutoFill is one of the more popular features for HR and Payroll adminstrators for the enormous time it saves by automating a simple function and allowing a single timesheet to replace multiple timesheets.

You can see more HR related functions in the TimeControl and HR use-case area of the TimeControl.com website.

FAQ: Tracking approvals

Question: We now have clients sign paper timesheets to show they were approved.  How would we deal with this requirement in an automated timesheet like TimeControl?

TimesheetAuditability_300x200.jpg This is a great question and one faced by any organization that is shifting from paper-based timesheets to an automated system.  Signature approvals are designed to have evidence that the person who signed the document actually saw the document they signed and their signature signifies their approval of the content.  There are two main areas of reluctance for auditors to accept an automated version of a signature in a computer-based timesheet:

  1. How do we know that the person whose name is now on the timesheet is actually the person who approved it? And;
  2. How can we be sure that the data in the view the person approved has not been changed.

In TimeControl, both of these concerns are dealt with in the way that TimeControl deals with auditability of the movement of timesheet ownership.

When a timesheet is created.  TimeControl notes in the database the user name and the date/time.  Then, whenever the timesheet changes ownership through releasing it for approval, the timesheet being rejected, updated re-released, approved and ultimate posted, TimeControl creates an entry in the Timesheet Release Log.

If a user is using the Alternate User function to log into TimeControl as someone else, TimeControl accommodates this also.  In this case the audit log will show both the person who had the responsibility of releasing or rejecting the timesheet as well as who the actual user was who performed the action.

Since this means that there is no reason to share one’s credentials to get into TimeControl, virtually all financial auditors HMS has encountered accept the user name entry in the audit log as equivalent to a signature on a piece of paper.  This has been tested in audits by authorities such as both Revenue Canada and the US IRS for R&D Tax Credits, Defense Contract Audit Agency audits, Sarbanes-Oxley compliance audits and countless other situations where timesheet data is part of an audit.

To be certain that this functionality will pass your own auditing standards, you should consult your Finance team and, if need be, have them speak to the technical experts at HMS.

 

FAQ: Can the TimeControl Menu be edited?

 

Yes you can.  Not only can you edit existing elements of the TimeControl Menu, but you can add to it also.  In the Administration Tab there is a selection called Menu entry.  Using this function, you can move menu items fromtcblog_menu tab to tab or add a new entry.  Imagine that you’ve created an internal project management tracking process manual and you’d like to make sure that all of your TimeControl users can access it from right inside TimeControl.  You can click Add in the Menu Entry module and add the URL and an icon for that selection.  Once you’ve added the new entry, it will immediately become visible in the User Profiles module in case you want to make sure it is secured for one user or another.

Or, imagine that you’ve created different manuals for different users perhaps for users in a particular country.  You could create manuals for each country and a menu item for each and then use User Profiles to only show the appropriate manual to someone in that country. tcblog_menuadd

The same goes for any other function you’d like to create.  The URL destination of a menu item could also be an external system.  This type of flexibility is powerful so you need to keep track of what you’ve added to your TimeControl so you can train people on finding the right function in the right place.

 

 

The relationship between TimeControl and Excel

We often get questions here at HMS about how TimeControl and Excel.  Answering appropriately requires knowing why people are asking.  timecontrolexcel.jpgFor those who are interested in knowing if they should migrate from an Excel timesheet to TimeControl, there are numerous resources on the TimeControl website identifying the benefits of going to a centralized data-driven timesheet model.  But, there are so many other ways that the two systems are tied, we’ve created a special solutions portal to help

Let’s take a look at some of the different ways you might be thinking that TimeControl and Excel are related:

Migrate from an Excel timesheet to TimeControl

Many organizations create their first timesheet using Excel. It’s a natural fit. The Excel format is infinitely flexible and perfect for designing a grid that has to use calculations to total up the week’s time and even costs.  But, as an organization grows, the need for the functionality of a full timesheet system grows also. Maintenance and the management of an Excel timesheet when an organization is a handful of employees is relatively simple. When the number of people grows, that maintenance becomes more complex, more costly and a bigger challenge.  That’s where TimeControl’s centralized data structure becomes much more attractive.

Importing and Exporting data between TimeControl and Excel

TimeControl includes complete support for importing and exporting data in an Excel format.  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 source data to Excel is very simple.  You can even schedule exports to Excel or imports from Excel to happen automatically on a schedule you determine.

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?  No problem. Need an Excel traffic light dashboard?  No problem.

Displaying 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.

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: www.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.