What a board report should include and in what order, a one-page financial summary worked for a quarter, how to write the commentary, and a free Excel workbook with the summary, KPIs, cash and covenant headroom, a risk register and a sources sheet.
Free Excel workbook, no sign-up. The formulas are live, and sample rows show how it fills in: replace them with your own.
Download board-report-template.xlsx
| Line | Actual | Budget | Variance | Variance % | Reading | Prior year | Change on prior year |
|---|---|---|---|---|---|---|---|
| Revenue | 14,600 | 15,000 | (400) | -2.7% | Unfavorable | 13,200 | 10.6% |
| Cost of sales | 8,760 | 8,850 | (90) | -1.0% | Favorable | 7,850 | 11.6% |
| Gross profit | 5,840 | 6,150 | (310) | -5.0% | Unfavorable | 5,350 | 9.2% |
| Gross margin | 40.0% | 41.0% | -1.0% | Unfavorable | 40.5% | ||
| Operating expenses | 3,920 | 4,050 | (130) | -3.2% | Favorable | 3,700 | 5.9% |
| EBITDA | 1,920 | 2,100 | (180) | -8.6% | Unfavorable | 1,650 | 16.4% |
| EBITDA margin | 13.2% | 14.0% | -0.8% | Unfavorable | 12.5% | ||
| Closing cash | 6,300 | 5,800 | 500 | 8.6% | Favorable | 5,100 | 23.5% |
A board report exists so the board can decide and oversee. It is not the monthly management reporting package reprinted. This page gives the format, section by section, a one-page financial summary worked for a quarter, and a free Excel workbook that computes the summary, KPIs, cash and covenant figures from one monthly data sheet. US companies often call the whole set the board deck or board book; UK companies say board pack.
The board's job is oversight: strategy, performance, risk and the decisions that only it can take. The report should make those easy. Business Roundtable's Principles of Corporate Governance put it plainly: "The quality and timeliness of information that the board receives directly affects its ability to perform its oversight function effectively."
Directors say they often do not get that. In research by Board Intelligence and the NACD, only 13 percent of directors rated their board packs "extremely effective", and 59 percent reported three or more areas of concern, from papers that are too operational to too little risk reporting. The fix is structure: decisions first, exceptions over detail, and figures that can be traced.
Appendices hold the full financial statements and anything a director may want to check. UK boards will also read this against the FRC's UK Corporate Governance Code, whose 2024 version applies from January 1, 2025.
Second quarter 2026 for the sample company, in USD thousands, as the Summary sheet computes it:
| Line | Actual | Budget | Variance | Variance % | Reading | Prior year | Change on prior year |
|---|---|---|---|---|---|---|---|
| Revenue | 14,600 | 15,000 | (400) | -2.7% | Unfavorable | 13,200 | 10.6% |
| Cost of sales | 8,760 | 8,850 | (90) | -1.0% | Favorable | 7,850 | 11.6% |
| Gross profit | 5,840 | 6,150 | (310) | -5.0% | Unfavorable | 5,350 | 9.2% |
| Gross margin | 40.0% | 41.0% | -1.0 pt | Unfavorable | 40.5% | ||
| Operating expenses | 3,920 | 4,050 | (130) | -3.2% | Favorable | 3,700 | 5.9% |
| EBITDA | 1,920 | 2,100 | (180) | -8.6% | Unfavorable | 1,650 | 16.4% |
| EBITDA margin | 13.2% | 14.0% | -0.8 pt | Unfavorable | 12.5% | ||
| Closing cash | 6,300 | 5,800 | 500 | 8.6% | Favorable | 5,100 | 23.5% |
The arithmetic holds line by line: 14,600 − 8,760 = 5,840; 5,840 − 3,920 = 1,920; 1,920 / 14,600 = 13.2%. On budget, 6,150 − 4,050 = 2,100. A year ago, 5,350 − 3,700 = 1,650. Variance is actual − budget, so on operating expenses −130 is favorable: lower spending recovered 130 of the 310 gross profit shortfall. The EBITDA margin variance is −0.85 points before rounding, shown as −0.8.
Answer first, then the cause, then the action, as in answer-first writing for commercial measures. Explain the table rather than describing it: "revenue was 14.6m" adds nothing a director cannot read; "below budget because two contracts slipped to Q3" does. Every figure in the text should appear in a table, and every table figure should trace to a file. A board narrative with a citation on every number shows the discipline in full.
Write the report itself in Word, Google Docs or slides, using the eight sections above with the cover stating decision, discussion or information. The Excel workbook holds the figures, with no charts and no typed totals:
Actual or Budget): month-end date, revenue, cost of sales, operating expenses and closing cash.B2; the prior-year quarter end is =EOMONTH($B$2,-12). Each line sums the three months ending on that date:=SUMIFS(Monthly!$C$2:$C$500,Monthly!$A$2:$A$500,">"&EOMONTH($B$2,-3),Monthly!$A$2:$A$500,"<="&$B$2,Monthly!$B$2:$B$500,"Actual")
The executive summary sits below the table, in yellow cells, so it is written from the figures beside it.
For the monthly management view behind the board summary, use the financial dashboard template.
Revenue grew 10.6% on the second quarter of last year to $14.6 million but finished 2.7% below budget, because two enterprise contracts slipped into the third quarter. Gross margin was 40.0%, a point below the 41.0% plan, so gross profit was $310,000 short of budget. Operating expenses ran $130,000 under budget, which recovered part of that shortfall; EBITDA was $1.92 million, $180,000 (8.6%) below budget, at a 13.2% margin. Closing cash was $6.3 million, $500,000 ahead of budget, and net debt is 1.6 times last-twelve-months EBITDA against a covenant maximum of 3.0. The board is asked to approve the revised second-half forecast that moves the two contracts into the fourth quarter.
The summary table and its commentary are where figures get typed twice. Covirage's tools compute the table from your ledger and sales files and cite each figure's source rows; the external AI model drafts the narrative for your team to edit, and never produces a number. See board reporting to get the board narrative drafted from figures that reconcile to finance, with a citation on every number. For the monthly pack that feeds it, see the management accounts template; for the early read, flash report.
An executive summary, the decisions required, financial performance against budget and prior year, cash and funding, key performance indicators, commercial and operational updates, risks, and appendices with the detailed statements. Each paper should state whether it is for decision, discussion or information.
Long enough to support the decisions, and no longer. Many boards aim for a main report of around ten pages with appendices behind it. A one-page summary at the front, readable in five minutes, matters more than the total length.
A management report is for running the business and goes into operational detail every month. A board report is for oversight and decisions, usually quarterly or at each meeting, and summarizes performance, risks and the choices the board must make.
Usually the CEO and CFO, with the corporate secretary coordinating papers and each executive writing their own section. The finance team prepares the financial summary and appendices, and should be able to trace every figure to its source.