Time Sheet Tracking and Work in Progress

Invoicing their clients on the basis of time spent on projects, our client relies on staff timesheet information for the calculation of billing amounts. The hours recorded on time sheets are input into a central computer system that then outputs outputs the invoices.

Our client had two main problems. First, not all time sheets were 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.

To assist our client in their efforts to tighten up on time recording, DMW developed a database that determines the gaps in timesheet information stored on the central system and chases the staff concerned.

Chasing Late Time Sheets

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

Additionally the system keeps department heads aware of the situation by e-mailing a summary of miscreants' slackness.

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. Real-time database links to client's Oracle-based accounting and time recording system.