Charleston AI Playbook

Directory / Prompts / Finance & bookkeeping

Weekly cash note

Updated

Problem it solves

You know the week felt expensive. You need it in three numbers and the decisions only you can make.

Best tool

  • ChatGPT (free chat)
  • Claude (free chat)
  • Gemini (free chat)
  • Copilot (free chat)

Paste a small table into the free chat. That is enough for one pass. Copilot inside Excel is paid with Microsoft 365. Do not connect a bookkeeping login, and do not paste a full customer list.

Copy-paste prompt

Write a one-page weekly cash note from these figures. Money in, money out, what is due in the next 7 days, and up to 3 decisions. Do not forecast beyond the numbers given. Do not give tax advice.

Period: [week]
Money in: [amount and source notes]
Money out: [amount and what it was]
Due in 7 days: [bills you listed]
Cash on hand, if you want it included: [amount or "leave out"]

Replace every [bracket]. If you cannot fill one, delete that line.

Example output

A usable draft repeats your figures, lists the bills you said are due, and phrases decisions as questions. It does not predict next month’s sales.

Tips

  • If a bill is not in the paste, it should not appear as due.
  • This is not a cash-flow model. It is a note for you.

Time saved

Estimate: the note is a few minutes after you have the figures. Getting the figures is the bookkeeping, and this prompt does not replace it.

How to use it

  1. Copy the prompt. Copy the prompt on this page into a free chat.
  2. Fill every bracket. Replace each [bracket] with a fact from your own notes. If you cannot fill one, delete that line instead of guessing.
  3. Edit before you use it. Read the draft against your notes. Delete any price, date, name, or promise you did not supply. You decide what gets sent.

Where this came from

  • Original to this library.