Sort out your spending from a card statement
You can do this after: Basics
In one line
Download your statement from your card company’s website or app as an Excel (or CSV) file, upload it to Claude, and say “Sort it by category.”
When to use it
- When you wonder where all your money went this month
- When you want to keep a budget but copying every line by hand is a chore
- When you want to find money that goes out every month, like subscriptions
Follow along
Step 1. Download the statement file
On your card company’s website or app, find the transactions or activity section and choose download (export) as Excel or CSV. Menu names differ from company to company.
Step 2. Upload the file and ask
Click the + button to the left of the input box to upload the file, then type this. How to upload files is covered in detail in Upload files at the Basics level.
Illustration (may look a little different from the real screen)
📎 november_card_activity.csvHere's this month's card statement. Sort it into food, transportation, shopping, subscriptions, and other, and show the total for each in a table. Point out separately any charges that look like they come out every month.
Sample replyHere are November's totals by category.
• Food: $412
• Transportation: $98
• Shopping: $236
• Subscriptions: $41
• Other: $75
Charges that look monthly
• Music subscription $10.99
• Video streaming $15.49 …
📎 november_card_activity.csvHere's this month's card statement. Sort it into food, transportation, shopping, subscriptions, and other, and show the total for each in a table. Point out separately any charges that look like they come out every month.
Sample replyHere are November's totals by category.
• Food: $412
• Transportation: $98
• Shopping: $236
• Subscriptions: $41
• Other: $75
Charges that look monthly
• Music subscription $10.99
• Video streaming $15.49 …
Step 3. Plan for next month
Make it your own
- “Compare my weekend spending with my weekday spending”
- “Total up just my food delivery app charges”
- “I’ll upload last month’s file too. Compare the two months”
Watch out for
- If the file contains your full card number or Social Security number, remove it before uploading. Statements usually already hide most of the card number.
- The totals may be wrong. Compare large amounts against the statement once.
- If the file won’t upload or it can’t read the content, try saving it as CSV in Excel and uploading again, or copying the table and pasting it in.
I'm stuck here
Stuck while following along? Tell me where. Only the site owner sees this. Leave your email only if you'd like a reply.
💌 Get new tips by email
I'll email you when a new tip goes up. No ads, ever.