More in Spreadsheets & money data.
Build a monthly expense tracker spreadsheet from one line with Claude
WorkedEvidence: Screenshots or logsPosted Last checked
One line to Claude got Amanda Caswell a categorized expense tracker with a summary and working total formulas in about 90 seconds.
Beginner-friendlyNo logins, payments or coding needed. Low risk: paste the prompt and you should get something useful.
How to use this
- Tap Copy prompt.
- Open Claude.
- Paste it into the message box.
- Replace anything in [CAPITAL LETTERS IN BRACKETS] with your own details.
- Send it, then read the answer before acting on it.
New to this? What's a prompt?
A prompt is the message you send to the AI tool. Copy the one on this page, put your own details where it asks, and read the answer before you act on it.
Prompt
Improved prompt
Our fuller version of the source's prompt, with fill-in details and rules, or one written to avoid what went wrong. Not tested by the poster.
Our fuller version of the person's prompt. They didn't use this version, and we haven't tested it.
Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish. Goal: Build a monthly expense tracker spreadsheet I can start filling in today. Questions to ask me first: - What spending categories do you use? - Do you want a budget-versus-actual comparison? - Will you use Excel or Google Sheets? Inputs (fill in or confirm): - My categories: [e.g., HOUSING / FOOD / TRANSPORT / KIDS / FUN] - Monthly budget per category, if I have one: [BUDGETS] - App: [EXCEL / GOOGLE SHEETS] Rules: - One row per expense with date, description, category and amount; categories chosen from a drop-down. - A summary at the top with totals per category and budget versus actual, using formulas. - Highlight any category over budget. - Use a few sample rows marked SAMPLE that I can delete. Checkpoint: Show me the column layout and summary design before building the file. If you get stuck: If your tool can't create a file, give me the exact formulas and setup steps instead. Verify before you finish: Test the formulas with the sample rows and confirm the totals are right. Output: A downloadable spreadsheet plus a three-line how-to. Done when: I can type in an expense and see the category totals update.
Customize this prompt
Answer these questions and we'll put your answers into the prompt for you. You can leave any of them empty.
Your prompt
Before you start, ask me 1–3 short questions about the details below and wait for my answers. Once I've answered, confirm the plan in one line and run the whole task start to finish. Goal: Build a monthly expense tracker spreadsheet I can start filling in today. Questions to ask me first: - What spending categories do you use? - Do you want a budget-versus-actual comparison? - Will you use Excel or Google Sheets? Inputs (fill in or confirm): - My categories: [e.g., HOUSING / FOOD / TRANSPORT / KIDS / FUN] - Monthly budget per category, if I have one: [BUDGETS] - App: [EXCEL / GOOGLE SHEETS] Rules: - One row per expense with date, description, category and amount; categories chosen from a drop-down. - A summary at the top with totals per category and budget versus actual, using formulas. - Highlight any category over budget. - Use a few sample rows marked SAMPLE that I can delete. Checkpoint: Show me the column layout and summary design before building the file. If you get stuck: If your tool can't create a file, give me the exact formulas and setup steps instead. Verify before you finish: Test the formulas with the sample rows and confirm the totals are right. Output: A downloadable spreadsheet plus a three-line how-to. Done when: I can type in an expense and see the category totals update.
Scroll to see the whole prompt. Your answers show in green.
3 blanks are still empty: My categories; Monthly budget per category, if I have one; App. They'll stay in brackets in your prompt, so the chat tool may ask you about them.
What you type stays in this browser tab. We don't send it or save it, and it's gone when you leave the page. If you use a "Try this in" button, your answers go to that tool as part of the prompt.
Try this in:
This prompt has blanks to fill in, like [BUDGETS]. We'll copy it instead of filling it in, so you can edit it before you send.
The source used Claude. These are general chat tools, so results may differ.
Opens in a new tab. We don't see what you send.
These links are only a shortcut. We're not affiliated with OpenAI, Google, Anthropic or xAI, and your results may not match the source.
The prompt they actually used
The exact prompt from the source.
Build me a monthly expense tracker by category.
AI tool
Outcome
Tom's Guide AI editor Amanda Caswell tested Claude's built-in Skills with a one-line request: "Build me a monthly expense tracker by category." In about 90 seconds, Claude returned a spreadsheet with a clean, professional layout, expenses grouped by category, a summary section at the top and proper formulas for totals. Caswell says it was good enough to proudly send to a colleague, because the spreadsheet Skill already carried the formatting and structure rules that would normally have to be spelled out.
Evidence: Screenshots or logsThe source shows screenshots, a transcript or the AI's output.
Source
- Posted
- by Amanda Caswell (Tom's Guide)
- Last checked
- Method:
- How we verify
Context: This is a blank template test; no use with real expenses over time is reported. The article calls the prompt eleven words, but the quoted prompt is shorter. The prompt shown here is our fuller version of the one-line original, and we haven't tested it. The article contains affiliate links.
More in Spreadsheets & money data
Make a father's handwritten crop ledger, kept since 1971, searchable with ChatGPT
A farmer digitized a father's crop ledger, kept since 1971, so past planting dates and yields are searchable with ChatGPT.
WorkedChatGPTEvidence: Company case studyView CaseTurn a year of bank statements into a business expense spreadsheet with Claude Cowork
Claude Cowork turned a year of statements into a categorized expense spreadsheet; the poster fixed a handful of items by hand.
WorkedClaude CoworkEvidence: Described by posterView CaseBuild a credit risk scorecard in Excel with Claude in Excel
Claude in Excel built a polished 28-sheet credit scorecard but broke the brief's method and overstated accuracy: partial at best.
PartialClaude (Excel)Evidence: Shown on videoView CaseFind smarter buying patterns in office supply order history with Claude Code
Alex Hillman had Claude Code study Indy Hall's paper-goods order history to suggest buying patterns that avoid last-minute orders.
WorkedClaude CodeEvidence: Described by posterView CaseAnalyze seven years of credit card statements with Claude Cowork
Claude Cowork turned seven years of card statements into 5,726 categorized transactions, though it miscategorized some vendors.
WorkedClaude CoworkEvidence: Screenshots or logsPoster says:5,726 transactions categorized
View CaseSort a Google Sheet in a custom priority order with Claude in Chrome
Asked to sort a Google Sheet in a custom priority order, Claude in Chrome kept sorting it alphabetically instead, so it failed.
FailureClaude in ChromeEvidence: Screenshots or logsView Case
Similar cases
Log spending by chatting and keep a budget workbook updated with a Claude Project
Claude built an Excel budget workbook and logs spending from short typed notes, which the user says beat budgeting apps.
WorkedClaudeEvidence: Article or interviewView CaseBuild a weekly budget tracker in Google Sheets with Gemini
A guide to having Gemini build a Google Sheets budget table that updates as expenses are logged; no results reported.
WorkedGeminiEvidence: Article or interviewBeginner-friendlyView CaseSort 42 bank transactions into a budget with Gemini in Google Sheets
Gemini in Sheets sorted 42 sample transactions, showed $3,440.84 spent against a $2,830 budget and flagged a possible double charge.
WorkedGeminiEvidence: Article or interviewBeginner-friendlyView Case