50 ChatGPT Prompts for Accountants and Bookkeepers

Accountants and bookkeepers spend a lot of time on work around the numbers: emails, checklists, formulas, memos, and explanations. ChatGPT can speed up that work, as long as you keep it away from final numbers and final judgments.

These prompts run in ChatGPT, Claude, Gemini, or Copilot, so you can use whichever assistant your firm approves. Copy a prompt, replace the details in [brackets], and edit the output to fit your client and your policies.

A Safety Note Before You Start

Read this once, then keep it in mind for every prompt below.

• AI is not tax, legal, or accounting advice. It does not know your client, your ledger, or the rules that apply where they operate. Use it to draft, explain, and organize. You make the calls.
• Never paste client identifiers or bank details. No client names, tax ID numbers, account numbers, bank statements, payroll records, or login details.
• Anonymize confidential financials. Replace names with "Client A," round or scale the numbers, and keep only the columns the prompt needs. Sample data with the same shape works just as well.
• Check every number. AI can make math mistakes and invent figures with total confidence. Recalculate anything that matters in your spreadsheet or accounting system.
• Follow your firm's rules. Some firms and clients restrict AI tools. Check your engagement letters, privacy duties, and IT policy first.

With that in place, here are 50 prompts grouped by the work that fills your week.

Reconciliations and Month-End Close

Use these to plan the close, find differences faster, and write up what you found. The matching itself stays in your system, where every figure can be traced.

1. Month-End Close Checklist

"Create a month-end close checklist for a [type of business, e.g., small services company] that uses [accounting software]. Group tasks by day of the close (day 1 to day [X]), and for each task list the owner role and what 'done' looks like."

2. Bank Reconciliation Troubleshooter

"My bank reconciliation is off by [amount]. The book balance is [amount] and the bank balance is [amount]. List the most common causes of a difference like this, in the order I should check them, and what to look for in each case."

3. Unmatched Items Pattern Finder

"Here is an anonymized list of unmatched items from a reconciliation, with date, description, and amount: [paste list]. Group them into likely causes (timing, duplicates, missing entries, amount errors) and tell me which ones to investigate first."

4. Accrual Estimate Approach

"I need to estimate an accrual for [expense type, e.g., utilities not yet billed]. Suggest 3 reasonable methods to estimate it, what data each method needs, and the risks of each. Do not give me a final number."

5. Reconciliation Memo

"Turn these rough notes into a short, clear reconciliation memo for the file: [paste notes with no client names]. Include the account, period, balances, reconciling items, and follow-up actions."

6. Intercompany Mismatch Checklist

"Two related entities show different intercompany balances at month end. Give me a step-by-step checklist to find the cause, covering timing, currency, and recording differences."

7. Prepaid and Deferral Schedule Layout

"Design a spreadsheet layout for tracking [prepaid expenses or deferred revenue]. List the columns I need, how the monthly amount should be calculated, and the checks that confirm the schedule ties to the balance sheet."

8. Close Retrospective

"Our last close took [X] days. The main delays were [list issues]. Suggest 5 practical changes to shorten the next close, and rank them by effort and impact."

Bookkeeping and Categorizing Transactions

Speed up coding, clean up the chart of accounts, and build repeatable rules. Always review suggested categories before posting.

9. Transaction Categorizer

"Suggest an account category for each of these anonymized transactions based on the description and amount: [paste list]. Use this chart of accounts: [paste account names]. Mark any you are unsure about and explain why."

10. Bank Rule Ideas

"Based on these recurring transaction descriptions, suggest bank rules I could set up in [accounting software] to code them automatically: [paste descriptions]. For each rule, give the match text and the account."

11. Chart of Accounts Cleanup

"Review this chart of accounts for a [type of business]: [paste account list]. Point out duplicates, accounts that are too broad or too narrow, and naming that is inconsistent. Suggest a cleaner structure."

12. Capitalize or Expense Question

"A client bought [describe item and use]. Walk me through the general questions to ask when deciding whether to capitalize or expense a purchase like this. Do not give a final answer. List what I need to check in our policy and the applicable standards."

13. Receipt and Document Request List

"Write a clear list of the documents I need from a client to finish their bookkeeping for [period]. Group it by type (sales, expenses, payroll, bank, loans) and keep it simple for a non-accountant."

14. Coding Guide for Staff

