Managing the reporting requirements for a conglomerate company can be a daunting and overwhelming task, as there are many moving and ever-changing factors. It is essential that conglomerate companies incorporate modern financial applications so that Group Finance can produce effective and accurate work and keep all independent businesses operating smoothly.

Wesfarmers comprises some of Australia’s most notable retailers such as Target, Bunnings, and Kmart, who each have their own form of self-governance and enterprise reporting methods. The company’s existing financial management system, could not efficiently manage their enterprise reporting, which encouraged their Finance team to heavily rely on offline spreadsheets. A change to their financial reporting system was prioritized, and the company’s leadership knew that the sooner it found a solution for Group Finance, the quicker the Finance team could optimize the software to their needs. Read on to learn about Wesfarmers’ finance transformation journey and the successes they have seen by replacing their existing finance management system and offline spreadsheets with OneStream.

Founded in 1914 and headquartered in Perth, Australia, Wesfarmers has operated Australian businesses that sell merchandise such as office supplies, fertilizer, and energy. Wesfarmers is known as one of the most successful and influential businesses to come out of Australia, ranking at 195 on the Fortune Global 500 and having over 100,000 employees. It has also had ample financial success, as its 2021 annual revenue was 33.94 billion Australian dollars, an increase of 43.5% from the previous year.

A Modern CPM Solution is Realized

Wesfarmers needed a solution for Group Finance that would be capable of handling non-standardised data outputs and inputs, streamlining data collection, managing complex consolidations, and handling advanced group reporting. Wesfarmers utilized Oracle’s Hyperion Financial Management (HFM) suite as part of the financial reporting process, but frequent reporting requirement changes were often through offline spreadsheets. Further, the situation became even more problematic when it was announced by Oracle that the version of HFM they were using would cease to be supported after December 2021.

Therefore, Wesfarmers sought a new system for Group Finance, prioritizing reliability, safety, and utility in their search. Representatives engaged in discourse with possible candidates such as CCH Tagetik, and Oracle. Still, they became mainly intrigued with OneStream’s Intelligent Finance platform after learning about it from consultants at Taysols, a prominent Australian service provider and partner of OneStream. OneStream’s platform provided a solid foundation against which the financial reporting process was significantly improved, as it allows conglomerate companies to efficiently address group reporting and monitor group performance data. After coming to an agreement with Wesfarmers, Taysols aided in the company’s transition from their Oracle HFM system to OneStream.

All-in-one Financial Solution

Wesfarmers immediately recognized benefits from partnering with OneStream, as group reporting became mainly automated, consolidation processes were significantly improved and their group reporting pipeline was modernized. The demand for spreadsheets diminished.

Following the implementation of OneStream, Wesfarmers’ senior executives could receive answers to their questions in minutes, rather than days. The outdated approach to the presentation of information was also replaced with modern and streamlined dashboards and reports.

OneStream provided Wesfarmers staff with detailed monthly progress reports concerning its subsidiaries. Previously, Wesfarmers’ subsidiary reports were audited in hundreds of offline spreadsheets; reports under OneStream are audited in the cloud.

Partnering with OneStream armed Wesfarmers with an all-in-one financial solution. Tedious manual processes became automated, data management became more organized, financial analytics were presented with more intricate details, and subsidiary performance reporting was simplified. Group Finance has never been easier for company leaders under OneStream.

Learn More

To learn more about Wesfarmers’ unique OneStream journey, we invite you to read their Customer Success Story. And if your organization is ready to begin your finance transformation journey, contact OneStream today!

Download the Case Study

The collection of quality data is the most important aspect of Environmental, Social, and Governance (ESG) reporting.  Why is that?  Well, the number of data sources is typically far greater for such reporting than in even the financial reporting process.  The difference stems from ESG reporting involving many different aspects, such as reporting on health & safety, fuel usage, property management, waste management, and more.  How do organisations collect all this data?  Despite technology improvements in large organisations over the years, most organisations have a multitude of operational systems from which to extract this data, which makes data collection for ESG quite challenging.

Why Data Collection and Quality Controls Matter

For ESG reporting to be fully effective, the data collection and quality controls must be built-in and use the same rigor as with financial data.  The external image of an organisation is at stake here, leaving no room for second-rate capabilities.

If your role is to sign off on the ESG reporting of your organisation, then ensure you’ve fully aligned your financial and ESG reporting into a single, governed process.  You’ll also want to ensure that the capability for collecting quality data is the best available.  Ultimately, whatever process and system work for accurate financial reporting can and should also be applied to ESG reporting.

How ESG Reporting Became Mainstream

Several reporting compliance changes moved ESG significantly up the priority list for many leadership teams globally.  Specifically, Europe enacted the 2021 Sustainable Finance Disclosure Regulation (SFDR), and the U.S. Securities and Exchange Commission (SEC) released its long-awaited proposals for climate disclosures for U.S. public companies.  Why do these changes matter?

Simply put, organisations can no longer rely on volunteering the more positive aspects of their sustainable compliance or on publicising specific actions or donations.  Today, an increasing level of socially and environmentally responsible investment activity involves assessing performance metrics beyond just the financial returns.  Such assessments answer the demand for evidence of sustainable processes, practices, and management.

Fuelling that demand is climate change, which is forcing organisations and people to think and act differently, to be more interested in and concerned about how communities are impacted.  Meanwhile, communities are focusing ever more heavily on what their neighbors and favourite brands are doing.  These factors are collectively – and increasingly – pushing organisations towards ethical reporting standards.

Selecting the right system and capability is imperative to meeting those standards.

Why Built-in Data Quality Is Essential

At its core, a fully integrated CPM software platform with built-in financial data quality (see Figure 1) is critical to organisations being able to drive effective transformation across Finance and Lines of Business.  A key requirement is providing 100% visibility from reports to data sources – meaning all financial and operational data must be clearly visible and easily accessible.

Why is this visibility so important?  When organisations collect data from multiple underlying systems and then complete multiple calculations and consolidation steps, full transparency provides uses and auditors the connections between the source data and the final reported data, including for all transformations, adjustments, and eliminations.

ESG OneStream
Figure 1: Built-In Financial Data Quality Management in OneStream

The solution should also include guided workflows to protect business users from complexity by guiding them uniquely through all data management, verification, analysis, certification, and locking processes.  Are these workflows critical?  Absolutely!  The major challenge with ESG reporting is simply the number of data sources to collect from and the sheer volume of requests within an organisation for this kind of data.  Using disparate systems, that collection can take many hours or days.  Having a unified system with the capability to guide users easily through the tasks, however, will save time and money.

Most important is the system’s ability to validate and transform data to ensure complete and accurate ESG information.  When so many different source systems are involved, along with multiple spreadsheets, the system must be able to fill in missing data fields, align analysis and ensure commonality in data before the information appears on reports.  For example, if a typo occurs during a manual data entry, the system should flag any value that seems out of place given the parameters of the company.

Data quality matters for several key reasons, as shown by research.  According to Gartner,[1] poor data quality costs organisations an average of $12.9 million annually.  Those costs accumulate not only from the wasted resource time in financial and operational processes but also – and even more importantly – from missed revenue opportunities.  Interested stakeholders closely review every fine detail an organisation publishes.  Any errors or omissions will therefore be quickly spotted, and the consequences could be severe.

ESG

For instance, poor ESG metrics can make it difficult to attract valuable investment as liabilities are considered too high.  One major concern for organisations today is attracting talent – which can also be affected by ESG metrics because people are becoming more selective about who they work for and with.

ESG reporting now, perhaps more than ever, has a significant impact on the profitability and bottom line of an organisation.  And as the global standards converge into a clearer position, organisations must bring ESG reporting together in a unified way.

Why a Unified Approach Makes a Difference

