Sales tracking: the 5 dashboards every Cameroonian SME manager should check every week

"It's fine, we're selling well." That's the answer many managers give when asked how their business is doing. Then, at the end of the year, the accountant announces a result far lower than expected. The shop was full, the till was busy, and yet the money isn't there.

This gap almost always has the same cause: the manager looks at volume, not the figures. They see customers, boxes going out, money coming in. They don't see the margin melting away on certain items, receivables piling up, stock sitting idle or the salesperson giving too many discounts.

Running an SME isn't about watching fifty indicators. It's about watching the right figures, at the right pace. This guide presents the 5 dashboards that are enough to run a Cameroonian SME or shop, the indicators to track in each, the calculations explained simply, and a 30-minute weekly ritual to turn them into decisions.

Why "every week"?

• Every day is too often: daily figures vary a lot (weather, market day, end of month) and push you to react to one-offs rather than trends.
• Every month is too late: when you discover at the end of the month that a flagship item has been out of stock for three weeks or that a customer has stopped paying, the damage is done.
• Every week is the right pace: often enough to correct quickly, rarely enough to see trends.

The only exception: till closing, which is checked every evening. We covered it in detail in our guide POS software in Douala and Yaoundé.

Dashboard 1: sales

This is the dashboard everyone looks at, but often badly: they look at the total without comparing it to anything. A figure on its own says nothing. You always need to compare it.

The indicators

• The week's revenue, compared with the previous week and with the same week last year.
• The month's cumulative revenue, compared with your target.
• The number of sales (receipts or invoices).
• The average basket: what a customer spends on average per purchase.
• Sales by day and by time slot: which days and hours drive your business.
• Sales by salesperson and by point of sale, if you have several.

Calculating the average basket

Average basket = revenue ÷ number of sales

Example: 4,200,000 FCFA of sales over the week, for 600 receipts → an average basket of 7,000 FCFA.

What to read from it

Revenue depends on two levers: the number of customers and the average basket. Separating them changes everything:

• Revenue is falling because the number of sales is falling? It's an attractiveness problem: competition, location, stock-outs on the items that bring customers in.
• Revenue is falling because the average basket is falling? Customers come but buy less: price, choice, advice at the till, add-on sales.

Comparing with the same week the previous year is essential in Cameroon, where business follows marked cycles: back to school, end-of-year holidays, Ramadan and Tabaski, the rainy season, month-ends linked to payday. A drop in August doesn't mean the same as a drop in December.

The trap to avoid

Don't congratulate yourself on rising revenue before looking at dashboard 2. Selling more by giving excessive discounts sometimes means earning less.

Dashboard 2: margins

This is the most important dashboard, and the least looked at. Your business doesn't live on its revenue: it lives on its margin.

The indicators

• The week's gross margin in FCFA: sales minus the purchase cost of the items sold.
• The average margin rate on sales.
• Margin by product family and by item: which products really make you money.
• Discounts granted, in amount and by salesperson.
• Items sold at a low or negative margin: sold below the planned price, or whose purchase price has risen without the selling price following.

Markup vs margin: stop confusing them

This is the most common calculation error among retailers, and it's costly.

An item bought for 10,000 FCFA and sold for 12,500 FCFA:

• Margin: 12,500 − 10,000 = 2,500 FCFA
• Markup (margin ÷ purchase price): 2,500 ÷ 10,000 = 25%
• Margin rate on sales (margin ÷ selling price): 2,500 ÷ 12,500 = 20%

The same item therefore has a "25% markup" or a "20% margin on sales" depending on the calculation. The manager who thinks they earn 25% on their sales actually earns 20%. On 4,200,000 FCFA of weekly sales, the difference between the two readings represents more than 200,000 FCFA of misjudgement every week. To reason about your sales, use the margin rate on sales: it tells you how much is left from every franc sold.

(Prices are taken excluding tax: if you're subject to VAT, the VAT collected isn't your money, it belongs to the State. See our article VAT and filing on Fiscalis.)

What to read from it

