Creating Financial Reports with GPT - AI Household Analysis Complete Guide

Introduction

So far, we've used Claude to organize expense records, categorize items, and get analyses. Pretty convenient, right? But there's one drawback. While conversations with Claude are saved, starting a new conversation requires re-entering previous data.

"I want to compare 3 months of data, how?" "I want to see monthly trends in a chart..." If you've had these concerns, now try integrating Claude's generated data with Excel or Google Sheets!

The benefits of Excel integration are clear. First, data accumulates. Add Claude's monthly organized data to your spreadsheet, and you'll build up 1-2 years of data. Second, you can easily create charts. View monthly expense trends as line graphs and category proportions as pie charts at a glance. Third, automatic calculations are possible. Using Excel formulas, averages, totals, and ratios calculate automatically!

Combining Claude's smart analysis with Excel's powerful data management creates a professional-level budget system!

Transferring AI Budget to Excel

Real Example 1: Creating Basic Tables

My input:

Organize March expenses in a format I can paste into Excel.

March expenses:
03/01 Starbucks 6,500 won
03/02 GS25 12,300 won
03/05 E-Mart 89,000 won
03/07 Baemin 22,000 won
03/10 Kakao Taxi 8,500 won

Claude's response:

Excel copy format (tab-separated):

Date	Merchant	Category	Amount
2025-03-01	Starbucks	Food(Café)	6500
2025-03-02	GS25	Food(Convenience)	12300
2025-03-05	E-Mart	Food(Grocery)	89000
2025-03-07	Baemin	Food(Delivery)	22000
2025-03-10	Kakao Taxi	Transportation	8500

How to use:

1. Select all above (Ctrl+A → Ctrl+C)
2. Open Excel
3. Paste in A1 cell (Ctrl+V)
4. Columns automatically separated!

---

CSV file format (better compatibility):

Date,Merchant,Category,Amount
2025-03-01,Starbucks,Food(Café),6500
2025-03-02,GS25,Food(Convenience),12300
2025-03-05,E-Mart,Food(Grocery),89000
2025-03-07,Baemin,Food(Delivery),22000
2025-03-10,Kakao Taxi,Transportation,8500

How to use:

1. Copy above into Notepad
2. Save as "Budget_2025_03.csv"
3. Open file in Excel
4. Automatically converts to table format!

---

💡 Tip: Want commas in amounts?

After pasting in Excel:

1. Select entire amount column
2. Right-click → "Format Cells"
3. Select "Number" → "Currency"
4. Automatically changes to 6,500 won format!

Real Example 2: Excel Template for Monthly Reports

My input:

Create March budget data as an Excel template.

Income:
- Salary: 3,200,000 won
- Side income: 150,000 won

Expenses:
- Fixed expenses: 1,090,000 won
- Food: 555,000 won
- Transportation: 120,000 won
- Shopping: 145,000 won

Savings: 800,000 won

Also tell me Excel formulas.

Claude's response:

---

📊 Excel Budget Template

Sheet 1: Monthly Summary

Column A: Item | Column B: Amount | Column C: Ratio

A	B	C
Monthly Budget Summary (March 2025)

[Income]
Salary	3200000	=B4/B8
Side income	150000	=B5/B8
Taxes/insurance	0
Total income	=SUM(B4:B6)	100%

[Expenses]
Fixed expenses	1090000	=B11/B18
Food	555000	=B12/B18
Transportation	120000	=B13/B18
Shopping	145000	=B14/B18
Entertainment	0	=B15/B18
Other	0	=B16/B18
Savings	800000	=B17/B18
Total expenses	=SUM(B11:B17)	100%

[Results]
Income	=B8
Expenses	=B18
Net savings	=B21-B22
Savings rate	=B23/B21

How to use:

1. Copy above starting from Excel A1
2. Column C formulas auto-calculate
3. Just enter numbers in column B!

---

Sheet 2: Daily Expense Records

Column A: Date | B: Category | C: Merchant | D: Amount | E: Notes

Date	Category	Merchant	Amount	Notes
2025-03-01	Food	Starbucks	6500	Americano
2025-03-02	Food	GS25	12300	Snacks
2025-03-05	Food	E-Mart	89000	Groceries
...	...	...	...	...

[Totals]
Food			=SUMIF(B:B,"Food",D:D)
Transportation			=SUMIF(B:B,"Transportation",D:D)
Shopping			=SUMIF(B:B,"Shopping",D:D)
Grand total			=SUM(D2:D100)

SUMIF formula explanation:

• =SUMIF(B:B,"Food",D:D)
• Find "Food" in column B, sum corresponding column D amounts

---

Sheet 3: Monthly Trends (3 months)

Column A: Item | B: January | C: February | D: March | E: Average

Item	January	February	March	Average	Change
Total income	3200000	3200000	3350000	=AVERAGE(B2:D2)	=D2-C2
Total expenses	2600000	2650000	2905000	=AVERAGE(B3:D3)	=D3-C3
Savings	600000	550000	800000	=AVERAGE(B4:D4)	=D4-C4

