In the pack: ChatGPT, Claude & Gemini Prompts for Finance and Accounting Professionals
Bank Feed Transaction Categorisation With Query List
Prompt
Business type: {{BUSINESS_TYPE}}
Chart of accounts (codes and names): {{CHART_OF_ACCOUNTS}}
Transactions (date, description, amount, money in or out): {{TRANSACTIONS}}
Business-specific rules, such as recurring suppliers and what they supply: {{CODING_RULES}}
1. Return a table: date, description, amount, proposed account from my chart only, confidence (high, medium, low) and reason.
2. Do not code any item that could belong to more than one account, may be personal, or may be a capital purchase; put those in a separate query list with one specific question per item.
3. Total the proposed amounts by account and check that the grand total equals the net of all transactions I supplied. Show the check.
4. Note patterns that suggest a missing rule, such as the same supplier coded two ways.
Rules: use only accounts in my chart, never invent an account, and never assume a transaction's purpose from the description alone. Flag items where sales tax or VAT treatment depends on the answer, for my adviser to confirm.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Bank Feed Transaction Categorisation With Query List” is a free prompt for ChatGPT in the Productivity category, 177 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{BUSINESS_TYPE}}, {{CHART_OF_ACCOUNTS}}, {{TRANSACTIONS}}, {{CODING_RULES}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 9 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.