Rent, groceries, the electric bill. None of it needs a paid subscription app. A basic Google Sheets workbook handles all three for free, and building the household ledger takes about fifteen minutes.
Why hand your personal transaction history to a third-party company when four simple spreadsheet formulas can track every dollar? You log shared expenses in one tab, mark who paid, and summary formulas tally the net balances on their own. When someone pays more than their share, the sheet shows exactly who owes what at the end of the month. Nobody has to guess.
The Shared Ledger Column Layout
Keep data entry dumb-simple. If recording a bottle of dish soap takes fifteen clicks, people quietly stop updating the sheet. Put every daily expense on a single tab named "Expenses" and freeze the top row so your headers stay visible as the list grows.
| Column | Header | What Goes Inside | Example Entry |
|---|---|---|---|
| A | Date | The day the bill was paid | 2026-06-01 |
| B | Description | What the payment covered | Electric bill |
| C | Category | Spending bucket for budgeting | Utilities |
| D | Total Amount | Total cost from the receipt | $140.00 |
| E | Paid By | Name of the person who paid | Alex |
| F | Split Method | How costs are divided | Equal |
| G | Alex Share | Dollar amount Alex is responsible for | $70.00 |
| H | Jordan Share | Dollar amount Jordan is responsible for | $70.00 |
| I | Receipt Link | Optional URL to a photo in Google Drive | drive.google.com/... |
Freezing row 1 is quick. Click View, hover over Freeze, and select 1 row. For receipt records, upload a photo of the receipt to Google Drive, then press Ctrl+K in the cell to paste the link straight onto the transaction. That cuts off most arguments over lost paper receipts. If you want to track payment methods alongside receipts too, see how tracking who paid what works with dedicated payment columns.
Core Formulas for Splits and Running Balances
Automation lives in two spots: the share columns and the monthly summary tab. Your formulas need to handle two jobs, dividing each row's cost and producing an overall balance card that shows net debts.
For an equal two-person split, columns G and H divide the total amount in column D by two. In cell G2, enter:
=IF(F2="Equal", D2/2, D2*0.5)
Living with three roommates instead of one changes only the divisor. Better yet, use =IF(F2="Equal", D2/3, 0) so the math stays predictable.
The real work happens on a separate tab called "Summary". Calculating who owes money takes two numbers per person: what they actually paid out of pocket, and what their total share of expenses came to. Put each housemate's name in column A. Column B sums everything that specific person paid using SUMIF:
=SUMIF(Expenses!$E$2:$E$100, A2, Expenses!$D$2:$D$100)
The formula checks column E on the expenses tab for the person's name, then adds up their payments from column D.
Column C sums their total owed share. If Jordan's shares sit in column H of the expenses tab, Jordan's summary cell uses:
=SUM(Expenses!$H$2:$H$100)
Net balance goes in column D:
=B2 - C2
A positive number means the group owes that person money. A negative number means that person owes the household. The math stays clear either way.
Income Ratios, Unequal Rooms, and Reimbursements
Equal splits don't work for every living arrangement. Say one partner earns $5,000 a month and the other earns $3,000, for a combined income of $8,000. The higher earner makes 62.5% of the total, the lower earner 37.5%. Multiply a $2,200 rent payment by each percentage and you get $1,375 and $825. Both people end up contributing the exact same proportion of their earnings toward housing.
Uneven bedrooms follow the same percentage logic. Someone with the master bedroom, the attached bath, and the walk-in closet might agree to cover 58% of the rent while the person in the smaller room takes 42%. Hardcode those percentages into the split formula, or add a dedicated ratio column right next to Split Method to keep things flexible.
To be honest, I usually leave a quick note in the description column whenever an unusual ratio applies, because six months later nobody ever remembers why that random Target receipt was split 70/30 instead of even, whether it was the specialized pet supplies for the older cat one partner had before moving in together or something else entirely. The note heads off a lot of awkward conversations.
One-off reimbursements need careful handling. When a roommate buys a shared couch on their personal card and everyone pays them back directly through cash or bank transfer, log the expense with a 100% split to the buyer. Never log the settlement transfers themselves as new expenses.
Protecting Formulas and Sharing Access
Handing out edit permissions with no protections invites broken formulas. Someone will backspace over a SUMIF while typing a grocery bill on their phone. Lock the calculations down before you share the link:
- Highlight your calculated columns, which means columns G and H on the expenses tab and the entire Summary tab.
- Open the menu, click Data, and select Protect sheets and ranges. This guide to protect sheets and ranges covers the detailed steps.
- Click Set permissions and choose "Only you" so housemates cannot overwrite the math.
- Click the green Share button in the top-right corner, enter your housemates' Google email addresses, and grant them "Editor" access.
One catch: range protection doesn't work in the Google Sheets mobile app. The mobile interface lacks the permissions tools. Configure everything in a desktop browser before you invite housemates.
House Rules and Mistakes That Break the Math
Even the cleanest spreadsheet fails if housemates ignore it for two months. A shared budget needs regular maintenance and clear house rules. Pick a recurring slot, like Sunday evening after dinner, and keep the review to ten minutes, just enough time to match receipts against entries, verify totals, and settle whatever balances are still open.
Four mistakes wreck the math more than anything else:
- Typing names inconsistently: If Alex shows up as "alex" or "Alex M", the standard SUMIF filters miss those rows. Dropdown validation in the Paid By column stops the spelling drift.
- Overwriting formula cells: A manual dollar amount typed straight into a calculated column erases the underlying math for every future row.
- Ignoring offline sync delays: Logging purchases on a phone with spotty connectivity works, but reopen the app on Wi-Fi later and confirm the updates actually synced.
- Double-counting settle-up transfers: Jordan sends $100 via bank transfer to square up, that transfer lands on the expense tab, and now the whole ledger is skewed. Record settle-ups in a separate log, or simply adjust the running balance.
That dropdown takes thirty seconds to build. Highlight the Paid By column, click Data, select Data validation, and choose "Dropdown" with your housemates' exact names. It stops typos before they start.
Spreadsheets Versus Third-Party Apps
Dedicated bill-splitting apps are convenient, and convenience has a price tag. Plenty of apps now charge up to $36 a year just to remove ads, cap daily entries on free tiers, and store your personal financial transactions on private servers. A spreadsheet gives you total ownership of the data. Export your records to CSV anytime, adjust custom room-size percentages on the fly, and build historical charts without paying a dime.
Turns out, tax rules also favor simple recordkeeping. Under IRS guidance on Form 1099-K, personal reimbursements between roommates for rent, internet, or groceries are not considered taxable business income. A clean spreadsheet ledger with linked receipts provides immediate proof of shared household expenses if a payment platform ever flags an influx of roommate transfers.
Apps still fit some groups. High turnover changes the calculus, so a weekend bachelor party or a rotating ski cabin can benefit from an app with instant phone scanning. For a stable home, the spreadsheet wins. Open a blank workbook today, paste in the column headers, and test the formulas against last week's grocery receipt.