What it does
The Monthly Commentary Generator reads your actual results alongside budget, prior period or prior year comparatives, works out what drove the variances, and writes structured narrative paragraphs for management packs and board papers.
When to use it
- At month end, when management commentary is due.
- When you need variance explanations for P&L line items.
- When drafting the narrative section of a management pack.
- Before running Skill 07, which uses this commentary as an input.
You need at least one period of actual P&L data, at least one comparative, and data mapped to standard P&L categories (run Skill 04 first if needed).
How it works
- Read the data. Claude identifies the Actual, Budget and Prior columns and calculates dollar and percentage variances.
- Rank by materiality. Variances are sorted by size, focusing on material items rather than every line. Rounding noise is ignored.
- Write in a fixed order.
- Revenue: the total against the comparative, the top drivers and any mix change.
- Costs: gross margin, operating expense movements, wages with headcount context where available, and one-offs.
- Bottom line: EBITDA and margin, NPAT and the year-to-date position.
- Apply the commentary standards. Facts before interpretation, favourable and unfavourable rather than good and bad, every movement quantified in dollars and percent, no more than three drivers per line, and Australian English.
What you get
Short, specific paragraphs of two to three sentences each that lead with the variance and then explain it, for example “revenue increased $45K (8%) driven by…”. Commentary references the cells it draws on so a reader can trace it back to source. Output can be inline, in Markdown, or written into specified workbook cells.
Good to know
- Text output only. It does not modify workbook data or build models.
- Not for assembling a board paper (Skill 07) or for cash flow commentary (Skill 08).
- If the driver of a variance isn’t clear from the data, the commentary says so rather than inventing an explanation.
- No forward-looking statements unless you ask for them.
- Claude confirms whether the budget is monthly or annual and whether “prior” means prior month or prior year, and flips Xero’s negative revenue sign before calculating variances.
- When Skill 12 has already run, use its materiality flags rather than recalculating.