Velixo Case Study: Yardnique

We met with Rob Wood – CFO, and Tom Flanagan – Controller at Yardnique to talk about their experience with Velixo and how it changed the game for them.

About Yardnique

Yardnique specializes in community landscape design, maintenance, and preservation for property managers, HOA boards, and multifamily and residential developers. Yardnique protects the quality, lifestyle, and environmental standards of the communities they serve. Keep an eye out for their bright orange trucks in communities across the southeastern United States!

Key challenges

• Yardnique went through a large ERP migration to Sage Intacct which took them almost one year but they were left with no acceptable reporting solution for their business.
• Manually exported-to-Excel reports from their previous ERP took them hours of extra effort to format and present the way they wanted. Once they had their reports, they still couldn’t refresh them from Excel. It was a repetitive and highly time-consuming task to prepare reports; and Yardnique couldn’t “export formulas to Excel” from Sage Intacct either.
• Some reports were not achievable in Sage Intacct, such as the highly dynamic or scenario-based reports with data flowing through various parts.
• Rob and Tom were only a team of two responsible for producing all those reports that served 30 users. They sought the services of an outsourcing accounting company to help them deliver the consolidated financial reporting they needed for the 23 branches of their business, as they found it difficult to achieve and time-consuming to produce. However, they would only get their reports back at best in the next 24-48 hours.

Velixo as a game changer

• Plug-and-Play: Yardnique was able to successfully use Velixo functions in the Excel financial reports their business had used for more than 20 years, they had the foundations and were able keep the same formatting and layouts but also improve their reporting.
• Excel flexibility: Yardnique’s management required well-formatted and flexible financial reports, the same type of strategic and scenario-based reports their business had used. They wanted to use Excel as they feel strongly about it as “the King of the reporting tools”.
• Automation: Once their reports were built, refreshing the data from Excel was significantly faster, no more manual export to Excel from Sage Intacct and no more extra effort reformatting everything were needed. This gave them the “Export formulas to Excel” they wanted.
• Learning Curve: Within two weeks, the Yardnique team were up and running with their Velixo reports. They went “from nothing to everything”. Rob and Tom at Yardnique were power users, they knew Excel and felt like they already knew Velixo!
• Self-Service: Yardnique went from having to rely on an outsourcing company to deal with the complexity, to owning the reports. They were also able to provide the management team with self-service tools like the ability to drilldown to transactions in real-time.
• Not just reporting: Velixo is also used for Control purposes. Yardnique uses the fast-reporting capabilities of Velixo for reconciliation purposes, to ensure that everything ties well together.
• Growing together: The Yardnique business has grown organically but also through acquisitions, and as they continue to add entities and branches, they know that new ones will simply flow through in their reports, or if any, require few extra changes.

Favorite features

• Cell-based functions: allowed them to be up-to-speed in two weeks and reused their existing Excel skills as well as their existing financial report layouts.
• Refresh button: because it is as simple as a click of a button to instantly refresh a worksheet, in real-time.
• Save without Velixo Formulas: when you export from Intacct, the spreadsheet does not include any formulas. With Velixo, Yardnique can save files without Velixo formulas and distribute them so non-Velixo users cannot see the “technical” calculations in the worksheets.
• Drilldown: enables Yardnique to analyze detailed transactions from any number, even on calculations.

Growing into functionality

Yardnique realizes there are still functionality in Velixo they are yet to take full advantage of, notably:

• Budget writeback, especially coupled with scenario-based reports.
• Journal entry writeback, to automate Performing complex allocation calculations or importing adjustments to the GL post reconciliation checks, all from within Excel in one click.

The Velixo team is looking forward to catching up with Tom and Rob again and witnessing continued positive outcomes for Yardnique.