There is now a compelling argument to transition from a connected to a fully unified CPM platform for ESG reporting, financial close, consolidation, reporting, planning, and more.  What’s the difference?  With a unified CPM platform, all processes are handled within a single application and instance.  Plus, data is loaded into one central database and immediately made available to all business processes, which means there are no manual data movements or reconciliations to perform.

Here are just some of the benefits that come from a unified platform:

  1. One software solution, one application for consolidation, planning, and ESG/financial reporting needs across an entire organisation with extensibility to handle future growth and change – one single controlling team, one single audit.
  2. Performance improvements thanks to control, consistency, and overall process visibility.
  3. Lower cost of ownership from replacing multiple software packages and integration points with one unified platform.

Many of the ESG reporting solutions in the market are focused on only a specific aspect of ESG, such as environmental, health, and safety (EH&S) compliance, but aren’t suited to the broader requirements of setting ESG goals and targets, tracking progress against targets and modeling the impact of ESG initiatives on future financial results.

How OneStream Delivers

OneStream’s unified, Intelligent Finance Platform (see Figure 2) with built-in reporting and analytics eliminates the complexity of fragmented ESG reporting tools.  With a strong foundation in financial data quality, OneStream allows organisations to integrate and validate large volumes of non-financial data (e.g., ESG metrics and conversion factors) with validation from any number of sources.  Confident decisions can then be based on accurate and trusted financial and operating results.

OneStream’s financial data quality management is not a module or separate product.  Instead, the management is built into the core of the OneStream platform — providing strict controls to deliver the confidence and reliability needed to ensure quality data.

ESG OneStream
Figure 2: OneStream’s Intelligent Finance Platform

 

OneStream can quickly aggregate and consolidate ESG data submissions to provide company-wide results.  With OneStream, ESG data is consolidated according to the same principles as financial data. Calculations and eliminations based on specific data values and fuel and energy consumption conversions can also be automated.  Essentially, OneStream “future-proofs” CPM and ESG reporting to ensure compliance when new standards come along.  How?  OneStream allows for unlimited configurable dimensions and hierarchies – ensuring support for GRI, SASB, and other frameworks which may emerge as required.

By intelligently aligning detailed operational and financial data, OneStream’s flexible reporting and analysis capabilities (see Figure 3) eliminate the need for Finance teams to waste time manually copying and reconciling data and creating reports.  In other words, OneStream unleashes Finance teams to focus on providing insights and analysis that better support key decisions.

 

ESG Analysis

Figure 3: OneStream ESG Analysis Dashboard

 

As a unified platform, OneStream can enable organisations to plan and forecast ESG initiatives with confidence and without compromise.  ESG goals and objectives can be set, and users can track actuals vs. targets and provide variance analysis & commentary.  What-if scenario modeling is also available to understand the ultimate impact of ESG policies on financial results and business value.

Effective ESG reporting ultimately allows investors to gauge an organisation’s intentions and actions – from how the organisation treats people to how board decisions are made or whether environmental factors are being prioritised.  To achieve meaningful targets, companies must therefore have the right ESG solution to drive performance.

Learn More

To learn more, visit our ESG Webpage, download our solution brief or check out the other blog articles in our ESG series.  Contact OneStream if your organisation is ready to align ESG reporting with financial reporting, and get ahead of upcoming disclosure mandates.

Download the Solution Brief

 

Financial reporting is an essential function of any Finance organization.  It provides stakeholders with a snapshot of the financial results and financial position of the enterprise.  You may think that financial reporting is mainly a function of the Accounting group within the Office of Finance, however financial reporting and the related analysis of financial results is an important function of most Financial Planning & Analysis (FP&A) departments.  Financial reporting capabilities are also an important feature to evaluate when selecting a software package to support FP&A as well as the Accounting team.  Read on to learn more.

What is Financial Reporting?

Financial reporting refers to processes and practices that provide stakeholders an accurate depiction of the finances of an enterprise, including its revenues, expenses, profits, capital, and cash flow. The enterprise could be a private or public company, non-profit, government agency, higher education institution, or other organization.

The primary financial statements that are produced through the financial reporting process include the following:

Key Stakeholders and Their Requirements

Financial reporting needs to inform and serve the needs of a variety of stakeholders.  This can include external stakeholders such as investors, owners, bankers, public markets, regulators, and boards of directors – who all need to understand the financial performance of the enterprise to guide investment decisions, levy taxes, ensure compliance, and provide advice to executive management.

External stakeholders are typically most interested in the key financial statements mentioned in the prior section, as well as supporting details, schedules, and commentary (e.g., management discussion and analysis) about the financial performance of the enterprise.

Financial reports are also essential tools for informing internal stakeholders about the financial performance of the enterprise.  This can include the CEO, CFO, and senior management team, as well as managers across the enterprise who need to understand how their particular subsidiary, department, business unit, or function is performing in relation to the overall enterprise.  Internal stakeholders are typically most interested in the consolidated income statement of the enterprise, as well as profit and loss reports for their specific area of responsibility.  This is where financial reporting expands to include financial analysis.  This financial analysis delivered as part of internal management reporting may include the following:

Interactive Executive Dashboard
Figure 1 – Interactive Executive Dashboard

The form these internal financial management reports may take can vary based on the preferences of the internal stakeholders.  Some may prefer printed financial reports or books of reports.  Some may prefer electronic access to financial reports via email delivery, while others may prefer to review financial results through an interactive dashboard (see figure 1), with the ability to drill into key performance indicators (KPIs) or values on financial reports. Financial and operational analysts may prefer to have access to financial and operational results via an Excel spreadsheet so they can slice and dice the data and perform scenario analysis as needed.

The Financial Reporting Gap

Given the demanding requirements of internal stakeholders when it comes to financial reporting and analysis, you might be wondering how well enterprises are doing in meeting the needs of this audience.  Unfortunately, despite the explosion of data across organizations, many organizations still struggle to meet the information requirements of executives and managers because they just don’t have the right tools for the job.

In fact, according to the FSN Future of Analytics in the Finance Function survey from 2020, only 14% of Finance leaders consider their reporting and analytics insightful.  That means 86% of reporting and analytic effort is missing the mark.  Why is this?  Because most enterprises are relying on fragmented silos of spreadsheets, legacy ERP and corporate performance management (CPM) software, data lakes, and BI tool for their reporting needs, which force Finance teams to build disjointed processes around their technology and are not organized in a way they understand.

Reporting and Analytics in CPM Software

Today’s modern CPM software solutions offer a number of advantages over legacy CPM solutions.  They are most often deployed in the cloud enabling faster time to benefit.  They offer specific functionality designed to address the financial close, consolidation, planning, reporting, and analysis needs of enterprises.  And most include robust, built-in reporting and analysis capabilities.  If this isn’t part of the CPM solution you are selecting, then you’ll need to augment the solution with 3rd party BI and reporting tools.

OneStream’s Intelligent Finance Platform
Figure 2 – OneStream’s Intelligent Finance Platform

For example, with a broad range of reporting and analytics capabilities, OneStream helps reduce reliance on spreadsheets and fragmented reporting tools to increase the speed, scope, and accuracy of reporting across the organization. OneStream’s Intelligent Finance Platform (see figure 2) unifies finance processes across the office of the CFO while enabling the organization with self-service, easy-to-use financial reporting software for a variety of stakeholder groups. OneStream’s reporting and analysis capabilities include the following:

Learn More

Financial reporting is an essential function for both Accounting and FP&A functions, and these capabilities are an important factor to consider when enterprises are evaluating CPM solutions for financial close, consolidation, planning, and forecasting.

Over 1,000 enterprises have chosen OneStream’s unified Intelligent Finance platform to support their financial close, consolidation, planning, reporting, and analysis requirements and to deliver timely, accurate financial and operational results to internal and external stakeholders.  To learn more, check out our interactive eBook and contact OneStream if we can be of assistance.

Download the e-Book

