Real-Time Data is the Minimum Requirement for a continuous Close

10 Downloads
Print Bookmark
An effective month end close needs an effective strategy during the pre-close period. There are a number of bottlenecks that hinder the financial close process, and accessing the right data is one of the most critical challenges. In this ebook, we explore the need for real-time data to support a continuous close process.
CONTENT

Chapter 1

Executive Summary

Chapter 2

How the Monthly Close and the Continuous Close Process Work

Chapter 3

What real time data means:

Chapter 4

What can the finance team do?

Chapter 5

The Need for Connected Workspace
Print Bookmark
Chapter 01

Executive Summary


This is the second ebook in a series that analyzes why the month end financial close takes time.  In our previous ebook, we provided an overview of the bottlenecks slowing the closing process and the reasons causing the financial close bottlenecks.  In this ebook, we explore the first challenge that creates these bottlenecks, the need for real time data to support a continuous close process.

Benefits of Real time Data

Chapter 02

How the Monthly Close and the Continuous Close Process Work


For most companies, the close process starts two to three days before the end of the month.  The pre-close process focuses on preparing all the data that can be prepared while waiting for the month end cutoff to start the race.

The first challenge is data is only made available at month end.  This prevents a continuous close process and it burdens the month end close process to manage a delicate balance between:

Accuracy, Time, Resources

  • Accounting resources to perform financial closing functions
  • Time to close the books and get the information to company management as quickly as possible after the month end
  • The accuracy of the close due to time and resource constraints.

When trying to implement a continuous close process the biggest hurdle that is stopping a continuous close is data.  The month end close process isn’t performed throughout the month because data isn’t easily available and able to be incrementally consumed.  Typically, at the month end, the close information is pulled into Excel (.csv format) from the general ledger, sub-ledgers, the bank, and other external systems on a batch basis. While this could be done mid-month, the csv data is not incrementally consumed, meaning each csv file retrieve requires:

CSV file retrieve requirements

This increases the resources required during the month end, increases the possibility of errors in the manual Excel processes, and only marginally shortens the time to close at month end.

The second challenge is that data comes from different internal and external systems with different levels of granularity and needs to be normalized and matched.  Some data comes in at a summary level, like information from the General Ledger.  The summary ledger data is used to validate and match against the detailed transaction information from the different sub-ledgers, schedules, or listing of transactions used for accruals or for timing cutoffs, etc.

Chapter 03

What real time data means:


Real-time data updates the Excel workpapers incrementally on a daily basis so that processes like reconciliation and account analysis can be performed incrementally without worrying about data cut-off, duplication of transactions, and errors created from copying formulas to the new information.

Even though 40-60% of all transactions happen at month end, once you have access to real-time data you can create a schedule to pre-close accounts through the month rather than waiting for month end and then incrementally check out the new transactions that happen at month end.  This greatly reduces the effort at month end and cuts days off of the month end closing process.

Real-time data is a multi-system challenge.  Here are a few examples why:

  • Transactions from the bank need to be matched up to the general ledger bank account, accounts payable and accounts receivable information.
  • Transactions from commission systems and payroll systems need to be matched up to control accounts in the general ledger and bank accounts

In many cases, Excel is the system used to perform, analyze and manage the close, which makes real time data more challenging because Excel is disconnected from all the other systems.  This means data is brought in at the end of the month in batch, information analyzed and reconciled, correcting journal entries calculated in Excel, and then someone manually enters the journal entries back into the ERP system.

The use of disconnected Excel with disconnected data only makes the financial close more challenging. It creates an audit challenge when the justification for adjusting and correcting journal entries at month end are Excel files on many different desktops and shared drives.There is no central binder of all month end adjustments and corrections.

Chapter 04

What can the finance team do?


The first step is to automate the financial software with an end to end financial close central system for performing the financial close processes just like you have an accounts payable system for recording expenses and paying vendors.

The second step is to make sure the financial close system supports real-time data integration with all the source systems,  including:

Data integration with all the source systems

Even though 40-60% of all transactions happen at the month end, once you have access to real-time data you can create a schedule to pre-close accounts through the month rather than waiting for month end.  Then, the “after” month end process becomes incrementally verifying the new transactions during the month-end.

Chapter 05

The Need for Connected Workspace


Financial close software should also store all the spreadsheet analysis and calculations in a connected workspace, so you have a close binder for each month rather than having close workpapers stored on every accountant’s desktop.  Having a connected workspace type system for managing the spreadsheets allows for incremental updates to the close workpapers to streamline interim reconciliation and validation close processes.

In our next ebook, we will go deeper into the need for connected workspaces as an integral part of the workflow and collaboration of  financial close management to organize and manage the process.

Data integration with all the source systems

Related Resources

All
Order to Cash
Talk To Our Experts

Streamline your order-to-cash operations with HighRadius!

Automate invoicing, collections, deduction, and credit risk management with our AI-powered AR suite and experience enhanced cash flow and lower DSO & bad debt

Talk to our experts
Thank you for downloading the PDF!