Skip to main content

Getting out of Excel Hell!

…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 computers to find the right data file, are all common problems excel users face all the time. Over the years, spreadsheets have been both a boon and a bane and have given many a nightmares to finance executives facing the wrath of an impending deadline. Here are some common excel problems that we often have to contend with:
  • To refresh or not to refresh- we’re all too familiar with the uneasiness that comes with changing formulas and updating interrelated spreadsheets that share cell values. If we are lucky we will realise that we are looking at wrong numbers because excel did not recalculate and refresh the cells. If we are unlucky, we may be working with wrong numbers leading to wrong conclusions and decisions.
  • What happened to my formula?– did you ever see a hard-coded value in a cell, and were absolutely convinced that you had put in a formula in the cell. Excel has a way of converting formula cells to hard-coded values in case of corruption or in case of linkages with other excel files.
  • The dramatic crash: If you have seen the message “Excel cannot open the file because the file format….”, then you have been witness to hours of hard-work coming to naught taking precious data down the drain.
  • To err is human, but your boss may not be divine. You can never be too careful, and errors do creep in, in spite of best efforts. In 2013, JPMorgan Chase lost more than $6 billion in its London Whale’ incident – allegedly due to copying and pasting incorrect information!
  • The virtues of patience often get tested when working with a large number of spreadsheets and data, and the file takes ages to open
  • Fragile for agile- Agile businesses require instant access to up-to-date information so that business leaders can make decisions quickly and accurately. The very nature of excel makes it difficult to achieve this objective.
  • Not designed for teamwork- Spreadsheets are not designed for collaboration. Attaching spreadsheets in emails and passing it around takes too much time, leaving room for errors and a high chance of someone working with an older document.
  • Too much formatting- Formatting the spreadsheet to make it presentable for reporting takes up too much of the productive hours.
When it comes to collaborative management financial reporting and multi-dimensional performance analysis, excel is not the ideal tool. Unfortunately, for most accountants, there is no easily available practical alternative.
The right software tool will not just meet the analytical capability that the executive management is looking for, but also the functional aspects of how an accountant prepares a financial report before it is ready for consumption (viz. regrouping of accounts, allocation of costs, segment reporting, consolidation etc.).
A single automated tool that will allow an organization to realize all the benefits and flexibility of Excel while mitigating its weaknesses and risks. A tool that is user-friendly and easy to learn.
So, automate your financial MIS today and escape from Excel Hell ! 


Comments

Popular posts from this blog

Top 5 Financial KPIs for the CXO

Let’s say you got up this morning with a headache. You know from experience that it’s a small niggle, and it will go away on its own. But what if you got up tomorrow morning, and the headache got worse? If an aspirin doesn't help, you will surely go to a doctor, and most likely get some diagnostic checks done. A KPI (key performance indicators) dashboard is like a diagnostics report of various parameters that reflect the health of your business. KPI’s help you measure your business’s financial health. You can define KPIs for different areas of your business, from HR, Finance, Marketing to Operations. You can combine these KPIs to arrive at an overall health for your business. The Finance function is like the blood flowing through your body; it affects each part of it and keeps it healthy and oxygenated. Similarly, your company’s financial performance has a direct impact on every aspect of your business. Remember, that KPI’s and dashboards are not just for CFO’s...

FinAlyzer, a flagship product of BeyondSquare Solutions, was featured on My Startup TV, India’s first channel for Startups.

We are glad to share that FinAlyzer, a flagship platform of BeyondSquare Solutions was selected by NASSCOM, among the Top 50 Startups and MSMEs for its first global virtual event NASTech 2020. Karthik Ganeshan, Director & Co-Founder of BeyondSquare Solutions featured in My Startup TV, India’s first channel for Startups. As stated by Karthik Ganeshan, he and his partners who are all ex-Infoscions had a deep desire to contribute to the Digital Transformation and thus co-founded BeyondSquare Solutions. FinAlyzer is a unified digital platform for Financial Consolidation, Close, Analytics, and Management Reporting. FinAlyzer is a key catalyst driving Digital Transformation for all the CFOs across industry segments. We are grateful to Major Sunil Shetty (My Startup TV) for hosting us on its media channel and the NASSCOM team who provided us a platform to showcase FinAlyzer.

Top 3 Trends in Financial Planning, Analysis & Reporting

The main purpose of Financial Planning & Analysis (FP&A) teams is to drive execution of the organizational strategy. They start from where the accounting team stops. These teams focus on what may happen in the future, by using data from the past, make assumptions and explain variances to the forecast so that management can maximize value creation and take better decisions. The FP&A teams support the finance controllers by turning information into knowledge, and knowledge into actionable insights. They are less focused on day to day transaction processing and more focused on forward-looking analysis for the business. With the speed and complexity of businesses constantly increasing, the prominence of FP&A teams has vastly increased. Apart from doing the budget, FP&A answers strategic questions, forecasts for the future, ensures a timely accounting close, prepares board reporting packages, preps the executive team, divests a division, analyzes product line prof...