The complexity of Swiss value-added tax often leads to errors in manual returns. An automated process chain ensures the correct application of all rules and creates a traceable audit trail.
The VAT return is a regular part of the finance team's rhythm. Whether quarterly or monthly, the goal is a correct and timely declaration to the Swiss Federal Tax Administration (ESTV). However, the path to achieving this is often marked by manual steps, complex rules, and the risk of human error. The regulations are constantly evolving. Many finance teams are therefore looking for ways to automate VAT returns in Switzerland. A well-designed automation not only ensures quality but also creates transparency and traceability for every closing.
The Pitfalls of Manual VAT Returns
The standard process in many Swiss SMEs begins with an export from the ERP system. The raw data — usually transaction journals or account ledgers — is imported into Excel. From this moment on, the manual work begins. Various tax codes must be correctly assigned, turnover and input taxes aggregated, and plausibility checks performed. This often involves using Excel templates and separate checklists that have grown over many years.
This approach is prone to errors. A checklist is only as current as its last revision and cannot enforce correct execution. Formulas in Excel can be accidentally overwritten, and links between different worksheets can break. Under the time pressure of a closing, the likelihood of careless mistakes increases. An incorrectly set filter or a forgotten summation can already lead to an incorrect return.
The complexity of value-added tax itself is another source of error. One example is the fictitious input tax deduction, for which specific conditions must be met (weka.ch 2026). Such special cases require deep specialist knowledge and careful examination for every single return. The Swiss Federal Tax Administration (ESTV) also regularly publishes clarifications and adjustments to its practice, such as on 12 November 2026 (Eidgenössische Steuerverwaltung ESTV 2026). Manually and consistently updating these changes in an existing process is a major challenge.
What an Automated Chain Achieves
An automated process chain closes the gap between the ERP system and the final return. It does not replace the ERP but automates the Excel layer that typically exists around it. The chain is a defined, programmed sequence that processes the data from export to the finished declaration. It ensures that the exact same, audited rules are applied every time it is run.
The process begins by taking the raw data from the ERP. The automation validates the data and classifies each transaction according to the stored business rules. These rules map the complex VAT regulations — including net tax rates, flat tax rates, and special cases — into a fixed logic. The system performs all necessary calculations and aggregates the values for the individual fields of the VAT form. The result is the final figures, ready for transfer to the ESTV portal.
- Direct processing of the standardised ERP export without manual adjustments.
- Application of fixed, programmed business rules for every transaction type and tax code.
- Automatic creation of a traceable audit trail for every calculation.
- Generation of the final figures in the structure of the official return form.
The Audit Trail: Traceability for Every Figure
A key result of automation is a complete audit trail. This audit trail is a detailed log that documents every step of the data processing. For every single figure in the final return, it shows which transactions and accounts it is composed of and which rules were applied. This transparency is of great value for internal control, for the audit, and for any queries from the tax authorities.
In a manual Excel file, this traceability is often not available. Formulas can be changed, cells can be overwritten with fixed values, and entire data ranges can be moved unnoticed. Months later, it is often impossible for anyone to reconstruct with certainty how a particular number came about. A machine-generated audit trail, on the other hand, is consistent and unchangeable. It provides proof of the return's correctness at the touch of a button and strengthens the finance team's confidence.
Automation is No Substitute for Expertise
An automated VAT return does not make the finance expert redundant. The opposite is true. The design and setup of such a process chain require deep expertise in Swiss value-added tax. The automation's logic must correctly reflect the legal requirements and the company's specific circumstances. Skopa works closely with the controller or CFO to translate their expertise into a robust technical solution.
The role of the finance team shifts with automation. Instead of spending hours or days manually compiling data, the work focuses on analysing the results. The specialist reviews the return generated by the machine, investigates any exceptions, and assesses the overall situation. The machine takes over the repetitive, error-prone work. The human makes the judgements, takes the decisions, and uses the time saved for more value-adding tasks.
What You Can Do This Month
Improving your VAT return begins with a clear assessment of your current procedure. You can already take the first steps to identify potential weaknesses in your process.
First, document your current process completely. Record every step, from exporting data from the ERP system to the final entry of the figures in the ESTV portal. Which people are involved? Which Excel files, templates, and checklists are used? Where do manual interventions or corrections take place?
Second, identify the biggest risks in this workflow. At which points do most errors typically occur? Which steps are completely manual and depend on the knowledge of a single person? Which calculations are particularly complex and difficult to trace?
Finally, check the traceability of your recent returns. Can you, today, trace every figure from your last three VAT returns back to the original transaction data without doubt and with efficiency? If the answer is no, or if the effort required is very high, you have found the most important starting point for automation.
Excel is a registered trademark of the Microsoft Corporation.
How the whole chain holds from export to filing, with no handover by hand, is on its own page. Complete automation →
Sources
- Eidgenössische Steuerverwaltung ESTV (2026) MWST: Publikationen zum Mehrwertsteuergesetz MWSTG, estv.admin.ch
- weka.ch (2026) Neu / Vorsteuerabzug MWST Voraussetzungen für den fiktiven Vorsteuerabzug, weka.ch

