50 ChatGPT Prompts for Accountants: Copy-Paste Templates That Work

50 ChatGPT Prompts for Accountants: Copy-Paste Templates That Work

The quality of your ChatGPT output is directly determined by the quality of your prompt. A vague prompt produces a vague result. A specific, well-structured prompt with clear context and instructions consistently produces near-final output. This is a library of 50 tested prompt templates for accounting tasks — copy, adapt to your context, and use immediately.

How to Use These Prompts

Before using any prompt, replace the bracketed placeholders with your specific information. The more context you provide — the audience, the tone, the key messages — the better the output. Always review AI-generated output before use in any professional context.

Management Commentary and Reporting

1. Variance analysis commentary "Write management commentary for the following variance analysis. Audience: board of directors. Tone: clear and professional. Key message: explain the main drivers of the variance and recommend actions. Data: [paste your actuals vs budget table]. Focus on variances above £[X] and include likely business reasons where visible from the data."

2. Executive summary of management accounts "Write a 200-word executive summary of the following management accounts for the board pack. Highlight the three most significant items. Tone: confident and clear. Data: [paste key P&L lines and KPIs]."

3. Monthly commentary for operational managers "Draft brief monthly performance commentary for department heads. Focus on [department name]. Data: [paste departmental P&L]. Tone: factual and action-oriented. Audience: non-finance managers. Keep to 150 words."

4. Board pack narrative introduction "Write an introduction to the board pack for [month/quarter]. The key themes to cover are: [theme 1], [theme 2], [theme 3]. Tone: authoritative but accessible. Audience: non-executive directors and executive directors. Length: 300 words."

5. Reforecast commentary "Write commentary for the following reforecast vs original budget. Data: [paste table]. Explain the main reasons for changes and the risks and opportunities for the remainder of the year. Length: 250 words."

Client Letters and Communications

6. Tax planning letter "Draft a client letter explaining [tax planning opportunity]. Client: [brief description of client — e.g. owner-managed business, turnover £X]. Tone: clear and advisory. Include: what the opportunity is, the estimated saving, action required, and next steps. Length: 400 words."

7. Year-end accounts cover letter "Write a cover letter to accompany annual accounts for [type of client]. The accounts show [key points — e.g. profit of £X, improved margins, increased borrowing]. Tone: professional and relationship-focused. Length: 300 words."

8. HMRC query response "Help me draft a response to the following HMRC query: [paste query]. Our position is: [brief explanation]. Tone: professional and cooperative. Include: a clear statement of our position, supporting explanation, and offer to provide further information."

9. Client briefing on budget changes "Write a client briefing note on the following budget changes relevant to our clients: [paste relevant changes]. Audience: small business owners. Tone: plain English, practical. Focus on: what it means for them and what they should do. Length: 400 words."

10. Proposal letter for new client "Draft a proposal letter for [type of engagement] for [type of client]. Our key differentiators are: [list]. Tone: professional and confident. Length: 500 words. Include: understanding of their situation, proposed scope, why us, and clear next steps."

Excel Formulas and Data

11. Complex VLOOKUP alternative "Write an INDEX MATCH formula to look up [value] from column [X] in a table where the lookup column is [Y] and the return column is [Z]. The table is on sheet [name] and ranges from [cell] to [cell]."

12. Conditional summary formula "Write a SUMIFS formula to sum [column] where [condition 1] and [condition 2]. The data is in columns [A:E] on sheet [name]."

13. Date-based calculation "Write an Excel formula to calculate the number of working days between [start date cell] and [end date cell], excluding weekends and UK bank holidays listed in range [range]."

14. Debug a broken formula "This Excel formula is returning [error/incorrect result]: [paste formula]. The data it should work on is: [describe structure]. Please explain what is wrong and provide a corrected version."

15. Power Query transformation "Write Power Query M code to: take a table with columns [list], filter rows where [condition], group by [column] and sum [column], then add a calculated column that [calculation]."

Audit Narratives and Documentation

16. Audit working paper narrative "Write a working paper narrative for the audit of [balance/area]. Conclusion: [state your conclusion]. Supporting evidence: [list key evidence obtained]. Risk assessed: [low/medium/high]. Any issues noted: [none / describe issues]. Format: professional audit documentation style."

17. Management representation letter point "Draft a management representation letter point for [specific representation needed]. This is for the audit of [company type] for the year ended [date]."

18. Going concern assessment narrative "Write a going concern assessment narrative based on the following information: [describe financial position, cash position, forecasts, any mitigating factors]. Conclusion: [going concern / material uncertainty]. Length: 300 words."

