Example

Monthly Management Report Example

A 110-person healthcare technology company in Oxford with £6.2M revenue. The FP&A team produces a monthly management pack by the 10th working day of each month. This February pack covers January performance and is distributed to the CEO, CTO, VP Sales, VP Operations, and department heads.

Example data

Financial model

P&L Summary
Jan Actual
Jan Budget
£ Var
YTD Actual
Revenue
£528k
£510k
+£18k
£528k
Gross Profit
£369k
£357k
+£12k
£369k
OpEx
(£305k)
(£295k)
(£10k)
(£305k)
EBITDA
£64k
£62k
+£2k
£64k
GP Margin
69.9%
70.0%
-0.1pp
69.9%
Cash Balance
£1,450k
£1,380k
+£70k
£1,450k
Revenue

Revenue beat driven by an unplanned upsell to an existing enterprise customer (£12k) and stronger-than-expected new business in the NHS vertical (£6k).

OpEx

OpEx overrun of £10k driven by recruitment fees (£7k for a senior hire) and a one-off legal cost (£3k). Both items are non-recurring.

Cash Balance

Strong cash position reflects improved collections. The finance team renegotiated payment terms with three large NHS trusts, reducing average DSO from 45 to 38 days.

Formulas

Key formulas

fx£ Variance = Actual - Budget

January came in £2k ahead on EBITDA despite a £10k OpEx overrun, because revenue and gross profit outperformed by £12k and £18k respectively.

fxGP Margin = Gross Profit / Revenue * 100

Gross margin at 69.9% is marginally below the 70% budget target. The 0.1pp shortfall is immaterial but worth monitoring if the trend continues.

fxCash Variance = Actual Cash - Budget Cash

Cash is £70k ahead of budget, driven by faster customer collections (DSO improved from 45 to 38 days) and timing of supplier payments.

Analysis

What makes this example good

Published by the 10th working day, ensuring timely decision-making
Both month and YTD views provide immediate and cumulative perspective
Commentary explains the "why" behind every material variance
Cash position included alongside P&L for a complete financial picture
Non-recurring items flagged separately to distinguish signal from noise

Customisation

How to adapt for your business

1

Add a department-level P&L breakdown below the consolidated view

2

Include a rolling forecast update alongside the BvA

3

Add operational KPIs relevant to your industry (pipeline, utilisation, churn)

4

Include a "key risks and actions" section for forward-looking commentary

5

Add trend charts for the 3-5 most important metrics

Common variations

  • --Flash report (revenue and cash only) issued within 3 days of month end
  • --Detailed management pack with 10+ pages of analysis
  • --Board-ready version with executive summary and strategic commentary
  • --Department-specific packs for each cost centre owner

FAQ

Frequently asked questions

Best practice is 5-10 working days after month end. "Flash" numbers (revenue and cash) should be available within 3 days. The full pack with variance commentary takes longer but should not exceed 10 working days.

Build this in Grove FP in 10 minutes

No credit card required. Set up in minutes. 30-day money-back guarantee.