Sort self-employed expenses into tax deduction categories

Group raw transaction lists and receipt records into standard tax deduction buckets to speed up tax preparation.

You getCategorized Expense Summary, itemized Breakdown and items Needing Clarification

Prompt

Prompt
Act as a freelance tax prep assistant. Review my raw list of business expenses and organize them into standard deduction categories suitable for Schedule C tax preparation.

- Provide general tax information only, not legal or certified tax advice, and advise consulting an enrolled agent or CPA for filing determinations.
- Group every expense into standard IRS Schedule C categories, such as Office Expense, Software & Tech, Advertising, Professional Services, Travel, and Meals.
- Identify transactions that look like mixed personal/business use or require special substantiation rules (like meals or mileage).
- Highlight potential red flags, missing details, or subscriptions that appear duplicate.

Output format:
1. Categorized Expense Summary (Table with columns: Category, Total Amount, Transaction Count)
2. Itemized Breakdown (Grouped by category with Date, Description, Amount, and Notes)
3. Items Needing Clarification (List of unclear expenses with advice on documentation)

My transaction list is below:

Example output

Example for: bank export of 6 business card charges

General tax information only, not licensed tax advice. Consult a certified CPA or tax professional to confirm deductible eligibility for your situation.

1. Categorized Expense Summary
CategoryTotal AmountTransaction Count
Software & Cloud Services$67.002
Advertising & Marketing$150.001
Business Meals (50% rule)$48.501
Office Expenses$89.991
Professional Services$200.001
2. Itemized Breakdown

Software & Cloud Services

  • Nov 03: Adobe Creative Cloud - $52.00 (Standard subscription)
  • Nov 14: Google Workspace - $15.00 (Email and cloud storage)

Advertising & Marketing

  • Nov 08: Meta Ads - $150.00 (Client acquisition campaign)

Business Meals

  • Nov 12: Corner Bistro - $48.50 (Client meeting; subject to standard 50% limit; keep receipt and client name on file)

Office Expenses

  • Nov 19: Office Depot - $89.99 (Desk chair mat and printer paper)

Professional Services

  • Nov 22: LegalZoom - $200.00 (Contract template review)
3. Items Needing Clarification
  • Corner Bistro ($48.50): Ensure you have a physical or digital receipt noting who you dined with and the specific business topic discussed.
  • Office Depot ($89.99): If any items were personal supplies, adjust the deductible total accordingly.
Written by AI from this prompt. Your results will vary.

Paste your bank or credit card statements directly after the prompt into ChatGPT, Gemini, or Claude. Follow up by asking how specific flagged items (like home office or cell phone bills) are split between personal and business use.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Personal Finance
Personal Finance

Set up a shared household bills workflow

Build a predictable, automated monthly transfer system for shared expenses. Use this to stop chasing receipts and eliminate awkward money talks with partners or housemates.