A guide to using Excel as financial accounting software
A comprehensive collection of articles, videos and more, hand-picked by our editors
A hospice and home healthcare company cured its budget process -- and saved $1 million a year -- with cloud CPM...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
software from Adaptive Insights.
By the start of 2014, after a phased implementation, Gentiva Health Services had replaced mainly Oracle Hyperion with Adaptive Planning corporate performance management (CPM) software for revenue planning, budgeting and forecasting. The business budgeting software is giving new life to the hospice and home healthcare giant.
"It has made the budget process so much simpler, so much easier, faster, with better user buy-in, fewer mistakes," said Kevin Bradshaw, director of finance for Atlanta-based Gentiva. "It has made us way more efficient with our budget process overall."
According to a study licensed and distributed by Adaptive Insights, which is based in Palo Alto, Calif., leaders at Gentiva were unhappy with what was a long and difficult budget process. Branch managers at 400 sites were frustrated with the time it took to complete budgets and with making changes needed to comply with a variety of rules.
Gentiva pays about $57,000 a year in subscription fees for the CPM software as a service from Adaptive Insights, which was formerly known as Adaptive Planning. It paid another $70,000 in consulting, personnel and training in prestart costs and another $4,800 for annual training on the business budgeting software.
By replacing mostly Oracle Hyperion with Adaptive, Gentiva saved about $1 million a year, according to the ROI Case Study report by Boston-based Nucleus Research. That number includes $463,000 in direct costs such as eliminating Oracle Hyperion license fees and consulting costs and reallocating staff to other projects; and $537,000 in indirect costs such as increased productivity of the finance team, IT and budget managers, the report said .
Gentiva evaluated business budgeting software from a number of companies, including Adaptive and Oracle. Bradshaw said Gentiva chose Adaptive partly because a hospice company it acquired in 2010, Odyssey Healthcare, used Adaptive and recommended it.
Bradshaw said Adaptive CPM is boosting productivity of budget managers and finance executives, giving the entire company new visibility into the budget process and reducing or eliminating software and consulting costs.
Gentiva began implementing Adaptive CPM is the summer of 2012, starting with its home health division. The implementation of the business budgeting software took three months for the division and was followed by corporate and hospice in the first half of 2013.
In the fall of 2013, the implementation slowed when Gentiva acquired the home health, hospice and community care businesses of Harden Healthcare Services. By January of 2014, all divisions were live on Adaptive.
Business budgeting software solves key problems
Bradshaw said the Adaptive system solved two major problems involving creation of the budget and approval of changes. Previously, finance leaders at Gentiva would create budgets for each of some 400 company locations.
With Adaptive, branch managers were provided access to the system and authorized to create their own budgets, Bradshaw said. This helped motivate them to buy into the idea of using Adaptive, he said. "It's a huge thing to say, 'This is your budget. You own it. Next year, when you are behind budget, it's nobody's fault but your own. You came up with this budget.'
Also, when a branch manager updates a budget, the change is immediately reflected in the budget for the entire organization.
Adaptive dramatically improved productivity, mostly by freeing up time for finance leaders.
"Previously, the budget process was taking too long," he said. "Our regional finance folks were staying up all night, doing 80-hour weeks for three or four months trying to get the budget ready. It's so much simpler with Adaptive."
The company also still uses Microsoft Excel just "to slice and dice" the numbers a little better, he said. Adaptive exports perfectly to Excel. "If you create a report, you can export it to Excel and it looks just like it did on your Adaptive screen [but] it's in Excel. Adaptive makes it perfectly seamless."
Excel retains its role
"We are a really big Excel user as a company," Bradshaw said. "Most everything is just exported to Excel. Personally, I don't print anything. I don't think most of our superusers do either. They pretty much just keep everything on Excel. That gets emailed around."
He said Gentiva doesn't use any connectors or automation to integrate Adaptive with the company's PeopleSoft ERP for general ledger. Instead, once a month, Bradshaw takes a couple of minutes and uses Excel to upload the general ledger from PeopleSoft into Adaptive. That allows Gentiva to compare actual to projected budgets and see the difference in dollars or percentages.
"That is one reason we why we decided not to go the connector," Bradshaw said. "It was hardly worth paying extra money to save me that amount of time."
With Adaptive, he creates a monthly, company-wide report that includes the actual budget, the last three months and then the year to date. He also writes a year-over-year report to show growth numbers.
Bradshaw said he likes the Adaptive modeling engine and drag-and-drop interface. "It's great. It is really simple to do."
The company's new owner -- Kindred Healthcare of Louisville, Ky., which completed its purchase of Gentiva early in February -- will also be using Adaptive, he said.
Kindred uses SAP ERP software, which will replace the PeopleSoft system for the general ledger. Gentiva will likely use connectors to link with the SAP system, he said.
Choose a budget technique
Get the buyer's guide to CPM software
Compare vendors in part two of the CPM buyer's guide
Budgeting software and video for learning top new Workday offerings