50 Copilot Prompts for Accountants | AIA Copilot
If you're spending hours manually analyzing Excel data, building variance reports, or reformatting financial statements, Microsoft 365 Copilot can cut that time by 70% or more. I've trained hundreds of finance professionals on Copilot, and the results are consistent: tasks that took 2-3 hours now take 15-20 minutes. This guide gives you 50 specific prompts you can use today in Excel, Word, Outlook, and Teams to automate the repetitive work that's eating up your day. These aren't generic AI tips—these are tested prompts that work with actual Copilot features in the Microsoft 365 apps you already use.
Excel Data Analysis & Formula Generation
1. Create pivot table from transaction data
Use Excel Copilot to instantly create pivot tables from raw transaction data. Type 'Create a pivot table showing total expenses by department and month' and Copilot generates the table structure, applies proper formatting, and adds subtotals without manual field dragging.
2. Generate complex SUMIFS formulas
Ask Copilot 'Write a formula to sum expenses where department is Marketing and date is in Q1' and it creates the exact SUMIFS formula with proper cell references. Eliminates formula syntax errors and reduces lookup time for complex conditional logic.
3. Identify outliers in expense data
Prompt Copilot with 'Highlight any expense entries that are more than 2 standard deviations from the mean' to automatically flag unusual transactions. Copilot applies statistical analysis and conditional formatting to surface anomalies that require investigation.
4. Build year-over-year comparison charts
Type 'Create a column chart comparing 2024 vs 2025 revenue by quarter' and Excel Copilot generates the chart with proper data series, labels, and formatting. Automatically selects appropriate chart type based on your data structure.
5. Calculate aging buckets for AR
Use 'Create columns showing AR aging in 30, 60, 90, and 90+ day buckets based on invoice date' and Copilot writes the nested IF formulas to categorize receivables. Instantly transforms raw AR data into actionable aging reports.
6. Generate variance analysis formulas
Ask 'Add columns calculating dollar variance and percentage variance between Actual and Budget' and Copilot creates both formulas with proper formatting. Eliminates manual formula writing for monthly variance reports.
7. Extract top 10 vendors by spend
Prompt 'Show me the top 10 vendors by total spend and create a bar chart' and Copilot sorts, filters, and visualizes vendor data automatically. Converts hours of manual sorting into a 30-second task.
8. Build dynamic month-end close checklist
Use 'Create a checklist table with task, owner, deadline, and status columns for month-end close' and Copilot structures the table with data validation dropdowns. Ask it to add conditional formatting to highlight overdue items.
9. Calculate weighted average cost
Type 'Calculate weighted average unit cost based on quantity and unit price columns' and Copilot writes the SUMPRODUCT formula correctly. Perfect for inventory valuation and cost accounting tasks.
10. Create cash flow waterfall analysis
Ask 'Build a waterfall chart showing cash flow from operating income through changes in working capital to ending cash' and Copilot structures the data and creates the waterfall visualization with proper up/down formatting.
Financial Reporting & Document Generation
11. Generate executive summary from data
In Word with linked Excel data, use Copilot to 'Write an executive summary of Q1 financial performance highlighting revenue, expenses, and net income trends.' Copilot pulls actual numbers from your spreadsheet and writes professional narrative commentary.
12. Draft variance explanation memo
Prompt 'Draft a memo explaining why Marketing expenses were 15% over budget in March due to trade show attendance' and Word Copilot creates a professional explanation with proper business writing structure.
13. Create budget presentation deck
In PowerPoint, use 'Create a 2026 budget presentation with slides for revenue assumptions, expense categories, capital expenditures, and cash flow' and Copilot builds the deck structure with title slides and placeholder content.
14. Format financial statements consistently
Ask Word Copilot to 'Reformat this income statement with consistent number formatting, proper indentation for subtotals, and bold headers' and it applies professional financial statement formatting across the entire document.
15. Generate footnotes for financial statements
Use 'Draft footnotes explaining our revenue recognition policy, depreciation methods, and inventory valuation approach' and Copilot creates GAAP-compliant footnote drafts that you can refine with specific company details.
16. Create monthly close summary email
In Outlook, prompt 'Draft an email summarizing month-end close completion, highlighting that we closed 2 days early and noting 3 key variances requiring attention' and Copilot creates a professional update for leadership.
17. Build KPI dashboard commentary
Ask PowerPoint Copilot to 'Add speaker notes explaining each KPI, why it matters, and whether the trend is positive or negative' on your dashboard slides. Creates ready-to-present talking points for each metric.
18. Draft audit response letter
Prompt Word Copilot with 'Draft a response to auditor request explaining our accounts receivable aging methodology and collection procedures' to generate a professional, detailed response that you can customize.
19. Create board meeting financial package
Use 'Generate a table of contents for a board financial package including executive summary, financial statements, KPI dashboard, and variance analysis' and Copilot structures the document with proper sections and page breaks.
20. Write policy documentation
Ask 'Draft an expense reimbursement policy covering eligible expenses, approval requirements, submission deadlines, and documentation requirements' and Copilot creates structured policy language you can adapt to your organization.
Accounts Payable & Receivable Automation
21. Generate vendor payment summary
Use Excel Copilot to 'Create a summary showing total payments by vendor for the current month with payment count and average payment amount' and it builds the summary table with proper aggregations automatically.
22. Draft payment run approval email
In Outlook, prompt 'Draft an email requesting approval for a $47,500 payment run covering 23 invoices, attaching the payment detail report' and Copilot creates a professional approval request with proper context.
23. Create vendor aging analysis
Ask Excel Copilot 'Build a pivot table showing accounts payable aging by vendor with current, 30, 60, and 90+ day columns' and it structures the aging report with proper date calculations and grouping.
24. Generate collection email templates
Prompt Outlook Copilot to 'Draft three collection email templates: friendly 15-day reminder, firm 30-day notice, and final 60-day notice before collections' and it creates progressively stronger collection language.
25. Analyze early payment discount opportunities
Use 'Calculate the annualized return on taking 2/10 net 30 payment terms and highlight which invoices qualify' and Excel Copilot computes discount value and identifies eligible invoices automatically.
26. Create duplicate payment detection
Ask Excel Copilot to 'Identify potential duplicate payments where vendor, amount, and invoice date match within 5 days' and it writes the complex logic to flag possible duplicates for review.
27. Draft invoice dispute resolution email
Use 'Write an email to vendor explaining invoice discrepancy: we received 95 units but were billed for 100, requesting revised invoice' and Outlook Copilot creates a professional dispute notification.
28. Generate payment forecast
Prompt Excel Copilot with 'Create a 13-week cash forecast showing scheduled AP payments by week' and it aggregates payment data by week with running totals for cash planning.
29. Build vendor performance scorecard
Ask 'Create a table showing vendor on-time delivery percentage, average days to payment, and number of invoice errors' and Excel Copilot calculates all metrics and formats the scorecard.
30. Create AR collection dashboard
Use 'Build a dashboard showing Days Sales Outstanding, collection rate, aged receivables by customer, and past due percentage with trend charts' and Excel Copilot creates the multi-metric dashboard with visualizations.
Budget Planning & Forecasting
31. Generate budget vs actual variance report
Prompt Excel Copilot to 'Create a variance report showing budget, actual, variance in dollars and percentage for all expense categories' and it builds the complete variance analysis with proper calculations and formatting.
32. Draft budget assumption documentation
Use Word Copilot to 'Document budget assumptions including 3% revenue growth, 5% salary increases, and 2% inflation on operating expenses' and it creates structured assumption documentation.
33. Create rolling 12-month forecast
Ask Excel Copilot to 'Build a rolling 12-month forecast using 6 months actuals and 6 months projected, with formulas to automatically shift each month' and it creates the dynamic forecast structure.
34. Generate department budget templates
Prompt 'Create a department budget template with rows for salaries, benefits, travel, supplies, software, and other expenses with formula totals' and Excel Copilot builds the reusable template structure.
35. Draft budget request justification
In Word, use 'Write a justification for a 20% increase in IT budget to support cloud migration and cybersecurity improvements' and Copilot creates a compelling business case narrative.
36. Build scenario analysis models
Ask Excel Copilot to 'Create three scenarios—best case, expected, and worst case—showing revenue and expense impacts with 10%, 0%, and -10% growth assumptions' and it builds the scenario comparison.
37. Generate headcount planning model
Use 'Create a headcount model showing current staff, planned hires by quarter, fully-loaded cost per role, and total compensation expense' and Copilot structures the comprehensive headcount plan.
38. Create capital expenditure tracking
Prompt 'Build a CapEx tracker with project name, approved amount, spent to date, remaining budget, and variance columns with conditional formatting for over-budget items' and Excel Copilot creates the tracking tool.
39. Draft quarterly forecast update memo
Ask Outlook Copilot to 'Write an email announcing Q2 forecast update, explaining we're raising revenue guidance by 5% and lowering expense forecast by 3%' for professional forecast communication.
40. Generate budget calendar timeline
Use Word Copilot to 'Create a budget calendar showing key dates: department submissions due Sept 15, consolidation Sept 30, management review Oct 15, board approval Oct 31' for planning coordination.
Meeting Management & Communication
41. Generate meeting summary with action items
After a budget review meeting in Teams, use Copilot to 'Summarize this meeting and list all action items with owners and deadlines' and it extracts decisions and tasks from the full transcript automatically.
42. Draft follow-up email from meeting
Use Teams Copilot to 'Draft a follow-up email summarizing the budget meeting decisions and attaching revised forecast' and it creates professional meeting recaps with context from the Teams recording.
43. Create month-end close meeting agenda
Ask Word Copilot to 'Generate a month-end close meeting agenda covering reconciliation status, variance explanations, audit items, and timeline review' and it structures the agenda with time allocations.
44. Summarize email threads on budget approvals
In Outlook, use 'Summarize this email thread about the Q4 budget approval process' and Copilot extracts the key decisions, approvals, and remaining questions from lengthy email chains.
45. Generate talking points for financial review
Use PowerPoint Copilot to 'Create talking points for each slide explaining financial performance, key drivers, and management actions' to prepare for board or investor presentations.
46. Draft audit kickoff meeting invite
Prompt Outlook Copilot to 'Write a meeting invitation for annual audit kickoff covering scope, timeline, document requests, and team introductions' with professional, complete context.
47. Create Q&A responses from Town Hall
After a company financial Town Hall in Teams, use 'List all questions asked during this meeting and draft responses to unanswered questions' and Copilot extracts Q&A from the transcript.
48. Generate weekly status update
Ask Outlook Copilot to 'Draft my weekly status email covering completed close activities, open items, blockers, and next week priorities' for consistent team communication.
49. Summarize cross-functional project updates
Use Business Chat to 'Summarize ERP implementation updates from emails, Teams chats, and project documents over the past two weeks' and Copilot aggregates information across all M365 sources.
50. Create onboarding checklist for new finance hire
Prompt Word Copilot to 'Generate a 30-day onboarding checklist for new senior accountant covering systems access, process training, key contacts, and first assignments' for structured onboarding.
Audit, Compliance & Documentation
51. Generate audit documentation index
Use Word Copilot to 'Create an audit documentation index listing all prepared schedules, supporting workpapers, and management representations with file locations' for organized audit files.
52. Draft internal control documentation
Ask 'Document the accounts payable three-way match control including purpose, process steps, responsible parties, and exception handling' and Copilot creates structured control documentation.
53. Create reconciliation workpaper template
Prompt Excel Copilot to 'Build a bank reconciliation template with beginning balance, deposits, checks, adjustments, and ending balance with variance check formulas' for standardized reconciliations.
54. Generate SOX compliance checklist
Use Word Copilot to 'Create a quarterly SOX compliance checklist covering control testing, deficiency tracking, remediation status, and management certification' for compliance monitoring.
55. Draft management representation letter
Ask 'Draft a management representation letter for year-end audit covering financial statement accuracy, completeness of records, and disclosure of contingencies' and Copilot creates the letter framework.
56. Create audit findings tracker
Prompt Excel Copilot to 'Build an audit findings tracker with finding description, risk level, owner, due date, status, and resolution columns with status-based formatting' for remediation tracking.
57. Generate tax documentation summary
Use 'Create a summary of tax-related transactions including depreciation schedules, charitable contributions, and deductible expenses' and Excel Copilot aggregates tax documentation data.
58. Draft process improvement recommendations
Ask Word Copilot to 'Write recommendations for improving month-end close efficiency based on current 12-day close cycle targeting 7 days' and it creates structured improvement proposals.
59. Create financial policy library index
Prompt 'Generate an index of all finance policies including expense reimbursement, procurement, capitalization, revenue recognition with policy owner and review dates' for policy management.
60. Generate quarterly certification memo
Use 'Draft a quarterly financial certification memo confirming accuracy of financial statements, adequacy of internal controls, and disclosure of material events' for compliance certification.
💡 Pro Tips from an MCT
- Be specific with data ranges: Instead of 'analyze this data,' say 'analyze sales data in cells A1:D500 and identify trends by product category.' Copilot works best with explicit instructions.
- Chain prompts for complex tasks: Start with 'create a pivot table of expenses by department,' then follow up with 'add a column chart' and 'format currency with no decimals.' Breaking big tasks into steps gets better results.
- Reference your existing work: Use prompts like 'format this report to match the style in last month's board deck' and Copilot can replicate formatting from documents in your OneDrive or SharePoint.
- Save your best prompts: When you find a prompt that works perfectly, save it in a OneNote page or Word doc. You'll use the same prompts monthly for recurring reports—don't reinvent them each time.
- Verify calculations always: Copilot is excellent at generating formulas, but always spot-check the results against known values. It's a productivity tool, not a replacement for professional judgment.
Want Your Team Using These Prompts by Friday?
I deliver hands-on Copilot training (MS-4018, MS-4019) where your team walks out with a custom prompt library for your actual workflows. Not theory—practical skills they'll use Monday morning. Custom AI solutions in 90 days. You own the IP.
Book Copilot Training