Skip to main content

The Hidden Cost of Solving Small Problems with Small Tools


Having worked for several companies over the years, one thing continues to surprise me: how often the same small operational problems come back. Different company, different industry, different people, different IT landscape, but remarkably similar frustrations.

These are rarely the big problems that make it onto a strategic roadmap. They are usually too small for that. None of these problems sounds particularly difficult to solve. And that is exactly why they often remain unsolved. Individually, they rarely justify a major software project or significant budget. Collectively, however, they consume a surprising amount of time.

A very typical example is time tracking. Many companies need employees to register time, but requirements often differ between departments, projects and types of employees. Another is expense management, where employees still regularly struggle with paying something on behalf of the company and getting reimbursed afterwards.

The same applies to subscription management. Companies increasingly have dozens of recurring software and service subscriptions spread across departments and employees. Knowing what subscriptions exist, who owns them, how much they cost, when they renew and whether they are still being used is surprisingly difficult. I wrote about this growing subscription jungle already several years ago in "Manage the New Jungle of Your Subscriptions" (https://bankloch.blogspot.com/2020/08/manage-new-jungle-of-your-subscriptions.html?utm_source=chatgpt.com).

Even something as basic as planning a meeting remains unnecessarily difficult, particularly when external people are involved. Internally, calendar systems can show availability, but as soon as people from several organizations participate, we are back to exchanging possible dates, using scheduling polls or sending multiple emails. The calendar should theoretically be one of our most integrated productivity tools, but there are still important gaps, something I discussed in "Your Digital Agenda: Cornerstone of Your Digital Life" (https://bankloch.blogspot.com/2020/04/your-digital-agenda-cornerstone-of-your.html?utm_source=chatgpt.com).

Other examples are even smaller. Organizing a group gift for a colleague, for example, usually results in somebody collecting money, maintaining a list of who has paid and sending reminders. It is a tiny process, but one that is repeated in almost every company. I wrote about this particular example in "Group Gift: A Precious Tradition Being Digitized" (https://bankloch.blogspot.com/2020/12/group-gift-precious-tradition-being.html?utm_source=chatgpt.com).
Similar gaps exist around employee availability and employee data management, where information about holidays, working locations, contact details, skills, responsibilities or other employee information is often distributed across HR systems, calendars, spreadsheets and collaboration tools. Read also my blog "A good employee directory - Why not part of the standard productivity tool set?" (https://bankloch.blogspot.com/2020/12/a-good-employee-directory-why-not-part.html") for more info.

And then there is task management, probably one of the clearest examples of functionality that exists everywhere and yet somehow remains fragmented. Outlook, for example, already allows emails to be converted into tasks and followed up, but these capabilities are still relatively rarely used in a structured way. Getting a simple overview of all tasks of a team can still be surprisingly difficult. Companies introduce Jira, Planner, Trello, Asana or other tools, while many tasks continue to live in emails, meeting notes, spreadsheets and people’s heads. See my blog "Streamlining Task Management: Can One Tool Fit All?" (https://bankloch.blogspot.com/2024/11/streamlining-task-management-can-one.html) for more info.

For almost every one of these problems, a software solution exists somewhere. But introducing a dedicated solution for every small operational gap quickly becomes unrealistic. Each new SaaS application comes with a subscription, implementation effort, user management, security reviews, training and support. More importantly, it adds another application to an already fragmented landscape. Before long, employees are switching between dozens of tools, often entering the same information multiple times because those tools are not properly integrated.

So companies tend to take the pragmatic route. Someone creates an Excel file. Another person builds a SharePoint list. A team starts maintaining something in Teams or Google Sheets. Perhaps somebody discovers an overlooked feature in Outlook or another application that is already available. Initially this works perfectly well. The problem is that a temporary workaround has a tendency to become a permanent business process.

Excel is probably the best example. It is incredibly flexible and almost everyone knows how to use it. For a small problem, creating a spreadsheet is often much easier than requesting a budget, selecting software and going through IT. But then the spreadsheet grows. More people start using it. Copies appear. Macros are added. Someone needs information from another system, so an export is added. After a few years, nobody is entirely sure which version contains the correct dataor how the spreadsheet actually works. What started as a clever solution to avoid unnecessary complexity has itself become complex.

There is another reason why these gaps are difficult to solve. They are often very company-specific. A standard SaaS product might solve 80 percent of the problem but miss the 20 percent that actually matters for a particular process. Sometimes the functionality is already available through configuration or customization, but nobody knows it. Because the application is relatively small, there is no real owner and certainly no internal expert who understands everything the tool can do. Buying another tool then seems easier than improving the one already there.

Generative AI is now changing this equation again. With AI-assisted development, or "vibe coding" as it is called, creating a small custom application has suddenly become much easier. An employee who would previously have built an Excel sheet can now create a simple web application. With surprisingly little effort, it can have a proper interface, workflows, validations and even integrations. For many of these small software gaps, the result can be significantly better than yet another spreadsheet.

This is a very interesting evolution, but it also introduces a new risk. The fact that we can build software much more easily does not necessarily mean that we should build more software.

When development was expensive, there was a natural pressure towards reuse. If one department invested substantial time and money in developing an application, other departments were encouraged to use the same solution. Today that barrier is disappearing. If every department can create its own small application in a few days, why bother aligning with another department? Why compromise on requirements when you can simply build exactly what you need?

The consequence could be a new generation of shadow IT. Instead of hundreds of uncontrolled Excel files, companies may end up with hundreds of uncontrolled small applications. And unlike a spreadsheet, an application introduces additional questions. Who maintains it when something breaks? Who updates the libraries it depends on? Who checks its security? Where is the data stored? Who manages access rights? What happens when the employee who created it leaves the company? And how does it exchange information with the rest of the organization?

The initial development cost may have fallen dramatically, but the lifecycle costhas not disappeared. In some cases it has simply become less visible.

This is why I believe the real opportunity created by AI is not necessarily to let everyone build more standalone applications. It is to make existing integrated platforms much easier and cheaper to extend.

Most companies already have several platforms that could potentially cover many of these small gaps: ERP systems such as SAP, Oracle or Odoo, CRM platforms such as Microsoft Dynamics, HubSpot or Salesforce, productivity suites from Microsoft or Google, HR platforms, and increasingly even banking applications. These platforms already have users, authentication, permissions, data models and integrations. Extending them therefore starts from a very different position than building another standalone tool.

ERP systems are particularly interesting in this context because many of the small operational gaps eventually come back to shared company data. Employees, customers, suppliers, projects, expenses, working hours, invoices, products and subscriptions are not isolated concepts. They are connected. The more applications that independently maintain copies of this information, the more reconciliation becomes necessary.

And reconciliation has a cost that companies often underestimate. An employee spending five minutes copying information from one system to another does not generate an IT invoice, so the cost remains largely invisible. The same is true for colleagues comparing two spreadsheets, correcting inconsistent data, searching for the latest version of a file or asking somebody on Teams whether information is still up to date. Multiply those small actions by hundreds of employees and hundreds of working days, and suddenly the "cheap" solution is not so cheap anymore.

Platforms such as Odoo are interesting examples of a possible middle ground. They combine many business functions within one environment while remaining relatively easy to extend. The open-source model also makes deeper customization possible when required. Combined with AI-assisted development, this could make relatively small extensions economically viable without automatically creating another isolated application and another copy of company data.

This does not mean that every process should be forced into an ERP system. Sometimes a specialized SaaS product really is the better solution, and sometimes an Excel file genuinely is all that is needed. The objective should not be centralization for the sake of centralization. The question should rather be whether a small local solution is still local once it starts depending on shared data, multiple employees or recurring business processes.

AI will make software creation increasingly accessible. That is undoubtedly a good thing. Many frustrating gaps that were previously too small to justify development can finally be addressed. But companies will need to resist the temptation to treat the lower cost of creating software as proof that the total cost of software has disappeared.

Perhaps the next step in digitalization is therefore not an explosion of thousands of individually generated applications. It could be the opposite: using AI to finally close all those small gaps inside a coherent landscape, where applications share data, common components and governance.

For years we accepted spreadsheets, manual re-entry and endless small alignments because solving each problem properly seemed too expensive. AI is changing that calculation. The opportunity now is to solve those problems without replacing spreadsheet sprawl with application sprawl, and to use the technology to make our existing platforms fit the way companies actually work.

Comments

Popular posts from this blog

Transforming the insurance sector to an Open API Ecosystem

1. Introduction "Open" has recently become a new buzzword in the financial services industry, i.e.   open data, open APIs, Open Banking, Open Insurance …​, but what does this new buzzword really mean? "Open" refers to the capability of companies to expose their services to the outside world, so that   external partners or even competitors   can use these services to bring added value to their customers. This trend is made possible by the technological evolution of   open APIs (Application Programming Interfaces), which are the   digital ports making this communication possible. Together companies, interconnected through open APIs, form a true   API ecosystem , offering best-of-breed customer experience, by combining the digital services offered by multiple companies. In the   technology sector   this evolution has been ongoing for multiple years (think about the travelling sector, allowing you to book any hotel online). An excelle...

RPA - The miracle solution for incumbent banks to bridge the automation gap with neo-banks?

Hypes and marketing buzz words are strongly present in the IT landscape. Often these are existing concepts, which have evolved technologically and are then renamed to a new term, as if it were a brand new technology or concept. If you want to understand and assess these new trends, it is important to   reduce the concepts to their essence and compare them with existing technologies , e.g. Integration (middleware) software   ensures that 2 separate applications or components can be integrated in an easy way. Of course, there is a huge evolution in the protocols, volumes of exchanged data, scalability, performance…​, but in essence the problem remains the same. Nonetheless, there have been multiple terms for integration software such as ETL, ESB, EAI, SOA, Service Mesh…​ Data storage software   ensures that data is stored in such a way that data is not lost and that there is some kind guaranteed consistency, maximum availability and scalability, easy retrieval...

IoT - Revolution or Evolution in the Financial Services Industry

1. The IoT hype We have all heard about the   "Internet of Things" (IoT)   as this revolutionary new technology, which will radically change our lives. But is it really such a revolution and will it really have an impact on the Financial Services Industry? To refresh our memory, the Internet of Things (IoT) refers to any   object , which is able to   collect data and communicate and share this information (like condition, geolocation…​)   over the internet . This communication will often occur between 2 objects (i.e. not involving any human), which is often referred to as Machine-to-Machine (M2M) communication. Well known examples are home thermostats, home security systems, fitness and health monitors, wearables…​ This all seems futuristic, but   smartphones, tablets and smartwatches   can also be considered as IoT devices. More importantly, beside these futuristic visions of IoT, the smartphone will most likely continue to be the cent...

A bank account - A concept of the past

Almost every recent article written about banking starts with the statement that the   banking industry is being disrupted   by new competitors, new innovations and new technologies. Although this statement is definitely true, the extend of the disruption can still be debated. Even the most innovative neo-banks still work with bank (current, saving, term and investment) accounts, cards (credit and debit), traditional credits, existing payment infrastructure…​ The user experience surrounding the origination and servicing of these products has dramatically improved (and will continue to evolve), but the underlying banking products are not really disrupted. You could argue that banking products are so intertwined with society and our way of thinking about finance, that they can’t be disrupted, but looking at those products you cannot ignore that they are far from an optimal solution in our current digital world. Let’s consider   cards   for example. Isn’t ...

AI in Financial Services - A buzzword that is here to stay!

In a few of my most recent blogs I tried to   demystify some of the buzzwords   (like blockchain, Low- and No-Code platforms, RPA…​), which are commonly used in the financial services industry. These buzzwords often entail interesting innovations, but contrary to their promise, they are not silver bullets solving any problem. Another such buzzword is   AI   (or also referred to as Machine Learning, Deep Learning, Enforced Learning…​ - the difference between those terms put aside). Again this term is also seriously hyped, creating unrealistic expectations, but contrary to many other buzzwords, this is something I truly believe will have a much larger impact on the financial services industry than many other buzzwords. This opinion is backed by a study of McKinsey and PWC indicating that 72% of company leaders consider that AI will be the most competitive advantage of the future and that this technology will be the most disruptive force in the decades to come. Deep Lea...

PFM, BFM, Financial Butler, Financial Cockpit, Account Aggregator…​ - Will the cumbersome administrative tasks on your financials finally be taken over by your financial institution?

1. Introduction Personal Financial Management   (PFM) refers to the software that helps users manage their money (budget, save and spend money). Therefore, it is often also called   Digital Money Management . In other words, PFM tools   help customers make sense of their money , i.e. they help customers follow, classify, remain informed and manage their Personal Finances. Personal Finance   used to be (or still is) a time-consuming effort , where people would manually input all their income and expenses in a self-developed spreadsheet, which would gradually be extended with additional calculations. Already for more than 20 years,   several software vendors aim to give a solution to this , by providing applications, websites and/or apps. These tools were never massively adopted, since they still required a lot of manual interventions (manual input of income and expense transaction, manual mapping transactions to categories…​) and lacked an inte...

Can Augmented Reality make daily banking a more pleasant experience?

With the   increased competition in the financial services landscape (between banks/insurers, but also of new entrants like FinTechs and Telcos), customers are demanding and expecting a more innovative and fluent digital user experience. Unfortunately, most banks and insurers, with their product-oriented online and mobile platforms, are not known for their pleasant and fluent user experience. The   trend towards customer oriented services , like personal financial management (with functions like budget management, expense categorization, saving goals…​) and robo-advise, is already a big step in the right direction, but even then, managing financials is still considered to be a boring intangible and complex task for most people. Virtual (VR) and augmented reality (AR)   could bring a solution. These technologies provide a user experience which is   more intuitive, personalised and pleasant , as they introduce an element of   gamification   to t...

From app to super-app to personal assistant

In July of this year,   KBC bank   (the 2nd largest bank in Belgium) surprised many people, including many of us working in the banking industry, with their announcement that they bought the rights to   broadcast the highlights of soccer matches   in Belgium via their mobile app (a service called "Goal alert"). The days following this announcement the news was filled with experts, some of them categorizing it as a brilliant move, others claiming that KBC should better focus on its core mission. Independent of whether it is a good or bad strategic decision (the future will tell), it is clearly part of a much larger strategy of KBC to   convert their banking app into a super-app (all-in-one app) . Today you can already buy mobility tickets and cinema tickets and use other third-party services (like Monizze, eBox, PayPal…​) within the KBC app. Furthermore, end of last year, KBC announced opening up their app also to non-customers allowing them to also use these thi...

Marketplaces in the financial industry - Here to stay?

Marketplaces are   hip and trendy   on the internet and will likely evolve even more in the near future. In some markets (like food delivery, transportation, commerce, holiday…​) they already represent double digit market shares (e.g. in 2018 $1.86 trillion was spent globally on the top 100 online marketplaces), but for the financial services sector, their impact (even though there are a few unicorn FinTechs in this space) on the industry is still limited. Any form of   intermediation   (travel agents, taxi dispatchers…​) will likely be replaced by a modern, digital and more direct equivalent, i.e. a digital marketplace. As the business of banks is exactly the intermediation between people having excess money and people needing money, the financial services sector will be significantly impacted. Furthermore, marketplaces are strongly intertwined with other concepts like the   gig-economy, the sharing-economy and the API-economy . All these trends will ultimately...

Innovation is the key to solve our climate issues (part 2) - The financial services sector as change enabler

Last week I published the first article of this series of 3 blogs ( https://bankloch.blogspot.com/2020/08/innovation-is-key-to-solve-our-climate.html ), introducing how our climate issues can be solved through a worldwide roll-out of   technological innovations   and by ensuring that these   innovations are economically viable . In order to ensure this viability, a drastic change in the behavior of all corporate stakeholders needs to be established. This second blog focuses more specifically on what the   Financial Services sector can bring to the table . Although the financial services industry does not generate much global warming emissions itself, they are perfectly positioned to support and enhance this change thanks to their large influence on the decision process of companies and consumers. As such they can be a big part of the solution, when they put their influence to good use. With 70% of banks recognizing that   climate change poses serious financial r...