A shared household expense and bill tracker

A shared apartment expense tracker is one record that everyone in the household can see. It lists each shared cost, who paid it, how it is split, and what each person's running balance is. You can build one in Excel or Google Sheets, start from a ready-made template, or use a dedicated shared-expense app. The format matters less than two things: the household agrees on the rules before the first entry, and the record is kept up to date. This guide covers both, using a simple Excel layout as the example.

Choosing a format: your own spreadsheet, a template or an app

Search results for this topic include four kinds of option: roommate expense spreadsheets for Excel, expense-splitter templates for Google Sheets, a shared-expenses template for Notion, and roommate or shared-expense apps in the Apple and Google app stores. The information available here comes from listing titles and short descriptions, so it does not confirm any product's current features, price or availability. Check each option yourself before the household relies on it.

Option | Can suit households that | Check before committing

Your own Excel or Google Sheets workbook | Want full control over the columns and split rules | Who builds and maintains it, and whether every member can open and edit the file

Ready-made spreadsheet template | Want a quick start with an existing layout | Whether it handles your number of people and uneven splits, and whether its formulas are easy to understand

Notion-style template | Already use that workspace for other household notes | Whether every member has access and is comfortable entering data there

Dedicated shared-expense app | Prefer entering costs from a phone and seeing balances calculated automatically | Current pricing, which features are free, what data the app collects, and whether you can export your records

About free trackers: a spreadsheet you build yourself costs only whatever access to spreadsheet software you already have. Whether a particular template or app is free, and on what terms, is not confirmed by the information here. Check the current listing.

What the household needs to agree on first

A tracker records an arrangement; it does not create one. Separate the choices you are proposing now from commitments that already exist, such as the lease, utility accounts in a particular person's name, or subscriptions someone already pays for. The tracker documents how members share costs among themselves. It does not change the terms of those outside agreements, so read the documents themselves for questions about them.

Which costs are shared: for example rent, each utility, internet, household supplies, groceries and shared subscriptions. Also list what stays personal.
How each cost is split: equally, by fixed custom shares (for example, by room size), or only among the people who used it. Topic sources commonly mention custom shares for rent, even splits for utilities, and splitting groceries only among the people who shared them. These are options to discuss, not defaults you must follow.
Who pays each bill to the provider or landlord, and by what date.
How and when others reimburse that person, and which payment methods everyone will accept.
How often balances are settled: weekly, monthly, or when a bill is paid.
The recording rule: how soon after paying a cost someone should log it, and whether a receipt or bill reference is expected.
Who maintains the tracker, including formulas, sharing settings and backups.
Exceptions: one-off large purchases, guests staying for a long time, extended absences, and items bought for the household without asking first.
What happens when someone moves in or out: the date their share starts or ends, and how prorated bills are handled.
How to raise a question about an entry: for example, adding a note in the tracker before settle-up rather than editing someone else's row.

Write the agreed split for each recurring cost on its own tab or in a short note at the top of the workbook. When someone questions an entry later, everyone can check the rule instead of relying on memory.

What information belongs in the tracker

Keep only the fields needed to answer three questions: what was spent, who paid, and who owes what. The layout below is illustrative; add or remove columns to match your agreement.

Column (illustrative) | What to enter | Notes on ambiguous entries

Date | The date the money was paid | If a bill covers a period such as a month of electricity, put the period in Description so it is not confused with the payment date

Description | What the cost was, for example "Electricity, March" | Be specific enough that others can match it to a bill or receipt

Category | Rent, utilities, groceries, supplies, subscription, settlement | Use "settlement" for repayments between members so they can be filtered out of spending totals

Amount | The total amount paid | Enter the full amount, not just the shared portion

Paid by | The one member who paid | If two people paid parts of one bill, record two rows

Share per member (one column each) | Each person's portion of this cost | Each person's portion can differ; members who did not share the cost get 0

Check | Amount minus the sum of shares | Should be 0; anything else means the split does not add up

Notes | Receipt reference, exceptions, open questions | Useful for flagging an entry before settle-up

Using one share column per member, instead of a single "split equally" setting, lets the same sheet handle equal splits, custom rent shares, and groceries shared by only some people.

Illustrative sample entries

The rows below are an invented example for a three-person household (Members A, B and C). They show how different split rules look in the same log. They are not suggested amounts or recommended splits.

Day 1 | Rent, agreed custom shares | Rent | 1800 | A | 700 | 550 | 550 | 0

Day 10 | Electricity, previous month | Utilities | 90 | B | 30 | 30 | 30 | 0

Day 12 | Groceries shared by A and C | Groceries | 60 | C | 30 | 0 | 30 | 0

Calculating balances in Excel

Each person's balance is what they paid minus the total of their shares. A positive balance means the household owes that person money. A negative balance means that person owes the household. In a correct log, all balances add up to zero. The layout and formulas below assume headers in row 1, data from row 2, Amount in column D, Paid by in column E, and member share columns in F, G and H. Adjust the ranges to fit your sheet.

Transactions sheet (columns)
A: Date   B: Description   C: Category   D: Amount   E: Paid by
F: Share A   G: Share B   H: Share C   I: Check   J: Notes

Check column (row 2, copy down):
I2:  =D2-SUM(F2:H2)

Summary sheet (one row per member)
Paid by A:    =SUMIFS(Transactions!D2:D500, Transactions!E2:E500, "A")
Shares of A:  =SUM(Transactions!F2:F500)
Balance of A: =[Paid by A cell]-[Shares of A cell]

Repeat for B (column G) and C (column H).
The sum of all balances should equal 0.

From the sample rows, Member A paid 1,800 and has shares of 760, for a balance of +1,040. Member B paid 90 and has shares of 580, for a balance of -490. Member C paid 60 and has shares of 610, for a balance of -550. The balances add up to zero. To settle up, B pays A 490 and C pays A 550.

To record a repayment, add a row with category "settlement". The person sending money goes in Paid by, and the full amount goes in the recipient's share column. In the example, B paying A 490 is entered as Amount 490, Paid by B, Share A 490. This raises B's balance to zero and lowers A's by the same amount, so the log keeps a full history instead of having balances overwritten.

Keeping the tracker current

Log each shared cost within the time the household agreed, while the receipt or bill is still at hand.
Glance at the Check column for any row that is not 0 before each settle-up.
Review balances together on the agreed schedule, then record each repayment as a settlement row.
After a period is settled, mark it in Notes or move it to an archive tab so the current period stays easy to read.
Keep a copy of the workbook, or an export if you use an app, somewhere every member can reach.
Revisit the split rules when circumstances change, such as a new member, a changed bill, or a new shared subscription, and record the date the new rule starts.

Gaps to keep in mind

The information behind this guide comes from search listing titles and short descriptions. It does not establish which apps or templates are currently free, which features they include, how they handle personal data, or how reliable they are, so check those points directly before choosing one. Nothing here is financial or legal advice. The tracker is a shared record of what household members have agreed, and its usefulness depends on that agreement being clear and the entries being kept up to date.