Skip to main content
SoloPrompt AI
All prompts
Bookkeeping
Business
Productivity

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.

Updated By SoloPromptAI Editorial

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.

ChatGPT
Claude
Gemini

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

text
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.
Stack of paper receipts and a laptop showing a spreadsheet for expense tracking.
Categorize a year of expenses in minutes — output drops straight into QuickBooks or Xero.

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.

AdminBusinessProductivity

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]
MarketingBusinessMarketing

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]