Skip to Main Content

Ellsworth Adhesives is a global distributor and integrator specializing in supply chain logistics for specialty chemicals and equipment. They work with industrial customers for engineered assembly processes, offering adhesives, specialty chemicals, and related equipment to the manufacturing industry. With over 1,000 employees in 21 countries, the company has an annual revenue of $540M.

Before:

Challenges in Currency Translations and Report Generation

Ellsworth Adhesives’ data was spread across four ERP (enterprise resource planning) systems, making it difficult for leaders to understand their cash flows. As a global distributor of products, Ellsworth dealt with 16 different currencies and 31 distribution centers, but they relied on Excel to import their trial balances manually into a consolidating platform. These variances would add up to large, time-consuming tasks for the team. Read-time exchange rate data was extremely time-consuming as well due to the diverse range of product offerings, and as a result, currency exchange rate translations were slow.

Once Ellsworth handled exchange rates, they moved to eliminations. A wrong entry would mean going through the strenuous process all over again, requiring an additional three people and eight days to create a report. Making matters worse, the consolidation platform had no security features, which meant if the data was reloaded without prior communication, the results for the workbook would change. This would lead to ever-varying data, making generating reports difficult.

Each business workbook had 50-60 different tabs on it, based on the business unit’s size and how many balance sheet accounts they were using. Corporate would review the reconciled data quarterly, on a rotating schedule to ensure they were accurate. Ensuring the accuracy of basic numbers was another manual task that Ellsworth did not need. Something needed to change.

Solution:

Collaborative Partnership to Easily Obtain Additional Capabilities

Ellsworth Adhesives partnered with Spaulding Ridge to build a modernized finance system in OneStream that corrected the roadblocks they were facing. Spaulding Ridge helped Ellsworth to streamline consolidations through automated direct connections from Ellsworth’s four ERP systems to OneStream. With accurate data pulled directly from the source, Ellsworth could now generate yearly, quarterly, and monthly reports instantaneously.

Spaulding Ridge also implemented our Dynamic Cash Flow solution that provides real-time insights and advanced forecasting capabilities. With this, Ellsworth is now able to gain visibility into each business unit entry and fix any asset transfer mismatch. Ellsworth is also able to restrict data entries or lock a specified period to stop data from being changed during that time.

We configured a driver-based planning and specialty planning system to accelerate FP&A processes for Ellsworth. They can reverse-populate data and understand the impact it has on their business. We also incorporated automated intercompany eliminations, cash flow reporting, USD overrides related to investment in subsidiaries, and eliminated exchange rate issues, leading to better processes for the Ellsworth team. As the market shifts, Ellsworth now has the flexibility to generate real-time forecasts that are adaptable to varying scenarios based on key metric projections.

After:

A Harmonizing and Automated Workflow, Eliminating Headaches

Ellsworth’s greatest impact from leveraging the OneStream platform has been the reduction in manual work, leading to time saved and error-free outcomes. After the implementation, Ellsworth has been able to eliminate five days out of the close process, three days in cash flow reporting, and two days in constant currency reporting. Ellsworth has also expedited acquisition reporting, constant currency, variance reporting, and cash flow reporting—all based on accurate, real-time information from across the business through Spaulding Ridge’s Dynamic Cash Flow Solution.

 Start your journey