The skilled labour shortage is an acute challenge for finance teams in Switzerland. Process automation is a strategic response to secure knowledge and strengthen corporate resilience.
The month-end closing follows a familiar rhythm. The figures are exported from the ERP system. They are available as raw data, often in the form of CSV or text files. Now the real work begins for the controlling and finance management teams: manual preparation in Excel. Data must be consolidated, key figures calculated, and variance analyses created. This process is routine, yet the pressure is constantly mounting. It is not just the time pressure that is felt anew each month. It is the growing concern about what happens if a key person is absent. The skilled labour shortage in the finance department in Switzerland is no longer a distant threat. It is an acute reality, driven by demographic change, and for many SMEs, it poses a strategic risk to their operational capability.
Demographic change is no longer a forecast
The high-birth-rate cohorts, the so-called baby boomers, are reaching retirement age. This is a simple statistical fact with far-reaching consequences for the labour market. With them, a generation of skilled professionals who have built up valuable experience and deep institutional knowledge over decades is leaving companies. This knowledge drain is particularly critical for finance teams. Experienced controllers or heads of finance who know the intricacies of accounting, the logic of internal cost allocations, and the history behind the figures in detail are retiring.
It is not just the ability to operate an Excel spreadsheet that is lost. What is lost is the understanding of the business context, the knowledge of historical special effects, and the confidence in dealing with complex accounting issues. Succession planning is becoming a major challenge. The search for suitable replacements is becoming increasingly difficult. The labour market for qualified finance professionals is tight. At the same time, younger generations often have different expectations of their work, particularly regarding technological equipment and the meaningfulness of their tasks. The gap created by the departure of experienced employees cannot always be closed easily and quickly.
The limits of traditional knowledge management
Companies often try to counter this loss of knowledge with documentation and handover protocols. This approach is necessary, but it quickly reaches its systemic limits. Much of what makes an experienced professional is implicit knowledge — a mixture of experience, intuition, and learned patterns. It is the understanding of the connections behind the figures, the intuition in troubleshooting, and the knowledge of informal processes that are not written down anywhere.
This knowledge is difficult to capture in a manual or a process description. When the person who has maintained a complex Excel file for group consolidation for years leaves the company, the crucial context is often lost. The file may remain, but the understanding of its structure, its manual adjustments, and its potential weaknesses diminishes. A successor may be able to understand the formulas, but they do not know the reason for a manual correction that was necessary once three years ago and has remained in the model ever since. This creates a significant operational risk in reporting. A scientific study shows that intellectual capital has a significant impact on a company's financial performance (Jurnal EMT KITA 2024). The loss of this capital through inadequately managed staff departures is therefore a direct business risk.
Automation as a structural response
Process automation offers a structural and sustainable answer to this challenge. It is not primarily about replacing employees. It is about making the finance team and its processes more resilient to staff changes and increasing overall efficiency.
Through automation, the logic of a process is explicitly mapped and embedded in a system. The process thus becomes traceable, standardised, and repeatable at any time. It is no longer dependent on the knowledge, availability, or daily form of a single person. The automation itself becomes living, constantly updated documentation. It does not run the risk of becoming obsolete, as is the case with a Word document.
This creates a stable chain — 'the chain' — from the raw data in the ERP to the final management report. This chain does not break if an employee leaves the company, falls ill, or goes on holiday. The continuity and reliability of financial reporting are secured. At the same time, the team is relieved of repetitive, error-prone, and low-value-added tasks. The freed-up time can be used for analysis, interpretation, and control of the figures — where human expertise is irreplaceable. This not only increases the quality of the finance function but also the attractiveness of the jobs for new talent.
Where to start? The Excel layer as a starting point
Comprehensive automation of the finance department is a major project. A pragmatic approach starts where the greatest manual effort and the highest personal risk lie. The ERP system is usually a stable and established entity. The requirements for the final reports are also clearly defined. The critical area often lies in between: the layer of manual processes in Excel that connects ERP exports with the reports.
This Excel layer is home to processes such as cost centre accounting, liquidity planning, the consolidation of subsidiaries, or the preparation of data for VAT returns. These processes have often grown historically, are insufficiently documented, and are heavily dependent on the person who originally created them. They are flexible, but also error-prone and non-transparent.
Automation at this point targets exactly the right area. It does not require the replacement of the existing and proven ERP system. The focus is on the efficiency and stability of the data processing chain. The importance of efficiency for financial performance is also well-documented in other areas. For example, a study in the construction sector showed that working capital efficiency is a relevant factor for sustainable financial performance (Al Ghifari 2027). This principle of efficiency can be directly applied to the internal processes of the finance department. Regulatory developments such as the automatic exchange of information in tax matters (Eidgenössische Steuerverwaltung 2026) are also based on the need for structured, reliable, and increasingly automated data processes.
What you can do this month
You do not have to wait for a large, company-wide initiative to act. You can start today to increase your team's resilience and prepare for the future. The first step is an honest inventory of existing processes.
Identify the most critical, repetitive, and person-dependent tasks in your month-end or quarter-end closing. Take an hour with your team and ask yourselves the following questions:
- Which report is the most time-consuming to create, measured in pure working hours?
- Which process is known in detail by only one person and could not be taken over by anyone else?
- In which work step do the most errors occur due to manual interventions, copying, and pasting?
- Which task most prevents your team from concentrating on the analysis and interpretation of the figures?
Select one of these processes — ideally the one that meets most of these criteria. Document it completely, from start to finish. A simple method is to record the screen during execution and comment on the steps. Alternatively, create a simple step-by-step guide with screenshots. Note down every click, every formula, and every manual adjustment from the ERP export to the final figure in the report.
This documentation is more than just a formality. It makes the process transparent and creates an objective basis for any further discussion about improvements. It is a first, concrete step towards securing implicit knowledge within the company and reducing dependence on individuals. This documented process is a valuable asset, regardless of what measures you take next.
Excel and Word are registered trademarks of the Microsoft Corporation.
Which of your routines is worth automating, we quantify beforehand — in your own hours. Potential analysis →
Sources
- Al Ghifari (2027) Pengaruh Green Financing, Working Capital Efficiency, dan Board Size terhadap Sustainable Financial Performance: Subsektor Heavy Constructions & Civil Engineering — Jurnal EMT KITA, doi.org
- Eidgenössische Steuerverwaltung (2026) Automatischer Informationsaustausch Schweiz–EU in Steuersachen: Bundesrat verabschiedet Botschaft zum Änderungsprotokoll, estv.admin.ch
- Jurnal EMT KITA (2024) The Effect of Green Accounting and Intellectual Capital on the Financial Performance of Companies in the Consumer Non-Cyclicals Sector Listed on the Indonesia Stock Exchange — Jurnal EMT KITA, doi.org

