Act! Database managing provision of Personal Assistants and Payroll Services to Clients on Direct Payments.
The challenge…
This client specialises in the provision of Personal Assistants, Payroll Management and Bank Account Management to their clients who are in receipt of Direct Payments from the Local Authority. They required a CRM database that would hold a considerable amount of detailed information relating to the Clients and Personal Assistants and show the relationships between the various parties.
Our solution…
An Act! database was chosen as the core system for a 6 user system in a hosted desktop environment. The database required heavy customisation to ensure that all of the relevant information was captured and presented to the users in a structured manner.
In addition to holding client information the database also needed to record detailed data relating to the Personal Assistants in terms of their availability for work, their training records and which Clients they had worked with.
To manage the required to track funding status and costs the Exponenciel Automatic Calculations add in was also installed.
The benefits…
The Local Authority requires regular status reporting on all Direct Payments cases to ensure service levels are being met. Prior to the implementation of Act! our client was primarily based and reporting was a time consuming process taking up a unnecessary amount of administration time. The Act! database holds all the relevant information around dates and key milestones to simplify report generation.
