Whenever Groundhog Day (Feb. 2nd) comes around it reminds me of that 1993 movie of the same name. Do you remember it? Just for quick refresher, Bill Murray plays an arrogant weatherman covering Groundhog Day in Punxsutawney, PA who finds himself in a time loop where Groundhog Day is repeated over and over.
Mr. Murray eventually breaks the cycle by changing his ways. But this situation also reminds me of how many Finance professionals must feel regarding their organization’s financial close and reporting process. I lived this myself for many years when I was an accountant early in my career. Finance and Accounting staff are often stuck in the same routine, month after month.
They struggle with spreadsheets or inadequate financial consolidation and reporting systems, and time-consuming manual tasks. When it takes 2 weeks or more to close the books, by the time Finance delivers management reporting its often too late to have an impact. Then there’s limited time available to focus on value-added analysis before the next month-end close starts again.
Modernize Systems and Automate Processes
The monthly financial close and reporting process doesn’t have to be like Groundhog Day. By modernizing financial systems and automating key tasks and processes, Accounting and Finance can streamline the close process, accelerate delivery of financial results and spend more time on analysis and supporting decision-making. Here are some examples of key tasks that can be streamlined through automation.
- Collecting and validating trial balances – many corporate Finance teams spend several days each month chasing down trial balances, validating researching and correcting errors with division or regional accountants. With a modern financial consolidation system, accountability and ownership for submitting and validating trial balances can be pushed to Finance staff at divisional or regional levels. With a fast and accurate data collection process, corporate Finance staff can focus more time on consolidating and reviewing results vs. loading data.
- Intercompany eliminations – this is another critical task that often adds extra days to the close process as corporate Finance staff spend too much time trying to reconcile intercompany balances and getting divisional and regional Accountants to correct their intercompany accounts. With a modern financial consolidation system, the responsibility for communicating and confirming intercompany charges and balances between divisions or regions can be pushed down to the operating levels, with intercompany eliminations being automated and only minor exceptions needing the attention of corporate Finance.
- Currency translations – because of the complexities of collecting and reporting financial results in multiple currencies, many organizations collect financial results from across the enterprise in only a reporting currency, such as US Dollars. Then to understand the impact of FX rates on their financial results, they have to spend extra time collecting additional data and performing this analysis. With a modern financial consolidation system, trial balances can be submitted in local currencies, translated to the reporting currency, and consolidations can occur in multiple currencies, with full analysis of the impact of fluctuating FX rates on financial results.
- Allocations – performing cost allocations that are required during the close process can be tedious when using spreadsheets, given the iterative nature of the process. With a modern financial consolidation and reporting solution, cost allocations can be automated, and updated as the financial results are updated over the course of the financial close cycle.
- Account Reconciliations – Finance teams in mid-sized to large enterprises can have hundreds to thousands of account reconciliations that need to be performed before the financial results can be finalized at period-end, adding extra days to the close process. With a modern account reconciliations solution, that integrates seamlessly with the financial consolidation software, the account reconciliations process can be more automated, and streamlined significantly.
- Management and Financial Reporting – while collecting and consolidating results often consumes most of the time in 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 modern financial consolidation solution, that includes integrated and Finance-friendly reporting tools, the production and distribution of management and financial reports can be largely automated, accelerating delivery and providing more time for Finance to perform value-added analysis.
Simplify and Unify Financial Consolidation, Reporting and More with OneStream XF
Many organizations have modernized Finance and automated the financial close process using OneStream Software. OneStream provides a revolutionary corporate performance management (CPM) solution, the OneStream XF SmartCPMTM platform. OneStream XF unifies and simplifies financial consolidation, planning, reporting, analytics and financial data quality for sophisticated organizations.
Deployed via the cloud or on-premise, OneStream is the first and only solution that delivers corporate standards and controls, with the flexibility for business units to report and plan at additional levels of detail without impacting corporate standards – all through a single application.
Built upon twenty years of creating industry leading financial consolidation and financial data quality solutions, our unique platform delivers more complete functionality in a solution that is easier to own and maintain. OneStream XF supports strict compliance requirements with comprehensive audit controls on data, metadata and processes. Our financial consolidation and reporting solution includes key capabilities that help streamline the close process, including:
- Global consolidation capabilities (US GAAP, IFRS, Multi-GAAP)
- Advanced currency and cash flow reporting
- Powerful intercompany eliminations
- Integrated financial data quality
- Detailed audit trails and drill-through
- Guided workflows, guided reporting and dashboards
- MS Office integration including Excel, Word and PowerPoint
The OneStream XF MarketPlace features downloadable solutions that allow customers to easily extend the value of their CPM platform to quickly meet the changing needs of finance and operations. Key XF MarketPlace solutions that complement our financial consolidation and reporting capabilities include:
- Account Reconciliations
- Close Manager
- Task Manager
- Disclosure Management
- Compliance Solutions
- Postal Service and others
In addition to providing the most advanced financial consolidation and reporting in the market, the OneStream XF platform also supports budgeting, planning, forecasting, and analytics. So there’s no need to integrate data between separate consolidation vs. planning and analysis applications or modules. All these capabilities live and work together in a single, unified platform.
Breaking the Cycle
Organizations that have adopted OneStream XF have accelerated their period-end financial close and reporting cycles, improved data quality, shifted more Finance time to value-added analysis, improved management insights and decision-making.
John O’Rourke is Vice President of Product Marketing at OneStream Software. With a background in accounting and finance, John has over 30 years of experience in the software industry, including 20 years of experience in product marketing at Hyperion Solutions, Oracle and Host Analytics. He has worked with many customers and partners on financial reporting and planning initiatives and has spoken and written on many topics in corporate performance management. John has also held positions in strategic marketing and product marketing at Dun & Bradstreet Software, Kenan Systems and Decisyon.