Shellway

Home / Prompts / Work and admin

Make a monthly expense report

Turn bank statement exports into a categorised summary.

Work and adminStep by step

The prompt

Read the CSV bank statements in ~/Documents/Statements for last month. Categorise each transaction (rent, food, travel, software, other), total each category and save the result as expenses-month.xlsx with a summary sheet.

How to use it

  1. Make sure Shellway is connected in ChatGPT, Claude or Cursor.
  2. Paste the prompt and change the folder names or paths to match your computer.
  3. Review the plan your AI shows before you confirm any changes.

Related prompts