Tag Archives: Timesheets

Capitalization and why it matters to project management

If you work in the Finance department Cap-Ex and Op-Ex are terms that are often used to differentiate between capital expenses and operational expenses.  That can matter to a project manager when trying to find the correct type of funding for a project.  There is, however, an aspect to capital management that is much more significant for most high-tech organizations and that is the notion of capitalization of project work.

Ever since the Y2K period when we saw IT firms going public with balance sheets that would vary greatly from one firm to the next, the US Federal Government has made rules about how assets are calculated.  When an organization invests in an asset such as a piece of software they are developing or a process or equipment they are inventing, they can have a line-item on their balance sheet that refers to the item’s value as an asset and is likely called “Intellectual Property”.  The concept makes common sense.  Let’s say a high-tech company invents something like a piece of software.  The software has some intrinsic value so if you ever sold the company, the value of that software would have to be taken into account yet how do you determine the exact value?

Capitalization targets that exact question and if your firm is or is about to be publicly traded, the concept is even more important.

Years ago, when proposals were first made to the US Financial Accounting Standards Board (FASB) I was asked by Strategic Finance Magazine to write an article about how this would promote activity-based-costing for project managers.  I’ve written about what would become Sarbanes-Oxley several times since.

The Sarbanes-Oxley law says that you have to be able to account in an auditable fashion anything you put in your balance sheet.  The penalties for failure can be significant.  The law has teeth and the CFO’s of firms traded on US exchanges know it.

One way that follows “Generally Accepted Accounting Principles” (GAAP) of calculating the value of an asset is to define the actual cost of it.  That cost includes the labor of the inventors, the indirect costs of their work as well as any equipment and materials they needed.  If you know what people are being paid and you know what they work on, then this amount can be calculated.  But, that requires tracking activity-based-costing.  In the TimeControl world, this is one of the goals of many of our clients.

This may sound similar to Research and Development Tax credits that we’ve written about on the TimeControl site often.  But the rules are somewhat different.  R&D tax claims are designed to promote companies and employees in the country to work on inventing new things.  Capitalization focuses on calculating the value of the thing created.

Here’s an example.

Let’s say we write some software and we pay the salaried staff in our own firm who are working here in our country $100,000 to invent it.  That $100,000 cost includes only those activities which are R&D eligible so inventing time, coding time, testing, even documentation.  But it doesn’t include marketing efforts, sales efforts or services such as technical support.  The $100,000 of costs can be applied to a research tax credit wherever it is available.  We can capitalize $100,000 of those costs and make the value of that software equal to the costs.  The timesheets that show the inventing, coding etc. tasks all count towards the capitalization of that project.

In TimeControl terms we configure the timesheet to code the tasks which are R&D eligible and then the staff by location and payment type to be able to report these amounts simply at any time.

Now, imagine we have a second similar project.  Our costs were also $100,000 but instead of using all of our internal staff, we outsourced half of the work to a contractor in another country.  We make both staff and contractors fill out our timesheets configured just as we did above.

But the results at the end of the year can be different.  The total that is capitalizable would still be $100,000 as that is the intellectual equity value that we’ve added to the company.  But, the Research Credits almost certainly don’t include the contractors from another country.  So if half the work was done outside the country then it’s entirely likely that our Research Credit is only $50,000.

For project managers and Finance Directors, we can often find conflict in being able to get to that auditable intellectual equity calculation for R&D or for Capitalization or both at the same time.  Finance is looking to accomplish what they need from their own tools and Project managers are just looking to finish projects as quickly as they can but when both parties collaborate, the benefits to the company can be significant.

Finance may find that just a payroll timesheet isn’t enough as they need the activity-level data.  Yet using a project-only timesheet such as Project Management might want isn’t enough because we need auditable results and those are always easiest when we are looking at 100% of time accounted for.

Using a multi-function timesheet like TimeControl makes this type of decision much easier.  It is common for TimeControl to be configured to achieve multiple corporate goals at once.  TimeControl’s extensive rate functionality is able to track multiple rate values simultaneously so for the same hour of work, we are able to calculate a billing cost, an actual or payroll cost, an average project cost or other cost types.  This allows us to use one of these many rate values to track the actual cost to us for capitalization.  Next we need to make sure we are only calculating those capitalization tasks that are eligible.

