Section 01

Month-end reporting takes the same shape every month. Gemini can help you write it faster, not just calculate it.

Month-end close in most finance teams follows a familiar rhythm: figures are finalised in the accounting system, then someone has to turn those figures into a report — a summary for leadership, variance commentary for budget holders, or a narrative that explains what happened and why.

The numbers themselves come from your accounting system or Sheets. Gemini's role is different: it helps you turn a set of figures into a clear written report, draft variance commentary, and keep the format and tone consistent from one month to the next.

Key insight: Gemini does not calculate your month-end figures — it helps you communicate them. Give it the numbers from your existing reports and ask it to draft the narrative, summary or commentary around them.

Draft variance commentary

Turn a table of budget vs actual figures into written explanations of the key differences.

Write management summaries

Summarise month-end results into a short narrative for leadership, in plain language.

Keep reports consistent

Use the same structure and tone every month, so reports are easy to compare and review.

Common month-end report types Gemini can help draft

Source of truth for figures: your accounting system or Sheets

100%

Of figures should be reviewed before a report goes out

Using Gemini for month-end reporting works best when it slots into the end of your existing close process — after the figures are final, not instead of them.

Finalise your figures first

Complete your normal month-end close in your accounting system, so the numbers feeding into the report are final, not provisional.

Bring the key figures into Sheets

Put the figures you want to report on — actuals, budget, prior period — into a simple table in Google Sheets.

Ask Gemini to draft commentary

Share the table with Gemini and ask it to identify the largest variances and draft a short written explanation for each.

Add context Gemini cannot know

Fill in the real business reasons behind each variance — a delayed contract, a one-off cost, a timing difference — since Gemini cannot know these on its own.

Review and format the final report

Check the draft against your figures, adjust tone if needed, and apply it to your usual report template before sending.

Note: Gemini drafts the words around your numbers. The figures themselves should always come from your accounting system or Sheets — never ask Gemini to generate or estimate figures for a report.

These prompts help you get useful first drafts from Gemini, while keeping your finance team in control of the figures and the final wording.

Prompt 1 — Draft variance commentary from a table

Act as a finance business partner. I am sharing a table of budget vs actual figures by department for this month. For each department, write a short variance commentary (2-3 sentences) that: - States whether the department is over or under budget, and by how much (amount and percentage) - Identifies this as the largest or smallest variance if relevant, compared to other departments in the table - Uses a neutral, factual tone suitable for a management report Do not invent reasons for the variance — if the cause is not in the data I provide, write "Reason to be confirmed with department" instead.

Prompt 2 — Write a management summary

Act as a finance business partner. I am sharing this month's headline figures: revenue, gross margin, operating costs and net result, each with the prior month and budget for comparison. Write a short management summary (4-6 sentences) in plain English that: - States the headline result for the month - Highlights the one or two most significant changes versus budget or the prior month - Avoids jargon and keeps a neutral, factual tone End with one sentence noting which areas may need follow-up discussion.

Always provide the figures yourself

Never ask Gemini to calculate or estimate month-end numbers. Give it the final figures from your accounting system and ask it to write around them.

Check every figure that appears in the draft

Before sending a report, confirm every number Gemini has written into the commentary matches your source table exactly.

Add the real business context

Gemini can describe what changed, but only your team knows why — replace any "reason to be confirmed" notes with the actual explanation.

Reuse the same prompt structure each month

Keep the same prompt format from month to month so the tone and structure of your reports stay consistent and easy to compare.

Important: Never send a Gemini-drafted report without checking every figure against your source data first. Gemini can describe and explain numbers, but it does not verify them — that responsibility stays with your finance team.