Client Case Study - Hemsley Orrell Partnership
Job Accounting System

Hemsley Orrell Partnership (HOP) is a multi-disciplinary practice of Consulting Civil Engineers and Structural Engineers, at the forefront of high quality building and engineering projects on both a national and international level.

HOP were using the combination of a simple Access database to record client and project details and an independent time recording and project costing package designed for accountancy practices.

There was a need to combine these systems, avoiding duplication, log more details of Clients and projects and provide a more sophisticated, yet simpler to use, project time recording and accounting function.

We worked closely Adam Humphrey, the HOP Director responsible for IT, to design a database that would meet their specific requirements. Following which we developed the database in Access and imported relevant data from their old databases.

The system records time booked by their staff, expenses and costs such as travel together with costs incurred by third parties. It also logs details of their own staff and of external resources complete with details of their skills and specialities so that skill searches can be achieved.

This data is used to produce a monthly work in progress report (summary or detailed) which is used by the Directors to calculate the monthly invoices.

Invoices are raised in Sage and then keyed into the database so that the monthly report can provide a history of invoices already raised.

Receipts from Clients are also matched against the invoices thus providing the Directors additional information of outstanding debts on the same concise report.

Adam Humphrey (HOP Director responsible for IT) said:

"I could see a need to streamline and rationalise our client and project data. We were duplicating input and unable to easily generate reports to review how projects were running".

"GB Associates were able to turn our aspirations into reality generating an access database which is used throughout our company by all the Staff".

"They provide a first class service where no issue is too much trouble and have always performed beyond our expectations".