ChatGPT Prompts for Bookkeeping and Finance (Copy and Paste)

Quick answer: The most useful ChatGPT prompts for finance give the model a role, your context, the exact data, one clear task, an output format and an instruction to show its working. Use them to categorize expenses, prepare reconciliations, structure cash flow forecasts and explain reports, then verify every number and keep sensitive data out of the chat.

This is a prompt library for small business owners, freelancers and bookkeepers who already keep records and want help with the thinking and formatting around them. Every prompt uses placeholders in square brackets so you can swap in your own details without pasting real names or account numbers. If you need help creating a client invoice itself, our separate guide to making an invoice with ChatGPT covers that; this page focuses on the bookkeeping and analysis around it.

Two rules before you start. First, treat every figure in a response as a draft until you have checked it against your source data. Second, do not paste bank account numbers, card numbers, tax IDs, passwords or customer personal data the task does not need.

How to write ChatGPT prompts for finance that you can check

Finance prompts fail in a predictable way: the answer sounds authoritative, but the numbers or rules are wrong. A good structure makes errors visible.

Part	What to include	Example
Role	Who the model should act as	Experienced bookkeeper for small service businesses
Context	Business type, country, cash or accrual basis, currency	US design studio, cash basis, USD
Data	Only the columns needed, with placeholders for names	Date, description, amount
Task	One job per prompt	Suggest a category for each line
Format	Table, columns, length	Table with original line, category, confidence
Checks	Show working, flag uncertainty, no guessing	Write "unclear" instead of guessing; show totals

You can add this sentence to the end of almost any prompt: Use only the data I provide. Show each calculation. If information is missing or ambiguous, say so instead of assuming.

Bookkeeping and expense categorization prompts

These help you build a consistent chart of accounts and classify spending. Our guide on how to track business expenses explains the record-keeping side.

Task	Prompt to copy
Build a simple chart of accounts	Act as a bookkeeper. Suggest a simple chart of accounts for a [type of business] in [country] using [cash/accrual] accounting, with no more than [number] expense categories. Explain each category in one line.
Categorize transactions	Using only these categories: [list], suggest a category for each transaction below. Add a confidence column (high/medium/low) and mark anything that could be personal, a transfer or a loan repayment as "review". [paste date, description, amount]
Write categorization rules	From these examples of categorized transactions, write a list of simple rules I can apply in my accounting software, such as "description contains X goes to category Y". [paste examples]
Spot possible duplicates	List any transactions below that might be duplicates (same amount within 3 days, or same payee and amount in the same month). Do not delete anything; just list them with the reason. [paste data]
Explain a term	Explain [prepaid expense / accrued revenue / depreciation] in plain English with a numeric example for a [type of business]. Note where rules differ by country.

Bank reconciliation prompts

ChatGPT cannot see your bank feed, but it can help you work through a reconciliation you have exported. Our bank reconciliation guide explains the full method.

Task	Prompt to copy
Reconciliation layout	Create a bank reconciliation template with sections for balance per bank statement, deposits in transit, outstanding checks, bank errors, balance per books, bank fees and interest. Show the formula linking the two adjusted balances.
Find unmatched items	Here are two lists: bank lines and ledger lines, each with date, reference and amount. Match lines with the same amount within 5 days. List unmatched items from each side separately. Do not invent matches. [paste lists]
Explain a difference	My adjusted bank balance is [amount] and my adjusted book balance is [amount]. List the common reasons for a difference of exactly [difference], including transposition errors, and how to test each.

Invoicing and accounts receivable prompts

Task	Prompt to copy
Aging summary	From this list of unpaid invoices (invoice number, client code, due date, amount), group them into current, 1 to 30, 31 to 60, 61 to 90 and over 90 days past due as of [date]. Show the total for each bucket and the grand total.
Collection priorities	Rank these overdue accounts for follow-up, considering amount, days overdue and payment history I describe. Explain the ranking in one line each. [paste client codes and notes]
Reminder sequence	Write three payment reminders for invoice [number] for [amount] due on [date]: friendly at 3 days overdue, firm at 14 days, final notice at 30 days. Do not add late fees or legal threats unless I list them.
Payment terms wording	Suggest clear payment terms wording for a [type of business] using [Net 30], accepted payment methods [list] and a late fee of [rate if allowed]. Keep it under 60 words.

For the aging prompt, compare the result with the method in our accounts receivable aging report guide, which shows how buckets are calculated.

Cash flow and budgeting prompts

Task	Prompt to copy
13-week forecast layout	Design a 13-week cash flow forecast for a small [type of business]: opening cash, receipts by source, payments by category, net cash flow, closing cash. Give the spreadsheet formulas, assuming weeks run across columns B to N.
Scenario thinking	Given these monthly figures [revenue, fixed costs, variable cost %], show what happens to monthly profit if revenue falls 10%, 20% and 30%. Show the calculation for each scenario.
Cost review	Review these monthly expenses and group them into must-keep, could-reduce and could-cancel. Ask me questions about anything unclear rather than assuming. [paste category and amount]
Break-even	Calculate my break-even monthly revenue with fixed costs of [amount] and a gross margin of [percent]. Show the formula and the arithmetic.

