6 ChatGPT Prompts Bookkeepers Can Copy and Paste Today

Independently researched from published sources. Last researched: April 2026. Results vary: this article teaches AI skills, not employment outcomes. See Terms and Privacy.

Scope of practice and advice notice

This article covers a profession with specific obligations in the area named above. It is not a substitute for your licensing, supervision, or professional duties, and nothing here is legal or compliance advice. Keep a human decision-maker on anything those obligations touch, and check your company's AI policy before using any prompt or tool with real work data.

A lot of AI advice for bookkeepers stops at 'ask ChatGPT to categorize your transactions.' That gets you a vague answer and a lot of back-and-forth. The prompts below are structured differently. Each one has placeholders that force you to give the AI the exact context it needs, so you usually get a usable result on the first try.

These come from prompt collections built for working bookkeepers and accountants, with sources verified during research. Every prompt specifies the output format, so you get structured tables or draft text you can paste straight into your workflow.

Pick one prompt that matches something on your to-do list right now. Replace the bracketed placeholders with real client data. Paste it into ChatGPT or Claude and see what comes back. If the output works, you are done. If it needs a tweak, adjust and run it again.

1. Transaction Categorization Explainer

Categorizing bank feed transactions takes up a big chunk of the week. This prompt maps each transaction to your actual chart of accounts with a one-sentence justification, so you have audit-ready reasoning without writing it yourself. It also flags ambiguous items and possible personal expenses mixed in.

copy and paste this prompt
I have a list of bank feed transactions that need categorizing. Here is my chart of accounts: [PASTE YOUR CHART OF ACCOUNTS] Here are the uncategorized transactions: [PASTE TRANSACTIONS: date, description, amount] For each transaction: 1. Suggest the correct account category from my chart of accounts 2. Explain WHY this category is correct in one sentence (so I can justify it to my client or during an audit) 3. Flag any transactions that are ambiguous and need my judgment call 4. Note any that might be personal expenses mixed in with business expenses Format as a table: Date | Description | Amount | Suggested Category | Reasoning | Flag (if any)

How to use it: Paste your client's chart of accounts and the uncategorized transactions (date, description, amount) into the bracketed sections. Review the suggested categories and flags before posting anything to the ledger.

Source

2. Client Financial Summary (Plain English)

Writing a plain-English summary after closing the books takes longer than it should. This prompt structures the output so it leads with the single most important takeaway and ends with questions the owner should think about. The 150-word cap keeps it tight enough to actually get read.

copy and paste this prompt
Here are the financial results for [CLIENT NAME] for [MONTH/QUARTER]: Revenue: [AMOUNT] COGS: [AMOUNT] Gross Profit: [AMOUNT] Operating Expenses: [AMOUNT] Net Income: [AMOUNT] Cash Balance: [AMOUNT] Accounts Receivable: [AMOUNT] Accounts Payable: [AMOUNT] Previous period comparison: [PASTE PRIOR PERIOD NUMBERS] Write a 150-word plain-English summary that: 1. Starts with the single most important takeaway (good or bad) 2. Highlights the 2-3 biggest changes from last period and likely reasons 3. Flags any concerning trends (e.g., receivables growing faster than revenue, cash declining despite profits) 4. Ends with 1-2 specific questions the business owner should think about Tone: professional but approachable, like a knowledgeable friend explaining the numbers, not a robot reciting them. Avoid jargon. If you use an accounting term, define it in parentheses.

How to use it: Fill in the current period numbers and paste the prior period figures for comparison. Send the output directly to your client or use it as the body of your monthly email.

Source

3. Bank Reconciliation Discrepancy Notes

You found the discrepancies, and now you need to explain each one and draft correcting entries for your workpaper. This prompt suggests likely causes and writes journal entries in debit/credit format. It also notes recurring issues that point to a process fix.

copy and paste this prompt
I've completed a bank reconciliation for [CLIENT/BUSINESS] for [MONTH] and found the following discrepancies: [LIST EACH DISCREPANCY: date, description, bank amount, book amount, difference] For each discrepancy: 1. Suggest the most likely cause (timing difference, data entry error, missing transaction, bank error, duplicate entry, unrecorded fee) 2. Recommend the specific correcting action (journal entry, void and re-enter, contact bank, etc.) 3. Draft the journal entry if one is needed (debit/credit format with accounts) 4. Note if this is a recurring issue that needs a process fix Also provide: - A summary paragraph I can include in my reconciliation workpaper - A list of any items that need client confirmation before I can resolve them Format clearly, I'll be copying this into my working papers.

How to use it: List each discrepancy with the date, description, bank amount, book amount, and difference. Copy the correcting entries and summary paragraph straight into your reconciliation workpaper.

Source

Finding these useful? The full guide has 16 of them, plus tool reviews and a 30-day plan. Get it for $24.

4. Invoice Follow-Up Email Sequence