Today, confidence in data quality is needed more than ever.  Executives must constantly respond to a multitude of changes and be provided with accurate and timely data to make the right decisions on what actions to take.  It’s, therefore, more critical than ever that organisations have a clear strategy for ongoing financial data quality management (FDQM).  Why?  Well, better outcomes result from better decisions.  And high-quality data gives organisations the confidence needed to get it right.  This confidence in data then ultimately drives better performance and reduces risk.

Why Is Data Quality Important?

Data quality matters for several key reasons, as shown by research.  According to Gartner,[1] poor data quality costs organisations an average of $12.9 million annually.  Those costs accumulate not only from the wasted resource time in financial and operational processes but also – and even more importantly – from missed revenue opportunities.

As organisations turn to better technology to help drive better future direction, the emphasis placed on financial data quality management in enterprise systems has only increased.  Gartner also predicted that, by 2022, 70% of organisations would rigorously track data quality levels via metrics, improving quality by 60% to significantly reduce operational risks and costs.

In a report on closing the data–value gap, Accenture[2] said that “without trust in data, organisations can’t build a strong data foundation”.  Only one-third of firms, according to the report, trust their data enough to use it effectively and derive value from it.

In short, the importance of data quality is becoming increasingly clearer to many organisations – creating a compelling case for a change in financial reporting software evaluations.  There’s now real momentum to break down the historic barriers and move forward with renewed confidence.

Breaking Down the Barriers to Data Quality

Financial data quality management has been difficult, if not virtually impossible to achieve for many organisations.  Why?  Well, in many cases, legacy corporate performance management (CPM) and ERP systems were simply not built to work together naturally and instead tended to remain separate as siloed applications, each with their own purpose.  Little or no connectivity exists between the systems, so users are often forced to resort to manually retrieving data from one system, manually transforming the data, and then loading it into another system – which requires significant time and risks lower quality data.

There’s also often a lack of front-office controls that leads to a host of issues:

All of that contributes to significant barriers to ensuring good data quality.  Here are the top 3 barriers:

  1. Multiple disconnected systems – Multiple systems and siloed applications make it difficult to merge, aggregate, and standardise data in a timely manner.  Individual systems are added at different times, often using different technology and different dimensional structures.
  2. Poor quality data – Data in source systems is often incomplete, inconsistent, or out of date.  Plus, many integration methods simply copy data complete with any existing errors – lacking any validations or governance.
  3. Executive buy-in – Failing to get executive buy-in could be due to perception or approach.  After all, an effective data quality strategy requires focus and investment.  With so many competing projects in any organisation, the case for a strategy must be compelling and effectively demonstrate the value that data quality can deliver.

Yet even when such barriers are acknowledged, getting the Finance and Operations teams to give up their financial reporting software tools and traditional ways of working can be extremely challenging.  The barriers, however, are often not as difficult to surmount as some believe.

The solution may be as simple as demonstrating how much time can be saved by transitioning to newer tools and technology.  Via such transitions, reducing the time investment can result in a dramatic improvement in the quality of the data through effective integration with both validation and control built into the system itself.

The Solution

There are some who believe Pareto’s law applies to data quality: Typically, 20% of data enables 80% of use cases.  It is therefore critical that an organisation follows these 3 steps before embarking on any project to improve financial data quality:

  1. Define quality – Determine what quality means to the organisation, agree on the definition, and set metrics to achieve the level with which everyone will feel confident.
  2. Streamline collection of data – Ensure the number of disparate systems is minimised and the integrations use world-class technology with consistency to the data collection processes.
  3. Identify the importance of data – Know which data is the most critical for the organisation and start there – with the 20%.  Then move on when the organisation is ready.

At its core, a fully integrated CPM software platform with built-in financial data quality (see Figure 1) is critical for organisations to drive effective transformation across Finance and Lines of Business.  A key requirement is providing 100% visibility from reports to data sources – meaning all financial and operational data must be clearly visible and easily accessible.  Key financial processes should be automated and using a single interface would mean the enterprise can utilise its core financial and operational data with full integration to all ERPs and other systems.

Figure 1: Built-In Financial Data Quality Management in OneStream

The solution should also include guided workflows to protect business users from complexity by guiding them uniquely through all data management, verification, analysis, certification, and locking processes.

OneStream offers all of that and more.  With a strong foundation in financial data quality, OneStream allows organisations to integrate and validate data from multiple sources and make confident decisions based on accurate financial and operating results.  OneStream’s financial data quality management is not a module or separate product but built into the core of the OneStream platform — providing strict controls to deliver the confidence and reliability needed to ensure quality data.

In our e-book on Financial Data Quality Management, we shared the following 3 goals for effective financial data quality management with CPM:

  1. Simplify data integration – Direct integration to any open GL/ERP system and empower users to drill-back and drill-through to source data.
  2. Improve data integrity – Powerful pre-data and post-data loading validations and confirmations ensure the right data is available at every step in the process.
  3. Increase transparency – 100% transparency and audit trails for data, metadata, and process change visibility from report to source.

Delivering 100% Customer Success

Here’s one example of an organization that has streamlined data collection and improved data quality in the financial close, consolidation, and reporting process leveraging OneStream’s unified platform.

MEC Holding GmbH – headquartered in Bad Soden, Germany – manufactures and supplies industrial welding consumables and services, cutting systems, and medical instruments for OEMs in Germany and internationally.  The company operates through three units: Castolin Eutectic Systems, Messer Cutting Systems, and BIT Analytical Instruments.

MEC has 36 countries reporting monthly, including over 70 entities and 15 local currencies, so the financial consolidation and reporting process includes a high volume of intercompany activity.  With OneStream, data collection is now much easier with Guided Workflows leading users through their tasks.  Users upload trial balances on their own vs. sending to corporate, which speeds the process and ensures data quality.  Plus, the new system was very easy for users to learn and adopt with limited training.

MEC found that the confidence from having ‘one version of the truth’ is entirely possible with OneStream.

Learn More

If your Finance organisation is being hindered from unleashing its true value, maybe it’s time to evaluate your internal systems and processes and start identifying areas for improvement.  To learn how read our whitepaper on Conquering Complexity in the Financial Close.

Download the White Paper

In a previous blog article, I highlighted the increasing buzz in the market in the past 12 months around the topic of environmental, social, and governance (ESG) reporting and why CFOs and Finance teams are paying more attention to it.  In this article, I’ll highlight why a growing number of organizations are leveraging OneStream to align their ESG reporting with their financial reporting and broader corporate performance management (CPM) processes, and the value that delivers.

ESG Reporting in Focus for CFOs

ESG reporting (a.k.a. Sustainability Reporting) refers to the disclosure of data covering a company’s operations in three areas: environmental, social, and corporate governance. It provides a snapshot of the business’s impact in these three areas for investors, customers, and wider stakeholders. The value of ESG reporting is that it ensures organizations consider their impacts on sustainability issues and enables them to be transparent about the risks and opportunities they face.

For many years, ESG reporting was an annual, voluntary disclosure by public and private companies to their stakeholders about the impacts of their enterprise on the environment and society and how they are managing these programs.  With an increasing amount of capital (now roughly $35 Trillion) flowing into “sustainable” mutual funds and ETFs, there is increasing stakeholder interest in ESG reporting and increasing demand for more detailed and frequent disclosures from public and private enterprises.

As a result, corporate sustainability and climate change efforts are fast transitioning from voluntary to mandatory in many countries, and even the US SEC is moving towards defining clear disclosure guidelines for public companies.  Based on this inertia, there is a clear driver for companies to develop robust sustainability and ESG strategies with transparent reporting to stakeholders.  And this is one of the primary reasons ESG reporting is becoming a hot topic for CFOs and Finance teams.

Aligning ESG Reporting with Financial Reporting

As ESG reporting transitions from voluntary to mandatory it will require the same level of governance, control, accuracy, and auditability as financial reporting.  And since CFOs and Finance teams fully understand how to drive control and accuracy in financial reporting, they are best suited to overseeing the collection, consolidation, and reporting of ESG and data alongside financial results.

