Why the sales pipeline alone isn't enough
In many Swiss SMEs, the sales pipeline lives in the CRM, while liquidity is tracked in the bank account and accounting software. A gap often remains between the two: an opportunity marked as "won" does not immediately translate into a collection, and solid revenue can coexist with cash under pressure.
The gap between sale and collection is normal. A client accepts a quote in January, the order is confirmed in February, the invoice is issued in March and payment arrives in May — with net 30 or 60-day payment terms, as is common in Swiss B2B. Without a systematic link between CRM, orders and accounting, the owner or operational CFO makes decisions on incomplete data: they assume liquidity that won't arrive, or defer investments despite contracts already won.
This guide explains how to build a bridge between the sales pipeline and cash forecasting, with a method suited to Swiss SMEs that want greater control without multinational-scale structures.
The gap between revenue, orders and cash
Understanding the three metrics and their time lag is the first step toward a useful forecast:
| Metric | Where it lives | What it indicates | Typical lag |
|---|---|---|---|
| Weighted pipeline | CRM | Future potential revenue, weighted by close probability | Weeks or months before the order |
| Order backlog | ERP / order management | Confirmed work or deliveries, not yet invoiced | Days or weeks before invoicing |
| Revenue | Accounting (account 3xxx) | Revenue recognized in the period | At invoice issue date |
| Actual collection | Bank / accounts receivable | Liquidity actually available | 30–90 days after invoice (average DSO) |
A common mistake is projecting the full pipeline value into the following month. In reality, only a fraction of opportunities convert to orders within the horizon considered, and only part of those orders generate invoices — and therefore collections — in the expected period. Cash forecasting must reflect this chain, not jump directly from "opportunity" to "money in the bank".
Pipeline stages and close probability
A structured pipeline turns sales intuition into numbers the treasurer or finance manager can use:
Standard B2B stages
- Qualified lead — verified interest, indicative budget (10–20%)
- Quote sent — formal proposal with amount and terms (30–40%)
- Negotiation — price, timing or scope review (50–60%)
- Verbal agreement / LOI — binding intent or contract in draft (70–80%)
- Order confirmed — signed document or PO received (90–100%)
Weighted value
Weighted value is calculated by multiplying the opportunity amount by the stage probability. A CHF 50,000 quote at 40% contributes CHF 20,000 to the sales forecast, not the full amount.
Probabilities should be calibrated against your company's historical data: if 25% of quotes sent convert to orders within 90 days, using a generic 40% systematically overestimates future collections.
For SMEs with short sales cycles (services, consulting, trade), updating the pipeline weekly is sufficient. For industrial or IT projects with 6–12 month cycles, a biweekly review with the sales team prevents "dormant" opportunities from polluting the cash forecast.
From CRM to cash: the operational bridge
Linking systems does not necessarily require full API integration. What you need is a consistent data chain with mandatory fields and clear responsibilities:
1. CRM → Order
When an opportunity moves to "won", the CRM must generate (or flag) an order with: net amount, expected delivery or service date, agreed payment terms, client contact and any deposits. Without these fields, accounting cannot estimate the invoicing date or collection.
2. Order → Invoice
The confirmed order feeds revenue planning. For milestone-based work, each project milestone must have an expected invoicing date. In Accountex and similar accounting software, issued invoices automatically feed accounts receivable and the revenue account — but the collection date still needs to be forecast.
3. Invoice → Expected collection
The estimated collection date is obtained by adding agreed payment days to the invoice date, plus a buffer based on the client's history (individual DSO). A client who consistently pays at 45 days instead of the contractual 30 deserves a separate line in the forecast.
Forecasting method: 13-week rolling
The 13-week rolling forecast (roughly one quarter) is the most widely adopted standard among SMEs for balancing accuracy and operational effort. It is updated weekly and combines three sources:
| Time horizon | Data source | Reliability | Example |
|---|---|---|---|
| Weeks 1–4 | Issued invoices + accounts receivable due dates | High (80–95%) | Invoice no. 2026-041, due 15 Apr, CHF 12,400 |
| Weeks 5–8 | Confirmed orders not yet invoiced | Medium (60–75%) | Order PO-778, expected delivery 20 Apr, invoice +30 days |
| Weeks 9–13 | Weighted CRM pipeline | Low (30–50%) | 3 opportunities at 60%, CHF 80,000 weighted → CHF 48,000 |
Add certain outflows (payroll, rent, suppliers with known due dates, tax instalments and social security contributions) and probable outflows (purchases linked to ongoing orders). The weekly net balance indicates whether invoice factoring, trade credit adjustments or a planned delay in investments will be needed.
Swiss specifics to incorporate into the forecast
VAT and tax deadlines
VAT charged on invoices does not belong to the company: it must be set aside for periodic payment to the FTA — typically quarterly under the effective method, semi-annually under the net tax rate method; with FTA authorization, also annually for businesses with limited turnover. In the cash forecast, deducting VAT from expected collections avoids overestimating available liquidity.
Under the effective method, the VAT liability generally arises at the invoice date, even if the client has not yet paid: VAT outflows must therefore also be planned in the weeks when the return is due (within 60 days of the end of the period). Similarly, corporate or income tax instalments (provisional and final, depending on legal form and canton) and social security contributions on salaries (AHV/IV/EO and, where applicable, occupational pension) should be entered as certain outflows in the relevant due weeks — checking the cantonal calendar and any deadlines agreed with the pension provider.
Seasonality and CHF
Many Swiss SMEs see revenue peaks at year-end (client budgets) and summer troughs. The forecast must reflect these historical patterns, not linearly project the current month.
For foreign clients invoiced in EUR or USD, allow for exchange rate margin or use the forward rate agreed with the bank, especially for multi-month orders.
DSO and payment terms: the hidden lever
Days Sales Outstanding (DSO) measures how many days on average it takes to collect a receivable. For a Swiss SME with annual revenue of CHF 1.2 million and a DSO of 55 days, roughly CHF 180,000 remains permanently "locked" in accounts receivable — liquidity that does not appear in the bank despite having already been invoiced.
| Action | Impact on DSO | Effect on cash |
|---|---|---|
| 30% deposit on order confirmation | Reduces outstanding receivables | Collection weeks earlier |
| QR-bill invoice | Reduces errors and administrative delays | Improves collection predictability |
| Automatic reminder at due date +7 days | −5 to −10 days on late payers | Recover CHF without new sales |
| Early payment discount (2/10 net 30) | Significant reduction | Trade-off: margin vs liquidity |
Monitoring DSO monthly in accounting software and comparing it with the sales forecast reveals whether the problem is sales (weak pipeline) or collections (receivables stretching out). These are two different diagnoses with different remedies.
Implementation in five steps
Map the current data chain
Identify where opportunities originate (CRM, email, Excel), where they become orders and where they are invoiced. Mark the points where data is lost or duplicated manually.
Define mandatory CRM fields
Net amount, expected close date, probability, payment terms, decision-maker contact. No opportunity enters the forecast without these five fields completed.
Create the weekly forecast template
A spreadsheet or view in accounting software with three blocks: certain collections (accounts receivable), probable collections (orders + pipeline), certain and probable outflows. Opening bank balance + inflows − outflows = projected balance.
Establish a joint review rhythm
30 minutes per week between sales and finance: update the pipeline, confirm invoicing dates for open orders, flag delays or cancellations. Forecast accuracy depends more on rhythm than on the tool.
Measure accuracy and calibrate
Each month, compare the forecast from 4 weeks ago with actual collections. If deviation exceeds 15%, review stage probabilities or the per-client DSO buffer. After three months, estimates become significantly more reliable.
Role of accounting software in the connection
The CRM manages opportunities; accounting software holds financial truth. Accountex sits at the centre of this bridge, providing the structured data needed for forecasting:
- →Accounts receivable with due dates — the basis for certain collections in the first weeks of the rolling forecast.
- →Collection history by client — calculation of individual DSO and the buffer to apply to contractual due dates.
- →Chart of accounts and cost centres — separation between recurring revenue and projects, useful for modelling cash flows with different profiles.
- →VAT and contribution schedule — tax outflows that do not appear in the CRM but affect net liquidity.
- →Bank reconciliation — weekly verification that the actual balance matches the updated forecast, identifying variances immediately.
The ideal integration is for an order "won" in the CRM to automatically create a client or project in accounting, with payment terms and amount already aligned. Where automatic integration is not available, a weekly CSV export with standardized fields reduces transcription errors and keeps the data chain consistent.
Common mistakes to avoid
Treating revenue as cash
Recognized revenue is not the same as liquidity. With 60-day payment terms, March revenue arrives in the bank at the earliest in May.
Pipeline not cleaned up
Opportunities stalled for months with inflated probability distort the forecast. Rule: if there has been no activity for 30 days, downgrade or archive.
Ignoring deposits and withholdings
In construction, IT and consulting, deposits change the collection profile. Foreign withholdings on invoices to international clients reduce the net amount in the bank.
Static monthly forecast
An annual budget does not replace a weekly rolling forecast. Liquidity is managed week by week, especially with fewer than 10 employees.
Conclusion: sales and cash as a single system
Connecting the sales pipeline, orders and cash forecasting is not an exercise for a multinational controller. It is an operational discipline within reach of every Swiss SME that wants to avoid liquidity surprises while maintaining strong commercial ambitions.
The method boils down to a few rules: probabilities calibrated on real data, a 13-week rolling forecast with sources of decreasing reliability, a weekly joint review between sales and finance, and accounting software as the source of truth for collections, due dates and tax outflows.
With Accountex, accounts receivable, collection history and the tax schedule become the numerical foundation on which to build a forecast that reflects the company's reality — not the sales team's optimism.