Reports & meetings

Monthly Report Template: KPIs, Highlights and Next Month's Plan

A monthly report tells leadership how a team or department performed against its targets over the past month, what went well, what got in the way, what the team will do next month and what support it needs. A weekly status report answers "what did we do this week?". A monthly report has to answer a harder question: "where are we against our goals, and why?"

On this page you can download a free monthly report template in Word and Excel, see how to build the KPI table, read a filled example from a B2B sales team, follow a one-hour routine that turns four weekly reports into one monthly report, and avoid the mistakes that make monthly reports go unread.

What is a monthly report?

A monthly report is a management report that summarizes a team's key performance indicators (KPIs) as target, actual and achievement rate, and adds the month's highlights, the root causes of any misses, next month's goals and the resources the team is asking for. Most teams write it in the first week of the month, once the previous month's numbers are closed, and use it as the pack for the monthly business review.

A good monthly report starts and ends with numbers. For every KPI below target it gives a cause and a fix; for every KPI above target it names the repeatable driver behind it. That is what lets leaders decide on budget, headcount and priorities. Think of it not as a diary of the month, but as a document that helps someone make next month's decisions.

When do you need a monthly report?

  • Preparing the pack for a monthly business review or leadership meeting
  • Tracking team KPIs against targets on a regular rhythm
  • Building the evidence for quarterly or half-year performance reports
  • Justifying a request for extra budget or headcount
  • Sharing monthly operating results with head office, branches or partners

How to fill in the monthly report template

The download contains exactly these fields. Fill in the KPI table first and write the summary last.

Basics

FieldWhat to writeExample
Reporting monthThe closed month and its dates.October 2026 (Oct 1–31)
Team and authorTeam name, author and reviewer.Sales Team 2 – Jordan Miller, team lead
AudienceWho reads it: the review meeting, your director.VP Sales, CEO
One-line summaryThe month's result and the single most important ask, in one or two sentences.New deals at 115% of target, revenue at 95%. Asking for more lead-generation budget in November.

KPI results

FieldWhat to writeExample
KPIFour to six metrics the team owns. Keep the same ones every month.New deals closed
TargetThe month's target agreed at the start of the year or quarter.40
ActualThe closed value, with the source system noted.46 (CRM)
AchievementActual ÷ target × 100, rounded to one decimal.115.0%

Analysis and plan

FieldWhat to writeExample
HighlightsKPIs above target, why, and what other teams could reuse.Bundle discount for renewing customers added 6 new deals
Misses and root causesOne or two causes per missed KPI, with evidence.Revenue 95%: one large delivery slipped to November
Next month's goalsKPI targets plus three key initiatives with owners and dates.330 new leads with Marketing by Nov 30
Support neededThe decision you need, the amount or headcount, and a deadline.Increase November paid-search budget by $2,500 – decision by Nov 10

Monthly report example

October report for the sales team of a B2B software company. Leadership can decide on November's budget from the summary and the KPI table alone.

MonthOctober 2026
TeamSales Team 2 (author: Jordan Miller)
Summary46 new deals, 115% of target; revenue at 95% because one large delivery moved to November. Lead generation reached only 85%, so the November pipeline needs support.
RequestPlease approve a $2,500 increase to November paid-search spend by Nov 10.

Monthly KPIs

KPITargetActualAchievement (%)
New deals closed4046115
Revenue (USD thousand)52049495
Customer inquiries handled1,2001,260105
New qualified leads30025585

Achievement = actual ÷ target × 100, rounded to one decimal. For lower-is-better metrics such as churn or defect rate, report the gap to target instead of an achievement rate.

Free download

Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.

Open the downloaded file in Nobami, our web office, to edit it right away.

Write a monthly report in one hour

  1. Collect the month's weekly reports. Putting four or five weekly reports side by side shows the trend of the month and the problems that kept coming back.
  2. Lock the KPI numbers from the source systems. Use the closed values from your CRM, finance or support tool, and calculate every achievement rate with the same formula.
  3. Explain what drove the wins. Look for a repeatable action – a campaign, a process change – rather than luck, so the result can be repeated.
  4. Give causes and fixes for the misses. Back each cause with data and give each fix an owner and a date.
  5. Set next month's goals and asks. List KPI targets, three key initiatives and any budget or headcount decision with an amount and a deadline.
  6. Write the summary last and send on a fixed date. Keep it to two sentences – result, cause, ask – and publish on the same working day every month.

Good practice and privacy notes

Monthly reports are internal business records, but they often contain personal data: customer names, individual sales figures, absence counts. In the EU and the UK, information about identifiable colleagues and customers is personal data under the GDPR, so aggregate where you can and share the report only with the people who need it.

If report figures will be used to evaluate individual employees, tell people in advance which metrics count and apply the same rules to everyone. In some countries, tools that monitor performance also require consultation with a works council or employee representatives before they are introduced.

Do not present overtime as an achievement. Working-time limits differ by country, and long hours belong in your time-recording system, not in the KPI table.

Sources

General information, not legal advice. Employment and privacy rules differ by country and company; follow your internal policy.

Common monthly report mistakes

  • Listing everything the team did in date order without comparing it to targets
  • Changing KPIs every month, so nobody can compare with last month or last year
  • Writing "we will try harder" next to a missed KPI instead of a cause and a fix
  • Mixing numbers from different sources, so the meeting is spent arguing about data
  • Asking for support without an amount, headcount or decision date
  • Pasting customer or employee personal data instead of aggregated figures

Monthly report FAQ

What is the difference between a monthly report and a weekly status report?

A weekly status report shares progress and next week's plan with your manager. A monthly report compares KPIs with targets, explains why, sets next month's goals and asks for decisions. Use your weekly reports as the raw material for the monthly one.

How long should a monthly report be?

One or two pages of main text is enough. Put the summary and the KPI table on page one and move detailed data to an appendix or a separate spreadsheet tab.

How do I calculate KPI achievement?

Divide actual by target and multiply by 100, rounded to one decimal. For lower-is-better metrics such as churn, the same formula reads backwards, so show the gap to target instead.

How should I report a month where we missed badly?

Say it in the first line of the summary. Explain the cause with data and add a recovery plan and the support you need. Hiding a miss costs more trust than the miss itself.

Can I use the template in Google Docs or Sheets?

Yes. The Word file opens in Google Docs and the Excel file opens in Google Sheets, LibreOffice and Numbers.

Submit this form for approval in Workbami

Stop emailing spreadsheets around. Fill in, approve and file it in Workbami, where approvals, reports and team chat live together. Free during the beta.

Start free

Related templates

← All templates