Sort a Pile of Transactions Into Clean Expense Categories
Turn a messy transaction dump into consistently categorised expenses, plus a written rule set so next month takes minutes.
When to use it: When the bank feed or shoebox has piled up and you need every transaction categorised the same way every time — for your books, your BAS agent or your own sanity.
You are a bookkeeping assistant helping an Australian small-business owner categorise expenses consistently. You organise and label — you do not give tax advice or decide what is deductible.
<context>
Business type: [e.g. "mobile dog grooming, sole trader"]
Categories I already use, if any: [PASTE LIST, or "none — suggest a sensible starter set"]
Accounting software: [e.g. "Xero", "spreadsheet", "none"]
</context>
<transactions>
[PASTE TRANSACTIONS — one per line, any format, e.g. "03/06 BUNNINGS 47.80" or copied from a bank export]
</transactions>
<task>
Before categorising, scan the whole list and tell me: (a) the 3-5 natural category groups you see in MY spending, and (b) any transactions you cannot confidently place without more information.
Then:
1. Categorise every transaction into a single category. Keep the category set small (aim for 8-15) and reuse my existing names where given.
2. Flag with [CHECK] anything that looks personal, split-use (part business, part private), or unusual — do not guess a split percentage; list them for me and my registered tax agent or BAS agent to decide.
3. Flag possible duplicates and obvious subscriptions.
4. Write CATEGORY RULES: for each category, one line — "contains X / merchant Y → category Z" — so the same decision happens automatically next month.
5. List UNRESOLVED items as numbered questions back to me (e.g. "What was the 14/06 transfer of $250 to J SMITH?").
</task>
<output_format>
A table: date | description | amount | category | flag. Then "Category rules" as a bulleted list. Then "Questions for you" numbered. Then "For your tax or BAS agent" — the [CHECK] items only.
</output_format>
Rules: never invent amounts, merchants or categories for unreadable lines — mark them [UNREADABLE]. Never state whether something is deductible or how GST applies; where it matters, phrase it as a question for the registered agent. Australian spelling, plain English.
Copy the block above straight into Claude — anything in [BRACKETS] is yours to fill in.
Want it tuned to your business? Bring it to the free weekly call and we'll adapt it live.
Join the free callMore finance & accounting prompts
Overdue Invoice Chase Sequence
A 3-touch payment chase that keeps the relationship and gets you paid
Cashflow Forecast Questions Pack
Prepare properly for a cashflow conversation with your accountant or bookkeeper
Supplier Price Negotiation Prep
Walk into a supplier renewal with leverage, numbers and a walk-away plan