How Financial Consolidations Winners Close Their Books In 7 Days

Table of Contents

How Long To Close Your Books Is Normal?

 

In a recent SAP Value Engineering (VE) study of financial consolidation, it was revealed that the average number of days for the very best companies to close their financial books was 7 days. 

 

SAP Value Engineering

 

 

How Did the Worst Performers Fare? 

 

They took more than 3 times as long at 22 days!  Now this wouldn’t be a big deal if finance cost weren’t a significant cost.  But that same VE study revealed that finance cost, when measured as a percentage of revenue, also varied widely:

Typical Cost of Finance

Finance Cost

Finance cost vary widely among organizations

 

  • Lowest cost finance operations came in at .4%
  • Highest cost finance operations came in at 1.2%.  (3 times seems to be a common theme here).

5 Surprising Reasons Enterprises Don’t Use An ERP

 

It is sometimes difficult to tease out the cost of finance for any given firm based on their publicly available information, but you can bet that whatever it is, the boss would like for it to be lower and for the books to get closed faster. 

When Do You Know The True Financial Status Of Your Business?

You would be surprised at how much teeth gnashing happens because no one really knows for certain how the business is doing until the books are closed

 

SAP BPC

Don't let this be you

 

What causes these delays in closing the books? 

 

The issues are not new and the technology to solve them exist and is constantly getting better.  To recap, those issues may include:

 

  • Intra-company politics, especially between HQ and subsidiaries, specifically regarding cost.

  • Individual reporting units that are slow to report

  • Push back from divisions, meaning no buy-in

  • Learning curve with the systems and procedures

 

With the new SAP EPM 10.0 release as well as subsequent releases, many technical issues have been addressed, especially in the areas of the interface and the use of formulas (they are now mostly buttons, but if you are still on an earlier version, you can still download our guide to some handy BPC formulas). 

 

Get 10 BPC Functions Checklist

 

 

Many specific issues contribute to the consolidation issues, such as:

 

  • Distribution of systems and maintenance of metadata

  • Flat file inputs from subsidiaries and affiliates

  • Delays in understanding and resolving variances.

 

Of course, Sarbannes-Oxley (SOX), IFRS and the need to migrate to XBRL play their parts as well in delaying financial consolidation. 

 

We believe that achieving value from your SAP implementation requires that you address many improvement areas, not just in the area of financial consolidation. 

In fact, in a recent study, it was reported that:

  • 50% or more of all organizations fail to achieve all projected business benefits.

  • 63% of companies or more do not succeed in addressing required business process change issues, one of which, is financial consolidation

 

SAP Financial Consolidation Projects

 

It can be challenging to implement a successful financial consolidation system using SAP BPC or SEM BCS or even EC-CS. 

If it is part of a bigger ERP implementation, you want to avoid being one of the 74 percent of ERP implementation projects that exceed their budget constraints. 

To put that into perspective, the typical ERP implementation project in 2011 ran to 10.5 million USD and overran their budget by 2 million dollars while more than half of those projects were late, and 23% of those late projects were over their schedule by 25% or more. 

 

Some simple recommendations:

 

Your project may well be late.  If it is focused on value, from the get-go, you will have a much better chance of getting the support you will need to deliver it, on-time or otherwise.

To get to initial go-live, push back on change request.  If you run a change through MS Project and it says it may well push the project completion date out months or even years, and you’re any good with project planning, like any good pilot-TRUST YOUR INSTRUMENTS. 

BO financial consolidation

Keep your financial consolidation project in the green.

 

If you aren’t really confident with MS Project, get professional help.   If you need help with SAP BPC, then just click the button and drop us a note.

 

Click me

 

 

Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

Lonnie D. Ayers, PMP

About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and remote coaching.
Balanced Scorecard Consultant

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by Lonnie D. Ayers, PMP

The SAP Blog

Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email.