While ESG reporting is quickly becoming mandatory, meeting an organization’s sustainability objectives will require a management process that’s similar to the corporate performance management (CPM) process that Finance teams employ to help them meet their financial objectives.  This process includes goal setting, planning, monitoring and reporting, and analyzing results to track progress and make adjustments as needed to stay on track.

As stated by Accenture in a recent survey report on ESG reporting, “Meeting demands for sustainability data will be integral to company performance.  Making a CFO responsible for sustainability is essential for ensuring a company meets its ESG goals.  Companies are much more likely to extensively embed ESG in core management processes when the CFO has accountability for ESG metrics.”

Aligning ESG with Financial Reporting and CPM

While many organizations manage ESG reporting via spreadsheets or point applications, both of these approaches create a data collection, consolidation, and reporting process that’s separate from the financial reporting process. And if ESG metrics need to be reported alongside financial metrics, wouldn’t it be better if this data was collected in the same system and processed as financial data?

The answer is yes, and that’s why a growing number of OneStream customers are extending the usage of our unified, CPM software platform to support their ESG reporting and management requirements.  OneStream’s platform provides several key capabilities that make it a great fit for ESG reporting.  These include the following:

Financial Data Quality:  OneStream can load and validate large volumes of financial and non-financial data such as GHG emissions, water and electricity usage with validations and out-of-the-box drill-down and drill-back capabilities to source data providing ultimate auditability.  OneStream can connect to any source of ESG data as required such as ERP, CRM, HR systems, and internal data warehouses.   The platform can also collect data via flat files, spreadsheets, or data entry forms.

Guided Workflow: OneStream allows customers to design the user experience around the process and apply controls, validation, and governance on ESG data collection, managing the monthly, quarterly, and yearly tasks together.  Customers can also leverage the OneStream Task Manager solution to manage and orchestrate the process further and enable email notifications.

Financial Consolidation:  OneStream can aggregate and consolidate ESG data and textual commentary quickly to provide company-wide results.  With OneStream, your ESG data is consolidated according to the same principles as your financial data, and with the same level of control, governance, and audit trails.  Complex ESG data conversions are supported, along with eliminations and partial ownership calculations. Customers can future-proof their CPM solution to support new standards with unlimited configurable dimensions and hierarchies – supporting GRI, SASB, and other frameworks as required.

Reporting & Analytics:  In addition to financial and management reports, configurable dashboard visualizations (see figure 1) can provide deep analysis of ESG data and turn it into valuable information and insights.  OneStream also supports ad hoc analysis via Microsoft Excel integration, a built-in spreadsheet component, and pivot grids.  Integration with MS Office products enables users to produce and distribute PowerPoint decks, Word Docs, and PDFs with ease.  Data Blending supports reporting and analysis on high volumes of non-financial data.

Planning and Forecasting:  Customers can plan and forecast on ESG with confidence and without compromise. They can set ESG goals and objectives, track Actuals v Target, and provide variance analysis & commentary.  Users can perform what-if scenario modeling to understand the impact of ESG policies on financial results and business value. OneStream supports unlimited extensible data models for any ESG planning process.

GIntelligent-Finance-Platform
Figure 1 – ESG Dashboard Visualizations/figcaption>

Based on these capabilities, OneStream’s platform is well-suited to supporting the collection, consolidation and reporting of ESG data and commentary for internal and external reporting. Much of the emissions data can be found in the local ERP systems and sub-ledgers. For example, energy bills, water consumption, fuel usage is all available on the invoices in the ERP data.  But the formatting, units, etc., are likely all different and there are many other offline or manual data collection processes that need to happen to bring everything together and holistically report on ESG initiatives.

Customers Leading the Way

OneStream has several customers that are already using our platform to collect, consolidate and report ESG data.  One example is a CPG holding company that has grown organically and via acquisitions of many food providers.  When they acquire companies, they let them keep their existing ERP systems as they are all manufacturing companies.  As a result, they have over 50 different GL/ERPs at 100+ locations.

This organization had been collecting data for financial and ESG reporting via spreadsheets and email, so it was highly manual, time-consuming, and prone to errors. They selected OneStream (see figure 2) to collect, consolidate and report their financial and non-financial/ESG data.

GIntelligent-Finance-Platform
Figure 2 – OneStream’s Unified, Intelligent Finance Platform

With OneStream the organization now has one system for actuals, budgets, quarterly forecasts, ESG reporting, weekly operations data, and M&A analysis. Having a single system and process saves time and reduces redundancy in data collection.  Subsidiaries provide a single submission for financial and ESG reporting.  The company has eliminated errors in data collection by using data entry forms with validation checks for key environmental and social metrics.

Conclusion

ESG and Sustainability reporting is rapidly moving from a voluntary to mandatory process.  CFOs and Finance teams need to get engaged to ensure the accuracy and integrity of ESG and sustainability reporting to a variety of stakeholders.  Aligning ESG reporting with the financial reporting and performance management process and system can eliminate duplication, increase accuracy, ensure compliance and improve the overall management of ESG initiatives.

To learn more, register for OneStream Splash 2022 where several partners and customers will share their experiences in aligning ESG reporting with financial reporting and the benefits they have achieved. Or contact OneStream if your organization is ready to align ESG reporting with financial reporting and get ahead of upcoming disclosure mandates.

Register For Splash

When it comes to corporate performance management (CPM), distilled down to the simplest terms, Finance has three basic roles to fulfill in its support for the organisation:

  1. Looking backward with processes such as the financial close and consolidation to produce an accurate book-of-record income statement and balance sheet to represent an organisation’s financial position.
  2. Looking forward to planning and forecasting to empower decision-makers with insights to support faster and more informed decision-making for the next month, quarter, and beyond.
  3. Providing right-time guidance for daily and weekly financial and operational decisions across the enterprise to drive organisational performance before month- or quarter-end.

Binding all three roles together, of course, facilitates effective financial reporting and operational management reporting.  Why does this matter?  Well, for all the reporting and analysis to be impactful and well understood, it first must be communicated to stakeholders in a timely, clear and actionable format.

Organisations now need to move forward with their finance and operational reporting to drive the increasing levels of agile decision-making expected.  It is time to kick old, inefficient processes to the curb.  Move away from the limitations of fragmented tools and truly deliver effective reporting from a unified, intelligent finance platform.

Limitations of Fragmented Reporting Tools

Many Finance teams struggle to meet varying stakeholder reporting needs.  Why?  Mainly it’s because such Finance teams rely on a fragmented mix of reporting tools – such as siloed spreadsheets, legacy CPM software, and stand-alone BI tools.  Doing so means Finance teams must invest an inordinate amount of time and manual effort to not only copy and paste data but also then reconcile and format reports.

Ad-hoc reporting is also frustrating for Finance and Line-of-Business (LOB) managers who require accurate information to make effective business decisions.  Finance teams must often choose whether to provide business partners with the training and access to yet another fragmented tool or to take the time to produce new reports on an as-needed basis.

Either way, the burden falls on Finance.

Effective Performance Reporting

To realise their full potential as strategic business partners, Finance leaders of sophisticated organisations require reporting capabilities that are aligned with their CPM processes but address the variety of stakeholder reporting needs.  OneStream achieves all of that – empowering Finance to lead at speed with a single lens across the organisation while providing a single source of the truth and a high level of financial data quality for more effective and streamlined financial, statutory, and management reporting.

Why Is Effective Reporting Important?

OneStream simplifies both financial reporting and operational reporting by allowing users to focus on the quality and content of their data rather than constantly working through the mechanics of building reports.  Here are just a few additional benefits OneStream offers for financial reporting and analysis:

OneStream Customer Success

