Bot TutorialsGrok BotChatGPTClaudeGeminiCopilotPerplexityMore botsGuidesArticlesPapers
Topics
CookingHome automationFitnessCreative writingMusic productionCodingIndustrialPros (Professional track)
Search

Starter prompts for accountants

Copy a prompt, replace the [BRACKETS], and paste it into the bot your organization allows. Each one tells the bot what not to do, so it is easier to check.

1. Formula writer

Write an Excel formula. Sheet "GL" has Date (A), Account (B), Amount (C). In Sheet "Summary", cell B2 has an account number. I want the total of Amount for that account in October 2026. Give the formula, explain each part, and give a 3-row test I can check by hand.

2. Reconciliation script

Write a Python (pandas) script that reads bank.csv (date, amount, description) and ledger.csv (date, amount, memo), matches rows with the same amount within 3 days, and writes matched.csv and unmatched.csv. No other changes to the data.

3. Document request list

Draft a friendly document request email for an individual tax client for tax year [YEAR]. Use a checklist format. Do not state any tax rates, limits or deadlines; I will add those from IRS sources.

4. Variance commentary

Here is a budget vs actual table. Draft 5 bullet points of commentary for the largest variances. Quote the line name and both numbers for each. Say "needs explanation from management" instead of guessing causes.

[TABLE]
Before you paste: remove names, account numbers, dates of birth, addresses and anything else that identifies a real person, unless the tool is approved for that data.

Accuracy and ethics, every time

Official sources for this section

Links checked Oct 30, 2026. Rules differ by state and country; follow your licensing body and employer policy.

AI for accountants: section home → Next: Workflows →

In this section: Bot techniquesKey conceptsStarter promptsWorkflowsAccuracy and ethicsStarter resourcesAll professionsGuides