A useful quarterly business review (QBR) dashboard does more than display results: it helps executives see what changed, why it changed, and what decision is required next. This guide shows how to build a one-page QBR dashboard in Google Sheets or Excel, select practical KPI widgets, prepare an export-ready presentation, and establish a repeatable quarterly update workflow.
Overview
A QBR dashboard is a compact view of business performance for a defined quarter. It should connect strategic priorities to measurable outcomes without forcing the audience to search through multiple worksheets or presentation slides. The best dashboard is not the one with the most charts. It is the one that makes important changes visible and gives each change an owner or next step.
Use the dashboard as the source of truth for the QBR presentation. A spreadsheet-based model is practical because it can preserve historical quarters, document assumptions, support reconciliation, and feed a one-slide executive summary. Whether you work in Excel or Google Sheets, separate the data-entry area from the presentation view so that formatting and formulas are less likely to be disrupted during updates.
Recommended workbook structure
- Instructions: Define reporting dates, owners, metric definitions, status rules, and update steps.
- Current quarter: Enter actual results, targets, prior-quarter values, and notes.
- History: Store comparable quarterly values so trends remain visible.
- Dashboard: Present the selected KPI cards, charts, commentary, and decisions required.
- Action tracker: Record agreed actions, owners, due dates, status, and the next review date.
A simple template can use one row per KPI and columns for metric name, category, owner, target, actual, prior quarter, variance, variance percentage, status, explanation, and action. Add a data dictionary if different teams use terms such as bookings, revenue, active customer, or qualified opportunity differently.
What to track
Choose KPIs that answer the questions executives are likely to ask: Are we progressing toward the plan? Where is performance off track? What is causing the change? What decision or intervention is needed? A useful starting point is six to twelve measures across financial performance, customer or market activity, operational delivery, and strategic initiatives.
Core KPI groups
- Financial: Revenue, gross margin, operating expense, cash position, or forecast variance.
- Commercial: Pipeline value, conversion rate, bookings, retention, average contract value, or customer growth.
- Customer: Active customers, renewal rate, support volume, response time, or satisfaction measure.
- Operations: On-time delivery, cycle time, utilization, defect rate, backlog, or capacity.
- Strategic initiatives: Milestones completed, planned-versus-actual progress, budget used, and risks requiring escalation.
Do not mix incompatible measurement types without labeling them. A percentage, a currency amount, and a count may all be important, but each needs an appropriate display format. Use the same definition and time basis from quarter to quarter. If a metric changes definition, mark the break in the historical series rather than presenting the figures as directly comparable.
Useful dashboard widgets
A one-page executive KPI dashboard can include a row of KPI cards showing actual, target, variance, and status; a trend chart for the most important financial or commercial measure; a compact table of exceptions; and a short list of decisions or actions. Use conditional formatting carefully. For example, define green, amber, and red based on the business context, not on a universal percentage rule. A small variance may be material for one KPI and irrelevant for another.
Include both leading and lagging indicators. Revenue is usually a lagging outcome, while pipeline coverage, delivery capacity, or milestone completion may provide earlier signals. Pairing the two helps the review move from reporting what happened to managing what may happen next. For broader KPI selection, use the Department KPI Template to organize metrics by sales, marketing, finance, and operations.
Cadence and checkpoints
The QBR workflow should begin before the meeting. A practical schedule is a sequence of data collection, reconciliation, interpretation, presentation, and follow-up rather than a last-minute slide refresh.
- Set the reporting cutoff. Confirm the quarter-end date, time zone, fiscal calendar, and whether the review uses closed actuals, preliminary results, or a mixture. Record exceptions in the instructions tab.
- Pull the data. Each KPI owner supplies the latest value, source, definition, and commentary. Use a standard input format and retain source links or report names where possible.
- Reconcile the numbers. Compare dashboard values with the finance, CRM, operations, or project systems that own the underlying data. Check totals, date ranges, units, sign conventions, and duplicate records.
- Refresh the visuals. Update KPI cards, trend charts, status colors, and labels. Confirm that charts include the current quarter and that scales have not hidden meaningful movement.
- Write the narrative. For each material variance, write a concise explanation using the pattern: result, driver, implication, and response. Avoid explanations that merely repeat the number.
- Prepare the review slide. Export the dashboard or reproduce its key elements in one presentation slide. Keep supporting detail in the workbook rather than shrinking every table onto the slide.
- Run the meeting. Spend time on exceptions, trade-offs, decisions, and risks. Treat green results as confirmation, not as a reason to skip important context.
- Update the action tracker. Record the decision, accountable owner, due date, expected outcome, and next checkpoint before the meeting closes.
QBR presentation checklist
- Does the slide identify the quarter and the reporting cutoff?
- Does every KPI show an actual, a comparison point, and a clear unit?
- Are targets and status rules defined consistently?
- Can an executive identify the three most important changes in less than a minute?
- Does every red or amber item have an explanation and proposed response?
- Are forecast figures clearly distinguished from closed actuals?
- Are decisions, owners, and deadlines visible?
- Have formulas, links, chart ranges, and exported files been checked?
For strategic alignment, connect the review to the Strategic Planning Template and use the OKR Spreadsheet Template when quarterly results need to be tied to objectives and key results.
How to interpret changes
Variance is a starting point, not a conclusion. A dashboard should help the team investigate the reason behind a movement. Calculate both the absolute difference and the percentage difference where appropriate. For example, a revenue variance can be expressed as actual revenue minus target revenue, while a volume metric may be better understood as a percentage change from the prior quarter.
Use a consistent review sequence:
- Confirm the signal: Check that the movement is not caused by a formula error, changed definition, delayed entry, duplicate record, or different reporting period.
- Compare the right baseline: Review target, prior quarter, and, when useful, the same quarter in a previous year. One comparison may show delivery against plan while another shows seasonality.
- Separate volume from rate: A change in total revenue may come from more customers, higher prices, larger orders, or a combination. Break the metric into its main drivers.
- Assess materiality: Consider financial impact, strategic importance, persistence, and reversibility. A modest movement may deserve attention if it affects a critical initiative.
- Assign a response: Decide whether to monitor, investigate, correct, reforecast, change an initiative, or escalate a decision.
Use narrative bullets that are specific but appropriately cautious. “Conversion declined after the channel mix shifted toward lower-intent leads; the sales team will test qualification changes next quarter” is more useful than “conversion was below target.” If the cause has not been confirmed, label it as a hypothesis and assign an owner to validate it.
For financial context, connect the dashboard to the Cash Flow Forecast Template. For operational meeting decisions, the Meeting Cost Calculator can help assess whether recurring review time is producing enough value.
When to revisit
Revisit the QBR dashboard every quarter, but do not wait for the next executive review to correct a known problem. KPI owners can maintain source data monthly, while the formal reconciliation, narrative refresh, and action review happen at the quarterly checkpoint. This creates a manageable rhythm without turning the dashboard into a constantly changing reporting project.
Quarterly maintenance routine
- Archive the completed quarter and add the new quarter to the history tab.
- Confirm metric definitions, owners, targets, and status thresholds.
- Check formulas, chart ranges, filters, and linked source data.
- Review whether any KPI no longer supports a current business decision.
- Refresh action statuses and carry forward only open, still-relevant items.
- Compare the current dashboard with the previous quarter before writing the narrative.
Update the template when the fiscal calendar, source systems, strategic priorities, or common KPI definitions change. Review example data and formulas at least annually, and check Google Sheets or Excel compatibility when significant spreadsheet features or reporting processes change. Benchmark rows should also be refreshed when the underlying comparison set changes; do not treat old benchmarks as permanent targets.
To use this QBR dashboard template in the next review, create the workbook tabs, assign one owner per KPI, set the reporting cutoff, and schedule the reconciliation checkpoint before the meeting invitation is sent. After the review, export the final one-slide summary, preserve the completed quarter, and update the action tracker. Repeating those steps each quarter turns the dashboard from a presentation artifact into a durable operating rhythm.
