Monthly Bookkeeping & Expense Categorizer for Coaches

Every coach knows the feeling: it’s the end of the month (or worse, the end of the tax year) and there’s a pile of bank lines, app charges, and coffee receipts that all need a home. Bookkeeping isn’t hard, it’s just tedious, and tedious is exactly the kind of work you keep putting off.

This prompt makes bookkeeping for coaches a 10-minute job. You paste in a month of raw transactions and your category list, and the AI sorts every line into a clean, tax-ready table, totals each category, and flags anything that looks off. By the end of this page you’ll also understand why it works, so your books stay tidy without a bookkeeper on retainer.

When to use this

• It’s month-end and you need to reconcile your business spending.
• Tax season is coming and your expenses are scattered across cards and apps.
• You exported a CSV from your bank or Stripe and need it sorted into categories.
• You want to spot personal charges that snuck onto the business card before your accountant does.
• You’re setting up clean books for the first time and want a repeatable system.

The prompt

Copy this whole block into ChatGPT, Claude, or Gemini:

You are a meticulous bookkeeper who specializes in small coaching businesses. Your job is to categorize a month of raw expense transactions into clean, tax-ready categories and flag anything that needs my attention.

Before you start, ask me up to 3 clarifying questions if anything below is unclear or ambiguous. Otherwise, proceed.

CONTEXT
- My business: {{BUSINESS_TYPE}}
- My country / tax system: {{COUNTRY}}
- The categories I use: {{CATEGORIES}}
- The period I'm reconciling: {{MONTH}}
- My raw transactions (date, merchant, amount): {{TRANSACTIONS}}

TASK
1. Assign every transaction to exactly one of my categories. If a transaction doesn't fit, place it in 'Other' and flag it.
2. Return a table with columns: Date, Merchant, Amount, Category, Note.
3. After the table, give me a category summary with a subtotal for each category and a grand total.
4. List any transactions you were unsure about under a 'Needs review' heading, with a one-line reason (e.g. possible personal expense, missing detail, looks like a duplicate).
5. Note any likely tax-deductible items that I should confirm with my accountant.

CONSTRAINTS
- Do not invent transactions, amounts, or merchants. Only use what I provide.
- Do not give definitive tax or legal advice; phrase deductibility as something to confirm.
- Keep currency formatting consistent with my input.
- If amounts don't add up or a line is malformed, say so rather than guessing.

After the summary, suggest 2 small habits that would make next month's bookkeeping faster.

How to customize it

Replace the five {{VARIABLES}} before you send it:

The easiest way to fill {{TRANSACTIONS}} is to export a CSV from your bank or Stripe and paste it straight in. The model reads messy bank descriptions fine.

See it in action (full example)

Here is the exact prompt, filled in for a health coach reconciling May. This is the whole input, nothing hidden:

You are a meticulous bookkeeper who specializes in small coaching businesses. Your job is to categorize a month of raw expense transactions into clean, tax-ready categories and flag anything that needs my attention.

Before you start, ask me up to 3 clarifying questions if anything below is unclear or ambiguous. Otherwise, proceed.

CONTEXT
- My business: solo health coaching LLC, cash-basis
- My country / tax system: United States (Schedule C sole proprietor)
- The categories I use: Software, Education, Marketing, Travel, Meals, Office, Fees, Contractors, Other
- The period I'm reconciling: May 2026
- My raw transactions (date, merchant, amount): 2026-05-03 ZOOM.US 14.99; 2026-05-05 CANVA PRO 12.99; 2026-05-08 META ADS 75.00; 2026-05-09 STARBUCKS 6.40; 2026-05-11 AMAZON OFFICE CHAIR 189.00; 2026-05-14 KAJABI 119.00; 2026-05-16 UDEMY COURSE 49.99; 2026-05-18 UNITED AIRLINES 312.40; 2026-05-18 UNITED AIRLINES 312.40; 2026-05-22 STRIPE FEE 18.75; 2026-05-25 PANERA LUNCH (client) 31.80; 2026-05-28 NETFLIX 15.49; 2026-05-30 UPWORK VA 200.00

TASK
1. Assign every transaction to exactly one of my categories. If a transaction doesn't fit, place it in 'Other' and flag it.
2. Return a table with columns: Date, Merchant, Amount, Category, Note.
3. After the table, give me a category summary with a subtotal for each category and a grand total.
4. List any transactions you were unsure about under a 'Needs review' heading, with a one-line reason (e.g. possible personal expense, missing detail, looks like a duplicate).
5. Note any likely tax-deductible items that I should confirm with my accountant.

CONSTRAINTS
- Do not invent transactions, amounts, or merchants. Only use what I provide.
- Do not give definitive tax or legal advice; phrase deductibility as something to confirm.
- Keep currency formatting consistent with my input.
- If amounts don't add up or a line is malformed, say so rather than guessing.

After the summary, suggest 2 small habits that would make next month's bookkeeping faster.

