Skip to main content

Consolidating the Financial Statements? Another Vacation Cancelled!

By
I have consistently observed that my friends from Finance are working during the times that most others are on vacation. This is especially true during quarter and year ends. Financial Consolidation can get quite complex, and the process of consolidation could be quite manual, even in many large organizations. The CFO’s goal is undoubtedly to push for faster and accurate close cycles. Many of the issues I am listing below are common to most organizations I have had the opportunity to observe and interact with:
  • The organization has grown through mergers and acquisitions, and the subsidiaries use disparate accounting systems and ERP’s, and thereby have different chart of accounts
  • Massive co-ordination exercise with the various organizational entities to get data on time for consolidation
  • Inter-company transaction reconciliation and elimination is a nightmare
  • Foreign currency translation
  • Multi-level entity hierarchy makes the consolidation complex
  • Minority interests and goodwill calculations
  • Some of the Subsidiaries do not follow Indian GAAP. How to handle the related Multi GAAP reporting (IFRS, US-GAAP, Schedule VI etc) and consolidation challenges?
  • Lack of consistency between internal MIS and statutory reporting
  • Lack of traceability for out-of-book adjustments
  • Compliance is not built into the process, but is a separate overhead activity. This results in going back and doing corrections, rather than getting it right the first time.

Using manual or semi-automated processes to do financial consolidation is tedious and potentially error prone. This makes financial reconciliations, share calculations, foreign currency translations, various allocations and other calculations very difficult to be compiled accurately or be wrapped up within the deadlines.  

With Companies Act 2013, the CFO is accountable for certifying internal financial controls. It makes it all the more important to make sure that the processes around financial statement preparation and consolidation are automated.

Many mid-sized organizations face these challenges, but cannot afford to implement large Enterprise Performance Management (EPM) solutions, as they are prohibitively priced. The industry needs easy to use and efficient software solutions that do not burn the bank. A system that is overly complex or does not function effectively will soon be abandoned by the stakeholders, and they will go back to their old ways of working.

Once the CFO and senior finance executives get convinced that they have zeroed in on the right software solution for their needs, they need to completely back the program and provide executive sponsorship. Adopting a new software system involves change in internal business processes and change in mindsets. Most people are reluctant to change. Unless the program is driven and monitored by the CFO’s office, it will be one more expensive but failed experiment.

In general, the expectations from the CFO and Finance Heads have been rising steeply. But what frequently stands out as a hurdle is the time and effort it takes to compile necessary information from multiple operational silos within the organization. Besides blocking your time and preventing your team from focusing on value adding work, such labor intensive transactional processes can create serious inefficiencies and inaccuracies in the output.

A simple solution that fits your needs and one that can be easily adopted by the team is what you are looking for. So, I wish you smart decision making – and happy holidaying!!


Comments

Post a Comment

Popular posts from this blog

The Mission to Make the CFO's life Easier

By
In today’s business context, life of a CFO is that of the radar as well as the captain of a moving ship. Today’s CFO is expected to contribute well beyond the traditional role of cost management and operational controls. The CFO needs to play a delicate balancing act across multiple dimensions, some of which include: Impact of globalization: having an effective finance function that can account for the increasing complexities of running a global business Regulatory adherence: Global regulatory requirements are constantly changing and continually increasing, and CFOs have a personal stake in regulatory adherence Risk management: the nature of risks that an organization faces keep changing Reporting requirements: managing the ever broadening and often burdensome reporting requirements The CFO needs to do all this, while also keeping a keen eye on rigorous ongoing cost management and operational efficiencies to fuel profitability and strategic reinvestment. All this under...
Post a Comment
Read more

5 Things to Consider Before Investing in a Financial Consolidation Software

By
  In a recent conversation, the Chief Accounting Officer of India’s largest private enterprise mentioned that a good financial consolidation software would be of great service to the accounting community. His statement implying indirectly that in his many years of managing accounting for an extraordinarily large and complex organisation, he has still not come across a suitable enterprise platform for consolidation. It is but natural to assume that organizations would rid themselves of long days of manual financial consolidation and labour-intensive management and statutory reporting. The practice of being strapped to one’s chair and spending long hours into these activities must be shunned. Instead, quality time should be spent on analysis and decision making. Before you dive in to avail the perks of a financial consolidation software, it is crucial to know what to expect from the software. While there are many choices, one must exercise prudence in selecting the one that furth...
Post a Comment
Read more

Getting out of Excel Hell!

By
…and why you should automate your management financial reporting. Excel is one of the world’s greatest desktop tools and many people love it because it is familiar and easy to operate. If you want to analyze a lot of numbers or do some complex modelling on a static dataset, it's hard to beat.I personally am a power user of excel and love the flexibility and ability to model various scenarios easily, and then analyse it. However, running a company involves collaborative, multi-department processes like planning, budgeting, forecasting, and reporting. It involves collating data from multiple source systems and people, curating & transforming it before it is ready for consumption. And that’s where the power of Excel falls short. Weeks are wasted every year, manually consolidating a mass of individual spreadsheets. Errors in cross-linkages, formulae getting converted to hard-coded numbers, manual errors, manual data entry, individuals having to laboriously search their computer...
Post a Comment
Read more