Stella
PDFs and Excel

Split bills with roommates and settle up in the fewest payments

Ten months of house expenses settled in three payments, uneven splits included.

Download StellaFree with the plan you already have.

A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 27 s in real time.

The short answer.

For each person, add up what they paid and subtract their share of every cost they were part of; positive means they're owed, negative means they owe. Then have each person who owes pay someone who's owed, biggest first, which keeps the payments to a minimum. Stella (stella.sh) does this from the sheet you already keep, following the “split between” column, notes, refunds and repayments, and saves the payments in a file.

Stella does this on Windows, Mac and Linux.

What happened.

Settled in about 2½ minutes: Dev pays Ana $6,222.04, Ben pays Ana $5,689.60, Chloe pays Ana $5,131.56. Checked afterwards against an answer key written before the run: the payments settle every balance exactly in no more than 3 payments, each person's balance is shown, and the expenses spreadsheet is unchanged.

The house, its four sharers and their expenses are fictitious, made for this run, in US dollars. The work is sped up 8×.

How Stella does it.

  1. Reads House expenses 2026 in Documents: 66 rows from January to October, with names typed inconsistently (“ben”, “Ana ”)
  2. Splits each cost only between the people named in its “Split between” column, and follows the note under the table that Dev was away in August for electric and water
  3. Counts Ben's $200 to Ana as a repayment and cancels the vacuum purchase against its refund
  4. Works out each person's balance and settles them in three payments, all to Ana, who paid the rent
  5. Saves a settle-up spreadsheet with the payments, balances and a line-by-line ledger, and flags two things to check: no November entries yet, and concert tickets that look personal

The prompt.

Four of us share a house and we log who paid for what in House expenses 2026 in my Documents. Work out who owes who, with the fewest payments to settle up, and save it as a file.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Tidy the sheet

    Make sure every row has Amount, Paid by and Split between, with names spelled the same every time (Find and Replace “ben” with “Ben”). Refunds go in as negative amounts. Write “All” where everyone shares.

  2. Add a share column per person

    For Ana: =IF(OR($E2="All",ISNUMBER(SEARCH("Ana",$E2))),$C2/IF($E2="All",4,LEN($E2)-LEN(SUBSTITUTE($E2,",",""))+1),0), where C is the amount and E the split. Copy it for each person, changing the name, and fill down.

  3. Work out each balance

    For each person: =SUMIF(D:D,"Ana",C:C) - SUM(F:F), what they paid minus their share column. The four balances should add up to zero (within a cent or two).

  4. Settle with as few payments as possible

    List who owes (negative) and who's owed (positive). Have the biggest debtor pay the biggest creditor as much as one of them needs, cross off whoever reaches zero, and repeat. That never takes more payments than people minus one.

  5. Handle the exceptions

    Money one sharer paid another directly (a repayment) is a row paid by the payer, split to the receiver only. Months when someone was away need the split column changed for those rows.

Where it stops.

  • Stella works out the payments; it doesn't send money or request it.
  • It follows the “Split between” column and notes as written, and says how it read anything ambiguous. Here it counted concert tickets because they were logged, and showed what changes if they shouldn't count.
  • The expenses and names go to the AI model you use in Stella. The sums are worked out on your computer.
  • Recorded on Linux with a free Python library; the settle-up file is an ordinary .xlsx that opens in Excel, Numbers or Google Sheets.

Questions.

What's the fewest number of payments to settle up?

At most one fewer than the number of people. Often fewer: here everyone owed the same person, so three payments settled four people.

Do I need a bill-splitting app?

Not if you already log expenses in a sheet. Apps need everyone to sign up. A spreadsheet with SUMIF, or Stella reading your sheet, gives the same answer.

How do I split a bill when someone was away?

Change that row's split to the people who were there. Stella followed a note saying exactly that for August.

Can I see spending by category as well?
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 13 November 2026.

Stella