Site Progress Payment Statement Calculator, Retention Money & TVA (VAT) 8.1%
Draw up the statement for an advance payment, the retention money and TVA (VAT) at 8.1%.
Interactive tool
A Your down payment status, in cumulative values
1 Contractual regime
Calculation cascade of the statement
- Net payable excl. TVA (HT)
- TVA 8,1 % (rounded to 5 centimes)
- Total incl. TVA (TTC) payable
- Calculated retention money
| Step | Amount (CHF) |
|---|
Retention: 10 % of the net value of the services up to 500'000 CHF; beyond that, 5 % but at least 50'000 CHF, at most 2'000'000 CHF (art. 150 SIA 118, as in the surety tool). The pro rata and the cash discount are calculated on the net amount of the services.
Embed this calculator on a website page
Paste this code into the page, or write [outil code="4.3"] in the content of a page on the site.
📄 Files and templates linked to this tool (free)
- XLSXPDF Final Account & Retention Calculator SIA 118 Situations 1 to 12 cumulated, advance payments deducted, retention money Art. 150 SIA 118, pro rata and TVA (VAT) 8.1%. See the file, its mini-tool and the pack →
- PDFDOCX ⚖️ Pure Law Client Termination Pack (art. 377 CO) & Suspension for Non-Payment Complete 7-page guide (PDF) and Word template. When the client cancels or does not pay: formal notice (mise en demeure) with a grace period, suspension, withdrawal from the contract, compensation spreadsheet and four letter templates. See the file, its mini-tool and the pack →
Move from calculation to full management
Keep your references at hand, then automate them in your quotes, bids and final statements.
Technical reference guide
The official calculation cascade of an advance-payment statement under the SIA 118 standard (Art. 144 to 152)
An advance-payment statement always follows the same cascade: the cumulative gross works, less the discount, give the net amount of the services; from this the guarantee retention, the pro rata deductions and the cash discount are deducted, then the advance payments already made; this gives the net amount payable excl. VAT (HT), to which VAT (TVA) is added. The guarantee retention calculation advance payment SIA 118 is based on article 150: 10 % of the value of the services; if the consideration exceeds 500'000 CHF, 5 % but at least 50'000 CHF, at most 2'000'000 CHF. The retention only falls due at acceptance, the final statement and the delivery of the surety (art. 152). The same rule is costed by the surety tool.
| Step | Amount (CHF) |
|---|---|
| Cumulative gross works excl. TVA (HT) | 150'000.00 |
| − Discount 5 % | −7'500.00 |
| = Net amount of the services excl. VAT (HT) (basis of the retention) | 142'500.00 |
| − Retention money (Art. 150 SIA 118) | −14'250.00 |
| − Prorata deductions 1,5 % | −2'137.50 |
| − Cash discount 2 % | −2'850.00 |
| − Previous net advance payments excl. TVA (HT) | −80'000.00 |
| = Net payable excl. TVA (HT) of the statement | 43'262.50 |
| + TVA 8,1 % (rounded to 5 centimes) | 3'504.25 |
| = Total incl. TVA (TTC) payable | 46'766.75 |
In exactly what order should the discount, the 10 % guarantee retention and the cash discount be deducted?
The order matters, because each deduction has its own basis. The discount is deducted first: it fixes the net amount of the services, on which the guarantee retention is calculated. The order of deduction discount cash discount building invoice is therefore as follows: the discount, then the guarantee retention, then the pro rata deductions (general contractor, cleaning, insurance, energy), finally the cash discount and the advance payments already made. In the tool, the pro rata and the cash discount are calculated on the net amount of the services; some contracts calculate them on the gross or after the retention: adapt the percentages to your contract.
| Cumulative net value of the works | Retention (Art. 150 SIA 118) | Share of the value |
|---|---|---|
| 100'000 CHF | 10'000.00 CHF | 10,0 % |
| 450'000 CHF | 45'000.00 CHF | 10,0 % |
| 500'000 CHF | 50'000.00 CHF | 10,0 % |
| 600'000 CHF | 50'000.00 CHF | 8,3 % |
| 1'000'000 CHF | 50'000.00 CHF | 5,0 % |
| 2'000'000 CHF | 100'000.00 CHF | 5,0 % |
| 5'000'000 CHF | 250'000.00 CHF | 5,0 % |
Why you must always prepare your statements in cumulative values and not in isolated tranches
A cumulative invoice works SIA 118 method adds up everything that has been carried out since the start of the site, then subtracts everything that has already been paid. This procedure automatically corrects the errors of previous statements, applies the right retention (which depends on the cumulative value) and avoids duplicates. With three statements of 60'000, 150'000 then 250'000 CHF of cumulative works, the net amount payable excl. VAT (HT) of each statement is always calculated from the cumulative total:
| Cumulative works excl. TVA (HT) | Net of the works | Retention | Net payable excl. TVA (HT) | TTC (TVA 8,1 %) |
|---|---|---|---|---|
| 60'000 CHF | 57'000.00 CHF | 5'700.00 CHF | 49'305.00 CHF | 53'298.70 CHF |
| 150'000 CHF | 142'500.00 CHF | 14'250.00 CHF | 73'957.50 CHF | 79'948.05 CHF |
| 250'000 CHF | 237'500.00 CHF | 23'750.00 CHF | 82'175.00 CHF | 88'831.20 CHF |
Statements 2 and 3 deduct the advance payments excl. VAT (HT) of the previous statements (excluding VAT (TVA)). Outside the SIA 118, the Code of Obligations provides no retention: it exists only if the contract provides for it, at a rate that the calculator lets you enter. To compare the two regimes, see the SIA 118 and CO comparator.
VAT (TVA) at 8.1 % on the guarantee retention: the rules of the Federal Tax Administration (AFC, VAT Info (Info TVA) 04)
The VAT (TVA) 8.1% advance-payment statement Swiss site is calculated on the net amount payable of the statement. Brochure no. 4 "Building industry" of the AFC (item 8.4) distinguishes two cases: during the works, when guarantee retentions are made on advance-payment requests and statements, only the net amount, after deduction of the retention, is taxed; at the final statement, the tax applies to the amount calculated before the deduction of the retention, whatever the accounting method. The VAT (TVA) on the retention is therefore not lost: it is due at the final statement.
With the default values, the final statement of a contract of 250'000 CHF gives a net amount payable excl. VAT (HT) of 149'187.50 CHF (the retention of 23'750.00 CHF is not deducted from the VAT (TVA) base), that is 161'271.70 CHF incl. VAT (TTC); the retention then remains a cash guarantee to be kept separately, or replaced by a surety. VAT (TVA) is calculated at the standard rate of 8.1 % and rounded to 5 centimes: round(amount × 20) / 20.
The brochure cited dates from 2007 to 2009 (valid until 31 December 2009) and the rates in its example are those of the time: the principle is taken up by the tool, but check the VAT Info (Info TVA) in force with the AFC. The number "04" is that of the brochure.
Accounting by agreed vs received consideration: impact on your VAT (TVA) cash flow
The accounting method changes neither the amount of VAT (TVA) nor the rule on retention: it changes the time at which VAT (TVA) is due (art. 40 LTVA).
| Method | When is TVA due? | Effect on cash flow |
|---|---|---|
| Agreed consideration | For the accounting period in which the statement is invoiced | You advance the VAT (TVA) to the AFC before the client pays |
| Consideration received | For the accounting period in which the payment is received | VAT (TVA) follows collection: no advance if the client pays late |
| Net tax debt rate (TDFN) | Industry rate set by the AFC, applied to the consideration | You invoice 8.1 % but pay over the net tax rate, without any input tax deduction |
A client who pays a statement at 60 days forces a company on the "agreed" method to finance the VAT (TVA) of that statement for those 60 days. The choice of method is made with the AFC, according to the conditions of the law: ask your fiduciary for advice.
Reverse charge (acquisition tax): the VAT (TVA) trap with a foreign subcontractor on a Swiss site
When a subcontractor has its seat abroad and is not entered in the Swiss register of taxable persons, the VAT (TVA) does not go through its invoice: it is the taxable recipient who declares the acquisition tax reverse charge foreign subcontractor at the rate of 8.1 % (art. 45 LTVA), calculated by the same rules as the VAT (TVA) on supplies made in Switzerland. On the net amount payable excl. VAT (HT) of 43'262.50 CHF in the example, the acquisition tax is 3'504.25 CHF; it is in principle recoverable as input tax if you are entitled to the deduction, but it must be declared in the right return.
The trap is twofold. First, the place of a service connected with a property is that of the property (art. 8 para. 2 let. a LTVA): for works on a Swiss site, the subcontractor may have to register for Swiss VAT (TVA) itself, and it will then invoice you the VAT (TVA). Second, paying a foreign subcontractor without VAT (TVA) and without declaring the acquisition tax exposes you to a back-tax claim with interest. Ask for the subcontractor's Swiss VAT (TVA) number, check it in the AFC register before the first payment and keep the proof in the site file. Tick "Foreign subcontractor" in the calculator to obtain the amount to declare.
Indicative information: the treatment of a specific service (subcontractor's tax liability, thresholds, procedure) must be confirmed by the AFC or your fiduciary. To check your subcontractors against the law on posted workers, see also the article 5 LDét checklist.
Frequently Asked Questions on Advance-Payment Statements, Guarantee Retention and VAT (TVA) (FAQ)
1. In what order should the discount, guarantee retention, cash discount and advance payments of a statement be deducted?
You always work in cumulative values: cumulative gross works, less the discount, which gives the net amount of the services (basis of the retention). From this you deduct the guarantee retention (art. 150 SIA 118), the pro rata deductions and the cash discount, then the advance payments already made, to obtain the net amount payable excl. VAT (HT), to which you add VAT (TVA). Example: 150'000 CHF of cumulative works − 5 % discount = 142'500.00 CHF; retention 14'250.00 CHF; pro rata 2'137.50 CHF; cash discount 2'850.00 CHF; advance payments 80'000 CHF: net amount payable excl. VAT (HT) 43'262.50 CHF.
VAT (TVA) of 8.1 % is calculated on this net amount and rounded to 5 centimes: 3'504.25 CHF, that is 46'766.75 CHF incl. VAT (TTC). In the tool, the pro rata and the cash discount are calculated on the net amount of the services; check the basis provided in your contract.
2. Is the 8.1 % VAT (TVA) calculated on the guarantee retention?
According to brochure no. 4 "Building industry" of the AFC (item 8.4), as long as retentions are made on advance-payment requests and statements, only the net amount, after deduction of the retention, is taxed. At the final statement, however, the tax applies to the amount calculated before the deduction of the retention, whatever the accounting method. In the example, the final statement of 250'000 CHF gives a net amount payable excl. VAT (HT) of 149'187.50 CHF, with no retention deducted, and 161'271.70 CHF incl. VAT (TTC).
The accounting method changes only the timing: with agreed consideration, VAT (TVA) is due for the period in which the statement is invoiced; with received consideration, for the period in which it is paid (art. 40 LTVA). The brochure cited dates from 2007 to 2009: check the VAT Info (Info TVA) in force with the AFC.
3. Must I invoice VAT (TVA) to a foreign subcontractor, or declare the acquisition tax?
If the subcontractor has its seat abroad and is not entered in the Swiss register of taxable persons, it is in principle you, as the taxable recipient, who declare the acquisition tax (art. 45 LTVA) at 8.1 % on the amount paid, instead of paying VAT (TVA) to the subcontractor. On a net amount payable of 43'262.50 CHF, the acquisition tax is 3'504.25 CHF; it is in principle recoverable as input tax if you are entitled to the deduction.
For works on a property in Switzerland, the place of the service is that of the property (art. 8 para. 2 let. a LTVA): the subcontractor may therefore have to register for Swiss VAT (TVA) itself. Ask for its Swiss VAT (TVA) number and check it in the AFC register before paying; in case of doubt, have the treatment confirmed by the AFC or your fiduciary.
Indicative information based on the SIA 118 standard (2013 edition), the VAT (TVA) act and brochure no. 4 of the AFC; it replaces neither the advice of your fiduciary nor that of the AFC.