The TimeControl task lists that might start in a project management system can arrive into TimeControl with Capitalization codes already established or they can be added by Finance after the tasks enter TimeControl.

The coding for staff as contractor vs. employee or country-of-origin can also be coded directly in HR or added to TimeControl later.

The beauty of the system is that end users don’t have to care.  This kind of background coding and decision making between Finance and Project Management allows the timesheet process to continue unimpeded and results in different parts of the organization getting the detailed financial or project information they need when they need it.

For organizations already using TimeControl for other purposes such as project tracking or HR or payroll, configuring the system for an additional purpose takes very little effort.  For those who haven’t yet started using TimeControl, adding the tracking of capitalization just becomes part of the basic configuration when the system is deployed.

There are processes to create and follow of course.  There will need to be someone in Finance who is responsible for following and reviewing the Capitalization data and reports that come out of TimeControl.  In addition, there will probably need to be some level of communication between Finance and Project Management to make sure that both parties understand what defines a capitalizable task or not.  But that kind of additional communication is probably a healthy addition to your regular process.

The advantage of using a multi-function timesheet like TimeControl is that a) different parties such as project management or Finance don’t have to compromise and not get the data they need and; b) end users don’t have to start filling out more than one timesheet.

Talk to HMS if you are interested in using TimeControl for capitalization, R&D tax credits and project management tracking as well as all the other aspects of timesheet collection that can be managed by TimeControl from the same system at the same time.

 

 

Migrating from Excel Timesheets to TimeControl?

There are countless organizations that still do their timesheets in Excel.  Is it any wonder that in every copy of Excel there are templates included to make multiple types of timesheets?  The advantage of using Excel for such tasks is twofold: First, it is instant.  If using a template, an Excel timesheet could be deployed in an hour.  Second, it is ultimately flexible.  An Excel timesheet can be changed to whatever degree you wish.

But, as easy as it is to create an Excel timesheet for a small group, organizations often outgrow such systems very quickly.  When the requirements for the timesheet include auditability or the need to harmonize coding to a central structure or just trying to find missing timesheets, the ease of Excel is eclipsed by its challenges.

TimeControl was designed from its inception in 1994 to have Excel integration and now, 25 years later, that integration is multi-faceted.  Aside from being able to consume Excel worksheets for lists of projects, charges or employees or being able to create Excel workbooks to enable analysis, reporting or external integration, TimeControl is a likely and common place for organizations to migrate their Excel timesheet systems.  Maintenance and the management of an Excel timesheet when an organization grows, becomes more complex, more costly and a bigger challenge.  That’s where TimeControl’s centralized data structure becomes much more attractive.

TimeControl has numerous points of contact with Excel:

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 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 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 couple of 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.

TimeControl DCAA Solutions area updated

Every year the US Defense Contract Audit Agency audits thousands of contracts with the US government.  If you have ever been part of such an audit you will know that the DCAA places a particular emphasis on verifying timesheets associated to workers working on projects that they oversee.  It is not enough to have a good time and attendance record.  The DCAA must validate that hours billed to government contracts were spent on those projects and not on other work.  A complete task-based timesheet is required that encompasses all work.

In 2017, the DCAA audited over $281 billion in defense contract costs.  The DCAA is not restricted to defense contracts alone.  Their standards and audits are also used by NASA, the DoE, Homeland security and other agencies.

While the DCAA deliberately does not endorse or certify software products, and instead focuses on an auditable process, the standards they require are well known.

TimeControl has included DCAA compliant functionality for many years and has been selected by clients on numerous occasions to be used for DCAA audit compliance.

HMS maintains a resource portal with a number of useful tools and links to aid in becoming DCAA compliant when using TimeControl.  The portal is free and is located at: dcaa.timecontrol.com.

TimeControl 7.2 is now available and it includes the new TimeControl Mobile App!

We’re very excited to announce the release of TimeControl version 7.2. This update to TimeControl includes numerous new and enhanced features and also showcases the release of the TimeControl Mobile App!

There are some incredible new features in this version and some major enhancements too!

