Quarterly Business Reviews are the highest-stakes meeting in an MSP account relationship — and the most expensive to prepare. Most account managers spend three to five hours per client pulling PSA exports, building slides, and writing an executive summary from scratch.
Generic "MSP QBR template" content online tells you what sections to include. It does not tell you what an automated QBR actually contains, how the data is sourced, or how long the whole process takes when your PSA is connected. This article does.
Manual QBR prep: where the time goes
A typical manual QBR for one client breaks down roughly like this:
- 45–60 min — exporting and filtering tickets and projects from HaloPSA or ConnectWise
- 60–90 min — building charts in Excel or PowerPoint (volume trend, resolution times)
- 45–60 min — writing executive summary and quarter commitments
- 30–45 min — formatting slides, branding, and proofreading
Total: 3–5 hours per client per quarter. Ten active QBR accounts means 30–50 hours of senior time every quarter — before the meeting itself.
What a Handover QBR pack contains
Handover's QBR Pack Builder pulls live ticket and project data from your PSA for a chosen date range and client, then generates every section below. You choose which slides to include; sections without sufficient data are flagged rather than filled with placeholders.
1. Executive summary
Quarter-level narrative written for the client director — what was delivered, what slipped, and what the relationship health looks like. Pulled from ticket volume trends, project status, and open risks.
2. Ticket volume trend
Weekly ticket counts across the reporting period as a bar chart — shows whether demand is rising, falling, or stable. Useful for capacity conversations and scope discussions.
3. Resolution performance by priority
Average hours to resolve P1, P2, and P3 tickets with ticket counts per band. Answers the question directors actually ask: are critical issues being handled fast enough?
4. Ticket breakdown
Distribution by category or status (configurable) — e.g. incidents vs requests, or open vs resolved mix. Includes a note when PSA data is incomplete.
5. Open vs closed
Raised, resolved, and still-open counts with resolved percentage. A single slide that shows whether the account is getting healthier or busier.
6. Project status (RAG)
Each active project with completion percentage, Red/Amber/Green rating, owner, and next action. The slide account managers spend the most time building manually.
7. SLA performance
Compliance percentage for the period when SLA data is available from the PSA.
8. Recurring issues
Top repeat ticket themes with counts and percentage of volume — surfaces systemic problems (same printer, same VPN issue) that one-off ticket stats hide.
9. Period comparison
Current vs previous quarter on volume, resolution rate, and average resolution hours, with a trend line narrative.
10. First contact resolution
FCR percentage with evaluated ticket count and benchmark note.
11. Risks, actions, and next-quarter commitments
Structured risks and actions from the period, plus numbered quarter priorities — action, risk addressed, owner, and target date. The centrepiece slide for renewal conversations.
Example: next-quarter commitments slide
The commitments slide is what directors remember. Here is representative output from a multi-client portfolio QBR — numbered priorities with owner and target:
Complete Office 365 SPF/DKIM remediation for Northwood Manufacturing sales team (Ticket #1001)
Target: 11 Jun 2026
Finalise MFA rollout for remaining 8 accounts at Northwood Manufacturing (Ticket #1002)
Target: 28 Jun 2026
Execute Fortigate 200F firewall migration for Bridgewater Council during agreed Saturday window
Target: 12 Jul 2026
PowerPoint and Excel export
The QBR exports as a branded PowerPoint (.pptx) deck with your logo and colour, plus an Excel workbook with the underlying ticket metrics. Slides use your MSP branding — not a generic template. A sample deck structure includes title slide, executive summary, ticket metrics charts, resolution-by-priority bars, project RAG table, SLA slide, recurring issues, period comparison, and commitments.
You can preview the pack in-app before export, edit the executive summary, toggle sections on or off, and download when ready. The PPTX is what you send ahead of the meeting or present live — not a PDF screenshot of a dashboard.
How long automated QBR generation takes
| Step | Manual | Handover |
|---|---|---|
| Data gathering | 45–60 min | Automatic (PSA sync) |
| Charts and metrics | 60–90 min | ~2 min generate |
| Executive summary + commitments | 45–60 min | Included in generate |
| Slide formatting + export | 30–45 min | One-click PPTX |
| Total (typical) | 3–5 hours | 15–30 min review |
Automation does not remove the account manager from the QBR — it removes the data wrangling. You still review the executive summary, adjust commitments, and add relationship context the PSA cannot see. The difference is starting from a complete first draft instead of a blank PowerPoint.
For a deeper look at QBR strategy, see our guide on how MSPs automate QBR preparation without losing quality. To try the pack builder: start a free trial, connect your PSA, and open QBR Pack from the main navigation.
Generate your next QBR in minutes
Connect HaloPSA or ConnectWise, pick a client and date range, export a branded PPTX — 14-day free trial.