OneStream’s unified, Intelligent Finance Platform (see Figure 1) with built-in reporting and analytics eliminates the complexity of fragmented reporting tools.  Through built-in advanced reporting and analytic capabilities, OneStream empowers sophisticated organisations by offering a unified solution for financial close, consolidation, budgeting, planning, forecasting, reporting, analytics, and financial data quality.

Figure 1: OneStream Unified CPM Platform

By intelligently aligning detailed operational and financial data, OneStream’s flexible reporting and analysis capabilities eliminate the need for Finance teams to waste time manually copying data and creating reports.  In other words, OneStream unleashes Finance teams to focus on providing insights and analysis to better support key decisions.

Below are details about how two OneStream customers achieved significant benefits from the reporting and analytics available within our unified platform.

Crane Worldwide Logistics – Crane’s goal to remain lean and provide meaningful business insight to management was well supported by OneStream.  From a more efficient close cycle and dynamic reporting — including automated cash flow – to drastically reducing the days in the planning cycle, Crane realised a big return on their investment.  Crane is now well suited to acquire new sites or create legal entities with full confidence in OneStream’s ability to handle the integration and deliver results.

Management can rely on OneStream to deliver quick results and make real-time decisions accordingly.  “The nice thing about OneStream is that the platform has proven that our data is now correct”, said Katrina Celestine, Financial Reporting Manager at Crane.  “Everything from reconciliations to cube views, to custom reporting has been huge.  Best of all has been the drill-down functionality.  When someone asks a question about an amount, I can drill into the detail and see exactly what’s pulling into it and provide support.  With OneStream, the answer is always at your fingertips, which I really like”.

Sasfin – By implementing OneStream, Sasfin has achieved full data integration across the organisation – creating a single view of the truth.  This integration is much more than mere automation.  Rather, the integration unifies and streamlines financial processes so that the data is consistent and reliable at all times.  Because processes are more efficient, Finance teams are released to add higher value to the whole organisation.

This paradigm shift in the role of the Finance function has been the greatest benefit to Sasfin.  Where they previously poured resources into generating reports each month, the company is now empowered to apply their brainpower to analyze the information coming through the reports.

Drive Performance with Built-in Reporting & Analytics

The Finance organisation’s historical credibility in controlling financial data, metrics, analysis, and reporting gives it a unique voice of authority and trust among business leaders.  That’s why OneStream’s Intelligent Finance Platform was designed to help the Office of the CFO drive performance with a wide range of solutions across Accounting, Finance, and Operations business partners.  With OneStream, companies get built-in reporting and analytics, financial consolidation, and planning all within one unified solution.

As a result, OneStream is giving Finance leaders across the globe the ability to finally harness their data with the speed, scale, and control required to guide decision-making and drive performance —with a seamless user experience that doesn’t force Finance teams to compromise on business processes or technology.

Learn More

If your Finance organisation is being hindered from unleashing its true value, maybe it’s time to evaluate your internal systems and reporting processes and start identifying areas for improvement.  To learn more, download our e-book on Reporting & Analytics today.

Download the e-Book

For most of us, watching sci-fi films like the Avengers or the Matrix has given us a potential insight into what the future might look like.  We can, therefore, imagine what’s possible and impossible for the next generations. But, we’re also seeing big shifts in what’s possible right now.

With analytics, for instance, we’re now reaching a stage where the technology available today can examine the vast amounts of data within an organisation and begin to predict what will happen next – with high degrees of accuracy.

Advanced analytics have been around for more than 20 years.  What’s new, then?  Why are analytic tools becoming increasingly more common today? Well, the changes in technology and the ability to integrate ever-larger volumes of data into day-to-day business processes are driving increasing interest and the desire to turn the vision of advanced analytics into reality.

Advanced analytics deliver deeper data knowledge and more granular insights.  Accordingly, many more business functions now have a legitimate interest in this capability to help foster better decision-making and improved business outcomes.

Gartner describes advanced analytics across four main types of capabilities (see Figure 1), which are illustrated below:

advanced analytic
Figure 1. Gartner’s four types of capabilities in advanced analytics

The questions in Gartner’s model (Figure 1) can be a helpful guide to understanding exactly where your organisation stands regarding the adoption of these capabilities.  Most organisations have mastered the first two questions, allowing organisations to understand what happened and why.  However, many organisations do not have the capabilities in place to predict what will happen.

Is there proof of this?  Yes.  According to the Dresner Advisory 2021 Data Science and Machine Learning Market Study, only 39% of Finance teams are deploying the kind of technologies that enable predictions about future or otherwise unknown events today.  The number of organisations that can then use those technologies to help decide what to do next is much lower.

The Power of Advanced Analytics for Finance

With the sheer volume of data available and advancements in CPM software, Finance teams now (finally) have the capability to interact with advanced analytics.  And do it at scale.

How?  Instead of taking on the burden of building models, Finance teams can rely on purpose-built software to help supplement analysis, reporting, and planning processes with not only high-volume operational and financial signals but also statistically significant, predictive forecasts.

The following advanced analytics use cases can be found across organisations:

Through data mining, machine learning (ML), statistical modeling, and other methods, advanced analytics are making industries everywhere more competitive.

Benefits of Advanced Analytics

Advanced analytics offer Finance teams a new way to drive performance – and lead at speed.  If Finance teams spend all their time moving data, reconciling data and building reports, they’ll have no time to leverage the data to guide key decisions.  But by leveraging technology to automate the hard work, Finance teams can shift a larger portion of their time to value-driving activities, such as forecasting cash or evaluating key capital investment decisions.

Advanced analytics tools offer a more accurate and reliable means of looking into the future than many previous tools could provide.  How can that insight help organisations gain a monetary benefit?  Well, retailers can use predictive models to forecast inventory requirements.  Hotels, restaurants and other hospitality organisations can use the capability to forecast the number of guests on any given night to maximise occupancy and revenue.  Airlines frequently use predictive analytics to set ticket prices that reflect past travel trends or account for major events.

Whatever the industry, attracting and retaining customers is important to any organisation, but advanced analytics can bring the opportunity to optimise marketing campaigns to nurture customers.  In turn, new purchasing opportunities can be surfaced to deliver continuous value.

OneStream Delivers Advanced Analytics

OneStream unleashes the power of Finance by unifying planning, financial close & consolidation, reporting, and analytics through a single, extensible solution.  We empower the enterprise with financial and operational insights to support faster and more informed decision-making – all in a platform designed to continually evolve and scale with the organisation.

OneStream’s comprehensive corporate performance management (CPM) software platform helps Finance teams access, maintain, validate and visualise data – all within a seamless and unified experience.  And in doing so on both governed financial and high-velocity operational data, OneStream provides a foundation for Finance-owned transactional analysis, reporting and sharing predictive insights.  Those insights then allow organisations to find new ways to ask ‘why’.

OneStream’s advanced analytics strategy includes key capabilities to enable Finance and business leaders.  Here are a few of those capabilities:

Analytic Blend

OneStream provides a unique ability to ‘blend’ validated financial data, highly dimensional operational data, and detailed transactional data in one platform for comprehensive, controlled, and consumable analysis and visualisation.  Easily combine financial, operational, and transactional data in a single dashboard for comprehensive visualisation and analysis.  With Analytic Blend (See Figure 2), Finance maintains one source of the truth for data, extending access to line-of-business managers and executives while eliminating data latency and the unnecessary replication of financial data for analysis.

Gartner Cloud FC MQ
Figure 2 – Gartner Magic Quadrant for Cloud Financial Close Solutions 2019
Predictive Analytics

OneStream empowers Finance teams to lead at speed by unifying predictive analytics with core CPM processes: planning, budgeting, and forecasting; financial consolidation; reporting; and financial data quality.  And with built-in predictive analytics (see figure 3), OneStream is unleashing Finance transformation to take budgeting, planning, and forecasting processes even further – allowing teams to plan, analyse and predict with confidence.

Gartner Cloud FC MQ
Figure 3. OneStream Dashboard – Predictive Analytics
Machine Learning

