To prepare the monthly management report without spending days in Excel, first decide which questions it has to answer, connect it to the source data rather than to exports copied by hand, and separate what repeats every month, which belongs on a dashboard, from what changes from one month to the next, which is asked on the spot. Time moves from gathering data to reading the numbers.
A monthly management report is the document that tells the board or the partners how the month went in sales, operations and finance, compared with the previous month, the same month last year and the plan. In many small and medium-sized businesses, whoever prepares it spends most of the time collecting files and very little reading what they say. This article covers what the report should contain, where the time goes and how to organise the preparation differently.
Why does the monthly report take days to prepare?
The routine is much the same from one business to the next. At the start of the month, someone in finance or management asks for exports from the invoicing software, the ERP and each department's spreadsheets. They paste the figures into a master workbook, refresh formulas and charts, fix the rows that have moved and email the result. The actual analysis gets the last hour.
There are three usual reasons for this.
- The data arrives as copies. Each export is a snapshot of the system at one moment, and an out-of-date file slips through unnoticed.
- The report has grown without a plan. Every request from management added a tab, and nobody removed the ones that stopped being read.
- New questions do not fit the template. When the managing director asks why sales fell in one region, the answer needs a fresh extract and arrives the following week.
What should a monthly management report contain?
There is no single template, and the content should follow the organisation's priorities. Even so, most small business reports fit into four blocks, each with a handful of questions.
| Block | Typical questions |
|---|---|
| Sales | How much was invoiced this month, against last month and the same month last year? Which customers and products explain the difference? |
| Customers and collections | How much is outstanding, and for how long? Which customers have paid late? |
| Costs and purchasing | Which cost lines grew faster than sales? Which suppliers weigh most? |
| Operations | How many orders were delivered on time? Is there slow-moving stock, or delays that keep recurring? |
Three to five indicators per block are enough. Beyond that, the report turns back into a collection of tables nobody reads to the end. The article on which indicators a small business should track helps with that choice.
Two rules of form also save arguments. The first is to write down, in one sentence, the definition of each indicator (what counts as a sale, which date it refers to, whether VAT is included). The second is to show every figure next to a comparison, because a number on its own does not say whether the month went well or badly.
How do you answer management's questions without requesting extracts?
Most of the time spent on the report does not go on the recurring figures but on the questions that come up when someone reads them. This is where conversational data analysis changes the process. Conversational data analysis means querying data by typing the question as you would ask a colleague, with no SQL, and getting an answer calculated from the source tables.
In EngiAnalytics, an analyst types, for example, "how much did we invoice by region this month and in the same month last year?" and gets the answer in seconds, in the most suitable format, as a chart, text or table. When the question calls for it, the answer arrives as several charts at once. For the monthly report, four details matter.
- Every answer explains itself. A sentence in natural language says what the query returns and, if that sentence quotes a number that is not in the data returned, the reader is warned. For a reading of the numbers, the analyst can ask for an analysis of the result.
- The source stays visible. The SQL query behind the answer can be opened and copied, next to the table with the data. Someone who knows the data confirms whether the agreed definition was used.
- The result is ready to send. Data exports as CSV, the chart as an image and the full report as a PDF, neatly presented and ready to go to whoever decides.
- The data stays where it is. EngiAnalytics connects to MySQL and PostgreSQL databases, including ERP and CRM databases running on those engines, and to Excel and CSV files, with no migration or system replacement.
An answer produced by AI is still an answer to be checked, especially when it goes to the board. The article on how to check an AI's answers about company data sets out the precautions.
Which part of the report belongs on a dashboard?
Anything that repeats every month, with the same definition, does not need to be rebuilt by hand. It belongs on a dashboard that is opened the day before the meeting with the data already refreshed. The written report is left for commentary, causes and decisions.
In EngiAnalytics, each person gathers their reports in a dashboard of their own, which they can share. Indicators show variation and trend, with data refreshed every time it is opened. Three features help build the dashboard for the monthly report.
- Indicators proposed by the product. EngiAnalytics identifies the business areas present in the data and proposes indicators for each one. It only presents what it has verified in the real data, and accepting a proposal is enough for the indicator to be tracked from day one.
- The direction of each indicator. Whoever creates an indicator can state whether going up is good or bad. With that, the Summary flags the change as positive or negative. Without it, it describes the change without judging it. For the average collection period or a cost line, going up is bad, and the dashboard should show it that way.
- User profiles. There are three profiles, Administrator, Analyst and Viewer. Viewers open the reports and dashboards already saved, which suits partners who want to see the numbers without preparing anything.
A practical example
Imagine a distribution business with 30 people, where the finance director spends the first four working days of each month preparing an 18-tab report for the partners' meeting. The data comes from the invoicing software, in a PostgreSQL database, and from two spreadsheets kept by the logistics team.
The change happens in four steps.
- Management picks the questions that matter in each block and cuts the report down to twelve indicators, each with its definition written in one sentence.
- The recurring indicators move to a shared dashboard, with the direction of each one set, so that the change shows straight away as positive or negative.
- In the week of the meeting, the finance director opens the dashboard, types the questions the numbers raise and checks the query behind every answer they intend to quote.
- The report sent to the partners contains the dashboard, two or three answers exported as PDF and one paragraph per block with causes and proposed decisions.
The aim is not to do away with the report. It is to turn the use of time around, so that most of it goes on understanding the month and deciding the next one, not on copying figures between files.
Where should you start?
Take last month's report and mark, tab by tab, what was actually read at the meeting. What nobody read goes. What repeats with the same definition moves to a dashboard. What raised new questions is the sign that those questions should be answerable on the spot, without waiting for an extract.
Then confirm where the data for each indicator lives and whether that source is the same every month. A report built on the right source, with written definitions and a few well-chosen questions, takes less time to produce and stands a better chance of changing decisions.
Frequently asked questions
What is a monthly management report?
It is the document that tells the board or the partners how the month went in sales, operations and finance, compared with the previous month, the same month last year and the plan.
How many indicators should a monthly management report have?
For most small businesses, three to five per area are enough. The report should answer the questions management uses to decide, not gather every table available.
Do you need to know SQL to prepare the report in EngiAnalytics?
No. Questions are typed in plain language. The SQL query behind each answer can be opened and copied by anyone who wants to confirm where the numbers come from.
Can the report be exported to send to the partners?
Yes. In EngiAnalytics, data exports as CSV, the chart as an image and the full report as a PDF, neatly presented and ready to go to whoever decides.
Does EngiAnalytics work with ERP data?
It connects to MySQL and PostgreSQL databases, including ERP and CRM databases running on those engines, and to Excel and CSV files, with no migration or system replacement.
Can the partners see the dashboard without preparing anything?
Yes. Anyone with the Viewer profile opens the reports and dashboards already saved. Dashboards belong to each person and can be shared.