1. Structure of the 3 sheets of the Excel hourly cost price workbook (Gross pay, Employer contributions and Profitability)
The workbook follows the path of the money: from the gross wage paid to the worker to the rate you can invoice as daywork. Each sheet uses the 2026 parameters of our online tools and remains editable.
1.1 Sheet 1 — Base salary, pro-rata 13th-month salary (+8.33%) and provisions for holidays and public holidays by age
The first sheet starts from the monthly gross salary and adds the pro-rata 13th-month salary, i.e. one extra twelfth (8.33%). Holidays and public holidays are not add-ons: they are included in the 2'112 hours paid per year (176 hours per month), which are not all billable. The number of holiday days depends on age and on the collective agreement: adapt the corresponding cell for apprentices and young workers.
1.2 Sheet 2 — The 8 Swiss employer contributions (AVS/AI/APG 5.3%, AC 1.1%, cantonal CAF, SUVA LAA-P, LPP, IJM and FAR 6% / RESOR 1.25%)
The AVS/AI/APG (5.3%) and unemployment insurance (AC, 1.1%, up to the insured earnings ceiling of CHF 148'200 per year) are completed by family allowances (CAF; cantonal rate, 2.65% on average in the workbook), occupational accident insurance (LAA), occupational pension (LPP), daily sickness allowance insurance (IJM) and early retirement: FAR at 6% in structural work, RESOR at 1.25% in finishing work. The workbook uses 34% of contributions in structural work and 25% in finishing work and building services; replace them with your actual rates.
1.3 Sheet 3 — From the 2'112 paid hours to the 1'620 billable productive hours and inclusion of overheads
From the 2'112 paid hours, you have to deduct holidays (about 212 hours), public holidays (76 hours), sickness and accident absences (68 hours on average) and the hours for preparation, loading, travel and bad weather (136 hours): about 1'620 productive hours remain, i.e. 135 hours per month. The annual cost divided by these hours gives the cost price; overheads (22% to 25%) and the margin are then added to reach the daywork rate.
2. The 3 Excel formula errors that destroy the margin of small building firms
A spreadsheet that calculates correctly on paper can lose thousands of francs over a financial year. The two pitfalls below come up most often in management audits.
2.1 Forgetting that the FAR contribution (6% in structural work) and SUVA also apply to the 13th-month salary
Many templates multiply the base salary by the contributions, then add the 13th-month salary without contributions. Yet contributions are calculated on the determining salary, 13th-month salary included: the real coefficient in structural work is 1.0833 × 1.34, i.e. 1.4517, and not 1.34 + 0.0833. For CHF 6'000 gross, the gap exceeds CHF 300 per month and per worker.
2.2 Omitting the unavoidable agreement-based costs (meal allowances of CHF 16 to 18/day, travel-time threshold and personal protective equipment (EPI))
Meal allowances (CHF 16.00 to 17.50 in structural work, CHF 18.00 to 19.00 in finishing work depending on the agreement), travel minutes paid beyond the threshold and personal protective equipment are due whatever the site. Our grid sets them at CHF 616 per month in structural work and CHF 595 in finishing work: do not leave them in the overheads.
3. Frequently asked questions about the Excel file for hourly cost in construction (FAQ)
3.1 How do I adapt the Family Allowance Fund (CAF) rate to my canton in the Excel file?
Family allowances are financed by the employer at the rate set by the cantonal fund; it varies from one canton to another. The workbook proposes 2.65% on average: replace it with the rate on your last fund statement, or compare the 26 cantons with our employer contributions comparator.
3.2 Do flat-rate lunch meal allowances have to be subject to AVS contributions in the spreadsheet?
Allowances paid to reimburse actual expenses (meals taken away from home) are in principle not determining salary as long as they stay within the limits of the agreement. The workbook treats them as agreement-based costs, outside the contribution base: have the treatment confirmed with your compensation fund and your fiduciary.
3.3 What is the difference between the direct hourly cost price and the hourly break-even point with overheads?
The direct cost price adds salary, contributions and agreement-based costs, divided by the productive hours. The break-even point adds the share of overheads (22% to 25%): below it, you work at a loss even though the worker is paid. The daywork rate then adds the margin.
The articles of the Code of Obligations (CO), the Civil Code (CC), the Criminal Code (CP), the Debt Enforcement Act (LP), the AVS Act (LAVS), the Accident Insurance Act (LAA) and the Posted Workers Act (LDet) cited were re-read on Fedlex on 6 November 2026. The articles of the SIA 118 standard, which is not freely available, are given according to our fact sheets and must be checked in the edition applicable to your contract. Updated: 7 November 2026.