Are shared apartment expenses piling up in messy text threads? Tracking rent, utilities, and grocery runs in a single Notion database keeps everyone honest without requiring another paid budgeting app. You only need one clean table and the right workspace permissions.
The biggest mistake roommates make is giving everyone full editing access to the database structure, which inevitably leads to deleted properties or broken rollups during a late-night grocery run update. Setting permissions to "Can edit content" solves this instantly. Roommates can add bills and mark IOUs as settled, but they cannot accidentally wipe out your column settings or status properties.
Essential Properties for a Shared Expense Table
| Property Name | Property Type | Why You Need It |
|---|---|---|
| Expense Name | Title | Identifies the charge, like "March Electric Bill" or "Paper Towels" |
| Amount | Number (Currency) | The total dollar cost paid to the vendor |
| Date | Date | The day the transaction occurred or bill arrived |
| Paid By | Person | Identifies which roommate covered the upfront charge |
| Split Type | Select | Equal Split, By Bedroom Size, or Custom Amount |
| Status | Status | Unpaid, Reimbursed, or Disputed |
| Receipt | Files & media | Photo proof of the paper receipt or utility invoice |
A status property keeps the board uncluttered. Once a roommate repays their share via bank transfer or cash, move the card from "Unpaid" to "Reimbursed." You can switch the database to a board view grouped by status, which pushes active balances to the front and tucks settled bills out of the way. For deeper customization, check Notion VIP's grouping guide to adjust sub-groups and hide empty categories.
If building this from scratch feels tedious, you can duplicate a community build like Notioneers' Sharing Bills & Expenses and adapt the properties to your apartment. It provides a solid starter layout.
Splitting Uneven Rent and Shared Utilities
Equal splits are easy, but apartments rarely work out to simple even numbers. One roommate might have the master bedroom with an ensuite bathroom, while another roommate works from home every day and uses twice as much electricity running window air conditioners through the summer.
Thing is, trying to cram complex splitting formulas into a single database row usually causes headaches. When you split a $150 internet bill between three people, recording one lump sum makes it impossible to show that one person paid back their $50 while another still owes theirs.
Create split lines instead. If the electric bill is $120 among three roommates, enter three distinct rows of $40 each, tagged to each person. It takes ten extra seconds to type. In exchange, each roommate gets an unambiguous row that marks their exact debt as settled without muddying someone else's record.
You can also use Notion Help Center on relations and rollups to connect a master "Bills" table to individual "Debts" rows if you want higher-level totals. Most apartments do not need that complexity. Separate rows work fine.
Step-by-Step: Locking Down Database Permissions
Sharing an entire workspace invites chaos. To invite roommates safely, follow the access models outlined in the Notion Help Center on sharing and permissions.
- Open the database page and click the "Share" button in the top right corner.
- Enter your roommate's email address in the invite field.
- Click the dropdown next to their name and select "Can edit content" instead of "Can edit."
- Send the invitation.
"Can edit content" allows them to add rows, change text, check boxes, and update amounts. They cannot rename properties, delete formula columns, or alter table views.
If you have a guest or subletter who only needs to verify a single utility payment, you can use page-level permissions instead. Open that bill's page and share it directly. The subletter views that single bill alone. Check the Notion Help Center on custom database permissions if you need granular permission rules on workspace plans.
Notion Databases vs Spreadsheets
Spreadsheets handle complex math and weighted splits better. Notion works best when your apartment prioritizes visual cards, attached receipt photos, and real-time collaboration without spreadsheet clutter.
House Rules to Prevent Money Disputes
Software cannot fix bad communication. Turns out, most friction comes from unstated assumptions. Agreeing on basic logging habits during move-in prevents arguments when rent comes due at the end of the month. Put a few simple house rules directly above the database:
- Upload the receipt: Every shared expense over $15 requires a photo or PDF receipt before reimbursement.
- Settle on Sundays: Review the board weekly and clear small IOUs via payment apps before balances accumulate.
- Note unusual usage: Roommates must flag temporary spikes, like visiting guests or AC usage, before splitting utility invoices.
Setting Up Your Tracker
Start small.
Create a blank database page today, add the core properties, and log last week's grocery bill as a test entry. Invite your roommates using "Can edit content" permissions, tag them on the test item, and make sure they can mark it reimbursed on their phones. Reset permissions or backup the database quarterly by making a quick duplicate. That simple routine keeps shared living stress-free.