And here is the complete output the model returns:

Here is your categorized expense report for May 2026.

Date	Merchant	Amount	Category	Note
2026-05-03	ZOOM.US	$14.99	Software	Video calls with clients
2026-05-05	CANVA PRO	$12.99	Software	Design tool
2026-05-08	META ADS	$75.00	Marketing	Facebook/Instagram ads
2026-05-09	STARBUCKS	$6.40	Meals	Solo coffee, see Needs review
2026-05-11	AMAZON OFFICE CHAIR	$189.00	Office	Furniture/equipment
2026-05-14	KAJABI	$119.00	Software	Course/membership platform
2026-05-16	UDEMY COURSE	$49.99	Education	Professional development
2026-05-18	UNITED AIRLINES	$312.40	Travel	Flight
2026-05-18	UNITED AIRLINES	$312.40	Travel	Flight, see Needs review (possible duplicate)
2026-05-22	STRIPE FEE	$18.75	Fees	Payment processing
2026-05-25	PANERA LUNCH (client)	$31.80	Meals	Client meal
2026-05-28	NETFLIX	$15.49	Other	Likely personal, see Needs review
2026-05-30	UPWORK VA	$200.00	Contractors	Virtual assistant

Category summary

Category	Subtotal
Software	$146.98
Marketing	$75.00
Meals	$38.20
Office	$189.00
Education	$49.99
Travel	$624.80
Fees	$18.75
Contractors	$200.00
Other	$15.49
Grand total	$1,358.21

Needs review – 2026-05-18 UNITED AIRLINES $312.40 (x2): two identical charges on the same day. Confirm whether this is a real second ticket or a duplicate to remove. – 2026-05-28 NETFLIX $15.49: streaming subscriptions are usually personal. Confirm whether this is genuinely a business expense before keeping it. – 2026-05-09 STARBUCKS $6.40: a solo coffee is generally not deductible. Keep only if it was a documented client meeting.

Likely deductible (confirm with your accountant) – Software, Marketing, Education, Fees, and Contractors are typically ordinary and necessary business expenses for a coaching practice. – Travel and client Meals are often deductible but have specific documentation rules (Meals are commonly limited to 50%). Keep receipts and note the business purpose. – The Office chair may need to be tracked as equipment depending on cost rules. Ask your accountant.

2 habits for faster bookkeeping next month 1. Tag the business purpose at the moment of purchase, e.g. add “(client lunch – Dana)” in your banking app’s note field. Future-you won’t have to guess. 2. Keep one dedicated business card so personal charges like Netflix never land in this report in the first place.

That report took the model under a minute. You scan the Needs review list, delete the duplicate flight if it’s an error, move Netflix to personal, and your books are done.

Why this works

Three LLM principles are doing the heavy lifting here. Learn them and every prompt you write gets sharper:

1. Role priming. Opening with “You are a meticulous bookkeeper who specializes in small coaching businesses” tells the model which behavior to adopt: careful, conservative, detail-oriented. A bare “sort these expenses” pulls a generic answer. Naming the role pulls the cautious, double-checking mindset you actually want around money.
2. Constraints as quality control. The “do not invent transactions” and “if amounts don’t add up, say so rather than guessing” lines are the most important part of a finance prompt. Language models are wired to be helpful, which can mean fabricating a plausible number to fill a gap. Explicitly forbidding that, and the “do not give definitive tax advice” guardrail, turns a confident guesser into a careful assistant. Telling the model what NOT to do is as powerful as telling it what to do.
3. Structure in, structure out, plus a clarifying check. Asking for specific table columns and a category summary forces a clean, reusable format instead of a wall of prose. And the “ask me up to 3 clarifying questions first” line lets the model surface ambiguity (cash vs accrual, which currency, an unclear merchant) by asking instead of guessing, which is the single biggest fix for sloppy AI output.

Do this now

1. Export this month’s transactions from your bank or Stripe as a CSV.
2. Copy the prompt above into ChatGPT or Claude and paste your transactions into {{TRANSACTIONS}}.
3. Fill in your business type, country, categories, and month, then send it.
4. Work the Needs review list, fix the flagged lines, and save the table to your records. You’re reconciled.

Pro tips

• Keep a stable category list. Reuse the exact same {{CATEGORIES}} every month so your year-end totals add up cleanly across all twelve reports.
• Run it on a rolling basis. A 10-minute monthly pass beats a 6-hour scramble in April. Make it the first thing you do each month-end.
• Never paste full card numbers. The merchant, date, and amount are all the model needs. Strip account numbers before you paste.
• Always treat deductibility flags as a checklist for your accountant, not a final answer. The prompt is built to suggest, not to advise.

Related

• Invoice & Payment Reminder Message Kit for Coaches
• Coaching Package Pricing & Profitability Calculator (Custom GPT)
• Zapier & Make Automation Blueprint for Coaches
• End-of-Day Coaching Shutdown Checklist