Make a budget from your bank statements
Three months of bank and card downloads as a monthly average for each category.
A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 01 s in real time.
The short answer.
Download the last few months from your bank and card as CSV, put them on one sheet, delete the card payments and transfers between your own accounts (they'd count the same spending twice), add a Category column and total it with a PivotTable, divided by the number of months. Stella (stella.sh) does that from the downloads on your computer: it sorts every purchase, leaves out paychecks, transfers and card payments, nets off refunds, and saves a spreadsheet whose totals update when you move something.
Stella does this on Windows, Mac and Linux.
What happened.
About a minute and a half. Checked afterwards against an answer key written before the run: the monthly average right for all seven categories (rent $1,650, groceries $722, eating out $274, transport $223, bills $327 with streaming and the gym, shopping $273, everything else $203) and a monthly total of $3,671, so card payments and the savings transfer weren't counted as spending.
The accounts, merchants and amounts are fictitious, made for this run, in US dollars. Stella's spreadsheet works its figures out with live formulas, so the check recalculated a copy to read them. The work is sped up 6×.
How Stella does it.
- Finds two downloads in Downloads: a checking account and a credit card, July to September
- Leaves out paychecks, money in from a friend, the $500 moved to savings each month and the card payments that show up in both files
- Counts each card purchase once on its own, and takes a clothing refund off shopping
- Sorts every purchase into rent, groceries, eating out, transport, bills and utilities, shopping or everything else
- Saves
Budget Jul-Sep 2026.xlsxin Documents with a Budget tab of monthly averages and a Transactions tab where changing a category updates the totals - Points out the calls you might make differently: streaming and the gym under Bills, a big July online order, cash withdrawals under everything else
The prompt.
Use my bank and credit card downloads in Downloads to make me a simple budget spreadsheet: how much I spend a month on average on rent, groceries, eating out, transport, bills and utilities, shopping, and everything else.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
Download a few months as CSV
In online banking, look for Download or Export on each account and card, and choose CSV (or Excel) for the same full months. Three months evens out bills that come quarterly. Only have PDF statements? See bank statement PDF to Excel first.
Stack them on one sheet
Paste every file under one set of headers: Date, Description, Amount, Account. Make spending the same sign in all of them, since banks and card companies often use opposite signs.
Delete what isn't spending
Filter the descriptions for PAYMENT, TRANSFER, payroll and money from friends, and delete those rows. The payment to your card is the same purchases you already have on the card file. Leave refunds in as negative spending.
Add a Category column
Type a category on each row, or sort by Description and fill a merchant's rows at once. Decide up front where subscriptions, the gym and cash withdrawals go, and stick to it.
Total it with a PivotTable
Excel: Insert, PivotTable, Category in Rows, Sum of Amount in Values. Numbers 13 and later has Pivot Tables too, or use SUMIF per category. Divide each total by the number of months for the monthly average.
Where it stops.
- Categories are Stella's reading of merchant names. It listed the choices you might want to change, but read the Transactions tab before you trust the totals.
- Your transactions go to the AI model you use in Stella while it sorts them. Delete account numbers from the downloads first if you like; it never needs your banking login.
- A budget from three months is an average, not a plan: yearly bills, holidays and one-off purchases need adding by hand.
- Not financial advice. Stella adds up what you spent; what to cut is your call.
- Recorded on Linux. On a Mac or Windows PC Stella may first install Python or a small spreadsheet library, which wasn't recorded. The file opens in Excel, Numbers or Google Sheets.
Questions.
Why does my budget count some spending twice?
When you add both a bank account and the card you pay from it, the card payment on the bank side is the same money as the purchases on the card. Count the purchases and drop the payment. Transfers to your own savings aren't spending either.
Do I need a budgeting app that links to my bank?
Not to see where the money goes. The CSV downloads you already get hold the same transactions, and nothing has to be connected. An app is handier only if you want it updated every day.
Can it find the subscriptions I forgot about?
Yes: see find subscriptions in your bank statement. To spot a merchant that billed you twice, see find duplicate charges on your credit card.
My bank gives me OFX or QIF files instead of CSV. Will that work?
Yes. Stella reads them directly, or see convert OFX to Excel to get a spreadsheet first.
Is Stella free for this?
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.
Can I control what Stella changes on my computer?
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.
Checked against these sources on 14 November 2026.