Payroll

Adjusting for Cold Progression: Why Payroll Now Needs a Robust Process Chain

Emanuel Flury·08 November 2026·6 min read
A person in an office looks at a complex Excel spreadsheet on a monitor, their hand holding a pen over a notepad.

The annual adjustment for cold progression is more than a tax update; it is a stress test for your payroll accounting. An automated process chain ensures accuracy and compliance where manual procedures reach their limits.

The end of the year is approaching, and with it, the preparations for year-end closing. For Swiss SMEs, a specific task has been added this year that directly affects payroll. On 22 September 2026, the Federal Department of Finance (FDF) announced the adjustment of tariffs and deductions for direct federal tax (Eidgenössische Steuerverwaltung ESTV 2026). This measure serves to offset cold progression for the 2027 tax year. For finance departments, this means that the cold progression payroll processes in an SME must be reviewed and updated. Implementing these new rules will be a test of the stability and accuracy of existing procedures.

What the Adjustment Means for Your Processes

Cold progression describes the effect whereby employees, through a salary increase that only compensates for inflation, move into a higher tax bracket. Their purchasing power does not increase, but their tax burden does. The federal government is legally obliged to periodically compensate for this effect (Eidgenössische Steuerverwaltung ESTV 2026). The adjustment ensures that the tax burden does not increase if purchasing power remains the same.

The changes for the 2027 tax year are specific. The maximum permissible deduction for third-party childcare will rise to 25,900 francs. The deduction for job-related training and further education costs will be increased to 13,100 francs (Eidgenössische Steuerverwaltung ESTV 2026). These are not the only adjustments. They affect all tariff levels of the direct federal tax.

Furthermore, the cantonal tax administrations must also adjust their tariffs for tax at source. The new federal requirements lead to changes in the annex of the Withholding Tax Ordinance (Eidgenössische Steuerverwaltung ESTV 2026). For payroll accounting, this means a cascade of updates. It is not enough to simply change two deductions in a table. The entire calculation logic for taxes and deductions must be put to the test.

The Risks of Manual Payroll Processes in Excel

Many finance teams in SMEs use Microsoft Excel as a bridge between the ERP system and the final payroll run. Data is exported from the ERP and processed further in Excel spreadsheets. Calculations are performed, lists are created, and plausibility checks are carried out there. This approach is established and flexible, but it carries significant risks when regulatory changes occur.

Manual data transfers are a common source of error. A typing error when entering a new deduction limit or a changed tariff level can affect hundreds of payslips. Formula errors in complex spreadsheets are another danger. These models have often grown over years and are not always fully documented. A small change in one cell can have unintended consequences elsewhere.

Versioning presents an additional problem. If multiple copies of a file are used, it becomes unclear which one is correct. Adjusting for cold progression requires precise and traceable changes. A manual, Excel-based process makes it difficult to ensure compliance and create a clean audit trail. The pressure on the finance team increases, especially during the hectic period of year-end closing.

The Robust Chain: From ERP to Correct Payroll

The alternative to error-prone manual steps is an end-to-end automated process chain. This chain begins with exporting data from the ERP system and ends with the creation of final payslips, payment files, and reports for the authorities. Skopa automates the Excel layer that exists around the ERP. The ERP system itself is not replaced in this process.

In an automated chain, the data is automatically validated and prepared after export. Business rules, such as the new tax tariffs and deductions, are stored centrally and systematically applied to the entire dataset. Every step is standardised and repeatable. Manual interventions are reduced to a minimum.

The advantage lies in reliability and traceability. When a rule changes — as is now the case with the adjustment for cold progression — it is updated in a single place in the automated process. The change is then applied consistently to all affected employees. The result is a payroll system that is not only faster but also verifiably correct. The chain from the ERP export to the final payroll run becomes stable and transparent.

Automation as a Strategic Response

The automation of payroll accounting is more than a technical solution to a recurring problem. It is a strategic decision that strengthens the resilience of the finance department. It relieves qualified specialists of repetitive and error-prone tasks. The time saved can be used for control, analysis, and planning activities.

The general trend in technology confirms this path. Major software manufacturers are investing specifically in the automation of financial processes. Microsoft, for example, is developing new 'Copilot in Excel features for finance workflows' and is driving the development of agent-based ERP functions in Dynamics 365 (Microsoft 2026a). These tools aim to close the gap between raw ERP data and decision-relevant financial reports.

This development shows that the automation of processes like payroll is not a distant vision of the future. The technology is available and becoming increasingly accessible. It offers a concrete response to the rising complexity of the regulatory environment and the growing demands for accuracy and efficiency in finance departments.

What You Can Do This Month

A change in processes does not happen overnight. Careful preparation is the key to success. Regardless of whether you are aiming for full automation or want to improve your existing manual processes, the following steps will create a solid foundation.

  • Document the process: Map out the entire journey of your payroll data. Start with the export from the ERP and track every step through to the final filing of documents. Identify every manual data transfer, every calculation in Excel, and every manual check.
  • Assess the risks: Mark the points in your process map where the new rules on cold progression will apply. Where do new tariffs or deductions need to be stored? Evaluate the risk of error for each of these manual interventions.
  • Check master data: The quality of automation depends on the quality of the source data. Review the employee master data in your ERP system for completeness and accuracy. Incorrect or missing data is often the cause of problems in downstream processes.
  • Analyse interfaces: Examine the transitions between different systems. Where is data manually copied and pasted? These interfaces are often the weakest links in the process chain and the best candidates for initial automation.

Clear documentation of the current state is the first and most important step. It enables you to make informed decisions about the future of your payroll processes. This analysis provides the basis for any sustainable improvement.

Microsoft, Excel, Dynamics 365 and Power BI are registered trademarks 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 →

PayrollAutomationComplianceClosing

Sources

  1. Eidgenössische Steuerverwaltung ESTV (2026) EFD passt Steuertarife und -abzüge an Teuerung an, estv.admin.ch
  2. www.microsoft.com (2026a) Dynamics 365 Project Operations: Invoice usability enhancements, microsoft.com
  3. www.microsoft.com (2026a) Dynamics 365 Finance: Table edit with Microsoft Power BI filters and slicers, microsoft.com

written by

Emanuel Flury
Emanuel Flury

Founder of Skopa. Nearly ten years of process automation in Fortune-500 environments, today for Swiss SMEs.

intro call

Have a process we should talk about?

An intro call is non-binding and concrete: we look at a real workflow and tell you honestly whether and where automation pays off.