• A falling margin rate while prices haven't changed: your purchase prices have risen, or discounts are multiplying.
• A best-selling item with a low margin: it brings customers in (that's its job), but it shouldn't make up the bulk of your sales.
• Discounts concentrated on one salesperson: that's a question to ask, without accusation but without delay.

Why software is essential here

Calculating the margin requires knowing, for each sale, the purchase cost of the item sold. By hand, it's impossible. Management software that links purchases, stock and sales calculates it automatically, item by item.

Dashboard 3: customers

Your customers aren't all equal. A few often account for a large share of your revenue, and a few often account for most of your unpaid invoices. This dashboard tells you who's who.

The indicators

• The top 10 customers for the month and the year, by revenue and by margin.
• New customers for the week or month.
• Inactive customers: your regular customers who haven't bought anything for 30, 60 or 90 days.
• Customer receivables, by customer and by age.
• Customers exceeding their credit limit.

What to read from it

• A regular customer who disappears is often a customer who has gone to a competitor. A call at the right time wins them back more easily than an advertising campaign finds a new one.
• Too much dependence on a single customer is a risk: if they cut their orders or pay late, your whole cash flow suffers.
• Ageing receivables must be dealt with every week. The older a receivable, the harder it is to recover. The reminder method is detailed in our article Invoicing software: automating quotes, invoices and reminders.

To go further in making use of your customer database, we'll dedicate a full article to it: "Customer database and follow-ups: how a simple CRM increases your sales in Cameroon".

Dashboard 4: products and stock

This dashboard links your sales to your stock. It answers two questions: what's selling, and do I have enough of it?

The indicators

• The top 20 items by revenue and by margin.
• Items out of stock or below their reorder point.
• Estimated lost sales on out-of-stock items (average sales × days out of stock).
• Dead stock items: no sales for 60 or 90 days.
• Stock coverage for the main items: how many days of sales your stock represents.
• The total value of stock, and how it's changing.

What to read from it

• A top-20 item out of stock is an emergency: every day costs sales, and sometimes customers.
• Stock value growing faster than sales signals that you're buying too much, or badly. It's tied-up cash.
• Dead stock items need a decision: promotion, bundle, supplier return or discontinuation.

The calculation methods (reorder point, ABC method) are detailed in our guide Stock management for shops in Cameroon.

Dashboard 5: payments and cash flow

Selling isn't enough: you have to get paid. This dashboard tells you where the money is.

The indicators

• The week's payments by payment method: cash, MTN Mobile Money, Orange Money, bank transfer, cheque.
• Till discrepancies for the week, by till and by cashier.
• Total customer receivables and the overdue share.
• Customers' average payment time.
• Supplier debts to be paid in the next 15 days.
• Available cash, compared with upcoming payments due.

Calculating the average payment time

Average payment time ≈ (customer receivables ÷ revenue including tax for the period) × number of days in the period

Example: 6,000,000 FCFA of receivables for 18,000,000 FCFA of revenue including tax over 90 days → an average payment time of about 30 days.

What to read from it

• A payment time that lengthens month after month signals cash flow pressure, even if sales are growing.
• Repeated till discrepancies on the same till or at the same times need checking.
• A growing share of Mobile Money in your payments requires rigorous reconciliation with the merchant account statement. The method is presented in our article Mobile Money: integrating MTN MoMo and Orange Money into your management.
• Supplier payments due exceeding forecast cash must be anticipated now: negotiation, faster customer reminders, postponing a non-urgent purchase.

The Monday ritual: 30 minutes to stay in control

Dashboards are useless if nobody looks at them. Here's a simple ritual to do every Monday morning, before opening or in a quiet moment.

The golden rule: every Monday must end with three concrete actions, written down and assigned to a person. A dashboard that leads to no decision is a useless dashboard.

The 5 mistakes that make dashboards useless

1. Tracking too many indicators. Beyond 5 to 7 figures per dashboard, nobody reads anymore. Better a few indicators checked every week than many ignored.
2. Looking at figures without comparison. Always compare with the previous week, the previous year or a target.
3. Confusing revenue and profit. The margin dashboard comes before the sales dashboard.
4. Working with wrong data. If not all sales are recorded, if stock isn't reliable, the dashboards lie. Data quality starts at the till.
5. Building dashboards by hand. A dashboard that takes two hours of Excel work every week always ends up being abandoned. We've put a figure on what this way of working costs in our article Managing your business with Excel: why it always ends up costing you.

What management software brings

The five dashboards rely on the same data: sales, purchases, stock, customers and payments. When this data is recorded in the same software, the dashboards build themselves, in real time:

• No re-entry: every sale automatically feeds all five dashboards.
• Reliable figures: the margin is calculated using the real purchase cost of each item sold.
• Automatic comparisons: previous week, previous year, target.
• Detail in one click: from an overall figure, drill down to the salesperson, the point of sale, the item or the customer.
• Alerts: a flagship item out of stock, a customer over their limit, a till discrepancy, an abnormal discount.
• Access on your phone: your dashboards follow you, even when you're not at the shop.

Features to demand

• ✅ Sales dashboard with comparisons (week, month, year, target)
• ✅ Average basket and number of sales, by day, by salesperson and by point of sale
• ✅ Margin and margin rate calculated automatically by item and by family
• ✅ Discount tracking by salesperson
• ✅ Top customers, inactive customers and receivables by age
• ✅ Top items, stock-outs, dead stock and stock coverage
• ✅ Payments by payment method, including MTN MoMo and Orange Money
• ✅ Till discrepancies by cashier
• ✅ Configurable alerts
• ✅ Mobile access and data export

To compare the available solutions, see our comparison of the 7 best sales management software in Cameroon. If you need indicators specific to your business (by delivery round, by depot, by sales channel), a custom tool becomes relevant: see our article custom or standard software: which should you choose?.

FAQ

What is the most important indicator for an SME? Gross margin, not revenue. It's what pays your salaries, your rent and your expenses. A business can increase its sales and lose money if its margins fall.

How much time should you spend on dashboards? About 30 minutes a week, provided the figures are produced automatically by software. The time should be spent thinking and deciding, not calculating.

Should you share dashboards with employees? Partly, yes. Sharing with each salesperson their own sales and average basket, or with the storekeeper the stock-outs and dead stock, makes the team accountable. Margins and cash flow generally remain reserved for the manager.

I don't have software yet: where do I start? Start by recording all your sales reliably, with the purchase cost of each item. Without this basic data, no dashboard is possible. Our complete guide to choosing management software helps you take this first step.

Can my dashboard figures replace my accounting? No. Dashboards are for day-to-day management. Accounting, kept by your accountant, produces the financial statements and mandatory returns. Good management software makes both easier by providing clean data.

Conclusion: stop managing by instinct

A full shop doesn't tell you whether the business is making money. Five dashboards do: sales, margins, customers, stock and payments. Checked every Monday for 30 minutes, they turn intuition into decisions, and nasty year-end surprises into corrections made in time.

At Alivaon, in Douala, we design custom sales management software with dashboards built around your real indicators: sales, margins, customers, stock and payments, viewable in real time on your phone. They're fed automatically by your till/POS, your DGI-compliant invoicing and your stock management.

👉 Discover your dashboards: free demo, reply within 24 hours