Coding · Spreadsheets

Build a Simple Budget Tracker Spreadsheet

Get a step-by-step plan and formulas to build your own monthly budget sheet from an empty file.

Prompt Code output

Help me build a monthly budget tracker in [SPREADSHEET_APP], starting from a blank file. My main spending categories are: [CATEGORIES]. My currency is [CURRENCY]. Guide me one step at a time: what to type in which cells for the headings, how to set up a table where I add each expense, and the formulas that add up spending per category and show what is left of my income. Tell me exactly which cell each formula goes in. Add a simple way to highlight a category in red when I go over budget, and explain how to set that up through the menus. Keep the language simple and avoid technical words unless you explain them.

Fill in the brackets

[SPREADSHEET_APP]
Excel or Google Sheets
[CATEGORIES]
e.g. rent, groceries, transport, phone, eating out, savings
[CURRENCY]
e.g. EUR, GBP, AED, MAD

How to use

  1. Copy the prompt.
  2. Replace the text inside [BRACKETS] with your own details.
  3. Paste it into ChatGPT or another AI assistant.
  4. Read the result and ask for changes if needed.

Tip: Follow the steps in order and ask a follow-up question whenever a step does not look the same on your screen.