Skip to content
Website
Sign in Sign up
Template and resource

Download Template: 13-Week Cash Flow Spreadsheet (Excel)

Download the 13-week cash flow Excel template for Swiss construction SMEs. Manage site WCR and safety reserves to prevent cash shortfalls.

Table of contents
The 3 Major Site Risks
  1. Financial / Margin: Liquidity shortfall due to delayed advance payments causing a cash gap of around 80 000 CHF to 150 000 CHF, triggering a default interest of 5% per annum pursuant to art. 104 CO in case of default towards suppliers.
  2. Legal / Joint Body / SUVA: Late payment of social contributions and CLA wages leading to formal notice from the creditor under art. 102 CO and triggering audits by the cantonal joint committee.
  3. Administrative / Acceptance: Blocked release of retention money under standard SIA 118 during joint inspection, depriving the company of 10% of its final cash flow for several months.

This operational spreadsheet in xlsx format allows business owners and site managers to accurately model cash inflows and outflows over a rolling 13-week horizon. The tool integrates working capital requirement calculations specific to construction sites in French-speaking Switzerland, tailored to absorb review periods for monthly payment applications and the temporary freeze of retention money.

Implemented right from internal work preparation, this workbook prevents cash crunches caused by delays in advance payments from the client and secures monthly reporting with the fiduciary. It allows you to size a liquid safety reserve matched to the firm's fixed overheads, thereby avoiding unplanned recourse to expensive bank overdrafts.

Download document — XLSX (14 ko)

13-week cash flow, site WCR and safety reserve

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.

Architecture and operational deployment of the Excel workbook

This workbook in xlsx format contains four interconnected worksheets, designed to be operated by the administrative manager together with the site manager and the business owner. It is updated on a strict weekly basis, every Friday afternoon, in order to anticipate the following week's disbursements and validate reconciliations sent to the fiduciary.

The file structures the company's financial flows across four mandatory sections:

  • "ReadMe" sheet: Summarises input conventions, calculation versions and the formula cell-locking policy.
  • "Parameters" sheet: Centralises Swiss VAT rates at 8,1%, contractual payment terms by creditor category and cash safety reserve targets.
  • "13-Wk Cash Flow" sheet: Matrix breaking down expected receipts and mandatory disbursements over a rolling thirteen calendar-week horizon.
  • "Site WCR" sheet: Dynamic modelling of working capital requirements specific to each project, factoring in invoicing time lags and retention money under standard SIA 118.

Column-by-column user guide for the cash flow matrix

Operating the "13-Wk Cash Flow" sheet relies on rigorous input of financial flows, without unverified extrapolations:

Identification and reference budget columns (columns A to D)

The manager enters the transaction code, the description of the job or cost account, as well as the monthly target budget approved by management. The workbook categorises outflows into direct operating expenses, net payroll, social security contributions (AVS, AI, APG, LAA, LPP) and administrative overheads.

Rolling weekly columns W1 to W13 (columns E to Q)

For each row, the user logs projected net cash flows on the exact calendar week:

  • Inflows: Only advance payment applications formally certified by site management are entered under the probable collection date. Disputed amounts or items under negotiation are excluded from confirmed liquidities.
  • Outflows: Recording firm due dates for supplier invoices, advance payments to subcontractors, withholding tax statements, VAT and wage payments on the 25th of the month.
  • What the workbook calculates: Net weekly cash balance, consolidated end-of-week bank position and mathematical variance compared to the initial working capital plan.
  • What to check: Complete absence of a negative projected balance across any of the thirteen weeks, and keeping the cash cushion above the alert threshold set in the parameters.

"Site WCR" sheet: project-level exposure modelling

This sheet requires entering the contract volume in CHF, material order schedules, labour cycles and the contractual retention money percentage. The workbook automatically calculates cumulative cash exposure by construction site. The site manager verifies that the mobilization advance or interim payments are sufficient to fund procurement before acceptance of the work.

Comparative table of cash flow management practices