19. Audit committee report section "Draft a section of the audit committee report covering [topic — e.g. significant judgements, key audit matters]. Key points to cover: [list]. Audience: audit committee members. Tone: formal and technical."

20. Control deficiency write-up "Write a management letter point for the following control deficiency: [describe deficiency]. Include: description of the issue, risk/implication, and recommendation. Tone: professional and constructive."

Tax Research and Technical

21. Tax concept explanation for client "Explain [tax concept] in plain English for a client who is [describe client]. Focus on: what it means for them, why it matters, and what they should do about it. Avoid jargon. Length: 250 words."

22. Comparing tax treatment options "Compare the tax treatment of [option A] vs [option B] for [type of entity/taxpayer]. Cover: income tax/corporation tax treatment, NIC implications, and key considerations for choosing between them. Note any areas where professional advice is essential."

23. Disclosure note drafting "Draft a tax disclosure note for the annual accounts of [type of company]. The key figures are: [current tax charge £X, deferred tax £X, effective tax rate X%]. Include standard disclosure language and flag any areas requiring specific disclosure."

24. Transfer pricing documentation "Draft an executive summary section of a transfer pricing policy document for [describe intercompany transaction]. Cover: description of transaction, parties involved, method selected, and rationale. Length: 400 words."

25. R&D claim narrative "Write the technical narrative for an R&D tax credit claim for the following project: [describe project]. Cover: the scientific/technological uncertainty, the work undertaken to resolve it, and why this qualifies under the HMRC guidelines."

Financial Analysis and Modelling

26. Sensitivity analysis commentary "Write commentary for the following sensitivity analysis of [model/forecast]. Key sensitivities: [list variables and ranges]. Audience: [CFO / board / investors]. Focus on: which sensitivities have the most material impact and what management actions are available to mitigate downside scenarios."

27. KPI definition and explanation "Define the following KPIs for inclusion in a management reporting pack: [list KPIs]. For each, include: definition, formula, why it matters, and what a good result looks like for [type of business]."

28. Investment appraisal summary "Write an investment appraisal summary for the following project: [describe project]. Key financials: [NPV, IRR, payback period]. Key assumptions: [list]. Recommendation: [proceed/reject/further analysis]. Audience: [ExCo/board]. Length: 300 words."

29. Cash flow commentary "Write commentary on the following cash flow statement for [period]. Highlight: the main drivers of cash generation or consumption, key movements in working capital, and the closing cash position. Data: [paste cash flow statement]. Length: 200 words."

30. Covenant compliance reporting "Draft a covenant compliance certificate narrative for the following loan covenants: [list covenants and test levels]. Actual results: [list actuals]. Include: confirmation of compliance/breach, headroom calculation, and any relevant context."

HR and Team Management

31. Job description for finance role "Write a job description for a [role title] position in a [type of organisation]. Key responsibilities: [list]. Required qualifications: [list]. Preferred experience: [list]. Tone: professional and appealing to high-quality candidates."

32. Performance review preparation "Help me prepare for a performance review with [describe team member — level, length of service, role]. Their key achievements this period: [list]. Areas for development: [list]. Draft: opening, achievements discussion, development feedback, and goals for next period."

33. Training needs communication "Draft an email to the finance team introducing a new [training initiative / tool / process]. Key messages: why we are doing this, what it involves, what is expected, and how it will benefit them. Tone: positive and clear. Length: 300 words."

Quick-Reference Prompts

34–40 (one-liners for common tasks)

• "Summarise this annual report in 10 bullet points, focusing on financial performance and key risks: [paste text]"
• "What are the key accounting considerations for [transaction/event]? Summarise in plain English."
• "Review this email for tone and clarity. The recipient is [describe]. Suggest improvements: [paste email]"
• "Write three subject line options for a client email about [topic]. Tone: professional but engaging."
• "Create a meeting agenda for a [type of meeting] with [attendees]. Key topics: [list]. Duration: [X] minutes."
• "Draft a LinkedIn post announcing [achievement/news]. Tone: professional and engaging. Length: 150 words."
• "Translate this accounting jargon into plain English for a non-finance audience: [paste text]"

Related Reading

• ChatGPT for Accounting: How Finance Teams Are Using It in 2026
• How to Write Board Reports With AI: A Step-by-Step Guide
• AI for Month-End Close: A Practical Checklist for Finance Teams
• AI Prompt Engineering for Finance: The Complete Guide

---

Building your AI skills systematically? Join the waitlist for Learnsignal's AI for Finance Professionals programme.