Can a free Google Sheets household budget track rent, power bills, groceries, deposits, and casual IOUs without causing fights? It can, but only under one condition: keep your bills apart from your repayments.
Who bought something, who owes money for it, and who paid back their portion are three separate facts. Mash them together and a $150 utility charge suddenly looks like two separate expenses.
You do not have to build from a blank file. Grab this free shared-expense spreadsheet template or the roommate-focused version. Both carry the fields you actually need: payer, total bill, split method, individual shares, and settlement status. Copy one, then tweak the categories for your home.
Keep bills, shares, and repayments separate
A standard budget shows where household money went. A shared ledger tracks who owes what to whom right now. Both jobs belong in the same workbook, but their rows must never touch.
| Tab | Suggested columns | Purpose |
|---|---|---|
| Expenses | Expense ID, date, description, category, paid by, amount, split method, receipt link, notes | Records each bill or purchase once |
| Shares | Expense ID, person, share owed | Shows each person's responsibility |
| Settlements | Date, from, to, amount, status, reference | Records repayments only |
| Summary | Person, paid, share owed, sent, received, balance | Calculates who is still owed |
| Lists | Member names, categories, split methods, statuses | Supplies consistent dropdown values |
For households that never change, a simple column per person can work.
The separate Shares tab earns its keep the second someone moves out, sub-leases, or sits out an expense. Audits take seconds instead of hours.
Set up the Expenses and Shares tabs
Assign an ID to every purchase first. That code anchors the original receipt, the individual shares, and any payment later.
| Expenses column | Example entry |
|---|---|
| Expense ID | ELEC-01 |
| Date | January 15 |
| Description | January electric bill |
| Category | Utilities |
| Paid by | Alex |
| Amount | $150.00 |
| Split method | Equal |
| Receipt link | Link to the bill |
| Notes | Shared by Alex, Jordan, and Casey |
Enter the full bill in Amount. Then add one row per person in Shares:
| Expense ID | Person | Share owed |
|---|---|---|
| ELEC-01 | Alex | $50.00 |
| ELEC-01 | Jordan | $50.00 |
| ELEC-01 | Casey | $50.00 |
Alex covered $150 upfront but owes only $50. Before anyone sends money, Alex sits at positive $100 while Jordan and Casey each owe $50.
It feels a little fussy, to be honest, and yes, every extra roommate means another line in the sheet, but that small repetition is exactly why you can audit balances six months down the road without guessing.
Leave personal spending off the tab unless everyone agreed to chip in. When someone pays a deposit or buys shared furniture, write down who keeps the item or collects the refund later.
Choose the split method before anyone pays
Splitting everything equally is quick. It is not always fair. Pick the allocation rule before cash leaves anyone's pocket, then paste that rule directly into Split method or Notes.
| Situation | Possible method | What to record |
|---|---|---|
| Rent for rooms of different sizes | Room-size or agreed fixed split | The agreed percentages or dollar amounts |
| Utilities | Equal or usage-based | The reason for an uneven share |
| Groceries | Equal, itemized, or usage-based | Which items are shared |
| Travel lodging | Per person or nights stayed | Who stayed for which dates |
| One person's expense | Owner pays 100% | The responsible person's name |
| Couple or family contribution | Agreed income-based or fixed split | The rule and when to revisit it |
Watch out for templates that bundle an expense into a 100% and 0% reimbursement tag. That shorthand creates confusion fast. Whether that 100% means someone is personally responsible for the cost or simply fronted the cash at the register changes what the entry actually means, and those are two different facts.
Take a practical case: Alex spots Jordan $40 for personal supplies. Alex goes under Paid by. Jordan gets the full $40 share. Alex spent money; Jordan owes the money. Never let a split label erase who paid.
Add formulas for balances
Pick one spelling per person and stick with it. To a spreadsheet formula, Alex, alex, and Alex R. are three unrelated strangers.
Put a roommate's name in Summary!A2. Place these formulas across row 2, then drag them down:
| Summary column | Formula | Meaning |
|---|---|---|
| B2 Paid | =SUMIF(Expenses!$E$2:$E$500,$A2,Expenses!$F$2:$F$500) |
What that person paid |
| C2 Share owed | =SUMIF(Shares!$B$2:$B$500,$A2,Shares!$C$2:$C$500) |
Their assigned share |
| D2 Sent | =SUMIFS(Settlements!$D$2:$D$500,Settlements!$B$2:$B$500,$A2,Settlements!$E$2:$E$500,"Paid") |
Settlements they sent |
| E2 Received | =SUMIFS(Settlements!$D$2:$D$500,Settlements!$C$2:$C$500,$A2,Settlements!$E$2:$E$500,"Paid") |
Settlements they received |
| F2 Balance | =B2-C2+D2-E2 |
Their remaining position |
Positive balances mean the house owes that roommate money. Negative numbers mean that person needs to pay up.
Turns out, most balance headaches come from messy data entry rather than broken math. Run =SUM(F2:F20) at the bottom of the balance column. If the total is not zero, look for an unmatched name, a missing share row, or a settlement logged twice.
Add a monthly household budget view
A shared ledger tracks IOUs. A household budget groups spending by date and category.
To pull an all-time category total against a label in Summary!A2, drop in this formula:
=SUMIF(Expenses!$D$2:$D$500,$A2,Expenses!$F$2:$F$500)
When reviewing single months, filter Expenses by date or drop the data into a pivot table showing dates, categories, and dollar amounts. A standard chart can read those totals without touching raw transactions. Look at this Google Sheets expense tracker example to see how a clean month-selector and category summary fit together.
Lock categories behind dropdown menus. Formulas treat Groceries and Food as different buckets, which undercounts both. Keep your list tight: rent, utilities, groceries, supplies, moving costs, deposits, and shared meals cover almost every living situation.
One main Expenses tab usually works better than creating twelve separate month tabs. Formulas break when someone renames a sheet.
Share the sheet and protect the formulas
Duplicate the template before typing real data into it. Hit Share, enter individual Google accounts, and grant Editor rights only to the people logging expenses or settlements.
A public link feels easier. It also broadcasts receipts and private household spending to anyone who finds it. Adding specific emails gives you a clean way to pull access when someone moves out.
Lock down your calculation cells. Head to Data > Protect sheets and ranges; follow the exact steps in this Google Sheets protected-ranges guide. Leave input cells open so roommates can add expenses, but lock your Summary sheet and formula columns.
Range protection stops clumsy typing. Tight sharing permissions stop unauthorized eyes.
Use the same workflow every time
Follow these six steps whenever money changes hands:
- Agree on ground rules. Settle split types, shared expense definitions, receipt storage, and review dates upfront.
- Log the purchase. Enter the date, description, category, payer, total cost, and receipt link promptly.
- Assign the shares. Create a row in
Sharesfor each roommate involved, verifying that the shares equal the purchase total. - Document the edge cases. Add clear notes for bedroom-size differentials, nights stayed, income splits, personal additions, deposits, or future refunds.
- Record settlements alone. When Jordan sends $50 to Alex, log a row in
SettlementswithFrom = Jordan,To = Alex,Amount = 50, andStatus = Paid. Leave the original bill alone. - Check balances on schedule. Settle after each bill or run a weekly or monthly review. Pick a routine and keep to it.
Need to send a nudge? Try this: "Hey, please check the sheet before Sunday. Jordan currently owes Alex $50 for January utilities. Mark the settlement Paid after it is sent."
Thing is, asking for cash is not the same as getting cash. Never mark an entry Paid until the bank or payment app confirms it.
Mistakes that create bad balances
- Entering the full bill as the payer's personal share owed.
- Recording a cash settlement as a brand-new household expense.
- Scattering spending across duplicate category tags like
GroceriesandFood. - Relying on 100% and 0% split tags without documenting who is actually liable.
- Overwriting Summary formulas by typing raw numbers directly into calculation cells.
The sheet handles your ledger math. It cannot chase roommates, verify bank deposits, or resolve disagreements for you.
When receipts pile up unlogged or housemates swap out constantly, dedicated software might save time. For most groups, an updated spreadsheet and clear rules work fine.
Common questions
Should the payer's share include their own portion?
Yes. If Alex pays $150 for an electric bill split three ways, Alex's share is $50. Not zero. Not $150. The other $100 is what the house owes back to Alex.
Should I enter a reimbursement as a new expense?
No. Leave the original purchase on the Expenses tab and log the money transfer under Settlements. The only time you touch Expenses is when an actual bill occurs.
Can couples or families use the same setup?
Yes. You do not need joint checking accounts to make this work. Log shared bills in the ledger, keep individual purchases on personal cards, and document whatever split ratio you agreed upon.
When should I consider another tool?
Make the switch when manual maintenance breaks down. That usually happens when receipts pile up on counters, reminders get ignored, or group size outgrows manual data entry. If people log expenses on time, this sheet is plenty.
Make a fresh copy today. Plug in your housemates and basic categories, then enter one real utility bill. Log a single settlement to confirm the balance math updates cleanly before backfilling old receipts.