Food	520000	528000	555000	=AVERAGE(B6:D6)	=D6-C6
Transportation	115000	111000	120000	=AVERAGE(B7:D7)	=D7-C7
Shopping	180000	165000	145000	=AVERAGE(B8:D8)	=D8-C8

Change analysis:

• Column E: Month-over-month change
• Positive = increase (red)
• Negative = decrease (blue)

Conditional formatting:

1. Select entire column E
2. "Home" → "Conditional Formatting" → "Color Scale"
3. Red (high) - White (medium) - Blue (low)

---

Sheet 4: Chart Data

Category expense (for pie chart):

Category	Amount
Fixed expenses	1090000
Food	555000
Transportation	120000
Shopping	145000
Savings	800000
Other	195000

Creating chart:

1. Select entire table
2. "Insert" → "Chart" → "Pie"
3. Auto-generates ratio chart!

Monthly trends (for line graph):

Month	Income	Expenses	Savings
January	3200000	2600000	600000
February	3200000	2650000	550000
March	3350000	2905000	800000

Creating chart:

1. Select entire table
2. "Insert" → "Chart" → "Line"
3. See 3-month trend at a glance!

---

💡 Useful Excel Formula Collection

1. Budget vs. Actual:

=IF(Actual>Budget, "Over", "Good")

Example:

A	B	C	D
Category	Budget	Actual	Assessment
Food	500000	555000	=IF(C2>B2,"Over","Good")

2. Savings rate calculation:

=Savings/Total income*100

Example:

Savings	800000
Total income	3350000
Savings rate	=B1/B2*100	→ 23.9%

3. Category percentage:

=Individual amount/Total expenses*100

Example:

Food	555000
Total expenses	2905000
Percentage	=B1/B2*100	→ 19.1%

4. Month-over-month change rate:

=(This month-Last month)/Last month*100

Example:

	February	March	Change rate
Food	528000	555000	=((C2-B2)/B2)*100	→ +5.1%

---

Real Example 3: Google Sheets Integration

My input:

I want to create a budget with Google Sheets.
Tell me how to get data organized by Claude monthly
and automatically add it to the spreadsheet.

Claude's response:

---

📱 Creating Google Sheets Budget

Step 1: Create Basic Spreadsheet

Access Google Sheets:

1. Go to Google Drive
2. "New" → "Google Sheets"
3. Name: "2025 Budget"

Sheet structure:

• Sheet1: Raw Data
• Sheet2: Monthly Summary
• Sheet3: Category Analysis
• Sheet4: Charts

---

Step 2: Request Data from Claude

Prompt:

Organize March expenses in TSV format for Google Sheets.
Include header in first row.

[Expense records]

Claude response (example):

Date	Category	Merchant	Amount	Notes
2025-03-01	Food	Starbucks	6500
2025-03-02	Food	GS25	12300
2025-03-05	Food	E-Mart	89000	Groceries

Paste:

1. Copy all
2. Paste in spreadsheet A1 cell
3. Columns auto-separated!

---

Step 3: Set Up Auto Formulas

Sheet2 (Monthly Summary) automation:

Column A: Category
Column B: March Amount
Column C: Auto-calculation formula

Category	Amount
Food	=SUMIF(Sheet1!B:B,"Food",Sheet1!D:D)
Transportation	=SUMIF(Sheet1!B:B,"Transportation",Sheet1!D:D)
Shopping	=SUMIF(Sheet1!B:B,"Shopping",Sheet1!D:D)
Grand total	=SUM(B2:B10)

Advantage:

• Just add data to Sheet1
• Sheet2 auto-updates!

---

Step 4: Auto-Update Charts

Pie chart:

1. Select category amount table in Sheet2
2. "Insert" → "Chart"
3. Select "Pie chart"
4. Auto-reflects when adding data to Sheet1!

Line graph (monthly trends):

1. Prepare monthly data in Sheet3
2. "Insert" → "Chart" → "Line"
3. Range: Set auto-expand

---

Step 5: Check on Mobile

Google Sheets app:

1. Download "Google Sheets" from Play Store/App Store
2. Log in with Google account
3. Open "2025 Budget" file
4. Check/edit anytime, anywhere!

Real-time sync:

• Edit on PC → Immediately reflects on smartphone
• Record expenses on smartphone → Check on PC

---

Real Example 4: Advanced Automation

My input:

I want to create a routine where I request a monthly report from Claude
at the end of each month and automatically add it to the spreadsheet.

Claude's response:

---

🤖 End-of-Month Routine Automation

End-of-Month Checklist

Day 1:

[To Claude]
Organize last month's (e.g., March) expenses.
In Google Sheets TSV format.

[Copy my expense records]

Day 2:

[To Claude]
Create March monthly report.

- Total income/expenses
- Category amounts
- Month-over-month analysis
- Next month's recommendations

Day 3:

1. Copy Claude response
2. Paste into "March Report" sheet in spreadsheet
3. Confirm chart updates

---

Template Usage

Use same prompt every month:

[Prompt for saving - Keep in Notepad]

Title: End-of-month budget organization

---

Claude, organize [month] budget.

