You have up-to-date accounting... but you only discover problems at year-end? Classic.
A financial dashboard isn’t just a pretty chart for the board. It’s a management tool. Something that tells you, in black and white, whether you’re making money, burning cash, or unintentionally financing your clients.
In Geneva, we often see the same scenario: an SME is running well, the order book is full, yet cash flow is tight. Result? AVS is postponed, tax advances are negotiated, and salaries are squeezed. The dashboard is precisely there to avoid this.
Here’s a concrete method, designed for a Swiss SME in 2026: which KPIs to track, how often, which alert thresholds to set, and how to implement it without spending your evenings on it.
(source: Statutes and obligations SMEs (ch.ch))
Essential indicators for an SME dashboard
Let’s be honest: if you set up 25 indicators, you’ll look at none. An SME needs a core set (8 to 12 KPIs), then a few “business” indicators depending on your activity.
The core: 10 KPIs relevant to 95% of SMEs
- Monthly turnover (revenue)
- Not just “the revenue”. Revenue per month, ideally compared to budget and last year.
- Gross margin (CHF and %)
- If you don’t track margin, you’re flying blind.
- In commerce: gross margin = sales – purchases of goods.
- In services: often margin on direct costs (subcontracting, project expenses).
- EBITDA (CHF and %)
- Operational performance before depreciation and financial charges.
- Very useful for comparing periods without being misled by one-off investments.
- Net result (CHF)
- Yes, it’s “accounting”. But it matters for equity, dividends, and bank credibility.
- Available cash (bank + cash)
- The simplest KPI, often the most ignored.
- Operational cash-flow (monthly)
- Cash generated by activity, not by loans or asset sales.
- If your result is positive but operational cash-flow is negative for several months, there’s an issue.
- DSO (Days Sales Outstanding): average client payment delay
- How many days your clients take to pay.
- DPO (Days Payables Outstanding): average supplier payment delay
- Useful to avoid paying too quickly (and suffocating yourself), or too late (and upsetting partners).
- Working capital requirement (WCR)
- WCR is cash “stuck” in client receivables + inventory – supplier debts.
- Many SMEs discover WCR when the bank says no.
- Personnel expense ratio (personnel expenses / revenue)
- In Geneva, personnel expenses rise quickly. If you don’t track this ratio, you suffer it.
“Business” KPIs: those that really move the margin
Depending on your activity, add 3 to 6 indicators max.
Service SMEs (agency, IT, consulting, fiduciary, engineering office)
- Billable occupancy rate (billed hours / available hours)
- Average daily rate (ADR)
- Margin per mandate/project
- Backlog (signed revenue not yet billed)
Commerce / e-commerce / distribution
- Inventory turnover (days)
- Shrinkage/loss rate
- Margin by product family
- Return rate
Construction / finishing trades
- Margin per site
- Billed progress vs actual progress (the trap of “profitable on paper” sites)
- Subcontracting / revenue
Hospitality / catering
- RevPAR / occupancy rate (hospitality)
- Food cost / beverage cost
- Margin per service
- And yes, VAT has its specifics: standard rate 8.1%, reduced 2.6%, special hospitality 3.8%.
Table 1 — Essential KPIs, formula, and what they really tell you
| KPI | Simple formula | What it really tells you |
|---|---|---|
| Monthly revenue | Sum of issued invoices | Your commercial traction and seasonality |
| Gross margin % | (Revenue – direct costs) / Revenue | If you’re selling at the right price or “working for nothing” |
| EBITDA % | EBITDA / Revenue | Your operational efficiency |
| Net result | Income – expenses | What’s left after everything, including depreciation and taxes |
| Available cash | Bank + cash | Your immediate oxygen |
| Operational cash-flow | Receipts – operating payments | If activity finances activity |
| DSO | Client receivables / daily revenue | If your clients are financing you |
| DPO | Supplier debts / daily purchases | If you’re financing suppliers… or vice versa |
| WCR | Clients + inventory – suppliers | Immobilized cash |
| Personnel expenses % | Personnel expenses / revenue | Your main lever in French-speaking Switzerland |
Checklist 1 — Your “minimum viable” dashboard (to check)
- Monthly revenue vs budget vs last year
- Gross margin CHF and %
- EBITDA CHF and %
- Net result
- Available cash (on day X)
- Operational cash-flow for the month
- DSO + top 10 late clients
- DPO + sensitive suppliers
- WCR (and its variation)
- Personnel expenses %
If you have this, you’re already better equipped than many SMEs.
How often should you track your financial KPIs?
The right frequency is the one that makes you act. Not just feel good.
Weekly: cash and receipts
Every week (yes, every week), check:
- Available cash
- 13-week cash forecast (more below)
- Expected receipts (due and upcoming invoices)
- Top client delays (and who calls whom)
Simple rule? If your cash can go below zero in less than 60 days, monthly tracking is too slow.
Monthly: performance and structure
Every month, ideally between the 5th and 12th of the following month (in Geneva, realistic if entries are clean):
- Revenue, margin, EBITDA, result
- Personnel expenses
- WCR, DSO, DPO
- Profitability by activity / cost center
Field observation: many SMEs wait until quarter-end “because it’s easier”. Result? Three months of drift, then panic.
Quarterly: fundamental decisions
Each quarter:
- Price review (increases, discounts, indexations)
- Analysis of unprofitable clients
- Structural adjustments (staff, subcontracting, premises)
- VAT review (code consistency, rates 8.1% / 2.6% / 3.8%)
Annual: closing, taxes, and strategy
Once a year:
- Closing according to the Code of Obligations
- Tax planning (advances, dividends, provisions)
- Budget for next year and objectives
(source: Code of Obligations (SME accounting requirements))
Table 2 — Recommended frequency by SME type
| SME profile | Cash tracking | Margin tracking | WCR tracking | Full reporting |
|---|---|---|---|---|
| B2B services (monthly billing) | weekly | monthly | monthly | monthly |
| Commerce with inventory | weekly | monthly | monthly (inventory turnover) | monthly |
| Construction / long projects | weekly | monthly (per site) | monthly | monthly |
| Growing start-up | 2x/week | monthly | monthly | monthly |
Alert thresholds to monitor (concrete examples for Swiss SMEs)
A KPI without a threshold is a thermometer without “fever”. You look, nod, and do nothing.
Here are simple thresholds. Not perfect. But actionable.
Cash thresholds: three levels to avoid cold sweats
1) Cash < 1 month of fixed expenses
- Orange alert.
- Example: your fixed expenses (salaries, rent, insurance, leasing, IT) are 120,000 CHF/month. If your cash drops below 120,000 CHF, you’re mentally overdrawn, even if the bank doesn’t see it yet.
2) Cash < 2 weeks of fixed expenses
- Red alert.
- Stop non-essential spending, accelerate receipts, negotiate payments.
3) Negative cash forecast at 6 weeks
- Dark red alert.
- You still have time to act, but not to philosophize.
Margin thresholds: the trap of “acceptable” discounts
Gross margin % drops by 2 points over 2 months
- Orange alert.
- Often: commercial discounts + subcontracting + analytical coding errors.
Negative margin per client
- Red alert.
- Yes, it happens. And not just “on a small client”.
Field anecdote: a Geneva service SME billed correctly... but systematically underestimated non-billable hours (pre-sales, corrections, internal meetings). On the dashboard, margin seemed stable. When billable occupancy rate was measured, real margin collapsed. Result? Repricing and mandate framing.
DSO / client delays thresholds: the heart of the matter
DSO > 45 days in B2B
- Orange alert.
DSO > 60 days
- Red alert.
And especially: if 20% of your clients cause 80% of delays, you don’t fix that with an automatic reminder. You call.
WCR thresholds: when growth brings you to your knees
WCR increases faster than revenue
- Orange alert.
WCR variation > +50,000 CHF in a month (typical SME size)
- Red alert.
Not a universal rule, but a ballpark. The idea: detect drift early enough.
Ark Fiduciaire
Need help with this topic?
Our experts are available for personalised guidance. First consultation free, no commitment.
Personnel expense thresholds: the painful ratio
Personnel expenses / revenue
- If your revenue stagnates and this ratio rises for 2 consecutive months, you have a productivity or pricing problem.
Checklist 2 — Your alert thresholds (to decide in black and white)
- Minimum cash (CHF) = ___
- Minimum cash (in weeks of fixed expenses) = ___
- Target DSO = ___ days; alert at ___ days
- Target gross margin = ___ %; alert at -___ points
- Maximum WCR (CHF) = ___
- Allowed monthly WCR variation = ___ CHF
- Target personnel expenses = ___ %; alert at +___ points
- Top 10 clients: max tolerated delay = ___ days
Practical implementation: tools, templates, and best practices
Let’s get concrete: how to build this dashboard without turning your accounting into a factory.
Step by step: building a reliable dashboard
Step 1 — Clarify the purpose (otherwise you’ll measure anything)
Ask yourself a simple question: what decisions do you want to make thanks to the dashboard?
Examples:
- Increase prices on an underperforming activity
- Reduce client delays
- Decide on a hire
- Cut an unprofitable product
Step 2 — Lock in accounting data quality
Without clean accounting, your dashboard tells stories.
Points to lock in:
- Coherent and stable chart of accounts
- Analytical allocation (by activity, project, site)
- Monthly cut-off (invoices to receive, expenses to pay)
- Correct VAT coding (8.1% / 2.6% / 3.8% as applicable)
(source: SME chart of accounts & KPI (trends 2026))
Step 3 — Choose the tool (Excel, Odoo, or SaaS)
- Excel: perfect for starting, especially if you have a clean accounting export.
- Odoo: interesting if you want to link sales, invoicing, accounting, projects. Reporting becomes smoother if entries are well done.
- SaaS reporting: useful if you have multiple sources (banks, e-commerce, CRM) and need automation.
(source: Odoo reporting tools for SMEs (official documentation))
Step 4 — Define a monthly “closing calendar”
A reliable monthly dashboard depends on a mini-closing.
Example of a realistic calendar:
- Day +2: supplier invoices entered, bank reconciled
- Day +5: client invoices issued, salary entries posted
- Day +7: cut-off (expenses to pay, income to receive)
- Day +10: dashboard validated and sent
Step 5 — Automate what can be automated, keep human judgment
Automate:
- Bank import
- Reconciliations
- Exports to Excel/BI
- Client reminders
Keep human:
- Variance analysis
- Decisions (pricing, staff, payment terms)
Best practices applied by SMEs that really manage
- A single dashboard owner (often management + fiduciary or finance manager). If everyone is responsible, no one is.
- A unique version: not 4 files “final_v7_definitive”.
- Written definitions: gross margin, EBITDA, cash-flow... write the formula and stick to it.
- Mandatory comment on variances: if margin -3 points, explain why. Otherwise, it ends with “we’ll see next month”.
Practical case (Geneva): when revenue rises but cash collapses
Geneva B2B service SME (12 employees), monthly billing.
Situation over 3 months
- Monthly revenue: 180,000 CHF → 210,000 CHF → 240,000 CHF
- Gross margin: stable at 52%
- Net result: positive each month
Yet: cash in bank
- Start period: 160,000 CHF
- End month 1: 110,000 CHF
- End month 2: 55,000 CHF
- End month 3: 18,000 CHF
The manager says: “We’re selling more, so it should be fine.” No.
Diagnosis via dashboard
- DSO goes from 38 days to 67 days (two big clients pay “when they can”)
- WCR increases by +95,000 CHF over 3 months (client receivables)
- Personnel expenses increase (2 hires): +28,000 CHF/month
What we actually do
- Set a threshold: DSO alert at 50 days.
- Change terms: 30% advance on new mandates, bi-monthly billing on long projects.
- Set a routine: client call at day +5 after due date, not at day +30.
- Adjust hiring plan: trial period + billing targets.
Result after 2 months
- DSO drops to 46 days
- Cash rises to 85,000 CHF
- Growth becomes financeable again without begging for a credit line.
It’s not magic. It’s management.
Frequent errors + corrections (ones we see all the time)
Error 1 — Confusing result and cash
Symptom: “We’re profitable, so all is well.”
Correction: add weekly cash tracking + 13-week forecast. And track WCR variation.
Error 2 — Tracking revenue without margin
Symptom: “We did +20% revenue, great.”
Correction: gross margin % + margin by activity. If you can’t calculate it, your analytics are too poor.
Error 3 — KPIs with changing definitions
Symptom: one month, margin includes subcontracting, next month not.
Correction: a KPI dictionary (1 page). Formula, source, responsible.
Error 4 — Waiting for annual closing to correct
Symptom: “We’ll see with the fiduciary at year-end.”
Correction: monthly mini-closing. Even simple. Even imperfect. But regular.
Error 5 — Not linking dashboard to actions
Symptom: numbers are reviewed, then ignored.
Correction: for each alert, a standard action.
- DSO > threshold → call + block delivery if needed
- Margin down → price review + direct cost review
- Cash < threshold → freeze spending + receipt plan
Error 6 — Forgetting VAT in management
Symptom: surprise at VAT statement, or rate errors.
Correction: quarterly check of VAT codes and applied rates (8.1%, 2.6%, 3.8%). And simple reconciliation: VAT collected vs taxable revenue.
(source: Statutes and obligations SMEs (ch.ch))
A word on accounting obligations: your dashboard must remain “reconcilable”
Your dashboard isn’t a legal document. But it must be reconcilable with accounting.
If you have an LLC or SA, you have obligations for bookkeeping and account presentation under the Code of Obligations. If your internal reporting goes in all directions, you waste time and increase the risk of errors at closing.
(source: Code of Obligations (SME accounting requirements))
Which documents to prepare for fast (and accurate) reporting
- Up-to-date bank statement and reconciliation
- List of open client invoices (with due dates)
- List of supplier invoices to pay
- Monthly salaries (accounting entries)
- Inventory (if applicable): reliable estimate or count
- Projects/sites: progress and direct costs
“Real-time” reporting: yes, but with a simple rule
Want real-time? Fine. But you don’t manage an SME with unvalidated numbers.
Our view, best approach:
- Very frequent cash tracking (bank = reality)
- Locked monthly reporting (mini-closing)
- Business indicators updated as you go (hours, projects, orders)
(source: Swiss financial statistics (official data and dashboards))
Payroll and HR data: standardize, or your ratios are wrong
If your personnel expenses are poorly allocated (bonuses, social charges, allowances, re-invoicing), your ratios become unusable.
For SMEs wanting to industrialize payroll/reporting, standards and data exchanges like Swissdec can help secure flows.
(source: Swissdec: reporting and standards for payroll/financial management)
SME Dashboard FAQ: common questions about financial KPIs, margin, cash-flow, and alerts
1) How many KPIs should you track in a Swiss SME?
Aim for 8 to 12 “core” financial KPIs, then 3 to 6 business KPIs. More dilutes attention. The dashboard should fit on one page (or screen) for management.
2) What’s the difference between gross margin and EBITDA?
Gross margin looks at profitability after direct costs (purchases, direct subcontracting, project costs). EBITDA then includes operating expenses (salaries, rent, marketing, IT), but before depreciation and financial charges. Both are useful: margin tells if you’re selling right, EBITDA tells if your structure is healthy.
3) My result is positive, why am I short of cash?
Often because of WCR: clients pay late, inventory increases, or you pay suppliers too quickly. Result is accounting, cash is banking. If you don’t track DSO/WCR, you discover the problem when the bank calls.
4) How often should you do a dashboard?
Cash and receipts: weekly. Performance (margin, EBITDA, expenses): monthly. Strategic review: quarterly. If your cash is tight, monthly alone isn’t enough.
5) Is Excel enough or do you need a tool like Odoo?
Excel is more than enough to start, if your accounting exports are clean. Odoo (or an ERP) becomes interesting when you want to link sales, projects, invoicing, and accounting, and reduce re-entry. The real issue isn’t the tool: it’s closing discipline and data quality.
6) What alert thresholds to set to avoid nasty surprises?
Set at minimum: minimum cash (in CHF and weeks of fixed expenses), target DSO + alert threshold, target gross margin + alert in points, allowed WCR variation, and target personnel expenses %. Without thresholds, a KPI is just a “nice” number.
References
- Statutes and obligations SMEs (ch.ch)
- Code of Obligations (SME accounting requirements)
- SME chart of accounts & KPI (trends 2026)
- Odoo reporting tools for SMEs (official documentation)
- Swiss financial statistics (official data and dashboards)
- Swissdec: reporting and standards for payroll/financial management