OneStream’s sensible ML solution will provide Finance teams with the power to leverage ML models without extensive work by data scientists.  This solution will take users through a step-by-step process for each part of the ML model-building and deployment process. Including feature engineering through advanced algorithm configuration, training, and deployment.

Creating value from advanced analytics in Finance and beyond could make a significant difference to your organisation’s performance.  What if you had the power to incorporate advanced analytics directly into your day-to-day business processes?  What if you could conquer the complexity of gathering and organising financial and operational data? Or creating and maintaining predictive forecast models?  Let the right technology help you to view the possible and impossible for the future of your organisation.

Learn More

If your Finance organisation is being hindered from unleashing its true value, maybe it’s time to evaluate your internal reporting & analytics and start identifying areas for improvement.  To learn more, view the OneStream advanced analytics interactive e-book.

Read the e-Book

Anyone leading Finance in a complex organisation today is likely facing increasing pressure to focus their efforts on value creation rather than just routine accounting, control, and compliance.  And as the requirement increases for accurate and timely data to inform key decision-making, the traditional month-end financial reporting cycle is clearly a material barrier to driving performance.  According to Accounting Web in 2021, 30% of survey respondents reported taking as many as 16-19 working days to close the books.  Many Finance teams are now moving backward as data volumes increase within their organisations.  Without change, more organisations could find themselves missing reporting deadlines and suffering from late filing penalties.

Why are so many organisations struggling to report in a timely manner?

The reason is simple:  they’re relying on fragmented silos of spreadsheets, legacy corporate performance management (CPM) software, data lakes, and BI tools for their reporting needs – forcing Finance teams to build disjointed processes around disparate technology tools.  Many of these tools are not optimally implemented or organised.  When every departmental and corporate application or model must be connected or integrated, it adds significant risks, costs, and complexities to already-taxed Finance teams.

Want proof?  Just think about how much time you and your team spend manually copying and pasting information between fragmented sources and tools as opposed to analysing results and helping your business partners take action.  Does this drawn-out process sound familiar?

The good news is that there is another option.  Unifying these multiple processes and tools can provide more automation, remove the complexities of the past and meet the diverse requirements of even the most complex organisation, both today and well into the future.

A Unified CPM Solution

Having a unified CPM platform such as OneStream (see Figure 1) is now a prerequisite to streamlining year-end reporting and unleashing the value of Finance.  And to make that possible, a platform that unifies key Finance processes and provides purpose-built functionality for financial consolidation, reporting, planning, forecasting, and analysis is necessary.  A unified CPM platform integrates financial and operational data from multiple sources and provides a single version of the truth for actuals, budgets, plans, forecasts, and analytical data.

OneStream’s Intelligent Finance Platform
Figure 1: OneStream Unified CPM Platform

Along with using a unified CPM platform, here are 3 steps you can take to streamline your year-end financial reporting:

  1. Automate data load with built-in financial data quality management
  2. Remove bottlenecks in the key financial close processes
  3. Automate the production and distribution of financial reporting
Gartner Cloud FC MQ

1.   Automate data loading with built-in financial data quality management

Collecting and integrating data from multiple GL/ERP systems into a financial consolidation system can be a laborious task.  In many organisations, this data collection process is handled via flat files or spreadsheets being sent from remote locations to corporate accounting for loading into the consolidation system.  This manual process lends itself to errors that often require multiple emails or phone calls to resolve when the incoming data is incomplete or doesn’t map to the corporate chart of accounts.

By creating a direct connection between the financial consolidation system and the GL/ERP data sources, the enterprise can automate and streamline the data collection process, with exceptions being flagged and addressed quickly.

The unified CPM platform should have financial data quality management (FDQM) at its core.  This capability is critical for organisations to drive effective transformation across Finance and lines of business.  A key requirement in FDQM is 100% visibility from reports to sources – all financial and operational data must be clearly visible and easily accessible.  Key financial processes should be automated, and using a single interface means the enterprise can utilise its core financial and operational data with full integration to all ERPs and other systems.

Gartner Cloud FC MQ

2.  Remove bottlenecks in the key financial close processes

To truly become a strategic business partner, the Finance function must dramatically reduce its transactional workload within financial close processes.  Unleashing the true value of Finance requires minimising manual tasks to ensure efficiency in the following key processes (and others):

3.  Automate the production and distribution of financial and operational reports

While collecting and consolidating results often consumes most of the monthly close process, generating reports for management and external stakeholders can also consume a lot of Finance time, especially when using spreadsheets.  With a unified financial consolidation solution that includes integrated and Finance-friendly reporting tools, however, the production and distribution of management and financial reports can be largely automated.  In return, delivery is accelerated, and more time is provided for Finance to perform value-added analysis.

Having a broad range of reporting and analytics capabilities helps reduce reliance on spreadsheets and fragmented reporting tools to increase the speed, scope, and accuracy of reporting across the organisation.  It is important to unify Finance processes across the Office of the CFO while enabling the organisation with self-service, easy-to-use reporting solutions for a variety of stakeholder groups.

Streamlined Year-End Reporting Success

Organisations that replace spreadsheets, manual uploads, and automate key financial processes and reporting within OneStream’s unified, governed, and flexible CPM platform can achieve a streamlined year-end reporting process. These organisations can truly lead at speed by delivering the right information, in the right format, at the right time to drive performance and bring value.

Learn More

If your Finance organisation is being hindered from unleashing its true value, maybe it’s time to evaluate your internal systems and processes and start identifying areas for improvement.  To learn more, download our e-book on Reporting & Analytics today.

Read the e-Book

Every year, data inconsistencies cost organizations time and money as they chase the truth to support financial and operational reporting.  Aside from the immediate impact on revenue, poor data quality over the long term leads to risk from decision-making based on inaccurate data and a lack of confidence in eXtended Planning & Analysis (xP&A) processes.  Why?  Because data inconsistencies confuse people, erode trust, cause angst and lead employees to seek “answers” in the data silos they know and love.

Of course, poor financial data quality leads to more than just poor decisions and risks in financial reporting.  It also causes organizations to waste resources, miss opportunities, and spend far too much time fixing data – time that could be better spent on other areas of the business.  And all of these impacts translate into increased costs.  In fact, according to Gartner [1], poor data quality costs an organization $12.8 million per year, on average.  Even worse?  That figure doesn’t even consider the downstream implications of poor decision-making.

With the overall exponential growth of data – especially amid the rise in xP&A – the cost of poor data quality will also grow exponentially if not addressed quickly.

Understanding Why Data Consistency Matters for Financial and Operational Reporting

Whereas data redundancy occurs when the same piece of data exists in multiple places, data inconsistency occurs in different formats in various systems, which leaves an organization with the unreliable and meaningless information. Most organizations traditionally created workarounds to reduce the impact of data inconsistencies but Finance can longer support these short-sighted solutions as it transforms itself into the core entity of xP&A – providing the financial intelligence required for corporate planning, reporting, and flexible operational planning (see Figure 1).  Data consistency must therefore be maintained across the enterprise to support xP&A.

Figure 1: Source – Gartner: Market Guide for Cloud xP&A Solutions, July 2021

Most FP&A leaders agree that having valid, accurate, and usable data for financial and operational reporting is critical.  The reality, however, is that many leaders spend more time chasing data inconsistencies instead of fixing the root causes, causing a lack of trust in the data.

Here are a few real-world examples of how data inconsistencies impact xP&A processes:
Conquering Data Complexity in Financial  Operational Reporting

A fully unified corporate performance management (CPM) platform (see Figure 2) with built-in Financial Data Quality Management (FDQM) is critical for organizations to align adequate financial and operational reporting across the enterprise.  An essential requirement for any CPM software platform is 100% visibility from reports to sources – all financial and operational data must be clearly visible, accessible, traceable, and consistent.

Intelligent finance platform

