In the typical financial period, account reconciliations are performed after the close. Accountants first review each account in the financial statements and then verify the accuracy of each balance listed. This process often involves comparing the financial statement balance to another source of information – for example, comparing the balance for the Cash account to an external bank statement. Other examples of critical accounts requiring reconciliation include Accounts Payable (compared to the AP sub-ledger) or Accounts receivable (compared to the AR sub-ledger).
Account reconciliations are primarily performed to ensure consistency and accuracy in financial reporting. And for publicly held companies that need to report financial results to external stakeholders, account reconciliations are a key internal control, one where detailed audit trails need to be available to back up all account balances.
For many organisations, the account reconciliations process not only involves manual, time-consuming work but also causes significant delays in the financial close process. Why? Well, most medium- to large-sized global companies must reconcile hundreds to thousands of accounts during the quarter-end or month-end close across the parent company and various subsidiaries. Something else also relates to this process: the need to reconcile data between multiple software applications used to run the business. The more systems, the more reconciliations required.
Leading Finance departments are attempting to eliminate the risks of manual processes. Those risks can include missing or lost reconciliations, unreconciled accounts, improper use of roll-forwards, and insufficient justification or documentation — and eliminating them helps protect organisations against costly mistakes. Many organisations have therefore adopted standalone account reconciliations software applications to deal with these issues.
However, that solution is not always the right answer. Why? With standalone account reconciliations applications, a ‘data integrity gap’ (see Figure 1) exists between the account reconciliations and the financial statements. When accounts are reconciled in a system separate from the financial reporting process, out-of-sync data easily occurs, causing delays in the close process and issues with data integrity.
Aligning account reconciliations and financial reporting ultimately improves the integrity of financial results and gives Finance and stakeholders increased confidence. But even beyond those benefits, significant time and cost benefits can be realized. Increased levels of visibility and control can also be gained.
Not yet convinced of the benefits? Here are 5 key reasons to align account reconciliations with financial reporting:
The key to more effective account reconciliations lies in not only automating the process but also fully unifying it with the financial close and reporting. If GL trial balances are loaded into a single system for financial consolidation, reporting, and account reconciliations, then the data will always be synchronised. The close process will also be faster and more efficient. Importantly, one single trial balance load can, in parallel, feed all reporting processes – including account reconciliations – from the same source. That ability reduces the risk of differences and speeds the close.
If the process is fully automated and unified, then the benefits of leveraging the same trial balances across the close and compliance processes become very clear. How? Well, data often changes constantly in the close process due to eliminations and other adjustments. Such updates, in an automated system, continue to get reflected across processes without having to physically move data between separate connected Finance solutions. And that automation eliminates the data integrity gap (see Figure 4).
OneStream is the ONLY solution that can provide a link from reported balances to reconciled accounts. Users can instantly drill to reconciliation from financial reports in one unified system. This capability provides 100% visibility from reports to data sources – meaning all financial and operational data is clearly visible and easily accessible.
The capability to unify financial close processes in parallel and without complexity gives OneStream the ability to replace multiple legacy or connected Finance applications and spreadsheets. And it’s a big opportunity for organisations to drive total cost-of-ownership savings and generate return from the investment in OneStream.
Below are a few examples of customers we have worked with and the benefits they’ve achieved with OneStream.
TerraForm Power decided to take a new “cloud first” approach to their software implementation strategy. Their system landscape included multiple legacy applications which were cumbersome and created challenges for TerraForm Power’s finance and IT teams. There was also a heavy reliance on Excel®, which lacked audit trails and posed risks for the company.
After implementing OneStream, the realisation of benefits has been significant. Having standardised reporting has helped TerraForm Power to close the books quicker and more accurately while getting through audits more reliably. Interactions across the team are improved with a single version of the truth. By bringing account reconciliations into OneStream the number of accounts has reduced from 700 to 150. As a replacement to Blackline, TerraForm Power is now saving roughly $100K per year on licensing.
West Bend Mutual Insurance (WBMI) previously used Microsoft Excel® spreadsheets as a data collection and reporting tool for their month-end close process. Allocations were performed in a different software tool that had size processing constraints. Inconsistencies in data collection via Excel® spreadsheets created a labour-intensive and error-prone close process. Further, the transparency by operations to financial detail was limited.
WBMI has experienced many benefits from implementing the unified OneStream™ solution. The largest benefit comes in the form of a consistent, stable allocation process eliminating the tedious time it took to do reconciliations. The combined time savings for these activities totals more than two days per month. The two days’ savings were the result of reduced time waiting for data loads and refreshing reports throughout the month.
Like TerraForm Power and WBMI, your organisation can also achieve a new level of risk, conquer complexity and improve the integrity of financial results by aligning account reconciliations with financial reporting. How? Replace your spreadsheets or standalone accounts reconciliation software solutions with a unified CPM software platform.
Want to learn more about how organisations are successfully adopting modern, cloud-based solutions for financial close, consolidation, and reporting? Click here to access OneStream’s ‘Conquering Complexity in the Financial Close’ whitepaper.
Download the White Paper
Well 2020 was a year we all won’t soon forget. While it was a year of disruption for many, the OneStream engineering teams were busy delivering a steady stream of innovations to the OneStream Platform and MarketPlace solutions. Here’s a quick recap of what new capabilities were delivered in 2020 and how they are helping our customers conquer new challenges and lead their organizations at the speed of business.
Having an efficient financial close process is essential to producing timely results to internal and external stakeholders. And thanks to increasing use of technology, the financial close process continues to improve. According to the 2019 Office of Finance Benchmark research by Ventana Research, 46 percent of companies close their monthly books within four business days compared to 29 percent in their 2014 study. Despite the improvement, Ventana Research still concludes that most organizations continue to be laggards in adopting technology that measurably improves effectiveness.
Even the smallest numbers in a balance sheet can have a huge impact on business. And properly analyzing financial statements is crucial when decisions are to be made. As the biggest buyer of petroleum coke in the world, Oxbow Carbon is a leading industrial commodity logistics company for steel, aluminum and other industrial manufacturing.
When engaging in M&A activity, it is imperative that organizations are able to easily adapt to changing business conditions. However, it is common for the office of finance to get derailed while integrating the financial systems and operational process of a newly acquired business. And this is a challenge that was all too familiar for Prince Corporation.
Finance leaders are continually striving for a quicker month-end close. But when organizations use bulky spreadsheets for financial close, consolidation, and reporting they are only creating additional stress on accounting teams. As West Bend Mutual Insurance (WBMI) learned, an Excel-based financial reporting process is tedious to manage, inflexible, and prone to manual errors. That’s why, to keep their finance teams from late nights of reconciling and posting journal entries, WBMI made the switch to a modern and unified corporate performance management (CPM) platform. The result has been a more efficient financial statement preparation process, a shorter month-end close, and a less stressed finance team. Let’s take a look at their unique OneStream story.
Account reconciliations is the process of ensuring financial statement account balances are correct at the end of an accounting period. It’s a process that uses two sets of records to ensure figures are correct and in agreement. And if they are not in agreement, making necessary adjustments or identifying and explaining differences.
Modernizing finance across a global organization requires a high amount of focus on unifying the data. To create the most effective financial consolidation and reporting process, you must bridge the gap between ERPs, various operational systems, and corporate performance management (CPM) software. Increasingly more organizations with fragmented ERP systems are taking the leap from fragmented spreadsheets and legacy CPM products to a unified CPM platform that supports faster, more informed decision-making. Read on to discover how a global supplier of chemical and water treatments discovered the path to modern finance with OneStream Cloud.
As a former accountant, I spent several years of my life back in the 1980’s working at a multi-national company where we spent 3 weeks of every month collecting trial balances from remote locations, consolidating the financial results, and generating reports for management and our parent company. Of course, back then we were working with arcane technology – including faxed trial balances, Lotus 123 spreadsheets to handle currency conversions, and a mainframe GL for financial consolidation and reporting. Unfortunately, this lengthy process left only a couple of days per month for higher-value work, then it was back into another month-end close. I felt like the proverbial hamster on the wheel.
Managing and completing account reconciliations in a large global enterprise can be daunting due to the number of data sources and the volume of reconciliations that need to be completed. Reliance on spreadsheets or other disconnected solutions can result in errors and delays in completing critical account reconciliations and can extend the financial close process.
The world of account reconciliations software has long been dominated by vendors such as Blackline and Trintech, only to be followed from a long distance by Oracle. Having worked in the early days of the account reconciliation software industry, when Trintech was selling payments devices and Blackline operated under another name (Osaba), it has been interesting to watch the industry evolve towards a certain convergence point.
When I worked in Finance in GL Accounting, or in FP&A, the mantra of “garbage in, garbage out” was what I lived by. As much as I hate to admit it, sometimes I was to blame for it. I’m sure there are much better accountants in the world than I ever was, or ever will be. But among the 280 or so finance organizations I have visited over the years working for Hyperion, Trintech, Prevero, or now OneStream – presenting account reconciliation software solutions for finance, this is by far the most common expression I have heard.