How to automate a recurring weekly or monthly report with AI

Turn the report you write every period into a reusable prompt with fixed sections, then paste in only that period's numbers and notes. You get the same report structure each time, with any missing reason flagged so nothing is invented.

Reviewed by AICourseHubPro · Last updated

Who this is for

  • Operations and admin staff who write the same report every week or month
  • Team leads who summarize numbers and notes for managers
  • Anyone who wants to save time on repeated documents

What you need before you start

  • A report you already write regularly, with its usual sections
  • This period's numbers and a few bullet notes
  • An AI tool your organization allows

Worked example: Write the monthly operations report from numbers and notes

The input

Act as an operations analyst writing a monthly report.
Context: Use only the numbers and notes below (fictional warehouse example).
Task: Write the report.
Format: Headline summary (2 sentences), Key numbers (table), What changed and why (3 bullets), Next month (3 bullets).
Limits: Do not add any figure that is not provided. If a reason is missing, write [REASON NEEDED].
Numbers:
Orders shipped: October 4,820, September 4,610
On-time shipping: October 94.1%, September 95.6%
Average pick time: October 6.2 min, September 6.8 min
Damage claims: October 31, September 24
Notes:
Aisle re-slotting finished on 9 October. Peak-season hiring started in the second half of October and 11 temporary staff joined. No note on the cause of the rise in damage claims.

The output

Headline summary
We shipped more orders in October and picked them faster, but on-time shipping slipped and damage claims rose.

Key numbers
Measure | September | October | Change
Orders shipped | 4,610 | 4,820 | +4.6%
On-time shipping | 95.6% | 94.1% | -1.5 points
Average pick time | 6.8 min | 6.2 min | -8.8%
Damage claims | 24 | 31 | +29.2%

What changed and why
- Average pick time fell after aisle re-slotting finished on 9 October.
- 11 temporary staff joined in the second half of October as peak-season hiring started.
- Damage claims rose from 24 to 31. [REASON NEEDED]

Next month
- Continue onboarding the 11 temporary staff.
- [INFORMATION NEEDED: plan to reduce damage claims]
- [INFORMATION NEEDED: reason for the drop in on-time shipping and the plan to recover it]

What to check or change by hand

  • Check every figure against your source and recalculate the changes (for example 31 against 24 is +29.2%)
  • Resolve every [REASON NEEDED] and [INFORMATION NEEDED]
  • Run the same prompt with a different month to check the structure stays the same
  • Review the report before it is sent

Free template

Recurring report prompt and checklist (Word) (DOCX), free with your email address.

Cautions

  • Check every figure against your source. A report that looks professional but has a wrong number is worse than a slow one.
  • Do not paste confidential or personal data into an AI tool that is not approved for it.
  • Keep a person responsible for reviewing the report before it goes out.

Frequently asked questions

What makes this "automation"?

You write the prompt once with fixed sections. Each period you paste only the new numbers and notes, which turns an hour of writing into minutes of checking.

Why does the structure stay the same every month?

The format line in the prompt fixes the sections, so the report looks the same each time.

What stops the AI inventing numbers?

The prompt says to add no figure that is not provided and to write a flag when something is missing. You then fill or remove each flag yourself.

All guides · All courses