Figure 2: OneStream’s Intelligent Financial Platform

Using Guided Workflow Drives Data Quality

An organization can achieve effective data consistency through standardized and simplified data collection and analysis processes with reports available at every step in the workflow.  The workflows must be guided to provide standard, defined, and repeatable processes for maximum confidence and reliability in a business-user-driven process.

In-context guided workflows protect business users from complexity by guiding them uniquely through all data management, verification, analysis, certification, and locking processes.  Here are just a few examples of how OneStream’s Guided Workflows can improve an organizations performance:

Conclusion

Deploying a program to enable data consistency is not an easy task, but the rewards are enormous.  Establishing a disciplined approach to managing data as an important enterprise asset will better position the organization to improve staff productivity and better serve customers.

With the rise of xP&A, the days of “dealing with” data inconsistencies are no longer an option, particularly in today’s volatile climate with ongoing global disruptions.  Finance leaders and analysts who want to move forward must once again have confidence their data is accurate without compromising ease of use.

With OneStream, data is consistent across all relevant business units leveraging our unified platform – reducing the drag that data inconsistencies impose on organizational performance.  Policies and technology are thus aligned, letting financial and operational leaders finally make better decisions to maximize profitability, without the fear of being blindsided by erroneous data.

Learn More

To learn more about how the unrivaled power of OneStream’s Intelligent Finance Platform can help keep your data consistent, download our Financial Data Quality Management ebook.  And don’t forget to tune in for additional posts from our Rise of xP&A blog series.

[1] Cost Optimization is Crucial for Modern Data Management Programs, Ankush Jain, Guidi De Simoni, Eric Thoo, Adam Ronthal, Melody Chien, Donald Feinberg, Ehtisham Zaidi, Sally Parker, Simon Walker, Malcolm Hawker, June 20, 2020

When put under strain, human bones have the ability to adapt to stress by rapidly deteriorating in size over time. The same could be said for organizations struggling with legacy performance management tools. Stress brought on by outdated finance applications can be felt not only by Finance teams but enterprise-wide through massive declines in process efficiency.

The leading provider of solutions for orthopedic implant procedures, Orchid Orthopedics needed to recover from the injury caused within their own Finance organization from years of using Infor and Excel®. These fragmented applications were impeding Orchid Orthopedics’ progress toward stronger financial consolidation and planning processes. Luckily, they knew that the earlier a modern finance platform was implemented, the sooner the healing process would begin, and the faster and more efficient their organization would be. Read on to learn about Orchid Orthopedics’ finance transformation journey and the successes they have seen by replacing Infor and Excel® with OneStream.

Delivering Leading Medical Device Services

Headquartered in Mason, MI, Orchid Orthopedic Solutions (Orchid) has been providing solutions for orthopedic implant procedures since 2005. Orchid is now a worldwide leader in orthopedic medical device solutions, delivering design and manufacturing services globally. Specializing in implants, single-use instruments, and innovative technologies within joint reconstruction, hips, knees, spine, trauma, extremities, and dental, Orchid holds the highest quality standards in the industry. Orchid employs approximately 2,000 employees and generating over $350M in annual revenue.

Orchid’s Pain Points

Orchid needed a platform that would provide greater visibility and optimization to support the company’s rapid development. Orchid was utilizing Infor CPM for financial consolidations and Microsoft Excel® for financial planning but was experiencing many limitations and challenges. To consolidate actuals and forecasts in Infor, the Finance team was spending nearly two hours rendering the system which, caused delays in their close and budgeting processes. The Excel® add-in feature of Infor required too much manual effort to perform ad hoc analysis and new report building was highly inefficient. On the FP&A side, the design of their system did not allow Orchid to utilize functionality for improved forecasting such as people planning, CAPEX planning, what-if scenarios, and more.

Orchid-Orthopedic-Solutions

 

So, Orchid began their search for a new CPM solution, that was innovative and practical. Orchid was most impressed by the capabilities of OneStream’s Intelligent Finance platform and the company’s well-rounded Gartner Magic Quadrant leadership placement in both financial consolidation and financial planning. OneStream’s customer references helped the Orchid team solidify their decision and they made switch from Infor to OneStream.

Finance Implants a Modern Solution

By converting to OneStream, Orchid is now equipped with a unified platform for financial consolidation, reporting, budgeting, and forecasting. Unlike Infor’s version, OneStream’s Excel® add-in function allows Orchid to easily execute ad-hoc analysis on actual data on a recurrent basis, while Guided Workflows provide enhanced visibility into the closing process.

With OneStream, Orchid is benefitting from faster consolidation times, a streamlined close process, and quicker access to results. In fact, Orchid has shortened the monthly close process by 20%-. The Orchid team now has a better understanding of monthly performance and has reduced the time it takes to compile month-end results for the management team and board by 2-3 days.

Orchid has even extended its OneStream platform to include Account Reconciliations, Task Manager, and People Planning solutions from the OneStream MarketPlace™. The Task Manager feature has provided better visibility into the status of the month-end closing process by updating owners of the process. In addition, People Planning automates the forecasting of labor costs, allowing Orchid to better manage their largest expense.

Learn More

To learn more about Orchid Orthopedics’ unique OneStream journey, we invite you to read their Customer Success Story. And if your organization is ready to begin your finance transformation journey, contact OneStream today!

 

In today’s volatile and disruptive economic environment, CFOs and Finance organisations must lead organisational decision-making processes with insight, speed and confidence.  Yet many Finance organisations are still bogged down by inefficiencies in routine processes within the period-end financial close and reporting cycle.  And that makes it difficult to shift time to value-added analysis and decision support.

Organisations that do successfully adopt modern, cloud-based solutions for financial close, consolidation and reporting have been more successful in streamlining back-office processes and driving financial performance.  And perhaps most importantly, such organisations have gained the agility required to lead at speed and adapt quickly to changing business and industry requirements.

To get there, your organisation must tackle the six key challenges which we have identified in this 2nd post of our Re-Imagining the Close blog Series.

Moving Ahead


The 6 Key Challenges for Financial Close & Reporting

Unfortunately, many close processes are simply run from memory and out of habit, often with no solid desire to improve or change the status quo.  Some organizations don’t realize there’s a better way.

Today’s post highlights the 6 key challenges many organisations face as they look to transform the financial close process.

Now is the time to identify and address each of the following 6 challenges to set your organisation on a path to real change and reimagine your financial close.

1. Ageing, Fragmented & Incomplete CPM Systems

Corporate performance management (CPM) processes supported by spreadsheets and a complex patchwork of other software can actually slow down Finance and may result in significant duplication and rework.  How?  Well, this fragmented approach to supporting close processes creates added technical complexity and administrative burden on the Finance team.  That burden includes moving and reconciling data, constantly managing metadata in multiple systems, monitoring data and managing security between fragmented products or models (see Figure 1).

Figure 1: Connected Finance Solutions – Fragmented
Figure 1: Connected Finance Solutions – Fragmented

All of these aspects dilute the ability of Finance teams to focus on driving performance and supporting critical decision-making.  These problems are only further compounded when there is a lack of key functionality to deal effectively with complex requirements, such as consolidating and eliminating inter-company balances automatically, without rules, or effectively handling alternate hierarchies without data duplication.

2. Increasingly More and More Complex Regulatory and Internal Requirements

Complexity increases the moment an organisation becomes international.  Why?  Well, the immediate requirement to handle complex ownership structures, multiple currencies, inter-company trading and other aspects across geographies and with different tax treatments can really explode the work of a Finance team.

Plus, the regulations governing how organisations report their results and comply with relevant local and industry rules only continue to increase in complexity once an organisation expands internationally.  Add to that the short filing timeframes given to organisations, and it becomes clear that robust and efficient systems and processes are the order of the day.  In the US, for example, Section 409 of the Sarbanes-Oxley (SOX) Act requires that public companies report any material events that result in a change in the company’s financial condition within four days of the event.  The deadline for the filing of the 10-Q (quarterly report) was also recently amended to 40 days after quarter end from 45 days.