Chasing overdue invoices is awkward, and it is easy to delay it or send the same vague reminder every time. This prompt generates three emails at escalating firmness: 7 days, 21 days, and 45 days overdue. Each email is short enough to send without heavy editing.

copy and paste this prompt
Write a 3-email follow-up sequence for overdue invoices for [BUSINESS NAME]. Client name: [CLIENT] Invoice number: [NUMBER] Amount due: [AMOUNT] Original due date: [DATE] Days overdue: [NUMBER] Payment terms: [NET 30/NET 60/OTHER] Email 1 (Friendly Reminder, 7 days overdue, ~75 words): - Assume it was an oversight - Reattach or reference the invoice - Make payment easy, include payment link or instructions Email 2 (Firm Follow-Up, 21 days overdue, ~100 words): - Reference the previous reminder - State the impact of late payment on your service delivery - Request a specific response date - Offer to discuss if there's a payment issue Email 3 (Final Notice, 45 days overdue, ~100 words): - State this is a final notice before escalation - Reference total outstanding amount and all previous attempts - Give a clear deadline (5 business days) - Note next steps if unpaid (late fees, service suspension, collections) Tone: professional and firm, never aggressive. The goal is to get paid while keeping the client relationship intact.

How to use it: Fill in the client name, invoice number, amount, due date, and days overdue. Copy each email into your email client and send or schedule them at the appropriate intervals.

Source

5. Financial Variance Analysis

Comparing two periods line by line is tedious, and explaining why each number moved is the real work. This prompt calculates changes and suggests likely causes for each line item, then flags which variances need investigation. It ends with an executive summary you can hand straight to the business owner.

copy and paste this prompt
Compare these two periods for [BUSINESS NAME]: Current period [MONTH/QUARTER]: [PASTE P&L LINE ITEMS] Prior period [MONTH/QUARTER]: [PASTE P&L LINE ITEMS] Budget (if available): [PASTE BUDGET LINE ITEMS] For each significant variance (over 10% or over $[THRESHOLD]): 1. Calculate the dollar and percentage change 2. Suggest the most likely cause (seasonal, one-time, pricing change, volume change, new vendor, lost customer) 3. Flag whether it needs investigation or is explainable 4. Recommend whether to adjust the forecast going forward Present as a table: Line Item | Current | Prior | $ Change | % Change | Likely Cause | Action Needed End with a 3-sentence executive summary: what happened, why it matters, and what to do about it.

How to use it: Paste the P&L line items for both periods and the budget if you have one. Set your materiality threshold in the dollar amount bracket so the output focuses on variances that actually matter.

Source

6. Accounts Receivable Aging Analysis

The aging report tells you what is owed, not what to do about it. This prompt turns raw aging data into a prioritized collection plan with draft emails, write-off candidates, and a DSO calculation. The one-paragraph owner summary saves you from explaining the situation from scratch every month.

copy and paste this prompt
Here is the accounts receivable aging report for [BUSINESS NAME] as of [DATE]: [PASTE OR DESCRIBE: customer name, total owed, current, 1-30 days, 31-60 days, 61-90 days, 90+ days] Analyze this and provide: 1. Total AR outstanding and breakdown by aging bucket (with percentages) 2. Top 5 highest-risk accounts (largest balances in 60+ days) with recommended actions for each 3. Collection priority list, who to call first and what to say 4. A draft 'soft reminder' email for accounts 30-60 days overdue 5. A draft 'firm notice' email for accounts 60-90 days overdue 6. Recommended write-off candidates (90+ days with no response history) 7. A one-paragraph summary I can present to the business owner explaining the state of collections and any cash flow risk Also calculate: Days Sales Outstanding (DSO) and compare to industry average for [INDUSTRY] if known.

How to use it: Paste your AR aging report with customer names and amounts broken out by aging bucket. Use the collection priority list to structure your calls for the week.

Source

Common questions

For the Transaction Categorization Explainer, yes. The prompt maps transactions to your specific chart of accounts, not generic categories. If you leave it out, you get textbook account names that do not match your ledger. A quick copy-paste from your accounting software is all it takes.
The prompts are software-agnostic. You paste your own data and the AI works with whatever you provide. The output comes back as structured tables or draft text you can use in any accounting platform.
Review every journal entry before posting. The AI drafts entries based on the discrepancy details you provide and formats them in standard debit/credit layout, but it does not see your live ledger. Verify account numbers and confirm the entry makes sense in context before recording it.
These six are a sample. The full guide ($24) covers a wider set of bookkeeping workflows, including month-end close, tax prep, vendor payment scheduling, and client onboarding. Same structured, copy-paste format throughout.

This is the free version

The full Bookkeeper guide goes much further: 16 copy-paste prompts, honest reviews of 14 tools with current prices, a dos and don'ts chapter, and a 30-day plan to put it all into practice.

Get the full guide. $24

One-time purchase. Instant download. Or read more about what's inside.

More free bookkeeper resources