Shared Budget Template for 3-5 Student Roommates

✨ Community Finance

Published: February 16, 2026

Can three to five roommates run a shared budget without a joint account or some complicated app? Yes. Pick a rule for each expense, write it down, and update one shared tracker every week. That's the entire system.

Nobody should have to guess who paid for the internet. The template below keeps rent, utilities, groceries, and reimbursements in separate lanes, so everyone can see the bill and each person's balance at the same time.

Decide the money rules before the first bill

Meet before any rent, deposit, or utility bill comes due. One honest conversation now beats weeks of vague group-chat messages later.

Keep the tracker limited to costs the household actually shares. Your roommate's sneakers and streaming subscriptions stay out of it.

Category	Decide together	Record in the tracker
Rent	Each person's amount or percentage, payment deadline, and how rent is submitted	Amount due, due date, and payment status
Utilities	Equal split or a specific exception	Bill total, payer, receipt, and each share
Internet	Who participates and how it is divided	Recurring amount and due date
Groceries	Separate food, shared staples, or a meal pool	Shared items only
Household supplies	What counts as shared	Cleaning products, paper goods, and similar basics
Furniture, deposits, and move-in costs	Ownership and what happens when someone leaves	Who paid and any agreed reimbursement

Pick one person to maintain the sheet. They type the rows; they don't get to rewrite house rules alone. Everyone can see the record, and anyone can raise an issue before a balance gets settled.

One boundary matters here. The house record exists for coordination. It doesn't replace the signed lease or the payment process your landlord requires.

Copy this free shared budget template

A plain spreadsheet handles this for most student houses. Set up four tabs called House Setup, Expenses, Shares, and Settlements.

Thing is, the Shares tab does one specific job. It keeps a purchase separate from the people who owe for it, so the two never get tangled into a single row.

Tab	What it holds	Why it matters
House Setup	Roommate names, move-in dates, rent percentages, and house rules	Keeps the starting assumptions visible
Expenses	Every shared bill or purchase	Shows what the household spent
Shares	One row for each person's share of an expense	Calculates what each person owes
Settlements	Payments made between roommates	Shows which balances are still open

Expenses tab

One row per shared bill, grocery run, or household purchase. No exceptions.

Expense ID	Date	Category	Description	Total	Paid by	Due date	Receipt link	Status
		Rent, utility, grocery, supplies, other						Open or settled

Give every row a short, unique ID. Something like APRIL-01 is plenty.

Link the receipt whenever one exists. A payment confirmation only proves money left an account. It doesn't show what was actually bought.

Shares tab

Every roommate included in an expense gets a row here.

Expense ID	Housemate	Amount owed

If an expense covers only three of five people, list just those three names. Never use a blank cell to mean someone is excluded. Blank cells turn into arguments later.

Even split? Divide the expense total by the number of included roommates. A formula like =Expenses!E2/4 works when the expense sits on row 2 and four people share it. Uneven splits get typed in by hand, using whatever amounts the group agreed on.

Settlements tab

Money moving between roommates gets logged here, separate from the original expense.

Date	From	To	Amount	Note

The distinction matters more than it looks. The grocery receipt records spending. The settlement row records repayment. Two different events, two different rows.

Summary formulas

Build a summary table with one row per housemate. It answers the only question anyone actually asks: who owes whom, and how much?

Housemate	Total paid	Share owed	Before settling	Sent	Received	Current balance

Drop these formulas into row 2, then copy them down for each roommate.

Total paid: =SUMIF(Expenses!$F:$F,A2,Expenses!$E:$E)
Share owed: =SUMIF(Shares!$B:$B,A2,Shares!$C:$C)
Before settling: =B2-C2
Sent: =SUMIF(Settlements!$B:$B,A2,Settlements!$D:$D)
Received: =SUMIF(Settlements!$C:$C,A2,Settlements!$D:$D)
Current balance: =D2+E2-F2

A positive current balance means the household owes that person money. A negative one means they still owe into the group.

Whatever happens, don't delete old rows to make a balance disappear. Add a settlement or adjustment row instead. The history is the point.

Print a one-page monthly tracker

The spreadsheet stays the source of truth. But a printed one-pager can keep a busy house honest between check-ins.

MONTH: __________________

RENT
Total due: __________
Paid by: __________
All roommates settled: Yes / No

UTILITIES
Electric or gas: __________
Water: __________
Internet: __________
Due dates checked: Yes / No

SHARED GROCERIES AND SUPPLIES
Budget: __________
Spent so far: __________
Receipt log updated: Yes / No

OPEN BALANCES
Roommate: __________ Amount: __________
Roommate: __________ Amount: __________

NEXT HOUSE MONEY CHECK-IN: __________

Put it on the fridge if that helps. Just make sure it mirrors the digital tracker rather than replacing it.

Split rent fairly when rooms are different

Equal rent works when the bedrooms, privacy, and access are genuinely similar. It's simple, everyone remembers it, and it creates the least work.