[Month] expenses:
[Paste card statement here]

Requests:
1. Organize in Google Sheets TSV format
   (Date, Category, Merchant, Amount, Notes)
2. Category totals
3. Month-over-month analysis
4. Next month's improvements

---

How to use:

1. Save template in Notepad
2. Each month just change [month]
3. Copy and paste expense records
4. Ask Claude!

---

Real Example 5: Integrating Multiple Accounts

My input:

I use 3 credit cards and 1 debit card.
If I give Claude each statement,
can you integrate them into one Excel file?

Claude's response:

Of course! Here's how:

---

💳 Multi-Account Integrated Budget

Method 1: Sequential Organization

Step 1: Organize by card

[Prompt 1]
Organize Shinhan Card March statement.
In TSV format.

[Statement 1 copy]

[Prompt 2]
Organize Samsung Card March statement.
Same format as Shinhan Card above.

[Statement 2 copy]

[Prompt 3]
Organize KB Debit Card March statement.
Same format.

[Statement 3 copy]

Step 2: Request integration

Combine the 3 card records above
into one table.
Sort by date,
and add a card name column.

Result:

Date	Card	Category	Merchant	Amount
2025-03-01	Shinhan	Food	Starbucks	6500
2025-03-01	Samsung	Transportation	Kakao Taxi	8500
2025-03-02	KB Debit	Food	E-Mart	89000
...

---

Method 2: Integrate All at Once

Prompt:

Organize all March card statements.

[Shinhan Card]
03/01 Starbucks 6,500 won
03/05 E-Mart 89,000 won

[Samsung Card]
03/01 Kakao Taxi 8,500 won
03/07 GS Caltex 80,000 won

[KB Debit Card]
03/02 GS25 12,300 won
03/10 Baemin 22,000 won

Requests:
1. Sort by date
2. Show card name
3. Auto-categorize
4. Remove duplicates (if any)
5. TSV format

Claude response:

Date	Card	Category	Merchant	Amount
2025-03-01	Shinhan	Food(Café)	Starbucks	6500
2025-03-01	Samsung	Transportation	Kakao Taxi	8500
2025-03-02	KB Debit	Food(Convenience)	GS25	12300
2025-03-05	Shinhan	Food(Grocery)	E-Mart	89000
2025-03-07	Samsung	Transportation(Gas)	GS Caltex	80000
2025-03-10	KB Debit	Food(Delivery)	Baemin	22000

---

Excel Pivot Table for Card Analysis

Prepare data:

1. Paste Claude's organized table in Excel
2. Select entire table

Create pivot table:

1. "Insert" → "Pivot Table"
2. "Rows": Card name
3. "Columns": Category
4. "Values": Sum of amounts

Result example:

Card/Category	Food	Transportation	Shopping	Total
Shinhan Card	185,000	0	45,000	230,000
Samsung Card	0	95,000	0	95,000
KB Debit Card	123,000	0	0	123,000
Total	308,000	95,000	45,000	448,000

Insights:

• Shinhan Card: Food/shopping focus
• Samsung Card: Transportation dedicated
• KB Debit: Convenience store/small payments

💡 Application:

• Using cards for their benefits?
• Cancel unnecessary cards?

---

Pro Tips Collection

1. Cloud Auto-Backup

• Google Drive: Auto-save
• Version control: "File" → "Version history"
• Recover even if accidentally deleted!

2. Sharing Feature

• Couple budget: Share spreadsheet
• "Share" → Enter email → "Edit permission"
• Real-time simultaneous editing!

3. Template Cloning

• After completing this year's budget
• "File" → "Make a copy"
• Rename to "2026 Budget"
• Delete data but keep structure!

4. Mobile Widget

• Google Sheets app
• Add widget to home screen
• Quickly record today's expenses!

5. Notification Settings

• "Tools" → "Notification rules"
• "Email when spreadsheet changes"
• Get notified when spouse records expenses!

---

Prompt Template

For Excel

Organize [month] expenses in Excel format.

[Expense records]

Requests:
1. Tab-separated table (TSV)
2. Header in first row (Date, Category, Merchant, Amount)
3. Date in YYYY-MM-DD format
4. Amount numbers only (no commas)

For CSV

Create [month] expenses as CSV file.

[Expense records]

Format:
Date,Category,Merchant,Amount
2025-03-01,Food,Starbucks,6500

Including Formulas

Create [month] budget Excel template.

Data:
[Income/expense records]

Requests:
1. Category totals (SUMIF formula)
2. Grand total (SUM formula)
3. Ratio calculation
4. Month-over-month change

Conclusion

Integrating Claude's organized budget data with Excel or Google Sheets transforms simple records into powerful financial analysis tools. Now combine AI and spreadsheet power to create the perfect budget!

---

💡 Today's Tip: Google Sheets is free, auto-backed up, and accessible anywhere. If you don't have Excel, we recommend Google Sheets!

---

🎉 Series Complete!

Thank you for reading all 10 posts in the "AI in Daily Life - Budget" series. Now you can start smart financial management using AI. Small actions create big changes. Fighting!