The 3 reports every SME should have
What reports does an SME actually need?
Most SMEs don't have a management reporting system. The numbers arrive from the accountant once a year — too late to be useful. At the other extreme, some companies produce dozens of sheets that nobody reads.
The solution is in the middle: 3 reports, at different frequencies, that together cover the three critical dimensions of a business: profitability, liquidity, and operations.
Report 1: the weekly dashboard
This is the most important and simplest report. It contains the 5 numbers to check every week: revenue, average margin, 30-day cash balance, production efficiency, order backlog.
Frequency: weekly (every Monday morning) Update time: 10 minutes Format: a sheet with 5 rows and columns for current value, 4-week average, trend
This dashboard is the first step in management control. It doesn't require expensive software — a shared spreadsheet is enough.
Report 2: the monthly management income statement
The management income statement differs from the tax-oriented financial statements the accountant prepares. It doesn't follow tax logic but operational logic: it shows revenue, variable costs, contribution margin, fixed costs, and the net result — every month.
Frequency: monthly (by the 10th of the following month) Key content:
| Item | This month | Same month last year | Budget | Variance |
|---|---|---|---|---|
| Revenue | — | — | — | — |
| Variable costs | — | — | — | — |
| Contribution margin | — | — | — | — |
| Fixed costs | — | — | — | — |
| Operating result | — | — | — | — |
The "Variance" column is the most important: it shows where the business is deviating from plan. If the contribution margin is below budget, the problem is in pricing, costs, or the mix. If fixed costs are higher, there's an unplanned investment or an inefficiency.
The comparison with the same month of the previous year eliminates seasonality and shows the real trend.
Report 3: the quarterly cash forecast
The 30-day cash flow forecast is part of the weekly dashboard. But every quarter, a longer horizon is needed: 90 days, with monthly detail.
Frequency: quarterly (with monthly updates) Key content:
- Current balance
- Expected collections month by month (based on invoices issued and average DSO)
- Expected payments month by month (suppliers, personnel, taxes, installments)
- Planned investments
- Projected balance at quarter-end
This report prevents liquidity crises. If it shows a gap in 60 days, there's time to act: push for collections, renegotiate payments, activate the credit line.
How to start if you have no reports
The priority order is clear:
- Week 1: build the weekly dashboard. 5 numbers, 10 minutes. This is the foundation.
- Month 1: add the 30-day cash forecast. A simple sheet is enough.
- Month 2-3: build the monthly management income statement. Requires a bit more initial work (classifying costs, defining categories) but then updates quickly.
The value of these reports isn't in their complexity — it's in their consistency. An approximate figure checked every week is more useful than a perfect report reviewed once a year.
The spreadsheet problem
Many SMEs already have some form of reporting — almost always in Excel. The issue isn't the tool but the maintenance: sheets become outdated within days, formulas break, data isn't shared.
The solution isn't necessarily expensive software. Often a well-structured sheet, with data updated by one person and shared in the cloud, is sufficient. What matters is that the 3 reports exist and are reviewed regularly.
A fractional controller can build these reports, keep them updated, and present them to the entrepreneur regularly — without the cost of a dedicated internal resource.
The spreadsheets to dashboards guide describes the path to turning these reports into a structured, scalable control system.
Want to build the 3 essential reports for your company? Get in touch for a no-commitment conversation, or learn about our strategic consulting.