NEWVena-Logo NEWVena-Logo
Request Demo

The Excel Lifecycle: A Collection of Patch Work

December 26, 2016 |

As a high school student trying to acquire job experience, I worked in a small family business with a long history and owned by a sweet married couple. The husband was in charge of operations and sales while the wife did the admin and accounting.

Because the ledger system they had in place didn’t accommodate payroll finances, those numbers and calculations were handwritten in a notebook. There were frequent errors in tax calculations, remittances, and commission checks, mainly because the people around her couldn’t read her handwritten numbers.  When I came on board I introduced Excel and the number of errors dropped dramatically.  Ah, the birth of a new era.

The Logical Choice for Tracking Numbers

Excel is an easy and logical choice for tracking numbers. It’s low cost, flexible and has a variety of useful features and functionality. But things change when a company’s business requirements grow. For example, if:

From Spreadsheets to Patch Work

This is where the patchwork comes in. Particularly if you’ve come to rely on Excel spreadsheets, the path of least resistance is often patchwork; whatever can be done to achieve the desired outcome as soon as possible.

Why? Because accountants are often already working long hours, so generating something quick inside an Excel spreadsheet is typically the default method.  Unfortunately, patchwork solutions often neglect important factors including documentation, controls, validation rules and audit considerations. Sooner or later, companies find themselves juggling a myriad of uncontrolled spreadsheets and spreadsheet-dependent processes.

Consider the following two scenarios:

Playing to Spreadsheet Strengths (Not Weaknesses)

Some will argue that using spreadsheets is playing to their strengths. Accountants today are very savvy with Excel, capable of complex functionality and some even capable of writing code to automate certain processes.  But there comes a point where playing to a strength eventually becomes working around a weakness.  Why does that happen?  We do what we do because at the time there isn’t really an alternative.

There are alternatives. Consider breathing new life into Excel by turning it into an enterprise-class platform. Look for a solution that combines:

Near the end of the Excel, patchwork lifecycle is when companies often start to shop and invest in an alternative. Be proactive and set your team up for success by anticipating future business requirements and inject proper systematic processes before your team gets into a state where every monthly process is a scramble to stay alive. And last but not least, embrace Excel by playing to its world-renowned strengths.

The post The Excel Lifecycle: A Collection of Patch Work appeared first on Blog | Vena Voice | Vena Solutions.

Recommended Posts

Ease of Use the #1 Driver of BPM Software Success, Survey Finds

June 17, 2020 |

Read More

How to Make an FP&A Mindset Part of Your Company DNA

June 16, 2020 |

Read More

3 Reasons Why the Time is Now for Finance to Adopt AI

June 11, 2020 |

Read More