The TimeControl Mobile App!
It has been a while in the making but the TimeControl Mobile App is now available.  It is a free App designed to work on both Android and iOS (Apple) devices.  The App lets users log into their TimeControl account and create a timesheet, update an existing timesheet, complete and release a timesheet and, if a supervisor, approve or reject timesheets.  The App is highly intuitive with a responsive design interface.  If used on an Android device, it adopts the styles and characteristics of that device.  If on an Apple device, it appears as any other Apple-based App.  The screen adjusts to the resolution available to it.

The TimeControl Mobile App is free and available on Google Play and the Apple App Store.  The TimeControl Mobile App works with TimeControl 7.2 and higher installations.

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

TimeControl API
TimeControl now includes a complete Application Programming Interface to the already numerous methods of integrating TimeControl with other corporate systems. With scheduled links already available, many organizations can take advantage of transferring data to and from TimeControl through transaction files. This new REST-based API goes even further, letting organizations program the movement of data into and out of TimeControl by creating programming calls to the TimeControl API. The API is optionally installed as part of TimeControl and security is controlled in both System Preferences and User Profiles.

Timesheet Grouping
TimeControl now allows you to group your timesheet or for TimeControl Industrial users, the Crew Timesheet. For users with a large number of line items, grouping them can help with data entry. There are up to five levels of grouping and you can group by any field displayed on the timesheet.
New buttons to Expand All or Collapse in the Actions Menu at the top allow you to quickly display all lines in the grouped format or go back just to the summary lines.

There is so much more!
Additional new and enhanced features include: Scheduled Timesheet Creation, Scheduled Autofilled Timesheets, email notifications in Line Item Approvals, pretest Validation Rules, SAML 2.0 authentication support, new data views in the Drill Down Analyzer and more.

For more information about TimeControl version 7.2, visit TimeControl.com/features/latest.

This new version is available now for clients with a current support and maintenance agreement at no additional charge from the TimeControl upgrades site: TimeControl.com/support/updates. TimeControl Online users will be upgraded automatically in the coming weeks.

Best Practices

Whether you are new to TimeControl or have used it for years, getting the fiscal year underway is a good time to review your timesheet practices to look for improvements.  bestpractices_300x168.jpgThe TimeControl website has numerous resources for this.

Organizational Best TimeControl Practices

When we think of best practices for timesheet use from the administrator or organization perspective, we think of processes, how to improve efficiency of the organization overall.  The TimeControl website includes a section in the Best Practices area called Timesheet Best Practices for Organizations. At: http://www.timecontrol.com/resources/best-practices/organizations

Personal Best TimeControl Practices

Timesheets are an application which may be used by every employee in the organization.  If we can save each person only a few minutes each week, the combined savings can be enormous.  The TimeControl website has a section called Timesheet Best Practices for Individuals at www.timecontrol.com/resources/best-practices/individuals which includes presentations and materials which show how each user can shave time off their timesheet entry effort.

Additional Use Case Scenarios

It is very common for us at HMS to receive calls asking how to use TimeControl for a particular use-case scenario.  This is often because TimeControl was originally implemented to solve a particular set of business challenges and now that it is a stable part of the organization’s culture, we don’t pause to think of what else it might be able to accomplish for us.  Take a look at the TimeControl Use Case Scenarios at www.timecontrol.com/use-cases to see the most common business challenges TimeControl solves and see if any of these can be applied in your own organizations.

Missing Features

You might not keep track of all the functionality that TimeControl offers.  Once you have deployed the functionality you originally designed into your timesheet process, it is quite common to ignore any new functionality which may have been added in the meantime.  So, take a moment and peek at the TimeControl Features overview at www.timecontrol.com/features which shows the most popular aspects of the TimeControl system.

FAQs – Frequently Asked Questions

We use the TimeControl blog itself to archive answers to the most frequently asked technical questions.  You can go to the search function of the blog and enter “FAQ” or just click on this link at:  blog.timecontrol.com/?s=FAQ.

For more about TimeControl Best Practices, go to: www.timecontrol.com/resources/best-practices.

FAQ: Timesheets by Exception

autofill.jpgCan TimeControl support timesheets entered only by exception? We have some operational staff who do the same thing all the time and are on salary so the only time we need their timesheet is when they need to book sick leave or vacation.

