1. How does the calculation of cumulative advance payments (Statements no. 1 to no. 12) work in the Excel file?
Each month, the workbook recalculates the cumulative progress since the start of the site, deducts the statements already invoiced and displays the amount for the month. You run no risk of forgetting an advance payment or invoicing the same work twice.
1.1 Why you should always invoice on cumulative progress (and deduct the previous statements) rather than with isolated invoices
Invoicing « the work of the month » without reference to the cumulative figure means losing track: a quantity correction or a change order is no longer found in the sequel. With the cumulative figure, statement no. 7 takes up everything that has been carried out and deducts the previous six: the final balance is known at any time and the final statement holds no surprises.
1.2 Automating cash retention money (Art. 149 to 152 SIA 118: 10% rule and the CHF 500'000 threshold at 5%)
According to the rule adopted by our tools, retention money is 10% of the value of the services up to CHF 500'000; beyond that, it is 5%, with a minimum of CHF 50'000 and a ceiling of CHF 2'000'000. The calculation applies to the total and not by bands. Check these articles in the edition of SIA 118 of your contract.
2. Accounting pitfalls and TVA (8.1%) in the final statement of a site
TVA and cash discounts are the two places where the most money is lost at the very end of a site, when attention drops.
2.1 How to treat Swiss TVA at 8.1% on retention money (accounting by agreed consideration versus consideration received with the AFC)
TVA is calculated on the service provided, not on the moment when the retention is released. During the works, only the net after retention is taxed under the received-consideration method; the amount before retention appears in the final statement. Confirm the method that applies to your company with the AFC (Federal Tax Administration) or your fiduciary.
2.2 Checking and reinstating the 2% cash discounts wrongly deducted when the client paid late (after 30 days)
Under SIA 118, the client who pays after 30 days loses the right to the cash discount. An automatic deduction of 2% on a late payment is therefore undue: the workbook compares the due date and the payment date and flags the cash discounts to be reinstated.
3. Frequently asked questions about advance payments and the SIA 118 final statement (FAQ)
3.1 Within what maximum period must the contractor submit its final statement under the SIA 118 standard?
SIA 118 sets a period for submitting the final statement after acceptance; the exact duration is to be read in the applicable edition. In practice, submit it within the month following acceptance: it triggers the review by the site management and the release of the retention.
3.2 Is a 10% retention money lawful if the contract does not mention the SIA 118 standard?
Without reference to SIA 118 or a clause of its own, the Code of Obligations (CO) provides for no retention money: it must result from the contract. A 10% retention is therefore enforceable only if the contract provides for it; if SIA 118 applies, it caps the retention as indicated above.
3.3 How do you replace cash retention with a joint and several surety (Art. 181 SIA 118) from acceptance?
Give the client a joint and several surety from a bank or an insurer, for the amount provided for by Art. 181 SIA 118: the client can then demand the release of the cash retention. Our file on surety contains the letter ready to send.
Keywords covered: final statement template Swiss site excel · monthly progress statement advance payment works xlsx · retention money calculation SIA 118 art 150 · retention ceiling 10% 5% 500000 CHF · invoicing cumulative progress Swiss building · TVA 8.1% on retention money.
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.