For the forecast itself, our cash flow forecast guide explains where the inputs should come from.

Reporting and analysis prompts

Task	Prompt to copy
Explain a P&L	Here is my profit and loss summary for [period] with the prior period alongside. Explain the three biggest changes in plain English and list questions I should ask my accountant.
Ratio check	From these figures, calculate gross margin, net margin and current ratio. Show each formula, then explain what a change in each would mean for a small business.
Owner summary	Turn these monthly numbers into a five-bullet summary for a business owner: revenue, gross profit, cash at month end, overdue receivables, biggest expense change.
Spreadsheet formula	My sheet has dates in column A, categories in B and amounts in C. Write a formula that totals category [name] for [month], and explain how it works.

If you are new to reading a profit and loss statement, ask ChatGPT to explain each line using your own report as the example. For formula-heavy work, see our ChatGPT for Excel guide.

Tax preparation prompts (for organizing, not advice)

Use these to get ready for your accountant or filing software, not to decide what to claim.

• List the documents a [sole proprietor / limited company] in [country] typically gathers for an annual tax return, as a checklist. Mark anything that depends on local rules as "check with an adviser".
• Turn my notes below into a clear list of questions for my accountant about [topic], ordered by importance.
• Explain the difference between [sales tax and VAT / zero-rated and exempt supplies] with a simple numeric example. Do not state current rates.

Look up rates yourself on official sites or use a sales tax calculator, then give the verified rate to the model if it needs one.

Worked example: checking an AI expense summary

Suppose you paste four uncategorized expenses (illustrative figures) and ask for totals by category:

• Software subscription: $1,240.00
• Printer ink and paper: $385.50
• Client lunch: $92.75
• Contractor payment: $610.00

The model returns: Software $1,240.00, Office supplies $385.50, Meals $92.75, Contract labor $610.00, total $2,318.25. Check the total yourself: 1,240.00 + 385.50 = 1,625.50; 1,625.50 + 92.75 = 1,718.25; 1,718.25 + 610.00 = 2,328.25. The AI total is $10.00 short, which is exactly the kind of small slip that is easy to miss in a neat table. Also note that meals are often only partly deductible, and the rule depends on your country, so the category is right but the tax treatment still needs your accountant.

Keep your financial data private

Before you use any of these ChatGPT prompts for finance with real records, check your settings. OpenAI explains the model-training toggle, Temporary Chats and deletion in its data controls FAQ. Business workspace plans have different terms from personal accounts. Our guide to AI data privacy for financial data has a full checklist, including how to redact exports.

• Replace client names with codes such as CLIENT_A and keep the key offline
• Delete account numbers, card numbers, tax IDs and addresses from exports
• Send totals or samples instead of full ledgers when that answers the question
• Prefer business plans with admin controls for team use

Build your own library of ChatGPT prompts for finance

The prompts above are starting points. The real time saving comes from keeping the versions that work for your business in one shared document, so you are not rewriting instructions every month.

1. Save the prompt and a sample output. Note the date, the plan you used and what you had to correct.
2. Fix your context block. Write one paragraph describing your business, country, currency, accounting basis and chart of accounts, and paste it at the top of each finance prompt.
3. Name prompts by month-end task. For example: categorize card spend, reconcile main account, aging summary, owner report. Run them in the same order each month.
4. Review quarterly. Models and features change. Re-test your saved prompts with a small known dataset where you already know the right answer.

Checklist for every finance prompt

• The prompt states country, currency and accounting basis
• Only necessary columns are included, with placeholders for names
• The model was told to use only provided data and show its working
• Totals were recalculated in a spreadsheet or calculator
• Any tax or legal statement was checked against an official source
• Final figures were entered in your books, not left in a chat

Common mistakes with AI finance prompts

• Asking for facts instead of giving data. "What were my sales last quarter?" invites invention. Paste the numbers.
• Combining many tasks. Categorize, reconcile and forecast in one prompt and errors multiply. One task per prompt.
• Accepting rounded or merged totals. Always recompute.
• Letting the model choose tax rates. Rates vary by place and change over time.
• Pasting full statements. Most questions can be answered with a redacted extract.
• Skipping your accountant. AI helps you prepare; a professional is still accountable for tax filings. Our look at AI bookkeeping covers where software and people each fit.

Turn the output into real documents

Once a prompt has helped you tidy line-item descriptions or confirm what is overdue, put the result into your normal tools. Our free invoice generator creates a PDF invoice in your browser and saves drafts to your browser's local storage; it has no AI features and does not send or track invoices, so you check and send each one yourself. Keep using these ChatGPT prompts for finance as a thinking partner, and keep your books as the single source of truth.