Format: XLSX / DOCX / PDFStandard: Excel · Word · PDF · SIA 118 Art. 62-65DOC 34
Price Escalation Billing File for Switzerland: Excel Calculation Sheet (KBOB / SIA 122 / SIA 123) & Letter Template
Complete 7-page guide (PDF) and Word template. Billing the cost increase between the quote and the end of the site: SIA 122, 123 and 124 methods, price variation clause, letters and a step-by-step spreadsheet.
Interactive tool: entitlement to price escalation and comparison of the ICP and parametric methods
Loading the tool…
📄 The « Brut de chantier » pack to download (free)
XLSXDOCXPDF
Price Escalation Billing File (KBOB / SIA 122 and 123)
Complete 7-page guide (PDF) and Word template. Billing the cost increase between the quote and the end of the site: SIA 122, 123 and 124 methods, price variation clause, letters and a step-by-step spreadsheet.
The three methods at a glance, legal basis, deadlines and procedure
The calculation sheet of the enclosed workbook, step by step
Cover letters, checklist of documents to attach, evidence checklist, frequent mistakes, practical case and cases where a lawyer should be consulted
Excel workbook (.xlsx) with formulas · Editable Word template (.docx) · Printable PDF document
1. How does the legal calculation of price changes between the offer and execution work (Art. 62 to 65 SIA 118)?
Price escalation is due only if the contract provides for it: adjustable prices, standard SIA 122 or 123, or a clause of its own. The cited articles of SIA 118 are to be checked in your edition.
1.1 The Production Cost Index method (ICP — Standard SIA 123) and deduction of the non-indexed fixed share of 20% (factor 0.80)
Price escalation is calculated as Amount × (1 − fixed share) × (index at calculation / index at offer − 1). With a fixed share of 20%, the factor is 0.80: on 250'000 CHF and an index increase of 6.5%, the price escalation is 13'000 CHF. The fixed share is an assumption of the workbook, to be checked in your contract.
1.2 The parametric method (Standard SIA 122 / KBOB Guide): custom weighting between Wages (fS), Materials (fM) and Fixed share (fF = 0.20)
The parametric method weights the increases: Amount × [fS × (wage index at calculation / at offer − 1) + fM × (materials index at calculation / at offer − 1)], with fS of 45%, fM of 35% and a fixed share of 20% in the workbook. These shares can be changed; those of the contract prevail.
2. Unit-price contract vs lump-sum contract: how to protect your offers against start-up delays
The longer the period between the offer and execution, the more unrealistic the offer price becomes.
2.1 Why the wording « Firm and non-adjustable prices » becomes a deadly trap when the site starts 10 months late
A firm price, accepted as it stands, commits you to execute at the offer price even if the site starts months later. Without a time-validity clause or price escalation, the increase in materials and wages is at your expense.
2.2 The time-validity clause for firm prices (e.g. 3 or 6 months maximum) to insert in every tender
State on every offer a validity of 3 to 6 months, and provide beyond that for price escalation under the SIA 122 or 123 method. If the site is delayed, you have a written basis for renegotiating.
3. Frequently asked questions about the KBOB price escalation calculation in Switzerland (FAQ)
3.1 What is the exact « reference date » to be used for the price escalation calculation (date of submission of the offer, Art. 62 SIA 118)?
As a general rule, the reference date is that of submission of the offer, but the contract may set another. Check the article of the applicable edition of SIA 118 or the clause of the contract.
3.2 Does price escalation apply automatically if the contract is subject to the SIA 118 standard with no contrary provision?
No: price escalation is due only if the contract provides for adjustable prices or a calculation method. According to our sheets, a lump-sum price designated as firm excludes price escalation. Read what is written.
3.3 What happens if the KBOB material indices fall between the tender and the site (price reduction)?
If the contract provides for adjustable prices, the adjustment works in both directions: a fall in the index results in a reduction. In that case the workbook calculates the price escalation with a negative result.
Keywords covered: price escalation calculation sheet construction Switzerland KBOB excel · parametric formula SIA 122 price increase materials wages · production cost index ICP SIA 123 SSE CRB · rule fixed share 20% factor 0.80 price escalation · reference date tender art 62 SIA 118 · invoicing increase steel concrete timber copper site.
General information based on Swiss law in force — does not replace personalised legal advice.
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.