Skip to content
Efidis
Efidis

OperationsUpdated 9 min read

The Monday dashboard: 12 weekly KPIs for small businesses

3D illustration of a tablet with a lilac bar chart, a calendar with Monday marked and a coffee mug.
In this article

Illustrative example: at 8 a.m. on Monday, the manager of a distribution business asks "how are we doing?" By 11 he has three different answers. Sales says it was a good week, receivables says nobody paid and the warehouse says two products ran out. All three are right, and none of them says what to do.

A weekly dashboard fixes that if it's short, if it's calculated the same way every time and if every number has someone who answers for it. You don't need business intelligence software to start: a spreadsheet with 12 rows will do.

The rule: one number, one owner, one alarm

Before you pick KPIs, set the rule that makes them useful. Every row on the dashboard has three things:

  • A number, always calculated with the same formula from the same source. If it's pulled differently every week, you can't compare it.
  • An owner: one named person who explains the number in the meeting and decides what to do. "The sales team" isn't an owner.
  • An alarm: the value at which someone has to act this week. Without an alarm, a KPI is decoration.

If a KPI has no owner, or nobody knows what they'd do if the alarm went off, take it off the dashboard. Twelve rows people read beat forty rows people file away.

The template: 12 KPIs in four blocks

Copy this table into a spreadsheet, one row per KPI, and add a column for each week. The thresholds are illustrative starting points: adjust them with your last 8 to 12 weeks of data.

KPIFormulaData sourceOwnerAlarm
1. Sales vs. targetInvoiced sales for the week ÷ weekly targetInvoicing or point of saleSales leadBelow 90% of target two weeks in a row
2. Gross margin(Sales − cost of goods sold) ÷ salesInvoicing and inventory costOwner or financeDrops more than 2 points vs. the 8-week average
3. Close rateQuotes accepted ÷ quotes sent (last 4 weeks)Quote logSales leadDrops 5 points vs. the previous month
4. Cash daysCash and bank balance ÷ average daily outflows (last 30 days)Bank statementsOwner or financeUnder 30 days
5. Past-due receivablesPast-due invoices ÷ total accounts receivableReceivablesCollections leadOver 20%, or rising three weeks in a row
6. Days sales outstanding (DSO)Accounts receivable ÷ credit sales for the last 90 days × 90Receivables and invoicingCollections leadMore than 10 days over your credit terms
7. Days of inventoryInventory at cost ÷ daily cost of goods sold (90-day average)Inventory and invoicingPurchasingRising three weeks in a row with no season to explain it
8. StockoutsSKUs with open orders and zero stock ÷ active SKUsInventory and ordersWarehouseAny of your top 20 sellers out of stock
9. Dead stockValue of SKUs with no sales in 90 days ÷ total inventory at costInventoryPurchasingOver 15% of inventory
10. On-time, in-full deliveryOrders delivered complete on the promised date ÷ orders deliveredShippingOperationsUnder 95%
11. First response timeMedian minutes between a customer message and the first reply, during business hoursWhatsApp, email or help deskCustomer serviceOver 60 minutes
12. Repeat customersCustomers who bought in the previous 90 days and again in the last 90 ÷ customers in the previous 90 daysSales by customerSales leadFalling three weeks in a row

If you sell services and carry no inventory, swap block 3 for capacity: billable hours ÷ available hours, late projects and hours worked but not yet billed (count them from signed service orders).

How to read each block

Sales: the target, the margin and what's coming

This week's sales tell you where you are; the close rate tells you where you'll be next month. If sales look fine but you're closing fewer quotes, the problem shows up late and all at once. Gross margin guards against the most common trap: selling more on discounts and making less.

Cash: the block that can't wait

Cash days answer a simple question: if no money came in starting tomorrow, how many days could you keep paying bills? In an analysis of 597,000 U.S. small businesses, the typical one held enough cash for 27 days with no inflows, and one in four had 13 days or less (JPMorgan Chase Institute, 2016). That's why the template's alarm is at 30 days: below that, one late payment from a big customer turns into a payroll problem.

Past-due receivables and DSO almost always explain why cash is dropping. In North America, past-due invoices averaged 23% of B2B receivables, though most were paid within a month of the due date (Atradius, 2026). The lesson for the dashboard: what you collect in the first few weeks comes in; what you let age, much less of it does. Check past-due receivables every week, not at month end. What each day of delay costs you is in what getting paid late costs.

Inventory: what's missing and what's piling up

