# Make a budget from your bank statements

> Markdown version of https://stella.sh/how/money-household/make-a-budget-from-bank-statement for agents and LLMs.
> Turn bank and credit card downloads into a monthly budget by category, with card payments and transfers left out: a PivotTable, or Stella (stella.sh).

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.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 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×.

Video (47 s): https://stella.sh/media/proofs/money-household/make-a-budget-from-bank-statement/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. Checking-account and credit-card downloads for July to September are in Downloads.
- 0:02 The prompt: a simple budget, average monthly spending in seven categories.
- 0:15 Stella replies: card payments, transfers, refunds and income will be left out so nothing is counted twice.
- 0:21 Sorting the transactions, sped up 6×.
- 0:33 Done: about $3,671 a month, rent first, with the sorting choices you might want to change.

What Stella does:

1. Finds two downloads in Downloads: a checking account and a credit card, July to September
2. 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
3. Counts each card purchase once on its own, and takes a clothing refund off shopping
4. Sorts every purchase into rent, groceries, eating out, transport, bills and utilities, shopping or everything else
5. Saves `Budget Jul-Sep 2026.xlsx` in Documents with a Budget tab of monthly averages and a Transactions tab where changing a category updates the totals
6. 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 to paste

```text
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.
```

## Build the budget yourself

1. **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](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel) first.
2. **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.
3. **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.
4. **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.
5. **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 Stella 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](https://stella.sh/how/pdf-excel/find-subscriptions-in-bank-statement). To spot a merchant that billed you twice, see [find duplicate charges on your credit card](https://stella.sh/how/money-household/find-duplicate-charges-on-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](https://stella.sh/how/money-household/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.

Sources: [Microsoft Support: Create a PivotTable to analyze worksheet data](https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576).

## Related problems

- [Find every subscription and regular payment in your bank statements](https://stella.sh/how/pdf-excel/find-subscriptions-in-bank-statement.md)
- [Find duplicate charges on your credit card](https://stella.sh/how/money-household/find-duplicate-charges-on-credit-card.md)
- [Convert OFX, QFX and QIF files to Excel](https://stella.sh/how/money-household/convert-ofx-to-excel.md)
- [Split bills with roommates and settle up in the fewest payments](https://stella.sh/how/pdf-excel/split-bills-with-roommates.md)
- [How much have I spent on Amazon each year?](https://stella.sh/how/money-household/how-much-have-i-spent-on-amazon.md)
- [Total your mileage log for taxes](https://stella.sh/how/money-household/mileage-log-for-taxes.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