Once one room has clearly more space, or a real perk, switch to a room-based split. Bedroom size is a fine starting point. It's not the whole story, though. A private bathroom, extra storage, better light, real privacy, street noise, or a room you have to walk through to reach the rest of the apartment can all shift what feels fair. That last one is the classic example people forget until move-in week.

Set percentages that add up to exactly 100 percent before anyone sends money. Then record the final dollar amounts in the House Setup tab. If total rent is $1,600 and one room's agreed share is 25%, that roommate pays $400. Simple math, written down once.

Income-based rent can work for close friends who want it. It also asks people to share personal financial details, so it should never be assumed. And agreeing that someone pays less doesn't automatically change what their lease says they owe.

Decide now, in writing, how you'll handle a roommate joining late, leaving early, or hosting a temporary subtenant. Rental obligations vary by lease and state. Read your lease, and confirm the landlord's required payment process before promising anything.

Give utilities, groceries, and supplies different rules

Don't force every cost into the same split. Rent is fixed. Groceries aren't.

Cost	A workable default	When to revisit it
Electricity, gas, and water	Split equally among residents	A clearly agreed exception, such as a long absence or unusual usage
Internet	Split among the roommates who use it	Someone moves out or the service changes
Cleaning supplies and paper goods	Share agreed household basics	Purchases include personal items
Groceries	Choose one grocery model and stick to it	The group keeps disagreeing about what is shared
Guest-related costs	Discuss before adding them to house spending	A guest regularly stays over

For groceries, pick one of these models:

Keep food separate and split only staples such as trash bags, dish soap, and paper towels.
Create a shared meal fund for planned group dinners and keep personal snacks out of it.
Keep all groceries separate, condiments included, if the household has different diets or routines.

To be honest, a grocery pool falls apart the moment "shared" means something different to each roommate. Label shelves, save the receipts, and split personal items off a shared receipt before logging the household portion.

Set a monthly spending limit for supplies or shared food. If the category starts running hot, talk before the next shop. Don't quietly change the rule mid-month.

Follow a weekly expense and settlement routine

Record fast, settle separately. A five-minute check each week beats reconstructing a month of purchases from memory.

Before the month begins, add known rent, internet, and expected utility due dates.
The payer logs each actual bill or shared purchase as soon as it happens.
Add a Shares row for every roommate included in that expense.
Send a payment request or reminder using the amount shown in the tracker.
When someone pays, log it on the Settlements tab.
Review open balances, missing receipts, and unclear grocery charges once a week.
At month-end, confirm every balance before starting the next month.

Pay however the group already agreed to pay. The transfer settles a debt. The tracker explains it.

A simple reminder lands easier when it points at a visible record:

The bill is in the shared tracker. Your share is [amount].
Please send it by [date]. Reply here if the split needs correcting before then.

Keep reminders factual. A late payment stays fixable when it's handled as a line item. It gets harder when it becomes a public argument.

Choose a spreadsheet, an expense app, or both

Nobody needs an app for this. A spreadsheet wins when your house wants custom rent shares, receipt links, detailed notes, or a record that stays with the group.

A shared-expense app can fit better if every roommate would rather log purchases from a phone and the group only needs simple balances. Before you rely on one, test it with a mock utility bill and an uneven split. Then check its current pricing, privacy settings, export options, and account requirements in the product's official information.

Turns out, one source of truth beats two partial records. Don't enter the same grocery run in a spreadsheet and an app, unless one of them is clearly marked as the archive.

Payment tools, trackers, and receipt folders serve different jobs. Keep that separation clear.

Put the agreement in writing

A short money agreement blocks selective memory. It can sit at the top of your spreadsheet or in a shared document.

HOUSE MONEY AGREEMENT

Rent split:
Rent payment deadline:
Who submits rent, if applicable:
Utility split rule:
Internet split rule:
Shared grocery rule:
Shared supplies rule:
Receipt and tracker rule:
Settlement deadline:
What happens if a roommate moves out:
How changes must be approved:
Date agreed:

Write it down before the memory turns fuzzy, even if it feels slightly over-formal in the first week and everyone is standing around a half-unpacked kitchen holding tape guns, because the later version of that conversation is rarely as easy.

This is a planning record, not legal advice. It can't override lease terms, landlord requirements, or state law.

Fix the common problems before they grow

Most money disputes trace back to an undefined category or a stale entry. These are the usual ones.

Personal items appear on a shared receipt. Split the receipt into shared and personal lines before it enters the tracker. Nobody should subsidize snacks, toiletries, or takeout they never agreed to share.

One person always fronts the money. Rotate the payer for variable costs, or settle more often. The person paying the bills shouldn't have to chase the whole house indefinitely.

The tracker becomes an archive. Give it a regular check-in date. A tracker nobody opens is just a spreadsheet-shaped memory problem.

A roommate moves out. Keep their old rows and add an end date in House Setup. Settle utilities, shared purchases, and any agreed one-time costs before their access to the tracker goes away.

Chores become a punishment for unpaid bills. Chores and money are separate household responsibilities. Handle a missed payment directly, with the same written rules you use for every roommate.