Building a management dashboard for your Senegalese SME in 2026

Many SME owners run their business on gut feeling. They sense it is going well or badly, with no precise figure. The problem is that gut feeling is often wrong, and it always warns too late. A dashboard turns intuition into steering: you see problems coming, you decide on facts, you sleep better.

This article shows you how to build a simple, useful and sustainable dashboard, with free or low-cost tools, adapted to a Senegalese SME.

Why a dashboard changes everything

Without a dashboard, you discover a cash problem when the account is empty. You notice falling sales when the month is already over. With a dashboard, you see the trend before the drop, and you act while there is still time. The dashboard is your car dashboard: without it, you drive with your eyes closed.

Choosing your KPIs: fewer, but the right ones

The classic mistake is wanting to measure everything. A good dashboard fits on one screen and holds five to eight indicators maximum. Here are the four essential families for an SME.

Sales

How much you sell, and the trend. Track monthly revenue, compared to the previous month and the same month last year. Add the number of orders and the average basket. You will instantly know whether growth comes from more customers or bigger baskets.

Cash

The most vital for an SME. Track your cash balance, expected collections and planned disbursements for the coming weeks. A profitable company can die from lack of cash. This indicator spares you the nasty surprise.

Margin

Selling a lot is pointless if you lose money. Track your margin: the difference between what you sell and what it costs you. Watch it per product or service to spot what really pays.

Customers

Track the number of new customers, the rate of returning customers, and possibly late payments. Acquiring a customer is expensive; retaining one costs less. This indicator tells you whether your business is building up or just replacing what it loses.

Identify your data sources

A dashboard is only as good as its data. List where your figures come from: cash register, invoices, bank statements, mobile money statements (Wave, Orange Money), order spreadsheet. The goal is to centralize these sources, ideally in a single input spreadsheet or via regular exports.

If entry is manual, simplify it to the extreme: one line per sale, fixed columns. The heavier the entry, the less it will be done, and an unfed dashboard is a dead dashboard.

The simple tools that are enough

No need for million-franc software. Two free tools cover the vast majority of needs.

Google Sheets for the foundation

Google Sheets (free, in the cloud, shared) is your base. You enter or import your data and compute your indicators with simple formulas. Sharing and collaboration are native, and everything is saved automatically.

Looker Studio for visualization

Looker Studio (free, from Google) connects to your Google Sheets and turns your figures into clear charts: sales curves, cash gauges, margin tables. You get a visual dashboard, shareable via a simple link, viewable on a phone. It is the winning duo for an SME: Sheets for the data, Looker Studio for the reading.

Building step by step

Start modest. Choose three vital indicators (sales, cash, margin). Create a Google Sheet with an input tab and a calculation tab. Connect Looker Studio and create three visuals. Only add indicators once the first ones run effortlessly. A dashboard that grows too fast becomes a chore, then an abandonment.

The review ritual: the key to success

A dashboard you never look at is useless. Set up a ritual. Every Monday, ten minutes alone or with your deputy: what do the figures say, what moved, what action this week. Every month, a deeper review. This ritual turns figures into decisions. Without it, the dashboard is just a pretty page never opened.

Example: a restaurant chain in Dakar

A small chain of three restaurants in Dakar never knew which location actually made money. The owner looked at the overall revenue, satisfied, without seeing that one restaurant was losing money every month.

They set up a Google Sheet fed each evening by each manager: sales, purchasing costs, payroll. Looker Studio displayed the margin per location. From the first month, the truth jumped out: one restaurant was dragging down the whole. The owner renegotiated the rent and adjusted the menu. Three months later, all three were profitable. Tool cost: zero francs.

Mistakes to avoid

Too many indicators: you can no longer see. Data never up to date: the dashboard lies. No ritual: the tool dies. Measuring what is easy rather than what matters: cash and margin before likes.

FAQ

How many indicators should I track ?

Five to eight maximum to stay readable. Even start with three vital ones: sales, cash and margin. You will add the others once the routine is set. Too many indicators drowns out the useful information.

Which free tools to build a dashboard ?

Google Sheets to enter and compute, Looker Studio to visualize. Both are free, in the cloud, accessible on a phone and shareable via link. That is enough for the vast majority of Senegalese SMEs.

How do I integrate Wave and Orange Money payments ?

Export or copy your mobile money statements regularly into your input sheet. The key is one line per collection with the date and amount, so cash and sales reflect reality.

How often should I update the dashboard ?

Sales and cash data are best entered daily or at end of day. The review happens weekly in ten minutes, with a deeper analysis once a month.

Do I need an accountant to build a dashboard ?

No, not for a simple management dashboard. You can build it yourself with Sheets and Looker Studio. A one-off support helps choose the right indicators and connect sources cleanly.

Does a dashboard replace accounting ?

No. The dashboard is for day-to-day steering; accounting meets legal and tax obligations. The two complement each other: one to decide fast, the other to stay compliant.

Let's talk about your project. Kolonell builds clear, automated dashboards for Senegalese SMEs. Write to us on WhatsApp +221 77 596 93 33.