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
- Export last month's bank transactions (about 5 minutes). If you have not categorised them yet, use Lesson 1 first.
- 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. - Note your opening and closing bank balances, your unpaid invoices and any bills due in the next 30 days.
- Run the prompt below and check the arithmetic it shows.
- Answer the one question it ends with, and put the action in your calendar.
Before you start: protect your data
- Paste category totals, not raw bank statements. Leave out account numbers and card numbers.
- Use client business names or invoice numbers only; there is no need for personal details.
- Check your AI tool's data settings, including whether chats may be used for training.
The monthly review prompt
Fill in each section. Write "none" where a section does not apply.
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)
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
- Money in: 6,200 + 120 = SGD 6,320
- Money out: 286 + 1,450 + 380 + 142 + 96 + 88 + 12 = SGD 2,454
- Net: 6,320 − 2,454 = SGD 3,866 (August: 4,950 − 917 = SGD 4,033)
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.
| Category | Last month | This month | Change |
|---|---|---|---|
| Equipment (out) | SGD 0 | SGD 1,450 | +SGD 1,450 |
| Client payments (in) | SGD 4,800 | SGD 6,200 | +SGD 1,400 |
| Software & subscriptions (out) | SGD 214 | SGD 286 | +SGD 72 |
- Equipment: your notes say this was a new monitor and drawing tablet, one-off.
- Client payments: [ASK: Which payments made September higher? Did any of it pay for August work that arrived late?]
- Software & subscriptions: your notes say a one-off font licence of SGD 72, which matches the change.
4. Next 30 days (from 5 Oct 2026)
- Unpaid invoices: INV-2026-011, SGD 900, due 20 Sep, overdue by 15 days; INV-2026-014, SGD 2,100, due 15 Oct. Total owed to you: 900 + 2,100 = SGD 3,000.
- Known bills: phone & internet SGD 88 (12 Oct), design software renewal SGD 420 (28 Oct), co-working SGD 380 (1 Nov). Total: 88 + 420 + 380 = SGD 888.
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
- Check the balance line first. If opening + net does not equal closing, fix the totals before reading anything else.
- Answer every
[ASK]. A short note now makes next month's comparison easier. - Keep the review. Save it with the month in the title, so next month you can paste this month's totals as "last month".
- 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
- Quarterly view: paste three months of totals and add "Show each category for all three months and the average."
- Several accounts: list each account's opening and closing balance and add "Do the balance check for each account and for the total."
- First month, no history: write "none" for last month. The prompt then skips the comparison and still gives you the summary, balance check and next 30 days.
Next step
Keep the monthly numbers in one place
The review is quicker when your totals are already grouped by month. The Notion Finance Dashboard product page lists an income and expense tracker, a monthly budget planner and a 6-month cash flow forecast. The page shows what is included, the requirements and the price.
See what's inside the Finance DashboardMore lessons
Earlier this week: categorise your bank transactions and write a clear invoice and reminder. Next: build a tax set-aside habit with AI.
All lessonsHow we checked this lesson
- Prompt run with Claude on 19 Oct 2026 using the illustrative input above. The output is shown as returned. We recalculated every total, the balance check, the ranking of changes and the days overdue with a script.
- The
SUMIFformula uses the standard syntax supported by Google Sheets, Microsoft Excel and Apple Numbers: range, criterion, sum range. - The prompt relies on no product-specific features. Any general AI chat assistant should handle it, but we have only tested it with Claude.
- Last reviewed: 19 October 2026.