Free · 2026 edition
A lightweight template for Swiss SMEs with up to ten employees. Updated 2026 rates, salary statements, accounting vouchers and annual totals — all in one workbook.
ARITHMA PAYROLL · AUSGABE 2026
Lohnbuchhaltung 2026
Eine schlanke Excel-Vorlage für Schweizer KMU bis zehn Mitarbeitende.
AHV/IV/EO 5.3%, ALV1 1.1%, ALV2 abolished. FAK, accident insurance and BVG remain input fields — they're policy and canton-specific.
Per employee, a dedicated salary sheet with master data, monthly entries and annual summary. Joining and leaving dates are configurable.
Print-ready monthly salary statement. Right-click the logo placeholder, drop in your company's logo, done.
Debit/credit per month — ready to transfer into your accounting software. Differences are flagged automatically.
The basis for Lohnausweis and the AHV year-end statement. All 612 sum cells are computed automatically.
Input cells are editable; formulas and fixed rates are locked — no accidental breakage of the calculation logic.
One workbook with everything you need for Swiss payroll.
Six-step guide. Brand logo, clear typography.
Current 2026 contribution rates. Notes on each rate.
Master data for up to 10 employees. Dropdowns for gender, vacation and status.
Per employee, one salary sheet. Monthly salary, hours, bonus, expenses, deductions automated.
Print-ready per month and per employee. Placeholder for your company logo.
Debit/credit ready for your accounting software. Auto-checked balance.
Annual totals for Lohnausweis and the AHV year-end statement.
Enter your email — we'll send you the download link instantly.
Nothing. It's completely free, no strings attached. We only use your email to send you the download link.
AHV/IV/EO 5.3% (employee/employer each), ALV1 1.1% up to CHF 148,200, ALV2 0% (abolished as of 01.01.2025). FAK, accident insurance, KTG and BVG remain input fields — they're policy and canton-specific.
Up to 10. Each employee gets their own salary sheet with master data and monthly values. For more than 10 employees, we recommend dedicated payroll software.
Complex special cases: multiple pension funds, international employees, withholding tax with spouse splitting. Those belong in dedicated payroll software or with your fiduciary.
You can edit the rates in the 'Rates' sheet at any time. All calculation formulas in the workbook reference those cells.