Skip to content
Website
Sign in Sign up
Template and resource

Downloadable Template: Reserve Accounts Spreadsheet (PDF)

Download our reserve accounts Excel template for Swiss construction SMEs: monthly provisions for 8.1% VAT, 13th-month pay, and social security contributions.

Table of contents
The 3 Major Site Risks
  1. Financial / Margin: A liquidity deficit during the quarterly AFC tax return or the year-end payment of the 13th-month salary, amounting to 40 000,00 CHF to 90 000,00 CHF for a ten-worker firm, leading to a cash flow crisis under the Code of Obligations.
  2. Legal / Joint Body / SUVA: Arrears on mandatory LAA, LPP social contributions or National Agreement joint funds, resulting in an in-depth joint inspection, audit fees, and formal notice served on the company.
  3. Administrative / Acceptance: Inability to obtain the social compliance certificates required for public tenders under the Federal Act on Public Procurement and the withholding of contractual advance payments governed by standard SIA 118.

This Excel workbook for managing reserve accounts is designed for Swiss construction SME owners, site managers, and administrative heads managing between 5 and 50 employees. It enables you to calculate and set aside each month in a dedicated bank account the amounts owed for VAT at the 8,1 % standard rate or net tax debt rate, the pro-rata share of the 13th-month salary agreed under art. 322 CO, holiday pay, as well as employer social security contributions for LPP, SUVA, and compensation funds.

Using this tool systematically during each monthly closing eliminates the false comfort of an apparently positive current account balance. It shields the contractor from quarterly cash-flow shocks from the Federal Tax Administration and secures relations with your fiduciary before any accounting close.

Downloadable document — XLSX (11 kB)

Monthly provisions for VAT, 13th-month salary, and social security contributions

Receive the document

Receive this document by email

Enter your address: the document is sent to you immediately. The link remains valid for 7 days. Your data is not shared with third parties.

Operational architecture and Excel workbook structure

The workbook is structured in xlsx format to ensure full compatibility with office management software used by Swiss SMEs. The document contains three strictly tiered tabs: the "Read Me" sheet, the "Parameters" sheet, and the "Provisions" sheet. This resource is aimed directly at business owners or internal accounting staff, working in close coordination with their external fiduciary. It should be updated on the last working day of each calendar month, immediately after generating the payroll summary and sales journal.

For any questions regarding tender pricing or quantity surveys based on the standard building description catalogue, please refer to the Soumissions section. Likewise, matters concerning collective agreement minimum wage scales fall under our dedicated recruitment section, while work verification tracking under standard SIA 118 is handled via the monitoring Portail.

Detailed sheet-by-sheet user guide

"Read Me" sheet

This sheet summarises internal financial governance rules. It sets out the respective responsibilities of executive management and administrative staff. It establishes the schedule of bank transfers to be executed to the restricted reserve account and describes the filing nomenclature for supporting documents sent to the fiduciary for quarterly audits.

"Parameters" sheet

This sheet centralises the contribution and tax rates applicable to the financial year. The user enters:

  • The VAT collection method: effective method at the 8,1 % rate or net tax debt rate (TDFN) method approved by the Federal Tax Administration.
  • Employer social insurance contribution scales: AVS/AI/APG contributions, accident insurance rates under the Ordinance on Accident Prevention and the LAA, occupational pension scheme (LPP) premiums, and contributions to joint compensation funds.
  • The reserve coefficient for the 13th-month salary and the provision for holiday entitlements required by the Code of Obligations.

The workbook locks these data points to prevent accidental changes within the monthly calculation grids.

"Provisions" sheet

This table serves as the monthly recording matrix. For each period, the manager enters the gross figures from issued invoices and gross wages paid. The workbook automatically computes the collected VAT net of deductible input tax, the exact employer share of social security contributions, and the accrued amount for the 13th-month salary. The check column then compares the theoretical calculated balance with the actual bank balance of the dedicated reserve account, flagging any financial allocation discrepancy.

Comparative table of provisioning practices

