Category Archives: timesheet

Accounting, ERP, ERP systems, Finance systems, HR, human resources, Payroll, timecontrol, timesheet, timesheet software, Timesheet transfer

Linking TimeControl with other corporate systems

Leave a comment

A question that is asked quite frequently is how to link TimeControl to external corporate systems. Some clients request links to move corporate data into TimeControl, some want to move data from TimeControl to another system.
One type of connection is a transfer of data into the TimeControl tables to create timesheets. Another example would be using a corporate HR system to feed new employee data to TimeControl’s employee table or a work order system to feed tasks and assignments to TimeControl’s charge tables.
It is very common for organizations to wish to transfer time and cost data from TimeControl to a corporate system for Payroll, HR or Financial uses. These links are beyond the connections to project management systems such as MS Project, Deltek or Primavera which are pre-configured in TimeControl.

There are two main methods to set up links to corporate systems. The preferred method depends on the specific requirements:

Batch Transfer:
TimeControl contains an Integration Wizard that allows the client to create a custom import or export batch file in order to link to their corporate systems. The definition of this transfer can include predefined or user-defined fields and data including data that might be required to link to the external application such as employee codes or work order numbers. The resulting file is in a CSV or XML format which allows for connection to a wide variety of applications. The data is exported against a selection filter providing data for a specific period, employee, project, business or other criteria. This is the most common way HMS clients link TimeControl to external systems such as payroll, finance, HR or ERP systems. It is easy to set up and to administer and Finance personnel are usually more comfortable with a transaction file of data that is at arm’s length from the corporate Finance system. This allows the Finance system administrators to use the Finance system’s business rules to check data on its way into their system. TimeControl supports multiple transfer templates to server multiple export requirements. If required, exported data may be batch tracked to avoid inadvertently exporting the same record twice.

This method allows transfer of data to be set up quickly and easily and allows for a final review of the data prior to being imported into the corporate system.

Direct Database Connection:
A more sophisticated connection but less commonly used method is to use direct connections at the data- base level with SQL scripts, stored procedures and triggers. Because the TimeControl data resides on a host client server database, direct data transfers are relatively simple to establish. This type of connection typically provides transparent, real time data synchronization. Setup using this method requires an internal SQL expert or an HMS consultant and the effort may vary from a few days to several weeks, depending on the complexity of the connection that is required.

This method provides a dynamic instant transfer of data which is not always required.

Manipulation of data with SQL Scripts

In some cases TimeControl clients have a requirement to manipulate the raw data that has been captured in TimeControl to support a specific requirement. It is possible to use SQL scripts and stored procedures within the TimeControl data structure to perform calculations, summarizations and other types of data manipulations. The results of this type of calculation are typically written to custom fields or tables within the TimeControl host database. This flexibility allows TimeControl to meet a great variety of client-specific requirements.

An example of this type of data processing would be multi-currency calculations done when there are several currencies in the rate table and where the costs must be reconciled to a single currency for reporting purposes.

Techniques, timecontrol, timesheet, Tips, Validation Rules

Getting started with Validation Rules in TimeControl

Leave a comment

TimeControl’s business rules engine, the Validation Rules module is one of the most powerful aspects of the timesheet system. There is almost no limit to the number of rules or the type or rules that can be created to test timesheets automatically.

Some examples of validation rules might include:

No more than 24 hours in a single day

Exactly 8 hours per day of regular time for salaried employees

Use the Acme Rates for the Acme projects

No overtime unless a) you’re eligible for overtime and, b) you did at least 40 hours of regular time this week

Each of these rules can be customized to only apply to a select group of employees or to be applicable to everyone and each rule can deliver a message saying that the rule is an error or only a warning. The result is that timesheet data that makes it into TimeControl is already of extremely high quality before anyone even looks at it for approvals! Also, the most common corrections to the timesheet data are done by the people who know the data best; the people who entered it in the first place.

When organizations first see the capabilities of the TimeControl Validation Rules module, it’s common for staff from the Human Resources or Payroll departments to get very excited. They envisage dozens or even hundreds of rules that will mean never having to look at timesheets manually again.

HMS implementers recommend caution over being too enthusiastic when starting with Validation Rules. Imagine a new system where an eager enthusiastic TimeControl Timesheet Administrator creates hundreds of rules for every possible timesheet error he or she can think of. The system is activated and new users try to enter their timesheets. A user receives one warning, corrects the error, then receives another error message, corrects that then gets another. In short order the user gives up on the system declaring it “too hard to use”.

It’s important to remember that one of the most challenging aspects of deploying an enterprise system like a timesheet is compliance and for that reason, we recommend starting with a tiny number of rules. Think about starting with a half dozen or perhaps 10 rules to get started and, after the system has been accepted by the users, gradually add new rules for the most common of repeated errors. The system will gradually become more managed naturally over time and users won’t notice the volume of rules when they’re added gradually as they’ll have learned in previous weeks to avoid the Validation Rules that have already been made a part of the system.

Validation Rules are one of the most powerful aspects of the TimeControl timesheet system and, like anything powerful, must be treated with care and respect.
Multiple Currencies, timecontrol, timesheet, timesheet software

Managing Multiple Currencies in TimeControl

1 Comment

We’ve got all kinds of PowerPoint presentations that have been used for technical purposes. Here’s one on how to manage multiple currencies in TimeControl. TimeControl has always allowed the rate codes to be identified by Currency or any other coding. But, what if you wanted to store TimeControl costs in a common currency that was converted at the time the work was done? Check out this presentation on managing multiple currencies in TimeControl.