How to Write Copilot Prompts for Finance Month-End Close Tasks

Month-end close is a high-pressure process that involves reconciling accounts, reviewing variances, and finalizing financial statements. Finance teams often spend hours pulling data from multiple systems and formatting reports. Copilot in Microsoft 365 can automate many of these steps, but the quality of its output depends entirely on how you phrase your prompts. This article explains how to structure prompts for month-end close tasks so Copilot returns accurate, ready-to-use results.

Poorly written prompts produce generic or incorrect answers. A prompt like “analyze the variance” is too vague. Copilot does not know which accounts, which period, or what threshold to use. By adding specific context, you turn Copilot into a reliable assistant that pulls from your Microsoft Graph data, Excel tables, and Power BI datasets.

This guide covers prompt structure, example prompts for common close tasks, and mistakes that cause Copilot to fail. You will learn how to write prompts that produce variance reports, reconciliation summaries, and journal entry drafts in seconds.

Why Prompt Structure Matters for Finance Data

Copilot uses large language models combined with your Microsoft Graph data. It can read Excel tables, Outlook emails, Teams chats, and SharePoint documents. But it does not have a memory of your company’s chart of accounts or month-end procedures. Every prompt must supply the missing context.

A well-structured prompt includes three elements:

Context: The specific task, account, period, and data source. For example, “the Trial Balance sheet in the file MonthEnd_June.xlsx.”

Action: The exact operation you want. Words like “draft,” “summarize,” “compare,” “flag,” or “calculate.”

Format: The output structure. “Show results as a table with columns for Account, Actual, Budget, Variance, and Notes.”

When any element is missing, Copilot guesses. Guessing works for simple requests like “write an email” but fails for finance tasks where precision is mandatory.

How to Write Prompts for Common Month-End Close Tasks

Below are five specific month-end close tasks with example prompts. Each prompt follows the context-action-format structure.

1. Generate a Variance Report from an Excel Trial Balance

1. Open the Excel file
   Open the Trial Balance workbook for the current month. Ensure the data is in a formatted Excel table with named columns: Account, Actual, Budget, Prior Year.
2. Select the data range
   Click anywhere inside the table. Go to the Copilot pane on the right side of the Excel window.
3. Write the prompt
   Type: “Create a variance report from this table. Show Account, Actual, Budget, Variance Amount, and Variance Percent. Highlight any account where variance exceeds 10 percent. Sort by variance percent descending.”
4. Review and insert
   Copilot will generate the table. Click Insert to add it to a new sheet. Verify the formulas by checking a few cells manually.

2. Draft a Bank Reconciliation Summary

1. Prepare the data
   Export the bank statement and the general ledger cash account to two separate Excel tables. Name the tables “BankStatement” and “GLCash.”
2. Open Copilot in Excel
   Select any cell in the BankStatement table. Open the Copilot pane.
3. Write the prompt
   Type: “Compare the BankStatement table with the GLCash table. List all transactions in BankStatement that do not appear in GLCash. Group them by date. Add a column called Status and mark each as Outstanding Check or Deposit in Transit.”
4. Review the output
   Copilot will create a reconciliation table. Manually verify the first five items against your bank statement to ensure accuracy.

3. Summarify Accrual Entries from Email Attachments

1. Open Outlook
   Navigate to the folder containing invoices and approval emails for the month.
2. Activate Copilot in Outlook
   Click the Copilot icon in the ribbon. Select Summarize from the dropdown.
3. Write the prompt
   Type: “Summarize all emails in this folder received after June 1. Extract the vendor name, invoice amount, due date, and approval status. Output as a table.”
4. Copy to Excel
   Click Copy Table. Paste into an Excel sheet named Accruals_June. Add a column for Journal Entry Number.

4. Calculate Depreciation for Fixed Assets

1. Open the fixed asset register in Excel
   Ensure the table has columns: Asset Name, Cost, Salvage Value, Useful Life, Method. Use straight-line for simplicity.
2. Select the table
   Click any cell. Open Copilot in Excel.
3. Write the prompt
   Type: “Calculate monthly depreciation for each asset using straight-line method. Add a column called Monthly Depreciation. Then sum the total depreciation for all assets. Show the total in cell F20.”
4. Verify the calculation
   Check one asset manually: (Cost – Salvage Value) / Useful Life / 12. Confirm Copilot used the correct formula.

5. Draft a Month-End Close Status Email

1. Open Outlook
   Start a new email. Click the Copilot icon to open the draft pane.
2. Write the prompt
   Type: “Draft an email to the finance team summarizing the month-end close status. Mention that all bank accounts are reconciled, the trial balance is balanced, and the only open item is the intercompany transfer from the UK subsidiary. Use a professional tone. Include a table with columns: Task, Status, Owner, Due Date. Populate it with these tasks: Bank Reconciliation (Complete, John, June 30), Trial Balance Review (Complete, Sarah, June 30), Intercompany Transfer (Pending, David, July 2).”
3. Review and send
   Copilot will generate the email. Check the table data for accuracy. Add any missing details before sending.

Common Mistakes That Cause Copilot to Return Wrong Results

Even with good prompts, Copilot can fail. These are the most frequent mistakes and how to avoid them.

Copilot Cannot Find the Right Data Source

If you do not specify which file or table to use, Copilot searches broadly. It might pull data from an old version of the trial balance or a different department. Always reference the exact file name and sheet. For example, write “the table named GL_Summary in the file MonthEnd_June.xlsx” instead of “the trial balance.”

Copilot Returns Generic Text Instead of Numbers

When you ask a vague question like “how is the month end?” Copilot produces a narrative summary with no numbers. Force Copilot to output structured data. Use phrases like “show as a table” or “list the values in a bulleted list with amounts.” If you need calculations, state the formula explicitly.

Copilot Misinterprets Dates or Periods

Copilot may use today’s date instead of the close period. Include the month and year in every prompt. Write “for June 2025” not “for last month.” If your data uses fiscal periods, include the fiscal year and period number, for example “FY2025 Period 12.”

Copilot Skips Security or Sensitivity Labels

If your finance files have sensitivity labels like “Confidential” or “Restricted,” Copilot may refuse to process them. Check that your Microsoft 365 license includes sensitivity label support. If Copilot returns an error about permissions, ask your IT admin to grant Copilot access to the labeled data.

Item	Vague Prompt	Effective Prompt
Variance report	Analyze the variance	Show a table with Account, Actual, Budget, Variance Percent, sorted by variance descending, for the file TrialBal_June.xlsx
Bank reconciliation	Reconcile the bank	Compare BankStatement table with GLCash table and list unmatched transactions by date
Depreciation calculation	Calculate depreciation	Add a column called Monthly Depreciation using straight-line method: (Cost minus Salvage Value) divided by Useful Life divided by 12, for the FixedAssets table
Status email	Write a close email	Draft an email with a table of tasks, status, owner, and due date for the June close

Writing effective prompts for month-end close tasks requires context, a clear action, and a defined output format. By following the examples above, you can reduce the time spent on manual data analysis and focus on reviewing the results. Start with one task, such as the variance report, and refine your prompt until Copilot returns exactly what you need. As you gain confidence, expand to more complex tasks like intercompany reconciliations or cash flow summaries.

Remember that Copilot is a tool that requires your oversight. Always verify the first few outputs manually before relying on them for final statements. The combination of a precise prompt and human review produces the most reliable month-end close process.