You don’t need 40 charts to manage an SME in Geneva. You need 10 to 15 numbers that are accurate, timely, and trigger decisions.
The classic trap? Confusing “accounting” with “management.” Accounting is for producing compliant accounts (and sleeping well during audits). Management is about avoiding nasty surprises: tight cash flow, eroding margins, clients paying in 75 days, VAT hitting at the worst time.
Let’s get practical: which KPIs to track, how often, which thresholds should raise an eyebrow, and how to deploy a dashboard without spending your evenings on it.
(source: SME accounting obligations and reporting (CO))
Essential Financial Indicators for SME Leaders (Priority KPIs)
1) Revenue: yes, but “net” and comparable
Everyone looks at revenue. The problem is, it’s often viewed incorrectly.
- Net revenue: after discounts, returns, credit notes. Otherwise, you’re telling yourself a story.
- Comparable revenue: same scope (same activities, entities, periods). An acquisition or a one-off big project can distort the picture.
- Revenue by line: by product/service, by team, by channel. That’s where you see what really drives the business.
Field observation: in Geneva, many service SMEs discover that “sales are good”... but 2 clients make up 45% of revenue. As long as it’s fine, it’s fine. The day one switches suppliers, it’s a different story.
2) Gross margin: the KPI that reveals pricing errors
Gross margin is your first thermometer. If it deteriorates, you can make all the sales efforts in the world, but you’ll be chasing your tail.
- Gross margin (CHF) = Revenue – direct costs (purchases, direct subcontracting, materials, directly attributable project costs)
- Gross margin (%) = gross margin / revenue
What I want to see in a dashboard:
- overall gross margin
- gross margin by activity (or mandate type)
- gross margin by “top 10” client
3) Operating result (EBIT): profitability before “financial engineering”
EBIT tells you if your model is sound, regardless of interest and taxes.
- EBIT (CHF)
- EBIT (%)
If you’re growing, EBIT may temporarily drop. That’s okay—as long as it’s a choice, not a surprise.
4) Operating cash flow: the real judge
Accounting profit doesn’t pay salaries. Cash does.
- Operating cash flow: customer receipts – supplier payments – operating expenses (considering changes in inventory and working capital)
Two common signals:
- accounting profit, but declining cash (often exploding working capital)
- rising cash, but only because supplier payments are delayed (it always catches up)
5) Available cash and runway
You need to know how many weeks you can last if things get tight.
- Available cash: bank + cash – short-term bank debt (for a “net” view)
- Runway (months) = available cash / monthly burn (if burn is positive)
Even a profitable SME can get stuck if a big client pays late and VAT is due the same quarter.
6) Working capital requirement (WCR): where SMEs get trapped
WCR is money tied up in:
- customer receivables
- inventory
- minus supplier payables
Simple KPIs to track:
- DSO (Days Sales Outstanding): average customer collection period
- DPO (Days Payables Outstanding): average supplier payment period
- DIO (Days Inventory Outstanding): inventory turnover (if you have stock)
In Geneva, DSO often “drifts” slowly: 38 days, then 45, then 52. No one panics—until cash starts squeaking.
7) Payment delays: not a “finance” KPI, a survival KPI
I want a very operational indicator:
- Amount of overdue unpaid invoices (CHF)
- Share of overdue invoices > 30 days / > 60 days
- Top 10 delays (yes, with internal names)
Result? You stop discovering problems “at closing.”
8) Personnel expenses: ratio and productivity
In Switzerland, personnel expenses are often the main cost.
Useful KPIs:
- Personnel expenses / revenue
- Revenue per FTE (full-time equivalent)
- Gross margin per FTE (even more telling)
In services, a personnel/revenue ratio rising by 3 points in 6 months is rarely a coincidence. Often: underbilling, too much non-billable work, or hiring too early.
9) Investments (CAPEX) and depreciation: staying on track
- Monthly CAPEX / annual cumulative
- CAPEX vs budget
- Depreciation (to understand impact on results)
A manager must know if the company is investing “to grow” or “to repair.”
10) VAT: a cash flow KPI, not just compliance
Even if VAT isn’t a cost (when managed correctly), it can drain your cash.
Track:
- Estimated VAT due for the period
- Difference between accounting VAT and VAT return (when you file)
Swiss rates since 2024:
- standard rate 8.1%
- reduced rate 2.6%
- special accommodation rate 3.8%
If you mix rates (dine-in/takeaway, mixed services, subscriptions), you want simple, regular control.
Checklist #1 — Your “pack” of KPIs (executive version)
Tick what you already have, black and white, every month:
- Net revenue (monthly + annual cumulative)
- Gross margin (CHF and %), overall + by activity
- EBIT (CHF and %)
- Operating cash flow (or reliable proxy)
- Available cash + 8–13 week forecast
- DSO + overdue amounts > 30 / > 60 days
- WCR (at minimum: receivables + supplier payables)
- Personnel expenses / revenue + revenue per FTE
- CAPEX vs budget
- Estimated VAT due / consistency check
KPI Monitoring Frequency and Methods (monthly, quarterly reporting, market tools)
You want a rhythm that fits your reality. Too frequent, you drown the team. Not enough, you fly blind.
Monthly: the standard that works for 80% of SMEs
Monthly reporting is the foundation.
What to aim for in practice:
- D+10 to D+15: previous month’s figures available (depending on volume and document quality)
- a 1-page dashboard + details if needed
If you’re growing fast or cash is tight, add weekly cash monitoring.
Quarterly: useful for strategy, risky if it’s your only pace
Quarterly is for:
- reviewing prices
- adjusting headcount
- deciding on investments
If you only check payment delays quarterly, you’ll get caught out.
Weekly: cash, receipts, pipeline (when things heat up)
When you sense tension (or want to avoid it), track weekly:
- receipts
- invoices issued
- overdue invoices
- cash position
- 8–13 week forecast
Monitoring methods: from simple to robust
You have four typical approaches:
- Well-built Excel
- fast
- flexible
- perfect to start
- risk: dependence on one person, copy-paste errors
- ERP (e.g., Odoo)
- sales–billing–accounting consistency
- possible automations
- requires serious setup
- Reporting / BI SaaS
- nice, shared dashboards
- banking, accounting, billing connectors
- beware: if source data is bad, the dashboard will look “clean” but be wrong
- Hybrid (often the best compromise)
- accounting/ERP as source
- automatic extraction
- simple dashboard (Excel/BI)
On SME digitalization and reporting trends, there’s a clear rise in automation and “near real-time” dashboards... but only when the accounting base is clean. Otherwise, it’s just window dressing. (source: Digitalization, reporting and SME dashboard trends (2026))
Table #1 — Recommended Frequency by KPI (Swiss SMEs)
| KPI | Frequency | Target deadline | Who reviews | Typical decision |
|---|---|---|---|---|
| Net revenue + gross margin | Monthly | D+10 to D+15 | Management + operations manager | Adjust prices, mix, subcontracting |
| Payment delays (overdue) | Weekly (if WCR sensitive) else monthly | D+3 to D+7 | Management + admin/collections | Reminders, delivery blocks, deposits |
| Cash + 8–13 week forecast | Weekly | D+2 | Management | Delay expenses, negotiate lines, plan VAT |
| EBIT | Monthly | D+15 | Management | Adjust expenses, hiring |
| Personnel expenses / revenue | Monthly | D+15 | Management + HR | Adjust capacity, billing |
| WCR (DSO/DPO/DIO) | Monthly | D+15 | Management + finance | Payment terms, inventory |
| Estimated VAT due | Monthly (at least) | D+15 | Management + accounting | Anticipate cash outflow |
| CAPEX vs budget | Monthly | D+15 | Management | Prioritize investments |
(source: SME accounting obligations and reporting (CO))
Alert Thresholds: Critical Values and Interpretations for Financial Health
Thresholds aren’t laws. They’re alarms. And an alarm should be set according to your business.
Cash: three alert levels
- Green: you cover 2 months of fixed costs without stress.
- Orange: you cover 1 month. Monitor weekly.
- Red: less than 3 weeks. Stop “thinking,” start acting.
For example, if your fixed costs (salaries, rent, insurance, leasing, etc.) are 120,000 CHF/month:
- green: > 240,000 CHF available cash
- orange: ~120,000 CHF
- red: < 90,000 CHF
Gross margin: the “pricing or execution” signal
- 2-point drop over 2 months: investigate.
- 5-point drop: you have a problem (pricing, purchasing, subcontracting, project drift).
In fixed-price services, a falling margin often comes from something simple: selling at the same price, but spending 20% more hours because the scope crept.
DSO (collection period): the slow poison
Practical thresholds (to adjust):
- < 35 days: healthy for many B2B SMEs
- 35–50 days: monitor
- > 50 days: it’s getting expensive
The real KPI is the trend. A DSO rising by 10 days in 3 months is rarely “normal.”
Client concentration: the risk we always minimize
- if 1 client > 25% of revenue: high risk
- if top 3 > 50%: very high risk
You can live with it, but you need to know and manage it (contracts, deposits, diversification).
Personnel expenses / revenue: the ratio that shows if you’re billing enough
Indicative thresholds (very sector-dependent):
- services: if the ratio rises without margin increase, you’re underbilling or overstaffed
- trade: watch gross margin, the ratio alone isn’t enough
Table #2 — Alert Thresholds (Pragmatic) and Quick Reading
| Indicator | Alert threshold | What it often means | First action |
|---|---|---|---|
| Available cash | < 3 weeks of fixed costs | WCR, margin drop, unplanned expenses | 13-week forecast + collection plan |
| Gross margin (%) | -2 points in 2 months | Low prices, rising direct costs | Price review + client analysis |
| DSO | +10 days in 3 months | Weak reminders, disputes, too lenient terms | Reminder process + deposits |
| Overdue > 60 days | > 5% of monthly revenue | Clients in trouble, disputed invoices | Stop delivery / payment plan |
| Personnel expenses / revenue | +3 points in 6 months | Underbilling, non-billable, early hiring | Review rates, billable, staffing |
| VAT due | unexpected spike | poor tracking, wrong rates, billing lag | Monthly estimate + rate check |
Practical Cases: Deploying an SME Financial Dashboard (Excel, Odoo, SaaS, Automations)
Here are three scenarios we see all the time.
Scenario A — (Clean) Excel for an SME of 5 to 20 people
You have:
- accounting managed externally or internally
- not too many invoices
- need for a simple dashboard
Approach:
- a locked Excel file (tabs: revenue, margin, WCR, cash, HR)
- monthly import of trial balance + customer ledger
- a “control” tab (totals, consistency)
What makes the difference: a stable model. Not a file that changes every month.
Scenario B — Odoo (or similar ERP) to link sales, projects, billing
You have:
- projects
- subcontracting
- teams that need to log time
Approach:
- set up products/services with correct accounts
- enforce disciplined entry (time, project purchases)
- generate margin reports by project, by client
Classic trap: install ERP, but let teams “tinker” with entries. Result? Inconsistent figures, back to Excel.
Ark Fiduciaire
Need help with this topic?
Our experts are available for personalised guidance. First consultation free, no commitment.
Scenario C — Reporting / BI SaaS for management who want sharing
You have:
- multiple sources (bank, billing, accounting)
- need for shared dashboards
Approach:
- connect sources
- define a KPI dictionary (same definition for everyone)
- set alerts (DSO, cash, margin)
Risk: spending 3 months making it pretty, forgetting the use. A dashboard is for decisions, not decoration.
Simple automations that change everything
- daily bank import (to track cash)
- automatic reminders (with human escalation)
- monthly extraction of trial balance and subledgers
- reconciliation of issued invoices vs receipts
(source: Digitalization, reporting and SME dashboard trends (2026))
Step by Step: Set Up Your Dashboard in 30 Days (Without Overkill)
Step 1 — Decide what you manage (and what you ignore)
Choose 10 to 15 KPIs. No more.
- profitability: gross margin, EBIT
- cash: cash, forecast, DSO
- execution: margin by activity/project
- risk: client concentration, overdue > 60 days
Step 2 — Set definitions (or you’ll argue)
Examples:
- does “gross margin” include subcontracting?
- “revenue”: invoiced or recognized on progress?
- “cash”: gross or net of short-term debt?
One definition = one calculation method = one source.
Step 3 — Lock data sources
- accounting (trial balance)
- billing (sales journal)
- bank (statements)
- HR (headcount/FTE)
If you have 3 versions of revenue, you don’t have a KPI problem. You have a process problem.
Step 4 — Build a “management” page
One page, really.
- 6 KPIs at the top (revenue, margin, EBIT, cash, DSO, overdue)
- 4 KPIs at the bottom (personnel expenses, WCR, CAPEX, VAT)
- a mini comment: “what’s moving” + “decision”
Step 5 — Add alert thresholds and actions
A KPI without action is a poster.
Example:
- DSO > 45 days → reminder + deposit on new contracts
- gross margin < target → price review + subcontracting review
Step 6 — Test 2 monthly cycles
Two months in a row, same format, same definitions. Fix what’s stuck.
Step 7 — Install the ritual
- 30 minutes per month, blocked agenda
- max 3 decisions
- one person responsible per action
Practical Case (Geneva): When Profit Rises but Cash Falls
Geneva B2B service SME, 12 FTE.
- Average monthly revenue: 220,000 CHF
- Gross margin: 48%
- Monthly fixed costs (salaries + structure): 145,000 CHF
- Operating result (EBIT) for the month: +12,000 CHF
On paper, all is well.
Except:
- DSO rises from 38 days to 56 days in 4 months
- Overdue invoices > 60 days: 85,000 CHF
- Estimated VAT due for the quarter: 42,000 CHF
Cash effect (simplified):
- +12,000 CHF EBIT
- but + (56-38) days of revenue tied up ≈ 18 days of revenue
- 220,000 CHF / 30 ≈ 7,333 CHF/day
- 18 days × 7,333 CHF ≈ 132,000 CHF of “stuck” cash
Add the VAT to pay (42,000 CHF) and you see why the bank starts calling.
Concrete decisions implemented in this case:
- faster billing (invoice at milestones, not at the end)
- deposits on new contracts (20% upfront)
- reminders at D+5 after due date, then escalate at D+15
- stop on clients > 60 days without a payment plan
Result? DSO drops, cash breathes, and you stop financing your clients.
Two Checklists That Prevent 80% of Issues
Checklist #2 — Consistency Checks Before Sending the Dashboard
- Dashboard revenue = total sales journal (same period)
- Gross margin: direct costs correctly allocated (not in overheads)
- Cash = actual bank balances (not “gut feeling”)
- Overdue clients: up-to-date list, not a 3-week-old extract
- VAT: applied rates consistent (8.1% / 2.6% / 3.8%)
- Personnel expenses: includes social charges, not just net salaries
- Any KPI with a big change has an explanation (otherwise, dig deeper)
9 Common SME Dashboard Mistakes (and How to Fix Them)
1) Tracking revenue without margin
Mistake: “We did +15% revenue, so it’s good.”
Fix: Revenue + gross margin by activity. If margin drops, you may be selling more... but less profitably.
2) Mixing invoiced and collected
Mistake: confusing sales performance and cash.
Fix: two separate lines: invoiced revenue and collections. And a DSO.
3) Discovering payment delays too late
Mistake: only checking receivables at closing.
Fix: monthly, even weekly tracking if it drifts. With a top 10.
4) Having 3 definitions of margin
Mistake: everyone calculates “their” margin.
Fix: one written, validated, and applied definition everywhere.
5) Not tracking VAT as a cash flow
Mistake: VAT is “handled by accounting,” period.
Fix: monthly estimate + anticipation of outflows. Rates are clear (8.1%, 2.6%, 3.8%). Cash doesn’t forgive.
6) Overcomplicated dashboard
Mistake: 25 KPIs, no one reads it.
Fix: 10–15 KPIs, one management page, annexes if needed.
7) No thresholds, no actions
Mistake: observe, comment, move on.
Fix: threshold → action → responsible → date.
8) “Clean” but wrong figures
Mistake: beautiful BI tool, shaky source data.
Fix: first, quality of entries, allocations, subledgers.
9) Reporting too late
Mistake: figures at D+30.
Fix: aim for D+10 to D+15. If not possible, simplify monthly allocations and make quarterly adjustments.
(source: SME accounting obligations and reporting (CO))
What the Code of Obligations Changes (or Not) for Your Reporting
The CO sets accounting and presentation obligations. Your dashboard is not a legal statement. It’s a management tool.
Two practical points:
- you can track “management” KPIs that don’t match statutory accounts
- you must maintain minimum consistency with accounting, or you’ll lose trust in the figures
(source: SME accounting obligations and reporting (CO))
Common French-Speaking Swiss Specificities (Geneva, Vaud) When Setting Up a Dashboard
Real deadlines: what leaders underestimate
- time to collect documents (supplier invoices, expense reports)
- internal validations (who blocks what)
- client disputes (which delay collection)
The “season” effect on Geneva SMEs
Some activities in Geneva have marked cycles (events, catering, international services). A good dashboard shows:
- monthly
- annual cumulative
- year-on-year comparison
And if you have a budget, include it. Otherwise, you’re flying blind.
For economic trends and business climate in Geneva, it’s worth keeping an eye on cantonal indicators. (source: Economic outlook 2026 (Geneva canton: SME trends and data))
In Our Opinion: The Best Dashboard Is the One That Triggers Decisions
A good dashboard:
- saves you time
- reduces surprises
- puts tough topics on the table (margin, delays, client dependence)
A bad dashboard:
- gives false reassurance
- keeps you busy
- arrives too late
If you have to choose, choose reliability and regularity. Design comes later.
SME Dashboard FAQ: 8 Q&As on KPI Best Practices, Tools, Mistakes to Avoid, Concrete Examples
1) How many KPIs should you track as an SME leader?
Aim for 10 to 15. Fewer, you miss signals. More, you dilute focus. One management page is good discipline.
2) What are the 5 “non-negotiable” KPIs?
- gross margin
- available cash
- 8–13 week cash forecast
- DSO (collection period)
- overdue invoices (including > 60 days)
Revenue alone isn’t enough.
3) Is Excel enough in 2026?
Yes, if:
- your definitions are clear
- your sources are stable
- you have consistency checks
Excel becomes risky when it depends on one person or is used to “fix” reality instead of reflecting it.
4) Is Odoo (or an ERP) worth the investment?
It’s worth it if you have:
- margin-based projects
- subcontracting
- need to link sales, time, purchases, and billing
Otherwise, you risk paying for overkill to do what a good Excel can.
5) How to set alert thresholds without mistakes?
Start simple:
- review 12 months of history
- set an “orange” (watch) and “red” (act) threshold
- adjust after 2–3 cycles
Most useful is the trend: a KPI moving fast deserves action, even if it hasn’t crossed a threshold yet.
6) Which KPIs to track if I’m in trading (buy-sell)?
Add:
- gross margin by product family
- inventory turnover (DIO)
- shrinkage/losses
- cash tied up in inventory
And monitor VAT as a cash flow.
7) Which KPIs to track if I’m in time-based services?
Add:
- billable rate (billable hours / total hours)
- revenue per FTE
- margin per client
- WIP (work in progress) if you bill with a delay
8) What’s the best first step if I’m starting from scratch?
Set up:
- monthly tracking of revenue + gross margin
- a list of overdue clients (with > 30 / > 60 days)
- an 8-week cash forecast
In 30 days, you’ll already have much stronger management.
(source: SME Tax Day 2026, HE-Arc)