Why split paper towels right down the middle when one roommate earns double?
Even splits look fair on paper, but they quietly build resentment. Proportional splitting fixes that dynamic. Each person pays according to their share of total household income.
The math stays remarkably simple. Say Person A brings home $3,000 every month and Person B brings home $2,000, creating a combined pool of $5,000. Person A pays 60 percent of shared supplies. Person B covers 40 percent. If a quick trip for trash bags and dish soap totals $50, A pays $30 while B chips in $20. You can build this in a spreadsheet in ten minutes.
Deciding What to Split by Budget Share
Keep personal groceries separate. Shared supplies only include items everyone burns through together, like paper towels, toilet paper, trash bags, dish soap, sponges, laundry detergent, and communal condiments. Protein powder, specialized skincare, snacks, and individual meals stay on individual tabs.
Thing is, proportional math only matters when incomes clearly diverge. A 20 percent gap is a sensible floor. Two roommates making $4,100 and $3,900 have a $200 spread. Splitting pennies over that gap creates pointless friction. Fifty-fifty works fine there. Widen the gap, though, and proportional splitting keeps the lower earner from burning out.
| Split Method | How Costs Are Divided | Best Used For | Tradeoff |
|---|---|---|---|
| Equal Split | 50/50 or divided evenly per head | Similar incomes, low-cost essentials | Strains lower earners when incomes diverge |
| Proportional (Budget Share) | Scaled to each person's take-home pay | Incomes differing by 20% or more | Requires sharing income numbers openly |
| Usage-Based | Paid based on individual consumption | High-use items or uneven grocery habits | Tedious to track item by item |
Choose whatever split matches your living situation best.
Setting Up the Google Sheets Calculator
No paid software is required. A shared Google Sheet gives both people instant visibility.
Start with a dedicated income block. As JakeLee's method for proportional bill splitting shows, dedicating specific cells to net income keeps the math clean and easy to adjust.
Put Person 1's net monthly income in cell B1 ($3,000). Put Person 2's income in cell B2 ($2,000). In cell B3, sum both incomes with =SUM(B1:B2). Next, give Person 1 their percentage in cell C1 with =B1/$B$3. Put =B2/$B$3 in cell C2 for Person 2.
Format cells C1 and C2 as percentages. The sheet will show 60% and 40%. Avoid multiplying by 100 manually if you tap the percentage format icon. If you do both, Sheets converts 0.60 into 6000%.
When double-checking formulas, Google Sheets formula guidance notes that pressing F2 toggles range selection so you can inspect referenced cells directly. It saves time.
Below your income block, set up your supply ledger with seven standard columns: Date, Item, Total Cost, Paid By, Person 1 Share, Person 2 Share, and Settled.
Enter =C7*$C$1 in the Person 1 Share column for row 7. In the Person 2 Share column, enter =C7*$C$2. Drag both down the sheet. The dollar signs pin your percentage cell in place as costs move down each row. For an extra safeguard, add a data validation rule using =SUM(E7:F7)=C7 to catch split errors immediately.
Logging Expenses and Settling Reimbursements
Whoever grabs the supplies fronts the cash at the register. Because of that, your sheet needs an actual reimbursement flow instead of just displaying theoretical splits. Expense templates featured by ExpenseSorted use running balances for this exact reason, sparing housemates from sending tiny cash transfers every other day.
Logging receipts right away stops missing expenses from piling up. Use this four-step routine:
- The buyer enters the date, store, item name, and total cost the day of the run.
- The sheet automatically calculates each person's dollar share using the income ratios.
- The buyer uploads a receipt photo to a shared folder or drops a link in the row.
- At month-end or during a weekly check-in, the non-buyer sends their balance and marks the Settled box.
Net your balances before sending money. Suppose Person 1 buys a $90 bulk supply pack at Costco, while Person 2 buys a $30 box of trash bags earlier that week. Never make two separate transactions. Person 2 owes Person 1 $36 (40% of $90). Person 1 owes Person 2 $18 (60% of $30). Settle the net difference. Person 2 simply sends Person 1 $18.
Managing Variable Incomes and Weekly Habits
Paychecks fluctuate. Freelancers, contractors, and hourly staff rarely take home identical amounts from month to month.
To be honest, updating your ratios every single Friday will make both of you want to abandon the whole system entirely (nobody wants to debate a twelve-dollar paycheck swing while unloading groceries), so sticking to a three-month rolling average or reviewing numbers once a quarter keeps the math sane without ignoring real earnings changes. Stability beats micro-adjustments every time.
Set a weekly ten-minute check-in. Sunday evening works nicely for most households. Sit down together, open the spreadsheet, clear up any odd receipt items, and total whatever is currently unpaid.
Version tracking heads off quiet misunderstandings. Under File, click Version history to see who edited specific cells and when. Budgeting writeups by AddToSheets highlight this feature for partners who want clear visibility without backseat policing.
Pitfalls That Break Budget-Share Agreements
A good system falls apart quickly when ground rules get sloppy. Watch out for these three common traps:
- Sneaking personal items onto shared receipts. If someone grabs paper towels, dish soap, and a $25 bag of fancy coffee beans, keep the beans out of the tracker. Circle shared items and enter only that subtotal.
- Basing splits on gross salary. An $85,000 gross salary looks huge on paper. Yet taxes, health insurance, and mandatory retirement deductions shrink the actual deposit. Always use net take-home pay.
- Letting unpaid tabs drag out. Letting a roommate float $200 across two months breeds quiet resentment. Pick a hard monthly deadline where all ledger balances drop to zero.
Frequently Asked Questions
What if a roommate refuses to share their exact income?
Never force proportional budgeting on someone who values financial privacy. If a roommate does not want to disclose their paycheck, stay with an even 50/50 split on communal essentials, or rotate who buys supplies each round. Proportional sharing requires mutual, voluntary transparency.
How should we split sales tax and delivery fees?
Apply your standard split percentage to the full checkout total. If Person A covers 60 percent of the items, they also pay 60 percent of the delivery fee, sales tax, and driver tip. Splitting fees separately over pennies is a waste of time.
What happens if one person travels for a month?
Nobody consumes paper towels or dish soap while they are out of town. If someone travels for several weeks, pause their share of daily consumables for that period. Fixed commitments like rent remain unchanged. Consumable supply runs should only reflect active residents.
Putting the Tracker to Work
Start small instead of overhauling your entire household system tonight. Open a fresh sheet with two income numbers and last week's receipt for cleaning supplies. Test the formulas together. Once both of you understand the math, pick a recurring day to clear your balances.