Guides › Finance & Accounting
Turn monthly figures into a report management will read
Get a short management report with headline numbers, what changed, risks and decisions needed, built from your monthly accounts.
When to use it
Each month before the management meeting
Step by step
Collect the month's numbers
Export the profit and loss, balance sheet and cash position, plus last month and the same month last year if you have them.
Set the format once
Ask management what they want to see, then save a short outline of headings in Word so every month looks the same.
Draft the report
Attach the exports to your AI assistant and paste this prompt.
Prompt to copyWrite a two-page monthly management report for [company] for [month], using the attached figures. Audience: directors who want the story, not the detail. Sections: 1) Headlines (four bullets with numbers). 2) Sales and margin compared with last month, budget and last year. 3) Costs: the three biggest changes and why (use my notes: [paste]). 4) Cash: closing balance, main movements and the next 8 weeks' known big payments. 5) Risks to watch. 6) Decisions or approvals needed. Use a table where it helps. Plain English. Mark anything you're unsure of as [CHECK]. Don't make recommendations on tax or investment.Check figures and tone
Tie every number back to your accounts and replace each [CHECK]. Make sure the risks and decisions reflect your own judgement.
Share it
Save it in Word and post it in your management channel in Teams or by email ahead of the meeting.
What you get
Headlines: Sales £182k, up 6% on September. Gross margin 41% (budget 43%), driven by higher freight costs. Cash £96k, down £18k after the annual insurance payment. Decision needed: approve the £12k van replacement in Q1.
Tips
- If your plan includes Copilot in Excel or Word, try it here; otherwise this chat method works with any assistant.
- Don't paste client personal data, full account numbers or payroll details into a public AI tool unless your organisation allows it. Use your work-approved assistant if you have one.