Risky wording / frequent mistakeCompliant formulation or practiceWhy
Keeping collected VAT in the operating current account.Monthly transfer of net VAT to a dedicated reserve bank account.Prevents collected taxes from being absorbed into material purchases or advance payments to subcontractors.
Waiting for the annual LPP fund statement to record the expense.Monthly provision calculated on the gross contributory payroll.Prevents a massive cash drain during the fourth-quarter regularisation.
Calculating the 13th-month salary solely on the December payroll.Monthly reserve allocation of one twelfth of gross contractual wages.Neutralises the impact of a doubled year-end payroll on operating margin.
Overlooking supplementary LAA accident insurance premiums.Inclusion of premium rates for occupational and non-occupational accidents.Ensures full coverage of contributions mandated by insurers recognised by the CNA.
Treating the overall bank balance as available cash flow.Systematic deduction of reserve accounts to establish net available cash.Gives a true picture of due liabilities without any false sense of surplus cash.
Omitting provisions for untaken holiday allowances.Periodic calculation of accrued entitlements under the provisions of the Code of Obligations.Secures the liquidity needed during employee departures or annual company shutdowns.

Critical errors prevented and financial impact

Failing to isolate deferred liabilities in a dedicated bank account is the primary cause of mid-year liquidity crises. Operating without a 13th-month reserve exposes a 10-person firm to an unexpected cash requirement of 50 000,00 CHF to 75 000,00 CHF in December. Likewise, an unplanned quarterly VAT adjustment can demand a payment of 25 000,00 CHF to 45 000,00 CHF, driving firms toward costly bank overdraft facilities. Rigorous use of the "Provisions" sheet neutralises these financial shocks by forcing the company to operate strictly within its actual working capital.

Illustrative practical cases (typical scenarios on Swiss construction sites)

The figures presented in the following scenarios are illustrative examples designed for methodological training.

Standard scenario in French-speaking Switzerland (Canton of Vaud)

A masonry and renovation firm of 12 employees carries out villa conversions and apartment building refits. At year-end closing, total cash showed 120 000,00 CHF in the operating account. Applying the provisions spreadsheet revealed 48 000,00 CHF owed for the 13th-month salary, 28 500,00 CHF for the quarterly VAT return, and 18 200,00 CHF in LPP and LAA social security contributions awaiting invoicing. The balance actually available for operations was only 25 300,00 CHF. Setting these funds aside beforehand in a separate reserve account protected the company from insolvency in January.

Standard scenario in an Alpine region (Canton of Valais)

A carpentry and roofing SME employing 8 workers operates on chalets and industrial roofs. Subject to seasonal variations, management completed the "Parameters" sheet each month with the net tax debt rate specific to their sector and local joint body contributions. This monthly discipline enabled the firm to methodically transfer an accumulated total of around 65 000,00 CHF into the reserve account between May and October. When winter site activity slowed, the company met its payroll and tax obligations without turning to emergency bank credit.

Frequently asked questions

How should you provision the 13th-month salary for a worker under a collective agreement?

The monthly set-aside amounts to 8,33 % of gross payroll. The employer pays the agreed wage in accordance with art. 322 CO. For an illustrative monthly wage of 6 250,00 CHF, set aside 520,65 CHF in a dedicated bank account.

What is the recommended transfer frequency to the VAT reserve account?

Execute a monthly transfer calculated on your actual receipts at the Swiss VAT rate of 8,1 %. For 85 000,00 CHF collected, transfer 6 369,10 CHF to avoid any shortfalls when filing the quarterly return with the Federal Tax Administration.

How can you offset cash-flow timing gaps for SUVA and LPP premiums?

Quarterly advance payments often underestimate the actual payroll. Provision approximately 15 % of gross wages each month for employer social security contributions. An illustrative reserve of 4 500,00 CHF prevents painful true-up charges when filing annual payroll declarations.

Where can you find wage grids to configure this reserve spreadsheet?

Minimum wage scales depend on each sector or canton. This document manages internal cash flow. To consult applicable minimum wages and collective agreements, please refer to our specialised section at /jobs/.

Does this template include quantity surveys or site unit prices?

No. The workbook exclusively secures cash reserves and alignment with your fiduciary. To prepare an itemised quote based on standard building description catalogues and price your tenders, visit our dedicated platform at /soumissions/.

Maintaining rigorous monthly provisions protects your SME from cash crunches when tax and social deadlines arrive. To advance your site financial management, explore the following complementary resources:

Art Construction is an independent company: it is not affiliated with the SIA, CRB, SUVA, or KBOB. Referenced norms and standards point to publications from these bodies; only official versions are legally binding.