Skip to main content

The perils of consolidating financials in Excel

                          

                                                         Visit: https://finalyzer.beyondsquare.com/

Excel is a fantastic tool for the finance professional. It allows for a reasonable amount of reporting, budgeting, analysis & forecasting. It is inexpensive, and is widely understood within the finance industry. This means that most employees are already trained and comfortable using it. These things make it a practical choice, at least until the business grows to a size where the problems of using excel start becoming evident. Financial consolidation can be complicated or simple, but for CFOs the overriding goal is always the same: faster and more efficient closes.
Once you begin adding complexity to the business with operations overseas, acquisitions of other businesses, or the in-depth reporting required to satisfy the interests of venture capitalists, regulators and internal stakeholders, excel for close management cannot keep up the pace. Has your company outgrown Excel for consolidation?
Let us take a look at some of Excel’s perils.
Time-consuming & tedious!
Manually creating reports on a monthly, quarterly or annual basis is incredibly time consuming and inefficient. Pulling together the vast array of financial information across multiple sources (entities, geographies, segments etc.) takes weeks to compile. Adding the accounting treatment to the consolidated information is time consuming. This has a significant impact on the ability to make the reports in a timely manner and then use it to make thoughtful decisions.
Data in Excel is error prone
The process of consolidating information in Excel is inherently manual. As long as the data volume or number of data sources is less, it can be kept reasonably accurate. However, as the number of data sources or data volume increases, it gets more and more error prone. Consolidating financial information across entities needs various levels of accounting treatment, viz. grouping of ledger accounts, forex translation, reclassification of accounts, eliminations, overhead cost allocation etc. Doing all of this in excel is of course inefficient but also inherently error prone. A simple “fat fingering” error could completely change the numbers that could not only lead to strategic decision making errors.
Also, the spreadsheets are not always validated properly. They are often reviewed by their own authors and are almost never subject to a peer review, or by someone completely independent due to lack of time and other such pressures. From an internal control perspective, this practice is a bad idea and causes so many spreadsheets to be flawed and without proper risk mitigating controls. Many companies proceed as if the spreadsheets are accurate, even though about 88% of all business spreadsheets used for close and consolidation contain errors. This could cause severe problems with the regulator if such errors are not caught on time.
Excel is not a database
Excel is spread-sheet software and not a database.One of the key inputs for decision making is comparing information across various reporting periods, viz. monthly data, YTD data, quarterly, consecutive reporting periods, corresponding periods in the previous year’s etc. The slicing and dicing of data across various reporting periods needs to be available quickly without having your accountant spend hours putting the data together. In most organisations, this is not the case. The accountant keeps digging data from various excel reports across various reporting periods, and tries to consolidate all the data that is required by the management.
Is your spreadsheet secure?
A spreadsheet can easily be emailed, which is a huge security risk. Spreadsheets are also easy to upload to consumer-grade cloud storage, such as Google Docs, which simply does not have the enterprise-grade security necessary when handling sensitive corporate documents.
In summary, you can’t help but conclude that Excel is time consuming as well as prone to material errors, especially if it is being used for financial consolidation and reporting. For that reason, a well-designed consolidation tool is much more preferable to using spreadsheets. Once such a database is established, it is much simpler to monitor and audit than with spreadsheets. If Excel isn’t handling it for your business anymore, it’s time to upgrade! The good news is that financial management software products have become more robust and these specifically designed products for the CFO office is everything that Excel is not, when it comes to accuracy, security and time saving!

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...