By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 20, 2026
A good board report answers three questions: where the business stands against plan, where it is heading, and what you need the board to decide. The metrics that do this are a short set: cash and runway, revenue and margin against budget, a current forecast, a handful of operating KPIs, and the main risks. If your numbers already live in Excel or Google Sheets, you can build the whole package there, and our spreadsheet-based finance work at Frac CFO is built around exactly that setup.
This guide shows which metrics to include, how to arrange them, how to write the commentary, and how to keep the package short enough that directors read it.
TL;DR
- Lead with a one-page summary: headline results, the key numbers, and the decisions you need from the board.
- Show every key number as actual vs. budget vs. last year, month and year-to-date, plus a full-year forecast.
- Explain each material variance in plain words: what happened, why, what you are doing about it, and the expected year-end effect.
- Keep the metric list short and consistent from meeting to meeting so trends are visible.
- A spreadsheet is enough to produce a board-ready package when it is structured well.
Table of Contents
- What the board actually needs from a report
- The core metrics to include
- How to lay out a board financial package
- Always include a forecast
- Write commentary that explains the variance
- Board reporting best practices
- A decision page for every meeting
- Building the package in Excel or Google Sheets
- Get a board package built for your business
- Our perspective
- FAQ
- Sources
What the board actually needs from a report
Before choosing metrics, decide what the report is for. The Bayes Business School good-practice guide describes the purpose of the reports as a set: together they let the board understand the external environment, track strategic goals, be confident the organization is run well and complies with its obligations, and know that its decisions are carried out. The same guide says papers need a clear purpose and enough information to support a decision or assess performance.
For a small or mid-sized company, that translates into a simple rule. Every number on the page should help a director do one of three things: judge performance, spot a risk early, or make a decision. If a metric does none of those, it belongs in an appendix or nowhere.
This matters most for the readers of this guide: founders reporting to investors, e-commerce owners with an advisory board, retail or service business leaders reporting to partners or a lender. Your directors are usually busy and not in the day-to-day. They want the story, not the ledger.
The core metrics to include
There is no single official list of board metrics for private companies. What the professional guidance agrees on is structure: progress against plan, a few key numbers, and analysis that supports decisions. Within that structure, these are the metrics most small and mid-sized boards ask for.
| Area | Metric | What it tells the board |
|---|---|---|
| Cash | Cash balance, monthly net cash flow, runway in months | Whether the company can fund its plan |
| Growth | Revenue vs. budget and prior year | Whether sales are on track |
| Profitability | Gross margin %, operating margin %, EBITDA | Whether growth is turning into profit |
| Efficiency | Burn rate, operating expenses vs. budget | Whether spending is under control |
| Working capital | Receivables days, inventory days, payables days | Where cash is getting stuck |
| Outlook | Full-year forecast vs. budget | Whether the plan still holds |
| Operations | 3 to 6 KPIs specific to your model | Whether the engine behind the numbers is healthy |
| Risk | Top risks and what is being done | What could knock the plan off course |
Cash and runway first
Cash is the metric no board member forgives you for missing. Show the opening balance, cash in, cash out, closing balance and runway in months on one small table. A rolling 13-week cash forecast is a practical way to show the short-term view, and a monthly view carries the rest of the year.
Runway is simply cash on hand divided by average monthly net burn. If you hold $240,000 and burn $30,000 a month on average, runway is eight months. Show the calculation basis once so directors can trust it.
Revenue, margin and spending against plan
Show revenue, gross margin and operating expenses against budget and last year. Gross margin is revenue minus the direct cost of delivering it, divided by revenue. For an e-commerce company, that means product cost, shipping, payment fees and returns. For a service business, it means delivery labor and direct costs. Choosing one definition and sticking to it matters more than which definition you choose.
Operating KPIs that match your model
The NACD, the US governance association, suggests boards use a dedicated dashboard that aggregates key performance indicators and key risk indicators. Pick the few KPIs that drive your results:
- Startups and SaaS: monthly recurring revenue, churn, customer acquisition cost, payback period.
- E-commerce: contribution margin per order, repeat purchase rate, advertising cost as a percent of revenue, inventory turns.
- Retail: sales per store or channel, margin by category, stock levels.
- Service businesses: utilization, revenue per client, backlog, proposal win rate.
Three to six is plenty. If you cannot say what decision a KPI informs, drop it.
How to lay out a board financial package
ICAEW, the UK chartered accountancy body, gives a clear model in its 2025 guidance on Excel reporting. It recommends showing progress against plan, key numbers and analysis that supports decisions. Turned into a template, it looks like this.
Page 1: the front page
The front page carries headline-and-detail commentary, the key numbers tied to your KPIs, and the decisions required with a recommended course of action. A director who reads only this page should know how the month went and what is being asked of them.
Pages 2 to 4: the statements
Follow with income statement, balance sheet and cash flow pages. ICAEW suggests each shows the month and year-to-date, compared with budget and last year, along with a full-year block showing budget, last year and forecast, with significant budget variances highlighted.
Page 5: KPIs and risks
Put your dashboard here: a few charts and a small table of KPIs with trend lines. Add a short risk list, with each risk, its likely impact and the action under way.
Appendices
Supporting detail goes at the back. Both the Bayes guide and the Australian Institute of Company Directors’ annotated sample board paper place complex supporting material in appendices so the main paper stays readable.
Always include a forecast
A board package that only looks backward leaves directors guessing. ICAEW’s 2025 article says a board financial report should include a forecast next to budget and prior-year comparisons, because conditions can change after the budget was prepared.
In practice, this means a full-year view with three columns: budget, last year and forecast. Update the forecast each month with actuals to date plus your best estimate for the remaining months. When the forecast and budget diverge, say why in the commentary. This is where many spreadsheet reports fall short: the budget lives in one file, actuals in another, and the forecast in someone’s head. Linking them in one workbook, with a single data tab feeding every report page, is what makes the package repeatable.