You can do timesheets by exception.  But, more importantly, you can do timesheets by exception for some staff while doing positive-entry timesheets for everyone else.  A positive-entry timesheet is one where an employee is expected to enter the timesheet with what they did with their time each day.  An exception timesheet is one where the employee typically does the same task each day so tracking their day-to-day activities is not important.  In their case, we’d like to default their timesheet to a standard week (for example: 40 hours of “in attendance”). Those employees would only have to make an entry for an “exception” such as vacation or sick leave or personal time off.

TimeControl includes a function called “Autofill” that automatically fills a timesheet for any employee in this category to the maximum per day required.  If there are no entries for that person, a complete week is filled in.  If there are some exception entries, only the gaps are filled in.  In this manner we can accommodate both exception timesheet employees and positive-entry timesheet employees.  More on this and other HR-related functions can be found at: http://www.timecontrol.com/use-cases/human-resources

TimeControl Administrator Management

7276253TimeControl is a centralized timesheet system and requires administration as any other centralized system would.  In smaller deployments of 100 users or less, all the responsibility typically falls to one person who helps design the TimeControl implementation and then manages it ongoingly.  But what happens when the deployment is more complex?  Let’s talk for a moment about the Administration Roles and how this work can be distributed to more than one person.   First of all, there are several types of Administrators that are possible:

Technical Administrator

If you have installed TimeControl on premises, you will almost certainly require a Technical Administrator.  If you are subscribed to TimeControlOnline, HMS Software takes care of this responsibility.
The Technical Administrator is typically from the IT department and is responsible to keep the TimeControl system functioning.  They will be responsible for the server TimeControl is installed on, the database that TimeControl is using and technical responsibilities that include the following:

  • System Monitoring
  • System Usage
    • Database storage
    • Log file storage
  • Technical Support
  • Testing and Installing new Upgrades

TimeControl may have been installed with multiple instances to provide a production instance that everyone uses as well as a staging or development instance that is used for testing new updates prior to giving access to the update to everyone.

Main Administrator

Whether you are subscribed to TimeControlOnline or are using TimeControl on premises, you will want a Main TimeControl Administrator who will take charge of the centralized aspects of the system.  This includes being responsible for:

  • Documenting and Maintaining the System Processes
  • Table Maintenance of the Employee, User, Charge, Project, Resource and Rates tables
  • System Preferences
  • Management of User Profiles
  • Archiving of old timesheet data
  • Routine Data Cleanup
    • Deleting or hiding old projects, employees, users, pop-up values etc. so that current users don’t need to go through them as they use the system.

Secondary Administrators (optional)

Larger organizations may divide up some responsibilities to different people in the organization.  It is not unusual in larger deployments for example, to have an HR administrator who will deal with onboarding and offboarding employees who join and leave the company.  They will be responsible to add or remove these employees from TimeControl as part of the overall process of a new employee or one who is leaving.  Some common Secondary Administrators include:

  • HR Administrator
    • Users
    • Employees
    • Internal Rates
    • TimeRequest Wizard
  • Project Administrator
    • Project Table
    • Charge Table
    • Resource Table
    • Assignments
    • Project Rates
  • Costing/Billing Administrator
    • Rate Values

Training for these secondary administrators must ensure that the multiple roles don’t conflict so ensuring that one aspect of the data is the responsibilty of one person is critical.

Some other notes

  • Share the knowledge
    One thing we see often at HMS is a call from a client informing us that their long standing and very knowledgeable TimeControl Administrator has just left and they need to retrain someone “right away”.  While HMS often does such training, it’s important to remember that complete training requires intimate knowledge of your internal processes.  It’s much more effective to have more than one Technical and Main TimeControl Administrator trained and active so that if there is someone missing even for a short time, there is no loss of continuity.
  • Document your system
    No one loves this responsibility but it is important nonetheless.  HMS does system documentation as a matter of course but process documentation is also critical and this is often left to the client to produce.  The more documentation you have for your centralized system, the easier it is to update and to train new people when required.
  • Don’t miss out on what’s new
    When new versions of TimeControl are released, take the opportunity to see what new functionality will be of benefit to your particular deployment.  It is common to skip an update or even if the Technical Administrator updates the system to just keep using it the way you always have without pausing to see if any new or enhanced functionality would be of use to you.  So, take a few minutes, look over the new features and see if there is something there that will make your life easier!

If you need help with Administrator Training, talk to HMS Technical Services at info@hms.ca.