Aller au contenu
Website
Format: XLSX / PDF Standard: Excel · PDF · SIA 118 · CFC DOC 02

Quote & Tender Bill of Quantities Template by CFC in Excel (Compliant with SIA 118 & TVA 8.1%)

A ready-to-fill quote: SIA 118 cover page, bill of quantities by CFC chapters and summary with discounts, cash discount, prorata and TVA 8.1%.

Interactive tool: net excluding VAT (HT), TVA (VAT) at 8.1%, total including VAT (TTC) and effect of deductions on the margin

Loading the tool…

📄 The « Brut de chantier » pack to download (free)

XLSXPDF

Quote & Bid Template by CFC

A ready-to-fill quote: SIA 118 cover page, bill of quantities by CFC chapters and summary with discounts, cash discount, prorata and TVA 8.1%.

  • Cover page: client, site management, contractor, SIA 118 conditions
  • Bill of quantities by CFC chapters 211, 221, 251, 271, 273
  • Summary: discount, cash discount, prorata account, civil liability (RC) and TVA
  • PDF: user guide for the template and blank forms (cover page, bill of quantities, summary) to print

Excel workbook (.xlsx) with formulas · Printable PDF document

1. Overview of the 3 sheets of the Excel tender template for Swiss contractors

The template contains only what is needed to submit an offer: a contractual cover page, a priced bill of quantities by chapter and a financial summary. The formulas are already in place; you only enter your quantities and your prices.

1.1 The contractual cover page (client, site management, express incorporation of the SIA 118 standard and validity period of the offer)

The cover page identifies the client, the site management and the company, then recalls that the offer is subject to the SIA 118 standard. It sets the validity period of the offer: without a deadline, your prices can be invoked months later, when materials have become more expensive.

1.2 The pricing bill of quantities structured by CFC chapters (SN 506 500) and standardised measurement units (m², m³, ml, pc, lump sum)

Each line gives a CFC chapter code, a description, a measurement unit (m², m³, ml, piece, lump sum), a quantity and a unit price. The workbook adds up by chapter (211 masonry, 221 windows, 251 sanitary, 271 plastering, 273 joinery) so that the architect can compare your prices with those of the other bidders.

1.3 The cascading financial summary: discount, cash discount, prorata retention and Swiss TVA at 8.1%

The subtotal of the chapters is reduced by the discount, any cash discount and the prorata account, then the TVA of 8.1% is calculated on the net amount. The order of the cascade matters: a cash discount calculated before the discount does not give the same amount. The workbook applies the usual order of tender conditions.

2. Which mandatory protective clauses should you leave at the bottom of your Excel quote?

A quote is not just a table of prices: its conditions decide who bears the contingencies. Two statements are enough to avoid most price disputes.

2.1 State « Unit prices invoiced on the actual measured quantities executed » rather than a risky global lump-sum price (Art. 373 CO)

With a lump-sum price, the contractor can in principle claim nothing more, even if the work requires more effort (Art. 373 para. 1 CO); only extraordinary circumstances that could not be foreseen allow the judge to intervene (para. 2). Stating « unit prices, invoiced on actual measured quantities » protects you from underestimated quantities.

2.2 Reservation on rising material prices (KBOB / SIA 122 price escalation) and time validity of the prices

Add a price escalation clause (SIA 122 method or KBOB indices) and a price validity of 3 to 6 months. An offer without reservation, accepted a year later, obliges you to perform at the old prices. Our file on price escalation details the formulas.

3. Frequently asked questions about drafting a quote for building works in Switzerland (FAQ)

3.1 Why must the SIA 118 standard always be mentioned explicitly on the cover page of the quote?

SIA 118 applies only if the parties declare it applicable. Without this mention, the Code of Obligations (CO) alone governs the contract: warranty periods, acceptance, retention money and unit prices are regulated differently there. The cover page removes the ambiguity.

3.2 In what mathematical order are the discount, the cash discount and the prorata account applied at the foot of the offer?

The usual practice is to deduct the discount from the subtotal first, then the prorata account, then to apply the cash discount to the balance paid within the deadline, with the TVA of 8.1% applied to the net amount. The contract may provide another order: the workbook shows the detail of each step so that you can check the result.

3.3 How do I import an architect's tender .01s or .crbx into an Excel spreadsheet without re-entering everything?

The .01s and .crbx tender files follow the SIA 451 standard. Our free converter reads them in the browser and produces an Excel workbook with the items, quantities and units: all that remains is to enter your prices in the bill of quantities.

Keywords covered: construction quote template Switzerland excel · tender bill of quantities CFC free xlsx · example building quote Switzerland TVA 8.1% · craftsman price offer template SIA 118 · tender cover page Switzerland · discount cash discount prorata account deduction quote.

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.

📥 Ready-to-use pack · free

Download the document

The file is displayed on screen right away and we also send it to you by e-mail.

Your address is used to send you this file. See our privacy policy.