Monthly Close Commentary: Automating the Narrative

Month-end close is one of the most time-pressured periods in any finance function. The numbers need to be right, and then they need to be explained — fast. AI can take a significant portion of the commentary work off your plate without compromising quality.

The Monthly Close Commentary Challenge

Most finance teams follow a similar pattern:

1. Close the books and finalise numbers
2. Produce P&L, balance sheet, cash flow
3. Run variance analysis
4. Write commentary — often late at night, often rushed

The commentary is where AI delivers the most immediate time savings. You provide the facts; AI provides the structure and language.

The Master Month-End Prompt

"Act as a Finance Manager writing the monthly management accounts commentary for [Month] [Year].

Financial results:

• Revenue: £[X] (budget £[Y], prior year £[Z])
• Gross profit: £[X] (margin [X]%, budget [Y]%, prior year [Z]%)
• Operating costs: £[X] (budget £[Y])
• EBITDA: £[X] (budget £[Y], prior year £[Z])
• Net cash: £[X] (up/down £[Y] in the month)

Key drivers of variances:

• Revenue: [explain]
• Gross margin: [explain]
• Costs: [explain]
• Cash: [explain]

Write a management accounts commentary of 300-350 words covering:

1. A 2-sentence headline summary
2. Revenue and margin section
3. Cost section
4. Cash section
5. A 2-sentence outlook

Tone: professional, direct. Distinguish clearly between one-off items and structural trends."

Section-by-Section Approach

If you prefer to build commentary in sections:

Revenue section:

"Write a 75-word commentary on revenue performance. Actual: £4.2m. Budget: £4.5m. Prior year: £3.8m. Key driver of shortfall: delayed enterprise order. Underlying performance: on track. Tone: confident, specific."

Gross margin section:

"Write a 75-word commentary on gross margin performance. Margin: 39.1%. Budget: 41.0%. Prior year: 38.5%. Key drivers of underperformance vs budget: product mix shift (£80k impact) and raw material price increases (£40k impact). Trend vs prior year: improving. Tone: analytical, acknowledge the issue but contextualise it."

Cash section:

"Write a 50-word cash commentary. Net cash position: £1.4m, up £200k from last month. Key driver: improved debtor collections. Upcoming outflow: VAT payment of £180k next week. Tone: factual, brief."

The Consistency Problem

When multiple people write commentary, the tone and structure are inconsistent. Solve this with a house style prompt:

"Here is our house style for monthly commentary:

• Always lead with the headline number
• Express variances as £ and % (both)
• Distinguish one-off from recurring items
• Use past tense for results, present tense for outlook
• Maximum 3 sentences per section

Rewrite this commentary to match this style: [paste commentary]"

Automating Repetitive Phrases

Some commentary elements repeat every month with minor changes:

"Write 5 different phrasings of the sentence 'Overheads were in line with budget' that I can rotate through to avoid repetition in monthly reports. Keep the same meaning, vary the structure and language."

Your Turn

Set up a template in your prompt library for month-end close commentary. Fill in the [placeholders] for your own business structure, typical variance categories, and audience. The next time month-end close comes around, spend 5 minutes filling in the facts and let AI handle the first draft.