DWHPro Insights

The Most Dangerous System in Your Bank Runs on Excel

By Roland Wenzlofsky ·

The Most Dangerous System in Your Bank Runs on Excel

Critical spreadsheets need the same ownership, testing and audit discipline as other business applications; the previously attributed quotation is omitted because its primary source was not established.

1 ymoncdt8jij7exvictlrsw 1
Where is Gerhard?

There is a system in your bank that nobody calls a system. It has no documentation. It has no change management process. It has no backup strategy, no disaster recovery plan, and no access control beyond the fact that one person knows the password to the folder on the shared drive.

It processes regulatory data. It generates board reports. It calculates risk figures that are submitted to the financial supervisory authority.

It is an Excel file with macros. And the person who built it is either about to retire or has already left.

If you work in data warehousing for European banks — and I have done so for over 20 years — you know exactly what I am describing. You have seen it in every institution. Not as an exception. As a rule.


How It Happens

Nobody sets out to build critical infrastructure in Excel. It starts innocently. A business analyst needs a report that IT cannot deliver for another six months. The analyst builds it in Excel. It works. Management is satisfied. The report becomes a recurring deliverable.

Over the next two years, the spreadsheet acquires macros. It pulls data from three different sources via copy-paste. Someone adds a VLOOKUP that references another workbook on a different share. A pivot table is added for the monthly board presentation. A colleague adds conditional formatting so the risk figures turn red when they exceed a threshold.

By year three, it is no longer a spreadsheet. It is an application. It has business logic, data integration, transformation rules, and output formatting. It has everything a proper ETL pipeline has — except version control, testing, documentation, audit trails, and the ability to function when its creator is unavailable.

In the regulated world, this is not merely inconvenient. It is a compliance risk.


The Audit Problem

Regulators do not care whether a number was produced by a data warehouse or a spreadsheet. They care whether the process that produced it is documented, reproducible, and auditable.

A pipeline can support auditability when its code, releases, access, execution and reconciliation are controlled and evidenced. Moving logic to a database does not automatically satisfy every regulatory requirement.

An unmanaged Excel/VBA process may lack logs, version history and understandable logic. These controls are possible: export and version VBA, test calculations, control releases and access, and retain execution and reconciliation evidence. The problem is an unmanaged deployment, not an inherent inability to govern spreadsheets.

I have personally witnessed audit findings in European banks where the root cause was an undocumented Excel process that produced numbers for regulatory reporting. The remediation was not a technical fix. It was a project.


Why IT Cannot Solve It Alone

The standard response from IT departments is: “Put it in the data warehouse.” This is correct in principle. But it ignores reality.

The business analyst built the Excel solution because IT could not deliver on time. If IT now says, “Give us 12 months, and we will rebuild it properly,” the business hears the same message that caused the problem in the first place. The analyst will nod, agree, and continue using Excel.

The gap is not technical. It is organisational. Business teams need autonomy over their data processes. IT needs governance and control. These two requirements are in tension, and Excel has been the unofficial resolution for decades — a resolution that works until it does not.

What is needed is a middle ground: tools that give business teams the autonomy to manage their own data workflows and reporting, while enforcing the governance, auditability, and structure that regulators and IT require. This is not a new data warehouse. It is the layer between the data warehouse and the business user — the layer where Excel currently sits, unsupervised.


The Cost of Doing Nothing

Banks that tolerate Excel-based critical processes are accumulating risk in three dimensions:

Operational risk. A key person leaves, becomes ill, or simply makes a copy-paste error. The process breaks. The board report is delayed or incorrect. This happens more often than any CIO will publicly admit.

Regulatory risk. An auditor identifies an undocumented, non-reproducible process in a compliance-relevant data chain. The finding triggers a remediation project that costs more than the proper solution would have cost in the first place.

Efficiency loss. Senior analysts — people who should be analysing data — spend hours each month manually assembling, formatting, and distributing reports. This is not value creation. It is data logistics performed by the department’s most expensive people.


A Practical Alternative

1 xefcr jko8wghzienshzq 1

I have recently come across a company that addresses exactly this problem. ETIXPERT is a specialist for data-driven process automation in regulated industries — banking, insurance, and industrial organisations — with over 25 years of experience.

They offer two platforms that directly replace the Excel-based workflows I have described:

ETIXPERT describes Zagreus as a workflow/reporting offering. Its exact integrations and control capabilities were not independently verified here. Evaluate versioned workflows, access controls, execution logs, evidence retention and recovery against your regulatory scope; no product automatically establishes regulatory compliance.

ETIXPERT describes niota as a low-code data/workflow offering. Before adoption, verify current availability, authorization, tenant isolation, change history and traceability in a representative demonstration and contract. These are evaluation requirements, not tested capabilities in this article.

I want to be transparent: I mention them here because their solutions directly address a problem I have observed in nearly every banking and insurance project I have worked on. The recommendation is based on relevance to the topic, not a commercial obligation.


The Question to Ask

If you work in a European bank — or any regulated institution — ask yourself this: how many critical processes in your organisation currently depend on an Excel file that one person maintains?

If the answer makes you uncomfortable, that discomfort is the correct response.

The data warehouse handles the heavy lifting. But the last mile — where data becomes reports, decisions, and regulatory submissions — is where Excel still reigns. And it is where the risk sits.

Fixing the data warehouse is important. Fixing the last mile is urgent.


DWHPro works with a network of specialists. The proposed team, scope and delivery responsibilities are agreed for each engagement.


Written by Roland Wenzlofsky, founder of DWHPro and author of Teradata Query Performance Tuning. DWHPro has helped data warehouse practitioners for 15+ years.

Deciding what to change in your data platform?

Compare optimisation, modernisation and migration against your workload and business requirements.

Explore independent platform assessments

Practical data engineering insights, regularly

Join more than 3,500 data professionals: a regular newsletter with practical insights on data engineering, new data platforms (Snowflake, Databricks, Teradata) and AI.

Follow DWHPro in Google to see our articles more often in Search.

Get more practical data engineering advice

Join the DWHPro newsletter for practical data engineering tips, troubleshooting examples and data platform insights.

Protected by Security by CleanTalk and CleanTalk Anti-Spam