Risky wording / frequent mistake Compliant formulation or practice Why
Entering an issued payment application as a collection at 30 firm days. Apply the actual average payment date observed after sign-off by site management (often 45 to 60 days). Avoids an artificial cash gap masking formal review delays under standard SIA 118.
Budgeting total revenue without separating out retention money. Deduct retention money from monthly cash inflows until the joint and several guarantee is delivered. Retention freezes 5% to 10% of the works value, making it unavailable to pay suppliers.
Smoothing payable VAT linearly across the twelve months of the financial year. Position the actual quarterly VAT return on its exact payment date (60 days after the end of the quarter). An unexpected VAT payment of 40 000 CHF to 90 000 CHF instantly drains the current account.
Allocating advance payments from a new job to settle debts from an earlier project. Isolate WCR tracking for each project in the workbook's dedicated sheet. Cross-financing between construction sites conceals an unprofitable contract and accelerates insolvency.
Delaying payment of social contributions to absorb a client payment lag. Draw on the bank safety reserve and meet the statutory deadlines of compensation funds. Joint compensation funds and SUVA take swift enforcement action that suspends access to public procurement.
Overlooking cash flow lag caused by change order work. Refuse to commit costs on addenda without written agreement on corresponding advance payments. The contractor advances labour and materials without short-term payment guarantees.

Critical mistakes locked down by the document

Systematically updating this spreadsheet prevents four recurring pitfalls on the French-speaking Swiss market:

  • Month-end cash crunches during payroll runs: The model flags cash shortfalls for wages and social security contributions seven weeks in advance, preventing shortfalls of 60 000 CHF to 180 000 CHF.
  • The scissor effect on bulk material purchases: Sizing WCR prevents committing purchase orders without advance payment coverage, avoiding operating deficits of 45 000 CHF to 120 000 CHF.
  • The profitability illusion of gross bank balances: Excluding funds ring-fenced for VAT and taxes prevents making unfinanced investments.

Illustrative practical cases (typical scenarios on Swiss construction sites)

The figures shown below are illustrative examples constructed to demonstrate how the workbook works in practice:

In the canton of Vaud, a masonry company with 18 employees is preparing a residential building site. In the "Site WCR" sheet, the site manager enters an estimated contract volume of 850 000,00 CHF excl. VAT. The construction schedule requires the immediate purchase of rebar and formwork for 140 000,00 CHF, while the first advance payment from the client will only occur at the end of the second month following joint quantity surveys.

Projections in the "13-Wk Cash Flow" sheet reveal a potential overdraft of 95 000,00 CHF in week 6. Thanks to this early warning, management negotiates an advance payment for materials of 80 000,00 CHF with the client and calls on a bank guarantee to release retention money from a completed site. The available balance remains consistently above the safety reserve set at 120 000,00 CHF, ensuring operational continuity without accounting issues.

Frequently asked questions

How much should be allocated to a general contractor's financial safety reserve?

For a firm with fifteen workers, a guideline reserve of 150 000,00 CHF covers three months of fixed costs. The fiduciary adjusts this figure based on invoicing cycles and standard SIA 118 retentions.

How should the collection delay for a monthly payment application with site management be modelled?

The spreadsheet incorporates a guideline period of ninety days between installation and payment. The schedule accounts for review under standard SIA 118 and standard timeframes under the Code of Obligations (CO).

Why separate operating cash flow from the Swiss VAT account?

Quarterly VAT returns at 8,1% require strict ring-fencing. Setting aside 40 000,00 CHF of collected input tax prevents using these funds to absorb a site's working capital requirement.

How often should the 13-week forecast be updated?

The technical management enters receipts every Friday. This weekly cadence highlights cash troughs of 25 000,00 CHF before payroll deadlines or compensation fund contributions.

Where should quantity survey disputes or off-budget unit prices be addressed?

The spreadsheet only tracks consolidated financial flows. Quantity disputes fall under standard SIA 118 on the tracking portal, whereas unit prices are analysed in the tenders modules.

Financial governance and business continuity

Rigorous monitoring of cash flows over thirteen weeks protects contractors from liquidity crises while streamlining periodic reviews with their fiduciary. To learn more about sizing reserves, optimising overheads or training your administrative staff, explore the ecosystem's 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.