Read the three inventory KPIs together. High days of inventory plus high stockouts means you bought what doesn't sell and you're short on what does. Dead stock is cash sitting on a shelf: if it's over 15%, Monday's conversation is about what to clear out, not what to buy. The formulas are in what dead stock costs you.

Customers: the slowest signal

On-time delivery and response time are what customers feel; repeat customers are the result. It's the KPI that moves the slowest and matters the most. According to research by Frederick Reichheld of Bain & Company, increasing customer retention by 5% increases profits by 25% to 95% (cited in Gallo, 2014). The range is wide and depends on the industry, but the direction is clear.

The Monday meeting in 30 minutes

A dashboard is useless without a short meeting where people read it. This agenda fits in half an hour with four or five people.

  1. Before 9 a.m.: the dashboard is updatedEach owner enters their number Friday afternoon or early Monday. Nobody shows up to the meeting to do math.
  2. Minutes 0 to 5: alarms onlyRead only the KPIs that triggered an alarm. Whatever is green doesn't get discussed.
  3. Minutes 5 to 20: one cause and one action per alarmThe owner of the number explains in one sentence why it happened and what they'll do this week. If they don't know the cause, the action is to find out.
  4. Minutes 20 to 25: the trendLook at the last eight weeks for two or three KPIs that keep getting worse without hitting the alarm yet.
  5. Minutes 25 to 30: commitments in writingEvery action goes in the same spreadsheet with an owner and a date. Next Monday starts by checking whether they got done.

How to have AI draft the weekly summary

An AI assistant can read your spreadsheet and write the summary before the meeting. It works if you give it the sheet with the weekly columns and ask for something specific: "This is our weekly dashboard with 12 KPIs and their alarm thresholds. Tell me which KPIs triggered an alarm this week, which have gotten worse three weeks in a row without hitting the alarm, and what two questions a manager would ask about each one. Don't calculate new KPIs and don't assume causes that aren't in the data."

AI is good at spotting trends in a table and writing them up. It doesn't know why margin dropped or whether the big customer will pay on Thursday. Use the summary to prepare for the meeting, not to replace it, and check the numbers against the sheet: language models can misread or misadd figures.

Mistakes that ruin a dashboard

  • Changing a formula without telling anyone. If "sales" includes sales tax one week and not the next, the trend is fake.
  • Looking only at averages. An average response time of 20 minutes can hide customers who waited a full day; that's why the template uses the median, and it's worth checking the outliers.
  • KPIs nobody can move. If the owner has no way to act on the number, the number doesn't belong there.
  • Alarms that never go off, or always do. Review thresholds every quarter.
  • Building the dashboard Monday morning. If pulling the data takes more than 15 minutes, the problem is where your data lives.

When this dashboard isn't a good fit

  • If your business has very few transactions per week (say, five big projects a year), weekly numbers swing too much. Use the same KPIs on a monthly cycle.
  • If nobody will act on the alarms. A dashboard reviewed with no consequences trains the team to ignore it.
  • If your source data isn't reliable. Inventory records that don't match the warehouse produce made-up days of inventory; fix the source first.
  • If you already have a dashboard that works. Don't swap it for this one: compare the rows and add only what's missing, especially cash days.

When building the dashboard takes longer than reading it

The first version of this dashboard is almost always built by hand: someone exports sales, receivables and inventory from three different places and pastes them into a spreadsheet. That time adds up. Asana found that 58% of the workday goes to "work about work," like searching for information and chasing status updates (Asana, 2023).

If someone spends every Monday morning pulling numbers together, the dashboard has already taught you its first lesson: your data lives in too many places. When sales, receivables, inventory and shipping are in one system, the 12 KPIs are calculated from today's data, and Monday is left with the part that actually needs people: deciding what to do. That's what well-connected custom software solves.

Sources

  1. JPMorgan Chase Institute, "Cash is King: Flows, Balances, and Buffer Days" (597,000 small businesses, 2015 data), 2016 (opens in a new tab)
  2. Atradius, "B2B payment practices trends in North America 2026" (Payment Practices Barometer), 2026 (opens in a new tab)
  3. Amy Gallo, "The Value of Keeping the Right Customers," Harvard Business Review, 2014 (opens in a new tab)
  4. Asana, "Anatomy of Work Global Index 2023," 2023 (opens in a new tab)
See how we work in route-based distribution

Frequently asked questions

Your Monday numbers, ready without building them

Efidis builds your company's app and calculates your KPIs from today's data. On the call we'll pick the numbers you need each week with you and see where they come from today.