Such regulatory requirements are pushing the office of the CFO towards not only faster closing and reporting but also the injection of more regular insights into financial results.

3. The Right Information at the Right Time

Why is getting the ‘right information at the right time’ so difficult?  It comes down to the effectiveness of the Finance processes.  The biggest issue is not having a single version of the truth and continuing to run a fragmented close process that requires trying to keep everything glued together.  That creates a less-than-ideal situation, and there’s entirely too much time being wasted to integrate, reconcile and validate data – causing unnecessary delays to key decisions.

An Accenture research report from December 2020 surveyed 450 CFOs and other Finance leaders at companies with at least $1B in annual revenue.  A key finding especially stood out: while nearly all (see Figure 2) respondents believe operating with real-time data is critical to navigating disruptions, such as the recent pandemic or the threat of a recession, just 16% of respondents are being informed by such data at the scale that’s needed.

Figure 2: Accenture 2020 – Time to Get Real
Figure 2: Accenture 2020 – Time to Get Real

These challenges are not limited to financial consolidation and close processes.  For many companies, financial processes are too manual and not yet automated or standardised, leading to time-consuming data entry (and re-entry) for reconciliations, reclassifications, and adjustments.

4. Too Many Manual Steps in Processes – Limited Automation

Are manual steps in Finance processes really that bad?  It’s true that some level of manual processes in small to mid-sized organisations may not be a huge problem.  It really all comes down to manageability.  As organisations grow or become more complex, manual processes add unnecessary risk, costs and time delays – all of which can accumulate over time and be very damaging.

Manual steps can result in the following pitfalls:

All of these potential pitfalls only emphasise why automation is the way forward.  And today, the most successful organisations are embracing automation by using financial close software to better equip their people and to ensure they have agile and effective processes.

5. Limited Inter-Period Reporting Capabilities

Most organisations focus considerable time and resources on monthly, quarterly and annual reporting requirements.  So why do very few organisations use ‘inter-period’ (i.e., daily or weekly) reports?  The reason is very often because, historically, Finance processes and technology did not allow for inter-period reporting.  Finance teams had a lot of manual tasks just to complete the existing reporting cadences, which left little or no time to consider any additional regular data points or insights.

Figure 3: Key Operational Data Collected in Everyday Systems
Figure 3: Key Operational Data Collected in Everyday Systems

Now organisations are discovering they have vast amounts of valuable information that’s collected every day in ERP, CRM, HCM, Supply Chain and other systems (See Figure 3) – information that has not typically been leveraged to support daily and weekly operating decisions.  The organisations that can harness these large volumes of operational, and often, transactional data to identify key trends and ‘signals’ can move to support daily and weekly decisions.  Such decisions can positively impact month-end financial results and therefore the performance of the overall organisation.

6. Lack of Transparency, Auditability & Controls

Many legacy CPM and/or connected Finance applications provide file-based integration with source systems, but key advantages come with having full, direct integration between CPM and GL/ERP and other systems.  Why are those advantages so important?  Well, a lack of robust data integration capabilities creates a multitude of problems, including cumbersome manual steps, wasted resources and time, risk of errors, poor financial data quality, lack of traceability and lack of auditability.  Thus, the effectiveness of the financial close and reporting processes is fully dependent on getting timely and accurate data from GL/ERP, HCM, CRM and other systems.

The loading, mapping and transforming of data from source systems to CPM solutions can be especially cumbersome and fragmented without highly connected and business-user-managed tools.  Not to mention, data movement may be reliant on IT resources that are not knowledgeable on both the CPM model and the transformation and validations that must occur. This issue is even more problematic without the transparency and controls needed by the business to support compliance

How to Overcome the Challenges – A Strategy for Moving Forward

Moving Forward

Many legacy Finance teams operate in the form of a conveyor belt production line.  Each person has specific tasks to complete during the close process to generate the required financial reporting – but only once production is complete at the end of the line.

For organisations looking to move away from this production-line approach, now is the perfect time to reimagine the close and effectively address these challenges with the key steps below:

At OneStream, we call this Intelligent Finance.

Learn More

To learn more about how organisations are reimagining the financial close, click here to access  OneStream’s Reimagining the Close whitepaper.

A revolutionary product is launched into the market. Are you eager to test it out, or do you wait until it has been widely accepted by society? There are many benefits to jumping on board early, especially when adopting technology. Trendsetting organizations can position themselves at the forefront of a major market movement and evolution. As they say, the early bird gets the worm.

With an eye on innovation, Huisman was willing to adopt new technology for their finance transformation journey which began back in 2018. As one of the first adopters of OneStream in the Netherlands, Huisman took a chance, and it was a good one. Huisman saw the appeal and potential of OneStream because the company’s vision aligned with their own needs and goals. Since then, OneStream has been named a leader in the Gartner Magic Quadrant reports for Cloud Financial Close and Cloud Financial Planning and Analysis (FP&A) markets, and recently received a 100% recommendation score in the BARC Planning Survey 21.

Read on to learn about Huisman’s OneStream journey and the successes they have seen by replacing Excel with an intelligent finance platform.

Scattered Landscape of Applications

huisman

Founded in 1929, Huisman Equipment is a worldwide operating company with its head office based in Schiedam, the Netherlands. Huisman designs and manufactures heavy construction equipment for the world’s leading companies in the renewable energy, oil and gas, civil, naval and entertainment markets. Huisman’s products range from cranes, pipelay equipment, drilling equipment and winches, to vessel designs and specials. Huisman employs approximately 2,500 people and has an annual turnover of €600M.

With locations around the world, Huisman had 10 regional offices using different local finance systems and Excel for financial consolidation and project reporting. Month-end and quarterly closing numbers would take up to a month to complete, while year-end reporting would take 3-4 months. There was no standard reporting pack for all departments and locations, which led to mismatched data that made reporting difficult.

From Spreadsheets to an Intelligent Finance Platform

Huisman embarked on a digital transformation to improve transparency across the organization and optimize business performance. This included a heavy focus on improving financial consolidation, reporting and project performance management. Although an unknown name in the Netherlands region at the time, OneStream’s cloud platform was selected because of its ability to streamline financial reporting but also support more operational and project performance management. Huisman strongly believed that OneStream would provide confidence in their contracts and less uncertainty in financial data.

Phase 1a of the OneStream implementation focused on project administration for 50 reporting entities. This included processing actuals, sales budgets, revised budgets, and forecasts in OneStream with detailed information about hours and costs per project. Managing intercompany activity is streamlined with project rate currency translations happening in OneStream. Phase 1b focused on implementing the financial consolidation model with P&L, balance sheet, cashflow and equity pick-up produced in OneStream. Future phases will include fiscal reporting, daily cash information, planning and budgeting, and more.

Benefits of Switching to OneStream

OneStream was flexible enough to connect system landscapes across locations, eliminating the need to move data between fragmented systems and providing Huisman with better insight into project performance across each entity and portfolio. By balancing project reporting with financial reporting, Huisman has gained visibility into project performance with more detailed financial data.

With 90% of their project data in OneStream, Huisman is seamlessly reconciling across systems and locations. OneStream is capturing different levels of information across locations, which has dramatically streamlined project and contract management. Users can drill down from summary information on a project, then into employee detail, to better manage the project lifecycle from proposal to delivery. Users can make their own analysis by slicing and dicing the data for their own point of view.

With 50+ reports, Huisman has accelerated from monthly to daily tracking of hours for 600 employees across projects. They now have detailed standard reporting packs for project managers, department heads and the board to review.

Learn More

To learn more about Huisman’s unique OneStream journey, we invite you to read their Customer Success Story. And if your organization is ready to ditch spreadsheets and start your digital transformation journey, contact OneStream today!