Claude for Money Spreadsheets & Analysis

Claude has a particular strength that makes it the best AI tool for crunching your money numbers: it is unusually good at building spreadsheets, reading documents you upload, and walking through math step by step without making errors. If ChatGPT is your money coach, Claude is your money accountant.

In this lesson, you will use Claude to build a real personal budget spreadsheet, audit a credit card statement, and analyze a job offer — all without opening Excel.

What You'll Learn

• How to upload PDFs and statements to Claude
• A prompt that builds a complete budget spreadsheet for you
• How to use Claude to compare two financial decisions side by side
• The "show me the math" pattern that prevents AI errors

Setting Up Claude

Open claude.ai and sign in with the free account you created in Lesson 2. The free tier (Sonnet) is excellent for everything in this lesson.

A few quick interface notes:

• The paperclip icon (or "Attach files") lets you upload PDFs, images, and CSV files
• You can paste long text directly into the chat — Claude handles long documents well
• Use the "New conversation" button to start fresh when you switch topics; it keeps your context tidy

Building Your First Budget Spreadsheet

Paste this into Claude:

Act as my personal finance accountant. Build me a clean monthly budget spreadsheet I can copy into Google Sheets. I have a take-home income of $4,000/month. My fixed expenses are: rent $1,400, utilities $120, internet $60, phone $50, car insurance $130, gym $30. My variable expenses last month were: groceries $420, eating out $180, gas $90, entertainment $80, shopping $200. My goals are: build emergency fund to $5,000 over 6 months, pay off $3,000 credit card at 22% APR. Output the spreadsheet as a markdown table with columns: Category, Type (Fixed/Variable/Savings/Debt), Amount, % of income. Also tell me my current savings rate and what it would need to be to hit my goals.

Claude will produce a clean, structured table — the kind that takes a human 30 minutes to build. Copy the markdown table directly into a Google Sheets cell or use ChatGPT to convert it to CSV if you prefer.

Now follow up with:

Now make me a "stretch" version of the same budget where I aim to save 25% of my income. Show me what would have to change.

You now have two budget options side by side. That is the kind of analysis a financial planner charges $200 to put together.

Uploading and Analyzing Statements

Claude can read documents you upload. This is genuinely powerful for personal finance.

Use case 1: Credit card statement audit.

Download a recent credit card statement as a PDF. Drag it into Claude. Then ask:

I am uploading my last credit card statement. Tell me: (1) my total spending, (2) the top 5 categories of spending, (3) any subscription or recurring charges I might want to review, (4) any fees that look unusual, and (5) one observation about my spending patterns I might not notice myself.

You will be surprised what Claude catches — duplicate streaming subscriptions, the $9.99/month service you forgot about, the fact that 40% of your "groceries" is actually convenience-store snack runs.

Use case 2: Lease or contract review.

Upload a lease, gym contract, or terms-of-service document. Ask:

Read this contract and act as a careful tenant advocate. List: (1) the most important obligations on me, (2) any unusual or aggressive clauses, (3) hidden costs I might face, and (4) five questions I should ask the landlord before signing.

You should still have a human read important contracts, but Claude is a fantastic first-pass reviewer.

Privacy note: Claude states that consumer chats are not used to train models by default. Still, redact your full name, address, and account numbers before uploading. Most contracts are fine without those identifiers; the legal language is what you actually want analyzed.

Comparing Two Decisions Side by Side

A skill that pays off forever: putting two options on a table.

Try this prompt:

Help me compare two job offers in a markdown table. Offer A: $72,000 base, 5% bonus target, 4% 401(k) match, $250/month commuter cost, 100% in-office in San Francisco. Offer B: $78,000 base, no bonus, 3% 401(k) match, fully remote, no commute, but health insurance costs $300/month more. Build a table of monthly cash impact, then a table of 5-year wealth impact assuming I invest the difference at 7%. Then recommend with reasoning.

You will get a clean comparison and a math-backed recommendation. The second table — the 5-year wealth impact — is what most people forget to calculate, and it often flips the decision.

Other side-by-side prompts to try:

• "Compare paying off my $10,000 student loan at 6% APR vs investing that money in an S&P 500 index fund over 10 years."
• "Compare buying a $25,000 used car cash vs taking a 5-year auto loan at 7% APR and investing the cash in a HYSA at 4.5% APY."
• "Compare a Traditional IRA vs Roth IRA for me at age 25 in the US, assuming I expect to retire in a higher tax bracket."

The 'Show Me the Math' Pattern

The single most useful follow-up prompt for Claude is:

Show me the math for that step by step. Use a small table if helpful.

Claude is great at math but sometimes glosses over a step, and that is where errors hide. Asking it to show its work serves two purposes: you catch any errors, and you actually learn the calculation.

Example: if Claude says "your debt costs $880/year in interest," ask:

Show me how you got $880. Walk through: balance, APR, monthly interest, annual interest. Are there any assumptions about minimum payments?

You will see things like "I assumed you carry the full balance every month with no payments" — which may or may not match your reality. Adjust and re-ask.

Building a Reusable Budget Template

Once you have a budget you like, save the prompt that built it. Each month you can re-run:

Here is my updated income and spending for [month]. Rebuild my budget table using the same categories and structure as last month, and tell me what changed.

That is a one-prompt monthly review. Combined with ChatGPT's monthly check-in prompt from the last lesson, you have a sustainable system.

When Claude Says "I Am Not Sure"

One thing you will notice with Claude: it is more likely than ChatGPT to say "I am uncertain" or "I would verify this with [source]." Treat that as a feature, not a bug. When Claude hedges, it usually means the question is genuinely ambiguous or the data could be out of date. Use Perplexity (next lesson) to confirm the live numbers.

Important Reminder

Claude is excellent at math, but it is still a language model, not a real accountant. For:

• Tax filing (use TurboTax, FreeTaxUSA, your country's equivalent, or a CPA)
• Major investment moves (use a licensed advisor)
• Anything legally binding (use a licensed lawyer)

Use Claude to prepare for those conversations, not replace them.

Key Takeaways

• Claude excels at building spreadsheets, reading uploaded documents, and step-by-step math.
• A single prompt can produce a complete monthly budget table you can copy into Google Sheets.
• Upload credit card statements, leases, and contracts for a careful first-pass review.
• For any decision with two paths, ask Claude to build a side-by-side table — including 5-year impact, not just monthly cash.
• The "show me the math step by step" follow-up catches errors and teaches you the calculation.
• Redact sensitive identifiers (name, address, account numbers) before uploading documents.