Hartco bids adieu to Excel with new consolidation tool

More time to analyze the numbers, and less time to generate them. That’s the key take-away Hartco Income Fund is hoping for with its implementation of financial intelligence applications from SAS Canada.

Based in Anjou, Quebec, Hartco is an information technology solutions provider across a variety of channels, from the public and private sectors to the consumer market through its CompuSmart retail brand. With the company’s conversion to an income fund in 2005, CFO Carl Gauvreau said it was more important than ever for Hartco to consolidate and automate its approach to budgeting, planning and consolidation.

Hartco had been relying on Microsoft Excel spreadsheets, which Gauvreau said was a very manual process — taking a lot of time to process the numbers each month, enter them into the spreadsheets and produce a financial statement. Once that was done, he said there wasn’t much time left to really analyze the data and use it for making meaningful business decisions.

“Because we’re now an income fund we need to provide monthly cash distributions to our unit holders, and obviously this requires that our forecasting system be a little more accurate,” said Gauvreau.

While Hartco looked at five or six major vendors, including Cognos, OutlookSoft and Microsoft’s Great Plains offering, Gauvreau said it settled on the budgeting and forecasting applications from SAS. This is primarily because of the integrated budgeting and forecasting applications, and the ability to get both a consolidated view and a more granular one into each of its operating entities.

“The consolidated view is always interesting,” said Gauvreau. “But if you’re able to understand exactly where the contribution of each business comes from, and how they contribute to the total, that is of much more value to us.”

He added that the option to easily integrate additional SAS applications in the future, such as CRM and merchandising analysis tools, was also an advantage.

Hartco began the implementation of the SAS system in September, is currently working on the definition of their model, and Gauvreau said they hope to be up and running in November. Probably the biggest hoped-for benefit, he said, is being able to highlight and respond to key business issues more quickly, particularly between Hartco’s different business groups.

Roger Shears, director of financial intelligence practice with SAS Canada, said the integrated nature of the SAS offerings that appealed to Hartco is one of its differentiators. The budgeting and forecasting applications are built on the SAS 9 platform, which allows for more seamless integration and makes it easier to add on additional capabilities, he said.

“Our ability to use the platform for the data integration and consistency of the acquisition and cleansing of data has been seen as a real positive,” said Shears.

QuickLink 061450

Would you recommend this article?


Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.

Jim Love, Chief Content Officer, IT World Canada

Featured Download

Jeff Jedras
Jeff Jedras
As an assistant editor at IT World Canada, Jeff Jedras contributes primarily to CDN and ITBusiness.ca, covering the reseller channel and the small and medium-sized business space.

Featured Articles

ADaPT connects employers with highly skilled young workers

Help wanted. That’s what many tech companies across Canada are saying, and research shows...

Unlocking Transformation: IoT and Generative AI Powered by Cloud

Amidst economic fluctuations and disruptive forces, Canadian businesses are steering through uncharted waters. To...

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now