How Gardant Simplified Senior Living Reporting with Sage Intacct

(0:07) We have integrated Sage Intact, which is our ERP software.
(0:07) We have that as a nightly integration.
(0:17) We also use data from Paycom, though it’s not directly integrated.
(0:17) We have someone on our team that uploads data after a payroll, as well as some other internal data that we use.
(0:38) Our company is in the assisted living industry.
(0:38) So we manage different communities in various states that offer Medicaid and private pay.
(0:47) Each community has its own set of books, payroll, etc.
(0:56) So Solver is very useful to combine those various books.
(0:56) Each of the communities that we manage have its own set of books.
(1:08) So we wanted to be able to have a software that would allow us the capability to create reporting, where we could see how all of these communities compared to each other, as well as provide combined reporting for ownership that is similar amongst several communities.
(1:27) Solver helps us with this issue.
(1:27) We also wanted to have one place where budgeting would be housed.
(1:33) So we could also compare those items and be able to go to one place to see those budget items.
(1:41) Prior, we budgeted via Excel and there was a lot of manual issues that could occur with those.
(1:49) Solver’s been great so far.
(1:49) I feel like our capability to create reports and produce those reports to benefit the whole entire company operations, the various executive directors at the communities has been outstanding.
(2:11) We’ve heard nothing but praise for the reports that we provide.
(2:18) We’ve been a growing company.
(2:18) So we’ve also had people newly joined the team that we’re training on Solver.
(2:25) And I think having some of our team go to the conference this year will help us learn how we can use Solver better and make our reporting and that even better.
(2:41) The main reason for us going with Solver was to help solve for a budgeting issue that we had.
(2:51) We were doing budgeting very manually prior in Excel and any changes had to be done by opening an Excel file for every single community and updating it and saving it back.
(3:04) There were also issues where someone could make a manual adjustment or change to a budget and it could throw it all off.
(3:11) By having it in Solver, we have control over it.
(3:11) We can make adjustments one time that will impact all budgets.
(3:18) We’re also able to pull information and compare it.
(3:27) Just the ability to create a report one time and be able to pull that for multiple months showing the same data set has greatly improved efficiencies.
(3:36) We’ve also been able to create reports for ownership groups that we’ve heard nothing but praise about.
(3:49) So the efficiencies and timing of these reports has greatly helped us.
(3:49) We’ve made our individual reports that benefit our company or what our company needs at the time.
(4:02) The budgets are customized to how we budget, present items, etc.
(4:10) We haven’t made any Solver customizations, I don’t believe, but the templates are unique to our company and what our needs are.
(4:33) Solver is used explicitly for the analysis team, but we are able to pull various reports that greatly helps our operations.
(4:41) There’s different aspects they look at for different points of time and they like to be able to see, especially Trailing 12, for all communities that have different books in our accounting software.
(4:52) We can pull a report and give it to them.
(4:56) There’s other aspects they like to compare.
(4:56) We’ve compared various budgets to each other that have the same ownership group so we can understand what questions they may have of why one community would be outperforming another.
(5:08) The analysis team is who has access to Solver right now.
(5:08) However, we are pulling data for the various departments at Guardant, especially operations.
(5:22) The collaboration between the analysis team and operations is very collaborative.
(5:22) We work together constantly to make things better at not only the communities, but at Guardant as well.
(5:35) We love that we are able to create a report that will be used and once that report is saved and published that others can have access to that report within the analysis to pull it and run it and that it’s as simple as next month hitting that run, exporting it to Excel, and sending it out.
(5:54) We don’t have to recreate the report month after month end.
(5:54) That is an efficiency itself.
(6:00) We have several reports that we pull for our C-suite that we’ve attuned over time and now people have the ability to run it, pull it, and send it out to high-up individuals that let them see how the communities and our company is doing and they appreciate this snapshot that we’re able to complete.
(6:22) Right now we’re using Solver just for budgeting and for some portfolio-wide reports.
(6:38) We believe and want to definitely expand Solver’s use for forecasting, doing multiple budget versions, etc.
(6:49) The benefits that we’ve received from using Solver has been significant.
(6:49) There are many efficiencies that are handled just by everything being in one place in time, being able to create a report once and running it prior.
(7:05) We would have had to recreate that report time and in time again or export multiple files to create one report so being able to have it all in one has saved numerous hours.
(7:17) There’s also been the risk reduction just how only certain people have the capability to touch these formulas, change these formulas, and things like that.
(7:32) The data being housed all in one area has also greatly benefited us.
(7:32) I’ve heard nothing but wonderful things about Solver from outside of our company, people that are within our company but outside the analysis team that don’t even use it.
(7:46) They know what we’re able to do with it and rave about it.
(7:53) So I find that a very wonderful thing.
(7:53) Our trainer for Solver, John Stravos, was excellent.
(8:06) I can’t say anything better about him.
(8:06) He was always available to help us.
(8:06) We were all managing, working from home, that balance, trying to figure out Solver and John was always happy to hop on a call with us, look at what we had issues with on his own time, and get back to us.
(8:18) We had tremendous support from him so we could get it working and where we need to be at.
(8:25) Overall the training of it and everything went wonderfully.