Skip to main content
Tools
Tools5 min read

Free roommate budget template for Excel and Sheets

Download a free monthly budget for a shared apartment: rent, bills, groceries and 100 expense rows. Excel or Google Sheets, worked example, no signup.

On this page

To run a shared apartment budget, write down what you plan to spend each month by category, then every actual purchase. This free template does it for you: six categories, 100 expense rows and the month’s remaining budget calculated automatically.

Download the free template (.xlsx)

No signup or email required. Open the file in Excel or import it into Google Sheets to fill it in together. The example uses US dollars. The file does not calculate what each roommate owes the others.

Get started

  1. Open the file in Excel or import it into Google Sheets.
  2. In Budget, enter the number of roommates and edit the blue cells.
  3. In Expenses, clear the five examples without deleting the rows. Then enter the month’s purchases.

What is in the file?

Budget holds your plan for the month: rent, energy, internet, shared groceries, cleaning and other costs. The sheet calculates spending by category, the amount remaining and an average per roommate. A negative remainder means you went over the plan.

Expenses records the date, category, description, person who paid, amount and notes. There are 100 input rows, from row 7 to row 106. Keep the category names unchanged so the dropdown matches the summary. Make one copy of the file per month, so each month starts from a clean sheet.

Example: a $2,000 budget for three roommates

These fictional figures are the ones in the file. They are not rent estimates: replace them with your own amounts. Remaining is the planned amount minus recorded spending.

CategoryPlannedSpentRemaining
Rent$1,500$1,500$0
Energy$120$118$2
Internet$36$36$0
Shared groceries$240$186$54
Cleaning$60$22$38
Other$44$0$44
Total$2,000$1,862$138
Three roommates: $666.67 planned and $620.67 spent per person on average.

The $138 remaining is room in the budget, not money sitting in a shared account. If a water bill is still due this month, take it out of that margin before treating it as spare.

How do you use it in Google Sheets?

Download the file, open a spreadsheet in Google Sheets, then choose File → Import → Upload and select the workbook. Create a new spreadsheet: both tabs come with it. Google documents this in its guide to importing Excel files.

Share one working copy with the apartment. Before entering your own figures, check that the example shows $2,000 planned, $1,862 spent and $138 remaining. Agree who logs what, so the same groceries are not entered twice.

Record each expense once

If Inès pays the $1,500 rent, record $1,500 once. When Hugo sends her his share, that transfer is a repayment, not a new expense. Keep the lease security deposit out of the monthly budget too: it is refundable, not a cost. For a credit from the energy supplier, enter a negative amount under Energy.

An average is not everyone’s share

A bigger bedroom can justify a bigger share of the rent. A roommate who works from home uses more energy during the day. The template’s average helps you plan; it does not allocate those costs. Read how to split rent by bedroom size and the energy bill when a roommate works from home. For personal and shared groceries, see splitting groceries and bills with roommates.

Who pays whom in this example?

In the file, Inès paid the rent ($1,500) and internet ($36), Hugo the electricity ($118) and cleaning products ($22), and Léa the groceries ($186). Assume the three roommates share everything equally and no repayments have been made yet. $1,862 divided by three is $620.666…, so two shares of $620.67 and one of $620.66 add up exactly.

RoommatePaidShareTo receive or repay
Inès$1,536$620.67Receives $915.33
Hugo$140$620.67Repays $480.67
Léa$186$620.66Repays $434.66

Hugo pays Inès $480.67 and Léa pays her $434.66. Inès receives $915.33 in total. The workbook does not calculate these repayments; this table explains the example.

Keep the budget here, the balances in Spliz

  1. Create a group for the apartment in Spliz and send its link to your roommates.
  2. Add each expense with the person who paid and the roommates it covers. Keep the rent split you agreed on.
  3. Check the balances, repay by bank transfer, in cash or with another app, then record the repayment. Recording it does not move any money.

Use Spliz for your shared apartment expenses. The app is free. Roommates can join the group as guests without creating an account, after installing the app. The file does not sync with Spliz: keep the spreadsheet for planning and one shared record for day-to-day expenses.

What if a total looks wrong?

Check that amounts are numbers and that the number of roommates is a whole number between 1 and 100. The Budget tab flags invalid inputs. An amount with a missing or unknown category appears under Uncategorized and still counts toward spending. Check that you have removed the sample expenses and stayed within the 100 input rows.

This is an editable planning file, with no macros, external data connections or payments. Keep a clean copy before changing its formulas.

Download the roommate budget (.xlsx)

Sources and method

Put the numbers into practice. Track what each friend paid in Spliz.