"Write a one-page coding guide for junior bookkeepers on how to code [type of expenses, e.g., travel and meals] for a [type of business]. Include common mistakes and examples."

15. Duplicate Payment Check

"Explain how I can find possible duplicate supplier payments in a spreadsheet export with columns [list columns]. Give me the steps and the formulas or filters to use."

Excel and Google Sheets Formulas

Describe what you want in plain words and let AI write the formula. Test every formula on a few rows where you already know the answer.

16. Formula From Plain English

"Write an [Excel or Google Sheets] formula that [describe the goal, e.g., sums column D when column B is 'Travel' and column A is in March]. My data starts in row [X]. Explain how the formula works."

17. Lookup for Matching

"I have two sheets. Sheet 1 has [columns] and Sheet 2 has [columns]. Write a formula that finds each invoice number from Sheet 1 in Sheet 2 and returns the amount, and shows 'Not found' if it is missing."

18. Fix My Broken Formula

"This formula returns [error or wrong result]: [paste formula]. My data looks like this: [describe columns]. Explain what is wrong and give me a fixed version."

19. Aging Buckets

"Write a formula that puts each invoice into an aging bucket (Current, 1-30, 31-60, 61-90, 90+) based on the due date in column [X] and today's date."

20. Variance Columns

"Create formulas for a budget vs actual sheet with budget in column [X] and actual in column [Y]. I need the variance amount, the variance percent, and a flag when the variance is over [threshold]. Handle a budget of zero without an error."

21. Data Cleanup

"My exported data has [describe problem, e.g., amounts stored as text, extra spaces, dates in different formats]. Give me formulas or steps to clean it so I can use it in a pivot table."

22. Pivot Table Plan

"I want a pivot table that shows [what you want to see, e.g., expenses by department by month]. My columns are [list]. Tell me which fields go in rows, columns, values, and filters."

Client Communication

Write clearer emails, faster. Keep client names and figures out of the prompt, then add them yourself before you send.

23. Missing Documents Reminder

"Write a polite but firm email to a client who has not sent [documents] for [period]. The deadline is [date]. Explain what happens if we do not receive them in time. Keep it short and friendly."

24. Explain a Report in Plain Words

"Explain what a [report, e.g., cash flow statement] shows to a small business owner with no finance background. Use simple words and one short example with round numbers."

25. Bad News Email

"Draft an email telling a client that [issue, e.g., their records need extra cleanup and the fee will be higher]. Be clear, calm, and professional. Explain why and offer next steps."

26. Fee Increase Notice

"Write a respectful email letting existing clients know our fees will change on [date]. Explain the reason in one or two sentences, thank them, and invite questions. No apologizing tone."

27. Onboarding Welcome Email

"Write a welcome email for a new bookkeeping client. Include what we need from them in the first week, how we will communicate, and our monthly timeline."

28. Answer a Common Question

"A client asked: '[paste question with identifying details removed]'. Draft a clear answer in plain language. Flag any point that I need to confirm against official guidance before I send it."

29. Tone Fixer

"Rewrite this email so it sounds professional and helpful, not defensive, while keeping the same message: [paste draft]."

Reporting and Variance Commentary

Turn numbers into clear explanations for managers and owners. Paste summarized, anonymized figures only, and check every number in the output against your source.

30. Variance Commentary Draft

"Write short management commentary for these budget vs actual results: [paste summarized table]. For each line with a variance over [threshold], give a one-sentence explanation based on these known causes: [list causes]. Do not invent reasons. Mark lines where I need to add one."

31. Month-End Summary for Owners

"Turn these key figures into a one-page monthly summary for a business owner: [paste rounded figures]. Lead with the 3 most important points in plain language."

32. KPI Definitions

"Write clear definitions and formulas for these KPIs for a [type of business]: [list KPIs, e.g., gross margin, days sales outstanding, current ratio]. Add one line on what a rising or falling value usually means."

33. Chart Choice

"I want to show [what you want to show, e.g., monthly revenue vs last year] to a non-finance audience. Which chart type should I use, and how should I label it so it is easy to read?"

34. Board Pack Outline

"Create an outline for a monthly finance pack for [audience, e.g., a small company board]. Include sections, what each should show, and the order that tells the clearest story."

35. Commentary Editor

"Edit this financial commentary so it is shorter and clearer without changing any numbers or conclusions: [paste commentary]. List any sentence that is vague or unsupported."

Tax-Season Prep (General Organization Only)

