Categorize a Year of Business Expenses with One Prompt
Export your bank statement as CSV, paste into ChatGPT with this prompt, and get clean expense categories ready for your accountant.
Intended outcome
Replaces hours of manual categorization in spreadsheets.
The prompt
You are a bookkeeping assistant for a sole trader.
Variables:
- Transaction data: {{PASTE_CSV}}
REQUIRED STRUCTURE — process every row and return a CSV with columns: date, description, amount, category, flag:
1. Assign ONE category from: Software, Marketing, Travel, Office, Contractors, Bank Fees, Personal, Income, Uncategorized.
2. Flag any transaction that looks personal, duplicate, or suspicious — add the reason in the flag column.
3. If a transaction cannot be categorized with confidence, set category to "Uncategorized" — do not guess.
Tone: precise, no commentary. Return only the CSV with a header row.Variables to replace
Fill each variable with your own value before running the prompt.
- [paste_csv] — your value
Suggested AI models
This prompt was written to work with the models below. Small tone or length adjustments may be needed when switching models — treat this as a starting point, not a guarantee of identical output.
Before you run it
- · Replace every variable with your own value — do not leave placeholders.
- · Read the output before sending it to a client.
- · Don't paste confidential client data into a public model without checking the provider's data policy.
The full breakdown
Tax time is brutal when expenses live in a chaotic bank export. This prompt turns CSV rows into clean categories in minutes.
The Prompt
You are a bookkeeping assistant for a sole trader.
Variables:
- Transaction data: {{PASTE_CSV}}
REQUIRED STRUCTURE — process every row and return a CSV with columns: date, description, amount, category, flag:
1. Assign ONE category from: Software, Marketing, Travel, Office, Contractors, Bank Fees, Personal, Income, Uncategorized.
2. Flag any transaction that looks personal, duplicate, or suspicious — add the reason in the flag column.
3. If a transaction cannot be categorized with confidence, set category to "Uncategorized" — do not guess.
Tone: precise, no commentary. Return only the CSV with a header row.Run this alongside the messy bookkeeping spreadsheet prompts before tax season, and use the Zapier invoice reminder guide to stop new mess from piling up. The rest of the bookkeeping toolkit lives in the prompts library.
SoloPromptAI creates practical tools and guides for getting clearer, more useful results from AI—without the prompt-engineering theater.
Related prompts
5 Copy-and-Paste AI Prompts to Clean Up Messy Bookkeeping Spreadsheets
Five battle-tested ChatGPT prompts that turn chaotic freelancer bookkeeping spreadsheets into clean, accountant-ready data in minutes — no formulas required.
- Outcome:
- Five reusable prompts cover the 90% of bookkeeping mess freelancers face.
- Models:
- ChatGPT, Claude, Gemini
- Variables:
- [paste_csv] [month_year]
The 5-Minute Weekly Admin Cleanup Prompt
Turn a messy inbox and to-do list into a prioritized Monday action plan with one ChatGPT prompt.
- Outcome:
- Paste your raw notes and inbox subject lines in.
- Models:
- ChatGPT, Claude, Gemini
- Variables:
- [paste_here]
The Perfect Client Onboarding Email Prompt for Freelancers
A copy-and-paste ChatGPT prompt that generates warm, professional onboarding emails tailored to each new client in under 30 seconds.
- Outcome:
- Replace manual onboarding emails with one reusable prompt template.
- Models:
- ChatGPT, Claude, Gemini
- Variables:
- [client_name] [project_type] [kickoff_date] [business_name]