Since 1982 Video 2000 has grown to be the fourth largest video store owner and operator in Australia with over 100 rental stores. These are a mix of wholly-owned stores and franchises, with stock levels exceeding half a million movies. The groups’ affairs and the 11 different distribution companies are managed by a family type group and an active Board of Directors.

“We are impressed by the Excel integration and have leveraged greatly from this function in Greentree. Monthly reporting has been reduced from 1½ days to 4 hours for over 80 reports. To record and process GST now takes 5 minutes compared to 30 minutes.”

Business growth and tax implications prompted a review of their business set-up and existing financial software, CBA. Market trends such as the move towards DVD rental over video changed the industry and meant Video 2000 would need a system flexible enough to monitor this impact and manage business critical information. Director, Brian Brent, explains, “The business growth hit a point where we had to change our systems. The main drivers for moving to Greentree were the introduction of GST, the attraction of the strong data importing facility and more flexibility of reporting.”

Video 2000 implemented Greentree in time for the introduction of Australian GST. Brian describes, “As with any new product, we were pioneers with Greentree. The business design of the system, plus the complexity of our business meant everyone was learning. We looked at a few other products, but we were comfortable with CBA and the new product from the same developers, Greentree.” With the introduction of Greentree the whole offi ce changed over to Windows. “Some personnel were not keen about using a new system at fi rst, but now they trust it and would not want to go back.”

Video 2000 draws heavily on the financial system and has very specific business requirements. Due to the high volume of data, processing and analysing reports in CBA for each of the 100 stores meant there were speed issues. These complex financial reporting structures, budget modelling and transaction entry were addressed and streamlined using Greentree's Excel reporting tool. Finance Controller, John Rashleigh, describes the impact on processing over 1400 AP invoices per month, “Excel is without doubt the biggest bonus. The high volume of processing has been improved by Greentree’s integration with Excel. The AP invoicing is all matched against orders in external databases and processed by the Excel import and avoids manually keying in high volume of invoices. Now it’s all automated.”

“Greentree is doing everything it needs to do. We aim to continue to streamline our processes and speed up reporting. Greentree’s automation and integration has relieved us of all the manual processes saving staff time and costs.”

The ability to manage and produce all reports using Excel has been a big change for the company. Greentree’s Excel integration has reduced the demand on staff time. John comments on their time savings, “We are impressed by the Excel integration and have leveraged greatly from this function in Greentree. Monthly reporting has been reduced from 1½ days to 4 hours for over 80 reports. The monthly report run now takes from 4 hours compared to 1 week using CBA.” John says the management of GST has also been alleviated. “To record and process GST now takes 5 minutes compared to 30 minutes. Greentree saves us a couple of times a month having to manually report GST.”

One specific requirement was to better manage the large data flow of sales reports from each store to the headquarters and be able to process them directly in Greentree. The Greentree Business Partner has specifically streamlined the sales import giving the management team true sales figures in the General Ledger instantaneously. “We can just go and pick a store to run a report rather than having to do a full run.” Commenting on the professional services of the support team, Brian says, “We have had no problems with the support or the quality of the customisations, no complaints from us! The ability to get customisations done at a reasonable cost is an advantage of working with the Greentree team.”

Video 2000 are heavy users of Greentree’s user defined transaction analysis trees which allow them to group their information, such as business units or geographical locations, for use at report time for sorting and sub-totalling at any level. The support team set up 11 separate companies in the system which meant the data was more manageable, particularly when they needed to produce a balance sheet and a profit and loss report per month per store. This powerful feature means the management team can easily tailor many standard Greentree reports and can summarise financial information within Excel. Previously, in CBA they used over 30,000 General Ledger accounts for all stores. “The big attraction for us was to simplify our chart of accounts. Greentree’s transaction trees have helped our ‘multi-branch’ system. Maintaining the chart based on that set up is so simple. Now there are only 1000 General Ledger accounts in Greentree,” explains John.

Clearly Greentree is keeping pace with Video 2000’s growth, “Greentree is doing everything it needs to do. We aim to continue to streamline our processes and speed up reporting. Greentree’s automation and integration has relieved us of all the manual processes saving staff time and costs,” Brian concludes.

About Video 2000

Since 1982 Video 2000 has grown to be the fourth largest, leading video store operator in Australia with over 100 rental stores and an on-line store. The groups’ 11 different distribution companies are managed by a family type group and an active Board of Directors. The group is administered by offices in Brisbane, Canberra, Darwin, and Townsville with the corporate headquarters situated in Brisbane.

For more information visit www.v2direct.com.au