Data consultancy has helped Shetland Recreational Trust dramatically improve its invoicing procedures
“It has made a great difference to our workload, with a saving of one full day a month, while ensuring a much greater level of accuracy”
Norma Johnson, clerical assistant, Shetland Recreational Trust I
n September 2014, Shetland Recreational Trust decided to invest in eyeQ, Gladstone’s new query builder and business
intelligence tool. The trust has worked with Gladstone since 2001 and, in addition to the company’s signature Plus2 member management software, is currently using the Connect online booking system across its eight sport and leisure sites, as well as a Kiosk self-service unit at its largest site. eyeQ appealed to us as it offered us an opportunity to improve our reporting capabilities as well as our invoicing procedures. We had been aware for some time
that our invoicing procedures required updating. Plus2 did not link in to our fi nancial software, so we had to create and print our sales invoices from Plus2, and then manually re-enter the details into our accounting system. With 100 invoices to process a month, each with around 10-15 invoice lines, we
June 2015 © Cybertrek 2015
found this to be very time consuming, taking up to a full day of staff time and inevitably leading to some errors. We believed eyeQ could help us
solve this problem, but while it is possible to create simple reports after the two days’ basic training offered with the product, we knew that for something this complex we required extra support. Gladstone offers all eyeQ customers access to a data consultancy service – provided by a member of its in-house data services team – to assist with this kind of issue. The service, which was charged
per day, involved a consultant visiting us in Shetland for three days in December 2014, to better understand our processes and work with us to fi nd a solution. By looking closely at the mapping of sales products within Plus2 and consulting with the suppliers of our fi nance package, he created an extract fi le using the custom SQL feature within eyeQ. This was able to
pull the relevant data out of Plus2 and organise it for compatibility, before exporting it into Microsoft Excel ready for automatic upload into the accounting system. After leaving Shetland, Gladstone
continued to work with the supplier of our fi nance package to develop the extract fi le, and after some fi nal testing we successfully completed our fi rst upload in February of this year. In terms of benefi ts, the sales
invoice interface has made a great difference to our workload, with an immediate staff saving of one full-time day per month – time that can now be spent on more valuable tasks – while the automation of the process ensures a much greater level of accuracy. In addition to these long-term
benefi ts, the project has given us the confi dence to work with Gladstone on other, higher-volume interfaces using eyeQ, which we anticipate will result in an even higher fi nancial return.
Read Health Club Management online at
healthclubmanagement.co.uk/digital 79
Page 1 |
Page 2 |
Page 3 |
Page 4 |
Page 5 |
Page 6 |
Page 7 |
Page 8 |
Page 9 |
Page 10 |
Page 11 |
Page 12 |
Page 13 |
Page 14 |
Page 15 |
Page 16 |
Page 17 |
Page 18 |
Page 19 |
Page 20 |
Page 21 |
Page 22 |
Page 23 |
Page 24 |
Page 25 |
Page 26 |
Page 27 |
Page 28 |
Page 29 |
Page 30 |
Page 31 |
Page 32 |
Page 33 |
Page 34 |
Page 35 |
Page 36 |
Page 37 |
Page 38 |
Page 39 |
Page 40 |
Page 41 |
Page 42 |
Page 43 |
Page 44 |
Page 45 |
Page 46 |
Page 47 |
Page 48 |
Page 49 |
Page 50 |
Page 51 |
Page 52 |
Page 53 |
Page 54 |
Page 55 |
Page 56 |
Page 57 |
Page 58 |
Page 59 |
Page 60 |
Page 61 |
Page 62 |
Page 63 |
Page 64 |
Page 65 |
Page 66 |
Page 67 |
Page 68 |
Page 69 |
Page 70 |
Page 71 |
Page 72 |
Page 73 |
Page 74 |
Page 75 |
Page 76 |
Page 77 |
Page 78 |
Page 79 |
Page 80 |
Page 81 |
Page 82 |
Page 83 |
Page 84 |
Page 85 |
Page 86 |
Page 87 |
Page 88 |
Page 89 |
Page 90 |
Page 91 |
Page 92 |
Page 93 |
Page 94 |
Page 95 |
Page 96 |
Page 97 |
Page 98 |
Page 99 |
Page 100