A dashboard does not require becoming an analyst
Many owners manage from three sources: the banking app, the feeling they get from customer conversations and a spreadsheet someone updates at month-end. The company works, but important signals arrive late. Revenue may look healthy while unpaid invoices grow, the pipeline empties or a key customer begins complaining.
KPI means key performance indicator. In plain language, it is a number showing whether an important part of the business is moving in the right direction. A dashboard is one page where those numbers can be seen together.
The purpose is not more data. It is for the owner to open one page every Monday, spot exceptions in ten minutes and decide who needs to act. Knowledge moves from the owner's head into a shared management system.
If a metric does not lead to a specific question or decision, it probably does not belong on the weekly owner dashboard.
Seven numbers for the weekly owner dashboard
Not every number is financial. A churn signal is an early warning that a customer may leave: a repeated complaint, poor rating, falling order volume or no recent activity. For a small business, this may be a simple list of customer, signal, owner and next action.
Sales pipeline is not the total of every enquiry. Show real opportunities with expected value, stage and next-action date. A weighted pipeline multiplies value by the probability assigned to its stage. Explain the rule and do not change it every week.
| Metric | What it means | Question it unlocks |
|---|---|---|
| 1. Cash position | Available money minus known payments due in the next 30 days | Can we cover payroll, tax and suppliers? |
| 2. Sales pipeline | Value of real opportunities by stage and expected month | Is enough future work coming, or do we need more sales activity? |
| 3. Revenue vs last month and target | Invoiced or recognised revenue compared with the prior month and plan | Are we growing or behind, and why? |
| 4. Gross margin | Revenue minus the direct cost of delivering the service | Does growth create value, or are we buying low-margin turnover? |
| 5. Top expense lines | Five largest expense categories and their change | Where is there an unexplained increase or unused subscription? |
| 6. Overdue receivables | Invoices issued but not paid by their due date | Which customer needs follow-up, and what cash risk exists? |
| 7. Complaints and churn signals | Complaints, repeated problems, cancellations and declining activity | Which customer is at risk before we lose them? |
The definition matters more than the chart
Before building the dashboard, create a metric dictionary: a short definition list. For every number, record its name, exact formula, source, owner, refresh frequency and action threshold. This ends arguments over whether revenue means signed contracts, issued invoices or cash received.
Example: overdue receivables means every issued invoice past its due date without a matching payment at 09:00 Monday. Source: invoicing system. Owner: finance administrator. Red threshold: more than €10,000 or 15% of monthly revenue. Action: review the list with each account owner that day.
Choose one source of truth—the system holding the official record. CRM owns pipeline, the invoicing product owns invoices, and the bank or accounting report owns cash. Do not correct a number manually in the dashboard; repair the source.
Tools and realistic prices
For most small companies, Google Sheets plus Looker Studio is the right €0-additional-software starting point. Notion helps when metrics need to sit beside goals, decisions and weekly meeting notes. Geckoboard makes sense when the numbers must remain visible to the team and ready integrations remove real maintenance.
Geckoboard's current public price is higher than older figures around €44 that still appear online. Check current price, included dashboards, editors and data limits before buying.
| Tool | Good for | Price checked July 2026 |
|---|---|---|
| Google Sheets | A first dashboard, manual imports and simple formulas | Free for anyone with a Google account; company Workspace is separate. |
| Looker Studio | Automatic charts over Sheets and other data sources | A no-cost version is available according to Google's documentation. |
| Notion | KPI database, goals, owners and meeting notes together | Free: $0; Plus: $10/user/month. |
| Geckoboard Essentials | Live screen, automated snapshots and many viewers | $119/month billed annually—approximately €103 excluding VAT. |
| Power BI | More complex models, permissions and greater data volume | Useful after definitions and sources stabilise; verify the current Microsoft plan for your users. |
Step by step: build it without an analyst
1. Choose seven decisions, not seven charts
Write the weekly management questions: enough cash, enough pipeline, overdue payment, expense spike or customer risk?
2. Define each metric
Record formula, source, owner, refresh timing and action threshold. Have the accountant approve financial definitions.
3. Create one input sheet
Use separate tabs for cash, sales, revenue, expenses, receivables and customer signals. Protect formulas and limit editing to owners.
4. Refresh manually for two weeks
A manual pilot exposes missing data and useless metrics. Do not automate the wrong definition.
5. Connect stable sources
Use a native connector, export or Make for proven fields. Show the date of the last successful refresh when something fails.
6. Build one page
Put cash, pipeline and revenue first, followed by margin, expenses, receivables and customer risk. Show current value, comparison and owner.
7. Establish a weekly review
On the same day each week, the owner and process owners review exceptions and record decisions and tasks. Without this ritual, the dashboard is decoration.
Worked example: about 12 hours recovered each month
The owner of an eight-person service company spends three hours every Friday collecting pipeline from CRM, payments from the bank, invoices from the billing tool and complaints from email. At month-end, another hour disappears into formatting. That is 3 × 4.33 + 1 = approximately 14 hours monthly.
A shared Google Sheet, Looker Studio page and automated exports reduce weekly preparation to 30 minutes for checking exceptions. New effort is 0.5 × 4.33 = 2.2 hours. Recovered capacity is 11.8 hours—roughly 12 hours a month.
At €35 per owner-hour, the capacity is worth about €413 monthly. With free Sheets and Looker Studio, additional tool cost is €0. If the company chooses Geckoboard at approximately €103 excluding VAT, net monthly value remains about €310.
A €500 setup pays back in about 1.2 months with the free stack or 1.6 months with Geckoboard. This is capacity value, not guaranteed profit. Value appears only when the owner uses the weekly review to make decisions rather than passively watching charts.
| Measure | Before | After |
|---|---|---|
| Weekly preparation | 3 hours | 30 minutes |
| Extra month-end formatting | 1 hour | 0 |
| Total monthly time | about 14 hours | about 2.2 hours |
| Recovered time | — | about 11.8 hours |
| Value at €35/hour | — | about €413/month |
Common mistakes
A useful dashboard does not run the business for you. It makes reality visible early enough to decide. When definitions, owners and the review rhythm are documented, the company no longer depends on the owner personally collecting and remembering every number.
- Tracking 30 metrics: attention fragments and nobody knows which exception matters. Start with five to seven.
- Vanity metrics: followers, page views or total leads look impressive but do not show quality, revenue or a next action.
- No shared definition: sales, finance and the owner use different meanings for revenue or active customer.
- Mixing cash and revenue: accounting revenue does not mean the money is in the bank.
- Manual dashboard corrections: the chart looks right while the source remains wrong.
- No refresh timestamp: old data is mistaken for current information.
- No weekly review ritual: the dashboard is opened only after a problem becomes obvious.
- A metric without an owner and threshold: the number turns red, but nobody must act.
Sources and further reading
Product capabilities change. The links below are primary or official sources reviewed when this guide was published.