How to automate the monthly board report

What the manual pack actually costs

A typical board pack for a company with 100–500 people runs to 25–40 pages. Producing it usually looks like this: finance exports trial balances on the second working day, someone pastes them into the master workbook, charts are refreshed one by one, the slides are updated, department heads are chased for their pages, and the pack is circulated the evening before the meeting — sometimes with a "v3 final" following at midnight.

Costed honestly, that is 3 or 4 people for 3 or 4 days each month: roughly 100 senior hours, or nearly 1,200 hours a year, to produce a document whose charts are 80% identical to last month’s. The other costs are quieter: a number that was restated after the meeting, a director who received the pack the night before and read it on the way in, and the four days after month end when finance is unavailable for anything else.

Define the pack once

Automation starts with agreeing what the pack is, which most boards have never done explicitly. Do it once, in a meeting with the chair, the CEO and the CFO:

1. List every page in the current pack and mark each as "read every month", "read sometimes" or "nobody remembers". Drop the third group.
2. For each surviving page, write the question it answers ("are we on plan for the year?", "is cash safe for the next two quarters?"). If two pages answer the same question, merge them.
3. Define each metric in one line, including what is excluded. Revenue net of credit notes; EBITDA before or after one-offs; headcount as full-time equivalents at month end. These definitions become calculated fields used by every page, so the board never again sees two figures for the same thing.
4. Fix the order. Executive summary, financials, sales and pipeline, operations, people, risks — whatever yours is, keep it identical every month so directors know where to look.

The result is usually 12–18 pages instead of 35. Build them once as dashboard pages, starting from the executive overview template, and treat the pack as a product that changes by exception rather than being rebuilt monthly.

Live numbers, with version history

Once the pages are connected to the accounting system, CRM and operational sources, the numbers update themselves. The month-end routine becomes: finance closes the period, someone checks the reconciliations, and the pack is already current. No exports, no pasting, no chart-by-chart refresh.

Live numbers introduce one new requirement: a director who opens the pack in week three must be able to see it as it was at the meeting, not as it is now with post-close adjustments applied. Two things solve this: download the issued pack as a PDF the day it goes out, so the meeting copy is on file, and keep the dashboard’s version history, which records how each page and definition changed and when. A restated figure is then traceable: what it said, what it says now, and when it changed.

Two habits make this work: agree a "pack freeze" time (say, 17:00 on the fourth working day) after which the issued version is the version of record, and put "figures as at" and "last updated" on every page.

Scheduled PDF delivery

Directors want a document, not a login. Schedule the pack as a PDF to arrive at a fixed time each month — the morning of the fourth working day, three days before the meeting — by email to the board list, with a copy to the company secretary. Executives can receive a version with additional pages the same morning from the same schedule.

Rules of thumb that keep this working:

• Three days before the meeting, not one. Directors who have read the pack ask better questions and the meeting is shorter.
• One PDF, not eleven attachments. The pack is a single page-ordered document with a contents page.
• Landscape, one page per dashboard page, numbers legible on a tablet. Check the PDF on a phone once; that is how at least one director will read it.
• A link to the live version for anyone who wants to click into a number before the meeting.

Klayara delivers scheduled reports as PDF or image by email, Slack, WhatsApp or Telegram; for boards, email is usually right.

Commentary alongside the charts

A chart without a sentence of explanation makes directors guess, and a chart with a paragraph of explanation goes unread. The pattern that works is a text block next to each chart with three lines at most: what happened, why, what we are doing about it. "Gross margin fell 2.1 points to 38.4%. Steel prices rose in July and two fixed-price contracts absorbed the increase. Both contracts reprice in October."

Assign commentary to the person who owns the number — head of sales for pipeline, COO for operations — with a deadline the day before the pack freeze. Text blocks live on the dashboard page, so commentary sits beside the chart it explains and is included in the PDF automatically. Last month’s commentary is visible in version history, which stops "as noted last month" from being a memory test.

Who sees what

A board pack contains things not everyone in the company should see, and a board contains people who should not see everything the executives see. Permissions on the pages handle both without maintaining separate versions:

• Board members see the pack. Non-executive directors may see the same pages without the detailed salary or customer-by-customer tables.
• Executives see the pack plus their department’s supporting pages.
• Subsidiary MDs see the group summary and their own entity in detail, with other entities’ rows hidden by a row rule.
• Finance sees everything, including the columns hidden from others.

The rules should hold in the PDF and in any download, not only on screen — which is the reason to set them on the data rather than per page. See security and permissions, and Klayara for executives for how leadership teams use this in practice.

What to keep manual

Automating the pack does not mean removing people from it. Keep by hand:

• The CEO’s letter or executive summary — the one page that gives the pack a point of view.
• Risks and the register — judgements, not measurements.
• Decisions requested — what the board is being asked to approve, with the options.
• Strategic and one-off items — an acquisition, a new site, a lawsuit.
• The minutes and actions from last time.

Everything else — financials, sales, operations, people, customers — is measurement, and measurement should be automatic. A reasonable target after three months: the recurring pages take zero hours to produce, commentary takes each owner 20 minutes, and finance spends the fourth working day checking numbers rather than pasting them.