Monthly Budget for Housemates: Spreadsheet Setup and Tracking Guide

✨ Community Finance

Published: May 1, 2026

Housemates can create a monthly budget by using a shared spreadsheet to log expenses, define splits like equal shares or by space, track payments, and hold monthly check-ins. Start with columns for date, description, amount, split type per person, and running balances. This approach works for U.S. roommates splitting rent, utilities, groceries, and household costs without needing complex tools.

For example, one person logs rent paid upfront, while others mark their shares for reimbursement. Weekly updates keep records current, and end-of-month reviews settle balances. Tools like Google Sheets allow multiple housemates to edit simultaneously, as noted in ExpenseSorted's roommate template guide.

Define Your Monthly Shared Expenses

Start by listing expenses that housemates share each month. Common ones include rent, utilities like electricity and internet, groceries, cleaning supplies, and streaming services.

Consider split options based on fairness and usage. For rent, divide by space: a larger bedroom pays more, as outlined in June Homes' roommate agreement template. Utilities often split equally among all housemates.

Groceries can use equal splits or per-person tracking for items bought. For reimbursements, mark one person at 100% and others at 0% in the split column, per ExpenseSorted's template approach.

Uneven splits fit occasional buys, like pizza where one pays 60%, two others 20% each, and one 0%, as in Ratehub's roommate tracker example. Tradeoffs include equal splits for simplicity versus usage-based for equity; discuss as a group to agree.

Set Up a Shared Spreadsheet for Tracking

Create a Google Sheets or Excel file for monthly tracking. Share the link with edit access so everyone can update in real time.

Recommended columns:

Date
Expense description (e.g., "Electric bill March")
Total amount
Split type (equal, by space, reimbursement)
Share per person (e.g., Person A: $50, B: $40, C: $30)
Payments logged (date and method, like Venmo or cash)
Running balance per person

Log expenses weekly: one housemate buys groceries, adds the row, and notes shares. Others confirm and pay up. Use simple formulas for totals, like summing shares to match the total amount.

ExpenseSorted notes real-time collaboration lets housemates see live changes with edit access. It also supports offline logging that syncs later. Common mistake: forgetting to log payments, which throws off balances; set a reminder to update after transfers.

Review monthly: filter by month, sum balances, and settle. For permissions, give view-only to guests but edit to core housemates. Update cadence: weekly logs, monthly full review.

Create a Roommate Agreement for Budget Rules

Draft a written agreement to set budget expectations. Cover monthly rent amounts per person based on room size or space use, as in June Homes' template.

Specify security deposit portions each paid upfront. Include reimbursement rules, like settling utilities within 7 days of the bill.

Tie in chores linked to money: agree on duties like trash removal, vacuuming, dusting, mopping, and bathrooms, per June Homes' examples. Non-compliance could mean covering extra cleaning costs.

Keep it simple: list rules, sign digitally or print, and store copies. This supports recordkeeping for disputes. Note: U.S. roommate agreements vary by state; this is not legal advice, so consider local landlord-tenant rules.

Example sections:

Rent: Person A $800 (master), B $600 (single), C $600 (single)
Utilities: Equal split
Reimbursements: Pay within 5 days via app or cash
Chores: Weekly rotation, shared supplies 50/50

Monthly Review and Check-In Workflow

Hold regular check-ins to manage the budget, as suggested by June Homes for tracking expenses and payments.

Steps:

End of month, open the shared sheet.
Review new expenses: confirm descriptions and totals with receipts.
Check balances: who owes whom.
Settle payments: transfer and log.
Plan next month: adjust splits if needed, like higher utilities in summer.

Script example: "Let's review March balances. Alex owes $25 for groceries; confirm payment? Next month's rent due April 1."

For receipts, snap photos, upload to a shared folder, and link in the sheet. June Homes recommends shared spreadsheets for equal contributions.

A spreadsheet suits simple groups of 2-4 housemates. It works when trust is high and expenses are predictable.

Recordkeeping Basics for Housemate Budgets

Keep records to back reimbursements and avoid disputes. Save spreadsheet exports as PDFs monthly, log payment screenshots (e.g., Venmo confirms), and store receipts digitally.

Document agreements and check-in notes in the same sheet or a separate tab. This creates a trail for shared expenses.

Editorial sources like June Homes emphasize tracking for alignment. For disputes, records help but consider mediation or local rules. U.S. readers: check state guidelines for roommate records; this is not formal advice.

Next steps: Set up your sheet today, draft the agreement this week, and schedule the first check-in.

FAQ

How do I split rent unevenly in a monthly budget?

Base it on room size or private space, like $800 for a master bedroom and $600 for singles, as in June Homes' agreement template. Log shares in the spreadsheet and track payments.

What columns should my housemate spreadsheet include?

Date, description, total amount, split type, per-person shares, payments logged, and running balances. This setup, inspired by ExpenseSorted, handles monthly tracking.

How often should we check our shared expense balances?

Weekly for logging, monthly for full reviews and settling, per June Homes' workflow for alignment.

Can we track cleaning chores in the budget sheet?

Yes, add a chores tab with rotation schedules and costs for supplies. Tie to money by noting shared cleaning fees if duties lapse, as in June Homes' examples.