Tag Archives: line item approval

Line Item Approvals

TimeControl Line Item Approvals, Chris Vandersluis, Christopher Vandersluis, Christopher Peter VandersluisIt’s almost never enough to just approve a timesheet based on the total hours in it. If you are in any kind of project or activity-based scenario, you will still need to approve the total time for the timesheet, but you will also want to do approvals for the projects.

We encountered this problem way back in 1983 as we wrote our first timesheet. There were two groups sponsoring the initiative. One was Finance. They needed total hours to be able to properly pay people and both Finance and HR needed to know when people were not working and why, again to determine the payroll properly as well as determine what entitlements like vacation and sick-leave have been taken by each employee. But that was what only the one group needed. Also sitting at the table was the Project Management department. They had a burning need to track not just how much time was being spent each week. They needed to know exactly what it was being spent on. They already had project plans, what they didn’t have was project actuals. They were being asked by management to describe budget vs. actual progress on each project and they simply didn’t have the data.

Easy, right?

It wasn’t actually. It took numerous design sessions where one side of the table or the other was unhappy before we finally realized the crux of the challenge was that we would need both approvals for the whole timesheet totals and separate approvals line by line.
TimeControl Matrix Approvals, Chris Vandersluis, Christopher Vandersluis, Christopher Peter Vandersluis

Ten years later we carried that philosophy into the first commercial release of TimeControl with both organizational approvals and project manager approvals. We also created a whole process to support those functions and called it the Matrix Approval Process for Labor Actuals™. Which is still a core element of TimeControl today. In that process, supervisors approve the whole timesheet and look at attendance and things like personal time off and sick leave. Project Managers get to approve or reject each project task when that task came from a project management system such as Microsoft Project or Primavera.

It was a big success.

As TimeControl matured we were faced with several new challenges. It wasn’t enough to do approvals of each line just for the project managers. Plus, not everyone was using a commercial project management system around which we’d designed the first pass of the Project Manager Validation function. Now we were asked could we also make independent line approvals for billable items, for contractor time vs. salary staff, for time to be exported into HR with approvals of entitlements.

That resulted in the Line Item Approval function. It works just like the Project Manager Validations but is based on an export interface. Let’s say your TimeControl environment has an export for Contractors. The idea is that individual contractors can review and approve the time their people spent on the project on a line-by-line basis. Then, once they get around to invoicing their client, both sides have already approved the time. Think that might not be a big deal? We’ve watched several clients do this and reduce the approval time of contractor invoices from between 90 and 120 days all the way down to 3-5 days. The impact on both the contractor and the client can be profound.

Line Item Approval basically lets us create an unlimited number of task-by-task approval processes all from the same timesheet line. We don’t delete that line (we never do in TimeControl anyway to ensure auditability) but the timesheet can get auditable adjustments if needed or the lines that are deemed unacceptable for that process can simply be put aside during the actual transfer of data for that purpose. Let’s say you’ve created a Line Item Approval for billing and a Billing Manager reviews all the lines that are about to get transferred into the billing system and made into a summary and then an invoice. By rejecting certain lines, perhaps for unbillable work, the Billing Manager effectively removes those hours from the billing transfer and thus the client’s invoice. The hours don’t evaporate from TimeControl, but they won’t ever be transferred to the invoicing system.

We can’t really make a graphic of this process because it’s three-dimensional. But, imagine the matrix grid and then imagine it has a third dimension with as many layers as you need approval processes. Often it’s just another one or two or three. But the effects on the company can be massive.

Think we’re done? Think again.

In the next version of TimeControl we’ll be introducing enhancements to the Line Item Approval (internally we call it LIA) Process and have even gone back to the original Project Manager Validation function to align the functionality of both features. Line Item Approval is already one of the most popular aspects of TimeControl and its flexibility ensures it can adapt to almost every approval requirement.

Auditability, Accountability and Flexibility. It’s a powerful combination.

Find out more about Approvals on the TimeControl.com website at: TimeControl.com/use-cases/matrix-approvals.

Line Item Approvals brings you beyond Project Approvals

Imagine this scenario… You have to review timesheets before sending them back to the LineItemApproval.jpgproject management system.  No problem.  TimeControl’s Matrix Approvals lets you do approvals both at the organizational level and task-by-task for the project.

Now you find out that you also need to review any timesheet hours and costs prior to being accepted by billing.  It’s very similar to the task-by-task exercise but it’s not for the project.  It’s for the client, not the project.

Enter TimeControl’s Line Item Approvals (LIA).  Line Item Approvals lets you add an additional line-by-line approval mechanism prior to sending the data to the billing system.

“But wait,” you say.  “We also need to have each contractor review their timesheet data in the field prior to acceptance!”

Line Item Approval once again has this covered.  This is one of the most powerful and extensible elements of TimeControl.  It essentially takes the Project Manager Approval concept; something that has been in TimeControl since version 1.0 back in 1994 and extends it as many different times as you wish.  The design of this feature is very elegant.  It is associated to the Interface Definition of a Table Export.  You might be using Scheduled Links or OnDemand Links or even pulling the information via TimeControl’s API but the Line Item Approval process flows through the interface definition.  If you turn this on, the export will not send lines of data through that export that have not been approved.

It’s hard to make a graphic for this because it essentially takes the two axis Matrix Approval Process and makes it into a 3, 4, 5 or as many as you want axes.

Worried this might slow your approvals?  No need.  Each and every Line Item Approval flow is completely independent of the others.  So, the Project Manager Approval might be weekly, the Account Manager Billing Approval might be monthly and the on-site contractor approval might be every two weeks.  You get to decide.

There are many more features in this remarkable function.  You can, for example, send automated emails when timesheet lines aren’t approved for a particular LIA approval process or filter the information that results from the approval process.

Setting up Line Item Approval takes only seconds but before you rush to do it, working through the workflow of what you’re trying to accomplish is worth taking some time on.

You can find out more about Line Item Approval in the TimeControl Reference Guide or ask your Account Manager if you’d like HMS Consulting Services to assist.