AI prompt to write a monthly MIS summary
The prompt
You are a finance manager writing the monthly MIS note for the directors of a [industry] company. Here are this month's numbers against last month and budget (₹ lakh): [paste a small table: line item | this month | last month | budget] Context you should know: [e.g. "Diwali sales month", "new branch opened on the 10th", "one large client paid late"] Write a one-page summary with: 1. Three headline points, each with the number and the change. 2. What drove the biggest changes, using only the context I gave. Where the reason is not in my context, write "Reason to confirm" instead of guessing. 3. Cash position and receivables in two lines. 4. Up to three decisions or actions needed from the directors. Rules: under 300 words. Numbers in ₹ lakh with one decimal place. No jargon the directors would not use.
Replace the parts in [square brackets] before you send it.
How to use it
- Open ChatGPT or Gemini and start a new chat.
- Tap Copy prompt, paste it, and replace every part in [square brackets] with your details. Placeholders are fine for names and personal data.
- Send it, then improve the draft in the same chat: "shorter", "more formal", "in Hindi".
- Read the final version yourself before you use it. Check every number, date and name.
- "Reason to confirm" is the important rule. It stops the AI inventing a neat explanation for a number.
Do not paste Aadhaar, PAN, bank details, salaries or anyone's personal data into a public AI tool. Use placeholders and add the real details in your own document.
Example result
A one-page note that opens with three headline lines ("Revenue ₹84.2 lakh, up 18% on last month and 6% above budget"), then explains the main movements using only the context you gave, marking anything unexplained as "Reason to confirm". Two lines cover cash and receivables, and it ends with two or three specific decisions for the directors.
Described in words: what you get depends on your photo or details, and on the tool.
Variations
Send one of these as your next message in the same chat, or use it to replace the matching line in the prompt.
Email version
Turn it into a 5-line email for the directors who will not open the attachment.
Slide
Give me the content for one slide: a title, three bullets and the one chart that would show the main change best.
Questions to expect
List the five questions the directors are most likely to ask about these numbers, with a short answer for each.
More finance and accounts prompts
- ChatGPT prompt for a polite payment reminderA copy-paste ChatGPT prompt for payment reminders that get paid: a polite email and a short WhatsApp message, with firmer versions for 30 and 60 days overdue.
- AI prompt to categorise expenses from a bank statementPaste exported bank or card transactions and get every line sorted into expense categories with a monthly total, using ChatGPT or Gemini. Remove account details first.
- AI prompt to explain budget vs actual variancesA copy-paste prompt that calculates budget vs actual variances, flags the ones that matter and drafts a plain explanation for each, in ChatGPT or Gemini.
- AI prompt to get the right Excel formulaDescribe what you need in plain words and get the right Excel or Google Sheets formula, explained part by part, with a test row to check it. Works in ChatGPT and Gemini.