These prompts help you organize the work, not decide tax positions. Tax rules differ by location and change often, so confirm every tax point against official guidance or a qualified tax professional.

36. Year-End Document Checklist

"Create a general year-end document checklist for a [type of client, e.g., self-employed consultant or small retail business]. Group it by income, expenses, assets, and payroll. Keep it general and do not name specific tax rules."

37. Client Tax Organizer Email

"Write an email asking clients to send their year-end documents by [date]. Include a short checklist, how to send files safely, and what happens if they are late."

38. Deadline Tracker Layout

"Design a simple spreadsheet to track [filing or deadline type] for [number] clients. List the columns, status options, and a formula that flags items due within [X] days."

39. Questions to Ask a New Client

"List the general questions I should ask a new client at year end to understand their situation before preparing their accounts. Group by business activity, changes during the year, and records."

40. Explain a Tax Concept Generally

"Explain the general idea of [concept, e.g., depreciation or the difference between a deduction and a credit] in plain language for a client. Do not include rates, thresholds, or local rules. Add a note that the details depend on their situation."

Audit Prep

Get organized before the auditors arrive. Never paste confidential audit files or client data. Work from structures and anonymized summaries.

41. PBC List Organizer

"Here is a list of items the auditors requested: [paste list with no client names]. Organize it by area, suggest an owner role for each, and create a tracker layout with status and due date columns."

42. Control Walkthrough Notes

"Help me write clear walkthrough notes for the [process, e.g., purchase-to-pay] process. Ask me questions one at a time about each step, then turn my answers into a short process narrative."

43. Supporting Schedule Checklist

"What should a clean supporting schedule for [account, e.g., accrued liabilities] include so an auditor can follow it? Give me a checklist covering ties, references, and explanations."

44. Response to an Audit Finding

"Draft a professional management response to this audit finding: [paste finding with identifying details removed]. Include the root cause, the corrective action, the owner role, and a target date. Keep it factual."

45. Sampling Explained

"Explain in plain language how auditors usually select samples for testing [area]. What records should I have ready so the testing goes smoothly?"

Learning and Professional Development

Use AI as a study partner and career coach. Check any technical point against current standards or your study materials, because AI can be out of date.

46. Standard Explained Simply

"Explain the main idea of [accounting standard or topic, e.g., revenue recognition] in plain language, with one simple example. Then list 3 common mistakes people make with it."

47. Practice Questions

"Write 10 multiple-choice practice questions on [topic, e.g., bank reconciliations or accruals]. Include the correct answer and a short explanation for each. Mix easy and hard questions."

48. Learning Plan for a New Skill

"I am a [role] who wants to learn [skill, e.g., building financial models or using Power Query]. Make a 4-week plan with [X] hours per week, weekly goals, and a small practice task each week."

49. Resume Bullet Points

"Turn these duties into strong resume bullet points for a [role] position: [paste duties]. Start each with an action verb and show results where possible, without inventing numbers."

50. Interview Practice

"Ask me 8 common interview questions for a [role, e.g., senior bookkeeper] job, one at a time. After each answer, give me short feedback and a better way to phrase it."

Tips for Better Results

Give the shape, not the secrets. Describe your columns, the period, and the business type. AI does not need real names or real figures to help with structure.

Ask it to show its work. Add "explain each step" to formula and reconciliation prompts. It makes errors easier to spot.

Test before you trust. Run every formula on rows where you already know the answer. Recalculate every figure AI puts in a draft.

Tell it what not to do. "Do not invent reasons" and "do not include local tax rules" keep drafts safe and honest.

Iterate. If a draft is off, say "shorter," "simpler," or "more formal" instead of starting over.

Own the final version. AI writes a first draft. You are responsible for accuracy, compliance, and client confidentiality.

Keep Building Your AI Skills

These prompts are a starting point. The bigger time savings come from building AI into your own close and reporting process.

Our free AI for Finance and Accounting course covers the basics of using AI safely in finance work. If the close is where your time goes, try AI for Financial Reporting and Month-End Close. For a broader, practical overview, see AI for Finance Professionals: The Complete Practical Guide. And if formulas slow you down, the short AI-Powered Excel Formulas course takes about 20 minutes.

Want to compare more learning options? Read our list of the best free AI courses for finance professionals.

Used carefully, AI takes care of the drafting so you can spend more time on the judgment calls that need an accountant.