time tracking - work in progress

Our client bills their clients on the basis of employee hours worked on the clients' projects. The hours recorded on time sheets submitted by our client's staff are input into a central computer system which uses the times as the basis for invoicing.

Our client had two main problems. First, time sheets were not being presented on time.

Second, and a consequence of the first, invoicing was not reflecting times actually worked by all employees on a client project.

We developed a database that accepts time recording data from the main system and from these data identifies missing time sheet information.

chasing late time sheets

On a weekly basis, the database automatically e-mails employees who have fallen behind on their time sheets

Additionally our system e-mails departmental heads with a summary of employees who have fallen behind on their time sheets

Each month the database e-mails department heads with a work in progress report based on the hours allocated by each employee to client projects.

value to client

Systematic approach to time recording:

• Improvements in time recording
• Automated tracking of time sheets
• Automated chasing of outstanding time sheets
• Automated work in progress reports
• Improvements in promptness of client billing
• Improvements in fulness of client billing.

client

A multi-national advertising, design and consultancy company.

platform

Microsoft Access, Excel, Outlook and VBA.