🧠 AI Learning Hub

Hub › Lessons › Lesson 3

Lesson 3 · Freelance money adminAbout 15 minutes a month

Run a 15-minute monthly cash review with AI

Most freelancers know roughly what came in last month, but not what changed, what is still owed to them or what is due next. A short review once a month answers those questions before they become a surprise. This lesson gives you one prompt that turns last month's totals into a review you can read in two minutes, ending with one thing to do this week.

What you will be able to do: paste last month's category totals, balances, unpaid invoices and upcoming bills into one prompt, and get back a checked summary, the three biggest changes, what is due in the next 30 days and one question to act on.

Why this works (and where it does not)

AI assistants are quick at adding up a short list, comparing two months and writing a plain summary. They are not reliable as a source of numbers: a model can misread a figure, or invent a reason for a change that sounds right.

So the prompt does three things: it uses only the totals you paste, it shows every calculation so you can check it, and it writes [ASK: …] when it does not know why something changed. It also checks that your opening balance plus the month's net equals your closing balance. If it does not, a transaction is missing or counted twice, and you want to know that before you rely on the totals.

The 15 minutes, step by step

  1. Export last month's bank transactions (about 5 minutes). If you have not categorised them yet, use Lesson 1 first.
  2. Total each category. In a spreadsheet with categories in column C and amounts in column D, =SUMIF(C:C,"Software",D:D) gives the total for one category. Keep last month's totals too.
  3. Note your opening and closing bank balances, your unpaid invoices and any bills due in the next 30 days.
  4. Run the prompt below and check the arithmetic it shows.
  5. Answer the one question it ends with, and put the action in your calendar.

Before you start: protect your data

The monthly review prompt

Fill in each section. Write "none" where a section does not apply.

Copyable prompt
You are helping me do a 15-minute monthly money review for my freelance business.

Month being reviewed:
Review date:
Currency:
Opening bank balance (first day of the month):
Closing bank balance (last day of the month):

This month's totals by category (money in and money out):
[paste]

Last month's totals by category (or "none"):
[paste]

Unpaid invoices owed to me: number, amount, due date (or "none"):
[paste]

Bills I know are due in the next 30 days: what, amount, date (or "none"):
[paste]

My notes about anything unusual this month (or "none"):
[paste]

Write, in this order:
1. Summary: total money in, total money out, and net (money in minus money out). Show the arithmetic.
2. Balance check: does opening balance + net = closing balance? If not, show the difference and list what I should check (for example, transfers between my own accounts, or transactions missing from the totals).
3. Top 3 changes from last month, ranked by size in currency, as a table: Category | Last month | This month | Change. Under the table, give a reason for each change only if my notes contain one. Otherwise write [ASK: a short question for me].
4. Next 30 days: list unpaid invoices (mark any that are overdue at the review date, with the number of days) and known bills. Give a total for each list.
5. One question to act on this week: the single most useful action these numbers point to, as a yes/no question.

Rules:
- Use ONLY the numbers, dates and notes I pasted. Do not invent transactions, reasons or dates.
- Show every calculation, in the same currency.
- Do not give tax, investment or borrowing advice, and do not judge spending as good or bad.
- Keep the review under 250 words, not counting tables.

Worked example

We ran the prompt with Claude on 19 October 2026. The business, invoices and amounts are made up for illustration. Your results will differ by tool, model and input.

Input (illustrative)

Sample input
Month being reviewed: September 2026
Review date: 5 Oct 2026
Currency: SGD
Opening bank balance (first day of the month): 9,340
Closing bank balance (last day of the month): 13,206

This month's totals by category:
Money in: Client payments 6,200; Other income 120
Money out: Software & subscriptions 286; Equipment 1,450; Co-working 380; Transport 142; Meals with clients 96; Phone & internet 88; Bank fees 12

Last month's totals by category:
Money in: Client payments 4,800; Other income 150
Money out: Software & subscriptions 214; Equipment 0; Co-working 380; Transport 165; Meals with clients 58; Phone & internet 88; Bank fees 12

Unpaid invoices owed to me:
INV-2026-011, 900, due 20 Sep 2026
INV-2026-014, 2,100, due 15 Oct 2026

Bills I know are due in the next 30 days:
Phone & internet, 88, 12 Oct
Design software annual renewal, 420, 28 Oct
Co-working, 380, 1 Nov

My notes about anything unusual this month:
Bought a new monitor and drawing tablet (one-off). Bought a font licence, SGD 72, one-off.

Output (as returned)

1. Summary: September 2026

2. Balance check: 9,340 + 3,866 = 13,206, which matches your closing balance. No difference to investigate.

3. Top 3 changes from August

Top 3 changes, ranked by size. On a phone, scroll the table sideways.

CategoryLast monthThis monthChange
Equipment (out)SGD 0SGD 1,450+SGD 1,450
Client payments (in)SGD 4,800SGD 6,200+SGD 1,400
Software & subscriptions (out)SGD 214SGD 286+SGD 72

4. Next 30 days (from 5 Oct 2026)

5. One question to act on this week: INV-2026-011 (SGD 900) is 15 days overdue. Will you send a payment reminder for it this week?

What we checked: every total and the balance check were recalculated with a script and match; the top 3 changes are the three largest by amount; days overdue (20 Sep to 5 Oct) is 15; the reason for the higher client payments is asked, not invented; and the review is under 250 words, not counting the table. Always read the output before you act on it.

Need to write that reminder? Lesson 2 has a prompt for a polite overdue reminder.

Before you act on the review

  1. Check the balance line first. If opening + net does not equal closing, fix the totals before reading anything else.
  2. Answer every [ASK]. A short note now makes next month's comparison easier.
  3. Keep the review. Save it with the month in the title, so next month you can paste this month's totals as "last month".
  4. Pick one action, not five. The point is a habit you keep, not a perfect report.

Not tax, accounting or financial advice. This review describes your own numbers; it does not tell you how much tax to set aside or how to invest. For those decisions, check your tax authority or speak to a qualified adviser.

Useful variations

Next step

How we checked this lesson