🧠 AI Learning Hub

Hub › Lessons › Lesson 1

Lesson 1 · Freelance money adminAbout 15 minutes

Categorise a month of bank transactions with one AI prompt

Sorting a bank export line by line is slow, and it is easy to forget what a payment was for. An AI assistant can do the first pass in seconds. You then spend your time only on the rows that need a human decision.

What you will be able to do: paste a bank-export CSV into an AI assistant and get back a table of transactions, each with a category, a confidence level and a "check me" flag, plus totals per category.

Why AI transaction categorization works (and where it does not)

AI models are good at reading messy bank descriptions such as ADOBE *CREATIVE CLOUD and recognising what they probably are. They cannot know your intentions. A coffee could be a client meeting or your weekend. A purchase from an online store could be a printer cartridge or a birthday present. Only you know.

So this prompt does two jobs. It categorises what is obvious, and it flags what is not so you decide those yourself. The aim is to save time on routine rows, not to hand your bookkeeping to a model.

Before you start: protect your data

The prompt

Copy this, edit the category list to match how you actually report your business, then paste your CSV rows at the end.

Copyable prompt
You are helping me categorise my business transactions.

Use ONLY these categories:
- Income – Client work
- Income – Product sales
- Software & subscriptions
- Travel & transport
- Meals
- Office supplies & equipment
- Transfer (not income or expense)
- Personal / not business
- Uncategorised

For each row of the CSV below, return a table with these columns:
Date | Description | Amount | Category | Confidence (High/Medium/Low) | Check me? (Yes/No) | Reason (max 8 words)

Rules:
1. Copy Date, Description and Amount exactly. Never change amounts, never add or drop rows.
2. If you are not sure, use "Uncategorised", set Confidence to Low and Check me to Yes.
3. Set Check me to Yes for anything that could be either personal or business (for example meals, online shopping, fuel, ride-hailing) and for every transfer.
4. Do not guess what a purchase was. Say what information is missing instead.

After the table, give:
- the total amount per category
- the number of rows marked "Check me"
- a one-line reminder that I must confirm the flagged rows myself.

CSV:
[paste your Date,Description,Amount rows here]

Worked example

We ran the prompt above with Claude on 17 October 2026, using the 10 made-up transactions below. The data is illustrative, not from a real account. Your results will differ by tool, model and data.

Input (illustrative CSV)

Sample data
Date,Description,Amount
2026-09-01,STRIPE PAYOUT,1250.00
2026-09-02,ADOBE *CREATIVE CLOUD,-59.99
2026-09-03,GRAB *TRIP 8842,-14.20
2026-09-05,NOTION LABS,-12.00
2026-09-08,WISE TRANSFER CLIENT ACME,2400.00
2026-09-09,STARBUCKS 0231,-6.80
2026-09-12,AMZN MKTP US,-89.45
2026-09-15,GOOGLE *WORKSPACE,-8.40
2026-09-18,TRANSFER TO SAVINGS,-500.00
2026-09-21,SHELL 1123,-62.30

Output

AI output for the sample data. Highlighted rows were flagged "Check me". On a phone, scroll the table sideways.

DateDescriptionAmountCategoryConfidenceCheck me?Reason
2026-09-01STRIPE PAYOUT1250.00Income – Product salesMediumYesPayout could be clients or products
2026-09-02ADOBE *CREATIVE CLOUD-59.99Software & subscriptionsHighNoDesign software subscription
2026-09-03GRAB *TRIP 8842-14.20Travel & transportMediumYesRide could be personal
2026-09-05NOTION LABS-12.00Software & subscriptionsHighNoProductivity app subscription
2026-09-08WISE TRANSFER CLIENT ACME2400.00Income – Client workHighNoDescription names a client
2026-09-09STARBUCKS 0231-6.80MealsLowYesBusiness purpose unknown
2026-09-12AMZN MKTP US-89.45UncategorisedLowYesItem unknown; check the receipt
2026-09-15GOOGLE *WORKSPACE-8.40Software & subscriptionsHighNoEmail and office suite
2026-09-18TRANSFER TO SAVINGS-500.00Transfer (not income or expense)HighYesOwn-account move, not spending
2026-09-21SHELL 1123-62.30Travel & transportMediumYesFuel may be personal use

Totals per category (we re-added these by hand: they match)

CategoryTotal
Income – Client work2400.00
Income – Product sales1250.00
Software & subscriptions-80.39
Travel & transport-76.50
Meals-6.80
Uncategorised-89.45
Transfer (not income or expense)-500.00

Rows marked "Check me": 6 of 10. That is a lot for a small sample, and it is deliberate: the prompt is cautious. On a typical month, most subscriptions and clearly named client payments will come back as High confidence and need only a glance.

Your 10-minute review

  1. Check the row count. The output should have exactly as many rows as your CSV. If not, ask: "You returned N rows but my CSV has M. List the missing rows."
  2. Spot-check three amounts against your bank statement.
  3. Decide every flagged row yourself. Look up receipts for "Uncategorised" items.
  4. Re-add one total (a calculator is fine). AI tools can make arithmetic mistakes.
  5. Save the final categories in your own record: a spreadsheet, your accounting tool or a Notion tracker.

Not tax or accounting advice. Which expenses are deductible, and how to treat mixed personal and business costs, depends on where you live and your situation. Use your tax authority's guidance or an accountant for those decisions.

Useful variations

Next step

How we checked this lesson