Tag Archives: enterprise timesheet

FAQ: Can you import historical timesheets into TimeControl?

old_new_crossroads_300x300Of course. Aside from importing all the supporting tables, there is a timesheet import function in TimeControl links that does specifically this. You’ll need to make sure all the employee information, charge code information and project information already exists but then the import is quite easy. There is a blog post on this here in the blog at: blog.timecontrol.com/?p=142 which includes an Excel template to help you prepare your data for the import.

FAQ: Can we start with the Online version of TimeControl but switch to our own internal TimeControl when we get bigger?

online_or_onprem_300x144You certainly can, but you can do a lot more than that. We’ve designed TimeControl Online, our Timesheet as a Service (TaaS) to support the identical code-base as TimeControl on premises. This means that if you are using TimeControl Online as a service and you install the standard TimeControl locally (with the appropriate number of licenses of course) then you can download you backup from TimeControl Online and instantly have your system active on premises. You’ll need to use the same database of course, which is MySQL but technically the movement from Online to on premises is stunningly simple. We’ve made moving between the two environments commercially easy too. You can get a credit from your remaining subscription towards purchase of TimeControl licenses. As easy as it is to move from TimeControl Online to TimeControl on premises, the reverse is also true. You can move from TimeControl on premises to TimeControl Online and we’ll give you credit from what you purchased towards your first year’s subscription.  You can find out more about the choice of TimeControl Online vs. TimeControl OnPremises in the How to Buy TimeControl area of the website.

Talk to one of the TimeControl account specialists about how this can work for you .

FAQ: Can we get access to TimeControl’s database to use with our reporting tools?

reporting_charts_300x200Absolutely. If you have installed TimeControl on premises, we publish the database schema design so that if you have the appropriate rights from your IT department, you can link directly to the database. We do not encrypt most of the data with the exception of authentication information. TimeControl does, however, include its own WYSIWYG report writer with extensive functionality. The TimeControl Report Designer includes capabilities to make both graphical and text-based reports, to save reports into PDF, Excel, JPG and other formats and to mix and match report formats within the same page. In addition you can control fonts, headers, footers, grouping, summarizing and even create formula fields. But if your heart is set on using another commercial reporting tool, then have the IT department give you read-only access to the data and you’re ready to go.  If you are using TimeControlOnline, you can also download a complete data backup in MySQL format every week and again use your own reporting or analytical tools on the data.

You can find out more about TimeControl’s internal reporting functionality on the TimeControl website at: www.timecontrol.com/features/reporting.

FAQ: Do we need to standardize on a single project management system before integrating TimeControl?

RubicStandardize_300x225No you do not and TimeControl is ideally suited for this type of challenge.  The pre-defined links to project management tools can link a TimeControl Project and associated charge codes to project information in Microsoft Project 1995 and up Microsoft Project Server 2002 and up, Oracle Primavera P3 through P6, Deltek’s Open Plan, InEight’s Hard Dollar HD and VersionOne.  And, it can link to all of those systems simultaneously.  TimeControl is designed to make as many project system connections as you wish and then each project can be linked through that connection to a project in that system.  This allows TimeControl to not only link some projects to Microsoft Project and some to Primavera P6 but TimeControl can link to multiple versions at the same time.  Imagine a situation where some projects are being managed in Microsoft Project Server 2010 and some are being managed in a separate instance of Microsoft Project Server 2013.  TimeControl could link to both systems at the same time and a TimeControl user wouldn’t have to worry about it.  They would just enter their complete timesheet in TimeControl and the data will go to the right project system and the right tasks in the background!

Find out more about TimeControl and Project Management tools on the Project Links page.

FAQ: How much internal effort and resources will I need to make a timesheet work?

internaleffortFirst, let’s talk about the effort to implement TimeControl when it is first deployed. This is highly dependent on several factors including the number of users on TimeControl and the number of external system to which TimeControl will be integrated.

The TimeControl QuikStart program was designed for a mid-sized organization doing a basic deployment of TimeControl with only a couple of interfaces to create.

This is a 5-day effort by HMS and requires internal support of a TimeControl Administrator for 3-5 days prior to making the timesheet available to the end-users.

If you are deploying TimeControl for 10-200 people and making a simple link to a project management tool and another export link to a finance tool, then this is probably sufficient.

Of course some people have much more complex environments and wish to integrate TimeControl to numerous internal processes and tools. Depending on the level of complexity, a multi-thousand person deployment covering numerous countries systems, internal payroll rules and more could take a team several months to complete the deployment.

Next, let’s talk about time to administer and support TimeControl once it is in use. The technical time to support TimeControl is negligible. You have to make sure data is being backed up, but that’s probably being done anyway as part of the DBA’s responsibilities.

Upgrades and updates take very little time and are done only a couple of times a year typically.

Administrators are often not full-time on TimeControl unless it is a system with thousands of users.

The work each week Administrators focus on is making sure new employees are onboarded and that employees who have left are made inactive and looking to do regular clean ups of old data.

FAQ: Is your timesheet DCAA certified?

dcaa_300x103For those wondering, DCAA stands for the US “Defense Contract Audit Agency”. The DCAA has set a number of standards for contracts paid for by the US government which include standards for timesheets. These criteria are used not only by the US Defense Department but also by Homeland Security, NASA, the Department of Energy and other public sector organizations who find the criteria to contain good business practices.

