Monthly management report for service companies
A monthly management report for service companies: recognised revenue, gross profit by project, utilization, receivables and cash on one page, with an example.
By The DataxLand team· · 5 min read
Service companies — agencies, consultancies, software outsourcers, training firms, accounting practices — sell people's time and expertise, not goods from a warehouse. That is why a retail-style management report (revenue, cost of goods sold, inventory) misses almost everything a managing director needs to know: is the team busy or idle, which projects make money, which clients pay late, how many months of payroll the cash covers.
This post gives a one-page monthly management report template for a service company of 10–50 people: seven metrics, how to calculate them, a worked example and a meeting rhythm for reading the report. The template does not replace statutory financial statements; it is a report for making decisions.
The numbers in this post are an illustrative example for a hypothetical 20-person service company, not a real business's figures.
The three "revenue" numbers of a service company
In retail, the sale and the payment happen almost at the same time. In services, three moments are often months apart:
| Number | Meaning | Example for the month |
|---|---|---|
| Recognised revenue | Value of the work performed in the month | 1,200,000,000 ₫ |
| Invoiced amount | What has been invoiced to clients under contracts and milestones | 1,350,000,000 ₫ |
| Cash collected | Money actually received in the bank | 980,000,000 ₫ |
A management report needs all three, side by side. Recognised revenue tells you how much work the company delivered; invoices tell you how much it has billed; cash collected tells you whether next month's payroll is covered. A month with good revenue but low collections is a sign that receivables are swelling.
Seven metrics on one page
1. Recognised revenue vs plan
The month's recognised revenue, compared with the same month last year and with the plan. Split it by service line (for example: fixed-price projects, monthly retainers, training) to see how much of revenue is recurring.
2. Gross profit by project
Project gross profit = project recognised revenue − direct staff cost − project subcontracting cost
Gross margin = project gross profit ÷ project recognised revenueDirect staff cost is the hours each person spent on the project multiplied by that person's hourly cost (salary, social insurance and benefits divided by working hours). This is the metric that exposes projects "sold at a loss" because the scope grew while the price stayed the same.
3. Utilization
Utilization = hours worked on billable client work ÷ available working hoursExample: 20 people × 160 hours = 3,200 available hours; 2,240 hours logged on billable work → 70%. Too low means paying for time you cannot sell; too high for too long and the team burns out and quality drops. A reasonable level varies by industry and role; what matters is your own company's trend.
4. Operating costs vs budget
Indirect costs (office, software, marketing, support staff) by department, compared with the budget. Just flag the lines that go over budget by more than a threshold (say 10%); there is no need to read every line.
5. Operating profit
Gross profit of all projects minus operating costs. This is the bottom line of the "results" section.
6. Receivables and days sales outstanding
Days sales outstanding (DSO) ≈ receivables at month end ÷ recognised revenue for the month × 30Add the list of overdue clients, split by age (under 30 days, 30–60, 60–90, over 90 days).
7. Cash and months of runway
The month-end cash balance divided by monthly fixed costs (salaries, office rent, software). Since a service company's costs are mostly salaries, this is the "sleep well" metric.
Example one-page report
Hypothetical 20-person company, September:
| Metric | This month | Last month | Notes |
|---|---|---|---|
| Recognised revenue | 1,200,000,000 ₫ | 1,150,000,000 ₫ | +4.3% |
| Direct staff and subcontracting cost | 720,000,000 ₫ | 700,000,000 ₫ | |
| Gross profit (margin) | 480,000,000 ₫ (40%) | 450,000,000 ₫ (39.1%) | Project B margin 18% |
| Utilization | 70% | 74% | Two people waiting for a new project |
| Operating costs | 300,000,000 ₫ | 290,000,000 ₫ | Software 12% over budget |
| Operating profit | 180,000,000 ₫ (15%) | 160,000,000 ₫ (13.9%) | |
| Receivables at month end | 1,800,000,000 ₫ | 1,430,000,000 ₫ | DSO 45 days |
| Cash / monthly fixed costs | 2,400,000,000 ₫ / 850,000,000 ₫ | About 2.8 months |
Read in five minutes, three things stand out: profit is up but receivables grew faster (collections of 980 million ₫ were below recognised revenue of 1.2 billion ₫); utilization fell because two people are waiting for a project; and project B has an 18% margin, far below the overall 40%. Those three things are the three items for the monthly meeting.
A meeting rhythm for the report
- 3rd working day of the month: lock last month's hours and recognised revenue. The report updates itself; nobody has to sit and compile it.
- 5th working day: a 30-minute meeting with team leads. Each person only talks about their own red-flagged lines.
- After the meeting: every red flag gets an owner and a follow-up date — call overdue clients, adjust project B's scope, assign work to the two people who are free.
- Mid-month: get an automatic alert when overdue receivables cross a threshold, without waiting for the monthly report.
How DataxLand does this
DataxLand loads ledgers, invoices and timesheet data from Excel files, accounting software or databases (see Connect data). The finance and accounting pack comes with metrics for revenue, gross profit, costs vs budget, profit, overdue receivables and days sales outstanding; see the template Technology · Finance and accounting and the page tracking accounts receivable. Your own metrics, such as utilization, are defined as workspace metrics, checked and then activated, and run on the same metric engine as the standard metrics.
The monthly report is scheduled to be sent to Telegram, Slack or Microsoft Teams on the day you choose, and the overdue receivables alert runs after every data refresh (see Reports and alerts and automated management reports). The managing director asks Si "why did profit go up this month while collections went down?" and gets an answer with sources.
FAQ
How is a management report different from financial statements?
Financial statements follow the accounting regime, serve tax and regulators, and are usually quarterly or annual. A management report uses metrics the business chooses, is produced monthly or weekly, and exists to support decisions. Both should draw on the same source numbers so they do not disagree.
How do I calculate utilization without timesheet software?
Start with a simple spreadsheet: each person logs hours by project every week. Moderate accuracy is still enough to see the trend. Once the habit sticks, move to a time-tracking tool that can export data.
How should fixed-price project revenue be recognised month by month?
Usually by percentage of completion (for example by milestone, or by hours worked over total estimated hours). Recognition for the financial statements must follow the accounting regime your company applies; ask your accountant so that the management report uses the same principle.
How many metrics are enough for one page?
Seven to ten. More than that and the meeting reads numbers instead of making decisions. Keep detailed metrics on secondary pages, opened when a line is red-flagged.
Read next: What is a semantic layer? · Automated reports via Telegram · DataxLand for finance and accounting