Write commentary that explains the variance

Numbers without explanation make directors do the analysis themselves. ICAEW’s advice for variances is to state what happened, why, what action is under way, how far along it is, and the expected effect at year-end.
Here is an illustration with made-up figures for a fictional online retailer:
Revenue was $412,000 against a budget of $450,000 (8% below). The shortfall came from paid search, where cost per click rose and we cut spend in two campaigns. We have moved $15,000 of budget to email and repeat-customer offers, which have a lower acquisition cost. Those changes started in week three. We expect the year-end revenue gap to narrow from $38,000 to about $25,000, with gross margin held at 41%.
That paragraph gives the number, the reason, the action, the timing and the outlook in five sentences. Do this for the three to five largest variances only. A materiality threshold, such as any line more than 5% or $10,000 off budget, keeps the commentary focused. For a deeper walk-through of the mechanics, see our guide to variance analysis in Excel.
Board reporting best practices
The Chartered Governance Institute’s checklist on effective board reporting is practical and short. Its main points:
- State why the paper is going to the board and why now. Make the ask explicit: decide, discuss or note.
- Keep the executive summary to no more than a page, with key messages up front.
- Use plain language and explain any jargon.
- Keep it as short as possible. Let charts carry a short narrative.
- Test your template with board members. The same source reports that 51% of organizations use topic-specific templates.
The Bayes guide adds that reports should be concise, relevant, reliable, timely, material and fit for purpose. It also recommends a consistent format, graphs and color coding, and a statement of any data limitations. It asks for management comment on under- or over-performance with the action being taken. It also notes that assurance or verification can help boards judge reliability.
Three habits turn this into a routine:
- Freeze the format. Same order, same definitions, same colors each month. Directors learn where to look.
- Close the books on a fixed schedule. Send the package at least several days before the meeting so directors can read it.
- Reconcile before you send. Cash on the report should tie to the bank, and revenue to the ledger. One visible error costs more trust than ten good pages earn.
A decision page for every meeting
If you ask the board to approve something, such as a hire, a loan, a new warehouse or a price change, give it a structured paper. The AICD sample includes the paper type, sponsor and presenter, a draft resolution when a decision is sought, an executive summary, a recommendation, strategy implications, financial impact, risk analysis and governance considerations. Its guidance on recommendations is to explain why the option is preferred, mention alternatives where relevant, and state the intended outcomes.
For a small company, a half-page version is enough: the decision, the recommendation, the cost, the cash impact over the next 12 months, the main risk and the alternative you rejected.
Building the package in Excel or Google Sheets
You do not need a reporting platform to produce a professional board package. You need a clean structure. A reliable build looks like this:
- Create one data tab. Export monthly actuals from your accounting or sales system into a single table with consistent account names. Every report page should pull from it, never from retyped numbers.
- Add budget and forecast tabs in the same layout, so actual, budget and forecast line up by row and month.
- Build the statement pages with formulas for month, year-to-date and full-year columns, and conditional formatting to flag variances above your threshold.
- Build the dashboard tab with the KPIs and charts that matter. Our walkthrough on Excel dashboard design covers the steps, and our financial dashboard examples show what finished pages can look like.
- Write the front page last, once the numbers are final.
- Export to PDF and send it, keeping the workbook as your working file.
The common failure points are broken links between tabs, definitions that drift from month to month, and a forecast that nobody updates. A starting structure helps. Our dashboard and KPI templates and financial model templates give you the layout to start from, and the Performance Scorecard template is a ready format for tracking KPIs against targets. If you are a SaaS founder, the SaaS Metrics Dashboard template covers the subscription metrics investors ask about.
Get a board package built for your business
Frac CFO builds finance systems in Excel and Google Sheets for businesses that prefer to keep working in spreadsheets, with hands-on onboarding and email support. You can start with a one-time project such as a KPI dashboard build, a budget build or a 13-week cash flow forecast, all listed on our one-time projects page. If you want the package prepared every month, our fractional CFO plans cover cash flow forecasting, KPI tracking, budgeting and dashboards: Starter is $600 per month ($7,200 per year), Growth is $1,750 per month ($21,000 per year), and Scale is $3,500 per month ($42,000 per year). The Launch Kit is a $650 one-off option.
You keep full control of your data in tools you already use, with no new platform to learn. See the Starter plan or the Excel templates to begin.
Our perspective
Most small companies do not have a board reporting problem. They have a spreadsheet problem. The numbers exist, but they sit in five files, with three definitions of margin and a forecast that was last touched in January.
We built our work around a simple idea: you should not have to replace your spreadsheets to get clear, confident financial reporting. A well-structured workbook, with one data source, linked budget and forecast, and a dashboard that shows only what matters, produces the same board-ready pages that a heavy system would, and you understand every cell.
That is why we focus on Excel and Google Sheets, on custom projects and templates, and on ongoing fractional CFO support for businesses that want their numbers to tell a clear story. A board package is not about more data. It is about making the next decision easier.
frac
FAQ
What goes into a board report?
A board report typically has an executive summary, the key financial results against budget and prior year, a forecast, operating KPIs, risks, and any decisions required. Supporting detail belongs in appendices. The guidance from the Bayes Business School guide is that papers should have a clear purpose and a concise summary.
What is the difference between a board report and a board package?
The board package is the full set of documents sent before a meeting: agenda, financial report, KPI dashboard, risk update and any decision papers. The board report is usually the management report within it. For a small company, the financial package and the report are often one document of five to ten pages.
How long should a board report be?
As short as it can be while supporting decisions. The Chartered Governance Institute recommends an executive summary of no more than one page, with charts carrying a short narrative. Put detail in appendices rather than the main body.
How often should the board financial package be produced?
Most boards that meet quarterly receive a package ahead of each meeting, and many companies prepare monthly numbers so trends are visible. Whatever the cadence, keep the format and definitions the same so directors can compare periods.
Can I build a board report template in Excel?
Yes. Use one data tab, linked budget and forecast tabs, statement pages with month, year-to-date and full-year columns, and a dashboard tab. ICAEW’s guidance on bringing financial reports alive in Excel describes this layout.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources
- Board reports that add value: a good practice guide (Bayes Business School, 2021)
- Bringing financial reports alive in Excel (ICAEW, 2025)
- Effective board reporting (Chartered Governance Institute UK)
- Board Papers annotated sample (Australian Institute of Company Directors, 2020)
- Sample Board-Level Reporting: Scenario Analysis and Disruptive Risks (NACD)