However, the DCAA is very clear that it does not endorse or “certify” any product. It has a required process and a range of required criteria which some timesheet products might be able to fulfill and others not.

TimeControl does fulfill the DCAA standards and we keep up to date on the criteria when they are changed. You can find more on this on the TimeControl site in the DCAA Use-Case solutions portal.

FAQ: How do we manage timesheet rates when we need one value for payroll, one value for billing and yet a third value for project costing?

Calculator_300x169This is a great question and a challenge easily managed in TimeControl. TimeControl’s rate system is incredibly flexible. First of all, you can have an unlimited number of rates defined per employee, per resource and/or for the whole organization.

So, an individual might see different possible rates for overtime, billable time per client etc. Next, for each rate there are by default 9 values. This combination gives limitless possibilities. Imagine that you had a regular rate and overtime rate for a staff person but you also charge different rates when you invoice.

No problem.

You can have two rate codes per client with each rate code pair having one internal value for the code and one billable value.

There are so many possible rate options that we’ve created a special area to talk about rates on the website which includes a comprehensive white paper.

You can find more on this area of TimeControl at www.timecontrol.com/features/rates.

FAQ: We just implemented Project Server which has a timesheet. Why should I consider another timesheet?

forkintheroadYou’re not alone. Microsoft has sold thousands of copies of Microsoft Project Server which is now available both for purchase and online subscription.

Project Server includes a timesheet which is designed to update the tasks listed in the Project Server database with hours and estimates to complete. You can also add administrative tasks to track non-project time.

In effect Project Server has not one but two timesheets and since Project Server 2010 has not one but three timesheet interfaces. So far so good. But for people who need to do not only timesheets for project updates, but also timesheets for auditiable financial purposes, Project Server administrators tend to look at Project Server partner timesheets (like TimeControl) to extend timesheet functionality.

Here are a few things you get with TimeControl that you can’t get with Project Server:

  • Link to both Project Server and Project Desktop at the same time
  • Link to different versions of Project Server at the same time
  • Link to multiple instances of Project Server at the same time
  • Extensive Rate functionality with unlimited rates per person
  • Business Validation Rules
  • Approval Workflow
  • Manage banks such as overtime, and vacation
  • The Matrix Approval Process™
  • Expense Reports
  • Missing timesheet email notification
  • Global tracking of timesheet approvals
  • Vacation Request/Approval with timeRequest™
  • Link simultaneously with Project, Project Server, ERP, HR, Payroll
  • TimeControlMobile interface

You can find out more about how TimeControl extends Project Server functionality here in the Solutions area.  Go to the Microsoft Project Solution’s page on the TimeControl website for more information.

FAQ: How many employees do I need to be before buying a timesheet makes sense?

staff_300x122This is a great question because it’s applicable to so many situations beyond timesheets.

To answer your question shortly, if you can no longer manage the hours in your head because there is too much detail required, you need a better system. If the work can be accomplished on a napkin or in a single Excel file then you need to think about a better system.

For most organizations, once they exceed 10 to 20 employees, the data becomes too hard to manage manually but your own situation may vary depending on how much detail you require for each employee.

If you are 2 or 3 people all working in an office small enough that you can shout down the corridor and find out everyone’s hours, you probably don’t need a timesheet. If you are 30 or 40 people or more and shouting down the corridor as a method of getting data is frowned upon, then you should be thinking about an automated system.

We have successfully deployed our own TimeControl timesheet system for organizations with as few as 10 employees and it has delivered great value.

We’ve deployed TimeControl for as many as 10,000 employees and, again, it has delivered great value. So, while each situation is different, the idea of standing back to look and see if the complexity of the challenge warrants an automated system is a good one.

If it isn’t clear that you will get a positive return on your investment of time, money and resources, then it might be better to wait.

That’s true for a timesheet, but it’s also true for any other enterprise system.

FAQ: How do you decide whether to purchase and install on premises or subscribe online?

onlineoronpremise_300x240This is a great question and very current as so many systems are now offering hosted online options. With TimeControl, you fundamentally are able to access all the functionality in our TimeControlOnline subscription as you do with the on premises installation. So the decision on whether to install TimeControl at your premises or subscribe to TimeControlOnline in the cloud should not be based on functionality.

Here are some of the key decision points that you may wish to consider:

Do you already have an infrastructure and personnel to support in-house applications? Do you already have servers, databases, technical staff who can ensure the application’s system requirements are maintained and that maintenance of the servers such as backups and security updates are kept up to date? If you don’t have such an infrastructure or the people to support it then going to a subscribed service might be better.

Do you have other enterprise applications that are installed at your premises? If you already have other applications that use commercial databases, web services and application servers, then you already have all the building blocks of an on-premises installation of TimeControl and the additional effort and costs to install TimeControl will be negligible.

Are you intending to do deep integration with other systems? If you are thinking of doing extensive integration of TimeControl data with other corporate systems, then an on-premises installation may be more attractive. When installing at your location, you will have direct access to the TimeControl data in its database and can take advantage of advanced reporting techniques such as mash-ups and data-level systems integration.

You can find out more about whether to choose an onsite or online deployment of TimeControl in the How-to-buy section of our website where there are webcasts, factsheets and other materials that will help you make the right choice.

Finally, if you’re really not sure, then ask us. Our implementation experts at HMS can walk you through all the advantages and disadvantages to each of these options allowing you to make an informed decision.