The Monday leadership meeting: automate the dashboard everyone rebuilds every week
If your Monday meeting opens with “which of these numbers is right?”, it is not a decision meeting. It is a reconciliation.
Every Monday, each manager arrives at the leadership meeting with their own spreadsheet, and the meeting starts by reconciling figures instead of deciding. One shared dashboard, fed by your tools and updated on its own, gives that time back to decisions. Here is how to build it, starting from what you already have.
7 min read
In this guide
- Put a figure on the time your team spends rebuilding its reports every week
- Choose the five to seven indicators that deserve a place on the meeting table
- Know what an automated dashboard takes, step by step
Contents
Sales has its figures, accounting has its own, production has its schedule. Each was extracted, copied and formatted during the week. In the meeting the totals don’t match, and the discussion turns to which version of the number is right rather than what to do. What a business leader needs is not one more report: it is one shared reading, the same for everyone, ready before the meeting.
01The data exists; the shared reading is missing
French small and mid-sized companies already steer with their data: 76% of them use it to manage their business, according to the France Num 2026 barometer (in French) from the French Directorate-General for Enterprise. But each mostly looks at its own area: 65% use their accounting and finance data, 53% their customer and sales data, and only 31% a cross-department dashboard, the one that puts every department on the same page.
- Accounting, finance
- 65%
- Customers, sales
- 53%
- HR, payroll
- 41%
- Suppliers, purchasing
- 40%
- Cross-department dashboard
- 31%
- Production management
- 21%
Source DGE, France Num 2026 barometer (in French), page 50: share of French micro, small and mid-sized companies using this data to manage the business (9,655 respondents).
The cross-department dashboard is also the only use where the spreadsheet comes ahead of business software: 19% against 11%, again according to France Num. In other words, the overall view is most often a file assembled by hand. This is not new: a Grant Thornton study quoted by Journal du Net (in French) already found that directors and managers spend most of their time building their reports rather than analysing them, and that 3 small businesses in 5 doubted the reliability of their analysis.
02What the hand-built report costs
The calculation is the same as for any repetitive task: duration, frequency, number of people, fully loaded hourly cost. The values below are illustrative assumptions; replace them with your own.
| Value | Assumption | Result |
|---|---|---|
| Managers involved | 5 | |
| Preparation time | 1.5 hours per person per week | |
| Weeks worked | 44 | |
| Total time | 5 × 1.5 × 44 | 330 hours a year |
| Fully loaded hourly cost | €40 | |
| Annual cost | 330 × 40 | €13,200 a year |
330 hours is about a fifth of a full-time job, counting the statutory French working year of 1,607 hours (in French). €40 an hour is a cautious assumption: an hour of work cost €44.7 on average in 2025 in French market-sector companies with 10 or more employees, according to INSEE (in French).
03What an automated dashboard looks like
Automating does not mean buying one more piece of software. It means connecting the tools where your figures already live, fixing once and for all how they are calculated, and delivering the result where the meeting reads it.
- 1
Connect the sources
Business management software, CRM, accounting, shared spreadsheets: the data is read where it is entered, with no export and no copy-paste.
- 2
Write one definition per indicator
Invoiced or ordered revenue? Calendar or rolling week? Each figure has one written, shared definition, and therefore one value.
- 3
Update without anyone stepping in
The dashboard recalculates every night or early every Monday. Nobody has to prepare it.
- 4
Deliver it where it is read
A shared screen, a PDF in every member’s inbox on Monday morning, or both.
- 5
Flag the gaps
When an indicator leaves its usual range, the manager concerned is told before the meeting, not during it.
04The indicators that deserve the meeting table
Five to seven indicators are often enough. The right choice depends on your business; the grid below helps sort the ones you already track.
Indicator
What it shows
The question to ask
01Revenue invoiced this week
What it showsThe pace of activity, compared with the same week last year
The question to askDoes the gap come from volume or price?
02Orders received and order book
What it showsRevenue for the weeks ahead
The question to askDoes the order book cover the next weeks of production?
03Quotes sent and conversion rate
What it showsThe health of sales work
The question to askWhich quotes need a follow-up this week?
04Overdue customer receivables
What it showsCash sitting with customers
The question to askWho follows up, and by when?
05Items below stock threshold
What it showsStock-outs on the way
The question to askHave the supplier orders gone out?
06Average delivery or service lead time
What it showsWhat the customer experiences
The question to askIs the promised lead time still being met?
05How we work
We start from the dashboard your leadership meeting already uses, and from the tools where its figures are entered. We connect the sources, write the definitions with you, and deliver a dashboard that updates itself, with its documentation. Everything we deliver is yours: the connections, the code, the data and the documentation. A distributor we worked with automated the receipt of its orders, their entry and its stock checks: it saves €1,000 a month (3plus case study, saving reported by the client).
Before your next leadership meeting
- List the reports each manager prepares before the meeting.
- Note how long each one takes, and from which tools.
- Spot the figures that appear in several reports with different values.
- Write a one-sentence definition of each of those figures.
- Keep the five to seven indicators that actually change a decision.
Frequently asked questions
How do you automate a leadership dashboard?
In four steps: connect the tools where the figures are entered (business management software, CRM, accounting, shared spreadsheets), write a single definition for each indicator, schedule the update (every night or every Monday morning), then deliver the result where the meeting reads it, on a shared screen or as a PDF by email. An alert can tell the manager concerned when an indicator leaves its usual range.
Which indicators belong on a small company’s leadership dashboard?
Five to seven indicators are often enough: revenue invoiced this week, orders received and the order book, quotes sent and their conversion rate, overdue customer receivables, items below stock threshold, and delivery or service lead time. Keep only the ones that change a decision made in the meeting.
How much does a hand-built report cost?
Multiply the preparation time by the number of people, the number of weeks worked and the fully loaded hourly cost. Example: five managers spending 1.5 hours a week on their reports, over 44 weeks, comes to 330 hours a year, or €13,200 at €40 an hour. B&Y Beyond’s calculator runs this calculation with your own values.
Why are the figures never the same from one department to another?
Because each department calculates the same indicator its own way: ordered or invoiced revenue, calendar or rolling week, with or without credit notes. The fix is to write one definition per figure, then calculate it once, automatically, from the same sources.
Do you need business intelligence software to automate a dashboard?
Not always. A visualisation tool (Power BI, Looker Studio, Metabase…) suits many sources; a shared spreadsheet fed automatically is often enough for a small company’s leadership meeting. The choice depends on the number of sources, the number of readers and the tools the team already uses.
Can you automate a dashboard when the data lives in Excel files?
Yes, as long as the files are shared and their structure stays stable: same columns, same tabs, same place. It is the most common case, since the spreadsheet is the most used tool for cross-department dashboards in French small businesses, according to the France Num 2026 barometer (in French).
Who owns a dashboard built by a contractor?
It depends on the contract: check that it includes handing over the code, the access and the documentation, and that the dashboard runs on your own accounts. With B&Y Beyond, everything delivered is yours, and you stay free to develop it with us, in-house or with another provider.
Sources
- French Directorate-General for Enterprise (DGE), France Num 2026 barometer, final report (survey of March and April 2026, 9,655 micro, small and mid-sized companies), pages 49 and 50, in French
- Journal du Net, “Défi 2022 : repenser les reportings pour viser la croissance” (Grant Thornton study “Le pilotage des PME : l’enjeu du reporting”, 2021), in French
- INSEE, Hourly labour cost in the European Union, 2025 annual data (published 18/09/2026, in French)
- French Ministry of Labour, Part-time work (statutory annual working time of 1,607 hours, in French)
- B&Y Beyond, case studies (saving reported by the client)
Analysis by B&Y Beyond, an independent third party. Raw data on request.
Written by Maleaume B.
Get the analysis for your company
Does your leadership team rebuild its figures every week?
Send us the list of reports prepared before your meeting. We put a figure on the time they take and on what an automated dashboard would change, before any commitment.